Chapter 13, Problem 8P

To determine

Compute the appropriate ratios for Company P.

Answer to Problem 8P

Compute the appropriate ratios for Company P.

	Ratio	Formula	Calculation	Result
	Profitability ratios
1	Return on Equity (ROE)	$\frac{\text{Net}\text{Income}}{\text{Average}\text{Total}\text{Stockholder'}\text{Equity}}$	$\left(\frac{\$14,000}{\left(\left(\$30,000+\$12,000\right)+\left(\$30,000+\$5,000\right)\right)÷2}\right)$	36.36%
2	Return on Assets (ROA)	$\frac{\text{Net}\text{Income}}{\text{Average}\text{Total}\text{Assets}}$	$\left(\frac{\$14,000}{\left(\$103,000+\$97,000\right)÷2}\right)$	14.00%
3	Financial leverage percentage	$\text{ROE}-\text{ROA}$	$36.36–14.00$	21.64%
4	Net profit margin	$\frac{\text{Net}\text{Income}}{\text{Net Sales Revenue}}$	$\frac{\$14,000}{\$190,000}$	7.36%
5	Earnings per share (EPS)	$\frac{\text{Net}\text{Income}}{\left(\begin{array}{l}\text{Weighted Average Number of }\\ \text{common Shares Outstanding}\end{array}\right)}$	$\frac{\$14,000}{6,000\text{shares}}$	$2.33
	Turnover ratios
6	Fixed asset turnover	$\frac{\text{Net}\text{Sales}\text{Revenue}}{\text{Average}\text{Net}\text{Fixed}\text{Assets}}$	$\frac{\$190,000}{\left(\$45,000+\$38,000\right)÷2}$	4.57 times
7	Receivables turnover	$\frac{\text{Net Credit}\text{Sales}}{\text{Average}\text{Net Receivables}}$	$\frac{\$190,000\times 33.33\%}{\left(\$14,000+\$18,000\right)÷2}$	3.95  times
8	Inventory turnover	$\frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}$	$\frac{\$112,000}{\left(\$40,000+\$34,000\right)÷2}$	3.02  times
	Liquidity ratios
9	Current ratio	$\frac{\text{Current}\text{Assets}}{\text{Current}\text{Liabilities}}$	$\frac{\left(\$4,000+\$14,000+\$\$40,000\right)}{\$16,000}$	3.625  times
10	Quick ratio	$\frac{\text{Quick}\text{Assets}}{\text{Current}\text{Liabilities}}$	$\frac{\left(\$4,000+\$14,000\right)}{\$16,000}$	1.125  times
11	Cash ratio	$\frac{\text{Cash \& Cash Equivalents}}{\text{Current}\text{Liabilities}}$	$\frac{\$4,000}{\$16,000}$	0.25  times
	Solvency ratio
12	Debt-to-equity ratio	$\frac{\text{Total}\text{Liabilities}}{\text{Total}\text{Stockholder's}\text{Equity}}$	$\frac{\$61,000}{\$42,000}$	1.45  times
13	Time interest earned ratio	$\frac{\text{Net Income}\text{+}\text{Interest +}\text{Income Tax Expense}}{\text{Interest Expense}}$	$\frac{\left(\$14,000+\$\$4,500+\$8,000\right)}{\$4,500}$	5.8  times
	Market ratios
14	Price/Earnings (P/E) ratio	$\frac{\text{Market Price per Share}}{\text{Earnings}\text{per Share}}$	$\frac{\$28}{\$2.33}$	12.017  times

Table (1)

Explanation of Solution

1. 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.

$\text{Return on Equity}\text{=}\frac{\text{Net}\text{Income}}{\text{Average}\text{Total}\text{Stockholder'}\text{Equity}}$

Return on equity ratio of Company P is 36.36%.

2. Return on assets:

Return on 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.

$\text{Return on Assets }\left(\text{ROA}\right)=\frac{\text{Net}\text{Income}}{\text{Average}\text{Total}\text{Assets}}$

Return on assets ratio of the Company P is 14%.

3. Financial Leverage Percentage:

Financial Leverage Percentage is one of the profitability ratios. It measures that the assets held by a company proportionate to its common stock (Equity). It measures the advantages or disadvantages that occur due to variance between the return on equity and return on assets.

$\text{Financial Leverage Precentage}=\text{Rate}\text{of}\text{Return}\text{on}\text{Equity}-\text{Rate}\text{of}\text{Return}\text{on}\text{Assets}$

Financial leverage percentage of the Company P is 21.64%.

4. Profit margin:

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

$\text{Net profit margin}\text{=}\frac{\text{Net}\text{Income}}{\text{Net Sales Revenue}}$

Profit margin of the Company P is 7.37%.

5. Earnings per share:

Earnings per share help to measure the profitability of a company. Earnings per share are the amount of profit that is allocated to each share of outstanding stock.

$\text{EPS}\text{=}\frac{\text{Net}\text{Income}}{\left(\text{Weighted Average Number of common Shares Outstanding}\right)}$

Earnings per share of the Company P are $2.33.

6. Fixed Asset turnover:

Fixed asset turnover is a ratio that measures the productive capacity of the fixed assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total fixed assets.

$\text{Fixed Assets turnover}\text{ratio}\text{=}\frac{\text{Net}\text{Sales}\text{Revenue}}{\text{Average}\text{Net}\text{Fixed}\text{Assets}}$

Fixed assets turnover of the Company P is 4.58 times.

7. 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.

$\text{Receivables Turnover Ratio}\text{=}\frac{\text{Net Sales}}{\text{Average}\text{Accounts}\text{Receivables}}$

Receivables turnover of the Company P is 3.96 times.

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

$\text{Inventory Turnover Ratio =}\frac{\text{Cost of Goods Sold }}{\text{Average Inventory}}$

Inventory turnover of the Company P is 3.02 times.

9. 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. The ideal current ratio is 2:1. The following formula is used to calculate current ratio.

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

Current ratio of the Company P is 3.63 times.

10. Quick 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.

$\text{Quick Ratio}\text{=}\frac{\text{Quick}\text{Assets}}{\text{Current}\text{Liabilities}}$

Quick ratio of the Company P is 1.13 times.

11. Cash ratio:

This ratio is used to measure the adequacy of the cash in the business.

$\frac{\text{Cash \& Cash Equivalents}}{\text{Current}\text{Liabilities}}$

Cash ratio of the Company P is 0.25 times.

12. Debt-equity ratio:

The debt-to-equity ratio indicates that the company’s debt as a proportion of its stockholders’ equity.

$\text{Debt-equity ratio}\text{=}\frac{\text{Total}\text{Liabilities}}{\text{Total}\text{Stockholder's}\text{Equity}}$

Debt-to-equity ratio of the Company P is 1.45 times.

13. Times Interest Earned Ratio:

It is one of the solvency ratios. It is a measure to evaluate the net income for interest payment on debt of a company. It is calculated as follows:

$\text{Times Interest earned ratio}\text{=}\frac{\text{Net Income}\text{+ Interest Expense}\text{+}\text{Income Tax Expense}}{\text{Interest Expense}}$

Times interest earned ratio of the Company P is 5.88 times

14. Price/Earnings Ratio: It depicts the relation of market price of a share to earnings per share of that company. The price/earnings ratio presents the market value of the amount invested to earn $1 by a company. It is major tool to be used by investors before the decisions related to investments in a company.

$\text{Price/Earnings Ratio}\text{=}\frac{\text{Market Price per Share }}{\text{Earnings per Share}}$

Price/earnings ratio of the Company P is 12.02 times