Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Balance Sheet 2014 2015 2016 Assets Cash $9,000 $7,282 $14,000 Short-term investments 48,000 20,000 71,632 Accounts receivable 351,200 632,160 878,000 Inventories 751,200 1,287,360 1,716,480 Total

Balance Sheet

2014

2015

2016

Assets

Cash

$9,000

$7,282

$14,000

Short-term investments

48,000

20,000

71,632

Accounts receivable

351,200

632,160

878,000

Inventories

751,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

$39,790

$36,840

Total assets

$1,468,800

$2,886,592

$,516,952

2011

2012

2013

Liabilities & Equity

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,800

460,000

1,680,936

Retained earnings

203,768

97,632

296,216

Total equity

$663,768

$557,632

$1,977,152

Total liabilities & Equity

$1,468,800

$2,886,592

$3,516,952

Note: E denotes, estimated ; the 2013 data for forecasts.

Income Statement

2014

2015

2016

Sales

$3,432,000

$5,834,400

$7,035,600

Cost of goods sold

2,864,000

4,980,000

5,800,000

Other expenses

340,000

720,000

612,960

Depreciation & Amortization

18,900

116,960

120,000

Total operating Cost

$3,222,900

$5,816,960

$6,532,962

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

Stock price

$8.50

$6.00

$12.17

Shares outstanding

100,000

100,000

250,000

2011

2012

2013E

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 payment

$40,000

$40,000

$40,000

Note: E denotes estimated ; the 2013 data are forecasts.

Ratio Analysis

2014

2015

2016E

Industry Average

Current

2.3

1.5

------------------

2.7

Quick

0.8

0.5

------------------

1.0

Inventory turnover

4.8

4.5

------------------

6.1

Days sales outstanding

37.3

39.6

------------------

32.0

Fixed assets turnover

10.0

6.2

-----------------

7.0

Total assets turnover

2.3

2.0

---------------

2.5

Debt ratio

54.8%

80.7%

--------------

50.0%

TIE

3.3

0.1

--------------

6.2

EBITDA Coverage

2.6

0.8

--------------

8.0

Profit margin

2.6%

-1.6%

--------------

3.6%

Basic earning power

14.2%

0.6%

--------------

17.8%

ROA

6.0%

-3.3%

--------------

9.0%

ROE

13.3%

-17.1%

--------------

17.9%

Price / Earnings (P/E)

9.7

-6.3

--------------

16.2

Price / Cash flow

8.0

27.5

-------------

7.6

Market / Book

1.3

1.1

-------------

2.9

Use the extended DuPont equation to provide a summary and overview of Computrons finan- cial condition as projected for 2016. 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

Basic Finance An Introduction To Financial Institutions, Investments, And Management

Authors: Herbert B. Mayo

12th Edition

1337691011, 978-1337691017

More Books

Students also viewed these Finance questions

Question

How does a brands portfolio management impact on IMC strategy?

Answered: 1 week ago

Question

How would you define brand attitude?

Answered: 1 week ago