npv profile

  • Thread starter Thread starter fay bannah
  • Start date Start date
F

fay bannah

Does anyone know if it is possible to chart the NPV
Profile on Excel 2000? And how to go about doing it?

thanks, Fay
 
Fay Bannah -
Does anyone know if it is possible to chart the NPV Profile on Excel 2000?
Click to expand...
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
 
Back
Top