Is your native language one other than English?
If so, can you help by validating these translations?

Mortgage Calculator with printable amortization schedule

advertisement

How to create a mortgage amortization schedule

Assuming you know the mortgage amount, to calculate the payment and create a schedule, leave all values set to "0" and follow these steps:

  1. Enter the Mortgage Loan Amount.
  2. Enter the expected Number of Payments.
  3. Enter the anticipated Annual Interest Rate.
  4. Set Payment Amount (P & I only) to 0 (the unknown).
  5. Click Amortization Schedule

That's it! That's all you need to do.

But there's a lot more you can do with this mortgage calculator.

×

Info...

  Original Size  
New! Drag & drop your saved files here to load...
File save and open are new beta test features. If you happen to get a different calculated result, do not assume that this calculator is making an error. Most likely, the problem is with the new file load feature. Please check that all settings got loaded as expected.

NOTICE - Always enter (and reenter) a 0 if you want a value calculated.

Since the calculator does not recalculate the payment when the mortgage amount changes (for example), users can create an amortization schedule with whatever payment amount they desire.

What is Mortgage Amortization?

advertisement

We learn from the financial dictionary that "amortization is the gradual repayment of a debt over a period of time, such as monthly payments on a mortgage loan or credit card balance. To amortize a mortgage, your payments must be large enough to pay not only the interest that has accrued but also to reduce the principal you owe."

An amortization schedule is a report showing the loan payments paid or due. The report provides details about how much of the payment the lender is allocating to principal and interest. The payment date due and the balance are frequently included in the schedule as well.

mortgage amortization schedule
First year of a mortgage amortization schedule with annual & running totals.

If the amount paid on the mortgage is not large enough to cover the interest due, then the mortgage balance will be increasing due to the unpaid interest. When a loan has an increasing balance, it is known as negative amortization. You can read more about it here. This calculator supports negative amortization.

Options that impact the amortization schedule

advertisement

Found on the "Set Dates or XPmts" tab:

More details about the available calculation options for odd day and irregular period interest.

  • Amortization Method - leave this setting set to "normal" unless you have a specific reason for setting it otherwise. For a complete explanation of these options, see Nine Loan Amortization Methods.
  • Days-Per-Year - 360/364/365 days per year option. This setting only impacts interest calculations when you set compounding frequency to a day based frequency (daily, exact/simple or continuous) or when there are odd days caused by an initial short or long period.
  • Fiscal Year-End for Report Totals - this setting establishes after what month the calculator shows year-end and running totals. This option is to accommodate businesses with fiscal year ends that do not coincide with the calendar year-end.
  • Rounding Options - due to interest and payment rounding with each payment (for example, payment or interest might calculate to 345.0457, but a schedule will need to round the value to 345.05), almost all loan schedules require a final rounding adjustment to bring the balance to "0". A footnote on the payment schedule informs you of the rounding amount.

Hopefully, you'll find this to be a full-featured mortgage calculator. If something is not clear, you may leave your question in the comments below

advertisement

3 Comments on “Mortgage Calculator With Amortization”

Join the conversation. Tell me what you think.
  • Hi,

    Which mortgage calculator is recommended to calculate the correct amount of interest in a leap year (ACT/365)? Installments are split between principal and interest.

    • Hi, For leap year, I believe you mean Actual/366. While not strictly a "mortgage calculator" either of these calculators support 366 day years. If your objective is to create an amortization schedule, with support for 366 days when the interest period falls in a leap year, then either of these two calculators should work for you.

      loan calculator

      Ultimate financial calculator

      Note, the "days per year" settings only impact interest calculations when compounding is set to a day based compounding frequency i.e. daily, exact/simple or continuous.

    • Actually, I didn’t realize that I hadn’t added the 366 day-per-year option to the mortgage calculator.

      I’ve now added it. Click on "Set Dates or XPmts" and select 365 or 366 from Days-per-Year.

      If you do not see the change right away, you may have to perform a hard refresh of the page:

      Depending on your operating system all you need to do is the following key combination:

      • Windows: ctrl + F5
      • Mac/Apple: Apple + R or command + R
      • Linux: F5

Comments, suggestions & questions welcomed...

* Required

Scroll to...
advertisement