For the Pro Forma Income Statement model in the Excel file Net Income Models (Figure 11.7), add a scroll bar form control to allow the user to easily change the level of sales from 3,000,000 to 10,000,000 in increments of 1,000 and recalculate the spreadsheet. (The scroll values must be between 0 and 30,000 so you will need to modify the spreadsheet to make it work correctly.)

Figure 11.7

Transcribed Image Text:

A B D. 1 Pro Forma Income Staternent 2 3 Sales $ 5,000,000 S(3,200,000) $ 1,800,000 -C3+C4 4 Cost of Goods Sold Gross Profit 6 7 Operating Expenses Administrative Expenses $250,000 Selling Expenses $450,000 Depreciation Expenses $325,000 Total 8 9 10 11 S(1,025,000) =-(SUM(B8:B10)) 12 $ 775,000 C5+11 $ (35,000) 13 Net Operating Income 14 Interest Expense 15 16 Earnings Before Taxes 17 $ 740,000 C13+C14 $ (296,000) Тахes 18 19 Net Income $ 444,000 C16+C17