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

How much is $20,000 amortized over 5 years? ›

If you borrow $20,000 over five years with a 5 percent interest rate, you'll pay $2,645.48 in interest on an amortized schedule. If you keep all other loan factors the same (rate, term and interest type) but increase your loan amount to $30,000, the interest you pay over five years would increase to $3,968.22.

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

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 formula for calculating Amortisation? ›

You can use the equation: I=P*r*t, where I=Interest, P=principal, r=rate, and t=time.

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.

Can you use Excel for amortization schedule? ›

User-friendliness: Excel is relatively user-friendly, so making an amortization schedule within the Excel program is fairly easy to do. Because of this, virtually anyone can create one of these schedules for their own business or personal financial purposes.

Can you negotiate amortization schedule? ›

While you may not be able to negotiate the interest rate of your mortgage, you can choose how many years it'll take you to pay it off–sort of.

How to create an amortization schedule? ›

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.

What is the difference between payment schedule and amortization schedule? ›

It's straightforward, but much less informative. Amortization tables, on the other hand, actually give borrowers some useful and transparent information in terms of how much they are paying in interest. A payment schedule will show you the payment due and on what date, but it won't reveal much more.

What is the actual amortization schedule? ›

An amortization schedule is a table that shows you how much of a mortgage payment is applied to the loan balance, and how much to interest, for every payment until the loan is paid off.

How to calculate amortization cost? ›

Assuming the straight-line method is used, the company divides the capitalized cost by the estimated useful life, and that gives you the amortization expense per year to recognize in the financial statements. Similar to depreciation, amortization is a non-cash expense, so there is no cash flow impact.

What is the straight line amortization schedule? ›

When a straight-line method is used, purchase expenses are amortized over the scheduled term based on the start date, end date, and method chosen. The start date and end date are included in the amortization term.

How to calculate accumulated amortization? ›

Accumulated amortization is calculated by dividing the value of the underlying intangible asset with years of its useful life. The division allows companies to report the same amount as amortization cost throughout the intangible asset life.

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 rule of 72 in amortization? ›

What is the Rule of 72? Here's how it works: Divide 72 by your expected annual interest rate (as a percentage, not a decimal). The answer is roughly the number of years it will take for your money to double. For example, if your investment earns 4 percent a year, it would take about 72 / 4 = 18 years to double.

Is there an Excel formula for amortization? ›

Enter "Original Balance" in cell A1, "Interest Rate (as a percentage)" in cell A2, "Term (in years)" in cell A3 and "Monthly Payment" in cell A4. Enter the corresponding values in cells B1 through B3. In cell B4, enter the formula "=-PMT(B2/1200,B3*12,B1)" to have Excel automatically calculate the monthly payment.

How do you make an amortization spreadsheet? ›

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.

References

Top Articles
Very off topic: Chicago
Eagles Tonight - Off Topic Discussions on theFretBoard
Is Paige Vanzant Related To Ronnie Van Zant
What spices do Germans cook with?
Phcs Medishare Provider Portal
Craigslist Cars And Trucks For Sale By Owner Indianapolis
Brendon Tyler Wharton Height
Culver's Flavor Of The Day Wilson Nc
Emmalangevin Fanhouse Leak
Vanadium Conan Exiles
Craigslist - Pets for Sale or Adoption in Zeeland, MI
California Department of Public Health
Valentina Gonzalez Leak
United Dual Complete Providers
6813472639
Site : Storagealamogordo.com Easy Call
Panic! At The Disco - Spotify Top Songs
Xsensual Portland
Yisd Home Access Center
Mj Nails Derby Ct
Mega Personal St Louis
Gazette Obituary Colorado Springs
Craigslist Roseburg Oregon Free Stuff
Caring Hearts For Canines Aberdeen Nc
Does Hunter Schafer Have A Dick
Rogue Lineage Uber Titles
Horn Rank
Bn9 Weather Radar
Devotion Showtimes Near Regency Buenaventura 6
Kirk Franklin Mother Debra Jones Age
The Clapping Song Lyrics by Belle Stars
Rainfall Map Oklahoma
FSA Award Package
Six Flags Employee Pay Stubs
Maybe Meant To Be Chapter 43
Heavenly Delusion Gif
Umiami Sorority Rankings
Mohave County Jobs Craigslist
Tugboat Information
Miracle Shoes Ff6
Check From Po Box 1111 Charlotte Nc 28201
2700 Yen To Usd
The best bagels in NYC, according to a New Yorker
Gym Assistant Manager Salary
Brown launches digital hub to expand community, career exploration for students, alumni
Menu Forest Lake – The Grillium Restaurant
Meet Robert Oppenheimer, the destroyer of worlds
Muni Metro Schedule
Suppress Spell Damage Poe
Laura Houston Wbap
Salem witch trials - Hysteria, Accusations, Executions
Texas 4A Baseball
Latest Posts
Article information

Author: Lakeisha Bayer VM

Last Updated:

Views: 5707

Rating: 4.9 / 5 (49 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Lakeisha Bayer VM

Birthday: 1997-10-17

Address: Suite 835 34136 Adrian Mountains, Floydton, UT 81036

Phone: +3571527672278

Job: Manufacturing Agent

Hobby: Skimboarding, Photography, Roller skating, Knife making, Paintball, Embroidery, Gunsmithing

Introduction: My name is Lakeisha Bayer VM, I am a brainy, kind, enchanting, healthy, lovely, clean, witty person who loves writing and wants to share my knowledge and understanding with you.