Returns the present value of an investment based on constant periodic payments and a constant interest rate.
Make sure that the rate corresponds to the number of payment periods. For a monthly payment period remember to divide an annual interest rate by 12 (months) to get a monthly interest rate. Enter cash paid out as negative values, and any cash received as positive values.
Syntax
PV( rate, periods, payment, {fv}, {atEnd} )
Arguments
rate The interest rate for the period of the investment. periods The number of payment periods. payment The amount paid each period. fv The future value of the investment (optional, default is 0). atEnd If TRUE payments take place at end of a payment period. (optional, default is TRUE.) Example
PV(.10/12,5*12,-100,10000) is -$1371.35.
Depositing $100 a month into a 10% savings account requires an initial outlay of $1,371.35. to have $10,000 in the account in 5 years.
PV(.08/12,3*12,-300) is $9,573.54.
A $9,573.54 loan at 8% can be paid off in 3 years with monthly payments of $300.