Description
Calculates the amount of a payment of an annuity going towards interest.
Formula for IPMT is:
IPMT(PER) = PMT - PRINCIPAL(PER-1) * INTEREST_RATE
where:
PMT = Payment received on annuity
PRINCIPA(per-1) = amount of the remaining principal from last period