1)
Compute the Component percentage for the year 2.
1)
Explanation of Solution
Component percentage analysis: Component percentage analysis is prepared to analyse the relationship among various items of the financial statements with a particular base amount. This analysis is also called as common-size statement.
Compute the component percentage for the Year 2.
Corporation S | ||
Income Statement | ||
For the year ended Year 2 | ||
Particulars | Year 2 | |
Amount | Percent | |
Sales revenues | $ 453,000 | 100 % |
Less: Cost of goods sold | ($ 250,000) | -55.19% |
Gross profit | $ 203,000 | 44.81% |
Less: Operating expenses (Including interest on bonds) | ($ 167,000) | -36.87% |
Pre-tax income | $ 36,000 | 7.95% |
Less: Income tax expense | ($ 10,800) | -2.38% |
Net income | $ 25,200 | 5.56% |
Table (1)
Corporation S | ||
Balance Sheet | ||
As on Year 2 | ||
Particulars | Year 2 | |
Amount | Percent | |
Cash | $ 6,800 | 3.33% |
$ 42,000 | 20.59% | |
Merchandise Inventory | $ 25,000 | 12.25% |
Prepaid expenses | $ 200 | 0.10% |
Property and equipment (net) | $ 130,000 | 63.73% |
Total assets | $ 204,000 | 100.00% |
Accounts payable | $ 17,000 | 8.33% |
Income taxes payable | $ 1,000 | 0.49% |
Bonds payable (Interest rate: 10%) | $ 70,000 | 34.31% |
Common stock($10 par value) | $ 100,000 | 49.02% |
$ 16,000 | 7.84% | |
Total liabilities and equity | $ 204,000 | 100.00% |
Table (2)
In the income statement, base amount is sales revenue. In the balance sheet, base amount is total assets.
2)
Compute the ratios in the DuPont model for Year 2.
2)
Explanation of Solution
DuPont model:
It is a model which allows the analyst to analyse a company’s performance using ratios. This model uses the ratios which indicates the company performance. DuPont model equiation is as follows:
Calculate the ratios in the DuPont model for Year 2.
Ratio | Formula | Calculation | Result | |
1 | Return on Equity (ROE) | 23.11% | ||
2 | Return on Assets (ROA) | 13.44% | ||
3 | Total asset turnover | 2.416 | ||
4 | Net profit margin | 5.56% | ||
5 | Financial leverage | 2.60 |
Table (3)
Working notes:
Calculate the average total stockholders’ equity
Average common stock for the year 2
Average total assets for the Year 2:
Want to see more full solutions like this?
Chapter 13 Solutions
FIN.ACCTG.: ACC 101: CUSTOM TEXT+CONNEC
- The condensed financial statements of Ivanhoe Company for the years 2020-2021 are presented below: (See Images) Compute the following financial ratios by placing the proper amounts for numerators and denominators. (Round per unit answers to 2 decimal places, e.g. 52.75.) (a) Current ratio at 12/31/21 $ $ (b) Acid test ratio at 12/31/21 $ $ (c) Accounts receivable turnover in 2021 $ $ (d) Inventory turnover in 2021 $ $ (e) Profit margin on sales in 2021 $ $ (f) Earnings per share in 2021 $ (g) Return on common stockholders’ equity in 2021 $ $ (h) Price earnings ratio at 12/31/21 $ $ (i) Debt to assets at 12/31/21 $ $ (j) Book value per share at 12/31/21 $arrow_forwardNot Graded Using the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56arrow_forwardRefer 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_forward
- Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Debt ratioarrow_forwardThe comparative financial statements of Global Technology are as follows: Review the worksheet RATIOA that follows these requirements. You have been asked to perform a ratio analysis of this company for 2012.arrow_forwardTwenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Current ratioarrow_forward
- Cuneo 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_forwardTwenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Price-earnings rationarrow_forwardTwenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Quick ratioarrow_forward
- Data for Lozano Chip Company and its industry averages follow. Calculate the indicated ratios for Lozano. Construct the extended DuPont equation for both Lozano and the industry. Outline Lozano’s strengths and weaknesses as revealed by your analysis. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars)arrow_forwardTwenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Ratio of fixed assets to long-term liabilitiesarrow_forwardProfitability metrics The following selected data were taken from the financial statements of The O'Malley Group Inc. for December 31, 20Y5. 20Y4. and 20Y3: No dividends on common stock were declared between 20Y3 and 20Y5. a.Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity Tor the years 20Y4 and 20Y5. Round to one decimal place. b. What conclusions can be drawn from these data as to the company's profitability?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub