Please tell a friend about us. Thank you.

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

Ultimate Investment Calculator
Calculate any investment unknown including income. Considers taxes, inflation and fees.
Recently Updated
Mortgage Calculator
  • Calculate tax benefits
  • Appreciated value
  • User can set dates
  • Extra payments
Will paying half the monthly payment every other week save interest charges?
Check out the Biweekly Loan Calculator to find out.
Enter a "0" (zero) for one unknown value above.
No/YrDatePaymentInterestPrincipalBalance
©2016 financial-calculators.com, all rights reserved
$ : mm/dd/yyyy
  Original Size  

Related: Need to amortize a really big debt? 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.

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.

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.

Related: 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 the loan payoff calculator. For a step-by-step example see the payoff calculation tutorial.

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

Need More Features?

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

495 thoughts on “amortization-schedule

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

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

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

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

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

      1. Using this amortization calculator, set the payment frequency to bi-weekly and the payment amount to $250.00. I would then set the number of periods to 0 and let the calculator calculate the term.
      2. The second option is to use the biweekly loan calcultor. This calculator, creates one schedule comparing the monthly payment plan to a biweekly payment plan.

        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.

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

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

  8. 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 of the 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.

Comments, suggestions & questions welcomed...

* Required