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

  Tiger computers inc of singapore is taking the purchase of

tiger computers inc. of singapore is taking the purchase of an automated etching machine for use in the production of

  Case study lynden limited research question consists of a

case study lynden limited research question consists of a case study you are a graduate accountant working for white

  Determine net operating profit or loss for business

Determine the net operating profit or loss for the business. Provide detailed assumptions to support each line item in your Proforma P&L Statement.

  Illustrate which type of buying situation is

the White Sox head groundskeeper, scouted nationwide for dirt before settling on the mix provided by Partac Peat. First time Roger Bossard purchased Partac Peat, it was most likely an example of which type of buying situation?

  Classify the following items as issuance of stock

Classify the following items as issuance of stock (I), dividends (D), revenues (R), or expenses (E). Then indicate whether each item increases or decreases stockholders' equity.

  Income tax liability before any tax credits

In 2013, Apricot Corporation had taxable income of $120,000. Included in taxable income was a $10,000 capital gain. The $120,000 of taxable income does not include a $15,000 capital loss carry forward available from the previous year. What is Apricot..

  Analyse the corporate culture at enron

Analyse the corporate culture at Enron and its management's behaviour. Include in your analysis, the normative theory of ethics which you would consider most relevant in driving the decision making at Enron.

  Prepare adjusting entries for the year ended

Prepare adjusting entries for the year ended December 31, 2013, Employee salaries are owed for 3 days of a regular 5-day work week. Weekly payroll, $8,000. The balance in Supplies before adjustment is $1,600. A physical count reveals $350 of supplies..

  Determine the contribution margin at the break-even point

Calculate the break-even point in (1) dollars and (2) number of fares. Without calculations, determine the contribution margin at the break-even point.

  Prepare a master budget for beta manufacturing

Prepare a Master Budget for Beta Manufacturing Ltd for each quarter (with a yearly total column) for the year ended 31 December 2012.

  Question premier trust and bank is considering giving alou

question premier trust and bank is considering giving alou company a loan. before doing so management decides that

  How would you advise the partners in developing a method

How would you advise the partners in developing a method for dividing income - Sanchez believes the income should be divided 7:3, favoring Sanchez, since Sanchez provides the majority of effort in running the partnership business.

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