Repayments Breakdown

You pay more of the interest at the beginning of the loan than at the end.

How much of my regular payment is principal ?

PPMT - Returns the principal amount paid on a given period on a loan with fixed interest.

How much of my regular payment is interest ?

IPMT - Returns the interest amount paid on a given period on a loan with fixed interest.