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

Calculating the future value of a present single sum with multiple interest rates This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

Net present value (NPV) represents the difference between the present value of cash inflows and outflows over a set time period. Knowing how to calculate net present value can be useful when ...

Calculating the future value of salaries is useful as part of a larger exercise to calculate the future value of many other components of a business.

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

As with the present value of an annuity, you can calculate the future value of an annuity by turning to an online calculator, formula, spreadsheet or annuity table. You’ll need this information: ...

Below, we'll show you how to calculate the present value of a stream of free cash flows expected over several years. Calculating present value example ...

How to calculate CAGR in Excel When calculating the CAGR, you must first add the periods and the values for each period.