Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Explain Analysis of the financial statements with comparison of industry averages

Heartland Inc. is a medium-size company that has been in business for 20 years. The industry has become very competitive in the last few years, and Heartland has decided that it must grow if it is going to survive.  It has approached the bank for a sizable five-year loan, and the bank has requested its most recent financial statement as part of the loan package.

The industry in which Heartland operates consists of approximately 20 companies relatively equal in size. The trade association to which all of the competitors belong publishes an annual survey of the industry, including industry averages for selected ratios for the competitors. All companies voluntarily submit their statements to the association for this purpose.

Heartland\'s controller is aware that the bank has access to this survey and is very concerned about how the company fared this past year compared with the rest of the industry. The ratios included in the publication, and the averages for the past year, are as follows:

Ratio

Industry Average

Current ratio

1.23

Acid-test (quick) ratio

0.75

Accounts receivable turnover

33 times

Inventory turnover

29 times

Debt-to-equity ratio

0.53

Times interest earned

8.65 times

Return on sales

6.57%

Asset turnover

1.95 times

Return on assets

12.81%

Return on common stockholders\' equity

17.67%

The financial statements to be submitted to the bank in connection with the loan follow:

Heartland Inc.

Statement of Income and Retained Earnings

For the Year Ended December 31, 2007

(thousands omitted)

Sales revenue

$542,750

Cost of goods sold

(435,650)

Gross profit

$107,100

Selling, general, and administrative expenses

$(65,780)

Loss on sales of securities

(220)

Income before interest and taxes

$41,100

Interest expense

(9,275)

Income before taxes

$31,825

Income tax expense

(12,730)

Net income

$19,095

Retained earnings, January 1, 2007

58,485

 

$77,580

Dividends paid on common stock

(12,000)

Retained earnings, December 31, 2007

$65,580

Heartland Inc.

Comparative Statements of Financial Position

(thousands omitted)

 

2007

2008

Assets

 

 

Current assets:

 

 

Cash

$1,135

$750

Marketable securities

1,250

2,250

Accounts receivables, net of allowances

15,650

12,380

Inventories

12,680

15,870

Prepaid items

385

420

Total current assets

$31,100

$31,670

Long-term investments

$425

$425

Property, plan, and equipment:

 

 

Land

$32,000

$32,000

Building and equipment, net of accumulated depreciation

216,000

206,000

Total property, plant, and equipment

$248,000

$238,000

Total assets

$279,525

$270,095

Liabilities and Stockholders\' Equity

 

 

Current Liabilities:

 

 

Short-term loans

$8,750

$12,750

Accounts payable

20,090

14,380

Salaries, wages, and other

1,975

2,430

Income taxes payable

3,130

2,050

Total current liabilities

$33,945

$31,610

Long-term bonds payable

$80,000

$80,000

Stockholders\' equity:

 

 

Common stock, at par

$100,000

$100,000

Retained earnings

65,580

58,485

Total stockholders\' equity

$165,580

$158,485

Total liabilities and stockholders\' equity

$279,525

$270,095

Question:

Prepare a columnar report for the controller of Heartland Inc., comparing the industry average for the ratio published by the trade association with the comparable ratios for Heartland. For Heartland, compute the ratios as of December 31, 2007, or for the year ending December 31, 2007, whichever is appropriate

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M9166440

Have any Question?


Related Questions in Basic Finance

Set up an amortization schedule for a 15000 loan to be

Set up an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next 4 years. The interest rate is 10%. How large must each payment be if the loan is for $30,000? Assume th ...

What is a budget variance analysis and why is this type of

What is a budget variance analysis and Why is this type of analysis key to determining the strengths and weaknesses of a business?

What are the ways that it can help comply with legal

What are the ways that IT can help comply with legal requirements and social responsibilities surrounding the sales of alcohol?

1nbspmrs beach wants to invest a lump sum of money today to

1)   Mrs. Beach wants to invest a lump sum of money today to have $100,000 when she retires at 65 (she is 40 today). a. How much of a deposit would she have to make if the interest rate on the C.D. was 5%? b. What would ...

The enterprise value of kwok services is 550 million kwok

The enterprise value of Kwok Services is $550 million. Kwok has total debt of $90 million, cash and investments of $40 million, and 8 million outstanding shares. What is Kwok's value per share?

You want to borrow 103000 from your local bank to buy a new

You want to borrow $103,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $2,350, but no more. Assuming monthly compounding, what is the highest rate you can afford on a 54-month ...

Find the modified internal rate of return mirr the annual

Find the modified internal rate of return (MIRR) The annual rate is 8.24%. Initial outlay is $356,800. Year 1: $163,100 Year 2: $173,100 Year 3: $181,300 Year 4: $175,700 Year 5: $161,400

Arbitrage insures that equal cash flows of equal risk sell

Arbitrage insures that equal cash flows (of equal risk) sell at equal prices and unequal cash flows (of equal risk) sell at equal rates of return once arbitrage has worked to adjust the prices. True or False and why?

You have just made your first 5200 contribution to your

You have just made your first $5,200 contribution to your retirement account. Assume you earn a return of 12 percent per year and make no additional contributions. a. What will your account be worth when you retire in 43 ...

As the financial controller for kl incorporated a highly

As the financial controller for KL Incorporated, a highly diversified conglomerate, you are considering the alternative financing plans for the next millennium. Due to the good relationship with the banks, your firm is a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As