Chapter 13, Problem 6.1GBP

To determine

Introduction:

Accounting ratio helps in comparing two or more financial data of the financial statements of the company. It is used by various parties to measure the performance of the companies.

To find:

The below stated ratios:

1. Net profit margin
2. Gross profit percentage
3. Fixed asset turnover
4. Return on equity
5. Earnings per share
6. Price / earnings ratio
7. Receivables turnover
8. Inventory turnover
9. Current ratio
10. Debt-to-assets ratio
11. Time interest earned

Answer to Problem 6.1GBP

		Company T	Company G
1	Net profit margin	10.0%	12.50%
2	Gross profit percentage	40.00%	46.42%
3	Fixed asset turnover	1.45	1.75
4	Return on equity	14.54	16.05
5	Earnings per share	$3.33	$3.33
6	P/E ratio	$4.20	$3.30
7	Account receivable turnover ratio	15.68	12.17
8	Inventory turnover ratio	4.68	4.76
9	Current ratio	1.58	5.00
10	Debt-to-assets ratio	0.35	0.23

Explanation of Solution

Profit margin ratio is calculated by dividing net income by the net sales. It helps in calculating the net income as a percentage of revenue.

Formula used:

$\text{Profit margin ratio}=\frac{Net\text{ income}}{\begin{array}{l}Total\text{ revenue}\\ \end{array}}\times 100$

	Company T	Company G
Net income	$112,000	$42,000
Total revenue (sales)	$1,120,000	$336,000
Net profit margin	10.0%	12.50%

1. Gross profit percentage helps the company to compare gross margin to the net sales. This ratio tells the profitability at which company sells its inventory.

Formula used:

$\text{Gross profit percentage}=\frac{Netsales-COGS\text{ or }(Gross\text{ profit)}}{Netsales}\times 100$

	Company T	Company G
Net sales (1)	$1,120,000	$336,000
COGS (2)	$672,000	$180,000
Gross profit (1 − 2)	$448,000	$156,000
Gross profit percentage	40.00%	46.42%

2. Asset turnover ratio calculates the ability of a company to generate sales with the fixed assets. A decline in the ratio means company has overinvested the amount in the fixed assets.

To calculate average stockholder’s equity:

$Net\text{ a}verage\text{ fixed assets}=\frac{\text{ Net fixed assets at the beginning + Net fixed assets at the end}}{2}$

The ending value of assets is taken as the values of their averages.

Formula used:

$Fixed\text{ assets turover}=\frac{Net\text{ revenue}}{Average\text{ net fixed assets}}$

	Company T	Company G
Net revenue	$1,120,000	$336,000
Average net fixed assets	$770,000	$192,000
Fixed asset turnover	1.45	1.75

3. Return on equity measure the profit earned using capital provided by the shareholders of a firm or in other words we can say that, ROI measures the effectiveness with which a company uses the assets to create profits.

To calculate average stockholder’s equity:

$Averageequity=\frac{equity\text{ at the beginning + equity at the end}}{2}$

Formula Used to calculate return on equity:

$\text{Return }onequity=\frac{Netincome}{Average\text{ shareholder's }equity}\times 100$

	Company T	Company G
Net income	$112,000	$42,000
Average stockholder’s equity	$\begin{array}{l}=\frac{\$798,000+\$742,000}{2}\\ =\$770,000\end{array}$	$\begin{array}{l}=\frac{\$266,400+\$256,800}{2}\\ =\$261,600\end{array}$
Return on equity	14.54	16.05

• Ending equity = Capital stock + additional paid in capital

4. Earnings per share (EPS) is that part of the profit of the company which is allocated to common stock per share. Earnings per share acts as an indicator of a company's profitability.

Formula used:

$Earningpershareratio=\frac{Netincome-\text{Preferred }dividends}{Average\text{ numbers of common shares outstanding}}$

	Company T	Company G
Net income	$112,000	$42,000
Average numbers of common share outstanding	33,600 shares (672,000÷20)	12,600 (252,000÷20)
Preferred dividends	$0	$0
Earnings per share	$3.33	$3.33

5. Price earnings ratio is calculated by dividing market value per share with earning per share.This ratio is used by the investors to find the value of company’s share and helps in making the comparison.

Formula used to calculate P/E ratio:

$\mathrm{P}\text{rice earning ratio=}\frac{Marketvaluepershare}{Earningpershare}$

	Company T	Company G
Market value per share	$13.20	$19.60
Earnings per share	$3.33	$3.33
P/E ratio	$3.96	$5.88

6. Receivable turnover ratio measures the number of times company collects its accounts receivable.

To calculate Average account receivables

$Av\text{erage account receivable= }\frac{\text{Opening account receivable+ closing account receivable}}{2}$

To calculate account receivable turnover ratio:

$Accounts\text{ Receivable Turn-over ratio=}\frac{Netcreditsalesornetsales}{Averageaccount\text{ Receivable}}$

	Company T	Company G
Net credit sales or net sales	$1,120,000	$336,000
Average account receivables	$\begin{array}{l}=\frac{\$65,800+\$77,000}{2}\\ =\$71,400\end{array}$	$\begin{array}{l}=\frac{\$27,200+\$28,000}{2}\\ =\$27,600\end{array}$
Account receivable turnover ratio	15.68	12.17

7. Inventory turnover ratio measures the number of times a company has sold its inventory.

To calculate average inventory:

$\text{Average Inventory = }\frac{Openinginventory+cl\text{osing inventory}}{2}$

To calculate inventory turnover ratio:

$\text{Inventory turnover ratio= }\frac{\mathrm{Cos}\text{t of goods sold}}{Average\text{ inventory}}$

	Company T	Company G
Cost of goods sold	$672,000	$180,000
Average inventory	$\begin{array}{l}=\frac{\$133,000+\$154,000}{2}\\ =\$143,500\end{array}$	$\begin{array}{l}=\frac{\$45,600+\$30,000}{2}\\ =\$37,800\end{array}$
Inventory turnover ratio	4.68	4.76

8. Current ratio is the ratio of current assets to current liabilities

$Currentratio=\frac{Currentassets}{Currentliabilities}$

	Company T	Company G
Current Assets	$266,000	$90,000
Current liabilities	$168,000	$ 18,000
Current ratio	1.58	5.00

Current assets = Cash + Accounts receivable + inventory + Other assets

Current Assets of company R = $35,000 + $77,000 + $154,000

= $266,000

Current Assets of company C = $32,000 + $28,000 + $30,000

= $90,000

9. Debt-to-asset ratio calculates the proportion of total assets financed by the creditors. If the ratio is higher, it means that the financing strategy of the company is risky.

Formula used:

$Debt\text{ to total asset ratio}=\frac{Total\text{ liabilities}}{Total\text{ Asset}}$

	Company T	Company G
Total assets	$1,232,000	$350,400
Total liabilities (current liabilities+ Notes payable (long-term))	$434,000	$84,000
Debt-to-assets ratio	0.35	0.23