Skip to main content

Amortization Schedule Calculator

Quickly compute amortization schedule with accurate formulas. See amortization schedules, growth projections, and side-by-side comparisons.

Reviewed by Sahil, Senior Finance & Tax Editor

Reviewed by Sahil, Senior Finance & Tax Editor

Formula

M = P ร— [r(1+r)^n] / [(1+r)^n - 1]

Where M = Monthly payment, P = Principal (loan amount), r = Monthly interest rate (annual rate / 12), n = Total number of payments (years ร— 12). Each monthly payment consists of an interest portion (remaining balance ร— monthly rate) and a principal portion (payment minus interest). As the balance decreases, the interest portion shrinks and the principal portion grows.

Worked Examples

Example 1: Standard 30-Year Mortgage

Problem:You take out a $250,000 mortgage at 6.5% interest for 30 years. What are the monthly payments and total interest?

Solution:Monthly rate: 6.5% / 12 = 0.5417%\nTotal payments: 30 x 12 = 360\nMonthly payment: $250,000 x [0.005417 x (1.005417)^360] / [(1.005417)^360 - 1] = $1,580.17\nTotal paid: $1,580.17 x 360 = $568,861\nTotal interest: $568,861 - $250,000 = $318,861\nFirst payment: $1,354 interest + $226 principal\nLast payment: $9 interest + $1,572 principal

Result:Monthly: $1,580.17 | Total Interest: $318,861 | Total Paid: $568,861

Example 2: 15-Year Mortgage Comparison

Problem:Same $250,000 loan but at 5.75% for 15 years. Compare with the 30-year option.

Solution:Monthly rate: 5.75% / 12 = 0.4792%\nTotal payments: 15 x 12 = 180\nMonthly payment: $250,000 x [0.004792 x (1.004792)^180] / [(1.004792)^180 - 1] = $2,072.78\nTotal paid: $2,072.78 x 180 = $373,100\nTotal interest: $373,100 - $250,000 = $123,100\nSavings vs 30-year: $318,861 - $123,100 = $195,761 in interest saved

Result:Monthly: $2,072.78 | Total Interest: $123,100 | Saves $195,761 vs 30-year

Frequently Asked Questions

How do extra payments affect my amortization schedule?

Making extra payments toward your mortgage principal can dramatically reduce both the total interest paid and the loan term. Extra payments reduce the outstanding principal faster, which means less interest accrues in subsequent months, creating a compounding savings effect. For example, on a $250,000 30-year mortgage at 6.5%, adding just $200 per month to your payment reduces the loan term by about 8 years and saves approximately $94,000 in interest. Even one extra payment per year (making 13 payments instead of 12) can shave 4-5 years off a 30-year mortgage. The most cost-effective time to make extra payments is early in the loan when interest costs are highest. Always confirm with your lender that extra payments are applied to principal and that there are no prepayment penalties.

References

Reviewed by Sahil, Senior Finance & Tax Editor ยท Editorial policy