Inferring Information from the DuPont Model Ratios
LO13-5 in this chapter, we discussed the DuPont model. Using that framework, find the missing amount in each of the following cases:
Case 1: ROE is 10 percent; net income is $200,000; the total asset turnover ratio is 5; and net sales are $1,000,000. What is the amount of average stockholders’ equity?
Case 2: Net income is $1,500,000; net sales are $8,000,000; average stockholders’ equity is $12,000,000; ROE is 22 percent; and the total asset turnover ratio is 8. What is the amount of average total assets?
Case 3: ROE is 15 percent; the net profit margin is 10 percent; the total asset turnover ratio is 5; and average total assets are $1,000,000. What is the amount of average stockholders’ equity?
Case 4: Net income is $500,000; ROE is 15 percent; the total asset turnover ratio is 5; net sales are $1,000,000; and financial leverage is 2. What is the amount of average total assets?
1.
Compute the amount of average stockholders’ equity using the DuPont model.
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 that indicate the company performance. DuPont model equation is as follows:
Return on equity ratio: Rate of return on equity ratio is used to determine the relationship between the net income available for the common stockholders’ and the average common equity that is invested in the company.
Determine the amount of average stockholders’ equity.
Hence, the amount of average stockholders’ equity is $200,000.
2.
Compute the amount of average total assets using the DuPont model.
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 that indicate the company performance. DuPont model equation is as follows:
Total Asset turnover: Total asset turnover is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets.
Determine the amount of average total assets.
Hence, the amount of average total assets is $1,000,000.
3.
Compute the amount of average stockholders’ equity.
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 that indicate the company performance. DuPont model equation is as follows:
Total Asset turnover: Total asset turnover is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets.
Return on equity ratio: Rate of return on equity ratio is used to determine the relationship between the net income available for the common stockholders’ and the average common equity that is invested in the company.
Determine the amount of average stockholders’ equity.
Working Note:
Determine the amount of average asset turnover.
Determine the amount of net income.
Hence, the amount of average stockholders’ equity is $3,333,333.
4.
Compute the amount of average total assets using the DuPont model.
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 that indicate the company performance. DuPont model equation is as follows:
Total Asset turnover: Total asset turnover is a ratio that measures the productive capacity of the total assets to generate the sales revenue for the company. Thus, it shows the relationship between the net sales and the average total assets.
Determine the amount of average total assets.
Hence, the amount of average total assets is $200,000.
Want to see more full solutions like this?
Chapter 13 Solutions
EBK FINANCIAL ACCOUNTING
- Profitability 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_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_forwardYou are considering two possible companies for investment purposes. The following data is available for each company. Additional Information: Company A: Bad debt estimation percentage using the income statement method is 6%, and the balance sheet method is 10%. The $230,000 in Other Expenses includes all company expenses except Bad Debt Expense. Company B: Bad debt estimation percentage using the income statement method is 6.5%, and the balance sheet method is 8%. The $140,000 in Other Expenses includes all company expenses except Bad Debt Expense. A. Compute the number of days sales in receivables ratio for each company for 2019 and interpret the results (round answers to nearest whole number). B. If Company A changed from the income statement method to the balance sheet method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations). C. If Company B changed from the balance sheet method to the income statement method for recognizing bad debt estimation, how would that change net income in 2019? Explain (show calculations). D. What benefits do each company gain by changing their method of bad debt estimation? E. Which company would you invest in and why? Provide supporting details.arrow_forward
- 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_forwardValero Energy, a petroleum company, reported net income of 1,803.8 on revenues of 54,618.6 for Year 4. Interest expense totaled 359.7, and preferred dividends totaled 12.5. Average total assets for Year 4 were 17,527.9. The income tax rate is 35%. Average preferred shareholders equity totaled 204.3, and average common shareholders equity totaled 6,562.3. All amounts are in millions. a. Compute the rate of ROA. Disaggregate ROA into profit margin for ROA and assets turnover components. b. Compute the rate of ROCE. Disaggregate ROCE into profit margin for ROCE, assets turnover, and capital leverage ratio components. c. Calculate the amount of net income to common shareholders derived from the excess return on creditors capital, the excess return on preferred shareholders capital, and the return on common shareholders capital.arrow_forwardPayne Products had $1.6 million in sales revenues in the most recent year and expects sales growth to be 25% this year. Payne would like to determine the effect of various current assets policies on its financial performance. Payne has $1 million of fixed assets and intends to keep its debt ratio at its historical level of 60%. Payne’s debt interest rate is currently 8%. You are to evaluate three different current asset policies: (1) a restricted policy in which current assets are 45% of projected sales, (2) a moderate policy with 50% of sales tied up in current assets, and (3) a relaxed policy requiring current assets of 60% of sales. Earnings before interest and taxes are expected to be 12% of sales. Payne’s tax rate is 40%. What is the expected return on equity under each current asset level? In this problem, we have assumed that the level of expected sales is independent of current asset policy. Is this a valid assumption? Why or why not? How would the overall risk of the firm vary under each policy?arrow_forward
- Using the data in the following table for a number of firms in the same industry, do the following: Firm (in Millions of Dollars) A B C D Sales $15 $10 $15 $30 Net income after tax 1.75 0.50 2.00 1.50 Total assets 6.0 18.0 8.0 15.5 Stockholders' equity 13.0 10.0 6.0 5.0 Compute the total asset turnover, the net profit margin, the equity multiplier, and the return on equity for each firm. Round your answers to two decimal places. A B C D Total Asset Turnover x x x x Net Profit Margin Equity Multiplier x x x x Return on Equity Evaluate each firm’s performance by comparing the firms with one another. Which firm has the lowest total asset turnover value?-Select-Firm AFirm BFirm CFirm DItem 17Which firm has the lowest net profit margin value?-Select-Firm AFirm BFirm CFirm DItem 18Which firm has the lowest equity multiplier value?-Select-Firm AFirm BFirm CFirm DItem 19Which firm has the lowest return on equity value?-Select-Firm…arrow_forwardOne third of company X's asset purchases were financed by taking out a loan from the bank. The remainder of the asset purchases were financed by selling shares of company X's common stock. What is the financial leverage (ratio) that describes this situation? Round your answer to two decimal places if necessary. Report any percentages as decimals (ie: write .05 instead of 5%). The answer is not 0.5 or 0.33arrow_forwardLas year Justine Corp. had sales of P315,000 and a net income of P17,382, and its year-end assets were P210,000. Justine's total debt to total assets ratio was 42.5%. Based on the Du Pont equation, what was Justine's return on equity (ROE)?arrow_forward
- Last year Justine Corp. had sales of P315,000 and a net income of P17,382 and its year-end assets were P210,000. Justine's total-debt-to-total-assets ratio was 42.5%. Based on the Du Pont equation, what was Justine's return on equity (ROE)?arrow_forwardBorland, Inc., has a profit margin of 6.5 percent on sales of $22,600,000. Assume the firm has debt of $8,700,000 and total assets of $15,300,000. What is the firm’s ROA? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardUsing the DuPont method, evaluate the effects of the following relationships for the Butters Corporation. A.Butters Corporation has a profit margin of 5.5 percent and its return on assets (investment) is 8.75 percent. What is its assets turnover? Round your answer to 2 decimal places. ______ times B.If the Butters Corporation has a debt-to-total-assets ratio of 65.00 percent, what would the firm’s return on equity be? Note: Input your answer as a percent rounded to 2 decimal places. C.What would happen to return on equity if the debt-to-total-assets ratio decreased to 60.00 percent? Input your answer as a percent rounded to 2 decimal places.arrow_forward
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning