Redcorp, Inc. manufactures a variety of consumer products. The company’s founders have run the company for 30 years and are now interested in retiring. Consequently, they are seeking a purchaser who will continue its operations, and a group of investors, Stewart Inc, is looking into the acquisition of Redcorp. To evaluate its financial stability and operating efficiency, Redcorp was requested to provide the latest financial statements and selected financial ratios. Summary information provided by Recorp is as follows:
Redcorp Inc.
Income Statement
For the Year Ended November 30, 2015
(in thousands)
Sales (net) 30,500
Interest income 500
Total Revenue 31,000
Cost and expenses
Cost of goods sold 17,600
Selling and general administrative expenses 3,550
Depreciation and amortization expenses 1,890
Interest Expense 900
Total costs and expenses 23,940
Income before taxes 7,060
Income taxes 2,800
Net income 4,260
Redcorp Inc. Balance SheetAs of November 30, 2015(in thousands)
2015 2014Cash 400 500Short-term investments 300 200Accounts receivable (net) 3,200 2,900Inventory 6,000 5,400Total current assets 9,900 9,000Property, plant, and equipment 7,100 7,000Total assets 17,000 16,000Accounts payable 3,700 3,400Income taxes payable 900 800Accrued expenses 1,700 1,400Total current liabilities 6,300 5,600Long-term debt 2,000 1,800Total liabilities 8,300 7,400Common stock ($1 par value) 2,700 2,700Paid-in capital in excess in par 1,000 1,000
Retained earnings 5,000 4,900
Total stockholders’ equity 8,700 8,600Total liabilities and equity 17,000 16,000
Selected Financial Ratios for Redcorp, Inc.
2014 2013 Current Industry AverageCurrent Ratio 1.61 1.62 1.63Acid Test Ratio .64 .63 .68Times Interest Earned 8.55 8.50 8.45Profit margin on sales 13.2% 12.1% 13.0%Asset turnover 1.84 1.83 1.84Inventory turnover 3.17 3.21 3.18
Requirement:1. In Microsoft Word (or other word processing document), please discuss the following:A. Calculate a new set of ratios for the fiscal year 2015 for Redcorp based on the financial statements presented. B. Explain the analytical use of each of the six ratios presented, describing what the investors can learn about Redcorp’s financial stability and operating efficiency. C. Identify and discuss three limitations of ratio analysis

A)

B)

                                       2014      2013          Industry Ave.     2015

Current Ratio                   1.61        1.62                   1.63             1.57

Acid Test Ratio                .64         .63                     .68             0.57

Times Interest Earned  8.55       8.50                  8.45              8.84

Profit margin on sales   13.2%     12.1%                 13.0%           13.97%

Asset turnover               1.84        1.83                    1.84             1.85

Inventory turnover         3.17        3.21                    3.18             3.09

Some of the company's ratios have improved a little, while others have actually worsen a little. but on general terms, they follow the industry's average.

E.g. times interest earned, profit margin and asset turnover improved a little and they tell investors that the company is more efficient and is actually working better and being more profitable.

While the current ratio, acid test ratio and inventory turnover show us that the company is a little bit more exposed to market risks and general economic conditions. But the change has not been substantial.

C)

The basic limitations of ratio analysis are:

Explanation:

Redcorp Inc.

Income Statement

For the Year Ended November 30, 2015  (in thousands)

Sales (net)                  30,500

Interest income              500

Total Revenue                           31,000

Cost and expenses

Cost of goods sold    17,600

S&A expenses            3,550

Dep. and amort. exp.  1,890

Interest Expense          900

Total costs and expenses        (23,940 )

Income before taxes                    7,060

Income taxes                                2,800

Net income                                   4,260

Redcorp Inc.

Balance Sheet

As of November 30, 2015 (in thousands)

                                                          2015           2014

Cash                                                   400           500

Short-term investments                    300           200

Accounts receivable (net)             3,200         2,900

Inventory                                        6,000         5,400

Total current assets                       9,900         9,000

Property, plant, and equipment     7,100         7,000

Total assets                                   17,000       16,000

Accounts payable                          3,700         3,400

Income taxes payable                      900            800

Accrued expenses                         1,700           1,400

Total current liabilities                  6,300          5,600

Long-term debt                             2,000           1,800

Total liabilities                                8,300          7,400

Common stock ($1 par value)        2,700         2,700

Paid-in capital in excess in par      1,000          1,000

Retained earnings                         5,000          4,900

Total stockholders’ equity            8,700           8,600

Total liabilities and equity           17,000          16,000

Selected Financial Ratios for Redcorp, Inc.

                                       2014      2013          Current Industry Average

Current Ratio                   1.61        1.62                   1.63

Acid Test Ratio                .64         .63                     .68

Times Interest Earned  8.55       8.50                  8.45

Profit margin on sales   13.2%     12.1%                 13.0%

Asset turnover               1.84        1.83                    1.84

Inventory turnover         3.17        3.21                    3.18

1) the stages a new product goes through from beginning to end, i.e., the stages that a product passes through from introduction through growth, maturity, and decline. 2) the time from initial research and development to the time at which sales and support of the product to customers are withdrawn. 3) the period of time during which a product can be produced and marketed profitably.

                                          hope it