The Optical Scam Company has forecast a sales growth of 20 percent for next year. The...

Transcribed Image Text:

The Optical Scam Company has forecast a sales growth of 20 percent for next year. The current financial statements are shown here: Income Statement $ Sales Costs 31,800,000 27,003,300 Taxable income Taxes Net income $ 4,796,700 1,678,845 $3,117,855 Dividends $ 1,247,142 Addition to retained 1,870,713 earnings Balance Sheet Assets Equity Current assets $ 7,340,000 Accounts payable Long-term debt Liabilities and Owners' $ 5,088,000 2,345,250 Fixed assets 19,372,000 Common stock Accumulated retained earnings Total equity $ 5,924,750 13,354,000 $ 19,278,750 Total assots $26712000 Total liabilities and equity $ 26.712.000 Total equity $ 19,278,750 Total assets $ 26,712,000 Total liabilities and equity $ 26,712,000 Please show how you work on the following questions in the excel file. (15 points) (1) Please construct your pro forma income statement and balance sheet. (2) Show how you calculate EFN with Pro Forma statements. (3) Show how you verify EFN with the formula. a. Using the equation from the chapter, calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Current assets Fixed assets Balance Sheet Assets Liabilities and equity Accounts payable Long-term debt Common stock Accumulated retained earnings Current assets Fixed assets Assets Balance Sheet Accounts payable Long-term debt Liabilities and equity Common stock Accumulated retained earnings Total equity Total assets Total liabilities and equity b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed c. Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) The Optical Scam Company has forecast a sales growth of 20 percent for next year. The current financial statements are shown here: Income Statement $ Sales Costs 31,800,000 27,003,300 Taxable income Taxes Net income $ 4,796,700 1,678,845 $3,117,855 Dividends $ 1,247,142 Addition to retained 1,870,713 earnings Balance Sheet Assets Equity Current assets $ 7,340,000 Accounts payable Long-term debt Liabilities and Owners' $ 5,088,000 2,345,250 Fixed assets 19,372,000 Common stock Accumulated retained earnings Total equity $ 5,924,750 13,354,000 $ 19,278,750 Total assots $26712000 Total liabilities and equity $ 26.712.000 Total equity $ 19,278,750 Total assets $ 26,712,000 Total liabilities and equity $ 26,712,000 Please show how you work on the following questions in the excel file. (15 points) (1) Please construct your pro forma income statement and balance sheet. (2) Show how you calculate EFN with Pro Forma statements. (3) Show how you verify EFN with the formula. a. Using the equation from the chapter, calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed b- Construct the firm's pro forma balance sheet for next year. (Do not round 1. intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Current assets Fixed assets Balance Sheet Assets Liabilities and equity Accounts payable Long-term debt Common stock Accumulated retained earnings Current assets Fixed assets Assets Balance Sheet Accounts payable Long-term debt Liabilities and equity Common stock Accumulated retained earnings Total equity Total assets Total liabilities and equity b-2. Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed c. Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)