What can you say about the companys liquidity position

Assignment Help Corporate Finance
Reference no: EM131359761

Assignment

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: EM131359761

Questions Cloud

Describe functioning of different parts of a typical sram : What are the commonly used input and output ports in a computer system? Briefly describe the applications of each one of them.
Addressing how to conduct comprehensive background : You are the HR Manager of a large child care center. The CEO has asked you to prepare a 2-3 page paper addressing how to conduct comprehensive background checks on employees hired to work with children.
Determine the number of address input lines : A certain memory is specified as 32K × 8.
Preparing for hr transformations : Of the items that Dr. Dave Ulrich mentioned in the you tube video (in the reading assignments for the week) for preparing for HR transformations, select two that you think are most important for the transformation you will recommend in your third ..
What can you say about the companys liquidity position : FIN 534- 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?
Find the number of ram chips required for the same : It is desired to construct a 64K × 16 RAM from an available RAM chip specified as 16K × 8. Determine the number of RAM chips required for the same.
Describe compensation issues : Question 1: Describe compensation issues you feel are important in your organization. Why would you rank these above others? Question 2: If your organization decided it had to reduce compensation levels to be competitive, how could you communicate ..
Find the number of sectors per track for this hard disk : The following data refer to a hard disk: number of tracks per side = 600; number of sides = 2; number of bytes per sector = 512; storage capacity in bytes = 21 504 000. Determine the number of sectors per track for this hard disk.
Integrate given two interviews as one paper : I did interview older people two times. - Given are two Interview: - Integrate given two interviews as one paper.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Determine the wacc for levels of the debt-to-capital ratio

Determine the WACC for levels of the debt-to-capital ratio and recommend a target capital structure given that the company is concerned with achieving the lowest possible cost of capital.

  Prepare a report on apple inc

Executive summary -  A brief summary introduction focused on important analytical results

  Consider a 6-year coupon bond with 4 annual coupons and a

consider a 6-year coupon bond with 4 annual coupons and a 1000 face value. how much will the price of the bond change

  Pick an mnc that currently does not do business in india

pick an mnc that currently does not do business in india. then consider what steps this company should explore to

  Provide a specific example of a company that took an action

provide a specific example of a company that took an action that might have increased short run profits but had the

  Prepare an analysis that shows whether

Cobe Company has already manufactured 28,000 units of Product A at a cost of $ 28 per unit.

  Describe the limitations of financial ratio analysis

Recent Financial Statement Report of the corporation, How liquid is the firm and are the firm's managers generating adequate operating profits on the company's assets?

  What is objective of the chase syndication team in hong kong

What is the objective of the Chase syndication team in Hong Kong - are they underwriters (investment bankers) or lenders (commercial bankers)?

  National financial advisors nfa served a diverse set of

national financial advisors nfa served a diverse set of clients some of whom were quite sophisticated financially and

  Two years ago the krusty krab restaurant purchased a grill

two years ago the krusty krab restaurant purchased a grill for 50000. the owner eugene krabs has learned that a new

  1 vindaloo corporation reported retained earnings of 400 on

1. vindaloo corporation reported retained earnings of 400 on its year-end 2002 balance sheet. during 2003 the company

  What would elis ending cash balance

Discuss the relationship between bond prices and interest rates. What impact do changing interest rates have on the price of long-term bonds versus short-term bonds?

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