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:
- Net profit margin
- Gross profit percentage
- Fixed asset turnover
- Return on equity
- Earnings per share
- Price / earnings ratio
- Receivables turnover
- Inventory turnover
Current ratio - Debt-to-assets ratio
- 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:
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% |
- 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.
- 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.
- 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. - 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.
- 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.
- Receivable turnover ratio measures the number of times company collects its accounts receivable.
- Inventory turnover ratio measures the number of times a company has sold its inventory.
- Current ratio is the ratio of current assets to current liabilities
- 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:
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% |
To calculate average
The ending value of assets is taken as the values of their averages.
Formula used:
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 |
To calculate average stockholder’s equity:
Formula Used to calculate return on equity:
Company T | Company G | |
Net income | $112,000 | $42,000 |
Average stockholder’s equity | ||
Return on equity | 14.54 | 16.05 |
• Ending equity = Capital stock + additional paid in capital
Formula used:
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 |
Formula used to calculate P/E ratio:
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 |
To calculate Average account receivables
To calculate account receivable turnover ratio:
Company T | Company G | |
Net credit sales or net sales | $1,120,000 | $336,000 |
Average account receivables | ||
Account receivable turnover ratio | 15.68 | 12.17 |
To calculate average inventory:
To calculate inventory turnover ratio:
Company T | Company G | |
Cost of goods sold | $672,000 | $180,000 |
Average inventory | ||
Inventory turnover ratio | 4.68 | 4.76 |
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
Formula used:
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 |
Want to see more full solutions like this?
Chapter 13 Solutions
MANAGERIAL ACCOUNTING W/CONN+ F17
- uring the month of April, Orison Supply Store sold $39,000 of inventory, with $25,000 sold on credit and the remaining for cash. The business collected $15,000 from the previous month's credit sales that excluded a bad debt of $750. The inventory sold was purchased at a cost of $2,3400. What was the total revenue recognised in the month of September? (Ignore GST for this question)A. None of the other answers B. 54,000 C. 14,250 D. 38,250 E. 39,000arrow_forwardJonel Corporation operates a branch in Cebu. In October, the HO shipped P 68,000 merchandise to this branch, which the branch credited the HO account for P 86,000. In November, the branch collected P2,000 HO accounts receivable. The HO was properly notified but debited Investment in Branch account for P 8,000. At the end of the year, the HO paid and recorded a P 12,000 expense for the branch but the branch has not yet made the appropriate entry for this. At year-end, the branch transferred P 50,000 cash to HO but the HO has not yet made the necessary entry. Based on the above, the corrections needed are a. HO to credit its Investment in Branch account for P 48,000, and the Branch to debit the HO account for P 18,000. b. HO to credit its Investment in Branch account for P 60,000 and the Branch to debit the HO account for P6,000 c. HO to credit its Investment in Branch account for P 56,000 and the Branch to debit the HO account for P 6,000. d. HO to credit its Investment in Branch…arrow_forwardBrand Advertising is offered a 3/10 net 40 trade discount by its supplier. In the past Brand has been able to get away with paying for supplies on credit in 60 days. Since it doesn't have money on hand to take advantage of the discount, it tries to negotiate a loan with Second Canadian Bank. The amount of $375,000 with a 15% compensating balance and a $5,500 interest charge has been negotiated for the month of May. Brand already maintains a $16,250 balance at the bank. Compute the annual rate of interest on the loan, and the cost of not taking the discount. Which one should Brand take? Talmund Book company borrows $16,000 for 30 days at 9% interest. What is the dollar cost of the loan? Calculate the cost of discounting a $100,000 bankers’ acceptance if it is due in 90 days and is sold at $97,915. Ignore bank fees.arrow_forward
- Bad Debt Expense: Percentage of Credit Sales Method The Glass House, a glass and china store, sells nearly half its merchandise on credit. During the past 4 years, the following data were developed for credit sales and losses from uncollectible accounts: Required: 1. Calculate the loss rate for each year from 2016 through 2018. ( Note: Round answers to three decimal places.) 2. Determine whether there appears to be a significant change in the loss rate over time. 3. CONCEPTUAL CONNECTION If credit sales for 2020 are $400,000, determine what loss rate you would recommend to estimate bad debts. ( Note: Round answers to three decimal places.) 4. Using the rate you recommend, record bad debt expense for 2020. 5. CONCEPTUAL CONNECTION Assume that the increase in The Glass Houses sales in 2020 was largely due to granting credit to customers who would have been denied credit in previous years. How would this change your answer to Requirement 4? Describe a legitimate business reason why The Glass House would adopt more lenient credit terms. 6. CONCEPTUAL CONNECTION Using the data from 2016 through 2019, estimate the increase in income from operations in total for those 4 years assuming (a) the average gross margin is 25% and (b) 50% of the sales would have been lost if no credit was granted.arrow_forwardYou are considering two possible companies for investment purposes. The following data is available for each company. Additional Information: Company A: Bad debt estimation percentage using the income statement method is 6%, and the balance sheet method is 10%. The $230,000 in Other Expenses includes all company expenses except Bad Debt Expense. Company B: Bad debt estimation percentage using the income statement method is 6.5%, and the balance sheet method is 8%. The $140,000 in Other Expenses includes all company expenses except Bad Debt Expense. A. Compute the number of days sales in receivables ratio for each company for 2019 and interpret the results (round answers to nearest whole number). B. If Company A changed from the income statement method to the balance sheet method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations). C. If Company B changed from the balance sheet method to the income statement method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations). D. What benefits do each company gain by changing their method of bad debt estimation? E. Which company would you invest in and why? Provide supporting details.arrow_forwardAssume you work as an assistant to the chief financial officer (CFO) of Fashions First, Inc. TheCFO reminds you that the fiscal year-end is only two weeks away and that he is looking to you toensure the company stays in compliance with its loan covenant to maintain a debt-to-assets ratio ofno more than 75 percent. A review of the general ledger indicates that assets total $690,000 and liabilities are $570,000. Your company has an excess of Cash ($300,000) and an equally large balancein Accounts Payable ($270,000), although none of its Accounts Payable are due until next month.Required:1. Determine whether the company is currently in compliance with its loan covenant.2. Assuming the level of assets and liabilities remains unchanged until the last day of the fiscalyear, evaluate whether Fashions First should pay down $210,000 of its Accounts Payable onthe last day of the year, before the Accounts Payable become duearrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning