accounting exercises

profilemkrmer
financialstatements.docx

Exercise 12-5 Evaluate risk ratios [LO3]

The 2012 income statement of Adrian Express reports sales of $16 million, cost of goods sold of $9.6 million, and net income of $1.6 million. Balance sheet information is provided in the following table. All amounts are in thousands.

  

ADRIAN EXPRESS Balance Sheets December 31, 2012 and 2011

  ($ in 000s)

  2012

  2011

  Assets

 

 

 

 

  Current assets:

 

 

 

 

       Cash

$

600  

$

760  

       Accounts receivable

 

1,400  

 

1,000  

       Inventory

 

1,800  

 

1,400  

  Long-term assets

 

4,800  

 

4,240  

  

          Total assets

$

8,600  

$

7,400  

  

  Liabilities and Stockholders' Equity

 

 

 

 

  Current liabilities

$

2,020  

$

1,660  

  Long-term liabilities

 

2,300  

 

2,400  

  Common stock

 

2,000  

 

2,000  

  Retained earnings

 

2,280  

 

1,340  

  

          Total liabilities and stockholders' equity

$

8,600  

$

7,400  

  

  

Industry averages for the following four risk ratios are as follows:

  

  

  Average collection period

25 days  

  Average days in inventory

60 days  

  Current ratio

2 to 1  

  Debt to equity ratio

50%  

  

Required:

1.

Calculate the four risk ratios listed above for Adrian Express in 2012. (Use 365 days in a year. Round your answers to 1 decimal place. Omit the "%" sign in your response.)

    

  Risk Ratios

  Average collection period

 days

  Average days in inventory

 days

  Current ratio

 to 1

  Debt to equity ratio

 %

  

2.

Do you think the company is more risky or less risky than the industry averages?

 

  

 

The 2012 income statement of Adrian Express reports sales of $16 million, cost of goods sold of $9.6 million, and net income of $1.6 million. Balance sheet information is provided in the following table. All amounts are in thousands.

  

ADRIAN EXPRESS Balance Sheet December 31, 2012 and 2011

  ($ in 000s)

   2012

   2011

  Assets

 

 

 

 

  Current assets:

 

 

 

 

      Cash

$

600  

$

760  

      Accounts receivable

 

1,400  

 

1,000  

      Inventory

 

1,800  

 

1,400  

  Long-term assets

 

4,800  

 

4,240  

  

         Total assets

$

8,600  

$

7,400  

    

  Liabilities and Stockholders' Equity

 

 

 

 

  Current liabilities

$

2,020  

$

1,660  

  Long-term liabilities

 

2,300  

 

2,400  

  Common stock

 

2,000  

 

2,000  

  Retained earnings

 

2,280  

 

1,340  

  

         Total liabilities and stockholders' equity

$

8,600  

$

7,400  

  

    

Industry averages for the following four risk ratios are as follows:

    

  

  Gross profit ratio

45

 %

  Return on assets

25

 %

  Profit margin

15

 %

  Asset turnover

2.5

 times

  Return on equity

35

 %

  

Required:

1.

Calculate the five profitability ratios listed above for Adrian Express. (Round your answers to the nearest whole number. Omit the "%" sign in your response.)

  

  Profitability Ratios

  Gross profit ratio

%       

  Return on assets

%       

  Profit margin

%       

  Asset turnover

times  

  Return on equity

%       

  

2.

Do you think the company is more profitable or less profitable than the industry averages?

  

    

 

The balance sheet for Plasma Screens Corporation and additional information are provided below.

PLASMA SCREENS CORPORATION Balance Sheet December 31, 2012 and 2011

 

   2012

   2011

  Assets

 

 

 

 

  Current assets:

 

 

 

 

      Cash

$

112,000  

$

120,000  

      Accounts receivable

 

78,000  

 

92,000  

      Inventory

 

95,000  

 

80,000  

      Investments

 

4,000  

 

2,000   

  Long-term assets:

 

 

 

 

      Land

 

480,000  

 

480,000  

      Equipment

 

90,000  

 

670,000  

      Less: Accumulated depreciation

 

(428,000) 

 

(268,000) 

 

          Total assets

$

1,131,000  

$

1,176,000  

 

  Liabilities and Stockholders' Equity

 

 

 

 

  Current liabilities:

 

 

 

 

      Accounts payable

$

99,000  

$

85,000  

      Interest payable

 

6,000  

 

12,000  

      Income tax payable

 

8,000  

 

5,000  

  Long-term liabilities:

 

 

 

 

      Notes payable

 

100,000  

 

200,000  

  Stockholders' equity:

 

 

 

 

      Common stock

 

700,000  

 

700,000  

      Retained earnings

 

218,000  

 

174,000  

 

          Total liabilities and stockholders' equity

$

1,131,000  

$

1,176,000  

 

 

Additional information for 2012:

1.

Net income is $69,000.

2.

Sales on account are $1,520,000.

3.

Cost of goods sold is $1,160,000.

references

Section Break

Exercise 12-7 Calculate risk ratios [LO3]

 

 3.

value: 2.00 points

 

 

Exercise 12-7 Part 1

Required:

1.

Calculate the following risk ratios for 2012 (Round your answers to 1 decimal place. Omit the "%" sign in your response):

 Risk Ratios

 a.

 Receivables turnover ratio

 times

 b.

 Inventory turnover ratio

 times

 c.

 Current ratio

 to 1

 d.

 Acid-test ratio

 to 1

 e.

 Debt to equity ratio

 %

 

check my work eBook Link View Hint #1 references

Worksheet

Difficulty: Hard

 

Exercise 12-7 Part 1

Learning Objective: 12-03 Use ratios to analyze a company’s risk.

 

 

 4.

value: 1.00 points

 

 

Exercise 12-7 Part 2

2.

When we compare two companies, can one have a higher current ratio while the other has a higher acid-test ratio?

Yes

No

Exercise 12-9 Calculate profitability ratios [LO4]

[The following information applies to the questions displayed below.]

The following condensed information is reported by Sporting Collectibles.

 

2013

2012

  Income Statement Information

 

 

 

 

  Sales revenue

$

10,400,000  

$

8,400,000  

  Cost of goods sold

 

6,800,000  

 

5,900,000  

  Net income

 

360,000  

 

248,000  

 

 

 

 

 

  Balance Sheet Information

 

 

 

 

  Current assets

$

1,600,000  

$

1,500,000  

  Long-term assets

 

2,200,000  

 

1,900,000  

 

      Total assets

$

3,800,000  

$

3,400,000  

 

  Current liabilities

$

1,200,000  

$

900,000  

  Long-term liabilities

 

1,500,000  

 

1,500,000  

  Common stock

 

800,000  

 

800,000  

  Retained earnings

 

300,000  

 

200,000  

 

      Total liabilities and stockholders' equity

$

3,800,000  

$

3,400,000  

 

references

Section Break

Exercise 12-9 Calculate profitability ratios [LO4]

 

 5.

value: 2.00 points

 

 

Exercise 12-9 Part 1

Required:

1.

Calculate the following profitability ratios for 2013 (Round your answers to 1 decimal place. Omit the "%" sign in your response):

 Profitability Ratios

 

 

 a.

 Gross profit ratio

 %

 b.

 Return on assets

 %

 c.

 Profit margin

 %

 d.

 Asset turnover

 times

 e.

 Return on equity

 %

check my work eBook Link View Hint #1 references

Worksheet

Difficulty: Hard

 

Exercise 12-9 Part 1

Learning Objective: 12-04 Use ratios to analyze a companys profitability.

 

 

 6.

value: 1.00 points

 

 

Exercise 12-9 Part 2

2.

Determine the amount of dividends paid to shareholders in 2013. (Omit the "$" sign in your response.)

  The amount of dividends paid

$  

check my work eBook Link View Hint #1 references

Worksheet

Difficulty: Hard

 

Exercise 12-9 Part 2

Learning Objective: 12-04 Use ratios to analyze a companys profitability.