Table of Contents### Calculating the Principal and Interest

Entire Site

Any loan payment has two components: principal repayment and interest charged. Interest charges are almost always front-loaded, which means that the interest component is highest at the beginning of the loan and gradually decreases with each payment. This means, conversely, that the principal component increases gradually with each payment.

To calculate the principal and interest components of a loan payment, use the `PPMT()` and `IPMT()` functions, respectively: