Chapter 13, Problem 1ATC

a.1

To determine

Compute the current ratio for the companies’ 2012 fiscal years.

Explanation of Solution

Current ratio: Current ratio is one of the liquidity ratios, which measures the capacity of the company to meet its short-term obligations using its current assets. Current ratio is calculated by using the formula:

  $\text{Current ratio}=\frac{\text{Current assets}}{\text{Current liabilities}}$

The current ratio for the Company C is as follows:

$\begin{array}{c}\text{Current ratio}=\frac{\text{Current assets}}{\text{Current liabilities}}\\ =\frac{\$13,526}{\$12,260}\\ =1.10:1\end{array}$

The current ratio for the Company W is as follows:

$\begin{array}{c}\text{Current ratio}=\frac{\text{Current assets}}{\text{Current liabilities}}\\ =\frac{\$54,975}{\$62,300}\\ =0.88:1\end{array}$

Hence, the current ratio of the Company C and Company W is 1.10:1 and 0.88:1

a.2

To determine

Compute the average days to sell inventory for the companies’ 2012 fiscal years.

Explanation of Solution

Average days to sell inventory: This ratio is determined as the number of days a particular company takes to make sales of the inventory available with them. It is calculated by using the formula:

  $\begin{array}{l}\text{Average days }\\ \text{to sell inventory}\end{array}\}=\frac{\text{365}}{\text{Inventory turnover}}$

The average days to sell inventory for the Company C is as follows:

$\begin{array}{c}\begin{array}{l}\text{Average days }\\ \text{to sell inventory}\end{array}\}=\frac{\text{365}}{\text{Inventory turnover }\left(\text{Refer Table (2)}\right)}\\ =\frac{365}{12.64\text{ times}}\\ =29\text{ days}\end{array}$

The average days to sell inventory for the Company W is as follows:

$\begin{array}{c}\begin{array}{l}\text{Average days }\\ \text{to sell inventory}\end{array}\}=\frac{\text{365}}{\text{Inventory turnover }\left(\text{Refer Table (2)}\right)}\\ =\frac{365}{\text{8}\text{.70 times}}\\ =42\text{ days}\end{array}$

Hence, the average days to sell inventory of the Company C and Company W is 29 days and 42 days.

a.3

To determine

Compute the debt to asset ratio for the companies’ 2012 fiscal years.

Explanation of Solution

Debt to assets ratio: The debt to asset ratio shows the relationship between total asset and the total liability of the company. Debt ratio reflects the financial strategy of the company. It is used to measure the percentage of company’s assets that are financed by long term debts.  Debt to assets ratio is calculated by using the formula:

  $\text{Debt-to-assets ratio}=\frac{\text{Total liabilities}}{\text{Total assets }}$

The debt to asset ratio for the Company C is as follows:

$\begin{array}{c}\text{Debt-to-assets ratio}=\frac{\text{Total liabilities}}{\text{Total assets }}\\ =\frac{\$14,622}{\$27,140}\\ =54\%\end{array}$

The debt to asset ratio for the Company W is as follows:

$\begin{array}{c}\text{Debt-to-assets ratio}=\frac{\text{Total liabilities}}{\text{Total assets }}\\ =\frac{\$117,645}{\$193,406}\\ =61\%\end{array}$

Hence, the debt to asset ratio of the Company C and Company W is 54%and 61%.

a.4

To determine

Compute the return on investment for the companies’ 2012 fiscal years.

Explanation of Solution

Return on investments (assets): Return on investments (assets) is the financial ratio which determines the amount of net income earned by the business with the use of total assets owned by it. It indicates the magnitude of the company’s earnings with relative to its total assets. Return on investment is calculated as follows:

  $\text{Return on investments}=\frac{\left[\begin{array}{l}\text{Earnings from }\\ \text{continuing operations}\end{array}\right]}{\text{Average total assets}}$

The return on investments for the Company C is as follows:

$\begin{array}{c}\text{Return on investments}=\frac{\left[\begin{array}{l}\text{Earnings from }\\ \text{continuing operations}\end{array}\right]}{\text{Average total assets }\left(\text{Refer Table (3)}\right)}\\ =\frac{\$2,767}{\$26,950.5}\\ =10.3\%\end{array}$

The return on investments for the Company W is as follows:

$\begin{array}{c}\text{Return on investments}=\frac{\left[\begin{array}{l}\text{Earnings from }\\ \text{continuing operations}\end{array}\right]}{\text{Average total assets }\left(\text{Refer Table (3)}\right)}\\ =\frac{\$24,398}{\$187,034.5}\\ =13\%\end{array}$

Hence, the return on investments of the Company C and Company W is 10.3%and 13%.

a.5

To determine

Compute the gross margin percentage for the companies’ 2012 fiscal years.

Explanation of Solution

Gross margin percentage: It is one of the profitability ratios. Gross margin ratio is used to measure the percentage of gross profit that is being generated per dollar of revenue or sales. It is calculated by  using the formula::

  $\text{Gross margin percentage}=\frac{\text{Gross profit}}{\text{Net sales}}\times 100$

The gross margin percentage for the Company C is as follows:

$\begin{array}{c}\text{Gross margin percentage}=\frac{\text{Gross profit}}{\text{Net sales}}\times 100\\ =\frac{\$12,314}{\$99,137}\\ =12.4\%\end{array}$

The gross margin percentage for the Company W is as follows:

$\begin{array}{c}\text{Gross margin percentage}=\frac{\text{Gross profit}}{\text{Net sales}}\times 100\\ =\frac{\$111,823}{\$446,950}\\ =25.0\%\end{array}$

Hence, the gross margin percentage of the Company C and Company W is 12.4%and 25%.

a.6

To determine

Compute the asset turnover ratio for the companies’ 2012 fiscal years.

Explanation of Solution

Asset turnover: Turnover of assets is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets. Turnover of assets is calculated as follows:

  $\text{Asset turnover}=\frac{\text{Net sales }}{\text{Average total assets}}$

The asset turnover for the Company C is as follows:

$\begin{array}{c}\text{Asset turnover}=\frac{\text{Net sales }}{\text{Average total assets }\left(\text{Refer Table (3)}\right)}\\ =\frac{\$99,137}{\$26,950.5}\\ =3.7\text{ times}\end{array}$

The asset turnover for the Company W is as follows:

$\begin{array}{c}\text{Asset turnover}=\frac{\text{Net sales }}{\text{Average total assets }\left(\text{Refer Table (3)}\right)}\\ =\frac{\$446,950}{\$187,034.5}\\ =2.4\text{ times}\end{array}$

Hence, the asset turnover of the Company C and Company W is 3.7 times and 2.4 times.

a.7

To determine

Compute the return on asset for the companies’ 2012 fiscal years.

Explanation of Solution

Return on sales: It is one of the profitability ratios. Profit margin ratio is used to measure the percentage of net income that is being generated per dollar of revenue or sales. It is calculated by  using the formula:

  $\text{Return on sales}=\frac{\text{Net income}}{\text{Net sales}}$

The return on sales for the Company C is as follows:

$\begin{array}{c}\text{Return on sales}=\frac{\text{Net income}}{\text{Net sales}}\\ =\frac{\$2,767}{\$99,137}\\ =2.8\%\end{array}$

The return on sales the Company W is as follows:

$\begin{array}{c}\text{Return on sales}=\frac{\text{Net income}}{\text{Net sales}}\\ =\frac{\$24,398}{\$446,950}\\ =5.5\%\end{array}$

Hence, the return on sales of the Company C and Company W is 2.8% and 5.5%.

a.8

To determine

Compute the return on asset for the companies’ 2012 fiscal years.

Explanation of Solution

Plant assets to long term debt: Plant assets to long term debt ratio measure the value of assets per each dollar of long term liabilities. It is calculated by  using the formula:

  $\begin{array}{l}\text{Plant assets to }\\ \text{long term debt}\end{array}\}=\frac{\text{Plant assets}}{\text{Long term liabilities}}$

The plant assets to long term debt for the Company C is as follows:

$\begin{array}{c}\begin{array}{l}\text{Plant assets to }\\ \text{long term debt}\end{array}\}=\frac{\text{Plant assets}}{\text{Long term liabilities}}\\ =\frac{\$12,961}{\$2,362}\\ =5.5:1\end{array}$

The plant assets to long term debt for the Company W is as follows:

$\begin{array}{c}\begin{array}{l}\text{Plant assets to }\\ \text{long term debt}\end{array}\}=\frac{\text{Plant assets}}{\text{Long term liabilities}}\\ =\frac{\$112,324}{\$55,345}\\ =2.0:1\end{array}$

Hence, the plant assets to long-term debt of the Company C and Company W are 5.5:1 and 2.0:1.

Working Note:

Determine the average inventory for both the companies.

Table (2)

Determine the average total assets for both the companies.

Table (3)

b.

To determine

Identify the company that appears to be more profitable. Identify the ratio that reveals the profitability using requirement a. and justify the conclusion.

Explanation of Solution

The ratios that are most relevant for determining profitability are as follows:

1. 1) Return on investment: Return on investments (assets) is the financial ratio which determines the amount of net income earned by the business with the use of total assets owned by it. It indicates the magnitude of the company’s earnings with relative to its total assets.
2. 2) Return on sales: It is one of the profitability ratios. Profit margin ratio is used to measure the percentage of net income that is being generated per dollar of revenue or sales.

The return on investment and return on sales of Company W is 13% and 5.5% respectively, which is substantially higher than the profitability ratios of Company C.

c.

To determine

Identify the company that has higher level of financial risk. Identify the ratio that reveals the financial risk using requirement a. and justify the conclusion.

Explanation of Solution

The ratios that are most relevant for determining profitability are as follows:

1. 1) Current ratio: Current ratio is one of the liquidity ratios, which measures the capacity of the company to meet its short-term obligations using its current assets.
2. 2) Debt to assets ratio: The debt to asset ratio shows the relationship between total asset and the total liability of the company. Debt ratio reflects the financial strategy of the company. It is used to measure the percentage of company’s assets that are financed by long term debts. 
3. 3) Plant assets to long term debt: Plant assets to long term debt ratio measure the value of assets per each dollar of long term liabilities.

The current ratio, Debt to assets ratio and plant assets to long term debt of Company C is 1.10:1, 54% and 5.5:1 respectively,  which indicates that Company C is having higher level of financial risk .

d.

To determine

Identify the company that charges higher prices for the goods. Identify the ratio that reveals the information using requirement a. and justify the conclusion.

Explanation of Solution

The ratios that are most relevant for determining the cost of goods of both the companies is the gross margin percentage. The gross margin ratio is used to measure the percentage of gross profit that is being generated per dollar of revenue or sales. The gross margin of Company W is 25.0% that is significantly higher than Company C. higher gross margin indicates that Company W is charging the most of its goods with respect to what it pays for the items it sells.

e.

To determine

Identify the company that is efficiently using its assets. Identify the ratio that reveals the profitability using requirement a. and justify the conclusion.

Explanation of Solution

The ratios that are most relevant for determining the efficient utilization of assets are as follows:

1. 1) Average days to sell inventory: This ratio is determined as the number of days a particular company takes to make sales of the inventory available with them.
2. 2) Asset turnover: Turnover of assets is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets

The average days to sell inventory of Company C is 29 days which indicates that Company C is utilizing the inventory efficiently than Company W. However, the asset turnover of Company C is 3.7 times whereas of Company W is 2.4 times, that indicates the efficiency of Company C to earn higher turnover using its total assets.