Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following financial statements for Industrial Supply Company. (Actual) December 31, Balance sheet Year 1 Comments Assets Cash $ 300,000 15% increase ( assumption

Consider the following financial statements for Industrial Supply Company.

(Actual)
December 31,
Balance sheet Year 1 Comments
Assets
Cash $ 300,000 15% increase (assumption)
Accounts receivable 1,800,000 15% increase (assumption)
Inventories 4,000,000 15% increase (assumption)
Total current assets $ 6,100,000
Fixed assets, net $ 1,400,000 15% increase (assumption)
Total assets (A) $ 7,500,000
Liabilities and Equity
Accounts payable (CL) $ 1,200,000 15% increase (assumption)
Notes payable 1,300,000
Total current liabilities $ 2,500,000
Long-term debt 500,000 No change (assumption)
Stockholders equity 4,500,000
Total liabilities and equity $ 7,500,000
Income Statement Year 1
Sales (S) $15,000,000 15% increase (forecasted)
Expenses, including interest & taxes 14,000,000
Earnings after taxes (EAT) $ 1,000,000
Dividends paid (D) 250,000 No change (assumption)
Retained earnings $ 750,000
Selected Financial Ratios
Current ratio 2.44 times
Debt ratio 40.00%
Return on stockholders equity 22.22%
Net profit margin on sales 6.67%

Determine the amount of additional financing needed and pro forma financial statements (that is, balance sheet, income statement, and selected financial ratios) for Year 2 under the following conditions:

Increase in Sales Increase in Expenses
$2,250,000 $2,100,000

Assume the following:

The company plans to maintain its dividend payments and long-term debt at the same level in Year 2 as in Year 1.

All of the additional financing needed is in the form of short-term notes payable.

Levels of cash, accounts receivable, inventories, net fixed assets and accounts payable increase proportionately as sales increase.

Round your answers in dollar form to the nearest dollar. Round your answers for financial ratios to two decimal places.

Additional Financing Needed: $

(Actual) (Pro forma)
December 31, December 31,
Balance sheet Year 1 Year 2
Assets
Cash $ 300,000 $
Accounts receivable 1,800,000
Inventories 4,000,000
Total current assets $ 6,100,000 $
Fixed assets, net $ 1,400,000 $
Total assets (A) $ 7,500,000 $
Liabilities and Equity
Accounts payable (CL) $ 1,200,000 $
Notes payable 1,300,000
Total current liabilities $ 2,500,000 $
Long-term debt 500,000
Stockholders equity 4,500,000
Total liabilities and equity $ 7,500,000 $
Income Statement Year 1 Year 2
Sales (S) $15,000,000 $
Expenses, including interest & taxes 14,000,000
Earnings after taxes (EAT) $ 1,000,000 $
Dividends paid (D) 250,000
Retained earnings $ 750,000 $
Selected Financial Ratios
Current ratio 2.44 times times
Debt ratio 40.00% %
Return on stockholders equity 22.22% %
Net profit margin on sales 6.67% %

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

Financial Economics

Authors: Zvi Bodie, Robert C Merton, David Cleeton

2nd Edition

0558785751, 9780558785758

More Books

Students also viewed these Finance questions

Question

What are the principle advantages of a Subchapter S election?

Answered: 1 week ago

Question

Establish each identity. cos 0 cos(360) sin(30) sin 0 tan(20)

Answered: 1 week ago