Calculation method and assumptions
The monthly rate is the nominal annual rate divided by twelve. For principal P, monthly rate r and n payments, the payment is P × r / (1 − (1 + r)^−n); at zero interest it is P / n. Payments are due at month-end. [1]
Fees paid upfront are added to cash paid. Financed fees increase the starting balance and also accrue interest. Extra monthly payments reduce principal after interest; the last payment is limited to the amount owed. [1]
Interest and payments are rounded to cents each month, with an adjusted final payment. The schedule assumes a fixed rate, no missed payments and no early-payment penalty. Daily interest, variable rates, tax and statutory APR calculations are outside this model. [1]
Worked example
Borrowing 1,200 over twelve months at zero interest, with no fees or extra payments, gives twelve payments of 100.
Sources and references
- PMT function — Constant-rate payment calculation, consistent monthly units and end-of-period payments.
Sources reviewed: 18 November 2026