FINANCE.PMT
FINANCE.PMT(rate, periods, value, future_value = 0, end_or_start = 0)
Calculates the period payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
- rate: Interest rate.
- periods: Number of payments to be made.
- value: Present value of the annuity.
- 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.