Amortization Chart & Printable Schedule

Original Size

Loan Carrying Cost: Interest Reduction Techniques from The Reading Room

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.

Don't want to be bothered setting dates? No problem. Use this loan calculator. It also creates an amortization schedule.

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

Ultimate Financial Calculator and see the loan 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 ourThis 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!

Please tell me how you use this calculator. Are you using it personally or professionally? What feature is important to you? If it didn't meet your needs, why? Your feedback will help me make improvements. Complete sentences aren't necessary! :)

Very useful for comparing stuff for personal use

but tried setting Payment Frequency from

“monthly” to “bi-weekly” but when “calc” is pressed,

it reverts back to “monthly”.

Thank you for both your compliment and comment.

That will happen – payment frequency changing from biweekly to monthly – only if the Amortization Method is set to “Canadian”. Notice that the compounding changes from whatever it is set to to “Semiannually”.

Set the Amortization Method to “Normal” and then you can set any combination of payment frequency and compounding frequency you desire.

I made some loans to a few friends. They don’t bother to send me a 1099. I use your loan calculator to figure the interest that I report to the IRS. Your loan calculator is handy . I wish you had a way of selecting for a certain year. For instance what is the total interest earned for 2016 ; evan though the loan is for multiple years?

Thank you for the comment, but I’m a little lost. If you want to see the interest for the year, the subtotal row of the schedule shows that with the specific year.

Did I misunderstand what you need?

I wanted to print out only the amortization schedule for the current year and not the whole amortization schedule.

Thanks for clarifying. At this moment, that’s not possible.

Your calculator gave me all I wanted, EXCEPT, I was not able to print a complete schedule. I understand I must be doing something wrong, but what!

In the row of buttons, there’s a “Print Preview” option. Click on that and then there is a print button in the upper left corner of the window that opens or at the bottom center at the very end of the schedule. Did you try either of those and still have a problem?

all I want is an amortzation schedule that shows the month amount that goes to interest and is applied to the principal on a loan of 21,012.02 with a monthly payment of $400.

What is calculated is useless to me.

Why? It will show you exactly that.

Enter the loan amount, interest rate and payment amount @ $400. Enter 0 for number of payments. Click calc and the schedule will show you the monthly $400 payment with the portion that is allocated to interest and principal.