Pro Forma Analysis
Not what you're looking for?
INCOME STATEMENT:
Sales 2000,000
Costs except depreciation (100,000)
--------------------------------------------------
EBITA 100,000
Depreciation (6,000)
--------------------------------------------------
EBIT 94,000
Inter Expense (net) (400)
---------------------------------------------------
Pretax income 93,600
Income Tax (32,760)
----------------------------------------------------
Net Income 60,840
BALANCE SHEET:
Assets
Cash and equivalents 15,000
Accounts Receivable 2,000
Inventories 4,000
_______________________________
Total Current Assets 21,000
Property, plant and equipment 10,000
________________________________
Total Assets 31,000
Liabilities and Equity
Accounts Payable 1,500
Debt 4000
_______________________________
Total liabilities 5,500
Stockholders' Equity 25,500
Total Liabilities and Equity 31,000
(ANSWER THE QUESTIONS BELOW USING EXCEL)
(USE THE DATA FROM ABOVE)
1) Jim's expects sales to grow by 10%. Using the Percent of sales method forecast.
a. costs
b. Depreciation
c. Net Income
d. Cash
e. Accounts receivable
f. inventory
g. Property, plant and equipment
2) Assume that Jim's pays out 90% of its net income. Use the percent of sales method to forecast:
a. Stockholder's equity
b. Accounts Payable
3) What is the amount of net new financing needed for Jim's?
Purchase this Solution
Solution Summary
Solution helps in preparing Pro Forma Analysis
Solution Preview
NCOME STATEMENT:
Sales 2000,000
Costs except depreciation (100,000)
--------------------------------------------------
EBITA 100,000
Depreciation (6,000)
--------------------------------------------------
EBIT 94,000
Inter Expense (net) (400)
---------------------------------------------------
Pretax ...
Purchase this Solution
Free BrainMass Quizzes
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.