## How to use the mortgage calculator

- Enter the
**Price of Real Estate** - Enter the
**Down Payment Percent**or**Down Payment Amount**. - Set
**Mortgage Loan Amount**to**0**(if unknown). - Enter the expected
**Number of Payments**. - Enter the anticipated
**Annual Interest Rate**. - Set
**Mortgage Payment (P & I only)**to**0**(if unknown). - Optionally set the
**Mortgage Closing Date** - Optionally set the
**First Payment Due Date** - Optionally enter
**Points** - Click either
**Calc**or**Pmt & Cost Schedules**for the answers.

That's it! That's how to calculate a mortgage payment.

*But there's a lot more you can learn from this mortgage calculator.*

#### Info...

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

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

Why doesn't the calculator automatically recalculate the last unknown?

We want the calculator to create an payment schedule using whatever parameters **you** want to use. Such behavior is a feature!

By not automatically recalculating the payment (for example) when the mortgage amount changes, this calculator lets those users create a payment schedule with whatever payment amount they want.

## Notes about this calculator

**Found on the "Set Dates or XPmts" tab:**

*Mortgage Closing Date*- also called the**loan origination date**or**start date**.*First Payment Due*- due date for the first payment

About Dates & Interest Calculations - In the real world, the time between the **mortgage origination date** and the **first payment due date** will seldom be equal to the payment frequency.

Your mortgage can require monthly payments, but in reality, you might go to the closing on July 15, and the first payment might not be due until September 1. Such a scenario leads to what is commonly called a "long initial period" and "odd days interest." (Had the first payment been due on August 1, then the first period would be called an "initial short period.")

Long and short first periods impact interest and payment calculations.

**By giving users the ability to enter these two dates, this calculator can do penny perfect calculations.**

This will result in payment amounts and interest charges that do not match other calculators.

And that's the point! You do not need to settle for estimates.

If you are satisfied with approximations, however, or you want to match other calculators, then set the "Mortgage Closing Date" and "First Payment Date" so that the time between them equals one full period as selected in "Payment Frequency." Example: If the "Mortgage Date" is July 15 and the "Payment Frequency" is "Monthly," then the "First Payment Date" should be set to August 15.

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

### There are only six values you will usually need to set.

**Found on the "Calculator" tab:**

*Price of Real Estate or Asset*- the negotiated purchase price. This is optional. Enter a zero to calculate.*Down Payment Percent*- the anticipated down payment expressed as a percent of the purchase price. optional*Down Payment Amount*- the anticipated down payment expressed as an amount. optional*Mortgage Loan Amount*- the amount of the mortgage loan. This, too, is optional. Enter a zero to calculate.

You may:

- Enter the real estate price and the down payment to calculate the mortgage amount.
- Enter the mortgage amount and down payment to calculate the affordable real estate amount.
- Or enter the mortgage amount and zero for the down payment and price.

*Number of Payments*- the length of the loan. The "Payment Frequency" setting also impacts the loan's term. For a term of thirty years, if the payment frequency is monthly, you need to enter 360 for the number of payments. (360 monthly payments = 30 year mortgage)*Annual Interest Rate*- the nominal interest rate. This the quoted interest rate for the mortgage.*Mortgage Payment (P & I only)*- the amount due on each payment due date. The amount includes**only**principal and interest. Do not include any additional amounts for taxes or insurance if you enter a value.

**If the Mortgage Loan Amount is either set or calculated off the real estate price, then one of the above three can be set to zero so that the calculator can calculate it.**

### Mortgage options you may want to tweak:

*Payment Frequency*- set how often payments are scheduled. The calculator supports 11 options, including biweekly (every other week), monthly, and annually. The schedule calculates the payment due dates from the first payment due date (not the mortgage closing date).*Compounding*- usually, you should set the compounding frequency to be the same frequency as the payment frequency. Doing so results in simple, periodic interest. Setting this option to "Exact/Simple" results in simple, exact day interest.*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.*Calc. & Include APR on Schedule*- when "Yes," the mortgage schedule shows in a Regulation Z compliant format, the APR.

**Found on the "Options" tab:**

*Points*- calculated using the loan amount, they are reported in the first row of the schedule. One point is one percent of the mortgage loan amount. Points, by themselves, increases the APR. However, borrowers pay mortgage points in order to obtain a lower interest rate. The combination of points and the lower rate should result in an overall lower APR. Check the APR option to find out. optional

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

## Brian says:

Hello Karl,

I tried it all again after your comments. I had missed out steps in the ‘options’ menu and when I went back and put it all in again, it worked exactly as you said.

Thank you for your patience and responsiveness.

Brian

## Karl says:

No problem. Thanks for letting me know.

## GL says:

Looking to run an amortization schedule for a $50,000 10YR loan @ 3% with Bi-weekly payments of $500 on the 1st and $250 on the 15th of each month. I understand that it will pay it off much earlier, but which calculator will allow me to

add in all the particulars?

## Karl says:

Your requirement should be easily accomplished with this mortgage calculator. The way to set up your calculation isn’t obvious however.

What you’ll need to do is something similar to this:

Here’s the thinking. Though the payments happen biweekly, they are comprised of two series of staggered monthly payments. $5000 starts on the first and $250 starts on the 15th.

Also, don’t think in terms of a 10 year term because you have already determined the payment amounts. Therefore, set the number of payments to 0 so the calculator calculates the term. If your payment amount cause the loan to run beyond 10 years, then you can redo the calculation with 120 payments and the final payment will be a larger balloon amount.

If this doesn’t get you what you need, tell me what I’ve missed and I’m sure I can come up with something. Also, there’s another calculator on this site that is even more flexible that we can try if this doesn’t work out.

## chuck irwin says:

is this mortgage calculator using 360 or 365 days to calculate interest?

## Karl says:

The user is in complete control. Please see:

"Days Per Year?"

on the "Set Dates or Extra Payments" tab.

Yea, I know, not the most obvious location for that option. I guess I must have put it there, because that where it fit at the time.

## COLLINS EKEH says:

Hello,

i installed your Calculator plugins and i want to edit it to have the following:

1. The Currency Sign: Please can Nigerian Naira be included in the Options.

2. Can the Headings of the various items .e.g. Annual Insurance etc be edited and still function same.

3. I have been battling to set the calculator to have a default fixed minimum Down payment percentage, that requires just the input for Number of monthly payment and Price of the Real estate.

4. Can i hide any heading of the calculator front-end but still seeing it at the back-end with the function still intact.

## Karl says:

First, thank you for considering my plugin.

I can add Nigerian currency (I’m surprised I missed it.) Please go to this page:

Currency and Date tests

and copy the results you see in the two lower right corner green boxes to a reply here. I’ll try to have support by March 1.

As to your other questions, I can’t go into details right not, but all the things are possible. The plugin includes ALL source code.

## LJ says:

I have tried a few tests, and it seems that if an extra payment occurs before the first periodic payment due date, the amortization schedule displays the extra payment dollar amount in the top summary of the schedule in the line that reads: “Period Payment:” instead of the actual periodic payment dollar amount. Please test for yourself to see if you find the same. (I can fill you in on what my other fields were if that ends up being necessary.)

## Karl says:

You’re right. Also, the first payment date is the extra payment date, and the top of the schedule shows the selected extra payment frequency.

I looked into fixing this, but the calculation gets a lot more complicated if the period between the loan date and the scheduled first payment date is either a long or short first period. (You can read about irregular first periods on this page.)

I may not support extra payments before the scheduled first payment date. Another option is to disable the long/short first-period settings when there’s an extra payment. I’ll have to see.

## LJ says:

It seems some changes were made since I last contacted you. Now the calculator won’t allow an extra payment date to be before the first scheduled periodic payment date…but in our case it must be shown this way and will be shown as such for the next 8 years just as it has been for the previous seven. And in thinking of others who may use this calculator, it is highly probable that people will make an extra payment before the initial payment is due if they can. (Particularly in cases like ours where the payments are due annually.) I had not brought up the errors to make things worse. Yes, I could just reduce the total loan amount by the extra payment and consider that initial extra payment as part of the down payment, but it technically wasn’t part of the down payment. The extra payment occurred a few months after the down payment. I preferred the calculator the way it was before.

## Karl says:

Yes, you are correct about the change. I decided to not allow an extra payment prior to the first payment because the math for the interest calculation can get tricky when the first period has odd days. Also, I’m not sure the best way to present the results to the user.

Think bout this scenario. Monthly payments. Loan origination on July 15 and the first payment due on Sept. 1. This sets up a long initial period with 16 odd days. The lender might collect the interest for the initial 16 days at closing (prepaid interest) and the calculator allows for that option (setting: long period interest at origination).

If the borrower makes an extra payment on July 25, then the odd day interest calculation is wrong. But it’s already been paid. Is a refund due? Technically yes. Should that be reflected in the schedule? That’s my dilemma.

Rather than show an inaccurate interest amount, I restricted the feature. This seemed to be the best solution since the extra payment itself is not about a penny perfect calculation, but rather it’s about a hypothetical, and that’s particularly the case the farther along one gets in the schedule.

That said, if you want to calculate the impact of an extra payment prior to the first payment, you can use this calculator. If you try it, scroll down the page to the tutorials. This calculator works differently than any other calculator on this site.

## Bryan Baynes says:

I have been using your calculator for a while and everything was working fine, but just recently I am getting two boxes out of place on the screen about 1/2 way down on the page not near your calculator which is on the bottom right of the page. I can see the code when inspecting the element.

Not sure where to start. I don’t have this issue when using the auto loan calculator. Thanks for any help you can provide. B

## Karl says:

Hi Bryan, I’m sorry you are having a problem with the calculator. I took a look though, and I can’t see any problems. I checked using Chrome on a desktop. Can you tell me what you are using? The boxes that are out of place, are they the inputs that belong in the calculator? Or some of the other boxes on the page? If you are on a desktop, can you try a “hard refresh?” On Windows you would use a Ctrl-F5.

## Bryan psalc.com/mortgage_services says:

I have used the Chrome version of Edge and Internet explorer. Both show this issue. I have also tried it on a few different computers all with the same result. Address is in the name. It will not show up if the screen is too small, as I remove it unless the screen is large enough to view it. I tried to include the code that was causing it in this box, but when trying to submit it, I would receive an odd error on the page.

## Karl says:

I just figure out what you are talking about. I thought you were talking about the calculator on this page. But you have installed the FC Mortgage Calculator plugin on your site.

This is the better page for reporting problems with the mortgage calculator plugin.

In any event, I just looked at your page with Edge (current version) and I don’t see any problems.

## Pam says:

Karl,

What am I doing wrong. On the calculator, I cleared before I started, didn’t use commas or periods and put in all of the information I usually do on this same calculator, went to the second tab and put the date the mortgage began and first payment, went back and clicked calculate and print and I only got a one page print out of exactly what I put in but not the normal monthly amortization chart I have been getting for the last year. Can you think of something I left out. I love this chart. Thank you.

## Karl says:

I can’t think of anything. Can you save your inputs to a file and send me the file so that I can see what’s happening? Just click on the file-Save As… feature. The email address is on the contact page.

## Bonnie says:

Karl –

Thank you for your prior replies. Is there any way to convert the files from the xml format to a pdf?

## Karl says:

You’re welcome. I assume you want the payment schedule saved as a PDF? If so, if you are using either Chrome or Edge, they will both print to PDFs. From the print preview window that opens, click on the Print button and where you get to select your printer, click on it and PDF will be one of the options.

Does this meet your needs?

FYI, the XML contains your settings. YOu can drag and drop it to the web page to the area just below the calculator and the calculator will have the saved values with all options.

## Bonnie says:

Karl –

How can you have higher principal payments and negative interest payments so that the initial payment equals out? I believe it’s in the short period/long period interest options but I can’t get it to work out where the principal should at least be the last payment and the interest due zero. Ugh!

## Karl says:

Sorry, but I’m not following you. The specifics are important. Are you using the calculator on this web page? Please save your inputs to an XML file and email it to the address on the contact page.

## Karl says:

Thank you for sending your inputs. Are you asking why the balance goes negative? That’s because the principal and interest payment of 439.18 is higher than what is needed to pay the loan off in 144 periods. You can do one of two things:

Since there is no down payment, set the

Price of Real Estate or Assetto 0.0.and then set either the

Number of PaymentsorPayment Amount (P & I only)to 0 to calculate. If I do that for the term, I get a new term of 112 payments. Since the term can’t be a fractional period, you might want to avoid the larger final payment and say that the term is 113 payments.## Karl says:

You had asked about the negative interest amounts. Negative interest happens when the balance goes below 0. The borrower will not owe interest on a negative balance. In theory, the original lender would owe the original borrower interest. Thus the negative interest.

The point is, this calculator will use the inputs a user enters to generate the amortization schedule. For your example, either the payment amount is too large, or the term is too long. One or both need to be adjusted. If the payment amount can’t or should not be changed, then I would suggest solving for the number of payments.

## Walter Rosenblum says:

Love your loan calculator. I have a client that has taken on a lot of debt while attempting to start his business. Your amortization schedules are great and the program is fun and easy. Question, how do you handle a balloon payment at the end of the loan?

## Karl says:

I’m happy to hear that you are finding the calculator useful.

There are several options for a balloon loan. The easiest way is to just enter the balloon term and the regular monthly payment that has been agreed upon. For example, calculate the payment based on say 360 months, then set the number of payments to the term of the balloon, say 60 payments, and then view the amortization schedule.

Does this help? If not let me know what’s not quite right and I’m sure we can resolve it.

## Tony says:

Very detailed and helpful calculators! I would love to see an option for an XLS download. I cannot get Excel or Sheets to open XML files, even using the XML import function. (I’m not an advanced Excel user, so I’m sure this is why, but an XLS option would be super helpful).

## Karl says:

Thank you. I’ve looked at adding .XLS support, but the amount of code that I would have to add causes the calculator to load slower. Also, it’s not clear to me what folks would expect if this calculator did save to .XLS. Would they expect just the data? Should it be formatted with fancy formatting? Or just columns and rows of data? Do they expect the calculations to continue working? Lots of questions.

## Tony says:

Thanks for the reply. In my case, it would just be helpful to have the data presented in a readable format, so just columns and rows. I would not need the calculations to function or any special formatting, just an organized format in rows and columns so that I could then format the data as needed. Even CSV or another format that would be able to import easily into Excel so that the data is readable. Thanks again for all of your work on these calculators! Very impressive.

## Karl says:

You’re welcome. I may have a basic XLS export added in the future. But there are other features ahead of that. Perhaps for 2022?

## Alan Taylor says:

No matter what I do, I can’t open an XML file. Why won’t this just save to Excel?

## Karl says:

I’m using Excel 2010 (yes, old I know, but I doubt if Excel has eliminated the feature).

I click on "File" and then "Open." To the right of "File name", I’m given the opportunity to pick file type. One of the types is "XML file (*.xml)."

Did you try making that selection, and then picking the file you saved from the calculator?

The XML file contains your inputs, and not the schedule. If you want the schedule in Excel, do a copy/paste. You’ll probably need to use Excel’s "Paste special" feature, and do a paste as text.

## Eddie says:

I need to make multiple unscheduled and unknown frequency principal reduction payments to the original amortization schedule. Explained another way: The original loan amount can be reduced if borrower chooses to make individual and unscheduled principal reduction payments. When those occur, I need to rerun the amortization schedule showing past “xtra pmts” made and the current “xtra pmt”. Those payments reducing the term of the loan. Payment amount is constant. I am only able to accomplish one “xtra pmt” presently. Possibly I am overlooking a feature you have already built into the schedule. By the way this is an excellent tool and has helped me on several occasions. Thank you.

## Karl says:

I’m happy to hear that you’ve found this calculator useful.

For what you want to do, you’ll need to use this loan payment tracking calculator. It should have all the flexibility that you need.