Amortization Chart & Printable Schedule

Currently the Amortization Schedule Calculator is the most popular financial calculator on this website. It calculates one of four unknowns or you can provide all the values. You are also in control of the loan and first payment dates. More below...»

- Calculate tax benefits
- Appreciated value
- User can set dates
- Extra payments

Original Size

US National Debt Calculator handles debts to $99 trillion. Amortize entire debt or your family's share of the debt (surprise!). Also, generic use for bond coupon schedules.

Need to amortize a really big debt?Important Note About Dates: This calculator allows irregular length first periods. That is, the calculator calculates the exact amount of interest due even when the initial period is shorter or longer than the other scheduled periods. This will produce interest charges that do not match other calculators. If you want to match other calculators then set the "Loan Date" and "1st Payment Date" so that they equal one full period as set in "Payment Frequency". Example: If the "Loan Date" is May 15th and the "Payment Frequency" is "Monthly", then the "1st Payment Date" should be set to June 15th, that is IF you want a conventional interest calculation. See the end of the "Help" text for some more details.

Every loan has four primary attributes or variables. (1) The loan amount, (2) the number of payments, (3) the annual interest rate and (4) the payment amount.

Enter any 3 values and zero ('0') for the unknown value. Click the [Calc] button to solve for the unknown and create a schedule.

Note: you can enter a non-zero value for all 4 variables. In that case, your inputs will be used to create the amortization schedule.

The "Loan Date" is the date the monies are advanced. It is also called the "origination date".

The "First Payment Date" is the date the first payment is due. It may be the same date as the "Loan Date" but not usually. When they are the same, this is known as "Payment-in-Advance". Leases are typically paid-in advance.

"Payment Frequency" determines how often payments are due. Monthly is the most common in the USA.

"Compounding" impacts how interest is calculated. In most cases "Compounding" should equal the "Payment Frequency".

"Points" are charged on some loans by the lender. Points are expressed as a percentage of the loan amount. A 300,000.00 loan with 2 points results in an extra fee due the lender of 6,000.00. Points are common for mortgages in the US only. Normally, you will want to leave this input set to 0.0%.

The "Amortization Method" should usually be set to "Normal". If the loan originates in "Canada" then you'll want to set this to the "Canadian" method. In some special cases loans will have only the interest paid as the regular payment or no interest at all. In that case, you can set the "Amortization Method" to accommodate those types of loans. The "Rule-of-78's" is sometimes used for car loans or other consumer loans.

To print any loan schedule, click on "Print Preview" and then "Print this schedule".

When the first period, the period of time between the "loan date" and the "first payment date" is longer than one full period, there will be interest due for the "extra days". This is known as "odd day interest". The odd day interest, with this schedule, is shown as being paid on the loan date. Example: if the "loan date" is March 24 and the "first payment date" is May 1, then there are 8 odd days of interest - March 24th to April 1st.

Conversely, if the time between the "loan date" and "first payment date" is less than the payment period set, then the first period is said to be a "short initial period" and the first payment will be reduced due to less interest being owed.

What is amortization? According to vocabulary.com, "amortization means a debt is being paid off by a series of payments". When people search for an amortization calculator, they search for it using many different search phrases. If you are searching for any of these financial calculators, this calculator should meet your needs. If it doesn't, feel free to tell me what you need in the comment area below and there is a good chance I'll be able to make a recommendation.

- amortization calculator
- amortization table
- loan amortization calculator
- loan amortization
- loan amortization schedule

loan payoff calculator. For a step-by-step example see the payoff calculation tutorial.

Don't over pay, don't under collect. If you need to track payments on the exact date they are paid (or missed) for whatever amount, then use theThis website has dozens of financial calculators that create various amortization schedules, payment schedules, withdrawal schedules and general cash flow schedules. This is a complete list of our free, online calculators. Feel free to surf!

The loan calculator, mortgage calculator and

auto loan calculator have all recently been updated.

- Supports setting dates - just like this calculator
- User controls when and how odd day interest is due
- Do "what-if" with extra payments
- User can select last month for year end totals

Is there a way to post extra payment against principle?

There is, but not with the amortization schedule. Please use the recently updated loan calculator. It now has the same features as the amortization schedule plus a few more including the ability to add a series of extra payments or a single extra payment. If you need even more flexibility, then I’ll make other suggestions.

I’m trying to figure the payoff amount to close a loan that would ordinarily run for another 3 years. The hard part comes in because my debtor paid a one time principal-only $10,000 reduction and then 5 months later paid another $5,000 to reduce the principal even further. Is there a way to enter two disparate amounts paid at these odd intervals and still come up with the correct balloon payment he needs to make to pay the loan off early?

The amortization schedule calculator is not designed for such flexibility. However this calculator can be used as a loan payoff calculator. Please scroll down the page and look at tutorial #25. I also suggest you take a look at tutorial #1 to get started.

The above-suggested calculator allows users to enter payments made on any date for any amount. Once you have reviewed the tutorials, if you have any questions, please ask.

This is a really helpful calculator. There is a down payment assistance program for first time homebuyers in San Diego. They offer a payment deferred (for 30 yrs) piggyback loan at 3% for up to 17% of the purchase price. As your calc shows, 17% of anything is pretty huge after 30 yrs of deferred payments.

Wow, I wasn’t aware of such a program. That’s too bad. Subsidies just enable the sellers to get a higher price than they would otherwise be able to get. And in addition, they expose the taxpayers to payback risks.

Karl

Love this amortization program

Can I buy this program which allows me to choose an old state date and also print the schedule. I have a Mac

Glad you like the calculator. The software I have available for download only runs on Window PCs. However, it’s not clear to me what you need to do that this calculator won’t do? (I think there’s a typo in you question.) This calculator does allow you to set any date you need back to January 1, 1970.

I want a calculator that allows me to put in the date the payment was actually made and it calculates the principal and interest split. Can you help me with that?

Thank you

Sure can. Please see this loan payoff calculator.

Above will let you enter individual or series of payments with any payment date. You can also change rates and have additional borrows if needed.

The best way for learning how to use it, I think, is to scroll down the page to the tutorials. Everyone should review tutorial #1 for orientation. Then tutorial #25 explicitly addresses your requirement.

Thank you.

Does amortization HAVE to happen only one way? For example, rather than the first payment being nearly all interest, may the first payment be nearly all principle?

No, it does not. I have had users mention that there are loans where all the interest is paid at the end. I have no first hand experience with this however.

Under the "Amortization Method" setting, you can select "Fixed Principal" and depending on other factors, the 1st payment may have a larger amount allocated to principal than to interest. But for this method, the payment amount declines. The total interest paid will be less than with the normal method.

Hi, any way to figure out what the effective amortization is?

"Effective amortization" is not a term with which I’m familiar. Can you give me an example or briefly explain what it is? Then I’ll look into it.

Can make same calculation by excel

From the "Print Preview" view, it is possible to select the entire schedule and then copy/paste it into Excel. You may have to use Excel’s "Paste Special" feature and paste it as unformatted text depending on which browser you are using.

If you want to export an amortization schedule to Excel, then the

C-Value!program has that feature. It costs $49.95 and runs on any Windows computer.Hi, I’m thinking you’ll be able to help me – I have a seller financed mortgage and I’m trying to determine what balance remains. The loan is/was for 20 years, started in 2015. Year 1-2, the interest was a certain percent. Year 3-7 is another percent, year 7-10 is another percent and years 10-20 is another percent. The payment will be the same throughout the loan. Do you have a calculator for me?

Hi, sure do!

Please look at this financial calculator. This calculator will allow you to change the interest rate on any date. It can also accept a series of loan payments or individual payments on specific dates if you need to track those as well.

Once on the page, scroll down for a series of tutorials. I suggest that everyone take a look at #1 to get started. Then you can pick ones that deal with your specific needs. Feel free to ask any questions you might have.

If you try it, let me know how you made out, please.

Hey Karl. Thanks for posting the calc.

I was actually using your calcs to match up with mine and everything works well. I’m trying to create an excel amortization worksheet for a 180/365 mortgage. Can you provide me with the interest calculation for this please? Thanks in advance.

Willy

Hi Willy, I limit my comments to answering questions about either how to use a particular calculator or what calculator is best to use to solve a given financial problem. The equations are my IP and I charge for my services to build custom calculators for other sites. Perhaps someone else will answer your question.

Is this a one time purchase price or an annual fee. It appears you offer support for your software?

For either C-Value! or SolveIT!, the charge is a one-time charge for the current version. If a user ever wanted to upgrade, then there would be another charge. Support is either via email or comments on a web page.

Of course, the calculator on this page is free.

The printing function does not show up when the Print preview box is chosen.

There are "Print" buttons located in 2 places in the "Print Preview" window. One in the upper left corner of the window frame and one at the end of the schedule itself (you’ll have to scroll as it’s not on the frame) in the bottom center.

If you don’t see either, can you tell me what device you are using and what browser. I’ll check.

I am using Windows 10, Google Chrome on a desktop computer. When I press calculate i can see the schedule, but when I click the print preview, absolutely nothing happens. I tried both the amortization schedule and loan schedules. It just won’t print. This is a $2.8M loan so it is quite lengthy, though I won’t print the whole thing. is this out of the parameters of the software?

There’s a loan amount limit of 999 million and 999 for the number of payments.

Also, there normally is 0 problems with Chrome or Windows 10. That’s exactly what I use.

I know it’s going to sound stupid, but when was the last time the computer was rebooted? I would try that, or if you are familiar with task manager, you can see if all Chrome sessions are killed after closing the browser. Perhaps you have a Chrome session that has crashed.

One note, you needn’t click the calc button before using the print preview button. Print preview will also calculate the unknown value.

Can you let me know if you reboot if that helps?

OK, I see because that particular loan has a rather small monthly payment, the number of payments exceed 999, which is why the program wouldn’t work.

Thanks and have a super week!

Oh, thanks for letting me know. That’s not good. Such a case should show the user a message. I’ll look into adding one.

One thing, it may be, and I just forget now. If you were solving for the number of payments, it could be that the browser ran out of memory. The limit of 999 is on the input. But I think the only limit on a calculated term is based on available memory.

how do i produce an amortization schedule for a 10 year loan that the first 2 years are not paid until the beginning of year 3 but acrue interest for the first 2 years and the first payment is the accrued interest only

There is a calculator on this site that will do what you need, but not this one.

For complete flexibility please see this financial calculator. Once on the page, scroll down to the tutorials and check out tutorial #1 to get an overview. Then see the tutorial about interest only payments. Basically, you’ll enter a loan in the first row with the loan date, followed by one row that is for a single interest only payment on any date you would like. Then follow the single payment row with a row for the required number of principal and interest payments (119 for 10 years less the single interest only payment).

Also, under "Settings", you’ll need to check out the interest options for long initial periods.

If you have questions, you can ask them in the comments at the bottom of that page.

Please let me know how you make out.

I am trying to use your online calculator to create an amortization table for a recently opened loan, but when i change the loan date to 12/18/17 and the first payment due to 2/1/18 and hit Calc, the dates both change to today’s date. Am I missing something? Or is it just not compatible with my system? I have a Mac (with MS Office installed on the desktop and available in the cloud), but since I am using your calculator online I wouldn’t think that would matter.

This online amortization schedule should work just fine using any modern browser, on an computer. Try this before clicking calc (or the print preview, which acts like calc), make sure you’ve tabbed off the date fields.

When you do that, do the dates still stay set?

What are your other settings? If you happened to have entered the dates in reverse, this might confuse the calculator and it could set the date today, though I’ve not checked that.

I figured it out — I was typing in the date with only two digits for the year, so when I hit tab it just changed back to today’s date (it briefly showed “1917” which I didn’t catch the first time). Once I entered the years as 4 digit numbers it worked fine. Thanks for the quick response!

Oh, thanks for letting me know. Glad you got it figured out. (I should have suggested it, or recommend using the pop-up calendar.)

Your Calculator is the only one of many I have found that created an amortization schedule that is to the penny accurate to my current loan. Thank you!

I do have a question tho. I know the interest compounds daily as far as the bank is concerned but they also reference a 360 method. When I try to enter both in other calculators it does not allow, it wants one of the other and the numbers are not accurate. Can I ask what the difference is between your calculator and the others? Does it have anything to do with the “normal” amortization method coupled with the daily compounding?

I am needing to explain this to another person and wish to be able to understand it myself first.

I can’t say exactly without knowing specifically what "other" calculators you are referencing.

But my guess is they make assumptions and they just haven’t gone to the trouble to allow the user to make all settings. The calculator gets more complex if the user has more options.