Parameter List
Syntax
IPMT(rate, period, number_of_periods, present_value,
[future_value]
, [end_or_beginning]
)rate
The interest rate. For example: 2%.
period
The amortization period, in terms of number of periods. The period value must be equal or lower than the number of periods. For example: 1.
number_of_periods
The number of payments to be made. For example: 360.
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.
[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.