Problem
You need to determine the present value of a future dollar amount, considering the time value of money.
Solution
Use the builtin function PV.
Discussion
Consider this example: what is the present value of a $5,000 payment to occur three years from now if the annual interest rate is 7%? You can use the present value, PV, function to find out. The syntax for PV is =PV(rate, nper, pmt, fv, type), where rate is the interest rate per period, nper is the number of payment periods, pmt is the payment per period, fv is the future value, and type is an indicator of the payment type (0 for payments at the end of each pay period or 1 for payments at the beginning of each pay period).

To compute the present value for our example, enter the formula =PV(0.07, 3, 0, 5000) in a cell. The result comes to $4,081.49. Excel generates this as a negative number, implying that this is what you would have to invest now at the given rate to have a future value of $5,000 three years from now. You can get rid of the negative by taking the absolute value, using the ABS function (see Chapter 7).
See Also
Take a look at the other recipes in this chapter to learn about other calculations of the time value of money.
Using Excel
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Charting
Statistical Analysis
Time Series Analysis
Mathematical Functions
Curve Fitting and Regression
Solving Equations
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations
Index