The given period is specified as a zero-based number instead of a 1-based number.
For a loan where the payment is a fixed amount, see theIPMT function.
Notes
Be consistent with the units.
Enternperas 3*12.
ISPMT uses a zero-based index for period (per).
Use 0 for period 1, 1 for period 2, etc.
The PPMT function is for loans with even principal payments.
For a loan with even periodic payments, use the IPMT function.
For example, you might use IPMT to get the interest amount of a loan payment for the…
