Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The latest income statement, balance sheet and other related information for Prado Company is as follows: Net Sales Revenue = $1,500,000 COGS = $1,050,000 Operating

The latest income statement, balance sheet and other related information for Prado Company is as follows:

Net Sales Revenue = $1,500,000

COGS = $1,050,000

Operating Expenses = $225,000

Interest Expense = $22,000

Tax Expense = $40,600

Addition to Retained Earnings = $105,560

Current Assets = $900,000

Net Fixed Assets = $1,350,000

Current Liabilities = $450,000

Long Term Debt = $220,000

Common Stock = $580,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) 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

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

Students also viewed these Accounting questions

Question

4. What are the current trends in computer software platforms?

Answered: 1 week ago