Analyzing Comparative Financial Statements Using Selected Ratios
Use the data given in PA13-1 for Pinnacle Plus.
Required:
- 1. Compute the gross profit percentage in 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?
- 4. Stockholders’ equity totaled $100,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 $110,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?
- 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?
- 8. After Pinnacle Plus released its current year’s financial statements, the company’s stock was trading at $18. After the release of its previous year’s financial statements, the company’s stock price was $15 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 Pinnacle’s future success?
1.
To Compute: the gross profit percentage for current and previous year.
Explanation of Solution
Financial Ratios
Financial ratios are the metrics used to evaluate the capabilities, profitability, and overall performance of a company.
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 Company PP during previous year (51.5%) with current year (52.7%) there is an increase in the gross profit percentage by 1.2cents in current year which is comparatively higher than previous year this indicates that company is earning high profit for per dollar of sales.
2.
To Compute: the net profit margin for current and previous year.
Explanation of Solution
Compute the net profit margin for previous year.
Compute the net profit margin for the current year.
Company PPdid better job in current year compared to the previous year net profit margin.
Working Notes:
Company PP | ||||
Financial statement | ||||
December 31 | ||||
Particulars |
Current year Amount ($)(A) |
Previous year Amount ($)(B) |
||
$ |
||||
Income statement | ||||
Sales revenue | 110,000 | 99,000 | 11,000 | 11.1 |
Cost of goods sold | 52,000 | 48,000 | 4,000 | 8.3 |
Gross profit | 58,000 | 51,000 | 7,000 | 13.7 |
Operating expenses | 36,000 | 33,000 | 3,000 | 9.1 |
Interest expenses | 4,000 | 4,000 | 0 | 0 |
Income before income tax expense | 18,000 | 14,000 | 4,000 | 28.6 |
Income tax expense (30%) | 5,400 | 4,200 | 1,200 | 28.6 |
Net income | 12,600 | 9,800 | 2,800 | 28.6 |
Balance sheet | ||||
Cash | 69,500 | 38,000 | 31,500 | 82.9 |
Accounts receivable | 17,000 | 12,000 | 5,000 | 41.7 |
Inventory | 25,000 | 38,000 | (13,000) | (34.2) |
Property and equipment | 95,000 | 105,000 | (10,000) | (9.5) |
Total assets | 206,500 | 193,000 | 13,500 | 7 |
Accounts payable | 42,000 | 35,000 | 7,000 | 20 |
Income tax payable |
1,000 | 500 | 500 | 100 |
Note payable(long-term) | 40,000 | 40,000 | 0 | 0 |
Total liabilities | 83,000 | 75,500 | 7,500 | 9.9 |
Common stock(par $10) |
90,000 | 90,000 | 0 | 0 |
Retained earnings |
33,500 | 27,500 | 6,000 | 21.8 |
Total liabilities and stockholders’ equity | 206,500 | 193,000 | 13,500 | 7 |
Table (1)
3.
To Compute: the earnings per share for the current year and previous year.
Explanation of Solution
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
Calculate the return on equity for the previous year.
Calculate the return on equity for the current year.
Company has generated more returns on equity in current year (10.5%) which is comparatively higher than the return on equity of previous year (9.0%). Increase in the return on equity increase the net profit margin of Company PP.
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
Calculate the fixed asset turnover for the previous year.
Calculate the fixed asset turnover for the current year.
Company has better utilized its investment in fixed assets in the current year (1.10) which is comparatively high to the utilization of its investment in fixed asset in previous year (0.9) for every dollar invested in fixed assets. Company PP has better utilized its fixed assets in the current year compared to its previous year’s performance.
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
Compute the debt – to - asset for the previous year.
Compute the debt – to - asset for the current year.
Company has received a contribution of 40% from its creditors which is comparatively little higher than the contribution made by its creditors during previous year (39%). Company PP maintains a same debt and equity financing balance in the current year as same as previous year.
7.
To Compute: the time interest earned for current and previous year.
Explanation of Solution
Compute the time interest earned for previous year.
Compute the time interest earned for current year.
Company’s times interest earned ratio has improved by 1.0 cents (5.5-4.5). Company PP times interest earned ratio for the current year(5.5) 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
Compute the price earnings ratio for previous year.
Compute the price earnings ratio for current year.
Price earnings ratio of Company PP shows that investors have become less confident about the future success of the company because the company price earnings ratio has decreased by 13.8 to 12.9 in the current year by 0.9 cents which is comparatively less than the price earnings ratio of previous year. Increase in the price earnings ratio shows that investors of the company have trust in company’s future performance and their increase in profits. Lower price earnings ratioshows that investors of the company do not expecteffective financial performance.
Want to see more full solutions like this?
Chapter 13 Solutions
Loose-leaf for Fundamentals of Financial Accounting with Connect
- Refer to the information for Sundahl Company on the previous page.Required:1. Prepare a common-size income statement for Year 1 by expressing each line item as apercentage 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 apercentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardWhich of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.arrow_forwardCompute the following for year 2: 2-a. Percentage markup on sales. (Round percentage answer to 1 decimal place (i.e., 0.124 should be entered as 12.4) 2-b. Income tax rate. (Round percentage answer to 1 decimal place (i.e., 0.124 should be entered as 12.4).) 2-c. Net profit margin ratio. Was it a good or poor indicator of performance? (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) 2-d. Percentage of total resources invested in property, plant, and equipment. (Round percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) 2-e. Debt-to-equity ratio. Interpret the result. (Round the final answer to 2 decimal places.) 2-f. Return on assets. Assume that long-term debt increased to $36,810 in month 1 of year 2. (Round intermediate calculations to 3 decimal places and percentage answer to 2 decimal places (i.e., 0.1243 should be entered as 12.43).) 2-g. Return on equity. (Round percentage answer to 2 decimal places (i.e.,…arrow_forward
- a) Based on the information provided, calculate the following ratios for the years ended 31December 2021 and 2020.You should give the formula for each ratio, in addition to your calculation.I. Gross profit marginII. Operating profit marginIII. Return on equityIV. Current ratioV. Gearing b) By comparing the financial information for years ended 31 December 2021 and 2020, andreviewing your ratio calculations, comment on the profitability, liquidity, and long-termsolvency of Mabel’s business over the past year. You should use the other information givento suggest reasons for any changes identified. c)If an investor was interested in buying Mabel’s business and was presented with theseresults, what further advice would you give them?arrow_forwardUsing the information from 27A prepare the following ratios: gross profit margin profit margin return on assets earnings per share current ratio acid test ratio debt ratio Indicate what each is used for (ie: measuring efficiency, solvency etc)arrow_forwarda. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.arrow_forward
- Analyze the ratios and give you a report on the same. Gross Profit Ratio = Gross Income/ Sales = 3073.7/10577 = 29.06% Net Profit Ratio = Net Income/ Sales = 80.3/10577 = 0.76% Current Ratio = Current Assets/ Current Liabilities Liquid Ratio = 3581.3/6150 = 58.23% = 7439.2/6150 = 1.21arrow_forwardPrepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place. Yesarrow_forwardIncome statements for Campbell Company for Year 3 and Year 4 follow: CAMPBELL COMPANY Income Statements Year 4 Year 3 $180,800 120,400 19,900 14,500 Sales $200,800 Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses 142,400 21,900 12,500 3,900 $180,700 5,900 $160,700 20,100 3,700 Income before taxes 20,100 Income taxes expense 6,500 Net income $ 13,600 $ 16,400 Required a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year. Complete this question by entering your answers in the tabs below. Required A Required B Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be entered…arrow_forward
- 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 Year2 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)2. Prepare a common-size income statement for Year 3 by expressing each line item for Year3 as a percentage of that same line item from Year 1. (Note: Round percentages to thenearest tenth of a percent.)arrow_forwardQuestion 1 Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres across the south of England. Extracts from her financial statements for the years ended 31 December 2021 and 2020 are shown below. Statement of profit or loss for the year ended 31 December: 2021 28,900 |(16,500) 12,400 (3,800) 8,600 |(4,000) 4,600 2020 Revenue 27,200 (14,000) 13,200 (3,600) 9,600 Cost of sales Gross profit Operating expenses Operating profit Non-operating expenses Net profit 9,600 Statement of financial position as at 31 December: 2021 Non-current assets Current assets Total assets 22,660 4,360 27,020 2020 20,920 3,750 24,670 Equity Non-current liabilities Current liabilities Equity and liabilities 20,940 3,000 3,080 27,020 16,340 3,500 4,830 24,670 The following information is also relevant: In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in three years so she decided not to renew the annual contract. She sold…arrow_forwardchoose: When a balance sheet amount is related to an income statement amount in comparing a ratio a. The ratio losses its historical perspective because at the beginning of the year amount is combined with an end of the year amount. b. The income statement amount should be converted to an average for the year. c. Comparisons should be converted to market value d. The balance sheet amount should be converted to an average for the year.arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education