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
- Read the instructions below and see the attached balance sheet of moon and star cooperation to support your answer. Moon Corporation and Star Corporation are in the same line of business and both were recently organized, so it may be assumed that the recorded costs for assets are close to current market values. The balance sheets for the two companies are as follows at July 31, 2011: Instructions a. Assume that you are a banker and that each company has applied to you for a 90-day loan of $12,000. Which would you consider to be the more favorable prospect? Explain your answer fully. b. Assume that you are an investor considering purchasing all the capital stock of one or both of the companies. For which business would you be willing to pay the higher price? Do you see any indication of a financial crisis that you might face shortly after buying either company? Explain your answer fully. (For either decision, additional information would be useful, but you are to reach your decision on…arrow_forwardou are a credit analyst of a growing commercial bank and have recently received loan applications from two companies of relatively similar size. Show below are selected financial data for these two applicants at the end of the current year: RED CO BLUE CO. Net credit sales P700,000.00 P650,000.00 Cost of goods sold P500,000.00 P490,000.00 Cash P60,000.00 P20,000.00 Accounts receivable (net) P77,000.00 P60,000.00 Inventory P94.000.00 P180.000.00 Current liabilities P110.b00.00 P105,000.00 Assume that the year-end balances for accounts receivable and for inventory approximate the average balances of these items throughout the year. A. Compute the following on RED 1. Inventory turnover 2. Days sales in inventory 3. Operating cyclearrow_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
- You 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_forwarda. Beauty of the Sea purchased inventory from a large supplier. The supplier offered a credit term of 3/10, n/30. Indicate whether this debt is an example of account payable, long-term or short-term debt. b. Adoptions and More drew on 8 annual notes totaling $250,000 to be paid upon completion of the office it is building. The company intends to pay $75,000 next year. What is that portion considered?arrow_forwardAs loan analyst for Blue Spruce Bank, you have been presented the following information. Assets Cash Receivables Inventories Total current assets Other assets Total assets Liabilities and Equity Current liabilities Long-term liabilities Capital stock and retained earnings Total liabilities and equity Annual sales Rate of gross profit on sales Sunland Co. $220,000 115,000 515,500 850,500 221,000 $1,071,500 $243,000 208,000 620,500 $1,071,500 $1,340,000 35% Carla Vista Co. $143,000 251,000 372,000 766,000 420,000 $1,186,000 $383,000 299,000 504,000 $1,186,000 $2,300,000 25%arrow_forward
- The Yankee Corporation has recently begun to accept credit cards. On July 7, Year 1, Yankee made a credit card sale of $600. Assume that the credit card fee is recorded on the date of sale and that the credit card company charges a fee of 3% for handling a credit card transaction. Which of the following correctly shows the effects of the sale on July 7? Assets 600 A. B. 582 C. 582 D. 600 Multiple Choice O Balance Sheet Liabilities + 18 ΝΑ ΝΑ ΝΑ Option B Option D Option C Option A Stockholders' Equity 582 582 582 600 Revenue 582 600 600 600 Income Statement Expense = Net Income Statement of Cash Flows ΝΑ ΝΑ 18 582 0A 18 ΝΑ 582 582 582 600 ΝΑ ΝΑarrow_forwardLyon County Bank agrees to lend the Grimwood Brick Company $100,000 on January 1. Grimwood Brick Company signs a $100,000, 8%, 9 month 33. The entry made by Grimwood Brick Company on January 1 to record the rmation below for questions 33 and 34 flower shop follows GAAP and applies the revenue recognition principle. When is b. when the performance obligation is satisfied. A flower shop makes a large sale for $1,000 on November 30. The customer is the $1.000 considered to be recognized? d. in the period that income taxes are paid sent a statement on December 5 and a check is received on December 10. The note. on proceeds and issuance of the note is a. Interest Expense. Cash 6,000 94,000 Notes Payable b. Cash 100,000 100,000 Notes Payable c. Cash Interest Expense Notes Payable d. Cash. Interest Expense Notes Payable Interest Payable 34. What is the adjusting entry required if Grimwood Brick Company prepares financial statements on June 30? a. Interest Expense. Interest Payable b. Interest…arrow_forwardDunder-Mifflin Inc. wanted to expand its manufacturing and sales facilities. The company applied for a loan from First Bank, presenting the prior-year audited financial statements and the forecast for the current year shown inExhibit 4.56.1. (Dunder-Mifflin Inc.’s fiscal year-end is December 31.) The bank was impressed with the business prospects and granted a $1,750,000 loan at 8 percent interest to finance working capital and the new facilities that were placed in service July 1 of the current year. Because Dunder-Mifflin Inc. planned to issue stock for permanent financing, the bank made the loan due on December 31 of the following year. Interest is payable each calendar quarter on October 1 of the current year and January 1, April 1, July 1, October 1 of the following year.The auditors’ interviews with Dunder-Mifflin Inc. management near the end of the current year produced the following information: The facilities did not cost as much as previously anticipated. However, sales were…arrow_forward
- As loan analyst for Headland Bank, you have been presented the following information. Assets Cash Receivables Inventories Total current assets Other assets Total assets Liabilities and Stockholders' Equity. Current liabilities Long-term liabilities Capital stock and retained earnings Total liabilities and stockholders' equity Annual sales Rate of gross profit on sales Toulouse Co. $122,000 225,000 564,000 911,000 502,000 $1,413,000 $299,000 398,000 716,000 $1,413,000 $964,000 30 % Lautrec Co. $332,000 313,000 541,000 1,186,000 638,000 $1,824,000 $353,000 502,000 969,000 $1,824,000 $1,548,000 40 %arrow_forwardHoffman Paper Company, a profitable distributor of stationery and office supplies, has an agreement with its banks that allows Hoffman to borrow money on a short-term basis to finance its inventories and accounts receivable. The agreement states that Hoffman must maintain a current ratio of 1.5 or higher and a debt ratio of 50 percent or lower. Cash 2$ 55,000 Current liabilities $ 210,000 Accounts receivable 150,000 Long-term debt 300,000 Inventory 255,000 Stockholders' equity 630,000 Fixed assets (net) 680,000 Total liabilities and stockholders' equity $1,140,000 Total assets $1,140,000 Given the balance sheet provided above, determine how much additional money Hoffman could borrow at this time to invest in inventory and accounts receivable without violating the terms of its borrowing agreement. Round your answer to the nearest dollar. $arrow_forwardUsing the data in the preceding question, what will the income statement for the year ended December 31 report for this situation? Nothing because the business has not received the cash yet Note receivable of $8,400 Interest revenue of $700 Both b and c Reference Problem On December 31 year-end, Crain Corporation has an $8,400 note receivable from a customer. The interest of 10% has accrued for 10 months on the note. What will Crain’s financial statements report for this situation? The balance sheet will report the note receivable of $8,400. The balance sheet will report the note receivable of $8,400 and interest receivable of $700. Nothing because the business has not received the cash yet. The income statement will report a note receivable of $8,400.arrow_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 College