Income statement and balance sheets

Assignment Help Financial Accounting
Reference no: EM13853300

Use the following information for Questions 1 through 4:

Assume that you recently graduated and have just reported to work as an investment advisor at the one of the firms on Wall Street. You have been presented and asked to review the following Income Statement and Balance Sheets of one of the firm's clients. Your boss has developed the following set of questions you must answer.

Income Statements and Balance Sheet

Balance Sheet

2012

2013

2014

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

 

 

 

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

2012

2013

2014

Sales

$3,432,000

$5,834,400

$7,035,600

Cost of goods sold except depr.

2,864,000

4,980,000

5,800,000

Depreciation and amortization

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

2012

2013

2014

Stock price

$8.50

$6.00

$12.17

Shares outstanding

100,000

100,000

250,000

EPS

$0.88

($0.95)

$1.104

DPS

$0.22

0.11

0.22

Tax rate

40%

40%

40%

Book value per share

$6.64

$5.58

$7.909

Lease payments

$40,000

$40,000

$40,000

Ratio Analysis

2012

2013

Industry Average

Current

2.3

1.5

2.7

Quick

0.8

0.5

1.0

Inventory turnover

4

4

6.1

Days sales outstanding

37.3

39.6

32.0

Fixed assets turnover

10

6.2

7.0

Total assets turnover

2.3

2

2.5

Debt ratio

35.60%

59.60%

32.0%

Liabilities-to-assets ratio

54.80%

80.70%

50.0%

TIE

3.3

0.1

6.2

EBITDA coverage

2.6

0.8

8.0

Profit margin

2.60%

-1.6%

3.6%

Basic earning power

14.20%

0.60%

17.8%

ROA

6.00%

-3.3%

9.0%

ROE

13.30%

-17.1%

17.9%

Price/Earnings (P/E)

9.7

-6.3

16.2

Price/Cash flow

8

27.5

7.6

Market/Book

1.3

1.1

2.9

1. What is the free cash flow for 2014?

2. Suppose Congress changed the tax laws so that Berndt's depreciation expenses doubled. No changes in operations occurred. What would happen to reported profit and to net cash flow?

3. Calculate the 2014 current and quick ratios based on the projected balance sheet and income statement data. What can you say about the company's liquidity position in 2013?

4. Use the extended DuPont equation to provide a summary and overview of company's financial condition as projected for 2014. What are the firm's major strengths and weaknesses?

Reference no: EM13853300

Questions Cloud

Use of the rti model for identification of students : For this assignment, write a paper in which you summarize your understanding of the use of the RTI Model for identification of students with characteristics common to emotional and behavioral disorders and subsequent determination of services
Definitions of monetary and fiscal policy : Definitions of monetary and fiscal policy - roles of monetary and fiscal policy in an economy
Develop a sociological argument : Normal 0 false false false EN-US X-NONE X-NONE Develop a sociological argume..
Write a paper on autonomy : Write a paper on given topic- Topic is Autonomy. Short papers should use double spacing, 12-point Times New Roman font, and one-inch margins
Income statement and balance sheets : Assume that you recently graduated and have just reported to work as an investment advisor at the one of the firms on Wall Street. You have been presented and asked to review the following Income Statement and Balance Sheets of one of the firm's c..
Calculate the market test analysis : Financial Statement Analysis - Please calculate the Market Test Analysis and show work with the formulas
Different types of government intervention in health care : What lessons can we infer from history around the efforts to enact National Health Insurance and/or Health Reform? What are the economic rationales for different types of government intervention in health care?
Asset management ratios : In light of Yahoo! Account, Apple, Inc. together with Blackberry, Google, and Hewlett-Packard has a place with the Electronic Equipment industry. Industry information was sourced from Yahoo's industry focus. Just an industry's couples of measu..
Write a literature review in the form of an article : You need to write up and submit the literature review in the form of an article for the (fictitious) Australian Information Journal.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Component of the equity section of the balance sheet

What else is a component of the Equity Section of the Balance Sheet? Please explain to the class how the retained earning comes about. You are correct. It is not contributed. How is Treasury Stock shown?

  What is meant by the term substance over form

Petunia Ltd purchased 75% of the shares of Lavender Ltd for a cash payment a number of years ago, when the retained earnings of Lavender Ltd were €200,000, and the share capital of Lavender Ltd was €100,000.

  Northern purchased the entire business of southern

Northern purchased the entire business of Southern including all its assets and liabilities for $687,750. Below is information related to the two companies:

  Levi mcarthur graduated with a master of accountancy degree

levi mcarthur graduated with a master of accountancy degree and has accepted a staff accounting position with a firm he

  What is impact if the company adds an additional security

what is impact if the company adds an additional security guard for the factory at a cost of $41000 per year?

  Quality-of-earnings qoe analysis attempts to evaluate

quality-of-earnings qoe analysis attempts to evaluate whether the reported earnings of a company reflect its true

  Illustrate what is jerold federal income tax filing status

Travis is a full-time student, while Macy earns $7,000 each year from a part-time job. Travis and Macy do not file jointly during either year. Illustrate what is Jerold’s Federal income tax filing status for 2010 and 2011 if all parties reside in:

  Compute the cash receipts and cash disbursements

compute the cash receipts and cash disbursements schedule.tilson company has projected sales and production in units

  Estimate of the companys net operating income

Maack Corporation's contribution margin ratio is 19% and its fixed monthly expenses are $50,500. If the company's sales for a month are $312,000, what is the best estimate of the company's net operating income? Assume that the fixed monthly expenses ..

  Differences between the models for law systems

What are some of the differences between the models for law systems throughout the world? What are some of the benefits of each? What are some of the disadvantages of each?

  Should mr. jackson accept the special order

George Jackson operates a small machine shop. He manufactures one standard product which is available from many other similar businesses and also manufactures custom-made products. His accountant prepared the annual income statement shown below.

  Developing master budget and pro-forma financial statement

The Gold Bay Hotel is in the process of developing a master budget and pro-forma financial statements for 1999.  The beginning balance sheet for the fiscal year 1999 is estimated to be: During the year the hotel expects to rent 30,000 rooms.  Rooms r..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd