PROBLEM (23 POINTS) Use the following information to PREPARE A RATIO ANALYSIS FOR Carton Co.

The following information pertains to Carlton Company. Assume that all balance sheet amounts represent both average and ending balance figures. Assume that all sales were on credit.
Assets
Cash and short-term investments

$ 40,000
Accounts receivable (net)

25,000
Inventory

20,000
Property, plant and equipment

210,000

Total assets
$295,000

Liabilities and Stockholders’ Equity
Current liabilities

60,000
Long-term liabilities

85,000
Stockholders’ equity-common

150,000

Total liabilities and stockholders’ equity
$295,000

Income Statement
Net sales

$ 85,000
Cost of goods sold

45,000
Gross margin

40,000
Operating expenses

15,000
Interest expense

5,000

Net income
$ 20,000
EPS $3.33

Number of shares of common stock

6,000
Market price of common stock

$20
Total dividends paid

$5,400
Cash provided by operations

$30,000
Dividend per share $.90

Required:

Prepare a ratio analyses using the formulas presented on page 627. If a ratio not applied to Carton Co., write N/A.

1. Current Ratio = Current assets / Current liabilities

= (40000+25000+20000)/60000

= 1.42

2. Quick Ratio = (Cash and short term investments + Accounts Receivable)/ Current Liabilities

= (40000+25000)/60000

= 1.08

3. Liquidity Ratio = (Cash and short term investments)/current Liabilities

= 40000/60000

= 0.67

4. Gross Profit Ratio = (Gross Profit / Net sales)*100

= 40000/85000*100

= 0.470588 * 100

= 47.06%

5. Operating Cost Ratio = (Operating Cost / Net sales)*100

= (45000+15000)/85000*100

= 70.59%

6. Operating profit Ratio = (operating profit/Net sales)*100

= (Gross Profit - Operating Expenses)/Net sales * 100

= (40000-15000)/85000*100

= 29.41%

7. Net Profit Ratio = Net Profit/Net Sales * 100

= 20000/85000*100

= 23.53%

8. Return on shareholder's Fund = Net Profit After Interest And Taxes/ Shareholders Funds * 100

= 20000/150000*100

= 13.33%

9. Return on Capital employed = Net Profit Before interest and Tax / (Total Assets - Current Liabilities)*100

= (20000+5000)/(295000-60000)*100

= 10.64%

10. Return on Total Assets = Net Profit Before interest and Tax / Total Assets * 100

= 25000/295000*100

= 8.47%

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