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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
