Chapter 12, Problem 12.2APFA

1.

To determine

To complete:  Amount and columns to be used in a horizontal analysis of the income statements for Company AE

Explanation of Solution

Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage.

Following is the Amount and percentage columns to be used in a horizontal analysis of the income statements for Company AE for the Year Ended February 2, 2013.

Company AE
Comparative Income Statement
For the Year Ended February 2, 2013
			Increase (Decrease)
Particulars	2013 (A)	2012 (B)	Amount	Percentage
					Net sales	$3,475,802	$3,120,065	$355,737	11.40%
Less: Cost of sales	$2,085,480	$1,975,471	$110,009	5.57%
Gross profit	$1,390,322	$1,144,594	$245,728	21.47%
Less: Selling, General and administrative expenses	$834,601	$718,123	$116,478	16.22%
Loss on impairment	$34,869	$19,178	$15,691	81.82%
Depreciation	$126,246	$137,958	($11,712)	-8.49%
Operating income	$394,606	$269,335	$125,271	46.51%
Other income(expense) net	$7,432	$5,874	$1,558	26.52%
Income before taxes	$402,038	$275,209	$126,829	46.08%
Less: Income tax expense	$137,940	$99,930	$38,010	38.04%
Income from continuing operations	$264,098	$175,279	$88,819	50.67%
Less: Loss from discontinued operations	$31,990	$23,574	$8,416	35.70%
Net income	$232,108	$151,705	$80,403	53.00%

Table (1)

2.

To determine

To Calculate: The given risk ratios for Company AE for 2013.

Answer to Problem 12.2APFA

The given risks ratios for Company AE for 2013 are:

1. a. Receivables turnover ratio – 80.24 times
2. b. Average Collection period – 4.54 days
3. c. Inventory turnover ratio – 5.95 times
4. d. Average days in inventory – 61.34 days
5. e. Current ratio – 2.61:1
6. f. Acid-test ratio – 1.55:1
7. g. Debt to equity ratio – 43.79%

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 AE for 2013:

   $\begin{array}{c}\text{Receivables turnover ratio = }\frac{\text{Net Credit sales}}{\text{Average Accounts Receivables}}\\ =\frac{\$3,475,802}{\$43,315.5\left(1\right)}\\ =80.24\text{ times}\end{array}$

Determine the amount of average account receivables.

$\begin{array}{c}\text{Average account receivables }=\frac{\left(\begin{array}{l}\text{Opening account }\\ \text{receivables}\end{array}\right)+\left(\begin{array}{l}\text{Closing account}\\ \text{ receivables}\end{array}\right)}{2}\\ \text{=}\frac{\$40,310+\$46,321}{2}\\ =\frac{\$86,631}{2}\\ =\$43,315.5\end{array}$ (1)

1. b. Average collection period: This ratio is used to determine the number of days a particular company takes to collect accounts receivables.

Formula:

$\text{Average collection period}=\frac{\text{365 Days}}{\text{Receivables turnover ratio}}$

Calculate the average collection period for Company AE for 2013:

$\begin{array}{c}\text{Average collection period}=\frac{\text{365 Days}}{\text{Receivables turnover ratio}}\\ =\frac{\text{365 Days}}{80.24\text{ times}}\\ =4.54\text{ days}\end{array}$

1. c. 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 AE for 2013:

   $\begin{array}{c}\text{Inventory turnover ratio}=\frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}\\ =\frac{\$2,085,480}{\$349,983\left(2\right)}\\ =5.95\text{ times}\end{array}$

Determine the amount of average inventory.

$\begin{array}{c}\text{Average inventory }=\frac{\left(\text{Opening inventory}\right)+\left(\text{Closing inventory}\right)}{2}\\ \text{=}\frac{\$367,514+\$332,452}{2}\\ =\frac{\$699,966}{2}\\ =\$349,983\end{array}$ (2)

1. d. Average days in inventory: This ratio is determined as the number of days a particular company takes to make sales of the inventory available with them.

   Formula: $\text{Average days in inventory = }\frac{\text{365 days}}{\text{Inventory turnover ratio}}$

   Calculate the average days in inventory for Company AE for 2013:

   $\begin{array}{c}\text{Average days in inventory = }\frac{\text{365 days}}{\text{Inventory turnover ratio}}\\ =\frac{\text{365 days}}{\text{5}\text{.95}}\\ =61.34\text{ days}\end{array}$

2. e. 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 AE for 2013:

   $\begin{array}{c}\text{Current ratio = }\frac{\text{Current Assets}}{\text{Current Liabilities}}\\ =\frac{\$1,141,800}{\$435,902}\\ =2.61:1\end{array}$

3. f. Acid-test Ratio: It is a ratio used to determine a company’s ability to pay back its current liabilities by liquid assets that are current assets except inventory and prepaid expenses.

Formula:

$\text{Acid test}\text{Ratio}=\frac{\text{Cash }+\text{ Short-term investments + Accounts Receivables}}{\text{Current Liabilities}}$

Calculate the acid test ratio for Company AE for 2013:

$\begin{array}{c}\text{Acid test}\text{Ratio}=\frac{\text{Cash + Short-term investments + Accounts Receivables}}{\text{Current Liabilities}}\\ =\frac{\$\$509,119+\$121,873+\$46,321}{\$435,902}\\ =\frac{\$677,313}{\$435,902}\\ =1.55:1\end{array}$

1. g. 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 AE for 2013:

   $\begin{array}{c}\text{Debt to Equity Ratio}=\frac{\text{Total Liabilities }}{\text{Stockholder's Equity}}\\ =\frac{\$534,866}{\$1,221,187}\\ =43.79\%\end{array}$

3.

To determine

To Calculate: The given profitability ratios for Company AE for 2013.

Answer to Problem 12.2APFA

The given profitability ratios for Company AE for 2013 are:

1. a. Gross Profit ratio – 40.00%
2. b. Return on Assets ratio – 12.52%
3. c. Profit margin – 6.67%
4. d. Assets turnover ratio – 1.87 times
5. e. Return on Equity ratio –17.59%

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 AE for 2013:

   $\begin{array}{c}\text{Gross Profit ratio = }\frac{\text{Gross Profit}}{\text{Net Sales}}\times 100\\ =\frac{\$1,390,322}{\$3,475,802}\times 100\\ =40.00\%\end{array}$

2. 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 AE for 2013:

$\begin{array}{c}\text{Return on assets ratio}=\frac{\text{Net Income}}{\text{Average total assets}}\times 100\\ =\frac{\$232,108}{\$1,853,427.5\left(3\right)}\times 100\\ =12.52\%\end{array}$

Determine the amount of average total assets.

$\begin{array}{c}\text{Average total assets }=\frac{\left(\text{Opening total assets}\right)+\left(\text{Closing total assets}\right)}{2}\\ \text{=}\frac{\$1,950,802+\$1,756,053}{2}\\ =\frac{\$3,706,855}{2}\\ =\$1,853,427.5\end{array}$ (3)

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 sales}}$

   Calculate the profit margin ratio for Company AE for 2013:

   $\begin{array}{c}\text{Profit Margin ratio}=\frac{\text{Net income}}{\text{Net sales}}\\ =\frac{\$232,108}{\$3,475,802}\\ =6.67\%\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 AE for 2013:

   $\begin{array}{c}\text{Asset turnover }=\frac{\text{Net sales}}{\text{Average total assets}}\\ =\frac{\$3,475,802}{\$1,853,427.5\left(3\right)}\\ =1.87\text{ times}\end{array}$

3. e. Return on Equity ratio: Rate of return on equity ratio is used to determine the relationship between the net income available for the common stockholders’ and the average common equity that is invested in the company.

   Formula:

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

   Calculate the return on equity ratio for Company AE for 2013:

   $\begin{array}{c}\text{Return on equity ratio}=\frac{\text{Net Income}}{\text{Average stockholder's equity}}\times 100\\ =\frac{\$232,108}{\$1,319,019\left(4\right)}\times 100\\ =17.59\%\end{array}$

Determine the amount of average stockholders’ equity.

$\begin{array}{c}\text{Average stockholders' equity }=\frac{\left(\begin{array}{l}\text{Opening stockholders' }\\ \text{equity}\end{array}\right)+\left(\begin{array}{l}\text{Closing stockholders' }\\ \text{equity}\end{array}\right)}{2}\\ \text{=}\frac{\$1,416,851+\$1,221,187}{2}\\ =\frac{\$2,638,038}{2}\\ =\$1,319,019\end{array}$ (4)