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.

Most analysts use Excel to calculate NPV. You can input the present value formula, apply it to each year's cash flows, and then add together each year's discounted cash flows, minus expenditures ...

Therefore, the model has you come up with estimates of those dividend payments and then calculates their present value. In order to use the model, you have to make several assumptions.

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

Minimize costs? Create a conference schedule with fewest early-morning sessions? In this excerpt from the book Data Smart, find out how to use Excel's free Solver add-in to do some data science ...

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.