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% |
Accounts receivable (net) | $ 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% |
Retained earnings | $ 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
Financial Accounting
- VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…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_forward
- Base on the financial ratios of company A, what is your recommendations and conclusion for company A.arrow_forwardRequired: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leveragearrow_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_forward
- Using 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_forwardBelow are three ratios introduced in your text. Describe the purpose for each of them, and also state the formula for calculating them: a. Revenue Per Employee Ratio: b. Quick Ratio: c. Fixed Assets Ratio:arrow_forwardSolve and perform the different financial ratios using the financial statements of XYZ Company for the year 2021. 1. Current Ratio 2. Quick Ratio 3. Receivables Turnover 4. Inventory Turnover 5. Debt Ratio 6. Equity Ratio 7. Times Interest Earned 8. Gross Profit Margin 9. Operating Profit Margin 10. Net Profit Marginarrow_forward
- b. Comment on each of the ratios calculated in part (a). ABOVE IS THE QUESTION THAT I NEED ANSWER, BELOW IS THE QUESTION (A) ANSWER THAT MENTIONED IN QUESTION (B) a) Calculate the following ratios for Company A and Company B. State clearly the formulae used for each ratio: ANSWER i) Gross Profit Margin Formula: Gross profit Margin = ( Gross profit / Net sales ) x 100 Company A : = ( 40000 / 160000 ) x 100 = 25 % Company B : = ( 60000 / 240000 ) x 100 = 25 % ii)Net Profit Margin Net profit Margin = ( Net profit / Net sales ) x 100 Company A : = ( 9000 / 160000 ) x 100 = 5.625 % Company B: = ( 18000 / 240000 ) x 100 = 7.5 % iii) Inventory Turnover Period (days) Inventory Turnover Period (days) = ( Inventory / Cost of sales ) x 365 Company A: = ( 30000 / 120000 ) x 100 = 25 % Company B: = ( 50000 / 180000 ) x 100 = 27.777 % iv) Receivables Collection Period (days) Receivables Collection Period (days) = ( Receivables / Net sales ) x 365…arrow_forwarda) 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. Gearingarrow_forwardPrepare the common-size financial statement for the entities below and provide a reasoned explanation of the benefits relative to ratios when used to compare performance and establish trends. Income statements for year ending 31 December 2020 Energy Plus Co. ltd V8 Splash Ltd. $’000 $’000 Net revenue 35,119 30,990 Cost of goods sold 12,693 11,088 Gross profit 22,426 19,902 Selling & administrative expenses 13,158 11,358 Other operating expenses 819…arrow_forward
- 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 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