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 ...

You have three ways to calculate ... "Price." Click the "Autosum" button and press "Enter" on the keyboard. This will automatically add the cost and markup values using the formula "=SUM(B2:C2 ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

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.

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 ...