Calculate current ratios based on projected balance sheet

Assignment Help Financial Accounting
Reference no: EM131353606

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

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

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

Questions Cloud

Result of excess sulphur dioxide in the atmosphere : Explain why acidic rain produced as a result of excess sulphur dioxide in the atmosphere can cause degradation of buidings
Describe the four different perspectives on compensation : Create a 1-2 page document identifying and describing the 4 different perspectives on compensation.
Determine the rate of the reaction between crystal violet : Could you explain the Kinetics of a Reaction Lab experiment where we determine the rate of the reaction between Crystal Violet dye and Sodium Hydroxide? I want to be able to understand how the how the whole reaction takes place, how the rate is de..
Calculate the temperature ranges on the logarithmic scale : Calculate the temperature ranges on the logarithmic scale and draw a conclusion about efficiency on the logarithmic scale.
Calculate current ratios based on projected balance sheet : 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?
Write chemical reactions to explain it : Explain how photochemical smog is generated and write chemical reactions to explain it?
How will you notify people of potentially dangerous : Recall your chosen firm and industry you have been using throughout the course. For this assignment, you will identify the top three major safety and health issues in your firm, and write a policy on each, consistent with Occupational Safety & H..
Identify the chemical components and the proportions : Identify the chemical components and the proportions necessary to achieve a buffer with the desired pH. Include relevant calculations in your answer.
Write the name and charge of the anion : Write the name and chemical formula of the following compound containing Sodium and Oxygen. Write the name and charge of the cation . Write the name and charge of the anion

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate annual depreciation for the first and second years

Conlin Company acquires a delivery truck at a cost of $42,000. The truck is expected to have a salvage value of $6,000 at the end of its 4-year useful life. the straight-line method. Calculate annual depreciation for the first and second years usin..

  Statement of cash flows in making informed decisions

Prepare a statement of cash flows for year ended December 31, 2014. Use the indirect method for cash flows from operating activities and how can users of financial statements utilize statement of cash flows in making informed decisions?

  Compute the annual rate of return

Wallowa Company is considering a long-term investment project called ZIP. ZIP will require an investment of $121,080. It will have a useful life of 4 years and no salvage value. Annual revenues would increase by $79,460, and annual expenses (excludin..

  Type of accounting fraud is payroll fraud

A possible type of accounting fraud is payroll fraud.Payroll fraud occurs when someone in the payroll department creates a fake/ imaginary employee and then collects the pay checks for that employee.

  What was the revenue earned in march

How could the Grays have concluded that the business operated at a loss of $6,100? Was this a valid basis on which to determine net income?

  What would elite report as cash payments to suppliers

In fiscal year 20x3, Elite, Inc. had cost of good sold of 1,000,000 euro. Inventory increased during the year by 250,000 euro while accounts payable increased by 150,000 euro and trade receivables decreased by 200,000 euro. Using the direct method, w..

  Acquisition and disposition of property plantthe research

acquisition and disposition of property plantthe research paper should not be more than pages including one page for

  What tax factors should be considered when making decision

When conducting business in the corporate form what tax factors should be considered when making the decision to operate as a C Corporation or an S Corporation?

  Statement of cash flows1 choose the combination that best

statement of cash flows1. choose the combination that best reflects the appropriate classification of cash received

  Elucidate the concept of net present value

Compute the net present value of the cash flows and the IRR for the project using the Excel spreadsheet formula. Elucidate the concept of Net Present Value.

  Determine the sales volume in dollars and units

Lindo Company incurs annual fixed costs of $46,640. Variable costs for Lindo’s product are $21.76 per unit, and the sales price is $32.00 per unit. Lindo desires to earn an annual profit of $50,000. Required Determine the sales volume in dollars and ..

  Financial management and accounting processes

Financial management and accounting processes

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