Amortization Schedule Calculator

What is an amortization schedule?

A mortgage amortization schedule is a table that lists each regular payment on a mortgage over time. A portion of each payment is applied toward the principal balance and interest, and the mortgage loan amortization schedule details how much will go toward each component of your mortgage payment.

Initially, most of your payment goes toward the interest rather than the principal. The loan amortization schedule will show as the term of your loan progresses, a larger share of your payment goes toward paying down the principal until the loan is paid in full at the end of your term.

How do you calculate amortization?

An amortization schedule calculator shows:

1. How much principal and interest are paid in any particular payment.
2. How much total principal and interest have been paid at a specified date.
3. How much principal you owe on the mortgage at a specified date.
4. How much time you will chop off the end of the mortgage by making one or more extra payments.

This means you can use the mortgage amortization calculator to:

1. Determine how much principal you owe now, or will owe at a future date.
2. Determine how much extra you would need to pay every month to repay the mortgage in, say, 22 years instead of 30 years.
3. See how much interest you have paid over the life of the mortgage, or during a particular year, though this may vary based on when the lender receives your payments.
4. Figure out how much equity you have.

How do I calculate monthly mortgage payments?

Here’s a formula to calculate your monthly payments manually: M= P[r(1+r)^n/((1+r)^n)-1)]

• M = the total monthly mortgage payment.
• P = the principal loan amount.
• r = your monthly interest rate. Lenders provide you an annual rate so you’ll need to divide that figure by 12 (the number of months in a year) to get the monthly rate. If your interest rate is 5 percent, your monthly rate would be 0.004167 (0.05/12=0.004167).
• n = number of payments over the loan’s lifetime. Multiply the number of years in your loan term by 12 (the number of months in a year) to get the number of payments for your loan. For example, a 30-year fixed mortgage would have 360 payments (30x12=360).