Mortgage Amortization Calculator (2024)

home / financial / mortgage amortization calculator

Print

The Mortgage Amortization Calculator provides an annual or monthly amortization schedule of a mortgage loan. It also calculates the monthly payment amount and determines the portion of one's payment going to interest. Having such knowledge gives the borrower a better idea of how each payment affects a loan. It also shows how fast the overall debt falls at a given time.

Mortgage Amortization Calculator (1)

Monthly Pay: $2,535.64

MonthlyTotal
Mortgage Payment$2,535.64$912,831.22
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,660.64$1,317,831.22
House Price$500,000.00
Loan Amount$400,000.00
Down Payment$100,000.00
Total of 360 Mortgage Payments$912,831.22
Total Interest$512,831.22
Mortgage Payoff DateAug. 2054

Amortization schedule

YearDateInterestPrincipalEnding Balance
18/24-7/25$25,981$4,447$395,553
28/25-7/26$25,681$4,746$390,806
38/26-7/27$25,362$5,066$385,741
48/27-7/28$25,021$5,406$380,334
58/28-7/29$24,658$5,770$374,564
68/29-7/30$24,269$6,158$368,406
78/30-7/31$23,855$6,572$361,834
88/31-7/32$23,413$7,015$354,819
98/32-7/33$22,941$7,486$347,332
108/33-7/34$22,438$7,990$339,342
118/34-7/35$21,900$8,528$330,815
128/35-7/36$21,326$9,101$321,714
138/36-7/37$20,714$9,713$312,000
148/37-7/38$20,061$10,367$301,633
158/38-7/39$19,363$11,064$290,569
168/39-7/40$18,619$11,809$278,760
178/40-7/41$17,825$12,603$266,158
188/41-7/42$16,977$13,451$252,707
198/42-7/43$16,072$14,355$238,351
208/43-7/44$15,107$15,321$223,030
218/44-7/45$14,076$16,352$206,678
228/45-7/46$12,976$17,452$189,227
238/46-7/47$11,802$18,626$170,601
248/47-7/48$10,549$19,879$150,722
258/48-7/49$9,212$21,216$129,507
268/49-7/50$7,785$22,643$106,863
278/50-7/51$6,261$24,166$82,697
288/51-7/52$4,636$25,792$56,905
298/52-7/53$2,901$27,527$29,379
308/53-7/54$1,049$29,379$0

What Is Amortization?

In the context of a loan, amortization is a way of spreading the loan into a series of payments over a period of time. Using this technique, the loan balance will fall with each payment, and the borrower will pay off the balance after completing the series of scheduled payments.

Banks amortize many consumer-facing loans such as home mortgage loans, auto loans, and personal loans. Nonetheless, our mortgage amortization calculator is specially designed for home mortgage loans.

In most cases, the amortized payments are fixed monthly payments spread evenly throughout the loan term. Each payment is composed of two parts, interest and principal. Interest is the fee for borrowing the money, usually a percentage of the outstanding loan balance. The principal is the portion of the payment devoted to paying down the loan balance.

Over time, the balance of the loan falls as the principal repayment gradually increases. In other words, the interest portion of each payment will decrease as the loan's remaining principal balance falls. As the borrower approaches the end of the loan term, the bank will apply nearly all of the payment to reducing principal.

The amortization table below illustrates this process, calculating the fixed monthly payback amount and providing an annual or monthly amortization schedule of the loan. For example, a bank would amortize a five-year, $20,000 loan at a 5% interest rate into payments of $377.42 per month for five years.

MonthBeginning BalancePaymentInterestPrincipalEnding Balance
1$20,000.00$377.42$83.33$294.09$19,705.91
2$19,705.91$377.42$82.11$295.31$19,410.59
3$19,410.59$377.42$80.88$296.54$19,114.04
4$19,114.04$377.42$79.64$297.78$18,816.26
..................
58$1,122.90$377.42$4.68$372.74$750.16
59$750.16$377.42$3.13$374.29$375.86
60$375.86$377.42$1.57$375.85$0.00

The calculator can also estimate other costs associated with homeownership, giving the borrower a more accurate financial picture of the costs associated with owning a home.

Amortizing a Mortgage Faster and Saving Money

In many situations, a borrower may want to pay off a mortgage earlier to save on interest, gain freedom from debt, or other reasons.

However, lengthier loans help to boost the profit of the lending banks. The amortization table shows how a loan can concentrate the larger interest payments towards the beginning of the loan, increasing a bank's revenue. Moreover, some loan contracts may not explicitly permit some loan reduction techniques. Thus, a borrower may first need to check with the lending bank to see if utilizing such strategies is allowed.

Nonetheless, assuming a mortgage agreement allows for faster repayment, a borrower can employ the following techniques to reduce mortgage balances more quickly and save money:

Increasing Regular Payments

One way to pay off a mortgage faster is to make small additional payments each month. This technique can save borrowers a considerable amount of money.

For example, a borrower who has a $150,000 mortgage amortized over 25 years at an interest rate of 5.45% can pay it off 2.5 years sooner by paying an extra $50 a month over the life of the mortgage. This would result in a savings of over $14,000.

Accelerating Payments

Most financial institutions offer several payment frequency options besides making one payment per month. Switching to a more frequent mode of payment, such as biweekly payments, has the effect of a borrower making an extra annual payment. This will result in significant savings on a mortgage.

For example, suppose a borrower has a $150,000 mortgage amortized over 25 years with an interest rate of 6.45% repaid in biweekly rather than monthly installments. By paying half of the monthly amount every two weeks, that person can save nearly $30,000 over the life of the loan.

Making Lump Sum Payments or Prepayments

A prepayment is a lump sum payment made in addition to regular mortgage installments. These additional payments reduce the outstanding balance of a mortgage, resulting in a shorter mortgage term. The earlier a borrower makes prepayments, the more it reduces the overall interest paid, typically leading to quicker mortgage repayment.

Nonetheless, borrowers should keep in mind that banks may impose stipulations governing prepayments since they reduce a bank's earnings on a given mortgage. These conditions may consist of a penalty for prepayments, a cap on how much borrowers can pay in a lump sum form, or a minimum amount specified for prepayments. If such conditions exist, a bank will usually spell them out in the mortgage agreement.

Refinancing a Mortgage

Refinancing involves replacing an existing mortgage with a new mortgage loan contract. While this usually means a different interest rate and new loan conditions, it also involves a new application, an underwriting process, and a closing, amounting to significant fees and other costs.

Despite these challenges, refinancing can benefit borrowers, but they should weigh the comparison carefully and read any new agreement thoroughly.

Drawbacks of Amortizing a Mortgage Faster

Before paying back a mortgage early, borrowers should also understand the disadvantages of paying ahead on a mortgage. Overall, mortgage rates are relatively low compared to the interest rates on other loan types such as personal loans or credit cards. Hence, paying ahead on a mortgage means the borrower cannot use the money to invest and make higher returns elsewhere. In other words, a borrower can incur a significant opportunity cost by paying off a mortgage with a 4% interest rate when they could earn a 10% return by investing that money.

Prepayment penalties or lost mortgage interest deductions on tax returns are other examples of opportunity costs. Borrowers should consider such factors before making additional payments.

Mortgage Amortization Calculator (2024)

FAQs

What is the easiest way to calculate amortization? ›

To calculate amortization, first multiply your principal balance by your interest rate. Next, divide that by 12 months to know your interest fee for your current month. Finally, subtract that interest fee from your total monthly payment. What remains is how much will go toward principal for that month.

How to easily calculate mortgage payment? ›

For example, if your interest rate is 6 percent, you would divide 0.06 by 12 to get a monthly rate of 0.005. You would then multiply this number by the amount of your loan to calculate your loan payment. If your loan amount is $100,000, you would multiply $100,000 by 0.005 for a monthly payment of $500.

What happens if I pay 3 extra mortgage payments a year? ›

You might find that making extra payments on your mortgage can help you repay your loan more quickly, and with less interest than making payments according to loan's original payment terms.

How do you calculate how much you would qualify for a mortgage? ›

Using a percentage of your income can help determine how much house you can afford. For example, the 28/36 rule may help you decide how much to spend on a home. The rule states that your mortgage should be no more than 28 percent of your total monthly gross income and no more than 36 percent of your total debt.

What is the rule of 72 in amortization? ›

It's an easy way to calculate just how long it's going to take for your money to double. Just take the number 72 and divide it by the interest rate you hope to earn. That number gives you the approximate number of years it will take for your investment to double.

What is the most commonly used method of amortization? ›

There are several ways to calculate the amortization of intangibles. The most common way to do so is by using the straight line method, which involves expensing the asset over a period of time.

What is the rule of thumb for calculating a mortgage payment? ›

The 28% rule

The 28% mortgage rule states that you should spend 28% or less of your monthly gross income on your mortgage payment (e.g., principal, interest, taxes and insurance). To determine how much you can afford using this rule, multiply your monthly gross income by 28%.

How much house can I afford if I make $70,000 a year? ›

With a $70,000 annual salary and using a 50% DTI, your home buying budget could potentially afford a house priced between $180,000 to $280,000, depending on your financial situation, credit score, and current market conditions.

Which formula should be used to correctly calculate the monthly mortgage payment? ›

The correct formula to calculate the monthly mortgage payment is m = p * (r * (1 + r)^n) / ((1 + r)^n - 1). This formula considers the principal amount, monthly interest rate, and the total number of payments to determine the fixed monthly payment required to repay the mortgage loan over the specified period.

What happens if I pay an extra $100 a month on my mortgage? ›

An extra $100 per month can make a bigger impact than you might think with your loan because when you pay this additional sum every month, the entire amount goes toward bringing down your principal balance. Usually, a good portion of each regular monthly payment goes toward just reducing the interest that you owe.

What happens if I pay an extra $500 a month on my 30 year mortgage? ›

Making extra payments of $500/month could save you $60,798 in interest over the life of the loan. You could own your house 13 years sooner than under your current payment. These calculations are tools for learning more about the mortgage process and are for educational/estimation purposes only.

How much house can I afford if I make $36,000 a year? ›

On a salary of $36,000 per year, you can afford a house priced around $100,000-$110,000 with a monthly payment of just over $1,000. This assumes you have no other debts you're paying off, but also that you haven't been able to save much for a down payment.

How much income do I need for a $400000 mortgage? ›

To afford a $400,000 house, you typically need an annual income between $100,000 to $125,000, which translates to a gross monthly income of approximately $8,333 to $10,417. However, this is a general range, and your specific circ*mstances will determine the exact income required.

How much income do you need to qualify for a $300 000 mortgage? ›

To comfortably afford a $300,000 house, you'll likely need an annual income between $75,000 to $95,000, depending on your specific financial situation and the terms of your mortgage. Your gross monthly income is a key factor in determining how much house you can afford.

What is the formula for total amortization? ›

Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal.

Is there an Excel formula for amortization? ›

The beginning loan amount changes each month since a portion of the principal balance is being repaid as part of the monthly payment. Alternatively, we can use Excel's IPMT function, which has the following syntax: =IPMT(rate, per, nper, pv, [fv], [type]).

Which three methods are used to calculate amortized cost? ›

There are generally three methods for performing amortized analysis: the aggregate method, the accounting method, and the potential method. All of these give correct answers; the choice of which to use depends on which is most convenient for a particular situation.

What is the formula for calculating amortization expense? ›

There is a mathematical formula to calculate amortization in accounting to add to the projected expenses. Amortization of an intangible asset = (Cost of asset-salvage value)/Number of years the asset can add value. Salvage value - If the asset has any monetary value after its useful life.

Top Articles
Latest Posts
Article information

Author: Frankie Dare

Last Updated:

Views: 5792

Rating: 4.2 / 5 (73 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Frankie Dare

Birthday: 2000-01-27

Address: Suite 313 45115 Caridad Freeway, Port Barabaraville, MS 66713

Phone: +3769542039359

Job: Sales Manager

Hobby: Baton twirling, Stand-up comedy, Leather crafting, Rugby, tabletop games, Jigsaw puzzles, Air sports

Introduction: My name is Frankie Dare, I am a funny, beautiful, proud, fair, pleasant, cheerful, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.