PPMT

Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

Parameter List

Syntax
PPMT(rateperiodnumber_of_periodspresent_value
[future_value]
[end_or_beginning]
)
rate

The interest rate. For example: 2%.

period

The amortization period, in terms of number of periods.

number_of_periods

The number of payments to be made. For example: 12.

present_value

The current value of the annuity. For example: 400.

[optional] future_value

The future value remaining after the final payment has been made. For example: 0. The default value is 0.

[optional] end_or_beginning

Whether the payments are due at the end (0) or beginning (1) of each period. For example: 0 or 1. The default type is 0.

Examples

PPMT(12%, 12, -1000, 12, 1) returns $923.08