advertisement

Spend a few minutes with this calculator, and you'll see that it offers a lot more than other monthly mortgage calculators.

The Ultimate Mortgage Calculator (UMC) makes it easy to calculate mortgage payments, of course.

Go beyond that, and you can do rent vs. buy analysis and answer other questions, such as "how do I save on a mortgage?" In addition to creating a printable amortization schedule, it also crunches the numbers and calculates an annualized return-on-investment (inflation-adjusted or not). If the ROI is positive, you may have found both the right home and a reasonable or even excellent investment. If it's negative, the house may be great, but the investment potential is undoubtedly lacking.

Can't decide between two perspective mortgages and two properties?

While the annual percentage rate (APR), is what you should use to compare two loans, the ROI is what allows you to compare two loans and two properties. That is, the return-on-investment considers costs beyond the mortgage.

For example, want to factor in maintenance costs into your calculations?

Great! This calculator can do that.

Of course, everyone's situation is different, so the calculator allows you to make over 30 different settings if you desire. Frankly, I cannot think of a mortgage scenario that it cannot handle.

But don't let the number of options put you off.

I'll walk you through all the details, step-by-step. Just scroll down below the calculator.

And don't worry if you don't understand everything in one go at trying out the calculator. You can ask your questions at the bottom of this page, and I'll be happy to answer them.

As the Pew Research Center says, "A home is one of the most commonly owned assets, and home equity is the single largest contributor to household wealth."

Next, how to quickly calculate a mortgage payment. More below

×

Info...

  Original Size  

Click, copy, paste this URL to save the inputs for yourself or to share with others.

This custom URL updates when you click the "Calc", "Clear" or "Schedule" buttons. Paste it into a browser's address bar to reload.

First, What is a Mortgage?

A mortgage is a loan secured by real estate.

What does that mean?

Very broadly speaking there are two types of lending.

  • A lender will lend money to you based on your reputation for paying back loans (or because they love you). For example, a credit card company will lend to you based on your credit history. If you fail to pay, the lender does not have the right to seize assets. If the lender cannot repossess assets, it is known as unsecured lending.
  • The second type of lending involves loans that are backed by an asset. That is, if the debtor fails to pay as promised, the lender can seize the asset (or assets) that the loan document specifies. Such a loan is called a secured loan. A mortgage is a secured loan because the mortgage holder can take the real estate if the borrower defaults, that is, they fail to pay.

The Mortgage Payment Calculation

advertisement

Don't let the number of details put you off. Fortunately, if you only want to calculate a payment amount, you'll frequently have to enter only three values. You can leave the other settings and inputs unchanged.

A payment amount calculation is as easy as this:

required inputs
Just three inputs needed to calculate a monthly payment amount.
  1. Click clear and enter values for:
    • Loan Amount: $295,000
    • Number of Payments: 360 (30-year mortgage, default monthly)
    • Annual Interest Rate: 4.5%
  2. Leave "Payment Amount (P & I only)" set to 0.
  3. Click either "Calc" or "Pmt & Cost Schedules"

$1,494.72 is the monthly principal and interest payment amount.

At this point, if you are following along, you may have noticed that the ROI is -4.6%. Yikes!

Don't worry! It most likely isn't. Here's why. See the "Appreciated value?" Notice it's the same as the purchase price. In other words, the calculator thinks you'll be selling the property at the price you paid, 30 years earlier.

Not likely. We'll get to how to change that below, but first, let's take a look at some variations for the payment calculation.

VERY IMPORTANT - You must enter a 0 if you want a value calculated. Some users have been frustrated by this. They want to know why the calculator does not simply recalculate if they have changed one of the inputs.

This behavior is by design. We want the calculator to create an amortization schedule using whatever parameters you want to use. This is a feature!

By not automatically recalculating a payment, this calculator lets those users who do not have a "standard" loan create a payment schedule.

ABOUT DATES - This calculator now allows for an irregular length first period. That is, you can set the loan date (sometimes referred to as the origination date or start date) and the first payment due date. The calculator can then calculate the exact amount of interest due even when the initial period is shorter or longer than the other scheduled periods.

However, this will result in payment amounts as well as 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 the time between them equals 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 the standard interest calculation.

Of course, you can always leave the dates set as they are when the calculator loads.

Anyway, that's it. Now you know the principal and interest payment required to pay off the mortgage debt. Below are variations on the above calculation, which will help you get answers to other commonly asked questions about mortgages.

4 Variations on the Mortgage Payment Calculation

Variation A — Solve for loan amount and loan payment

The home costs $368,750. How much will I need to borrow? What will my payment be?

setup to calculate a loan amount
A setup for calculating loan amount and monthly payment from the purchase price.
  1. Click clear and enter values for:
    • Price of Real Estate or Asset: $368,750
    • Down Payment Percent: 20%
    • Number of Payments: 360 (30-year mortgage, default monthly)
    • Annual Interest Rate: 4.5%
  2. Leave Loan Amount set to "0", an unknown
  3. Leave Payment Amount (P & I only) set to "0"
  4. Click "Calc"

You'll need to borrow $295,000, and again, the monthly payment will be $1,494.72. Also, notice you'll need to have $73,750 available for the down payment.

Variation B — Solve for the purchase price and loan payment

I want the mortgage amount to be no more than $250,000. I want my down payment to be 20% of the purchase price. What price can I afford to pay for the real estate? What will be my monthly payment? What down payment amount will be required?

Purchase price and mortgage payment
A setup for calculating purchase price and monthly payment with a 20% down payment
  1. Click clear and enter values for:
    • Down Payment Percent: 20%
    • Loan Amount: $250,000
    • Number of Payments: 360 (30-year mortgage, default monthly)
    • Annual Interest Rate: 4.5%
  2. Leave Price of Real Estate or Asset set to "0"
  3. Leave Payment Amount (P & I only) set to "0"

Click "Calc."

You can pay up to $312,500. The down payment required is $62,500, and the principal and interest portion of your 30-year monthly mortgage payment will be $1,266.71

Variation C — Budget mortgage from an affordable payment

You don't want your monthly base mortgage payment (P&I) to exceed $1,300. And you want to put down $40,000. How much can I borrow? What can I afford to pay for the house?

Purchase price and mortgage amount
A setup for calculating purchase price and mortgage amount from the desired monthly payment.
  1. Click clear and enter values for:
    • Down Payment Amount: $40,000
    • Number of Payments: 360 (30-year mortgage, default monthly)
    • Annual Interest Rate: 4.5%
    • Payment Amount (P & I only) set to $1,300
  2. Leave Price of Real Estate or Asset set to "0"
  3. Loan Amount: set to "0"
  4. Click "Calc"

The loan amount can be up to $256,569, and you can buy a property priced at $296,569. However, note that your $40,000 down payment is only 13.5% of the purchase price, which may not be enough to qualify for the loan amount.

The lender, therefore, may require you to do one of 2 things:

  • purchase a less expensive property; or
  • increase the down payment to bring it to 20% of the purchase price

Variation D - Mortgage with a balloon payment

advertisement

Perhaps you'll recognize this setup from the first example. Frequently, a balloon loan calculates the periodic regular payment amount on a longer-term and then set the period when the balloon is due. That's how this calculator works.

Setup for a balloon mortgage
A setup for a mortgage with a final balloon payment.
  1. Click clear and enter values for:
    • Loan Amount: $295,000
    • Number of Payments: 360 (30-year mortgage, default monthly)
    • Annual Interest Rate: 4.5%
  2. Leave "Payment Amount (P & I only)" set to 0.
  3. Click either "Calc" or "Pmt & Cost Schedules"
  4. Reset Number of Payments: 72 (the balloon payment due period)
  5. Click "Pmt & Cost Schedules" for the schedule showing balloon payment
Balloon amortization schedule for a mortgage
Mortgage schedule with a large final balloon payment

The UMC can do many more calculations, but the above scenarios should get you started. But, the debt payment does not begin to cover the full cost of a home loan. There are a few other expenses, of course! And this calculator is designed to consider them as well.

There's More to a Mortgage Than the Loan Payment Amount

advertisement

Besides creating a printable mortgage schedule showing date due, payment amount, interest paid, principal, and balance, it has support for the following expenses as well:

  • PMI — private mortgage insurance. Could be required if your loan to value (LTV) is more than 80%. That is, your down payment frequently needs to be 20% or more to avoid PMI.
  • Property Taxes — are included in the escrow column on the schedule. Please be sure to enter an annual amount in the calculator.
  • Property Casualty Insurance — is also included in the escrow column on the mortgage schedule. Again, enter an annual amount.
  • Tax Benefits — shows tax savings as a result of a potential deduction for mortgage interest and property taxes.
  • Points — calculated using the loan amount, they are reported in the first row of the schedule.

All of the above are optional. So you may set them to 0.

Note: The Ultimate Mortgage Calculator automatically selects from three amortization schedule layouts. If you've not entered values for any of the above options, then the UMC displays a simplified schedule showing only the payment along with the principal interest and loan balance.

But there is even more!

The optional, new "Inflation-Adjusted Cost and Appreciation Schedule" tracks mortgage costs and other costs such as maintenance and optionally adjusts them to account for projected inflation.

Cost and Appreciation Schedule
The New Cost and Appreciation Schedule

Alright, now that I have an idea of what I can afford and how much my loan payment should be, how do I compare lenders?

The Annual Percentage Rate — APR

In the US, the APR is one of the few numbers, when it comes to lending, that is regulated by the Federal Government (see Truth-in-Lending Act TILA). Some people may think that the government would regulate payment amounts. But that is not the case. A lender may usually stipulate any payment amount they wish, and that's fine if the borrower agrees to it.

But the APR is different. The APR is not an interest rate. The APR is a rate-of-return, and the TILA clearly states how to calculate it (but not maximums or minimums values). The Consumer Financial Protection Bureau (previously the US Fed) is responsible for oversight under the TILA.

The APR is a good thing for the consumer. Since the TILA was passed in 1968, forcing the adoption of a consistent APR calculation, it has become easier for borrowers to compare different loan offers on equal a footing. Before lenders had to disclose the APR, the borrower was left comparing mortgage interest rates, or payment amounts and then they had to factor in various fees.

Was a 5% mortgage interest rate and $2,000 in various closing costs and fees better than a 5.125% mortgage with lower closing costs?

Who knew? You had to either do the math by hand or risk selecting the higher-cost loan.

But lenders now have to be compliant with the TILA. Which means they have to calculate it the same way. (The Act goes on for pages!).

As useful as the APR is for comparing loans, there is a rub. The APR is a personal number. That is, the consumer cannot reliably compare lenders by comparing advertised APRs. The advertised APRs are just starting points.

Points, fees and other charges
Possible points, fees, PMI, and other charges impact your personal APR.

For one thing, the payment amount quoted will impact a loan's APR. But it's just not the payment amount, fees and other charges also affect the APR calculation. Required inspection reports, attorney's fees, and loan application fees all determine your APR. And to the extent, those fees will vary from lender to lender; the APR will also change.

Since you can't use advertised APRs, to compare loans effectively, you must either have each potential lender prepare what is known as an APR Disclosure Statement or, to expedite things, you can use a calculator that calculates the APR for a DIY comparison.

So how do you calculate an APR?

The Ultimate Mortgage Calculator will do the heavy lifting and calculate the APR for you. But you still need to understand what factors into the calculation. For the calculator to calculate an accurate APR, you'll need to provide the following information:

  • loan amount
  • payment amount (either enter the lender's quoted payment or calculate it)
  • the other loan details - amount, term and interest rate
  • points, if any
  • total of all fees and charges REQUIRED by the lender
  • PMI rate, if required
(I stress required charges because if you opt into a charge, say an enhanced septic tank inspection that the lender does not require, then that charge is not accounted for in the APR calculation.)
APR calculation
A Regulation Z Compliant APR Calculation.

There's another caveat the borrower should be aware of when comparing APRs. You do not necessarily want to take the loan with the lowest APR.

Why's that? When given a choice, why would I ever want to take out a loan with a higher APR?

Remember I said the APR is a "personal number?" If you are taking out a 30-year mortgage, the mathematics behind the APR assumes that you'll be paying off the loan for the entire 30 years. And the same for a 15-year mortgage. Or for any loan term.

But your circumstances will likely vary. For example, if you plan to sell the property before the loan's term is reached, then the calculated APR is not the actual APR. This is because you pay the fees and other charges up-front and over the shorter term, their impact on the APR is more significant.

Therefore, the higher the fees and the shorter the term, the higher the APR. So if you are considering paying points to reduce your interest rate and you see that doing so lowers the APR, below another lender's offer, that may only be the case if you stay in the home and pay the mortgage for its fully stated term. If not, the loan with the higher APR but lower fees may be the better deal.

Are There Tax Benefits to Having a Mortgage?

In the US, Uncle Sam helps homeowners by giving them a tax break on primary residences. The UMC shows the benefit in dollar terms (amount saved on taxes) on the amortization schedule if you provide your marginal tax rate.

Possible income tax benefits
Possible income tax benefits to having a mortgage (see text!).

Calculating the benefit use to be straight forward until The Tax Cuts and Jobs Act (TCJA) [as explained by the TaxFoundation.org] became law in 2017. It's not anymore. And accordingly, it is possible that the calculator OVERSTATES the tax benefit to you. That will be the case if either of these is true:

  • If you do not itemize deductions on your tax return, then there is no tax benefit to having a mortgage. Do not enter a marginal tax rate. (The tax law change increased the standard deduction as of tax-year 2018, and the IRS expects fewer people to itemize their return.)
  • As of 2018, there are caps on the mortgage interest deduction and property tax deduction. So if you see that either of the costs exceeds the caps, then your tax benefit is being overstated. (That is, the calculator does not know about the caps, mainly because it would also need to know your state income tax liability if there is any.

For those interested, here are the caps, per Bill Bischoff, writing at MarketWatch:

  • "the TCJA changes the deal by limiting itemized deductions for personal state and local property taxes and personal state and local income taxes (or sales taxes if you choose that option) to a combined total of only $10,000 ($5,000 if you use married filing separate status)."
  • "For 2018-2025, the TCJA generally allows you to deduct interest on up to $750,000 of mortgage debt incurred to buy or improve a first or second residence (so-called home acquisition debt)"
  • For those who use married filing separate status, the home acquisition debt limit is $375,000.

I've left the tax benefit calculation option in for those that will benefit from Uncle Sam's generosity and understand the above.

Do your followers a favor and retweet.

Is Buying a House a Good Investment?

As I said at the top of the page, in general, yes, I think it is.

Take a look at the gain in home prices over various periods for the past 66 years as measured by the Case-Shiller Home Price Index (CSHPI).

Case-Shiller Nominal Home Price Index - Not Seasonally Adjusted
Start End Years Annualized Gross Return
1952 2018 66 +4.4% +1,343.3%
1988 2018 30 4.0% 180.8%
2003 2018 15 3.0% 47.4%
2008 2018 10 4.8% 34.9%
2013 2018 5 5.4% 29.2%
Gains calculated from ONLINE DATA ROBERT SHILLER US Home Prices 1890-Present

If you are looking at these gains and saying to yourself, well, it's obvious that buying a home is a good investment and if necessary, taking out a mortgage is the thing to do. If you're thinking that, then I have to say hold on a minute. Home appreciation is only one of the considerations. We need to look at several other things as well before we can answer the question.

Here is where we need to briefly pause to explain how we are going to know if a mortgage a good investment. That is, what number will tell us this?

If you understand what ROI is, then feel free to skip to How Do I Calculate the ROI?

The Key Number to Understand: ROI

Background

The key is to understand what a return-on-investment calculation is and how it's useful. Return-on-Investment (or ROI) sometimes also called rate-of-return (ROR) or internal rate of return (IRR) tells us what the gain (or loss) is on an investment expressed as an annualized percentage.

If you invest $1,000 and sell the investment a year later for $1,500, your ROI is 50%.

The keyword in the definition is "annualized." Using the same example as above, but this time, you sell the investment after two years, the gain is still 50%, but the annualized return will no longer be 50% because it took two years to make the $500 profit. (The ROI will be approximately 22% - See ROI Calculator.)

cost summary header
New cost summary header showing gain/loss calculation and return-on-investment.

Further, if you invest $1,000 and sell $750 one year later and sell a final $750 at the end of the second year, the total gross return is still 50%, but the ROI will be higher. (It will be nearly 32% - see the IRR Calculator). This is because you received a return on your investment before the end of the 2-year term, and an investment return earlier in the cash flow improves the ROI (a bird-in-hand as such).

The point is the ROI levels the playing field. In the above example, we always have a $500 profit for a 50% gross return. If you were to only look at the gain, you might think there's no difference in the investment. But that's not the case, and the ROI tells us that.

The ROI also gives you the tool to compare 15-year mortgages with 30-year mortgages, or any term you like for that matter.

For the above reason, the UMC calculates an ROI so you can answer if a house is a good investment for you. Generally speaking, if the ROI is negative, you should perhaps consider renting as an alternative to purchasing a home. On the other hand, if it's positive, then the projection is, you'll earn a profit on the purchase.

How Do I Calculate the ROI?

This mortgage finance calculator, of course, does the math. We need to make a few decisions, however.

  • First, expenses, of course, impact the profitability of an investment. Housing is no different. We need to decide what costs we want to include in the calculation? Are we only concern with the direct mortgage expenses, such as down payment, periodic payments, points, etcetera? Or do we want a broader analysis that includes, estimated maintenance, insurance, and property taxes?
  • Secondly, do we want an inflation-adjusted analysis? Over the term of a 15-year or 30-year mortgage, inflation can have quite an impacted. Or do we want an unadjusted ROI?

The UMC is very flexible, and it allows users to answer these questions in a way that meets their needs. However, reasonable defaults are preloaded into the calculator when you first land on this page (I go into detail how I selected each default below) and we'll use those for this analysis.

For our illustration, we are going to use the CSHPI to estimate the future selling price of the home. Since we use a 30-year mortgage to base our example on, we'll assume our house will increase in values at a rate of 4% per year.

For general cost inflation (maintenance, property taxes, etc.), the UMC allows you to enter a different inflation number. Per the Federal Reserve Bank of St. Louis "...the FOMC [Federal Open Market Committee] adopted an explicit inflation target of 2 percent in January 2012." While inflation has been running a bit under that, we'll use 2% for this example's cost inflator.

Now, as to the costs, let's look at where I got the numbers used in this example. (I suggest you refresh the page to reload the calculator with the numbers we are using. After you understand the analysis, you can get your numbers together. Then the results will be more meaningful to you.)

  1. Loan Amount: According to the Consumer Financial Protection Bureau, the average size new mortgage balance as of 2017 was $260,386. (Assuming a 20% cash down payment, the calculator will calculate Price of Real Estate.
  2. Annual Interest Rate: As of February 2019, the average interest rate for a 30-year fixed mortgage was 4.35%, per Freddie Mac as retrieved from FRED, Federal Reserve Bank of St. Louis; March 2, 2019.

Youll find the following inputs on the Options tab:

  1. Annual Property Taxes: Property taxes in most states contribute a significant amount to the overall cost of owning a home, and the UMC accounts for them. I calculated the average property tax rate of 0.98 from the Median Property Tax Rates By State data found at tax-rates.org. Using 0.98% on the average selling price, we get an average property tax bill of $3,190.00. (Of course, if you don't know the actual property tax yet, you can find your state's rate here.)

There are two additional expenses, and for these numbers, I'm winging it:

  1. Annual Maintenance $3,000
  2. Yearly Property and Casualty Insurance premium $800.

One expense the calculator does not directly support is homeowners association fees (HOA fee). If you need to account for those, calculate the current annual amount and add that amount to the yearly maintenance expense. The ROI calculation will be correct.

Given the above details, what's the ROI?

1.6% ROI
1.6% Return-on-Investment (ROI)

Hmm, that's not so good. True, it's probably better than the annual return you would have earned from a savings account for the past ten years, but you must be wondering why I say, in general, buying a house is a good investment?

That's because this analysis is not complete — 1.6% is just an intermediate result. After all, you have to live somewhere, right?

Buy vs. Rent

If your alternative to buying is renting, then your estimated rent needs to be an offsetting cost in your calculation.

What do I mean? Why is this?

Look at it this way, what's your ROI on rent? Nothing, of course. In fact, it is worse than nothing. The money is out the door, never to be seen again. Therefore, you should say the ROI is -100%. But that's silly. No one thinks of ROI when it comes to renting.

But to make the comparison between renting and buying meaningful, we need to zero out the 100% rent loss. To do this, the UMC will adjust the total cost of home ownership by what you are willing to spend on rent (the analysis looks at rent or cost-of-housing as a fixed cost). If you are willing to pay $20,000 a year for rent, then the calculator's analysis will look at the difference in costs and calculate the ROI.

In other words, the UMC will calculate an ROI for the marginal dollars you'll spend owning a home over renting. You should do this because it's only the dollars after the cost-of-housing that you'll have available to invest if you decide home ownership is not for you.

Alright, so how will considering rent in the analysis impact the results?

Well, let's see.

According to RENTCafe.com, the average rent in the US as of June 2018 for three bedrooms is $1,714 a month. If we enter that into Monthly Rent and recalculate, the ROI is now:

10.1% ROI
10.1% return-on-investment (ROI) after allowing for cost-of-housing.

Quite a difference, wouldn't you say! And also, I think, a more realistic result. Because it's telling us that if we take out an average mortgage at a nationwide average interest rate and pay average costs, we'll make a return on our INVESTABLE dollars of 10.1%.

A 10.1% return is better than the S&P has done over the last 30 years, which was 5.9% without accounting for dividend reinvestment.

Still not sure about buying?

Then take a look at this pie chart the calculator creates:

Total inflation-adjusted costs
Final house value and total inflation-adjusted costs.

Regardless of what ROI you earn, when the 30 years are over if the projections hold up, and after you have paid all the mortgage payments along with the taxes, insurance, and maintenance, you'll have an asset that you can sell for approximately $1,055,000.

How much of the rent money will you get back?

Not only do you get back the investment gain on your marginal dollars spent, but you also recover your housing costs from the past 30 years!

Plus, there are at least two other financial benefits to buying a house that doesn't show up in the totals:

  • Taking out a 15-year or 30-year fixed rate mortgage locks you into a fixed payment amount for a very significant portion of your housing cost. You can't say that about renting.
  • Once the mortgage is paid off, your housing costs going forward will drop significantly. Of course, that will never happen if you decide to continue renting.
rent vs. buy analysis
Rent vs. Buy: showing a fixed 30-year mortgage payment vs. increasing rent.

A few words of caution.

  • All real estate is local. Some areas tend to appreciate well above the national average, and some will, of course, fall below the average. It is up to you to buy right and to make the right assumptions.
  • The results of this analysis could quickly change if interest rates rise. Interest is a significant cost component of the mortgage. Make sure you do your own analysis.
  • The results will also change (perhaps significantly) if you do not stay in the house for the full term of the mortgage. Want to see by how much the ROI will change? First, prepare a full term analysis of your mortgage, and then do it again by changing the "Number of Payments" to the length of time you expect to own the home. That is, if you are going to be in the home for eight years, change the "Number of Payments" to 96 and leave everything else the same. Then recalculate the ROI using the shorter term.

Finally, the point is not to agree or disagree with the numbers I'm using. The point is to give you a tool and the background so that you can do your own analysis. The Ultimate Mortgage Calculator is flexible enough that you should be able to study the home buying transaction any way that makes you comfortable to answer the question, "is buying a house a good investment?"

Ok, I'm leaning toward buying a home. Is there any way I can save some money and improve the ROI even more?

Yes, there is.

You might want to consider making extra payments to reduce interest charges or the mortgage saving tips that follow.

Mortgage Calculator with Extra Payments and Lump Sum

I assume that most borrowers know that if they pay an additional amount on their mortgage (or any loan) above the required payment that they'll save money. (Check the terms of your loan to make sure there is no prepayment penalty.)

How does paying extra on your mortgage work? That is, why does it save you money?

The answer is rather simple actually. When you make a payment on a traditional mortgage, interest is calculated using the current balance for the number of days since the last payment. The calculation adds the interest to the loan balance and then deducts the total payment amount.

If you pay an additional $200, for example, 100% of the $200 is used to reduce the principal balance (or at least it should be if the lender's math is correct) and then next time interest is calculated on the balance that is lower by $200 than it would otherwise be.

And the lower the balance, the lower the calculated interest.

The crucial thing to understand is, while an extra $200 may not seem like much in terms of say a $250,000 balance, but that single $200, has reduced the balance of the loan from its payment date until the loan is paid-in-full. The interest saving is on every future payment. And if you continue to make the extra payment, their impact is compounded.

You'll be able to save quite a bit of money! And that has got to be a good thing, right?

Well, let's see how good.

lump-sum extra payment
A setup for a $10,000 lump-sum extra payment on an odd payment date.

What is the effect of paying extra principal on a mortgage?

Assume you receive a year-end bonus and you are considering making a single lump-sum payment toward the mortgage balance of $10,000. What will be the interest savings?

mortgage summary with extra payment
Check the mortgage interest calculator's schedule to see your interest savings.

If you assume this calculator's default values, the one-time $10,000 additional payment will save you more than $23,000 in future interest charges.

Is it a good idea to make extra mortgage payments?

There's an ongoing debate among financial professionals and even mortgage holders at large whether or not it's a good idea to prepay a mortgage. The thinking is, you could use the money that is being used to make additional loan payments and invest the money instead. Some say, investing the money will create more wealth than it saves in interest charges.

I'm not here to give financial advice, and the Ultimate Mortgage Calculator can't help you with an answer. What it will do is calculate the interest you'll save if you choose to make extra payments.

expanded extra payment schedule
The Ultimate Mortgage Calculator's expanded payment schedule showing an odd-day lump-sum payment.
Make sure your lender applies 100% of the additional payment to principal.

What it will do that this calculator won't do is prepare a comparative financial schedule that calculates both what the interest savings will be as well as the projected future value if you invested the money instead.

You definitely should look at this calculator if you are making or planning to make extra principal payments.

What if you're not convinced that you should make additional mortgage payments. Are there any other techniques you can use to reduce your costs?

Yes, there are.

Two Additional Tips for Saving Money on Your Mortgage

Mortgage payments are generally a significant portion of any family's monthly budget. Typically the mortgage loan consumes 25% or more of the monthly income. Hopefully, most consumers know if they make extra payments or agree to bi-weekly payments, they can save a small boatload of interest over the term of their loan. These strategies are certainly useful, and they will save you money. You should consider them depending on your other investment options.

But what if you don't have the free cash flow to make extra payments? Are there money-saving strategies that don't require sacrifice?

Well, yes, in fact, there are. Read on for two such ideas for you. Naturally, you'll want to plug your numbers into the calculator to see what you can save.

TIP 1: Don't Assume Making a Higher Down Payment Saves Money

Usually, one would think that the greater the down payment amount, the less the amount borrowed. The lower loan amount means a lower accumulated interest charge over the term of the loan. That's what one would think, and usually, that would be correct. But at least in the US, mortgage borrowers have another option.

Borrowers can pay points. Points are nothing more than an up-front fee charged by lenders in exchange for a lower interest rate. The lender will calculate the amount owed for points as a percentage of the total loan. On a $300,000 loan, 2.5 points equals $7,500.

So you're thinking, I understand what points are. And I do plan to be in this house for a dozen years or more. It also sounds good to pay something up front in exchange for a lower interest rate, but what if I don't have the available cash to pay points? Am I out of luck?

Maybe not.

chart showing mortgage points
Mortgage chart showing an initial "bump" in annual payment due to paying mortgage points.

You can swap down payment for points.

How much cash do you have for a down payment? Twenty percent or more?

If that's the case, it may save you money if you give the lender less for a down payment and use that money to pay a couple of points. Let's look at an example.

In the calculator, enter the following values:

  1. Price of Real Estate or Asset?: $375,000.00
  2. Down Payment Percent?: 22%
  3. Loan Amount?: $0
  4. Number of Payments? (#): 360
  5. Annual Interest Rate?: 4.1250%
  6. Payment Amount?: $0
  7. Points?: 0

Since we are comparing mortgage strategies only, make sure "Annual Property Taxes," "Annual Insurance" and "Private Mortgage Ins. (PMI)" are all set to "0".

The calculator is going to calculate both the mortgage loan amount and the monthly payment since you have entered zeros for those inputs.

total interest
Total interest with a 22% down payment.

The significant number, however, is total interest. Checking at the bottom of the calculator, just above the buttons, you'll see for our example loan that you would pay $217,836 in interest over the term of the loan. Make a note of this number. You'll need it for the next step.

There is one more calculation. Change the following inputs (the others are left as they are):

  1. Down Payment Percent?: 20%
  2. Mortgage Amount?: $0 (Reset for new calculation)
  3. Annual Interest Rate?: 3.8750%
  4. Payment Amount?: $0 (Reset for new calculation)
  5. Points?: 2.00 (Under the "Options" tab.)
total interest
Pay points upfront to save $4,000 (total interest includes points).

What we have done is to reduce the down payment amount by 2% and added 2 points. When you add points, you are buying a lower interest rate. In this (conservative) example, adding 2 points lowers the fixed interest rate by 1/4 of a percent over the entire term of the loan. You may find in your area that you can reduce your rate more -- maybe by 0.333% or even 0.4%.

We are now ready to calculate the new mortgage details. This time, since there are more details on the schedule, click "Pmt & Cost Schedule" (It is not necessary to click "Calc" first.)

There are two totals in the summary section of the schedule we need to know:

  • Points Amount: $6,000
  • Total Interest & Points Paid: $213,856

Compare this to the total interest from the first calculation when the down payment was higher, and there were no points — $217,836.

The mortgage with the two points and 20% down, will save you $3,970 over the one with 22% down.

Not only will you save nearly $4,000, but there's also icing on the cake (and it's calorie-free!). The savings come to you without you having to make any sacrifices. You do not have to go through anything other than the typical mortgage approval process. You do not have to submit a different application or do additional paperwork. And you do not have to have any extra money upfront.

The cool part is, if you look at your payment amount, you see it will decrease from $1417 to $1410! Woopie!

There's even more.

If you are in the US and you itemize deductions when you pay income taxes, points are often a deductible cost for obtaining a mortgage. This means Uncle Sam (and other American taxpayers) is helping you out by lowering your tax bill. If you are in the 33% marginal tax bracket, $4,000 paid as mortgage points could save you $1,320 in taxes in the year you file after taking out the mortgage. (Please see the section on this page "Tax Impact" to understand the possible limits.)

This is a win, win, win, win.

  • Lower total mortgage cost
  • Lower monthly payments
  • No change to the mortgage process itself
  • And a front-loaded possible tax deduction

A word of caution is in order here. You'll only want to employ the second strategy if you plan to stay in your home for a relatively extended period. If you expect to move in say 5 or even ten years, you may not save enough in interest charges to make up for the points. Use the payment schedule to find your break-even point.

I should also note one point that some may consider being a disadvantage. You'll have slightly less equity in your home in the early years of the mortgage. The reduced equity is because you've traded points in place of making a more significant down payment.

Let me know in the comments what you think of this tip. Will you consider using it?

I think my next tip is even better...

TIP 2: Make Payments at "Start-of-Period" to Save

Lenders hate this. (Hint, it has to do with their ROI.)

But if you are the borrower, you should love it.

When applying for a mortgage, lenders ask for a lot of documentation. Bank statements are one item you'll be requested to provide. They will be looking at your cash flow to see if you have two or even more payments available beyond the down payment amount you have agreed to in the purchase contract.

All well and good.

Since the lender wants you to have a payment or two already in the bank, give it to them as early as possible. Often, the initial loan installment is not due until the first-of-the-month after the month following the closing. (Close on March 20th, and the payment is due on May 1st.) Instead of waiting though, hand the lender a check for the first payment on the day you sign the mortgage papers.

Why would I want to do that?

set first payment date
Make your first payment on the day the loan originates to save thousands.

Here's why.

In the calculator, enter the following values:

  1. Price of Real Estate or Asset?: $350,000.00
  2. Down Payment Percent?: 20%
  3. Mortgage Amount?: 0
  4. Number of Payments? (#): 360
  5. Annual Interest Rate?: 4.1250%
  6. Payment Amount?: $1,417.60
  7. Points?: 0.00%
  8. Payment Frequency?: Monthly
  9. Set the Loan Date and First Payment Due, so they are one month apart
  10. Once again, since we are comparing only mortgage strategies, enter "0" for "Annual Property Taxes," "Annual Insurance," and "Private Mortgage Ins. (PMI)".

The calculator will solve for both the mortgage loan amount and the monthly payment since you've entered zeros for those inputs.

Click "Payment & Cost Schedules"

Make a note. Total interest due is $208,527, and the first payment is paid one month after the loan date. We call this an "end-of-period" schedule.

Now for the comparison calculation.

Change the following inputs (the others are left as they are):

  1. Mortgage Amount?: $0 (Reset for new calculation)
  2. Number of Payments? (#): 0 (Reset for new calculation)
  3. Set the Loan Date and First Payment Due to the same date

These changes set the calculator to calculate the loan term.

Again, click "Payment & Cost Schedules."

Notice how the first payment now falls on the closing date of the loan? Also, notice for the first installment, there is NO INTEREST DUE. Why? Because no days have passed! Interest is charged/collected only for days when the money is on loan.

Now total interest due is $205,236.

How much interest will you save?

By making this one simple change to the payment schedule, you will save $3,291 in interest charges over the term of the loan. Furthermore, you'll have to make only 258 payments, not 360, and the last payment will be due on February 1, 2047, not May 1, 2047.

Like the first tip, this tip does not require you to make any fundamental change to what you were already planning to do. You don't even have to tell your lender that you are going to do this. Just hand them the check on the day you close the loan.

If you decide to use this money-saving strategy, understand the payment you provide your lender at closing is only the mortgage payment. You do not have to give them any escrow amount they might be collecting with later payments. Escrow is something separate. An escrow amount typically is added to the regular mortgage payment, and it is used to cover property taxes and insurance. Again, you pay them only the mortgage part of your total amount at the closing.

Also, it is a good idea to closely monitor your new mortgage account and confirm that this first payment is applied 100% to the principal. If it's not, then you won't get the full benefit of this technique.

chart with extra payments
Accumulated mortgage chart showing a series of extra payments.

What About Adjustable Rate Mortgages or ARMs?

In the US, at least, adjustable-rate mortgages (ARM) have fallen out of favor with borrowers. In the current low-interest-rate environment, it does not make much sense for someone to take out a mortgage that has an interest rate that is more likely to increase than decrease.

The UMC does not officially support ARMs.

However, if you need to create an amortization schedule for an ARM, I'm not going to leave you high and dry. Please see the Ajustable Rate Mortgage calculator. It is easily capable of creating an amortization schedule with adjustable rates. You can adjust the interest rate as of any date, not just on payment due dates. There is even an adjustable-rate mortgage tutorial that will show you step-by-step how to create an ARM schedule.

Wrapping-Up

My desire is, you will use the Ultimate Mortgage Calculator to give you insights into mortgages and how they work. Hopefully, those insights will save you some significant money.

advertisement

53 Comments on “Mortgage Calculator”

financial online calculator Join the conversation. Tell me what you think.
  • Travis Harrell says:

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

  • 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?

    • 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 loan payoff 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.

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

  • Alma Gutierrez says:

    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 Ultimate Financial Calculator.

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

      • Alma Gutierrez says:

        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.

          • Alma Gutierrez says:

            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?

  • Alma Gutierrez says:

    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.

  • 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.
    Brilliant!
    Thank you,
    Gail Hunt

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

    • Are you saying this interest only calculator doesn’t work, or another calculator? If so, in what way? Can you give me an example? For me, it solves for either the payment amount or loan amount and it creates a payment schedule with 100% of the payment covering the interest and no principal. Thanks for your time.

  • Hi There,

    I installed your plugin here http://emg2017.flywheelsites.com/resources/calculators/ using one of your example shortcodes but the calculator does not display properly.

    There is no text next to the fields to show what should be entered in each field.

    Any ideas as to why?

    Thanks!

    • Hello, I took a look at the page. Did someone make custom modifications to the calculator? It not just that you can’t see the text, the layout is all messed up as well.

      I took a look at the text issue. Here is the code for the first label:

      <label class=”control-label” for=”edPrice”><span class=”text”><span class=”text-inner”>Real Estate Price?:</span></span></label>

      I’m not sure if you know HTML, but see the class="text"? That’s not part of the calculator code. If your theme inserted those class definitions, then the theme is not compatible with this plugin.

      There are a lot of other changes made to the calculator as well.

  • I’m am getting a loan of $144,000 at a 1.7% rate. I would like to know how much I need to pay monthly in order to pay if off with 8-10 years. How would I do this?

    • To calculate the payment amount for the 10-year loan, you can set the inputs this way:

      Price of Real Estate or Asset?:   $0.00
      Down Payment Percent?:             0.0%
      Loan Amount?:               $144,000.00
      
      Number of Payments? (#):            120   < --- 120 months = 10 years
      Annual Interest Rate?:           1.7000%
      Payment Amount (P & I only)?:      $0.00  <--- payment amount is unknown
      
      Payment Frequency?:               Monthly
      Compounding?:                     Monthly
      Days Per Year?:                       365   <--- doesn't matter much
      Amortization Method?:              Normal
      

      To calculate the payment amount, the key is to set it to 0.

      If a user already knows how much they want to borrow, then the price of the real estate and the down payment percentage can be set to 0 also.

      Does this get you started?

    • Sorry for the problem. I can’t debug this right at the moment, but if you have the mortgage amount, please try this calculator:

      loan calculator.

      It works in a similar way. Just plug your mortgage amount in and the other loan details.

      • It did the same thing. Once the additional payment was entered it wouldn’t let me see or print the schedule.

        I’m trying to get a schedule for: $105,000 LA
        $1000 payment
        8% Interest
        $25,000 additional payment on each anniversary
        date
        We hope to close on May 1, 2018

        • Hate to say it, but I’m not having an issue. That is, I enter extra payments (in the loan calculator) and I can see them in the print preview.

          There is one thing, if you’ve been to this site before, you might have some older code remaining cached in your browser. You can try what’s called a "hard refresh".

          On Windows computers, that usually done (in IE and Chrome anyway) by pressing Ctrl-F5.

          Please give that a try.

  • ceil oberlander says:

    How do I get payment information for total payment fixed, principal (calculated), (interest calculated at fixed rate) , escrow taxes fixed amount.

    • The "total payment" for the year includes the principal and interest paid and the "escrow amount" includes the total taxes paid. You would need to add these two numbers together to know the total of all these values.

      I don’t see a place where this total would logically fit into the schedule, otherwise, I would include it.

  • Lundy Wilder says:

    Hi Karl, You must have an amazing mind to understand and program all of these calculators !!
    I am about to owner finance a home sale to a friend. He has said that he wants to sometimes make extra payments and since his income is variable each month, these extra payments will vary. I have had my lawyer draw up all the necessary mortgage closing papers for us to sign and record. They created a mortgage schedule but it doesn’t take into consideration extra payment options.

    I do not have a banking background and I know I will need a reliable way to re-calculate everything each time he makes extra payments. Which calculator would be best for me to use as we go along with him making regular monthly payments plus his erratic extra payments ?

    He will be paying his own insurance and property taxes so I don’t need to worry to worry about escrow for those.

    His loan amount will be $144,000 (after subtracting his down payments and rent credits I am allowing him) , the mortgage will be for 15 years, monthly payments.

    I would really appreciate your advice on which of your calculators I can use to keep track of this and issue him an annual statement.

    I love your favicon BTW !!

    Lundy in Alabama

    • Hello Lundy in Alabama,

      I’ve got just the calculator for you. Please see the Ultimate Financial Calculator. It is designed to allow the user to record each payment on a loan as they are made.

      If you go to the above page, scroll down, and you’ll see a lot of tutorials. Read #1 to get started. Then #25 deals specifically with your needs.

      With the web calculators, it is not possible to save your work. If you have a Windows computer, and you don’t want to enter the payments each time, you can look at the C-Value! software program. It works like the recommended calculator and it has the ability to save what you entered. Of course, you can try the UFC for a few months to see how you like it since you will only be dealing with a few months of payments.

Comments, suggestions & questions welcomed...

Leave a Reply to ceil oberlander Cancel reply

Scroll to...
advertisement