Prepare a columnar report for controller of heartland inc

Assignment Help Accounting Basics
Reference no: EM131793088

Problem - Comparison with 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 Inc. decides 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 Heartland's most recent financial statements 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 companies belong publishes an annual survey of the industry, including industry averages for selected ratios for the competitors. All companies voluntarily submit their financial statements to the association for this purpose.

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

Ratio

Industry Average

Current ratio

1.23

Acid test (quick) ratio

0.75

Accounts receivables turnover

33 times

Inventory turnover

29 times

Debt-to- equity ratio

0.53 times

Interest earned

8.65 times

Return on sales

6.57%

Assets turnover

1.95 times

Return on assets

12.81%

Return on common stockholder's 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, 2008 (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 and 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, 2008                                            58,485

                                                                                                                $77,580

Dividends paid on common stock                                             (12,000)               

Retained earnings December 31, 2008                                    $65,580                                

Heartland Inc. Comparative Statements of Financial Position (thousands omitted)

 

2008

2007

Assets



Current assets:

Cash

Marketable securities

Accounts receivable, net of allowances

Inventories

Prepaid items

Total current assets

Long term investments

Property, plant, and equipment:

Land

Buildings and equipment, net of accumulated depreciation

Total property, plant, and equipment

Total assets

 

$ 1,135

1,250

15,650

12,680

385

$ 31,100

$  425

 

$  32,000

216,000

$248,000

$279,525

 

$ 750

2,250

12,380

15,870

420

$ 31,670

$   425

 

$  32,000

206,000

$238,000

$270,095




Liabilities and Stockholder's Equity



Current liabilities:

Short term notes

Accounts payables

Salaries and wages payable

Income taxes payable

Total current liabilities

Long term bonds payable

Stockholders' equity:

Common stock, no par

Retained earnings

Total stockholders' equity

Total liabilities and stockholders' equity

 

$ 8,750

20,090

1,975

3,130

$ 33,945

$ 80,000

 

$100,000

65,580

$165,580

$278,525

 

$ 12,750

14,380

2,430

2,050

$ 31,610

$ 80,000

 

$100,000

58,485

$158,485

$270,095

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

Reference no: EM131793088

Questions Cloud

Using fifo method calculate cost of goods sold : Using FIFO method, calculate cost of goods sold, ending inventory, and gross profit
Would the new interval be narrower or wider : Find a 95% confidence interval for the difference in proportions. In particular, does the interval capture 0, and what does that show?
Discuss what is the amount of contribution margin : What is the amount of contribution margin if sales volume increases by 20%
Was the rate of miscarriages higher with zofron as feared : Was the rate of miscarriages higher with Zofron, as feared? Which of the conditions for finding the confidence interval do not hold?
Prepare a columnar report for controller of heartland inc : Prepare a columnar report for the controller of Heartland Inc. comparing the industry averages for the ratios published by the trade association
Find the percentages that graduated for both groups : Which of the conditions fail so that we cannot use a confidence interval for the difference between proportions?
Write about why we study history : The second objective, in the same document you will write about Why we study history. Peter Stearns has a great article on this which will help you get started.
Calculate the putin companys ratios : Selected data for Putin Company for 2014 and additional information on industry averages follow
Would the interval be wider or narrower than the one : Report the confidence interval for the population percentage that opposed banning super-size sugary soft drinks in 2012, using a carefully worded sentence.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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