Whirlpool Europe
Whirlpool Europe Analysis
The Whirlpool Europe case provides an opportunity to look at different ways to evaluate a major IT investment the company is considering. To undertake this analysis we have to make a few assumptions because the case does not have all the details needed to estimate benefits and investment cost. However, if you were in a company faced with this situation, these numbers would be available.
The spreadsheet for Whirlpool contains two worksheets. Worksheet 1 is a net present value analysis, and worksheet 2 applies an options pricing model to the decision.
Be sure to save a copy of the spreadsheet when you download it because most of the questions refer back to the original spreadsheet, which you will often change in a preceding question.
NPV Analysis (Worksheet 1)
The NPV analysis follows the scenario in the case: the company invests for a series of years, and implements in the West, South Central and North regions in that order. The spreadsheet has been designed with the first analysis showing the summary of investment costs and anticipated benefits for the six year time horizon in the case. The spreadsheet calculates the net present value of each year’s benefits and costs, and subtracts the NPV of costs from benefits. The table just below this analysis contains variables that you can change to test the sensitivity of the analysis. The rest of the spreadsheet presents the details of the assumptions and calculations to arrive at the yearly costs and benefits.
Please answer the following question about the NPV analysis:
1. What are the key assumptions of this analysis?
________________________________________________________________________
________________________________________________________________________
2. The current NPV is negative. One way to save money would be to reduce consulting costs. Please set the average consulting cost per month in cell b33 to $5000. At what discount rate is the NPV
The Whirlpool Europe case provides an opportunity to look at different ways to evaluate a major IT investment the company is considering. To undertake this analysis we have to make a few assumptions because the case does not have all the details needed to estimate benefits and investment cost. However, if you were in a company faced with this situation, these numbers would be available.
The spreadsheet for Whirlpool contains two worksheets. Worksheet 1 is a net present value analysis, and worksheet 2 applies an options pricing model to the decision.
Be sure to save a copy of the spreadsheet when you download it because most of the questions refer back to the original spreadsheet, which you will often change in a preceding question.
NPV Analysis (Worksheet 1)
The NPV analysis follows the scenario in the case: the company invests for a series of years, and implements in the West, South Central and North regions in that order. The spreadsheet has been designed with the first analysis showing the summary of investment costs and anticipated benefits for the six year time horizon in the case. The spreadsheet calculates the net present value of each year’s benefits and costs, and subtracts the NPV of costs from benefits. The table just below this analysis contains variables that you can change to test the sensitivity of the analysis. The rest of the spreadsheet presents the details of the assumptions and calculations to arrive at the yearly costs and benefits.
Please answer the following question about the NPV analysis:
1. What are the key assumptions of this analysis?
________________________________________________________________________
________________________________________________________________________
2. The current NPV is negative. One way to save money would be to reduce consulting costs. Please set the average consulting cost per month in cell b33 to $5000. At what discount rate is the NPV