PVpayment - payment amount to be made per period. Type a negative number for money you pay and a positive number for money you receive.interestRate - interest rate per period.periods - number of periods (intervals between payments).PV(500;.05;5) returns 2164.73833531....If you want the return value to return two decimal places, enclose the formula with the correct Round function: Round(Current Formula;2).

Was this topic helpful? Send feedback.