We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Forecast Assumptions

The whole doc is available only for registered users

A limited time offer! Get a custom sample essay written according to your requirements urgent 3h delivery guaranteed

Order Now

How sensitive is return on capital to the forecast assumptions in case Exhibit 8? An increase in cash operating expenses decrease NOPAT, which in turn makes ROC extremely sensitive when this ratio goes up; in general when total operating expenses go up NOPAT goes down, thus ROC goes down. In addition if the COGS increase this drastically drops ROC. The total assets has a big impact on ROC an increase of 1000m increased ROC by a full 1.5 percent. The ROC is also very sensitive to the Price to Earnings ratio turnover; yet the receivable-turnover figure has little impact.

Inventory turnover is also a factor that affects ROC drastically, a small decrease in inventory turnover drops the ROC drastically as shown below. But most interesting was that sales growth did not have any effect on ROC. What independent changes in Carrie Galeotafiore’s estimates are required to drive the 2002 return-on-capital estimate below Home Depot’s cost-of-capital estimate of 12.3%? The ROC can be reduced through a decrease in EBIT of 1,133M, by a decrease in NOPAT of 707M, or an increase in capital of 5,746M. By using the excel goal seek function on exhibit 8 and changing the ROC to 12.3% instead of 15.1% in year 2002E, I found the following results:

ROC = 15.1%
ROC = 12.3%
Gross margin=gross profit/sales
Receivable turnover
Inventory turnover
P&E turnover
Cash operating exp./sales
Income tax rate

Look specifically at gross margin, cash operating expenses, receivable turnover, inventory turnover, and P&E turnover. What effect does sales growth have on return on capital? Explain your findings. An increase in sales growth did not have any effect on receivable turnover, inventory turnover, P&E turnover, gross margin, and cash operating expenses. It was also observed that the total sales-growth figure has no impact on ROC. That is because the financial model in exhibit 8 is almost completely based as a percentage of sales ratios. This was confirmed by the effects exhibit 8 took when the sales account ware increased in exhibit 4. In effect, all of the accounts differed consistently with sales.

Related Topics

We can write a custom essay

According to Your Specific Requirements

Order an essay
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access

Your Answer Is Very Helpful For Us
Thank You A Lot!


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59