PV Function

Syntax

Present_Value as N = PV(N periodic_investment,N periodic_interest_rate,N time_periods)

Arguments

periodic_investment: The amount of each equal investment, which may be either positive or negative. Numeric
periodic_interest_rate: Interest rate per time period. Interest rate must be a positive number. Numeric
time_periods: Number of time periods (and investments), which must be a positive number. Numeric

Description

Returns the present value of a stream of periodic investments over a specified integer term.

Discussion

PV() returns the present value of a stream of Investment s, invested at a fixed Interest_Rate for a certain Number_Of_Time_Periods. The PV() function is used to find the amount that must be invested now to produce a given future amount.

Example

Assume a 12% per annum interest rate. An annuity pays $100 per annum for the next 30 years. To compute the present value of this payment stream, use the following expression:

PV(100,.12,30) ->  805.52