Question
The latest income statement, balance sheet and other related information for Prado Company is as follows: Net Sales Revenue = $1,200,000 COGS = $840,000 Operating
The latest income statement, balance sheet and other related information for Prado Company is as follows:
Net Sales Revenue = $1,200,000
COGS = $840,000
Operating Expenses = $120,000
Interest Expense = $22,000
Tax Expense = $43,600
Addition to Retained Earnings = $104,640
Current Assets = $900,000
Net Fixed Assets = $1,080,000
Current Liabilities = $240,000
Long Term Debt = $220,000
Common Stock = $520,000
Retained Earnings = $1,000,000
1. Given the existing information, the Sustainable Growth Rate is (please round to the nearest integer percentage such as 5) %
From now on, please assume that the company's sales will grow at 8% for the following year. Estimate the following regarding the proforma statements.
2. The proforma EBIT is $
3. The initial proforma Interest Expense estimation (beginning of first iteration, remember Butler Lumber) is $
4. Assuming the same tax rate, the proforma net income is $
5. Assuming the same plowback ratio, the proforma addition to retained earnings is $
6. Assuming 100% capacity usage, the proforma TOTAL assets are $
7. The proforma current liabilities are $
8. The proforma retained earnings are $
9. The External Financing Need is $
10. Assuming the EFN will be fulfilled by increasing the LTD, the proforma LTD (to balance the balance sheet) is $
11. With the updated LTD you just calculated, assuming a 10% interest rate, the corrected interest expense (end of first iteration) is $
12. If the current capacity usage is at 80%, then the proforma net fixed assets are $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started