Mortgage Amortization Calculator
| Monthly | Total | |
|---|---|---|
| Mortgage payment | $2,690.29 | $968,502.93 |
| Property tax | $500.00 | $180,000.00 |
| Home insurance | $208.33 | $75,000.00 |
| Other costs | $416.67 | $150,000.00 |
| Total out-of-pocket | $3,815.29 | $1,373,502.93 |
- House price
- $500,000.00
- Loan amount
- $400,000.00
- Down payment
- $100,000.00
- Total of 360 mortgage payments
- $968,502.93
- Total interest
- $568,502.93
- Mortgage payoff date
- Nov. 2056
Annual schedule
| Year | Interest | Principal | Ending balance |
|---|---|---|---|
| 1 | $28,304 | $3,979 | $396,021 |
| 2 | $28,012 | $4,272 | $391,749 |
| 3 | $27,698 | $4,585 | $387,164 |
| 4 | $27,361 | $4,922 | $382,241 |
| 5 | $27,000 | $5,284 | $376,958 |
| 6 | $26,612 | $5,672 | $371,286 |
| 7 | $26,195 | $6,088 | $365,198 |
| 8 | $25,748 | $6,535 | $358,662 |
| 9 | $25,268 | $7,015 | $351,647 |
| 10 | $24,753 | $7,531 | $344,117 |
| 11 | $24,200 | $8,084 | $336,033 |
| 12 | $23,606 | $8,677 | $327,356 |
| 13 | $22,969 | $9,315 | $318,041 |
| 14 | $22,285 | $9,999 | $308,043 |
| 15 | $21,550 | $10,733 | $297,310 |
| 16 | $20,762 | $11,521 | $285,788 |
| 17 | $19,916 | $12,367 | $273,421 |
| 18 | $19,008 | $13,276 | $260,145 |
| 19 | $18,033 | $14,251 | $245,895 |
| 20 | $16,986 | $15,297 | $230,598 |
| 21 | $15,863 | $16,421 | $214,177 |
| 22 | $14,657 | $17,627 | $196,550 |
| 23 | $13,362 | $18,921 | $177,629 |
| 24 | $11,973 | $20,311 | $157,318 |
| 25 | $10,481 | $21,802 | $135,516 |
| 26 | $8,880 | $23,404 | $112,112 |
| 27 | $7,161 | $25,122 | $86,990 |
| 28 | $5,316 | $26,968 | $60,022 |
| 29 | $3,335 | $28,948 | $31,074 |
| 30 | $1,209 | $31,074 | $0 |
Monthly schedule
This mortgage amortization calculator builds a full payment-by-payment schedule for a fixed-rate home loan, showing how much of each payment goes to interest and principal, the remaining balance and your total housing costs.
The schedule above lists every payment over the life of the loan. Change the start date to line the dates up with your first payment, and switch off taxes and costs to focus on the loan itself. The yearly view is handy for tax planning, since it shows the mortgage interest paid in each calendar span, while the monthly view shows the exact balance after any given payment.
What Is Amortization?
Amortization means paying off a debt through a series of regular payments that each cover the interest due and part of the principal, so the balance reaches exactly zero at the end of the term. Most mortgages, car loans and personal loans are amortizing loans. The word is also used in accounting for spreading the cost of an intangible asset, such as a patent, over its useful life, but for borrowers it describes how the loan is repaid.
Every payment on an amortizing loan is the same size, but its makeup changes. Interest is calculated on the balance still owed, so early on, when the balance is highest, interest takes the largest share. On the default $400,000 loan at 7.108%, the first payment of $2,690.29 includes about $2,369 of interest and only $321 of principal. By the final years the proportions have reversed, and the last payment is almost entirely principal.
The table below shows the same process on a smaller scale: a $15,000 loan at 6% for three years, with a payment of $456.33 a month. Total interest over the 36 payments comes to $1,427.85.
Comparing the first and last rows shows the pattern in miniature: interest falls from $75.00 to $2.27 while the principal portion grows from $381.33 to $454.06, even though the payment never changes.
| Month | Beginning balance | Payment | Interest | Principal | Ending balance |
|---|---|---|---|---|---|
| 1 | $15,000.00 | $456.33 | $75.00 | $381.33 | $14,618.67 |
| 2 | $14,618.67 | $456.33 | $73.09 | $383.24 | $14,235.44 |
| 3 | $14,235.44 | $456.33 | $71.18 | $385.15 | $13,850.28 |
| 4 | $13,850.28 | $456.33 | $69.25 | $387.08 | $13,463.21 |
| 5 | $13,463.21 | $456.33 | $67.32 | $389.01 | $13,074.19 |
| 6 | $13,074.19 | $456.33 | $65.37 | $390.96 | $12,683.23 |
| … | … | … | … | … | … |
| 35 | $905.86 | $456.33 | $4.53 | $451.80 | $454.06 |
| 36 | $454.06 | $456.33 | $2.27 | $454.06 | $0.00 |
Interestₖ = Bₖ₋₁ × r · Principalₖ = M − Interestₖ · Bₖ = Bₖ₋₁ − Principalₖ
- Bₖ
- loan balance after payment k (B₀ is the amount borrowed)
- r
- monthly interest rate (annual rate ÷ 12)
- M
- fixed monthly payment, P × r(1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]
Repeating these three steps for every month produces the amortization schedule. Because interest is charged on a shrinking balance, each payment sends a little more to principal than the one before.
Amortizing a Mortgage Faster and Saving Money
Because interest is charged only on the outstanding balance, anything that lowers the balance sooner reduces the total interest you pay. There are several ways to do it.
Extra payments. Adding even a modest amount to each monthly payment, marked for principal, shortens the loan and cuts interest substantially, especially in the early years. On the default $400,000 loan, an extra $250 a month pays the mortgage off nearly seven years early and saves more than $150,000 in interest. Annual lump sums from a bonus or tax refund work the same way, and one-time payments are most effective when made early in the term.
Biweekly payments. Paying half the monthly amount every two weeks produces 26 half-payments, or 13 full payments, a year. The extra payment goes entirely to principal and typically shortens a 30-year loan by four to six years. Make sure your servicer applies each half-payment when it arrives rather than holding it until the full amount is received, and avoid third-party programs that charge fees for the service.
Refinancing to a shorter term. A 15-year mortgage usually has a lower rate than a 30-year loan, and with half the number of payments, total interest is often less than half as much. The trade-off is a much higher required payment and closing costs on the new loan. Refinancing to a lower rate at the same term can also lower total interest, if you stay long enough to recover the costs.
Recasting. Some lenders will recalculate, or recast, the payment after a large lump-sum principal payment, keeping the same rate and end date but lowering the monthly payment. It does not shorten the loan, but it reduces interest and frees up cash flow for a small fee, usually a few hundred dollars.
Making a larger down payment. Borrowing less in the first place is the simplest way to reduce interest. A larger down payment can also eliminate private mortgage insurance and earn a better rate.
Before paying ahead, confirm that your loan has no prepayment penalty, keep an emergency fund in place and pay off higher-rate debts first. Check each statement to see that extra money was applied to principal rather than held as an advance on future payments.
Drawbacks of Amortizing a Mortgage Faster
Paying a mortgage down early has costs of its own. Money put into the house is illiquid: getting it back requires selling, refinancing or taking out a home equity loan. The same dollars might earn more in a retirement account, especially one with an employer match, or might be better used to pay off credit cards and other higher-rate debt. If you itemize deductions, a smaller balance also means less deductible mortgage interest. Weigh these trade-offs before committing extra cash to the loan.
Frequently asked questions
What is a mortgage amortization schedule?
A table listing every payment over the loan's life, showing how much goes to interest, how much to principal and the balance remaining afterward.
Why does so much of my early payment go to interest?
Interest is charged on the outstanding balance, which is largest at the start. On a $400,000 loan at 7.108%, about $2,369 of the first $2,690.29 payment is interest.
How do I pay off my mortgage faster?
Make extra principal payments, switch to biweekly payments, refinance to a shorter term or make a larger down payment. Each reduces the balance sooner, which cuts interest.
What is the payment on a $500,000 home with 20% down?
Borrowing $400,000 at 7.108% for 30 years costs $2,690.29 a month in principal and interest. Adding 1.2% property tax, $2,500 of insurance and $5,000 of other yearly costs brings the total to $3,815.29.
Does the schedule include taxes and insurance?
The schedule tracks only principal and interest, because taxes and insurance do not change the loan balance. The monthly-versus-total table adds them to show your full housing cost.
What is the formula for mortgage amortization?
The monthly payment is M = P × r(1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]. For each payment, interest is the previous balance times r, principal is M minus that interest, and the new balance is the old balance minus the principal. On a $400,000 loan at 7.108% for 30 years, M is $2,690.29 and the first month's interest is $2,369.33, leaving $320.96 for principal.
How do I make a mortgage amortization schedule in Excel?
Put the payment in one cell with =PMT(7.108%/12, 360, -400000), which returns $2,690.29. In each row, interest is the prior balance × 7.108%/12, principal is the payment minus interest, and the new balance is the prior balance minus principal; fill down for 360 rows. Excel's IPMT and PPMT functions return the same interest and principal split for any single payment number.
Results are estimates for educational purposes and are not financial, tax or legal advice. Confirm figures with a qualified professional or your lender.
Updated by Calculator.hair. How we build and check our calculators