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:
All the possible ratios.
Answer to Problem 6.1GAP
Company R | Company C | ||
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.82 |
5 | Earnings per share | $3.33 | $3.33 |
6 | P/E ratio | $4.20 | $3.30 |
7 | Account receivable turnover ratio | 15.68 | 18.66 |
8 | Inventory turnover ratio | 4.68 | 4.76 |
9 | 2.75 | 8.80 | |
10 | Debt-to-assets ratio | 2.28 | 2.92 |
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.
- 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 a 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 R | Company C | |
Net income | $80,000 | $35,000 |
Total revenue | $800,000 | $280,000 |
Net profit margin | 10.0% | 12.50% |
Formula used:
Company R | Company C | |
Net sales (1) | $800,000 | $280,000 |
COGS (2) | $480,000 | $150,000 |
Gross profit (1 − 2) | $320,000 | $130,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 R | Company C | |
Net revenue | $800,000 | $280,000 |
Average net fixed assets | $550,000 | $160,000 |
Fixed asset turnover | 1.45 | 1.75 |
To calculate average stockholder’s equity:
Formula Used to calculate return on equity:
Company R | Company C | |
Net income | $80,000 | $35,000 |
Average stockholder’s equity | ||
Return on equity | 14.54 | 16.82 |
• Ending equity = Capital stock + additional paid in capital
Formula used:
Company R | Company C | |
Net income | $80,000 | $35,000 |
Average numbers of common share outstanding. | 24,000 shares (480,000÷20) | 10,500 (210,000÷20) |
Preferred dividends. | $0 | $0 |
Earnings per share. | $3.33 | $3.33 |
Formula used to calculate P/E ratio:
Company R | Company C | |
Market value per share | $14.00 | $11.00 |
Earnings per share | $3.33 | $3.33 |
P/E ratio | $4.20 | $3.30 |
To calculate Average account receivables
To calculate account receivable turnover ratio:
Company R | Company C | |
Net credit sales or net sales | $800,000 | $280,000 |
Average account receivables | ||
Account receivable turnover ratio | 15.68 | 18.66 |
To calculate average inventory:
To calculate inventory turnover ratio:
Company R | Company C | |
Cost of goods sold | $480,000 | $150,000 |
Average inventory | ||
Inventory turnover ratio | 4.68 | 4.76 |
Company R | Company C | |
Current Assets | $330,000 | $132,000 |
Current liabilities | $120,000 | $ 15,000 |
Current ratio | 2.75 | 8.80 |
Current assets = Cash + Accounts receivable + inventory + Other assets
Current Assets of company R = $25,000 + $55,000 + $110,000 + $140,000
= $330,000
Current Assets of company C=$45,000 + $16,000 + $25,000 + 46,000
= $132,000
Formula used:
Company R | Company C | |
Total assets | $880,000 | $292,000 |
Total liabilities (current liabilities+ Notes payable (long-term) + borrowed loan) | $385,000 | $100,000 |
Debt-to-assets ratio | 2.28 | 2.92 |
Want to see more full solutions like this?
Chapter 13 Solutions
Managerial Accounting
- Use the following information to answer the next two questions: Lewis Company uses the allowance method for recording its expected credit losses. It estimates bad debts at 2% of credit sales, which were $900,000 during the year. On December 31, the Accounts Receivable balance was $150,000, and the Allowance for Doubtful Accounts had a balance of $12,200 before adjustments. What is the amount of bad debt expense Lewis Company will report on their Income Statement this year? Select one: a. 17,756 b. 3,000 c. 12,200 d. 18,000 e. 2,756arrow_forwardUse the following information to answer the next two questions: Harris Company uses the allowance method of handling its credit losses. It estimates credit losses at 1.5% of credit sales, which were $2,700,000 during the year. On December 31, the Accounts Receivable balance was $475,000, and the Allowance for Doubtful Accounts had a balance of $30,600 before adjustment. Indicate the effect (increase / decrease) that recording the bad debt expense for the year will have on the company's assets, liabilities, and equity, respectively. Assets Liabilities Equity Select one: a. Decrease, No Change, Decrease b. Increase, No Change, Decrease C. Increase, No Change, Increase O O d. Decrease, Decrease, No Change e. Increase, Decrease, lncreasearrow_forwardUse the following information to answer the next two questions: Harris Company uses the allowance method of handling its credit losses. It estimates credit losses at 1.5% of credit sales, which were $2,700,000 during the year. On December 31, the Accounts Receivable balance was $475,000, and the Allowance for Doubtful Accounts had a balance of $30,600 before adjustment. Indicate the effect (increase / decrease) that recording the bad debt expense for the year will have on the company's assets, liabilities, and equity, respectively. Assets = Liabilities + Equity What would be the Net Realizable Value of Harris Company's Accounts Receivable at year end, after the adjusting entry for bad debts has been recorded? Select one: a. 403,900 b. 465,100 c. 444,400 d. 434,500arrow_forward
- At the end of the year, two similar companies were in the process of calculating bad debt expense for the year. Each company had credit sales of P 1,000,000 and a debit balance in Allowance for Uncollectible Accounts of P 2,000 before any year-end adjustment. The amount of accounts receivable written off during the year for both companies was P 8,000. The balance of Accounts Receivable is P 180,000. A Company estimates that 5% of accounts receivable will not be collected over the next year. B Company estimates that 5% of credit sales will not be collected over the next year. Required: For each company, determine: a) The uncollectible accounts expense for the year. b) The adjusting entry to be made of December 31. c) The balance in Allowance for Doubtful Accounts after adjustmentarrow_forwardDuring the current year, Giatras Electronics recorded credit sales of $710,000. Based on prior experience, it estimates a 4.5 percent bad debt rate on credit sales. Required: 1. Prepare journal entries for each of the following transactions. a. On October 28 of the current year, an account receivable for $2,800 from a prior year was determined to be uncollectible and was written off. b. At year-end, the appropriate bad debt expense adjustment was recorded for the current year. 2. Complete the following table, indicating the amount and effect for each transaction. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare journal entries for each of the following transactions. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) a. On October 28 of the current year, an account receivable for $2,800 from a prior year was determined to be uncollectible and was written off. b. At year-end,…arrow_forwardA company reports a year end credit sales in the amount of 390,000 and accounts receivable of $85,500. The company uses the income statement method to report bad debt estimation. The estimation percentage is 3.5%. There is a current debut balance of $2,000 in the bad debt account and a $2,000 credit balance in the allowance for doubtful accounts. Record the journal entry using the income statement method. Then record this transaction using T accountsarrow_forward
- Manilow Corporation operates in an industry that has a highrate of bad debt. Before any year-end adjustments, the balance inManilow’s Accounts Receivable was $555,000 and Credit LossAllowance has a credit balance of $40,000. The year-end balancereported in the statement of financial position for Credit LossAllowance will be based on the aging schedule shown below.Day AccountOutstanding Amount Probability ofCollectionLess than 16 days 300,000 .9816-30 days 100,000 .9031-45 days 80,000 .8546-60 days 40,000 .8061-75 days 20,000 .55Over 75 days 15,000 .00Instruction:1.1 Compute expected credit loss for the year endingDecember 31 and the net realizable value of Manilow’saccounts receivable as of December 311.2 Prepare the journal entry to record the expected credit lossfor the year.arrow_forwardThe Dubious Company operates in an industry where all sales are made on account. The company has experienced bad debt losses of 1.90% of credit sales in prior periods. Presented below is the company's forecast of sales and expenses over the next three years. Year 3 $ 374,000 Year 2 $ 375,000 Unknown 333,000 Unknown 335,750 Unknown Unknown Sales Revenue Bad Debt Expense Other Expenses Net Income Year 1 $ 369,000 Unknown 340,000 Unknown Required: a. Calculate Bad Debt Expense and net income for each of the three years, assuming uncollectible accounts are estimated as 1.90% of sales. b. Assume that the company changes its estimate of uncollectible credit sales to 1.90% in Year 1, 2.90% in Year 2 and 2.40% in Year 3. Calculate the Bad Debt Expense and net income for each of the three years under this alternative scenario.arrow_forward1.) Beltline Co. had credit sales of $100,000 for the year, and based on experience estimates that approximately 1% of these sales will be uncollectible. Under the percent of sales method, a.the adjusting entry to record the uncollectible sales would involve a debit to Allowance for Doubtful Accounts and a credit to Bad Debt Expense. b.the estimated uncollectible sales should not be recorded until there is firm evidence that a customer will not pay. c.the estimated bad debt expense is $1,000. d.the estimated bad debt expense is $10,000. 2.) Under the percentage of receivables method theory, a.the majority of accounts receivable portion will not be collected. b.some portion of the existing accounts receivable will not be collected. c.the percentage of uncollectible accounts is calculated as Average Uncollectible Accounts divided by Average Accounts Receivable. d."some portion of the existing accounts receivable will not be collected" and "the percentage of uncollectible…arrow_forward
- During Burns Company's first year of operations, credit sales totaled $180,000 and collections on credit sales totaled $125,000. Burns estimates that bad debt losses will be 1.0% of credit sales. By year-end, Burns had written off $500 of specific accounts as uncollectible. Required: 1. Prepare all appropriate journal entries relative to uncollectible accounts and bad debt expense. 2. Show the year-end balance sheet presentation for accounts receivable. Complete this question by entering your answers in the tabs below. Required 1 Required 2 re all appropriate journal entries relative to uncollectible accounts and bad debt expense. Note: If no entry is required for a transaction/event, select "No journal entry required" in the first account field. View transaction list Journal entry worksheet 1 2 Record the entry to write-off specific accounts. Note: Enter debits before credits. Transaction 1 Record entry General Journal Clear entry Debit Credit View general journalarrow_forwardAt the end of the current year, the unadjusted trial balance of Branco, Incorporated, indicated $5,840,000 in Accounts Receivable, a credit balance of $9,600 in Allowance for Doubtful Accounts, and Sales Revenue (all on credit) of $160,360,000. Based on knowledge that the current economy is in distress, Branco increased its bad debt rate estimate to 0.2 percent of credit sales. Required: 1. What amount of bad debt expense should be recorded for the current year? 2. What amount will be reported on the current year's balance sheet for accounts receivable? Bad debt expense of current year Accounts receivable of current yeararrow_forwardDuring Burns Company's first year of operations, credit sales totaled $180,000 and collections on credit sales totaled $125,000. Burns estimates that bad debt losses will be 1.0% of credit sales. By year-end, Burns had written off $500 of specific accounts as uncollectible. Required: Prepare all appropriate journal entries relative to uncollectible accounts and bad debt expense. Show the year-end balance sheet presentation for accounts receivable.arrow_forward