Question

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 Revenue/Sales 7983 5363
Cost of Goods Sold (COGS) 5817 4128
Gross Profit 2166 1235
Sales, General & Admin. (SG&A) 1256 1138
Research & Development (R&D)
EBIT 530 -333
Net Income 786 -25
Cash Flow (from operations) 868 185
Cash and Equivalents 4027 4336
Short- & Long-term Investments
Accounts Receivable (AR) 953 466
Inventory 33 11
Total Assets 6803 6021
Accounts Payable (AP) 1157 801
Long-term Debt 300 317
Total Shareholder's Equity 4107 3920

Need to know how to perform dupont analysis of ROE

Thanks!

Homework Answers

Answer #2

answered by: anonymous
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
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...
2) Compute the EBIT margin and its components – the gross profit margin and selling, general,...
2) Compute the EBIT margin and its components – the gross profit margin and selling, general, and administrative expenses to revenue in 2018 and 2019. What caused the change in EBIT margin? [You do not have to use the average method – i.e. you can use year-end numbers in computing the ratios.] ATC Company Balance Sheet on December31 ($ millions) 2018 2019 Inventory 20 28 Accounts Receivable 36 26 Other 29 36 Cash 410 473 Total Current Assets 495 562...
what is the wacc for amerisourcebergen? Income Statement 9/30/17 Sales $153,144.00 Cost Of Goods $148,598.00 Gross...
what is the wacc for amerisourcebergen? Income Statement 9/30/17 Sales $153,144.00 Cost Of Goods $148,598.00 Gross Profit $4,546.00 Selling & Adminstrative & Depr. & Amort Expenses $3,486.00 Income After Depreciation & Amortization $1,060.00 Non-Operating Income $3.00 Interest Expense $145.00 Pretax Income $918.00 Income Taxes $553.00 Minority Interest $0.00 Investment Gains/Losses $0.00 Other Income/Charges $0.00 Income From Cont. Operations $364.00 Extras & Discontinued Operations $0.00 Net Income $364.00 Depreciation Footnote 9/30/17 Income Before Depreciation & Amortization $1,493.00 Depreciation & Amortization (Cash...
A) The firm has a gross profit of $100, operating income (EBIT) of $70, taxable income...
A) The firm has a gross profit of $100, operating income (EBIT) of $70, taxable income (EBT) of $65, net income of $45, total assets of $4,000, total equity of $1,200, and total sales of $200. What is net profit margin? B)The company has net income of $30,000 for the year and paid dividends of $40,000.  At the beginning of the year, the company had common stock of $50,000, paid-in surplus of $60,000, and retained earnings of $70,000. At the end...
Please calculate the following based on the facts provided:   a. Gross Margin Ratio: Net sales =...
Please calculate the following based on the facts provided:   a. Gross Margin Ratio: Net sales = $1,000,000.00 & Cost of Goods Sold = $200,000.     b. Return on assets ratio (ROA): Net Income = $350,000 & Average Total Assets = $2,500,000   c. Return on Equity (ROE): Net Income = $350,000 & Shareholder's Equity = $5,000,000.   d. Customer Acquisition Cost (CAC): Sales/Marketing Costs = $450,000 & number of new customers 1,000.    e. Current Liquidity Ratio: Current Assets = $1,200,000 & Current Liabilities=...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
INCOME STATEMENT: 2016 2017 Sales $100,000.00 $120,300.00 Cost of Goods Sold $60,000.00 $72,180.00 Gross Margin $40,000.00...
INCOME STATEMENT: 2016 2017 Sales $100,000.00 $120,300.00 Cost of Goods Sold $60,000.00 $72,180.00 Gross Margin $40,000.00 $48,120.00 Depreciation $16,000.00 $19,200.00 Administrative Costs $9,000.00 $10,800.00 EBIT $15,000.00 $18,120.00 Interest $4,000.00 $4,000.00 Pre-tax income $11,000.00 $14,120.00 Taxes $4,400.00 $5,648.00 Net Income $6,600.00 $8,472.00 Dividends $0.00 $5,083.20 Addition to Retained Earnings $6,600.00 $3,388.80 BALANCE SHEET AS OF 12/31/2017: ASSETS 2016 2017 Cash $5,000.00 $6,000.00 Inventory $15,000.00 $18,000.00 Accounts Receivable $15,000.00 $18,045.00 Current Assets $35,000.00 $42,045.00 Net PPE $80,000.00 $92,000.00 Total Assets (TA) $115,000.00...
Calculate Return on equity (ROE), Return on assets (ROA), Net Profit Margin (NPM), Debt ratio, and...
Calculate Return on equity (ROE), Return on assets (ROA), Net Profit Margin (NPM), Debt ratio, and Total assets turnover for 2018 and 2019. Explain why ROE is lower in 2019 than in 2018 (explain in terms of each ratio in DuPont equation for ROE). Income Statements ($ in millions) Balance Sheets ($ in millions) 2018 2019 Assets 2018 2019 Sales Revenue $2,580 $2,865 Cash $70 $50 Less: Cost of goods sold $1,060 $1,500 Short-Term investments $35 $9 Less: Operating Expenses...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Income Statement All numbers in thousands Revenue 1/29/17 1/31/16 Total Revenue 94,595,000 88,519,000 Cost of Revenue 62,282,000 58,254,000 Gross Profit 32,313,000 30,265,000 Operating Expenses Research Development - - Selling General and Administrative 17,132,000 16,801,000 Non Recurring - - Others 1,754,000 1,690,000 Total Operating Expenses - - Operating Income or Loss 13,427,000 11,774,000 Income from Continuing Operations Total Other Income/Expenses...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT