The PV function returns the present value of a loan or an investment, when using constant and regular periodic payments.
Examples of PV are calculations of for mortgage or other loans, or future values towards investment goals.
PV is part of the set of financial functions that Sigma supports.
PV(rate, nperiods, pmt, [fv], [type])
The PV function syntax has the following arguments:
- The interest rate per period.
- To use 7%, use the value 0.07.
- Number of payment periods
- The payment for each period
- The future value, or a cash balance after the last payment.
- Defaults to 0.
- Due date of the payment.
- End of the period
- Beginning of the period
- Default is 0.
- Be consistent with the units for rate and nperiods arguments. If you make monthly payments on a two-year loan at an annual interest rate of 7%, use the rate calculation of 0.07/12 and nperiods calculation of 2*12. For annual payments on the same loan, use the rate of 0.07 and nperiods of 2.
The annual payment of $12,000 towards an investment, over 5 years, with an annual interest rate of 10% has a present value of - $45,489.44.
The quarterly payment of $3,000 towards an investment, over 5 years, with an annual interest rate of 10% has a present value of - $46,767.49.
The monthly payment of $1,000 towards an investment, over 5 years, with an annual interest rate of 10%, has a present value of -$47,065.37.
- PV function in Microsoft documentation