返回列表 发帖

Reading 41: Financial Analysis Techniques - LOS d ~ Q1-5

1.During 2007, Brownfield Incorporated purchased $140 million of inventory. For the year just ended, Brownfield reported cost of goods sold of $130 million. Inventory at year-end was $45 million. Calculate inventory turnover for the year.

A)   2.89.

B)   3.25.

C)   3.50.

D)   3.71.

 

2.As of December 31, 2007, Manhattan Corporation had a quick ratio of 2.0, current assets of $15 million, trade payables of $2.5 million, and receivables of $3 million, and inventory of $6 million. How much were Manhattan’s current liabilities?

A)   $7.5 million.

B)   $10.5 million.

C)   $12.0 million.

D)   $4.5 million.

 

3.Wells Incorporated reported the following common size data for the year ended December 31, 20X7:

Income Statement

%

 

 

Sales

100.0

 

 

Cost of goods sold

58.2

 

 

Operating expenses

30.2

 

 

Interest expense

0.7

 

 

Income tax

5.7

 

 

Net income

5.2

 

 

 

 

 

 

Balance sheet

%

 

%

Cash

4.8

Accounts payable

15.0

Accounts receivable

14.9

Accrued liabilities

13.8

Inventory

49.4

Long-term debt

23.2

Net fixed assets

30.9

Common equity

48.0

Total assets

100.0

Total liabilities & equity

100.0


For 20X6, Wells reported sales of $183,100,000 and for 20X7, sales of $215,600,000. At the end of 20X6, Wells’ total assets were $75,900,000 and common equity was $37,800,000. At the end of 20X7, total assets were $95,300,000. Calculate Wells’ current ratio and return on equity ratio for 20X7.

 

 

Current ratio

Return on equity

 

A)           2.4                                    26.4%

B)           4.6                                    25.2%

C)           2.4                                    26.8%

D)            4.6                                   22.8%

4.Eagle Manufacturing Company reported the following selected financial information for 2007:

Accounts payable turnover

5.0

Cost of goods sold

$30 million

Average inventory

$3 million

Average receivables

$8 million

Total liabilities

$35 million

Interest expense

$2 million

Cash conversion cycle

13.5 days

Assuming 365 days in the calendar year, calculate Eagle's sales for the year.

A)   $57.8 million.

B)   $58.4 million.

C)   $52.3 million.

D)   $36.0 million.

 

5.Which of the following ratios would NOT measure liquidity?

A)   Quick Ratio.

B)   ROA.

C)   Cash Ratio.

D)   Current Ratio.

答案和详解如下:

1.During 2007, Brownfield Incorporated purchased $140 million of inventory. For the year just ended, Brownfield reported cost of goods sold of $130 million. Inventory at year-end was $45 million. Calculate inventory turnover for the year.

A)   2.89.

B)   3.25.

C)   3.50.

D)   3.71.

The correct answer was B)

First, calculate beginning inventory given COGS, purchases, and ending inventory. Beginning inventory was $35 million [$130 million COGS + $45 million ending inventory – $140 million purchases]. Next, calculate average inventory of $40 million [($35 million beginning inventory + $45 million ending inventory) / 2]. Finally, calculate inventory turnover of 3.25 [$130 million COGS / $40 million average inventory].

 

2.As of December 31, 2007, Manhattan Corporation had a quick ratio of 2.0, current assets of $15 million, trade payables of $2.5 million, and receivables of $3 million, and inventory of $6 million. How much were Manhattan’s current liabilities?

A)   $7.5 million.

B)   $10.5 million.

C)   $12.0 million.

D)   $4.5 million.

The correct answer was D)

Manhattan’s quick assets were equal to $9 million ($15 million current assets – $6 million inventory). Given a quick ratio of 2.0, quick assets were twice the current liabilities. Thus, the current liabilities must have been $4.5 million ($9 million quick assets / 2.0 quick ratio).

 

3.Wells Incorporated reported the following common size data for the year ended December 31, 20X7:

Income Statement

%

 

 

Sales

100.0

 

 

Cost of goods sold

58.2

 

 

Operating expenses

30.2

 

 

Interest expense

0.7

 

 

Income tax

5.7

 

 

Net income

5.2

 

 

 

 

 

 

Balance sheet

%

 

%

Cash

4.8

Accounts payable

15.0

Accounts receivable

14.9

Accrued liabilities

13.8

Inventory

49.4

Long-term debt

23.2

Net fixed assets

30.9

Common equity

48.0

Total assets

100.0

Total liabilities & equity

100.0


For 20X6, Wells reported sales of $183,100,000 and for 20X7, sales of $215,600,000. At the end of 20X6, Wells’ total assets were $75,900,000 and common equity was $37,800,000. At the end of 20X7, total assets were $95,300,000. Calculate Wells’ current ratio and return on equity ratio for 20X7.

 

 

Current ratio

Return on equity

 

A)                                        2.4       26.4%

B)                                        4.6       25.2%

C)                                        2.4       26.8%

D)                                        4.6       22.8%

The correct answer was C)

The current ratio is equal to 2.4 [(4.8% cash + 14.9% accounts receivable + 49.4% inventory) / (15.0% accounts payable + 13.8% accrued liabilities)]. This ratio can be calculated from the common size balance sheet because the percentages are all on the same base amount (total).

Return on equity is equal to net income divided by average total equity. Since this ratio mixes an income statement item and a balance sheet item, it is necessary to convert the common-size inputs to dollars. Net income is $11,211,200 ($215,600,000 × 5.2%) and average equity is $41,772,000 [($95,300,000 × 48.0%) + $37,800,000] / 2. Thus, 2007 ROE is 26.8% ($11,211,200 net income / $41,772,000 average equity).

 

4.Eagle Manufacturing Company reported the following selected financial information for 2007:

Accounts payable turnover

5.0

Cost of goods sold

$30 million

Average inventory

$3 million

Average receivables

$8 million

Total liabilities

$35 million

Interest expense

$2 million

Cash conversion cycle

13.5 days

Assuming 365 days in the calendar year, calculate Eagle's sales for the year.

A)   $57.8 million.

B)   $58.4 million.

C)   $52.3 million.

D)   $36.0 million.

The correct answer was B)

Set up the cash conversion cycle formula and solve for the missing variable, sales. Days in payables is equal to 73 [365 / 5 accounts payable turnover]. Days in inventory is equal to 36.5 [365 / ($30 million COGS / $3 million average inventory)]. Given the cash conversion cycle, days in inventory, and days in payables, calculate days in receivables of 50 [13.5 days cash conversion cycle + 73 days in payables – 36.5 days in inventory]. Given days in receivables of 50 and average receivables of $8 million, sales are $58.4 million [($8 million average receivables / 50 days) x 365].

 

5.Which of the following ratios would NOT measure liquidity?

A)   Quick Ratio.

B)   ROA.

C)   Cash Ratio.

D)   Current Ratio.

The correct answer was B)

ROA = (EBIT/average total assets) which measures management's ability and efficiency in using the firm's assets to generate operating profits. Other ratios that measure liquidity (if a company can pay its current bills) besides the quick, cash, and current ratios are the: receivables turnover, inventory turnover, and payables turnover ratios.

TOP

  Thanks

TOP

a

TOP

a

TOP

ADCBB

TOP

thnx

TOP

返回列表