=IPMT(4%/12, 12, 60, 100000) Result: ~€285.18 | A | B | C | D | |-----------|------------|--------------------|------------------| | Period | Payment | Interest (IPMT) | Principal (PPMT) | | 1 | =PMT(...) | =IPMT(...) | =PPMT(...) | | 2 | same PMT | =IPMT(...,2,...) | =PPMT(...,2,...) | Variation: Rent on a Perpetual Annuity ( Rente Perpétuelle ) If you have a perpetual annuity (no principal repayment, only interest), the periodic rente is simply:
For :
=IPMT(4%/12, 1, 60, 100000) Result: €333.33 rentes rente excel
This is a French keyword meaning (often referring to calculating the interest portion of a loan or annuity payment in Excel). =IPMT(4%/12, 12, 60, 100000) Result: ~€285
