Chapter 13, Problem 6PB

Using Ratios to Compare Loan Requests from Two Companies

The financial statements for Thor and Gunnar companies are summarized here:

	Thor Company	Gunnar Company
Balance Sheet
Cash	$ 35,000	$ 32,000
Accounts Receivable, Net	77,000	28,000
Inventory	154,000	30,000
Equipment, Net	770,000	192,000
Other Assets	196,000	68,400
Total Assets	$1,232,000	$350,400
Current Liabilities	$ 168,000	$ 18,000
Note Payable (long-term) (12% interest rate)	266,000	66,000
Common 5tock (par $20)	672,000	252,000
Additional Paid-in Capital	70,000	4,800
Retained Earnings	56,000	9,600
Total Liabilities and Stockholders’ Equity	$1,232,000	$350,400
Income Statement
Sales Revenue	$1,120,000	$336,000
Cost of Goods Sold	672,000	180,000
Other Expenses	336,000	114,000
Net Income	$ 112,000	$ 42,000
Other Data
Per share price at end of year	$ 13.20	$ 19.60
Selected Data from Previous Year
Accounts Receivable, Net	$ 65,800	$ 27,200
Inventory	133,000	45,600
Equipment, Net	770,000	192,000
Note Payable (long-term) (12% interest rate)	266,000	66,000
Total Stockholders’ Equity	798,000	266,400

These two companies are in the same business and state but different cities. Each company has been in operation for about 10 years. Both companies received an unqualified audit opinion on the financial statements. Thor Company wants to borrow $105.000 and Gunnar Company is asking for $36,000. The loans will be for a two-year period. Neither company issued stock in the current year. Assume the end-of-year total assets and net equipment balances approximate the year’s average and all sales are on account.

Required:

1. 1. Calculate the ratios in Exhibit 13.5 for which sufficient information is available. Round all calculations to two decimal places.
2. 2. Assume that you work in the loan department of a local bank. You have been asked to analyze the situation and recommend which loan is preferable. Based on the data given, your analysis prepared in requirement 1, and any other information, give your choice and the supporting explanation.

To determine

The Net profit margin ratio for Company T and Company G.

Explanation of Solution

Net Profit margin Ratio:

This ratio gauges the operating profitability by quantifying the amount of income earned from business operations from the sales generated.

Following is the calculation of Net profit margin ratio for Company T

$\begin{array}{c}\text{Net}\text{profit}\text{margin}\text{ratio=}\frac{\text{Net}\text{income}}{\text{Revenues}}\text{×100}\\ \text{=}\frac{\text{\$112,000}}{\text{\$1,120,000}}\text{×100}\\ \text{=10}\text{.00\%}\end{array}$

Following is the calculation of Net profit margin ratio for Company G

$\begin{array}{c}\text{Net}\text{profit}\text{margin}\text{ratio=}\frac{\text{Net}\text{income}}{\text{Revenues}}\text{×100}\\ \text{=}\frac{\text{\$42,000}}{\text{\$336,000}}\text{×100}\\ \text{=12}\text{.50\%}\end{array}$

Thus, the net profit margin ratio for Company T and Company G is 10.00% and 12.50% respectively.

To determine

The Gross profit percentage ratio for Company T and Company G

Explanation of Solution

Gross Profit Percentage:

Gross profit is the financial ratio that shows the relationship between the gross profit and net sales. It represents gross profit as a percentage of net sales. Gross Profit is the difference between the net sales revenue, and the cost of goods sold. It can be calculated by dividing gross profit and net sales.

Following is the calculation of Gross profit percentage ratio for Company T

$\begin{array}{c}\text{Gross}\text{profit}\text{percentage}\text{ratio=}\frac{\left(\begin{array}{l}\text{Net}\text{sales}\text{revenue-}\\ \text{cost}\text{of}\text{goods}\text{sold}\end{array}\right)}{\text{Net}\text{sales}\text{revenue}}\text{×100}\\ \text{=}\frac{\left(\text{\$1,120,000-\$672,000}\right)}{\text{\$1,120,000}}\text{×100}\\ \text{=}\frac{\text{\$448,000}}{\text{\$1,120,000}}\text{×100}\\ \text{=40}\text{.00\%}\end{array}$

Following is the calculation of Gross profit percentage ratio for Company G

$\begin{array}{c}\text{Gross}\text{profit}\text{percentage}\text{ratio=}\frac{\left(\begin{array}{l}\text{Net}\text{sales}\text{revenue-}\\ \text{cost}\text{of}\text{goods}\text{sold}\end{array}\right)}{\text{Net}\text{sales}\text{revenue}}\text{×100}\\ \text{=}\frac{\left(\text{\$336,000-\$180,000}\right)}{\text{\$336,000}}\text{×100}\\ \text{=}\frac{\text{\$156,000}}{\text{\$336,000}}\text{×100}\\ \text{=46}\text{.43\%}\end{array}$

Thus, the gross profit percentage ratio for Company T and Company G is 40.00% and 46.43%

To determine

The fixed asset turnover ratio for Company T and Company G

Explanation of Solution

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.

Following is the fixed asset turnover ratio for Company T

$\begin{array}{c}\text{Fixed}\text{asset}\text{trunover=}\frac{\text{Net}\text{revenue}}{\text{Average}\text{net}\text{fixed}\text{assets}}\\ \text{=}\frac{\text{\$1,120,000}}{\text{\$770,000}}\\ \text{=1}\text{.45}\end{array}$

Following is the fixed asset turnover ratio for Company G

$\begin{array}{c}\text{Fixed}\text{asset}\text{trunover=}\frac{\text{Net}\text{revenue}}{\text{Average}\text{net}\text{fixed}\text{assets}}\\ \text{=}\frac{\text{\$336,000}}{\text{\$192,000}}\\ \text{=1}\text{.75}\end{array}$

Thus, the fixed asset turnover ratio for company R and company C is 1.45 and 1.75.

To determine

The return on equity ratio for Company T and Company G

Explanation of Solution

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.

Following is the return on equity ratio for the Company T

$\begin{array}{c}\text{Return}\text{on}\text{equity=}\frac{\left(\begin{array}{l}\text{Net}\text{income-}\\ \text{preferred}\text{dividends}\end{array}\right)}{\text{Average}\text{common}\text{stockholders'}\text{equity}}\text{×100}\\ \text{=}\frac{\left(\text{\$112,000-0}\right)}{\text{\$798,000(1)}}\text{×100}\\ \text{=14}\text{.04\%}\end{array}$

Working note:

Calculate the average stockholders’ equity

$\begin{array}{c}\text{Average}\text{common}\text{stockholders'}\text{equity=}\frac{\left(\begin{array}{l}\text{Opening}\text{common}\text{stockholders'}\text{equity+}\\ \text{Closing}\text{common}\text{stock}\text{holders'}\text{equity}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$798,000+\$798,000}}{\text{2}}\\ \text{=\$798,000}\end{array}$ (1)

Following is the return on equity ratio for the Company G

$\begin{array}{c}\text{Return}\text{on}\text{equity=}\frac{\left(\begin{array}{l}\text{Net}\text{income-}\\ \text{preferred}\text{dividends}\end{array}\right)}{\text{Average}\text{common}\text{stockholders'}\text{equity}}\text{×100}\\ \text{=}\frac{\left(\text{\$42,000-0}\right)}{\text{\$266,400(2)}}\text{×100}\\ \text{=15}\text{.77\%}\end{array}$

Working note:

$\begin{array}{c}\text{Average}\text{common}\text{stockholders'}\text{equity=}\frac{\left(\begin{array}{l}\text{Opening}\text{common}\text{stockholders'}\text{equity+}\\ \text{Closing}\text{common}\text{stock}\text{holders'}\text{equity}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$226,400+\$226,400}}{\text{2}}\\ \text{=\$226,400}\end{array}$ (2)

Thus, the return on equity ratio for Company T and Company G is 14.04% and 15.77%

To determine

The earnings per share ratio of Company T and Company G

Explanation of Solution

Earnings per share ratio:

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.

Following is the Earnings per share ratio of Company T

$\begin{array}{c}\text{Earnings}\text{per}\text{share}\text{ratio=}\frac{\text{Net Income }-\text{Preferred dividend}}{\text{No of shares outstanding}}\\ \frac{\text{\$112,000 }-\text{ \$0}}{\text{33,600 shares(3)}}\\ \text{=\$3}\text{.33}\end{array}$

Working note:

Calculate the number of shares outstanding for company T

$\text{Number}\text{of}\text{shares}\text{outstanding=}\frac{\text{Total}\text{value}\text{of}\text{common}\text{stock}}{\begin{array}{l}\text{Par}\text{value}\text{of}\text{each}\text{stock}\\ \text{=}\frac{\text{\$672,000}}{\text{\$20}}\\ \text{=\$36,400}\end{array}}$ (3)

Following is the Earnings per share ratio of Company G

$\begin{array}{c}\text{Earnings}\text{per}\text{share}\text{ratio=}\frac{\text{Net Income }-\text{Preferred dividend}}{\text{No of shares outstanding}}\\ \frac{\text{\$42,000}-\$0}{\text{12,600shares(4)}}\\ \text{=\$3}\text{.33}\end{array}$

Working note:

Calculate the number of shares outstanding for Company G

$\text{Number}\text{of}\text{shares}\text{outstanding=}\frac{\text{Total}\text{value}\text{of}\text{common}\text{stock}}{\begin{array}{l}\text{Par}\text{value}\text{of}\text{each}\text{stock}\\ \text{=}\frac{\text{\$252,000}}{\text{\$10}}\\ \text{=\$12,600}\end{array}}$ (4)

Thus, the Earnings per share ratio of Company T and Company G is $3.33 and $3.33

To determine

The price/Earnings ratio of Company T and Company G

Explanation of Solution

Price/Earnings Ratio:

The price/earnings ratio shows 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.

Following is the price/earnings ratio of Company T

$\begin{array}{c}\text{Price/Earnings}\text{ratio=}\frac{\text{Stock}\text{price}}{\text{Earnings}\text{per}\text{share}}\\ \text{=}\frac{\text{\$13}\text{.20}}{\text{\$3}\text{.33}}\\ \text{=3}\text{.96}\end{array}$

Following is the price/earnings ratio of Company G

$\begin{array}{c}\text{Price/Earnings}\text{ratio=}\frac{\text{Stock}\text{price}}{\text{Earnings}\text{per}\text{share}}\\ \text{=}\frac{\text{\$19}\text{.60}}{\text{\$3}\text{.33}}\\ \text{=5}\text{.89}\end{array}$

Thus, the price/earnings ratio of Company T and Company G is 3.96 and 5.89

To determine

The receivables turnover ratio for Company T and G.

Explanation of Solution

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.

Following is the receivables turnover ratio for Company T

$\begin{array}{c}\text{Receivables}\text{turnover}\text{ratio=}\frac{\text{Net}\text{sales}\text{revenue}}{\text{Average}\text{net}\text{receivables}}\\ \text{=}\frac{\text{\$1,120,000}}{\text{\$71,400(5)}}\\ \text{=15}\text{.69}\end{array}$

Following is the number of days a company T takes to collect accounts receivables.

$\begin{array}{c}\text{Days}\text{to}\text{collect=}\frac{\text{365}}{\text{Receivables}\text{turnover}\text{ratio}}\\ \text{=}\frac{\text{365}}{\text{15}\text{.69}}\\ \text{=23}\text{.27 days}\end{array}$

Working note:

Calculate the average net receivables

$\begin{array}{c}\text{Average}\text{net}\text{receivables=}\frac{\left(\begin{array}{l}\text{Opening}\text{net}\text{receivables+}\\ \text{Closing}\text{net}\text{receivables}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$77,000+\$65,800}}{\text{2}}\\ \text{=\$71,400}\end{array}$ (5)

Following is the receivables turnover ratio for Company G

$\begin{array}{c}\text{Receivables}\text{turnover}\text{ratio=}\frac{\text{Net}\text{sales}\text{revenue}}{\text{Average}\text{net}\text{receivables}}\\ \text{=}\frac{\text{\$336,000}}{\text{\$27,600(6)}}\\ \text{=12}\text{.17}\end{array}$

Following is the number of days a company G takes to collect accounts receivables.

$\begin{array}{c}\text{Days}\text{to}\text{collect=}\frac{\text{365}}{\text{Receivables}\text{turnover}\text{ratio}}\\ \text{=}\frac{\text{365}}{12.17}\\ \text{=29}\text{.99Days}\end{array}$

Working note:

Calculate the average net receivables

$\begin{array}{c}\text{Average}\text{net}\text{receivables=}\frac{\left(\begin{array}{l}\text{Opening}\text{net}\text{receivables+}\\ \text{Closing}\text{net}\text{receivables}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$28,000+\$27,200}}{\text{2}}\\ \text{=\$27,600}\end{array}$ (6)

Thus, the receivables turnover ratio for company T and company G is 15.69 and 12.17

To determine

The inventory turnover ratio for Company T and Company G

Explanation of Solution

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.

Following is the inventory turnover ratio for Company T

$\begin{array}{c}\text{Inventory}\text{turnover}\text{ratio=}\frac{\text{Cost}\text{of}\text{goods}\text{sold}}{\text{Average}\text{inventory}}\\ \text{=}\frac{\text{\$672,000}}{\text{\$143,500(7)}}\\ \text{=4}\text{.68}\end{array}$

Following is the number of days a company T takes to sell its inventory

$\begin{array}{c}\text{Days}\text{to}\text{sell=}\frac{\text{365}}{\text{Inventory}\text{turnover}\text{ratio}}\\ \text{=}\frac{\text{365}}{4.68}\\ \text{=77}\text{.99days}\end{array}$

Working note:

Calculate the average inventory

$\begin{array}{c}\text{Average}\text{inventory=}\frac{\left(\begin{array}{l}\text{Opening}\text{inventory+}\\ \text{Closing}\text{inventory}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$154,000+\$133,000}}{\text{2}}\\ \text{=}\frac{\text{\$287,000}}{\text{2}}\\ \text{=\$143,500}\end{array}$ (7)

Following is the inventory turnover ratio for Company G

$\begin{array}{c}\text{Inventory}\text{turnover}\text{ratio=}\frac{\text{Cost}\text{of}\text{goods}\text{sold}}{\text{Average}\text{inventory}}\\ \text{=}\frac{\text{\$180,000}}{\text{\$37,800(8)}}\\ \text{=4}\text{.76}\end{array}$

Following is the number of days a company G takes to sell its inventory

$\begin{array}{c}\text{Days}\text{to}\text{sell=}\frac{\text{365}}{\text{Inventory}\text{turnover}\text{ratio}}\\ \text{=}\frac{\text{365}}{4.76}\\ \text{=76}\text{.68}\end{array}$

Working note:

Calculate the average inventory

$\begin{array}{c}\text{Average}\text{inventory=}\frac{\left(\begin{array}{l}\text{Opening}\text{inventory+}\\ \text{Closing}\text{inventory}\end{array}\right)}{\text{2}}\\ \text{=}\frac{\text{\$30,000+\$45,600}}{\text{2}}\\ \text{=}\frac{\text{\$75,600}}{\text{2}}\\ \text{=\$37,800}\end{array}$ (8)

Thus, the inventory turnover ratio for company T and company G is 4.68 and 4.76

To determine

The current ratio of Company T and G

Explanation of Solution

Current ratio:

Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.

Following is the current ratio of Company T

$\begin{array}{c}\text{Current}\text{ratio=}\frac{\text{Current}\text{assets}}{\text{Current}\text{liabilities}}\\ \text{=}\frac{\text{\$266,000(9)}}{\text{\$168,000}}\\ \text{=1}\text{.58}\end{array}$

Working note:

Calculate the current assets of Company T

$\begin{array}{c}\text{Current}\text{assets=Cash+Accounts}\text{receivables+Inventory}\\ \text{=\$35,000+\$77,000+\$154,000}\\ \text{=\$266,000}\end{array}$ (9)

Following is the current ratio of Company G

$\begin{array}{c}\text{Current}\text{ratio=}\frac{\text{Current}\text{assets}}{\text{Current}\text{liabilities}}\\ \text{=}\frac{\text{\$90,000(10)}}{\text{\$18,000}}\\ \text{=5}\text{.00}\end{array}$

Working note:

Calculate the current assets of Company G

$\begin{array}{c}\text{Current}\text{assets=Cash+Accounts}\text{receivables+Inventory}\\ \text{=\$32,000+\$28,000+\$30,000}\\ \text{=\$90,000}\end{array}$ (10)

Thus, the current ratio of Company T and Company G is 1.58 and 5.00

To determine

The debt-to-assets ratio of Company T and Company G

Explanation of Solution

Debt to Asset Ratio:

Debt to asset ratio is the ratio between total asset and total liability of the company. Debt ratio reflects the finance strategy of the company. It is used to evaluate company’s ability to pay its debts. Higher debt ratio implies the higher financial risk.

Following is the debt-to-asset ratio of Company T

$\begin{array}{c}\text{Debt-to-asset}\text{ratio=}\frac{\text{Total}\text{liabilities}}{\text{Total}\text{assets}}\\ \text{=}\frac{\text{\$434,000}}{\text{\$1,232,000}}\\ \text{=0}\text{.35}\end{array}$

Following is the debt-to-asset ratio of Company G

$\begin{array}{c}\text{Debt-to-asset}\text{ratio=}\frac{\text{Total}\text{liabilities}}{\text{Total}\text{assets}}\\ \text{=}\frac{\text{\$84,000}}{\text{\$350,000}}\\ \text{=0}\text{.24}\end{array}$

Thus, the debt-to-asset ratio of Company T and Company G is 0.35 and 0.24.

To determine

To State: which company is preferable for receive loan.

Explanation of Solution

Following is the comparison of the Company T and G profitability and liquidity which helps in deciding which company is preferable to receive loan:

Particulars	Company T	Company G
Profitability:
Net profit margin ratio	10%	12.50%
Gross profit percentage ratio	40.00%	46.43%
Fixed asset turnover ratio	1.45	1.75
Earnings per share	$3.33	$3.33
Return on equity	14.04%	15.77%
Liquidity:
Inventory Turnover	4.68	4.76
Current ratio	1.58	5.00

Table (1)

From the above table it is concluded that Company G is more preferable than Company T as its profitability and liquidity ratios are higher.

Company G is preferable to receive loan from loan bank because by analysing there profitability and liquidity and solvency of both the Companies T and G though Company G solvency position is less risky its profitability and liquidity is comparatively higher than Company T, even while comparing the on the basis of loan requirement Company C needs $36,000 which is lesser to Company T $105,000 so it is advisable to provide loan for Company G.