Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A computer manufacturer has financial statements as follows: Balance Sheets Assets 2015 2016 2017 Estimated Cash $ 9,000 $ 7,282 $ 14,000 Short-Term Investments. 48,600

A computer manufacturer has financial statements as follows:

Balance Sheets

Assets

2015

2016

2017 Estimated

Cash

$ 9,000

$ 7,282

$ 14,000

Short-Term Investments.

48,600

20,000

71,632

Accounts Receivable

351,200

632,160

878,000

Inventories

715,200

1,287,360

1,716,480

Total Current Assets

$ 1,124,000

$ 1,946,802

$ 2,680,112

Gross Fixed Assets

491,000

1,202,950

1,220,000

Less: Accumulated Depreciation

146,200

263,160

383,160

Net Fixed Assets

$ 344,800

$ 939,790

$ 836,840

Total Assets

$ 1,468,800

$ 2,886,592

$ 3,516,952

Liabilities And Equity

2015

2016

2017 Estimated

Accounts Payable

$ 145,600

$ 324,000

$ 359,800

Notes Payable

200,000

720,000

300,000

Accruals

136,000

284,960

380,000

Total Current Liabilities

$ 481,600

$ 1,328,960

$ 1,039,800

Long-Term Debt

323,432

1,000,000

500,000

Common Stock (100,000 Shares)

460,000

460,000

1,680,936

Retained Earnings

203,768

97,632

296,216

Total Equity

$ 663,768

$ 557,632

$ 1,977,152

Total Liabilities And Equity

$ 1,468,800

$ 2,886,592

$ 3,516,952

Income Statements

2015

2016

2017E

Sales

$ 3,432,000

$ 5,834,400

$ 7,035,600

COGS except depr.

2,864,000

4,980,000

5,800,000

Depreciation

18,900

116,960

120,000

Other Expenses

340,000

720,000

612,960

Total Operating Costs

$ 3,222,900

$ 5,816,960

$ 6,532,960

EBIT

$ 209,100

$ 17,440

$ 502,640

Interest Expense

62,500

176,000

80,000

EBT

$ 146,600

$ (158,560)

$ 422,640

Taxes (40%)

58,640

(63,424)

169,056

Net Income

$ 87,960

$ (95,136)

$ 253,584

Other Data

2015

2016

2017E

Stock Price

$ 8.50

$ 6.00

$ 12.17

Shares Outstanding

100,000

100,000

250,000

EPS

$ 0.880

$ (0.951)

$ 1.014

DPS

$ 0.220

$ 0.110

$ 0.220

Tax Rate

40%

40%

40%

Book Value Per Share

$ 6.638

$ 5.576

$ 7.909

Lease Payments

$ 40,000

$ 40,000

$ 40,000

Statement of Cash Flows

2016

Operating activities

Net income

$ (95,136)

Adjustments:

noncash adjustments:

depreciation

116,960

changes in working capital:

change in accounts receivable

(280,960)

change in inventories

(572,160)

change in accounts payable

178,400

change in accruals

148,960

Net cash provided by operating activities

$ (503,936)

Investing activities

Cash used to acquire fixed assets

$ (711,950)

Cash due to change in short term investments

$ 28,600

Net cash provided by operating activities

$ (683,350)

Financing activities

change in notes payable

$ 520,000

change in long-term debt

$ 676,568

change in common stock

$ -

payment of cash dividends

$ (11,000)

Net cash provided by financing activities

$ 1,185,568

Summary

Net change in cash

$ (1,718)

Cash at beginning of year

9,000

Cash at end of year

$ 7,282

-Why are ratios useful? What three groups use ratio analysis and for what reasons?

-Refer to the above companys financial statements. Calculate the 2017 current and quick ratios based on the projected balance sheet and income statement data.

-Calculate the 2017 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover.

-Calculate the 2017 profit margin, basic earning power (BEP), return on assets (ROA), and return on equity (ROE).

-Use the extended DuPont equation to provide a summary and overview of the companys financial condition as projected for 2017. What are the firms major strengths and weaknesses?

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 Management Of Health Care Organizations

Authors: William N. Zelman, Michael J. McCue, Noah D. Glick, Marci S. Thomas

5th Edition

1119553849, 9781119553847

More Books

Students also viewed these Finance questions