Amortisation schedule

Copper Contributor

Hi all, I am wondering if there is a formula that will show a loan amortisation schedule where the total monthly payment remains the same with the interest payments gradually reducing and the principle repayments gradually increasing over the period of the loan term?

1 Reply

@Duncan_Dids 

You can use the PPMT and IPMT functions for this purpose.

S0211.png