Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Industrial Supply Company example (Table 4.4) it was assumed that the companys fixed assets were being used at nearly full capacity and that

In the Industrial Supply Company example (Table 4.4) it was assumed that the companys fixed assets were being used at nearly full capacity and that net fixed assets would have to increase proportionately as sales increased. Alternatively, suppose that the company has excess fixed assets and that no increase in net fixed assets is required as sales are increased. Assume that the company plans to maintain its divi- dend payments at the same level in 2014 as in 2013. Determine the amount of addi- tional financing needed for 2014 under each of the following conditions:

Increase In Sales Increase In Expenses
a. 3,750,000 3,750,000
b. 3,000,000 2,800,000
c. 4,500,000 4,000,000

Table 4.4

Industrial Supply Financial Statements

Balance Sheet

Actual

December 31, 2013

Pro Forma

December 31, 2013

Comments

Assets

Cash

500,000

625,000

25% Increase (assumption)

Accounts Rec.

2,000,000

2,500,000

25% Increase (assumption)

Inventories

4,000,000

5,000,000

25% Increase (assumption)

Total Current Assets

6,500,000

8,125,000

Fixed Assets, net

1,000,000

1,250,000

Total Assets (A)

7,500,000

9,375,000

25% Increase (assumption)

Liabilities and Equities

Accounts Payable (CL)

1,500,000

1,875,000

25% Increase (assumption)

Notes Payable

1,000,000

1,750,000

1,000,000 + AFN =

1,000,000 + 750,000

Total Current liabilities

2,500,000

3,625,000

Long-term Debt

500,000

500,000

No change (assumption)

Income Statement

2013

2014

Sales (S)

15,000,000

18,750.000

25% Increase (assumption)

Expenses, including interests & taxes

14,250,000

17,750,000

Forecasted

Earnings after taxes (EAT)

750,000

1,000,000

Dividends paid (D)

250,000

250,000

No change (assumption)

Retained earnings

5000,000

750,000

Selected Financial Ratios

Current Ratio

2.60 times

2.24 Times

Decreased

Debt Ratio

40%

44%

Increased

Return on stockholders equity

16.7%

19.0%

Increased

Net Profit margin on sales

5.0%

5.33%

Increased

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

The Handbook Of Post Crisis Financial Modelling

Authors: Emmanuel Haven, Philip Molyneux, John Wilson, Sergei Fedotov, Meryem Duygun

1st Edition

1137494484, 978-1137494481

More Books

Students also viewed these Finance questions

Question

Describe how the regression line is mathematically determined

Answered: 1 week ago