Chapter 13, Problem 13.3DIE

(a)

To determine

Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.

To compute: Current ratio for 2017 and 2016

Answer to Problem 13.3DIE

Current ratio for 2017

$\begin{array}{c}\text{Current}\text{ratio}=\frac{\text{Current}\text{assets}}{\text{Current}\text{liabilities}}\\ =\frac{\text{\$1,380}}{\text{\$900}}\\ =\text{1}\text{.53:1}\end{array}$

Current ratio for 2016

$\begin{array}{c}\text{Current}\text{ratio}=\frac{\text{Current}\text{assets}}{\text{Current}\text{liabilities}}\\ =\frac{\text{\$1,310}}{\text{\$790}}\\ =\text{1}\text{.66:1}\end{array}$

Explanation of Solution

Given info: Balance sheet and income statement

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}\text{liabilities}}$

Conclusion

Hence, current ratio for 2017 and 2016 is 1.53:1 and 1.66:1 respectively. It has decreased in the year 2017.

(b)

To determine

To compute:  Inventory turnover ratio for 2017 and 2016

Answer to Problem 13.3DIE

Inventory turnover ratio for 2017

$\begin{array}{c}\text{Inventory}\text{turnover}\text{ratio}=\frac{\text{Cost}\text{of}\text{goods}\text{sold}}{\text{Average}\text{inventory}}\\ =\frac{\text{\$955}}{\text{\$425}}\\ =\text{2}\text{.25 times}\end{array}$

Inventory turnover ratio for 2016

$\begin{array}{c}\text{Inventory}\text{turnover}\text{ratio}=\frac{\text{Cost}\text{of}\text{goods}\text{sold}}{\text{Average}\text{inventory}}\\ =\frac{\text{\$890}}{\text{\$365 }\left(\text{Step 1}\right)}\\ =\text{2}\text{.44 times}\end{array}$

Explanation of Solution

Given info: Balance sheet and income statement

Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period.

Formula:

$\text{Inventory turnover}=\frac{\text{Cost of goods sold}}{\text{Average inventory}}$

Average inventory for 2016 and 2015 is determined as follows:

Average inventory for 2016

$\begin{array}{c}\text{Average inventory}=\frac{\text{Opening}\text{inventory}+\text{Closing}\text{inventory}}{\text{2}}\\ =\frac{\$390+\$460}{2}\\ =\$425\end{array}$

Average inventory for 2015

$\begin{array}{c}\text{Average inventory}=\frac{\text{Opening}\text{inventory}+\text{Closing}\text{inventory}}{\text{2}}\\ =\frac{\text{\$340}+\text{\$390}}{\text{2}}\\ =\text{\$365}\end{array}$

Conclusion

Hence, inventory turnover ratio for 2017 and 2016 is 2.25 times and 2.44 times respectively. In the year 2016, it has decreased.

(c)

To determine

To compute:  Profit margin for 2017 and 2016

Answer to Problem 13.3DIE

Profit margin ratio for 2017

$\begin{array}{c}\text{Profit margin ratio}=\frac{\text{Net}\text{income}}{\text{Net}\text{sales}}\\ =\frac{\text{\$294}}{\text{\$3,800}}\\ =7.\text{7\%}\end{array}$

Profit margin ratio for 2016

$\begin{array}{c}\text{Profit margin ratio}=\frac{\text{Net}\text{income}}{\text{Net}\text{sales}}\\ =\frac{\text{\$154}}{\text{\$3,460}}\\ =4.5\text{\%}\end{array}$

Explanation of Solution

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}\text{income}}{\text{Net}\text{revenue}}$

Conclusion

Hence, profit margin ratio for 2017 and 2016 is 7.7% and 4.5% respectively. This ratio has increased because net income is increased.

(d)

To determine

To compute:  Return on assets for 2017 and 2016

Answer to Problem 13.3DIE

Return on assets ratio for 2017

$\begin{array}{c}\text{Return}\text{on}\text{assets}=\frac{\text{Net}\text{income}}{\text{Average}\text{assets}}\\ =\frac{\text{\$294}}{\text{\$2,275}\left(\text{Step}\text{1}\right)}\\ =12.\text{9\%}\end{array}$

Return on assets ratio for 2016

$\begin{array}{c}\text{Return}\text{on}\text{assets}=\frac{\text{Net}\text{income}}{\text{Average}\text{assets}}\\ =\frac{\text{\$154}}{\text{\$2,055}}\\ =7.5\text{\%}\end{array}$

Explanation of Solution

Return on assets determines the particular company’s overall earning power.

Formula:

$\text{Rate of return on assets}=\frac{\text{Net}\text{income + Interest expense}}{\text{Average total assets}}$

Average total assets are determined by dividing opening and closing total assets by 2. It is calculated as follows:

Average assets for 2017

$\begin{array}{c}\text{Average assets}=\frac{\text{Opening}\text{balance}\text{of}\text{assets}+\text{Closing}\text{balance}\text{of}\text{assets}}{\text{2}}\\ =\frac{\text{\$2,210}+\text{\$2,340}}{\text{2}}\\ =\text{\$2,275}\end{array}$

Average assets for 2016

$\begin{array}{c}\text{Average assets}=\frac{\text{Opening}\text{balance}\text{of}\text{assets}+\text{Closing}\text{balance}\text{of}\text{assets}}{\text{2}}\\ =\frac{\text{\$1,900}+\text{\$2,210}}{\text{2}}\\ =\text{\$2,055}\end{array}$

Conclusion

Hence, rate of return on assets for 2017 and 2016 is 12.9% and 7.5% respectively. This ratio has increased because net income is increased.

(e)

To determine

To compute:  Return on common stockholders’ equity for 2017 and 2016

Answer to Problem 13.3DIE

Return on stockholders’ equity for 2017

$\begin{array}{c}\begin{array}{l}\text{Return}\text{on}\text{common}\\ \text{stockholders'}\text{equity}\end{array}\}=\frac{\text{Net}\text{income}}{\text{Average}\text{stockholders' equity }}\\ =\frac{\text{\$294}}{\text{\$1,035}}\\ =\text{28}\text{.4\%}\end{array}$

Return on stockholders’ equity for 2016

$\begin{array}{c}\begin{array}{l}\text{Return}\text{on}\text{common}\\ \text{stockholders'}\text{equity}\end{array}\}=\frac{\text{Net}\text{income}}{\text{Average}\text{stockholders'}\text{equity}}\\ =\frac{\text{\$154}}{\text{\$970}\left(\text{Step 2}\right)}\\ =15.9\text{\%}\end{array}$

Explanation of Solution

Explanation

Rate of return on stockholders’ equity is used to determine the relationship between the net income and the average common equity that are invested in the company.

Formula: $\text{Rate of return }=\frac{\text{Net income }-\text{Preferred dividends}}{\text{Average common stockholder’s equity}}$

Average common stockholders’ equity is determined by dividing opening and closing total common stockholders’ equity by 2. It is calculated as follows:

Average common stockholders’ equity for 2017

$\begin{array}{c}\begin{array}{l}\text{Average common}\\ \text{stockholders equity}\end{array}\}=\frac{\left(\begin{array}{l}\text{Opening}\text{balance}\text{of common stockholders' equity }\\ +\text{Closing balance of common stockholders' equity}\end{array}\right)}{\text{2}}\\ =\frac{\text{\$1,040}\text{+}\text{\$1,030}}{\text{2}}\\ =\text{\$1,035}\end{array}$

Average common stockholders’ equity for 2016

$\begin{array}{c}\begin{array}{l}\text{Average common}\\ \text{stockholders equity}\end{array}\}=\frac{\left(\begin{array}{l}\text{Opening}\text{balance}\text{of common stockholders' equity }\\ +\text{Closing balance of common stockholders' equity}\end{array}\right)}{\text{2}}\\ =\frac{\text{\$900}+\text{\$1,040}}{\text{2}}\\ =\text{\$970}\end{array}$

Conclusion

Hence, rate of return on stockholders’ equity for 2017 and 2016 is 28.4% and 15.9% respectively.

(f)

To determine

To compute:  Debt to asset ratio for 2017 and 2016

Answer to Problem 13.3DIE

Debt to Total Assets Ratio for 2017

$\begin{array}{c}\text{Debt}\text{to}\text{total}\text{assets}\text{ratio}=\frac{\text{Total}\text{debt}}{\text{Total assets}}\\ =\frac{\text{\$1,310 }}{\text{\$2,340}}\\ =55.98\%\end{array}$

Debt to Total Assets Ratio for 2016

$\begin{array}{c}\text{Debt}\text{to}\text{total}\text{assets}\text{ratio}=\frac{\text{Total}\text{debts}}{\text{Total assets}}\\ =\frac{\text{\$1,170}}{\text{\$2,210}}\\ =52.94\%\end{array}$

Explanation of Solution

Explanation

Debt to asset 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 assets.

Formula:

$\begin{array}{l}\text{Debt to assets}\\ \text{ratio}\end{array}\}\text{=}\frac{\text{Total debt}}{\text{Total assets}}$

Total debt is determined by adding total current liabilities and total long-term liabilities.

Total debt for 2017

$\begin{array}{c}\text{Total debt}=\left(\text{Total current liabilities}+\text{Total long}-\text{term liabilities}\right)\\ =\$\text{9}00+\$\text{41}0\\ =\$\text{1},\text{31}0\end{array}$

Total debt for 2016

$\begin{array}{c}\text{Total debt}=\left(\text{Total current liabilities}+\text{total long}-\text{term liabilities}\right)\\ =\$\text{79}0+\$\text{38}0\\ =\$\text{1},\text{17}0\end{array}$

Conclusion

Hence, debt to total assets for 2017 and 2016 is 28.4% and 15.9% respectively.

(g)

To determine

To compute: Times interest earned for 2017 and 2016

Answer to Problem 13.3DIE

Times interest earned ratio for 2017

$\begin{array}{c}\text{Times interest earned}=\frac{\text{Interest before income tax and interest expense}}{\text{Interest expense}}\\ =\frac{\text{\$445}}{\text{\$25}}\\ =17.8\text{times}\end{array}$

Times interest earned ratio for 2016

$\begin{array}{c}\text{Times interest earned}=\frac{\text{Interest before income tax and interest expense}}{\text{Interest expense}}\\ =\frac{\text{\$240}\left(\text{Step 1}\right)}{\text{\$20}}\\ =12\text{times}\end{array}$

Explanation of Solution

Times - interest earned ratio quantifies the number of times the earnings before interest and taxes can pay the interest expense.

Formula:

$\begin{array}{l}\text{Times-interest-earned}\\ \text{ratio }\end{array}\}=\frac{\text{Net income}+\text{Income tax expense}+\text{Interest expense}}{\text{Interest expense}}$

Income before income tax and interest expense is the sum of income before tax and interest expense.

Income before income tax and interest expense for 2017

$\begin{array}{c}\text{Income before income tax and interest expense}=\left(\text{Income before tax}+\text{interest expenses}\right)\\ =\$\text{42}0+\$25\\ =\$\text{445}\end{array}$

Income before income tax and interest expense for 2016

$\begin{array}{c}\text{Income before income tax and interest expense}=\left(\text{Income before tax}+\text{interest expenses}\right)\\ =\$\text{22}0+\$\text{2}0\\ =\$\text{24}0\end{array}$

Conclusion

Hence, times interest earned ratio for 2017 and 2016 is 17.8 times and 12 times respectively. Company’s ability towards payment of interest has increased in the year 2017.