What can you say about the companys liquidity position

Assignment Help Corporate Finance
Reference no: EM131225065

Question: Directions: Answer the following questions on a se...

Directions: Answer the following questions on a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link in the course shell. This homework assignment is worth 100 points.

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

Questions Cloud

Advantages and disadvantages of private sector options : Discuss one or more of the issues associated with those questions in light of your own value system and beliefs. How can the
Describe at least three ways a person can teach : Describe at least three ways a person can teach by example according to the article and provide a personal example in which you have demonstrated this concept. Explain how "teaching by example" influences the development of ethical and moral reas..
Supply chain manager for midstream natural gas company : MEB-7173 - Operations Management - You are the Supply Chain Manager for a Midstream natural gas company. Your latest customer is an E&P company active in the Bakken Shale in a North Dakota.
What is the standard error of the sampling distribution : What is the standard error of the sampling distribution? What is the probability that the sample mean will be less than 31 days for reimbursement? What is the probability that the sample mean will indicate between 35 and 45 days for reimbursement?
What can you say about the companys liquidity position : 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?
Regarding the format of the multi-step income statement : Identify the false statement regarding the format of the multi-step income statement:
Compare to the companys credit terms : Contemporary Media Sign Company sells on account. Recently, Contemporary reported the following figures: Requirements Compute Contemporary’s days’ sales in receivables for 2013. Suppose Contemporary’s normal credit terms for a sale on account are “2/..
Find the probability that the daily output : The daily output of a production line varies according to a normal distribution with a mean (µ ) of 163 units and a standard deviation (σ ) of 3.5.Find the probability that the daily output will fall below 160 units. Find the probability that..
Discuss the lawsuit in the notes to the financials : My company is being sued for $1,000,000. We are fighting the lawsuit and believe we will be successful in beating the lawsuit but it will likely cost us $100,000 in attorney bills and associated costs. Even though we think we will beat the lawsuit, w..

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Prepare the trading and profit and loss account

Prepare the Trading and Profit and Loss Account of Little Scamps for the Year ended 30 June 201Y. A proforma is provided in your Answer Booklet for your use in completing this task.

  Elk county telephone has paid the dividends shown in the

elk county telephone has paid the dividends shown in the following table over the past 6 years.year dividend per

  Computing the monthly interest rate

You are taking out a 100,000 mortgage loan to be repaid over 25 years in 300 monthly payments

  Calculate cost of retained earnings and new common stock

The management of a conservative company has adopted a policy of never letting debt exceed 30% of total financing. The company will earn $10,000,000 but distribute 40% in dividends,

  Create a financial analysis report of ge general electric

create a financial analysis report of ge general electric including the following six sections- executive summary-

  Constant-growth dividend discount model to estimate your

constant-growth dividend discount model to estimate your companys expected rate of return. you will assume that the

  What is the impact on your recommendation of the fact

What is the impact on your recommendation of the fact that the operating cash inflows associated with press A are characterized as very risky in contrast to the low-risk operating cash inflows of press B?

  Computation of present value of bond

Computation of present value of bond to check whether it is overpriced - Ron Rhodes calles his broker to inquire about purchasing a bond of Golden Years Recreation Corporation

  Find internal rate of return and payback period

Explain with a graph how SML is different from CML. Why CAPM equation might be more relevant than other equations when calculating required rate of return.

  The loan sharks propose legislation to promote the industry

Suppose you were hired as a lobbyist for the loan sharks. What arguments could you make to support their proposal? - How would you respond to these arguments if you oppose kneecap breaking?

  If she invests her prize money in a diversified

Your mother just won $250,000 for splitting a Nobel Prize with three coworkers. If she invests her prize money in a diversified equity portfolio returning 8 percent per year, approximately how long will it take her to become a millionaire, before acc..

  Dick davies owns a small mining company called davies gold

dick davies owns a small mining company called davies gold mining. the recent rises in the gold price has made the

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