Chapter 12, Problem 12.6BP

1.

To determine

To Calculate: The given risk ratios for Company TAA for 2018 & 2019.

Answer to Problem 12.6BP

The given risky ratios for Company TAA for 2018:

1. a. Receivables turnover ratio – 11.1 times
2. b. Inventory turnover ratio – 4.4 times
3. c. Current ratio – 15.9:1
4. d. Debt to equity ratio – 30.9%

The given risky ratios for Company TAA for 2019:

1. a. Receivables turnover ratio – 11.7 times
2. b. Inventory turnover ratio – 4.3 times
3. c. Current ratio – 14.0:1
4. d. Debt to equity ratio – 25.2%

Explanation of Solution

Risk Ratios: Risk ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company. The following are the ratios that evaluate the risk of a company:

1. a. Receivables turnover ratio: Receivables turnover ratio is mainly used to evaluate the collection process efficiency. It helps the company to know the number of times the accounts receivable is collected in a particular time period. This ratio is determined by dividing credit sales and sales return. It is calculated by using the following formula:

   $\text{Receivables turnover ratio = }\frac{\text{Net Credit sales}}{\text{Average Accounts Receivables}}\times 100$

Calculate the receivables turnover ratio for Company TAA for 2018:

$\begin{array}{c}\text{Receivables turnover ratio = }\frac{\text{Net Credit sales}}{\text{Average Accounts Receivables}}\\ =\frac{\$8,900,000}{\left(\$810,000+\$790,000\right)/2}\\ =\frac{\$8,900,000}{\$1,600,000/2}\\ =\frac{\$8,900,000}{\$800,000}\\ =11.1\text{ times}\end{array}$

Calculate the receivables turnover ratio for Company TAA for 2019:

$\begin{array}{c}\text{Receivables turnover ratio = }\frac{\text{Net Credit sales}}{\text{Average Accounts Receivables}}\\ =\frac{\$10,400,000}{\left(\$790,000+\$990,000\right)/2}\\ =\frac{\$10,400,000}{\$1,780,000/2}\\ =\frac{\$10,400,000}{\$890,000}\\ =11.7\text{ times}\end{array}$

1. b. Inventory Turnover Ratio: This ratio is a financial metric used by a company to quantify the number of times inventory is used or sold during the accounting period.

   Formula: $\text{Inventory turnover ratio}=\frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}$

Calculate the inventory turnover ratio for Company TAA for 2018:

$\begin{array}{c}\text{Inventory turnover ratio}=\frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}\\ =\frac{\$5,450,000}{\left(\$1,075,000+\$1,405,000\right)/2}\\ =\frac{\$5,450,000}{\$2,480,000/2}\\ =\frac{\$5,450,000}{\$1,240,000}\\ =4.4\text{times}\end{array}$

Calculate the inventory turnover ratio for Company TAA for 2019:

$\begin{array}{c}\text{Inventory turnover ratio}=\frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}\\ =\frac{\$6,800,000}{\left(\$1,405,000+\$1,725,000\right)/2}\\ =\frac{\$6,800,000}{\$3,130,000/2}\\ =\frac{\$6,800,000}{\$1,565,000}\\ =4.3\text{ times}\end{array}$

1. c. Current ratio: Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.

   Formula:

   $\text{Current ratio = }\frac{\text{Current Assets}}{\text{Current Liabilities}}$

Calculate the current ratio for Company TAA for 2018:

$\begin{array}{c}\text{Current ratio = }\frac{\text{Current Assets}}{\text{Current Liabilities}}\\ =\frac{\$2,469,000}{\$155,000}\\ =15.9:1\end{array}$

Calculate the current ratio for Company TAA for 2019:

$\begin{array}{c}\text{Current ratio = }\frac{\text{Current Assets}}{\text{Current Liabilities}}\\ =\frac{\$3,070,000}{\$219,000}\\ =14.0:1\end{array}$

1. d. Debt to equity Ratio: Debt to equity ratio is used by the company to determine how well the company is able to survive the losses without damaging the creditors’ interest. It is determined by dividing total debt and total equity. 

Formula:

$\text{Debt to Equity Ratio}=\frac{\text{Total Liabilities }}{\text{Stockholder's Equity}}$

Calculate the debt to equity ratio for Company TAA for 2018:

$\begin{array}{c}\text{Debt to Equity Ratio}=\frac{\text{Total Liabilities }}{\text{Stockholder's Equity}}\\ =\frac{\$755,000}{\$2,444,000}\\ =30.9\%\end{array}$

Calculate the debt to equity ratio for Company TAA for 2019:

$\begin{array}{c}\text{Debt to Equity Ratio}=\frac{\text{Total Liabilities }}{\text{Stockholder's Equity}}\\ =\frac{\$719,000}{\$2,851,000}\\ =25.2\%\end{array}$

2.

To determine

To Calculate: The given profitability ratios for Company TAA for 2018 & 2019.

Answer to Problem 12.6BP

The given profitability ratios for Company TAA for 2018 are:

1. a. Gross Profit ratio – 38.8%
2. b. Return on Assets ratio – 38.9%
3. c. Profit margin – 13.8%
4. d. Assets turnover ratio – 2.8 times

The given profitability ratios for Company TAA for 2019 are:

1. a. Gross Profit ratio – 34.6%
2. b. Return on Assets ratio – 40.2%
3. c. Profit margin – 13.1%
4. d. Assets turnover ratio – 3.1 times

Explanation of Solution

Profitability ratios: In general, financial ratios are used to evaluate capabilities, profitability, and overall performance of a company. The following are the ratios that evaluate the profitability of a company:

1. a. Gross Profit ratio: Gross profit ratio is the financial ratio that shows the relationship between the gross profit and net sales. Gross profit is the difference between the total revenues and cost of goods sold. It is calculated by using the following formula:

   $\text{Gross Profit ratio = }\frac{\text{Gross Profit}}{\text{Net Sales}}\times 100$

   Calculate the gross profit ratio for Company TAA for 2018:

   $\begin{array}{c}\text{Gross Profit ratio = }\frac{\text{Gross Profit}}{\text{Net Sales}}\times 100\\ =\frac{\$3,450,000}{\$8,900,000}\times 100\\ =38.8\%\end{array}$

Calculate the gross profit ratio for Company TAA for 2019:

$\begin{array}{c}\text{Gross Profit ratio = }\frac{\text{Gross Profit}}{\text{Net Sales}}\times 100\\ =\frac{\$3,600,000}{\$10,400,000}\times 100\\ =34.6\%\end{array}$

1. b. Return on asset ratio: Rate of return on total assets measures the profit generated from the use of total assets.

Formula:

$\text{Return on assets ratio}=\frac{\text{Net Income}}{\text{Average total assets}}$

Calculate the return on asset ratio for Company TAA for 2018:

$\begin{array}{c}\text{Return on assets ratio}=\frac{\text{Net Income}}{\text{Average total assets}}\times 100\\ =\frac{\$1,230,000}{\left(\$3,124,000+\$3,199,000\right)/2}\times 100\\ =\frac{\$1,230,000}{\$6,323,000/2}\times 100\\ =\frac{\$1,230,000}{\$3,161,500}\times 100\\ =38.9\%\end{array}$

Calculate the return on asset ratio for Company TAA for 2019:

$\begin{array}{c}\text{Return on assets ratio}=\frac{\text{Net Income}}{\text{Average total assets}}\times 100\\ =\frac{\$1,360,000}{\left(\$3,199,000+\$3,570,000\right)/2}\times 100\\ =\frac{\$1,360,000}{\$6,769,000/2}\times 100\\ =\frac{\$1,360,000}{\$3,384,500}\times 100\\ =40.2\%\end{array}$

1. c. Profit margin: Profit margin ratio is used to determine the percentage of net income that is being generated per dollar of revenue or sales.

   Formula: $\text{Profit Margin}=\frac{\text{Net income}}{\text{Net revenue}}$

   Calculate the profit margin ratio for Company TAA for 2018:

   $\begin{array}{c}\text{Profit Margin ratio}=\frac{\text{Net income}}{\text{Net revenue}}\\ =\frac{\$1,230,000}{\$3,086,000}\\ =13.8\%\end{array}$

   Calculate the profit margin ratio for Company TAA for 2019:

   $\begin{array}{c}\text{Profit Margin ratio}=\frac{\text{Net income}}{\text{Net revenue}}\\ =\frac{\$1,360,000}{\$10,400,000}\\ =13.1\%\end{array}$

2. d. Assets turnover ratio: Asset turnover ratio is used to determine the asset’s efficiency towards sales.

   Formula: $\text{Asset turnover }=\frac{\text{Net}\text{revenue}}{\text{Average total assets}}$

   Calculate the assets turnover ratio for Company TAA for 2018:

   $\begin{array}{c}\text{Asset turnover }=\frac{\text{Net}\text{revenue}}{\text{Average total assets}}\\ =\frac{\$8,900,000}{\left(\$3,124,000+\$3,199,000\right)/2}\\ =\frac{\$8,900,000}{\$6,323,000/2}\\ =\frac{\$8,900,000}{\$3,161,500}\\ =2.8\text{ times}\end{array}$

   Calculate the assets turnover ratio for Company TAA for 2019:

   $\begin{array}{c}\text{Asset turnover }=\frac{\text{Net}\text{revenue}}{\text{Average total assets}}\\ =\frac{\$10,400,000}{\left(\$3,199,000+\$3,570,000\right)/2}\\ =\frac{\$10,400,000}{\$6,769,000/2}\\ =\frac{\$10,400,000}{\$3,384,500}\\ =3.1\text{ times}\end{array}$

3.

To determine

whether overall risk and profitability ratios are improved from 2018 to 2019.

Explanation of Solution

Regarding risk, the receivables turnover slightly improved and the debt to equity ratio has been declined, where both are positive signs. However, the inventory turnover ratio and current ratio both declined in 2019.

Profitability ratios are mixed. While net income has been increased by $130,000 in 2019, the gross profit ratio has declined from 38.8% to 34.6%. Return on assets has increased, profit margin has declined, and asset turnover has been improved.