Sensitivity Analysis

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Problem. Consider the same project as Project NPV - Working Capital. Assume that the product life-cycle of seven years is viewed as a safe bet, but that the scale of demand for the product is highly uncertain. Analyze the sensitivity of the project NPV to the units sales scale factor and to the cost of capital.

Solution Strategy. Copy the pattern of unit sales in the base case to a new location and multiply this pattern by a scale factor to get the new unit sales scenario. Assume that the real cost of capital is constant. Thus, forecast the future cost of capital by taking the year 1 cost of capital and adding the change in the inflation rate. Create a two-way data table using a range of input values for units sales scale factor and a range of input values for the year 1 cost of capital. Using the data table results, create a 3-D surface chart.

FIGURE 10.6 Spreadsheet for Two-Way Data Table and 3-D Surface Chart.

FIGURE 10.6 Spreadsheet for Two-Way Data Table and 3-D Surface Chart.

Was this article helpful?

0 0

Post a comment