Using Ratios to Compare Loan Requests from Two Companies
The financial statements for Royale and Cavalier companies are summarized here:
Royale Company | Cavalier Company | |
Balance Sheet | ||
Cash | $ 25,000 | $ 45,000 |
Accounts Receivable, Net | 55,000 | 16,000 |
Inventory | 110,000 | 25,000 |
Equipment, Net | 550,000 | 160,000 |
Other Assets | 140,000 | 46,000 |
Total Assets | $880,000 | $292,000 |
Current Liabilities | $120,000 | $ 15,000 |
Note Payable (long-term) | 190,000 | 55,000 |
Common Stock (par $20) | 480,000 | 210,000 |
Additional Paid-in Capital | 50,000 | 4,000 |
40,000 | 8,000 | |
Total Liabilities and Stockholders’ Equity | $880,000 | $292,000 |
Income Statement | ||
Sales Revenue | $800,000 | $280,000 |
Cost of Goods Sold | 480,000 | 150,000 |
Other Expenses | 240,000 | 95,000 |
Net Income | $ 80,000 | $ 35,000 |
Other Data | ||
Per share price at end of year | $ 14.00 | $ 11.00 |
Selected Data from Previous Year | ||
Accounts Receivable, Net | $ 47,000 | $ 14,000 |
Note Payable (long-term) | 190,000 | 55,000 |
Equipment, Net | 550,000 | 160,000 |
Inventory | 95,000 | 38,000 |
Total Stockholders’ Equity | 570,000 | 202,000 |
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. Royale Company wants to borrow $75,000 cash and Cavalier Company is asking for $30,000. The loans will be for a two-year period. Both companies estimate
Required:
- 1. Calculate the ratios in Exhibit 13.5 for which sufficient information is available. Round all calculations to two decimal places.
- 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 (e.g., accounting policies and decisions), give your choice and the supporting explanation.
1)
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 R
Following is the calculation of Net profit margin ratio for Company C
Thus, the net profit margin ratio for Company R and Company C is 10.00% and 12.50% respectively.
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 R
Following is the calculation of Gross profit percentage ratio for Company C
Thus, the gross profit percentage ratio for Company R and Company C is 40.00% and 46.43%
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 R
Following is the fixed asset turnover ratio for Company C
Thus, the fixed asset turnover ratio for company R and company C is 1.45 and 1.75.
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 R
Working note:
Calculate the average stockholders’ equity
Following is the return on equity ratio for the Company C
Working note:
Thus, the return on equity ratio for Company R and Company C is 14.04% and 16.51%
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 R
Working note:
Calculate the number of shares outstanding for company R
Following is the Earnings per share ratio of Company C
Working note:
Calculate the number of shares outstanding for Company C
Thus, the Earnings per share ratio of Company R and Company C is $3.33 and $3.33
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 R
Following is the price/earnings ratio of Company C
Thus, the price/earnings ratio of Company R and Company C is 4.20 and 3.30
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 R
Following is the number of days a company R takes to collect accounts receivables.
Working note:
Calculate the average net receivables
Following is the receivables turnover ratio for Company C
Following is the number of days a company C takes to collect accounts receivables.
Working note:
Calculate the average net receivables
Thus, the receivables turnover ratio for company R and company C is 15.69 and 18.67
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 R
Following is the number of days a company R takes to sell its inventory
Working note:
Calculate the average inventory
Following is the inventory turnover ratio for Company C
Following is the number of days a company C takes to sell its inventory
Working note:
Calculate the average inventory
Thus, the inventory turnover ratio for company R and company C is 4.68 and 4.76
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 R
Working note:
Calculate the current assets of Company R
Following is the current ratio of Company C
Working note:
Calculate the current assets of Company C
Thus, the current ratio of Company R and Company C is 1.58 and 5.73
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 R
Following is the debt-to-asset ratio of Company C
Thus, the debt-to-asset ratio of Company R and Company C is 0.35 and 0.24.
2)
To State: which company is preferable for receive loan.
Explanation of Solution
Following is the comparison of the Company R and C profitability and liquidity which helps in deciding which company is preferable to receive loan:
Particulars | Company R | Company C |
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% | 16.51% |
Liquidity: | ||
Receivable turnover | 15.69 | 18.67 |
Inventory Turnover | 4.68 | 4.76 |
Current ratio | 1.58 | 5.73 |
Table (1)
From the above table it is concluded that Company C is more preferable than Company R as its profitability and liquidity ratios are higher.
Company C is preferable to receive loan from loan bank because by analysing there profitability and liquidity and solvency of both the Companies R and C though Company C solvency position is less risky its profitability and liquidity is comparatively higher than Company R, but on the basis of loan requirement Company C needs $30,000 which is lesser to Company R $75,000.
Want to see more full solutions like this?
Chapter 13 Solutions
Fundamentals Of Financial Accounting
- FINANCIAL RATIOS Based on the financial statements for Jackson Enterprises (income statement, statement of owners equity, and balance sheet) shown on pages 596597, prepare the following financial ratios. All sales are credit sales. The Accounts Receivable balance on January 1, 20--, was 21,600. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and average number of days required to collect receivables 6. Inventory turnover and average number of days required to sell inventoryarrow_forwardFINANCIAL RATIOS Based on the financial statements, shown on pages 603604, for McDonald Carpeting Co. (income statement, statement of owners equity, and balance sheet), prepare the following financial ratios. All sales are credit sales. The balance of Accounts Receivable on January 1, 20--, was 6,800. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and average number of days required to collect receivables 6. Inventory turnover and average number of days required to sell inventoryarrow_forwardFINANCIAL RATIOS Based on the financial statements, shown on pages 605606, for McDonald Carpeting Co. (income statement, statement of owners equity, and balance sheet), prepare the following financial ratios. All sales are credit sales. The balance of Accounts Receivable on January 1, 20--, was 6,800. 1. Working capital 2. Current ratio 3. Quick ratio 4. Return on owners equity 5. Accounts receivable turnover and the average number of days required to collect receivables 6. Inventory turnover and the average number of days required to sell inventoryarrow_forward
- Ernst Companys balance sheet shows total liabilities of 32,500,000, total stockholders equity of 8,125,000, and total assets of 40,625,000. Required: Note: Round answers to two decimal places. 1. Calculate the debt ratio. 2. Calculate the debt-to-equity ratio.arrow_forwardRatios Analyses: McCormick Refer to the information for McCormick above. Additional information for 20X3 it as follows (amounts in millions): Required: Next Level Compute the following for 20X3. Provide a brief description of what each ratio reveals about McCormick 1. return on common equity 2. debt-to-assets 3. debt-toequity 4. current 5. quick (McCormick uses cash and equivalents, short-term securities and receivables in their quick ratio calculation.) 6. inventory turnover days 7. accounts receivable turnover days 8. accounts payable turnover days 9. operating cycle (in days) 10. total asset turnover Use the following information for 14-17 and 14-18: The Hershey Company is one of the worlds leading producers of chocolates, candies, and confections. It sells chocolates and candies, mints and gums, baking ingredients, toppings, and beverages. Hersheys consolidated balance sheets for 20X2 and 20X3 follow.arrow_forwardKlynveld Companys balance sheet shows total liabilities of 94,000,000, total stockholders equity of 75,000,000, and total assets of 169,000,000. Required: Note: Round answers to two decimal places. 1. Calculate the debt ratio. 2. Calculate the debt-to-equity ratio.arrow_forward
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forwardLast year, Nikkola Company had net sales of 2.299.500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.arrow_forwardGrammatico Company has just completed its third year of operations. The income statement is as follows: Selected information from the balance sheet is as follows: Required: Note: Round answers to two decimal places. 1. Compute the times-interest-earned ratio. 2. Compute the debt ratio. 3. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammaticos industry are as follows: How does Grammatico compare with the industrial norms? Does it have too much debt?arrow_forward
- FINANCIAL RATIOS Use the spreadsheet and financial statements prepared in Problem 15-8A. All sales are credit sales. The Accounts Receivable balance on January 1, 20--, was 10,200. REQUIRED Prepare the following financial ratios: (a) Current ratio (b) Quick ratio (c) Working capital (d) Return on owners equity (e) Accounts receivable turnover and average number of days required to collect receivables (f) Inventory turnover and average number of days required to sell inventoryarrow_forwardThe following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardMeasures 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. Instructions Determine the following measures for 20Y2, rounding to one decimal place, including percentages, except for per-share amounts: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days sales in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCollege Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,