Chapter 14, Problem 14.4APR

Measures of liquidity, solvency, and profitability

The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $82.60 on December 31, 20Y2.

Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31,20Y2 and 20Y1
	20Y2	20Y1
Retained earnings, January 1	$3,704,000	$3,264,000
Net income	600,000	550,000
Total	$4,304,000	$3,814,000
Dividends:
On preferred stock	$ 10,000	$ 10,000
On common stock	100,000	100,000
Total dividends	$ 110,000	$ 110,000
Retained earnings, December 31	$4,194,000	$3,704,000
Sales	$10,850,000	$10,000,000
Cost of goods sold	6,000,000	5,450,000
Gross profit	$ 4,850,000	$ 4,550,000
Selling expenses	$ 2,170,000	$ 2,000,000
Administrative expenses	1,627,500	1,500,000
Total operating expenses	$ 3,797,500	$ 3,500,000
Income from operations	$ 1,052,500	$ 1,050,000
Other income	99,500	20,000
	$ 1,152,000	$ 1,070,000
Other expense (interest)	132,000	120,000
Income before income tax	$ 1,020,000	$ 950,000
Income tax expense	420,000	400,000
Net income	$ 600,000	$ 550,000

Marshall Inc. Comparative Balance Sheet December 31,20Y2 and 20Y1
	20Y2	20Y1
Assets
Current assets:
Cash	$1,050,000	$ 950,000
Marketable securities	301,000	420,000
Accounts receivable (net)	585,000	500,000
Inventories	420,000	380,000
Prepaid expenses	108,000	20,000
Total current assets	$ 2,464,000	$2,270,000
Long-term investments	800,000	800,000
Property, plant, and equipment (net)	5,760,000	5,184,000
Total assets	$ 9,024,000	$8,254,000
Liabilities
Current liabilities	$ 880,000	$ 800,000
Long-term liabilities:
Mortgage note payable. 6%	$ 200,000	$ 0
Bonds payable. 4%,	3,000,000	3,000,000
Total long term liabilities	$ 3,200,000	$3,000,000
Total liabilities	$ 4,080,000	$3,800,000
Stockholders' Equity
Preferred 4% stock, $5 par	$ 250,000	$ 250,000
Common stock. $5 par	500,000	500,000
Retained earnings	4,194,000	3,704,000
Total stockholders' equity	$ 4,944,000	$4,454,000
Total liabilities and stockholders' equity	$ 9,024,000	$8,254,000

Instructions

Determine the following measures for 20Y2 (round to one decimal place, including percentages, except for per-share amounts):

1. 1. Working capital
2. 2. Current ratio
3. 3. Quick ratio
4. 4. Accounts receivable turnover
5. 5. Number of days' sales in receivables
6. 6. Inventory turnover
7. 7. Number of days' sales in inventory
8. 8. Ratio of fixed assets to long-term liabilities
9. 9. Ratio of liabilities to stockholders' equity
10. 10. Times interest earned
11. 11. Asset turnover
12. 12. Return on total assets
13. 13. Return on stockholders' equity
14. 14. Return on common stockholders' equity
15. 15. Earnings per share on common stock
16. 16. Price-earnings ratio
17. 17. Dividends per share of common stock
18. 18. Dividend yield

To determine

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

Explanation of Solution

Working capital

$\begin{array}{c}\text{Working capital = Current assets – }\text{}\text{Current liabilities }\\ \text{= \$2,464,000 – \$880,000}\\ \text{= \$1,584,000}\end{array}$

Working capital is determined as the difference between current assets and current liabilities.

Formula:

$\text{Working capital = Current assets – }\text{}\text{Current liabilities }$

To determine

The current ratio of M Incorporation.

Explanation of Solution

Current ratio

$\begin{array}{c}\text{Current ratio}=\frac{\text{Current assets}}{\text{Current}\text{liabilities}}\\ =\frac{\text{\$2,464,000}}{\text{\$880,000}}\\ =2.8\end{array}$

Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.  Current assets include cash and cash equivalents, short-term investments, net, accounts and notes receivables, net, inventories, and prepaid expenses and other current assets. Current liabilities include short-term obligations and accounts payable.

Formula:

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

To determine

The quick ratio of M Incorporation

Explanation of Solution

.Quick ratio

$\begin{array}{c}\text{Quick ratio }=\frac{\text{Quick assets }}{\text{Current}\text{liabilities}}\\ =\frac{\$1,936,000}{\$880,000}\\ =2.2\end{array}$

Acid-Test Ratio is the ratio denotes that this ratio is a more rigorous test of solvency than the current ratio. It is determined by dividing quick assets and current liabilities. The acceptable acid-test ratio is 0.90 to 1.00. It is referred as quick ratio. Use the following formula to determine the acid-test ratio:

$\text{Acid Ratio}=\frac{\text{Quick assets}}{\text{Current}\text{liabilities}}$

To determine

Accounts receivable turnover for M Incorporation

Explanation of Solution

Accounts receivable turnover

$\begin{array}{c}\begin{array}{l}\text{Accounts receivables}\\ \text{ turnover ratio}\end{array}\}=\frac{\text{Net credit sales}}{\text{Average accounts receivables}}\\ =\frac{\$10,850,000}{\$542,500}\\ =20.0\end{array}$

Accounts 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. Main purpose of accounts receivable turnover ratio is to manage the working capital of the company. This ratio is determined by dividing credit sales and sales return.

Formula:

$\begin{array}{l}\text{Accounts receivables}\\ \text{ turnover ratio}\end{array}\}=\frac{\text{Net credit sales}}{\text{Average accounts receivables}}$

Average accounts receivable is determined as follows:

$\begin{array}{c}\begin{array}{l}\text{Average accounts }\\ \text{receivables }\end{array}\}\text{= }\frac{\left(\begin{array}{l}\text{Opening accounts receivables }\\ \text{+ Closing accounts receivables }\end{array}\right)}{2}\\ =\frac{\$585,000+\$500,000}{2}\\ =\$542,500\end{array}$

To determine

 To determine: Number of days’ sales in receivables of M Incorporation.

Explanation of Solution

Number of days’ sales in receivables

$\begin{array}{c}\begin{array}{l}\text{Number of days’ sales }\\ \text{in receivable }\end{array}\}=\frac{\text{Average accounts receivable }}{\text{Average daily sales}}\\ =\frac{\$542,500}{29,726.02}\\ =18.3\text{days}\end{array}$

Number of days’ sales in receivables is used to determine the number of days a particular company takes to collect accounts receivables.

Formula:

$\text{Number of days’ sales in receivable}\text{=}\frac{\text{Average accounts receivable }}{\text{Average daily sales}}$

Average daily sales are determined by dividing sales by 365 days.

$\begin{array}{c}\text{Average daily sales = }\frac{\text{Sales}}{\text{365}\text{days}}\\ =\frac{\$10,850,000}{365\text{days}}\\ =\$29,726.02\end{array}$

To determine

Inventory turnover ratio for M Incorporation

Explanation of Solution

$\begin{array}{c}\text{Inventory turnover ratio }=\frac{\text{Cost of goods sold}}{\text{Average inventory}}\\ =\frac{\$6,000,000}{\$400,000}\\ =15.0\text{times}\end{array}$

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 is determined as below:

$\begin{array}{c}\text{Average inventory = }\frac{\left(\text{Opening inventory + Closing inventory }\right)}{2}\\ =\frac{\$420,000+\$380,000}{2}\\ =\$400,000\end{array}$

To determine

Number of days sales in inventory ratio of M Incorporation

Explanation of Solution

Number of days sales in inventory ratio

$\begin{array}{c}\begin{array}{l}\text{Number of days’ }\\ \text{sales in inventory }\end{array}\}=\frac{\text{Average inventory }}{\text{Average daily cost of goods sold}}\\ =\frac{\$400,000}{\$16,438.35}\\ =24.3\text{days}\end{array}$

Number of days’ sales in inventory is determined as the number of days a particular company takes to make sales of the inventory available with them.

Formula:

$\text{ Number of days’ sales in invenotry}=\frac{\text{Average inventory }}{\text{Average daily cost of goods sold}}$

Average daily cost of goods sold are determined by dividing cost of goods sold by 365 days. Thus, average daily cost of goods sold are determined as follows:

$\begin{array}{c}\text{Average daily cost of goods sold= }\frac{\text{Cost of goods sold}}{\text{365}\text{days}}\\ =\frac{\$6,000,000}{365\text{days}}\\ =\$16,438.35\end{array}$

To determine

Ratio of fixed assets to long-term liabilities

Explanation of Solution

$\begin{array}{c}\text{Ratio of fixed assets to long-term liabilities}=\frac{\text{Fixed assets }}{\text{Long-term liabilities }}\\ =\frac{\$5,760,000}{\$3,200,000}\\ =1.8\end{array}$

Ratio of fixed assets to long-term liabilities is determined by dividing fixed assets and long-term liabilities.

Formula:

$\text{Ratio of fixed assets to long-term liabilities}=\frac{\text{Fixed assets }}{\text{Long-term liabilities }}$

To determine

Ratio of liabilities to stockholders’ equity

Explanation of Solution

 Ratio of liabilities to stockholders’ equity

$\begin{array}{c}\begin{array}{l}\text{Ratio of liabilities }\\ \text{to stockholders' equity }\end{array}\}=\frac{\text{Total liabilities}}{\text{Stockholders' equity}}\\ =\frac{\$4,080,000}{\$4,944,000}\\ =0.8\end{array}$

Ratio of liabilities to stockholders’ equity is determined by dividing liabilities and stockholders’ equity.

Formula:

$\text{ Ratio of liabilities to stockholders' equity}=\frac{\text{Total liabilities}}{\text{Stockholders' equity}}$

To determine

Times interest earned ratio

Explanation of Solution

 Times interest earned ratio

$\begin{array}{c}\begin{array}{l}\text{Times-interest-}\\ \text{earned ratio }\end{array}\}=\frac{\text{Income before income tax}+\text{Interest expense}}{\text{Interest expense}}\\ =\frac{\$1,020,000+\$132,000}{\$132,000}\\ =8.5\%\end{array}$

Times interest earned ratio quantifies the number of times the earnings before interest and taxes can pay the interest expense. First, determine the sum of income before income tax and interest expense. Then, divide the sum by interest expense.

Formula:

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

To determine

Asset turnover ratio

Explanation of Solution

Asset turnover ratio

$\begin{array}{c}\text{Asset turnover ratio }=\frac{\text{Sales}}{\text{Average total assets}}\\ =\frac{\$10,850,000}{\$8,639,000}\\ =1.3\end{array}$

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

Working notes for average total assets are as follows:

$\begin{array}{c}\text{Average total assets =}\frac{\text{Beginning total assets + Ending total assets }}{2}\\ =\frac{\$9,024,000+\$8,254,000}{2}\\ =\$8,639,000\end{array}$

To determine

Return on total assets

Explanation of Solution

Return on total assets

$\begin{array}{c}\text{Return on total assets}=\frac{\text{Net}\text{income + Interest expense}}{\text{Average total assets}}\\ =\frac{\$600,000+\$132,000}{\$8,639,000}\\ =8.5\%\end{array}$

Return on assets determines the particular company’s overall earning power. It is determined by dividing sum of net income and interest expense and average total assets.

Formula:

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

To determine

Return on stockholders’ equity

Explanation of Solution

Return on stockholders’ equity

$\begin{array}{c}\begin{array}{l}\text{Return on }\\ \text{stockholders' equity}\end{array}\}=\frac{\text{Net income }}{\text{Average stockholder’s equity}}\\ =\frac{\$600,000}{\$4,699,000}\\ =12.8\%\end{array}$

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

Formula: $\text{Rate of return on stockholders' equtiy }=\frac{\text{Net income}}{\text{Average stockholder’s equity}}$

Average stockholders’ equity is determined as follows:

$\begin{array}{c}\text{Average stockholders' equity =}\left(\frac{\begin{array}{l}\text{Beginning stockholders' equity }\\ \text{ + Ending stockholders' equity }\end{array}}{2}\right)\\ =\frac{\$4,944,000+\$4,454,000}{2}\\ =\$4,699,000\end{array}$

To determine

Return on common stockholders’ equity

Explanation of Solution

Return on common stockholders’ equity

$\begin{array}{c}\begin{array}{l}\text{Return on common }\\ \text{stockholders' equity}\end{array}\}=\frac{\text{Net income – Preferred dividends }}{\text{Average stockholder’s equity}}\\ =\frac{\$600,000–\$10,000}{\$4,699,000}\\ =13.3\%\end{array}$

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 on common stockholders' equtiy }=\frac{\text{Net income – Preferred dividends }}{\text{Average common stockholder’s equity}}$

Average common stockholders’ equity is determined as follows:

$\begin{array}{c}\text{Average stockholders' equity =}\left(\frac{\begin{array}{l}\text{Beginning common stockholders' equity }\\ \text{ + Ending common stockholders' equity }\end{array}}{2}\right)\\ =\frac{\$4,694,000+\$4,204,000}{2}\\ =\$4,449,000\end{array}$

To determine

To determine: Earnings per share on common stock

Explanation of Solution

Earnings per share on common stock

$\begin{array}{c}\text{Earnings per share=}\left(\frac{\text{Net income }–\text{ Preferreddividends}}{\text{Weighted-average common shares outstanding}}\right)\\ =\frac{\$600,000-\$10,000}{100,000}\\ =\$5.90\end{array}$

A portion of profit that an individual earns from each share is referred to earnings per share.

Formula:

$\begin{array}{l}\text{Earnings }\\ \text{per share}\end{array}\}=\frac{\text{Net income }-\text{Preferred dividends}}{\text{Weighted average number of common shares outstanding}}$

To determine

To determine: Price earnings ratio

Explanation of Solution

Price earnings ratio

$\begin{array}{c}\text{Price earnings ratio =}\frac{\text{Market price per share}}{\text{Earning per share}}\\ \text{=}\frac{\text{\$82}\text{.60}}{\text{\$5}\text{.90}}\\ \text{=14}\text{.0 times}\end{array}$

Price/earnings ratio is used to determine the profitability of a company. This ratio is abbreviated as P/E.

Formula:

$\text{Price/earnings ratio}=\frac{\text{Market price per share of common stock}}{\text{Earnings per share}}$

To determine

Dividend per share of common stock

Explanation of Solution

Dividend per share of common stock

$\begin{array}{c}\begin{array}{l}\text{Dividend per }\\ \text{share of common stock}\end{array}\}=\frac{\text{Dividend per Common stock}}{\text{Shares of common stock}}\times 100\\ =\frac{\$100,000}{100,000\text{shares}}\\ =\$1.00\end{array}$

Dividend per share of commons stock is determined by dividing dividend per common stock and shares of common stock.

Formula:

$\begin{array}{l}\text{Dividend per }\\ \text{share of common stock}\end{array}\}=\frac{\text{Dividend per Common stock}}{\text{Shares of common stock}}\times 100$

To determine

To determine: Dividend yield ratio

Explanation of Solution

Dividend yield ratio

$\begin{array}{c}\text{Dividend yield }=\frac{\text{Annual dividend per Share}}{\text{Market price per Share}}\times 100\\ =\frac{\$1.00}{\$82.60}\\ =1.2\%\end{array}$

Explanation:

Dividend yield ratio is determined to evaluate the relationship between the annual dividend per share and the market price per share.

Formula:

$\text{Dividend yield }=\frac{\text{Annual dividend per Share}}{\text{Market price per Share}}\times 100$

Conclusion

Thus, summary table of determined ratios are below:

S.No	Particulars	Ratios
1.	Working capital	$1,584,000
2.	Current ratio	2.8
3.	Acid test ratio	2.2
4.	Accounts receivable turnover ratio	20.0
5.	Number of days’ sales in receivables	18.3
6.	Inventory turnover ratio	15.0
7.	Number of days sales in inventory	24.3
8.	Ratio of fixed assets to  long-term liabilities	1.8
9.	Ratio of liabilities to stockholders’ equity	0.8
10.	Times interest earned ratio	8.7
11.	Asset turnover ratio	1.3
12.	Return on total assets	8.5%
13.	Return on stockholders’ equity	12.8%
14.	Return on common stockholders’ equity	13.3%
15.	Earnings per share	$5.90
16.	Price earnings ratio	14.0
17.	Dividend  per share of common stock	$1.00
18.	Dividend yield	1.2%