Questions or registration help? (608) 444-6575 support@powerofinterest.com

Loan-payment math

Amortization Formula and Worked Schedule Example

The standard fixed-payment formula calculates the regular principal-and-interest payment. The schedule then applies that payment one row at a time.

The standard amortization payment formula

M = P × [r(1 + r)n] ÷ [(1 + r)n − 1]
M
regular payment
P
principal or original loan balance
r
interest rate per payment period
n
total number of payments

For monthly payments, divide the nominal annual rate by 12 to obtain the monthly periodic rate. Multiply the term in years by 12 to obtain the number of payments.

Example: $200,000 at 6% for 30 years

  • Principal: $200,000
  • Annual rate: 6.00%
  • Monthly rate: 0.06 ÷ 12 = 0.005
  • Number of payments: 30 × 12 = 360
  • Calculated monthly payment: $1,199.10

The payment remains fixed, but the interest and principal portions change as the balance declines.

First three rows of the schedule

PaymentPayment amountInterestPrincipalBalance
1$1,199.10$1,000.00$199.10$199,800.90
2$1,199.10$999.00$200.10$199,600.80
3$1,199.10$998.00$201.10$199,399.70

Each row uses the prior row's ending balance. Interest equals the starting balance multiplied by 0.005. Principal equals the payment minus interest.

Why software and spreadsheets can differ by a few cents

Programs may round interest to cents on every row or retain additional precision until totals are displayed. Exact dates and day-count conventions can also produce a different result than a simple monthly periodic formula.

When comparing a lender statement, use the same dates, compounding assumptions, rounding rules, and payment-posting method.

Continue with more complex schedules

Once the basic formula is understood, review how extra payments, changing rates, and balloon maturities alter later rows.

Build and compare the schedule

Use the free amortization calculator for a standard schedule. Use the registered Windows amortization software when you need to edit individual dates, payments, rates, or notes and save the revised loan.

Why early loan payments are mostly interest

For a standard monthly fully amortizing loan, interest for each period is based on the outstanding balance at that point in the schedule. The scheduled payment is first applied to current-period interest; the remainder reduces principal. Because principal starts highest at the beginning, the interest portion of the early payments is usually larger.

For example, on a $200,000 loan at 6% annual interest using a monthly periodic rate, the first month's interest is $200,000 × 0.06 ÷ 12 = $1,000. A scheduled principal-and-interest payment of approximately $1,199.10 therefore initially reduces principal by about $199.10. The second month's interest is calculated on the lower outstanding balance, not the original $200,000.

What principal means in a loan schedule

Principal is the unpaid loan amount on which interest is calculated under the assumed terms. It is not the monthly payment, total future payments, escrow or unpaid accrued interest. In a standard amortization schedule, each payment splits into interest and reduction of principal. An extra principal payment decreases the amount on which later interest is calculated, while missed payments can change that balance and the timing of interest accrual.

If your loan is paid on irregular dates, the standard monthly formula is only a starting point: use our actual-date reconciliation tool. For a standard payment schedule, see the loan payment calculator or Amortization Pro.

Questions

Frequently asked questions

What is the monthly rate for a 6% annual rate?

For a standard monthly periodic calculation, 6% divided by 12 equals 0.5% per month, or 0.005 as a decimal.

Why does the interest portion decline?

Interest is calculated from the remaining balance. As principal is repaid, the balance and later interest amounts decline.

Why might my lender schedule differ?

Dates, day-count conventions, compounding, payment posting, fees, and row-by-row rounding can cause differences.