Fay Bannah -
Does anyone know if it is possible to chart the NPV Profile on Excel 2000?
And how to go about doing it? <
If "NPV Profile" means a plot of NPV versus discount rate, start with the
sequence of cash flows in worksheet cells, enter a list of discount rates in
a column on the left (for X values of the chart), enter the NPV function in
a column on the right (for the chart's Y values) with a relative reference
to the cell with the discount rate (and absolute reference to the cells
containing the cash flows), copy the NPV function so you have an NPV value
for each rate, select both sets of data, and create an XY (Scatter) chart.
- Mike Middleton,
www.usfca.edu/~middleton
