Amortization Calculator - Free Amortization Schedule | Zillow (2024)

This browser is no longer supported. Please switch to a supported browser or download one of our Mobile Apps.

See Mobile Apps

Skip main navigation

Our mortgage amortization calculator takes into account your loan amount, loan term, interest rate and loan start date to estimate the total principal and interest paid over the life of the loan. Adjust the fields in the calculator below to see your mortgage amortization.

Estimated monthly payment

$975

Total principal

$200,000

Total interest

$151,086

Principal & interest

$351,086

Next Step: Talk to a local lender

Whether you need a home loan or you want to refinance your existing loan, you can use Zillow to find a local lender who can help.

Amortization chart

The amortization chart shows the trend between interest paid and principal paid in comparison to the remaining loan balance. Based on the details provided in the amortization calculator above, over 30 years you’ll pay $351,086 in principal and interest.

Amortization schedule breakdown

Our mortgage amortization schedule makes it easy to see how much of your mortgage payment will go toward paying interest and principal over your loan term. You can view amortization by month or year. Keep in mind, your monthly mortgage payment may also include property taxes and home insurance - which aren't included in this amortization schedule, since the payments may fluctuate throughout your loan term.

  • Total principal payments: $200,000
  • Total interest payments: $151,086
DateInterestPrincipalPrincipal remaining
3/2024$696$279$199,721
4/2024$695$280$199,441
5/2024$694$281$199,159
6/2024$693$282$198,877
7/2024$692$283$198,594
8/2024$691$284$198,310
9/2024$690$285$198,025
10/2024$689$286$197,739
11/2024$688$287$197,452
12/2024$687$288$197,164
1/2025$686$289$196,874
2/2025$685$290$196,584

Explore more mortgage calculators

  • Affordability calculator

    How much house can you afford? Use our affordability calculator to estimate what you can comfortably spend on your new home.

  • Mortgage calculator

    What will your new home cost? Estimate your monthly mortgage payment with our easy-to-use mortgage calculator.

  • Debt-to-income calculator

    Your debt-to-income ratio helps determine if you would qualify for a mortgage. Use our DTI calculator to see if you're in the right range.

  • Refinance calculator

    Interested in refinancing your existing mortgage? Use our refinance calculator to see if refinancing makes sense for you.

Participating lenders may pay Zillow Group Marketplace, Inc. ("ZGMI") a fee to receive consumer contact information, like yours. ZGMI does not recommend or endorse any lender. We display lenders based on their location, customer reviews, and other data supplied by users. For more information on our advertising practices, see our . ZGMI is a licensed mortgage broker, NMLS #1303160. A list of state licenses and disclosures is available here.

What is amortization?

Amortization is the process of gradually paying off a debt through a series of fixed, periodic payments over an agreed upon term. The payment consists of both interest on the debt and the principal on the loan borrowed. At first, more of the monthly payment will go toward the interest. As more principal is paid, less interest is due on the remaining loan balance. You can estimate your mortgage loan amortization using an amortization calculator.

What is an amortization schedule?

An amortization schedule is a table that shows the amount of interest and principal you pay each month over time. In addition, the schedule will show you the total interest paid to date and the remaining principal balance on the loan. A mortgage loan is typically a self-amortizing loan, which means both principal and interest will be fully paid off when you make the last payment on the predetermined schedule — usually monthly. Our mortgage amortization table shows amortization by month and year.

How to calculate amortization

In order to make an amortization schedule, you'll need to know the principal loan amount, the monthly payment amount, the loan term and the interest rate on the loan. Our amortization calculator will do the math for you, using the following amortization formula to calculate the monthly interest payment, principal payment and outstanding loan balance.

  • Step 1: Convert the annual interest rate to a monthly rate by dividing it by 12.

    Annual interest rate / 12 = monthly interest rate

  • Step 2: Multiply the loan amount by the monthly rate to get the interest payment.

    Loan amount * monthly rate = interest payment

  • Step 3: Subtract the monthly mortgage payment from the interest to determine the principal payment.

    Monthly mortgage payment - interest payment = principal payment

  • Step 4: Subtract the principal from the loan amount to get the outstanding loan balance.

    Loan amount - principal payment = outstanding loan balance

The above steps calculate monthly amortization for the first month out of the 360 months in a typical 30-year loan. For the remaining months, repeat steps two through four using the previous outstanding loan balance as the new loan amount for the next month in the schedule.

For example, you can use the steps above to calculate amortization on a 30-year fixed-rate mortgage valued at $200,000 with a 3% interest rate (0.0025 monthly rate) and a monthly payment amount of $843. In a spreadsheet, show the first payment in row one, the interest payment in one column, the principal payment in the next column and the loan balance in the last column.

PaymentInterestPrincipalBalance
Payment 1$200,000 x 0.0025 = $500$843 - $500 = $343$200,000 - $343 = $199,657
Payment 2$199,657 x 0.0025 = $499$843 - $499 = $344$199,657 - $344 = $199,313

How to calculate amortization with an extra payment

Extra payments on a mortgage can be applied to the principal to reduce the amount of interest and shorten the amortization. To calculate amortization with an extra payment, simply add the extra payment to the principal payment for the month that the extra payment was made. Any additional extra payments throughout the loan term should be applied in the same way. Keep in mind, while you can pay off your principal early, in some cases there may be a pre-payment penalty for paying the loan off too early.

How to calculate the monthly payment on a mortgage

The easiest way to calculate loan payments is to use an amortization calculator. If trying to calculate amortization manually, you can use the PMT function in an Excel spreadsheet. The PMT function calculates payments on a loan based on constant payments and a constant interest rate. The format of the PMT function looks like this:

=PMT(annual interest rate/number of payment periods,number of years of the loan,present value of the loan)

If calculating the monthly payment on a 30-year fixed-rate mortgage valued at $200,000 with a 3% interest rate, the PMT function would look like the below and return a monthly payment amount of $843.

=PMT(0.03/12,360,200000)

Why use an amortization calculator?

Besides saving you the time of having to manually do all the math, a mortgage amortization calculator can help you determine:

  • How much principal and interest you owe now and in the future.
  • How much principal and interest you paid over the life of the loan.
  • How much principal and interest you paid during a particular year or month.
Amortization Calculator - Free Amortization Schedule | Zillow (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 I make my own amortization schedule? ›

It's relatively easy to produce a loan amortization schedule if you know what the monthly payment on the loan is. 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.

Can you use Excel for amortization schedule? ›

Excel amortization templates include pre-written formulas within cells to automatically calculate whatever data you need. In a good amortization Excel template, you only need to enter a few numbers, and formulas will take over and fill out the entire table for you.

How do I get an Amortisation schedule? ›

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 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.

How do you calculate the amount of amortization? ›

A loan amortization schedule is calculated using the loan amount, loan term, and interest rate. If you know these three things, you can use Excel's PMT function to calculate your monthly payment. In our example above, the information to enter in an Excel cell would be =PMT(3.5%/12,360,150000).

Can QuickBooks do an amortization schedule? ›

QuickBooks does not have a built-in tool to automatically calculate amortization schedules. For example, to amortize a loan in QuickBooks, you can set up the loan as a long-term liability account. Then each time you make a loan payment, record it with a check or journal entry against that loan account.

What are alternatives to amortization schedule? ›

Types of Non-Amortizing Loans
  • Type 1: Balloon Loan. ...
  • Type 2: Interest-Only Loans. ...
  • Type 3: Deferred-Interest Programs.

Can I print an amortization schedule? ›

For more complicated loan borrowing scenarios you should use an online spreadsheet, which also allows you to save or print out your loan amortization as a PDF. Periods per Year (12 for monthly, 26 for bi-weekly, 52 for weekly, etc.)

What is a normal amortization schedule? ›

An amortization schedule, often called an amortization table, spells out exactly what you'll be paying each month for your mortgage. The table will show your monthly payment, how much of it will go toward your loan's principal balance, and how much will be used on interest.

How do I create a lease amortization schedule? ›

Let's delve into a step-by-step procedure to understand this better.
  1. Create columns in the spreadsheet. ...
  2. Insert the due dates and payment amounts. ...
  3. Apply the NPV function. ...
  4. Calculation of interest on the lease liability. ...
  5. Determine the Closing Balance. ...
  6. Carry forward the closing balance to the next period.
Feb 2, 2023

Who provides amortization schedule? ›

For many borrowers, their lender will provide an amortization schedule for their mortgage loan.

How to calculate amortized cost? ›

Key Formulas
  1. Amortized Cost = Purchase Price - Repayments + Amortization of Discounts/Premiums.
  2. Amortization Amount Per Period = (Discount or Premium Amount) / Number of Periods.
Dec 21, 2023

How to solve amortization problems? ›

Amortization Formula
  1. PMT=P⋅(rm)[1−(1+rm)−mt]
  2. P is the balance in the account at the beginning (the principal, or amount of the loan)
  3. r is the annual interest rate in decimal form.
  4. t is the length of the loan, in years.
  5. m is the number of compounding periods in one year.
May 26, 2022

What is the formula for the monthly loan 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.

Top Articles
Latest Posts
Article information

Author: Velia Krajcik

Last Updated:

Views: 5253

Rating: 4.3 / 5 (54 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Velia Krajcik

Birthday: 1996-07-27

Address: 520 Balistreri Mount, South Armand, OR 60528

Phone: +466880739437

Job: Future Retail Associate

Hobby: Polo, Scouting, Worldbuilding, Cosplaying, Photography, Rowing, Nordic skating

Introduction: My name is Velia Krajcik, I am a handsome, clean, lucky, gleaming, magnificent, proud, glorious person who loves writing and wants to share my knowledge and understanding with you.