Question

I calculated the dupont model for Ford 2001 & GM 2001. I calculated the profit margin,...

I calculated the dupont model for Ford 2001 & GM 2001. I calculated the profit margin, asset turnover, financial leverage and ROE to be as follows. Can someone verify the following to see if I did it correctly:

Profit Margin (PM) = Net income / Sales

PM Ford 2001 = 65,453 / 162,412 = -0.336

PM GM 2001 = 601 / 177,260 = .0033

Asset Turnover (AT) = Sales / Average total assets

AT Ford 2001 = 162,412 / ((276,543 + 284,421) / 2) = 0.579

AT GM 2001 = 177,260 / ((323969 + 303100) / 2) = 0.565

Return on Assets (ROA) = Net Income / Average Total Assets

ROA Ford 2001 = -5,453 / ((276,543 + 284,421) / 2) = -0.194

ROA GM 2001 = 601 / ((323,969 + 303,100) / 2) = .0019

Financial Leverage (FL) = Average Total Assets / Average stockholder's Equity

FL Ford 2001 = ((276,543 + 284,421)/2) / ((7,786 + 18,610)/2) = 21.251

FL GM 2001 = ((323,969 + 303,100)/2) / ((1,970 + 30,175)/2) = 12.571

Return on Equity (ROE) = PM *AT*FL

ROE Ford 2001 = -3.35751% * .579046 * 21.25185 = -41.316%

ROE GM 2001 = 0.33904% * .56536 * 12.57104 = 2.409%

Homework Answers

Answer #1

in dupont Model Return on Equity=profit margin*assset turn over*financial leverage

#for FORD in 2001

profit margin=net income/sales=65,453/162,412=0.403

Asset turn over ratio=sales/average total asset=162,412/ ((276,543 + 284,421) / 2) =0.579

financial liverage= Average Total Assets / Average stockholder's Equity

  ((276,543 + 284,421)/2) / ((7,786 + 18,610)/2)=280,482/13198=21.251

so,ROE=0.403*0.579*21.251=4.96

#for GM in 2001

Profit Margin =(PM) = Net income / Sales= 601 / 177,260 = 0.00339

Asset Turnover (AT) = Sales / Average total asset= 177,260 / ((323969 + 303100) / 2)=0.565

Financial Leverage (FL) = Average Total Assets / Average stockholder's Equity

= ((323,969 + 303,100)/2) / ((1,970 + 30,175)/2) = 313,534.5/16,072.5=19.507

so,ROE=0.00339*0.565*19.507=0.03736

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
One. The famous Dupont Identity breaks Return on Equity (ROE) into three components: Profit Margin, Total...
One. The famous Dupont Identity breaks Return on Equity (ROE) into three components: Profit Margin, Total Asset Turnover, and Financial Leverage (Assets/Equity). French Corp. has an Asset/Equity ratio of 1.55. Their current Total Asset Turnover has recently fallen to 1.20, bringing their ROE down to 9.1% a) What is this firm's Profit Margin? B) If the company were able to improve its Total Asset Turnover to 1.8, what would be their new ROE? Two. Sousa, Inc., has Sales of $37.3...
Ratios FY Ending 9/30/2000 9/29/2001 Sales growth rate -32.82 Gross profit margin (gross profit/sales) 27.13% 23.03%...
Ratios FY Ending 9/30/2000 9/29/2001 Sales growth rate -32.82 Gross profit margin (gross profit/sales) 27.13% 23.03% Operating profit margin (EBIT/sales) 6.64% -6.21% Net profit margin (net profit/sales) 9.85% -0.47% Cash flow margin (cash flow/sales) 10.87% 3.45% Asset turnover (sales/assets) 1.17 0.89 Equity multiplier (assets/equity) 1.66 1.54 ROA (net income/assets) 0.12 0.00 ROE (net income/equity) 0.19 -0.01 Adjusted equity (equity - investments) 2,317.00 1,208.00 Adjusted ROE (net income/adjusted equity 33.92% -2.07% Financial Statements data ($mil) for FY Ending 9/30/2000 9/29/2001 Total...
5. Link Leisure has an ROE below the industry average, but their profit margin and financial...
5. Link Leisure has an ROE below the industry average, but their profit margin and financial leverage are both above the industry average. Which of the following statements is true about Link Leisure? Its dividend payout must be equal to the industry average Its total asset turnover must be lower than the industry average Its return on assets must be higher than the industry average Its time interest earned ratio must be below the industry average
I need to calculate the following information for Allscripts (MDRX) but I do not know how....
I need to calculate the following information for Allscripts (MDRX) but I do not know how. 1. Liquidity of Short-Term Assets Current Ratio Cash Ratio Quick Ratio 2. Long-Term Debt-paying Ability Debt Ratio Debt-equity Ratio Times Interest Earned 3. Profitability Net Income / Sales (Profit Margin) Net Income / Assets (ROA) Net Income / Shareholder Equity (ROE) 4. Asset Utilization / Management Efficiency Total Asset Turnover Inventory Turnover Measures Accounts Receivable Turnover 5. Market Measures Price / Earnings Ratio Earnings...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($millions) 2015 2014 2013 Net sales $31,718 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 8,390 7,135 6,666 Interest expense and income Interest expense 149 142...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($millions) 2015 2014 2013 Net sales $31,385 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 8,057 7,135 6,666 Interest expense and income Interest expense 149 142...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company...
Compute and Interpret Measures for DuPont Disaggregation Analysis Balance sheets and income statements for 3M Company follow. 3M Company Consolidated Statements of Income For Years Ended Dec. 31 ($millions) 2015 2014 2013 Net sales $30,674 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general & administrative expenses 6,182 6,469 6,384 Research, development & related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 7,346 7,135 6,666 Interest expense and income Interest expense 149 142...
14. The DuPont equation Corporate decision makers and analysts often use a technique called DuPont analysis...
14. The DuPont equation Corporate decision makers and analysts often use a technique called DuPont analysis to understand and assess the factors that drive a company’s financial performance, as measured by its return on equity (ROE). Depending on the version used, the DuPont equation will deconstruct the firm’s ROE, its best measure of financial performance, into two or three important factors, or drivers. DuPont analysis can be conducted using either the traditional DuPont equation or the extended DuPont equation. The...
Compute and Analyze Measures for DuPont Disaggregation Analysis Balance sheets and income statements for Costco Wholesale...
Compute and Analyze Measures for DuPont Disaggregation Analysis Balance sheets and income statements for Costco Wholesale Corporation follow. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) September 1, 2013 September 2, 2012 August 28, 2011 Revenue Net Sales $102,870 $97,062 $87,048 Membership fees 2,286 2,075 1,867 Total revenue 105,156 99,137 88,915 Operating expenses Merchandise costs 91,948 86,823 77,739 Selling, general and administrative 10,104 9,518 8,691 Preopening expenses 51 37 46 Operating Income 3,053 2,759 2,439 Other income (expense)...
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow....
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2007 2006 2005 Sales $ 57,878 $ 51,271 $ 45,682 Credit card revenues 1,612 1,349 1,157 Total revenues 59,490 52,620 46,839 Cost of sales 39,399 34,927 31,445 Selling, general and administrative expenses 12,819 11,185 9,797 Credit card expenses 707 776 737 Depreciation and amortization 1,496 1,409 1,259 Earnings before interest and income taxes 5,069 4,323 3,601...