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 | ||
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
GB 112/212 MANAGERIAL ACC. W/ACCESS >C<
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning