Amortization Schedule Calculator | Bankrate (2024)

Amortization is paying off a debt over time in equal installments. Part of each payment goes toward the loan principal, and part goes toward interest. As the loan amortizes, the amount going toward principal starts out small, and gradually grows larger month by month. In an amortization schedule, you can see how much money you pay in principal and interest over time. Use this calculator to input the details of your loan and see how those payments break down over your loan term.

  • What is an amortization schedule?
  • How do you calculate amortization?
  • How do I calculate monthly mortgage payments?
  • How a mortgage calculator can help

What is amortization?

Each month, your mortgage payment goes towards paying off the amount you borrowed, plus interest, in addition to homeowners insurance and property taxes. Over the course of the loan term, the portion that you pay towards principal and interest will vary according to an amortization schedule. If you take out a fixed-rate mortgage, you’ll repay the loan in equal installments, but nonetheless, the amount that goes towards the principal and the amount that goes towards interest will differ each time you make a payment.

Over the course of the loan, you’ll start to have a higher percentage of the payment going towards the principal and a lower percentage of the payment going towards interest. With a longer amortization period, your monthly payment will be lower, since there’s more time to repay. The downside is that you’ll spend more on interest and will need more time to reduce the principal balance, so you will build equity in your home more slowly.

What is an amortization schedule?

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.

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.

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 full 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 in your home.

To use the calculator, input your mortgage amount, your mortgage term (in months or years), and your interest rate. You can also add extra monthly payments if you anticipate adding extra payments during the life of the loan. The calculator will tell you what your monthly payment will be and how much you’ll pay in interest over the life of the loan. In addition, you’ll receive an in-depth schedule that describes how much you’ll pay towards principal and interest each month and how much outstanding principal balance you’ll have each month during the life of the loan.

How do I calculate monthly mortgage payments?

Your monthly mortgage payments are determined by a number of factors, including your principal loan amount, monthly interest rate and loan term. A higher interest rate, higher principal balance, and longer loan term can all contribute to a larger monthly payment.

The monthly mortgage payment formula

Here’s a formula to calculate your monthly payments manually:

M = P

r (1 + r)n

(1 + r)n- 1

Symbol
Mthe total monthly mortgage payment
Pthe principal loan amount
ryour 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).
nnumber 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).

Next steps in paying off your mortgage

If you want to accelerate the payoff process, you can make biweekly mortgage payments or extra sums toward principal reduction each month or whenever you like. This tactic will have minimal impact on your budget, and it will still help you save significantly on interest.

If you can get a lower interest rate or a shorter loan term, you might want to refinance your mortgage. Refinancing incurs significant closing costs, so be sure to evaluate whether the amount you save will outweigh those upfront expenses.

Another option is mortgage recasting, where you preserve your existing loan and pay a lump sum towards the principal, and your lender will create a new amortization schedule reflecting the current balance. Your loan term and interest rate will remain the same, but your monthly payment will be lower. With fees around $200-$300, recasting can be a cheaper alternative to refinancing.

Lastly, a home loan modification brings the home loan current for borrowers experiencing financial hardship. While a loan modification might allow you to become mortgage-free faster, and could reduce your interest burden as well, this option may negatively impact your credit.

Popular next steps

Mortgage

What is amortization?

Mortgage

Prepaying your mortgage

Mortgage

Mortgage monthly payment calculator

Amortization Schedule Calculator | Bankrate (2024)

FAQs

How do I calculate my amortization schedule? ›

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 do you beat an amortization schedule? ›

3 Loan-Amortization Tips
  1. Add Extra Dollars to Your Monthly Payment. If your total mortgage loan is $100,000 and your fixed monthly payment is $500, add $100 or more to each monthly mortgage payment to pay down the loan more quickly. ...
  2. Make a Lump-Sum Payment. ...
  3. Make Bi-weekly Payments.
Mar 8, 2023

How much would a $50,000 personal loan cost per month? ›

Here's what a $50,000 loan would cost you each month
8.00%12.35%
Seven-Year Repayment$779.31/month, $15,462.10 in interest over time$892.02/month, $24,929.90 in interest over time
10-Year Repayment$606.64/month, $22,796.56 in interest over time$727.51/month, $37,300.90 in interest over time
1 more row
Jan 20, 2024

How much would a $70,000 loan cost? ›

The monthly payment on a $70,000 loan ranges from $957 to $7,032, depending on the APR and how long the loan lasts. For example, if you take out a $70,000 loan for one year with an APR of 36%, your monthly payment will be $7,032.

What is an amortization schedule answers? ›

An amortization schedule gives you a complete breakdown of every monthly payment, showing how much goes toward principal and how much goes toward interest. It can also show the total interest that you will have paid at a given point during the life of the loan and what your principal balance will be at any point.

How do I manually create a amortization schedule? ›

How to create an amortization schedule in Excel
  1. Create column A labels. ...
  2. Enter loan information in column B. ...
  3. Calculate payments in cell B4. ...
  4. Create column headers inside row seven. ...
  5. Fill in the "Period" column. ...
  6. Fill in cells B8 to H8. ...
  7. Fill in cells B9 to H9. ...
  8. Fill out the rest of the schedule using the crosshairs.
Feb 3, 2023

How do you calculate fully amortizing payments? ›

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.

How to pay off a 300k mortgage in 5 years? ›

Increasing your monthly payments, making bi-weekly payments, and making extra principal payments can help accelerate mortgage payoff. Cutting expenses, increasing income, and using windfalls to make lump sum payments can help pay off the mortgage faster.

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

Making additional principal payments will shorten the length of your mortgage term and allow you to build equity faster. Because your balance is being paid down faster, you'll have fewer total payments to make, in-turn leading to more savings.

What credit score do I need for a $10,000 loan? ›

To increase your chance of qualifying for a $10,000 unsecured loan, you should have a credit score of 600 or higher. Some lenders start their minimum credit score requirements at 600, however, there are some lenders that require a credit score in the high 600s or low 700s.

What credit score do you need to get a $30,000 loan? ›

You will need a credit score of 580 or higher to get a $30,000 personal loan in most cases, along with enough income to afford the monthly bill payments. Other common loan requirements include being at least 18 years old, being a U.S. citizen or a permanent resident, and having a valid bank account.

What credit score do I need for a $50,000 loan? ›

Most lenders prefer borrowers with a credit score in the good to excellent range (670 or higher), indicating a history of responsible financial management.

How do you calculate amortization method? ›

How to calculate loan amortization. You'll need to divide your annual interest rate by 12. For example, if your annual interest rate is 3%, then your monthly interest rate will be 0.25% (0.03 annual interest rate ÷ 12 months). You'll also multiply the number of years in your loan term by 12.

What is the formula for the monthly payment? ›

Monthly Payment = (P × r) ∕ n

Again, “P” represents your principal amount, and “r” is your APR. However, “n” in this equation is the number of payments you'll make over a year. Now for an example. Let's say you get an interest-only personal loan for $10,000 with an APR of 3.5% and a 60-month repayment term.

How do you calculate monthly loan payments? ›

The formula is: M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1], where M is the monthly payment, P is the loan amount, i is the interest rate (divided by 12) and n is the number of monthly payments.

What is the formula for the monthly payment of a loan? ›

So, to get your monthly loan payment, you must divide your interest rate by 12. Whatever figure you get, multiply it by your principal. A simpler way to look at it is monthly payment = principal x (interest rate / 12). The formula might seem complex, but it doesn't have to be.

Top Articles
Latest Posts
Article information

Author: Kerri Lueilwitz

Last Updated:

Views: 5273

Rating: 4.7 / 5 (67 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Kerri Lueilwitz

Birthday: 1992-10-31

Address: Suite 878 3699 Chantelle Roads, Colebury, NC 68599

Phone: +6111989609516

Job: Chief Farming Manager

Hobby: Mycology, Stone skipping, Dowsing, Whittling, Taxidermy, Sand art, Roller skating

Introduction: My name is Kerri Lueilwitz, I am a courageous, gentle, quaint, thankful, outstanding, brave, vast person who loves writing and wants to share my knowledge and understanding with you.