Question
Please help me solve the following questions, a detailed presentation of steps would be greatly appreciated, thank you!
Consider the following two companies and the operating decisions they have made over a five - year period COMPANY B In Thousand Dollars Net Income Sales Total Assets 2001 2002 2003 2004 2005 119.3 120 123 125 941.511221360 1620 1890 1001.61001.6 1001.6 1001.6 1001.6 656 23 122 656 656 656 656 Book Value of Equity Family living withdrawals 23 23 23 23 COMPANY In Thousand Dollars 2001 2002 2003 2004 2005 189 941.51000 1080 1240 1340 1001.6 1080 1180 1355 1475 656 40 119.3 126 150 173 Net Income Sales Total Assets 656 656 656 656 Book Value of Equity Family living withdrawals ratio 23 25 30 35 1.Perform a DuPont analysis and compare the results. How do these companies operating and financial decisions differ from each other? 2.Calculate the companies sustainable growth rates and the corresponding sustainable growth challenge for each year. What operating and financial strategies can you recommend to attain balanced growth, whenever such goal is not attained?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Dupont Analysis = Net profit Margin × Asset Turnover × Financial Leverage

Dupont Analysis = Net Income/ Sales × Sales/ Total Assets × Total Assets/ Total Equity

I have attached a pic to explain the first question.

2) Growth Rate Calculation = (sales in 2002 - Sales in 2001)/Sales in 2001

This is the basic formulae for the growth rate.

Sales Growth Rate for Company B and C attached in Pic.

Company B is only investing in it's Sales Force and Marketing and not focussing on the Fixed Capital Formation, thereby not generating higher Operational efficiency to match the income with it's higher sales.

Company C should also invest in it's sales Force and Marketing, to match the Sales with higher Operational Efficiency.2001 119.3 941.5 2002 120 1122 Company B Net Income Sales Total Assets Book Value of Equity65665666 Withdrawls Dupont Analysis 2005 125 1890 001.6 1001.6 1001.6 1001.6 1001.6 656656 232323 23 23 2003 122 1360 2004 123 1620 Net Profit Margin | 12.67%| 0.94 1.53 18.19%) 10.70%| 8.97% Asset Turnover Leverage Return On Equity 7.59%) 1.62 1.53 18.75%) 6.61% 1.89 1.53 19.05% 1.53 18.60%) 18.29%) Company C Net Income Sales Total Assets Book Value of Equity Withdrawls Dupont Analysis Net Profit Margin Asset Turnover Leverage Return On Equity 2001 119.3 941.5 1001.6 656 2002 126 1000 1080 2003 1080 118이 656 2930 2004 173 1240 1355 656 2005 189 1340 1475 656 40 12.67%) 0.94 1.53 18.19%) 12.60%| 0.93 1.65 19.21%) 13.89%| 0.92 1.80 22.87%| 13.95%| 0.92 2.07 26.37%| 14.10% 0.91 28.81% ) The C has cona kettin tharm Asts in inuesting in Abu ezpamatei plan h The compowy C hao ben erc Gumsth Rade2001 2002 2003 2004 2005 2 41 8 S 87

Add a comment
Know the answer?
Add Answer to:
Please help me solve the following questions, a detailed presentation of steps would be greatly appreciated,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following two companies and the operating decisions they have made over a five –year...

    Consider the following two companies and the operating decisions they have made over a five –year period: 1.Perform a DuPont analysis and compare the results. How do these companies operating and financial decisions differ from each other? 2.Calculate the companies’ sustainable growth rates and the corresponding sustainable growth challenge for each year. What operating and financial strategies can you recommend to attain balanced growth, whenever such goal is not attained? COMPANY B 2002 2003 2004 2005 2001 119.3 In Thousand...

  • Please use excel to solve. Any help would be greatly appreciated. A B E F G...

    Please use excel to solve. Any help would be greatly appreciated. A B E F G 1 C D Changes in Consumer Price Index, 1960-2006 (Percent) 2 Year-Year Percent Change in Commodities CPI Year-Year Percent Change in Services CPI 3 4 5 6 7 8 Commodities% 0.9 Services% 3.4 0.6 1.7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37...

  • Please read case article, "Attention Kmart Shoppers? Into and out of Bankruptcy" and help me come...

    Please read case article, "Attention Kmart Shoppers? Into and out of Bankruptcy" and help me come up with a solution for the case as well as action steps to implement the solution! Thank you!! ATTENTION KMART SHOPPERS? Former Kmart CEO, Charles C. Conaway, failed in his 19-month effort to revive the iconic firm, resulting in the largest retailing bankruptcy filing in history on January 22, 2002 (Davies, et al., 2002). On March 11, 2002, bankrupt Kmart named James B. Adamson...

  • Please read the facts of the case and prepare answers for the following questions : 1...

    Please read the facts of the case and prepare answers for the following questions : 1 – What is the relevance of the $2,000 monthly payment to Dave Verden on the analysis of Jones’ financing needs? 2 – What metrics could you use to compare the historical financial results for Jones with the projected financial results under the four defined scenarios? 3 – Other than financing needs, what other issues should Jones address as he considers the different growth scenarios?...

  • CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a...

    CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a gleaming office tower in Houston, Texas. In front of that gleaming tower was a giant "E" slowly revolving, flashing in the hot Texas sun. But in 2001, the Enron Corporation, which once ranked among the top Fortune 500 companies, would collapse under a mountain of debt that had been concealed through a complex scheme of off-balance-sheet partnerships. Forced to declare bankruptcy, the energy firm...

  • Case: Enron: Questionable Accounting Leads to CollapseIntroductionOnce upon a time, there was a gleaming...

    Case: Enron: Questionable Accounting Leads to CollapseIntroductionOnce upon a time, there was a gleaming office tower in Houston, Texas. In front of that gleaming tower was a giant “E,” slowly revolving, flashing in the hot Texas sun. But in 2001, the Enron Corporation, which once ranked among the top Fortune 500 companies, would collapse under a mountain of debt that had been concealed through a complex scheme of off-balance-sheet partnerships. Forced to declare bankruptcy, the energy firm laid off 4,000...

  • Given the value line: a.) what is the top line growth for 2015? b.)Bottom-Line? c.) Annual...

    Given the value line: a.) what is the top line growth for 2015? b.)Bottom-Line? c.) Annual dividen per share? d.) Current ratio in 2014? e.) % bonds of Captial structure f.) p/e ratio g.) beta h.) EBITDA % I.) Long-Debt % change 2015 We were unable to transcribe this image41.65 TO 20.1 (Media 92) ATM 1.12 ** 3.4% YAKE 1965 07 2:22. 87 3. 35.8 COCA-COLA NYSE:KO TIMELINESS 4 Lowered 70115 h: 289 29 SAFETY . 1 New 727190 LEGENDS...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT