Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

The present value equals the dividend divided by the discount factor, which in the first row will simply equal the current dividend.

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.