Financial Forecasting Exercise

This exercise illustrates Financial Forecasting using the "Percentage of Sales" approach. Click the "New Problem" button to generate a new problem. Then express the balance sheet and income statement accounts as a percentage of sales. Next, construct "Partial Pro-Forma" financial statements and determine the External Financing Needed to meet the forecasted growth rate in sales. Complete the exercise by using the specified "Plug" to construct the "Pro-Forma" financial statements. After attempting each of the calculations you can click the buttons to view the solutions. The worksheet also functions as a calculator. You can enter your own data into the fields and then click the buttons to view the solutions.