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
8/2024$696$279$199,721
9/2024$695$280$199,441
10/2024$694$281$199,159
11/2024$693$282$198,877
12/2024$692$283$198,594
1/2025$691$284$198,310
2/2025$690$285$198,025
3/2025$689$286$197,739
4/2025$688$287$197,452
5/2025$687$288$197,164
6/2025$686$289$196,874
7/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

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

Can Excel calculate amortization schedule? ›

The PPMT function in Excel calculates the periodic principal amortization owed on the loan, which, to reiterate from earlier, should increase after each payment period.

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

How to pay off a 30-year mortgage in 15 years? ›

It suggests that homeowners who can afford substantial extra payments can pay off a 30-year mortgage in 15 years by making a weekly extra payment, equal to 10% of their monthly mortgage payment, toward the principal.

Is it better to pay extra on principal, monthly or yearly? ›

Making an extra mortgage payment each year could reduce the term of your loan significantly. The most budget-friendly way to do this is to pay 1/12 extra each month. For example, by paying $975 each month on a $900 mortgage payment, you'll have paid the equivalent of an extra payment by the end of the year.

Does paying extra principal change amortization schedule? ›

Paying a little extra towards your mortgage can go a long way. Making your normal monthly payments will pay down, or amortize, your loan. However, if it fits within your budget, paying extra toward your principal can be a great way to lessen the time it takes to repay your loans and the amount of interest you'll pay.

What is the difference between amortization and amortization schedule? ›

Amortization typically refers to the process of writing down the value of either a loan or an intangible asset. Amortization schedules are used by lenders, such as financial institutions, to present a loan repayment schedule based on a specific maturity date.

How to create an 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.

What three things you would find on an amortization schedule? ›

Beginning balance: This is the principal balance you have at the beginning of each new month before you make a loan payment. Scheduled payment: This is your monthly loan payment. This number will be the same every month. Principal: This is the amount paid toward your principal with every payment.

How do you calculate cost amortization? ›

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 effective amortization? ›

Interest expense is calculated as the effective-interest rate times the bond's carrying value for each period. The amount of amortization is the difference between the cash paid for interest and the calculated amount of bond interest expense.

What is an example of amortization? ›

Example A: A business has a $10,000 software license, which it expects will come to an end in five years. Using the straight-line method, the amortization expense would be $2,000 per year for the next five years. At the end of five years, the carrying amount of the asset will be zero.

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.

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.

How do you calculate simple interest amortization? ›

Formula for calculating simple interest

You can calculate your total interest by using this formula: Principal loan amount x Interest rate x Loan term in years = Interest.

Top Articles
Best Settings - Escape From Tarkov Guide - IGN
Excessive RAM and Page File causing game to be unplayable - SPT Mods Workshop
Maxtrack Live
Global Foods Trading GmbH, Biebesheim a. Rhein
Warren Ohio Craigslist
My E Chart Elliot
Occupational therapist
Craigslist Mpls Mn Apartments
Poe Pohx Profile
Ub Civil Engineering Flowsheet
83600 Block Of 11Th Street East Palmdale Ca
The Rise of Breckie Hill: How She Became a Social Media Star | Entertainment
Nj Scratch Off Remaining Prizes
My.doculivery.com/Crowncork
Fairy Liquid Near Me
Kaomoji Border
Daily Voice Tarrytown
Tyler Sis University City
Craigslist Clinton Ar
Keci News
Contracts for May 28, 2020
Amazing Lash Studio Casa Linda
Preggophili
Narragansett Bay Cruising - A Complete Guide: Explore Newport, Providence & More
Gunsmoke Tv Series Wiki
Filmy Met
Bad Business Private Server Commands
Rogold Extension
Jt Closeout World Rushville Indiana
Amici Pizza Los Alamitos
Navigating change - the workplace of tomorrow - key takeaways
Prima Healthcare Columbiana Ohio
Maybe Meant To Be Chapter 43
Xemu Vs Cxbx
Mydocbill.com/Mr
Atlanta Musicians Craigslist
2007 Peterbilt 387 Fuse Box Diagram
Craigslist Pets Plattsburgh Ny
Owa Hilton Email
Chase Bank Zip Code
Ehc Workspace Login
Hillsborough County Florida Recorder Of Deeds
Page 5747 – Christianity Today
Blippi Park Carlsbad
Madden 23 Can't Hire Offensive Coordinator
Walmart Front Door Wreaths
A Snowy Day In Oakland Showtimes Near Maya Pittsburg Cinemas
Fredatmcd.read.inkling.com
Bob Wright Yukon Accident
Latest Posts
Article information

Author: Pres. Lawanda Wiegand

Last Updated:

Views: 5938

Rating: 4 / 5 (51 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Pres. Lawanda Wiegand

Birthday: 1993-01-10

Address: Suite 391 6963 Ullrich Shore, Bellefort, WI 01350-7893

Phone: +6806610432415

Job: Dynamic Manufacturing Assistant

Hobby: amateur radio, Taekwondo, Wood carving, Parkour, Skateboarding, Running, Rafting

Introduction: My name is Pres. Lawanda Wiegand, I am a inquisitive, helpful, glamorous, cheerful, open, clever, innocent person who loves writing and wants to share my knowledge and understanding with you.