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.

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

The future value function capability in Microsoft Excel helps business owners easily assemble data for projects such as budgeting and company or asset valuation exercises. The Excel formula is ...

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

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