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. For the second row, calculate the year by adding 1 to the ...

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

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.