Analyzing Comparative Financial Statements Using Selected Ratios
Use the data given in CP13-1 for Golden Corporation.
Required:
- 1. Compute the gross profit percentage for the current and previous years. Round the percentages to one decimal place. Are the current year results better, or worse, than those for the previous year?
- 2. Compute the net profit margin for the current and previous years. Round the percentages to one decimal place. Are the current year results better, or worse, than those for the previous year?
- 3. Compute the earnings per share for the current and previous years. Are the current year results better, or worse, than those for the previous year?
TIP: To calculate EPS, use the balance in Common Stock to determine the number of shares outstanding. Common Stock equals the par value per share times the number of shares.
- 4. Stockholders’ equity totaled $30,000 at the beginning of the previous year. Compute the return on equity (ROE) ratios for the current and previous years. Express the ROE as percentages rounded to one decimal place. Are the current year results better, or worse, than those for the previous year?
- 5. Net property and equipment totaled $35,000 at the beginning of the previous year. Compute the fixed asset turnover ratios for the current and previous years. Round the ratios to two decimal places. Are the current year results better, or worse, than those for the previous year?
- 6. Compute the debt-to-assets ratios for the current and previous years. Round the ratios to two decimal places. Is debt providing financing for a larger or smaller proportion of the company’s asset growth? Explain.
- 7. Compute the times interest earned ratios for the current and previous years. Round the ratios to one decimal place. Are the current year results better, or worse, than those for the previous year? Explain.
- 8. After Golden released its current year’s financial statements, the company’s stock was trading at $30. After the release of its previous year’s financial statements, the company’s stock price was $21 per share. Compute the P/E ratios for both years, rounded to one decimal place. Does it appear that investors have become more (or less) optimistic about Golden’s future success?
1.
To Compute: The gross profit percentage for current and previous year.
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.
Compute the gross profit percentage for the previous year.
Compute the gross profit percentage for the current year.
By comparing the percentage gross profit percentage of Corporation G during previous year (39.4%) with current year (38.9%) there is a decrease in the gross profit percentage by 0.5cents in current year which is slightly lower than previous year this indicates that company is earning lower profit for per dollar of sales.
2.
To Compute: The net profit margin for current and previous year.
Explanation of Solution
Net Profit margin:
This ratio gauges the operating profitability by quantifying the amount of income earned from business operations from the sales generated.
Compute the net profit margin for previous year.
Compute the net profit margin for the current year.
The net profit margin for the current year is slightly higher (5.6%) comparing to the previous year net profit margin (5.5%). Thus the Corporation G is functioning better in the current year.
Working Notes:
Corporation G | ||||
Particulars | Current (A) | Previous (B) | Increase or Decrease | |
Amount |
Percentage
|
|||
Income statement | ||||
Sales revenue | $180,000 | $165,000 | $15,000 | 9.1% |
Less: Cost of goods sold | $110,000 | $110,000 | $0 | 0.0% |
Gross profit | $70,000 | $65,000 | $5,000 | 7.7% |
Less: Operating expenses: | $53,300 | $50,400 | $2,900 | 5.8% |
Interest expenses | $2,700 | $2,600 | $100 | 3.8% |
Income before income taxes | $14,000 | $12,000 | $2,000 | 16.7% |
Less: income tax expense | $4,000 | $3,000 | $1,000 | 33.3% |
Net income | $10,000 | $9,000 | $1,000 | 11.1% |
Balance sheet: | ||||
Cash | $4,000 | $8,000 | ($4,000) | (50.0%) |
Accounts receivable | $19,000 | $23,000 | ($4,000) | (17.4%) |
Inventory | $40,000 | $35,000 | $5,000 | 14.3% |
Property and equipment | $45,000 | $38,000 | $7,000 | 18.4% |
Total assets | $108,000 | $104,000 | $4,000 | 3.8% |
Current liabilities | $16,000 | $19,000 | ($3,000) | (15.8%) |
Long term notes payable | $45,000 | $45,000 | $0 | 0.0% |
Common stock | $30,000 | $30,000 | $0 | 0.0% |
Additional paid in capital | $5,000 | $5,000 | $0 | 0.0% |
Retained earnings | $12,000 | $5,000 | $7,000 | 140.0% |
Total liabilities and stockholders' equity | $108,000 | $104,000 | $4,000 | 3.8% |
Table (1)
3.
To Compute: The earnings per share for the current year and previous year.
Explanation of Solution
Earnings per share:
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.
Calculate the earnings per share for the previous year.
Calculate theearnings per share for the current year.
Company’s earnings per share has an Eps of ($1.40)which is comparatively higher than previous year earnings per share ($1.09), there is an increased Eps by 0.31cents($1.40 -$1.09). Increase in the EPS value shows a good profit for the stockholder’s for the investment made by them.
Working Notes:
4.
To Compute: The return on equity for current and previous each year.
Explanation of Solution
Return on equity:
Return on equity is used to determine the relationship between the net income available for the common stockholders’ and the average common equity that are invested in the company.
Calculate the return on equity for the previous year.
Calculate the return on equity for the current year.
Company has generated less return on equity in current year (23.0%) which is comparatively lower than the return on equity of previous year (25.7%). Decrease in the return on equity decrease the net profit margin of Corporation G.
Working Notes:
Calculate Average stockholder’s equity for the previous year.
Calculate Average stockholder’s equity for the current year.
5.
To Compute: The fixed asset turnover for current and previous year.
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.
Calculate the fixed asset turnover for the previous year.
Calculate the fixed asset turnover for the current year.
Corporation G has utilized its fixed assets in previous year than current year as the fixed asset turnover ratio is higher in previous year (4.52) comparing to the current year (4.34)
Working Notes:
Calculate the fixed asset turnover for the previous year.
Calculate the fixed asset turnover for the current year.
6.
To Compute: The debt –to-asset for current and previous year.
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.
Compute the debt – to - asset for the previous year.
Compute the debt – to - asset for the current year.
The debt-to-asset asset ratio of current year is decreased (0.56) comparing to the previous year (0.62). The Corporation’s assets are financed less by debt, so the company is functioning better in the current year.
7.
To Compute: The times interest earned for current and previous year.
Explanation of Solution
Times Interest Earned Ratio:
It’s a measure to evaluate the net income for interest payment on debt of a company. It is a part of solvency ratios.
Compute the time interest earned for previous year.
Compute the time interest earned for current year.
The times interest earned ratio has improved by 0.6 cents (6.2-5.6). Corporation G times interest earned ratio for the current year(6.2) shows that the company has enough net income which is earned before paying interest and income taxes to meet out their interest expense for the year.
8.
To Compute: The price earnings ratio for current and previous year.
Explanation of Solution
Price/Earnings Ratio:
It depicts the relation of market price of a share to earnings per share of that company. The price/earnings ratio presents 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.
Compute the price earnings ratio for previous year.
Compute the price earnings ratio for current year.
The price earnings ratio of Corporation G is increased in current year (18.0) comparing to the previous year (14.0) . The investors believe that the Corporation has great potential for future growth and profitability.
Want to see more full solutions like this?
Chapter 13 Solutions
Loose-leaf for Fundamentals of Financial Accounting with Connect
- 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_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardRevenue and expense data for Gresham Inc. for two recent years are as follows: a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.arrow_forward
- ANALY SIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1A, compute the following profitability measures for 20-2 (round all calculations to two decimal places): (a) Profit margin ratio (b) Return on assets (c) Return on common stockholders equity (d) Earnings per share of common stockarrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardThe income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Includes both state and federal taxes. Refer to the information for Somerville Company on the previous pages. Also, assume that the price per common share for Somerville is 8.10. Required: Compute the price-earnings ratio. (Note: Round the answer to two decimal places.)arrow_forward
- Sundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)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 (round 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
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning