Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR example. We’ve calculated an NPV of $472,169 with an IRR of 57% using a ...

the discount rate, the series of cash flows and the range of dates when the cash flows are received in time. Using Excel can make calculating NPV quick and (relatively) easy.

It requires the discount rate (again ... isn’t financially feasible and should be avoided. Can I Calculate NPV Using Excel? Yes. You can use an NPV formula in Excel or use the NPV function ...

Use What-If analysis, a built-in calculator in Excel, to solve for the discount rate that equals zero. Take our NPV/IRR example. We’ve calculated an NPV of $472,169 with an IRR of 57% using a ...