Executive Fruit’s financial manager believes that sales in 2015 could rise by as
ID: 2767808 • Letter: E
Question
Executive Fruit’s financial manager believes that sales in 2015 could rise by as much as 20% or by as little as 5%. Assets and costs change in proportion to sales, debt remains constant, and no new equity financing occurs. a. Recalculate the first-stage pro forma financial statements under these two growth assumptions and calculate the required external financing (All figures are in thousands). (Enter your answers in thousands.) Base Case 20% Growth 5% Growth INCOME STATEMENT Revenue $ 10,000 $ $ Cost of goods sold 9,000 EBIT $ 1,000 $ $ Interest 200 Earnings before taxes $ 800 $ $ State and federal tax 320 Net income $ 480 $ $ Dividends 320 Retained earnings $ 160 $ $ BALANCE SHEET Assets Net working capital $ 1,000 $ $ Fixed assets 4,000 Total assets $ 5,000 $ $ Liabilities and shareholders' equity Long-term debt $ 2,000 $ $ Shareholders' equity 3,000 Total liabilities and shareholders' equity $ 5,000 $ $ Required external financing $ $ b. Assume any required external funds will be raised by issuing long-term debt and that any surplus funds will be used to retire such debt. Prepare the completed (second-stage) pro forma balance sheet. (Enter your answers in thousands.) BALANCE SHEET Base Case 20% Growth 5% Growth Assets Net working capital $ 1,000 $ $ Fixed assets 4,000 Total assets $ 5,000 $ $ Liabilities and shareholders' equity Long-term debt $ 2,000 $ $ Shareholders' equity 3,000 Total liabilities and shareholders' equity $ 5,000 $
Explanation / Answer
Solution:
Notes
a. Shareholders' equity increases by earnings retained in 2015.
b. Required external financing = increase in net assets - retained earnings
c. Long-term debt, the balancing item, increases by required external financing
a. 20% 5% Income Statement 2015 Growth Growth Revenue $10,000 $12,000 $10,500 Cost of goods sold 9,000 10,800 9,450 EBIT 1,000 1,200 1,050 Interest expense 200 40 40 Earnings before taxes 800 1,160 1,010 State & federal tax 320 400 340 Net Income $480 $760 $670 Dividends 320 400 340 Add. To Retained Earnings $160 $360 $330 Balance Sheet 20% 5% Assets 2015 Growth Growth Net working capital $1,000 $1,200 $1,050 Fixed Assets 4,000 4,800 4,200 Net Assets $5,000 $6,000 $5,250 Liabilities & shareholders' equity Long-term debt 2,000 400 400 Shareholders' equity 3,000 3,160 3,160 Total liabilities & sh. equity $5,000 $3,560 $3,560 Required external financing 2,440 1,690 b. Second Stage Pro Forma 20% 5% Balance Sheet 2015 Growth Growth Assets Net working capital $1,000 $1,200 $1,050 Fixed Assets 4,000 4,800 4,200 Net Assets $5,000 $6,000 $5,250 Liabilities & shareholders' equity Long-term debt $2,000 $2,840 $2,090 Shareholders' equity 3,000 3,160 3,160 Total liabilities & sh. equity $5,000 $6,000 $5,250Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.