Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Executive Fruits financial manager believes that sales in 2015 could rise by as much as 20% or by as little as 5%. Assets and costs

Executive Fruits 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 $ $

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

CFIN

Authors: Scott Besley, Eugene Brigham

5th edition

1305661656, 9781305888036 , 978-1305666870

More Books

Students also viewed these Finance questions

Question

what's apple's brand loyalty in the smartphone market?

Answered: 1 week ago

Question

hoW doeS the CLoud Work? Appendix

Answered: 1 week ago

Question

wHat are Content ManageMent SySteMS? Appendix

Answered: 1 week ago