Calculating Monthly Payments and Amortization
Key Takeaways
For a standard monthly fixed-rate calculation, convert the annual note rate to a decimal monthly rate and use months for the remaining term.
Calculate a period's interest from its starting balance, then subtract that interest from the principal-and-interest payment to find principal reduction.
Report principal and interest separately from escrow, mortgage insurance and other amounts in the borrower's total payment.
Price the monthly payment from the note
A standard fixed-rate home loan can spread the same principal-and-interest (P&I) payment over the number of months in its term. Early in the loan, interest is calculated on a larger balance. As that balance falls, a greater part of the same scheduled payment goes to principal. The interest rate and the combined P&I stay fixed in this example even though the allocation moves. A loan with an interest-only phase, irregular periods or a balloon needs its own terms before you can use this model.
For a level fully amortizing payment with equal monthly periods, use the balance P, the annual note rate as a decimal divided by 12 to get the monthly rate i, and the number of remaining monthly payments n. The payment is P × i ÷ [1 − (1 + i) raised to the power −n]. This is the amount that makes the present value of all remaining regular payments equal to the balance. Each payment is discounted one monthly period farther than the preceding one. For a zero-interest exercise, divide the principal equally among the remaining months. Do not apply the positive-rate formula with a zero denominator.
Construct the first two schedule rows
Take a $240,000 fixed-rate loan at a 6% note rate, paid in 360 equal monthly periods. Use the starting amount of $240,000, a monthly rate of 0.06 ÷ 12 = 0.005, and n = 360. The monthly P&I is $1,438.92 rounded to cents. First-month interest is $240,000 × 0.005 = $1,200, so principal reduction is $238.92. The next period's interest starts from $239,761.08, giving $1,198.81 before finding principal by subtraction.
| Month | Starting balance | Interest | Principal | Ending balance |
|---|---|---|---|---|
| 1 | $240,000.00 | $1,200.00 | $238.92 | $239,761.08 |
| 2 | $239,761.08 | $1,198.81 | $240.11 | $239,520.97 |
The table shows amounts rounded to cents. An actual servicer's rounding convention and final payment may differ slightly from a hand calculation. Notice the order: interest from starting balance, principal as the rest of the payment, balance after that principal. Subtracting the $1,438.92 payment from principal would overstate the amount repaid by $1,200 in the first month. Multiplying the original balance by the monthly rate each month would miss the declining interest share after each principal payment.
Compare term and recurring housing costs
At the same 6% rate with the same initial principal but 180 payments, the formula gives $2,025.26 per month. Because the first month's interest is still $1,200, first-month principal rises to $825.26. A larger scheduled monthly principal contribution pays off this same balance in fewer months and reduces the interest paid over the life of the loan, assuming all scheduled payments are made with no extra fees or irregular timing. A buyer comparing terms needs both the payment and the repayment speed. A percentage point in the note rate and a reduction in years change different inputs.
Suppose estimated monthly taxes and homeowners insurance are escrowed at $400 and there is no mortgage insurance. Initial payment collected on the 30-year option is $1,438.92 + $400 = $1,838.92. That escrow deposit is not a principal payment. If escrow rises by $55 after a tax increase, the total rises to $1,893.92 with the same $1,438.92 P&I. If the borrower pays the tax bill directly instead, the bill is still a housing cost even though it is absent from the lender's periodic collection.
Check what the answer represents
The formula gives a scheduled payment at a specified rate and balance. The note rate governs the interest calculation, while the APR incorporates applicable finance charges and timing. Borrowers can compare the two measures without substituting one for the other. A payoff statement at a later date may include interest accrued to the payoff date and other permitted amounts, so use the current documented payoff for settlement. An additional amount credited to principal can lower the next period's interest at the same rate. It usually leaves the scheduled P&I in place unless the loan is properly recast or modified. For a rounded exercise, keep enough precision through the formula and round the dollar result at the end.
Official Sources
The first scheduled principal-and-interest payment is $1,438.92 on a $240,000 loan with a 6% annual note rate and equal monthly periods. How much principal does that payment repay?
$1,200.00
$238.92
$1,438.92
$2,638.92
What is the level monthly principal-and-interest payment on a $240,000, 15-year loan at a 6% annual note rate?
$1,438.92
$1,200.00
$825.26
$2,025.26
A fixed-rate mortgage has $1,438.92 of scheduled monthly principal and interest plus $400 of escrow, with no mortgage insurance. Escrow later rises by $55. What is the new total periodic payment?
$1,493.92
$1,838.92
$1,893.92
$1,438.92
Sections you finish are checked off in the contents.