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

Hi Karl,

Question re loan amortizer online.

Entered loan as follows:

Principal: $200,000

Interest: 3% per annum

Payments: 60

Loan date: 10/2/2017

First payment date: 3/1/2018

Calculated payment: $3,593.74

This differs from what I calculated using LoanAmortizer Enterprise edition:

Principal: $200,000

Interest: 3% per annum

Payments: 60

Loan date: 10/2/2017

First payment date: 3/1/2018

Calculated payment: $3,629.45

note: 365 day year

I’m hopeful you could help explain the difference.

Thank you,

Jonathan

Hi Jonathan, first, thank you for posting the question here. Secondly, I’m a bit rushed right now, so if this answer doesn’t cover enough detail, perhaps we can take up remaining questions tomorrow?

To answer your question, the difference has to do with the dates, based on and assuming regular monthly payments, your example has a very long initial first period (longer than the monthly frequency selected). The question is, what to do with the additional interest?

Notice, this calculator has a lower payment, but the additional interest from what is commonly called the "odd days" is paid at the loan origination. My guess is, the other calculator is not showing the odd day interest paid up front but is adding it to all payments.

Neither method is wrong and both payment amounts can be considered correct.

In fact, if you look at this site’s just updated loan calculator there are some interest options and when the options are set to amortize the odd days interest, the payment amount will exactly match the other calculator.

Hope this helps.

While I’m at it, this finance calculator will also give you options for how interest is handled of irregular initial periods as will the just updated mortgage calculator.

Karl – thank you so much. You are generous in wisdom!

I use your amortization schedule frequently and have found it so user friendly. I am very pleased I have come across your website. For some reason, recently when I input the rate of 3.625% (for normal amortization) and do the print preview to print the payment schedule, it changes the rate to 3.6249%. None of the other rates will do this. I was curious about this and would prefer it stay as 3.625% for the printed schedule. Can you take a peek at this?

Glad you have found it to be "friendly". Now all I have to do is make it accurate. 🙂

I can confirm that I see the same problem. I’ll take a look at where the rounding is going wrong (converting from the representation of a number with the ‘%’ tacked on to an actual number) and get a fix out. Unfortunately, this won’t happen over night however.

Ann, the problem with the interest rate display (3.625% showing as 3.6249%) is fixed. Thanks for telling me about it.

Great!! Thank you so much.

Hi Karl,

When I came across to your website I see that there is Amortization Method option ( Canadian, Normal …..) . I did not see it on other sites this option. Would you please tell me what the difference between Normal and Canadian method ? I see that I am getting different numbers for each of them. Also there is any way to export the schedule report into excel ?

Thank you,

Adi

Hi Adi. First about the Canadian option. For some loans, if not all loans, the Canadians regulate the compounding frequency. It must be semiannual or annual. When a user sets this calculator to "Canadian", it forces the payment frequency to monthly and compounding to annual. If you were to set the "Amortization Method" to "Normal" and payment to monthly and compounding to semiannual, you would get the same results as setting "Amortization Method" to "Canadian."

There is no way to directly export to Excel. There have been several requests to add this feature and earlier this month, I spent some time developing it. The issue I ran into was this, I could either get the calculator to do a very plain export so that numbers remained numbers and then they could be included in formulas within the spreadsheet, or I could get the calculator to export with nice formatting but the numbers were converted to text in the cells. Including them in formulas then would fail.

Facing this dilemma, I decided to hold off on adding this feature until I have a better understand as to what users expect.

Hi Karl

Why is the normal calculation based on a 360 day period in a year? This impacts my calculations as interest is charged daily but paid monthly.

Thanks

Hi Nicolette, I assume that you saw you can change the day per year option under "Settings?"

Also, it impacts the calculation only if there are initial odd days. Does this address your concern?

Thanks Karl. Yes I only saw it this morning however, but I appreciate the speedy response 🙂

Hey Karl, This looks great. I was wondering, Is there a way this can be broke down to a bimonthly schedule, but only making the payment as 100%. ex. Say loan due every month is $500.00 so every 15 days the payment is $250.00. I was wondering how much I would save paying my home loan this way.

Thanks for your time!

Mark

Hi Mark, Sure, I think I understand. There are two options:

I just noticed, you said every 15 days. Biweekly is every other week. Is that OK. For every 15 days, you would have to use this calculator and select twice monthly for the payment frequency.

How can I set this calculator to calculate on a 365 day basis rather than a 360 day basis?

Click on the "Settings" button and select "360 / 364 /365" to open the window to make the setting.

Note, this setting only impacts interest calculations when a user has selected "Daily" or "Exact / Simple" compounding OR there is an initial irregular length period.

Thank you!

Hello and thanks for this extremely useful calculator. I especially like that you can put in any number of payments and not be tied to “years” as many do. I wonder if there is a way to view the entire amortization schedule via scrolling rather than hitting page to page? That would make it very easy to ‘cut and paste’ into exel (for example) so that it would be possible to digitally keep in particular files for particular buildings.

Hi, you can get the behavior you want by clicking on the

print previewbutton. I use it personally instead of using the calc button. You can scroll through the entire schedule when the print preview window is open. Also, if you select the schedule there, you can copy and paste to Excel. If you use a non-Microsoft browser, you probably will need to do a paste special in Excel.Hello, first thank you for this tool! @nd, is there any way to down load the results in soft copy?

Thanks!

Eric

Hi,

You’re welcome.

There is not a download or save feature per se. However, what you can do, is use the print preview feature (I use it

instead ofthe Calc button) and select the entire schedule and then you can copy/paste to Word or Excel for example.The other alternative is, again from print preview, print to a PDF. Google Chrome will offer this feature built in. For other browsers, I can’t really say. You may have to download a free PDF print driver.

Let me know if you need additional details.

It won’t allow me to enter a first payment date. Every time I enter 12/01/17, it changes it to 11/01/17

What’s the "Loan Date" set to? Payment date must be on or after loan date.

No/Yr Date Payment Interest Principal Balance

Loan: 11/01/2017 0.00 0.00 0.00 70,075.00

1:1 11/01/2017 1,073.22 0.00 1,073.22 69,001.78

2:1 12/01/2017 1,073.22 188.95 884.27 68,117.51

2017 Totals: 12/31/2017 2,146.44 188.95 1,957.49

Running Totals: 12/31/2017 2,146.44 188.95 1,957.49

I entered the loan date as of 11/01/17 and try to enter first payment date at 12/01/17, but it keeps changing the first payment date to 11/01/17, of course with no interest on the first payment, all principal.

I did get it to work. Thanks, Don

Great, because my earlier reply was totally off base and must not have made any sense.

Were you able to understand why it didn’t work for you at first? If so, can you let me know?

I had used 11/01/17 for Loan date and 12/01/17 first first payment, but it kept change 12/01/17 to 11/01/07. I changed the loan date to 11/02/17 and it let me use 12/01/07 for first payment. You can see the data above i copied and pasted with those dates, but as you can see,it indicated a first payment on 11/01/17 all principal, no interest.

I don’t know why the discrepancy.

Thanks, Don

How does one calculate interest if compound is less frequent than payment frequency? I like to be a ‘know it all’ and I don’t know it lol. For example, an annual compound with a monthly payment frequency.

I never discuss equations. That’s my IP accumulated over 30 years.

Yours is the best calculator site ever!

Now, question:

If I have loan for $70,000 on 12/1/17, with 4% interest, payable in installments on 12/1 in 2018, 2019, 2020, and 2021.

Each annual payment is to be $17,500 on principal + the accrued interest (which of course varies each year).

How do I get it to calculate each year’s payment?

Thanks!

Thank you Jackie!

This is a "

Fixed Principal" and that option/setting is found under the "Amortization Method". Set that option and "0" for the payment amount. Loan date will Dec 1, 2017 and first payment will be Dec. 1, 2018 of course. Loan paid off in 4 payments.Let me know if you have any questions.

I need an amortization schedule for:

1st payment: March 15, 2015

Amount Financed: $6800.00

Interest Rate 7%

Monthly Payments: $100.00

Person could only pay $100 each month so I need to see how long the payments will be.

Former Bookkeeper did not print out a schedule so I am having to go back to first payment date.

It showed payments thru 12-01-18, then it shows something like a one time balloon payment after that.

I need it to show me monthly for however many months it takes.

Can you help me?

Gloria

I think so.

Assuming the payments were made regularly and/or you just want a very good approximation for when the loan will be paid off (but not the exact date), you can use this calculator. What you do is enter the values you indicated above and the dates, but enter 0 for the "Payments" and the calculator will calculate the term of the loan using the $100.00 payment amount.

If, on the other hand, you need to audit the loan and come up with an exact balance, let me know and we can walk through that as well.