PV

FINANCE.PV

FINANCE.PV(rate, periods, amount, future_value = 0, end_or_start = 0)

Calculates the present value of an investment, based on constant-amount periodic payments and a constant interest rate.

• rate: Interest rate.
• periods: Number of payments to be made.
• amount: Amount paid per period.
• future_value: Future value remaining after the final payment.
• end_or_beginning: Whether payments are due at the end (0) or the beginning (1) of each period.