Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Optical Scam Company has forecast a sales growth of 20 percent for next year. The current financial statements are shown here: Income Statement

imageimage

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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe

10th edition

978-0077511388, 78034779, 9780077511340, 77511387, 9780078034770, 77511344, 978-0077861759

More Books

Students also viewed these Finance questions

Question

Why are acceptance criteria important in a software project?

Answered: 1 week ago

Question

8. What kinds of people are most likely to develop sleep apnea?

Answered: 1 week ago