Please tell a friend about us. Thank you.

This recently updated Mortgage Calculator is unique when compared with financial calculators found elsewhere. It can solve for two unknowns at a time allowing you to calculate, for example, both the payment amount and the affordable house price. More below...»

Need a traditional loan calculator?
Our Loan Calculator solves for one of four unknowns and creates a printable payment schedule as well as several charts.
Will making small, extra payments save me money?
Our Extra Payment Calculator will create an amortization table and show you the interest saved.
Enter a "0" (zero) for one unknown value above.
Enter a "0" (zero) for one unknown value above.

©2016, all rights reserved
$ : mm/dd/yyyy
  Original Size  

Related: Loan Carrying Cost: Interest Reduction Techniques
from The Reading Room

Updated Nov. 26: Now includes points. (See Help.)

Updated Oct. 22: Now optionally calculates private mortgage insurance (PMI), real estate taxes and property insurance. Updated, easier to read schedule. Now prints more uniformly in a variety of browsers, not just Chrome and Firefox. Also, users can select all the text in the schedule and copy and paste it to Excel and hopefully other spreadsheets.

You can use this calculator to answer such questions as:

  • How much mortgage can I afford?
  • What is the mortgage payment?
  • How much money do I need to buy a house?
  • What is the down payment on a house?

Related You may also like the Auto Loan Calculator. It also accepts six inputs, but it asks for an amount for the down payment rather than a percentage.

This Mortgage Calculator is not limited to solving mortgage loan problems of course. It can be a useful tool whenever money is borrowed to purchase an asset and the down payments is expressed as a percent.

Do You Have 20 Seconds?
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! :)

17 thoughts on “mortgage-calculator

  1. Your columns are mixed up.
    The interest and the principal columns are wrong which is causing numbers to be incorrect.

  2. You’re referencing the print preview? The numbers aren’t wrong there. Using the default example, click on calc and then print preview. I see the following number for interest and principal for the first payment.

    1,516.67 interest
    922.43 principal

    The loan amount is $280,000 @ 6.5% interest rate.

    (6.5 / 100 / 12) * 280,000 = 1516.667

    Also, check the last running total of the principal column, the total equals the loan amount i.e $280,000.

    Or were you talking about something else?

  3. How can I enter the payment dates in the payment schedule?

    • If you want to enter payments as they are made (to determine exact loan balance or to handle extra or missed payments) then you can use this Time Value of Money Calculator . (This is a more flexible calculator but it will take time to learn. Please scroll to the bottom of the page for 25 tutorials.)

      If you just want to specify the loan’s origination date and first payment date and have the other payments on a regular schedule then you can use this amortization table, which I see you have already found.

  4. Why don’t the calculators auto-complete with the correct calculations once the required fills are filled in. It would lead to a much smoother user experience. Additionally, the errors that pop up when the calculator cannot calculate are vague, it would be helpful if they could pinpoint the exact source of error. Thank you!

    • Hi Rachel, so there are 2 questions / issues here. I’ll take the 2nd one first.

      As to the messages being vague, that should be very easy for me to fix. The problem is, they are not vague to me! Can you copy / paste here and tell me what isn’t clear and I’ll reword an update. I guess you keep seeing the message because they aren’t clear. The basic point to remember is, a user never types anything except for a number or the decimal character. And a user should use backspace to delete.

      As to the calculator auto calculating rather than clicking on the calculate button, that might be a future enhancement, but it’s tricky because many calculators can solve for multiple unknowns and there also does not need to be an unknown. Lets’s say a user wants to create a schedule with a specific payment amount which is not the normal payment amount and they want to have a term that results in a final larger balloon payment. Now they enter all their values and has they get to the payment amount, it has been calculated by the calculator because it previously had been 0. That means they have to clear out the just calculated value. That’s not ideal either.

      Probably the best thing is to let the user type Alt-C to calculate?

      Thanks for your comments and hope to hear what text you find not to be clear.

  5. In using the calculator, it seems that changing the accrual basis from 365 to 360 does not affect the payment amount which is incorrect. Not sure if this had been brought up before. Thanks

    • Hi, what calculator are you using? This calculator does not give the user an option for selecting a 360/365 day year.

      But, that aside, the 360/365 day option, where offered, only impacts calculations for “exact”, “daily” or “continuous” compounding OR when a period has odd days – say monthly frequency and dates go from Oct 7th to Nov. 1. Then you’ll see a difference due to 360/365 selection. The reason for this, if compounding is monthly and the period between the 2 dates is an even month, then the interest rate used is the nominal annual rate divided by 12 (not 360 or 365).

      You can check this for yourself using the Time Value of Money calculator.

      (Please do not reply to this email. If you have a follow-up, question, please post it on this site.)

      • I used the amortization calculator, although I accidentally added the comment under the mortgage calculator.

        I saw the statement impacts calculations for “exact”, “daily” or “continuous” compounding (when clicking settings to change the accrual basis) and even when I changed the option to compounding to daily from monthly, I could not see a difference in the payment.

        Terms are $100,000 at 5% for 60 months, note date 11/1/2016 with first payment 12/1/2016.

        We are in need of a loan calculator to calculate loan payments both on a 365 OR 360 accrual basis.

        Appreciate your help. Thank you!

        • I think I understand what’s happening. If you change between 360 or 365, you then need to go back and set the payment amount to 0, and recalculate it. The payment amount will not change on its own when the user changes the days per year option. Perhaps I need to think about making that change.

          Taking your numbers, I get these results:

          $1,887.51 for 365
          $1,890.70 for 360 days.

          Thanks for posting the follow-up.

          • Good morning- I went in and deleted the payment amount as you recommended and then calculated again but even like this I can’t get the payment amount to recalculate. I get a payment amount of $1887.12 for both 365 and 360. Any other suggestions? Thank you

          • This is perplexing. The calculator definitely will calculate different payment amounts based on 360/365 selection.

            Please confirm that compounding frequency is set to either “Daily” or “Exact/Simple”.

            Not really sure what you mean by “delete” the payment. Specifically, it has to be set to “0” (zero).

            If you reopen the settings dialog window, is your selection saved in every case? Meaning, when you select 360 and then reopen, do you see 360 selected? And same for the 365 selection. This setting is stored in a “cookie” on your local computer. Perhaps cookies are disabled? If they are, then it would not work either.

            Specifically what are all your inputes and what is the result of the calculated payment?

  6. ok, I think I got it. I corrected compounding from Monthly to Daily and made sure to set the payment to zero before changing the accrual basis. Thank you so much for your help.

  7. I have been looking for a calculator that told me the number of months it would take, and how much interest I would save, if I added money to every monthly mortgage payment.
    Your calculator takes into account exactly what I was looking for and gave me a figure in seconds.
    Thank you,
    Gail Hunt

  8. How do I change the date of the loan and the date of the payments?

    • With this calculator, the user can’t change the dates. The purpose of this calculator is to make it easy for a user to check total costs and affordability while making as few entries as possible.

      For being able to set dates, you have two choices.

      1. If you want to set the loan date and 1st payment date and then assume all payments are made on a fixed schedule, use the Amortization Schedule.

      2. If you want to record payments as they are made, that is, the payment dates vary, then use the Ultimate Financial Calculator.

      For #2, check out the tutorials on the page. Scroll down and read #25 (after reading #1), as that deals with random loan payments and calculating loan balances.

Comments, suggestions & questions welcomed...

* Required