Equal Principal & Interest Payment Calculator
Equal Principal & Interest Payment is is a repayment method that pays a fixed amount including principal and interest over a fixed period. Interest is heavier early in the loan, and the principal portion increases over time.
During the repayment period you pay a fixed amount each month — the sum of principal and interest. Part of each payment goes toward the principal and the rest toward interest on the outstanding balance. As the balance decreases, the interest burden falls and the principal portion rises.
This method makes it easy to plan because the monthly payment is predictable, but the interest burden is heavy early on. It suits borrowers who want a constant payment, and banks also favor it because the total interest earned is higher.

Equal Principal & Interest Payment Calculation Method
With the PMT function you can build a schedule by first finding ① the principal-and-interest payment per period, then ② the interest per period, and finally ③ the principal portion. Each period's interest is found by multiplying the outstanding principal by the monthly rate.
How to calculate using the PMT function
The PMT function is mainly used in financial calculations, especially to compute total interest when a fixed amount is paid or received each month for a loan or investment. PMT stands for "Payment" and calculates the payment amount occurring at regular intervals over a fixed period. It is often used to compute monthly loan repayments or rent.
- rate: the interest rate — the annual rate divided by months, or the rate adjusted to the payment period.
- nper: the total number of payment periods (e.g. months).
- pv: the present value, i.e. the current value of the loan or investment. Usually entered as a negative number.
- fv (optional): the future value, i.e. the amount remaining after the loan or investment ends. Usually omitted.
- type (optional): indicates when payments are made — 0 if payments occur at the end of each period (e.g. monthly), 1 if at the beginning. Usually omitted.