September 27, 2021
Extra Payment Calculator

Additional Cost Mortgage Calculator for Excel


A few of the questions I’ve had concerning mortgages and simply loans generally have needed to do with whether or not it’s a good suggestion to make additional funds on the principal. In case you have had related questions, please be happy to obtain the Additional Mortgage Funds Calculator for Excel and browse the remainder of this web page.

Commercial


Why Make Additional Mortgage Funds?

There could also be many causes an individual desires to make extra funds on
the principal of a mortgage, however the commonest causes appear to be:

  • To payoff a house, auto, or shopper mortgage extra rapidly.
  • To scale back the quantity of complete curiosity paid.
  • To reap the benefits of excessive mortgage rates of interest when different financial savings plans
    have a decrease rate of interest.

All of those could also be good causes to make extra funds, however be sure you
perceive what you’re doing, first. See under for extra details about every of those causes.

Additional Cost Mortgage Calculator

for Excel

Extra Payment Calculator
⤓ Obtain

For: Excel 2007 or later & Excel for iPad/iPhone

Different Variations

Template Particulars

License: Private Use (not for distribution or resale)

“No set up, no macros – only a easy spreadsheet” – by Jon Wittwer

Description

Calculate the distinction in complete curiosity paid on a mortgage mortgage when making extra month-to-month funds.

Since creating this spreadsheet, I’ve created many different calculators that allow you to embrace additional mortgage funds. Essentially the most superior and versatile one is my Residence Mortgage Calculator.

* For Excel 2003: The CUMIPMT operate requires the Evaluation ToolPak, which comes with Excel however is commonly not put in routinely. To put in the add-in, open up Excel and go to the Instruments menu > Add-Ins… and examine the field subsequent to “Evaluation ToolPak”.

Causes to Make Additional Funds

Paying off a Mortgage Early

This method is fairly straightforward to grasp. In the event you make extra funds, you’d
count on the mortgage to paid sooner. The spreadsheet assumes that the additional mortgage funds are made
each month.

Pay Much less Whole Curiosity

Every month, your fee consists of each curiosity and principal. The
quantity of curiosity that’s paid relies upon upon the quantity of principal nonetheless owed (i.e.
the present steadiness). That implies that in the event you pay down the principal, you
will find yourself paying much less curiosity. That is the so-called “curiosity financial savings
that’s calculated within the worksheet (i.e. the discount within the curiosity expense).

Additional Funds vs. Financial savings

It might be bizarre to think about making extra funds as an “funding”, however it seems that making additional funds is sort of equivalent to inserting the cash in a financial savings plan. If the mortgage rate of interest is similar as for the financial savings plan, then the quantity of lowered curiosity expense from making additional funds is equivalent to the quantity of curiosity “gained” within the financial savings plan (assuming each charges are fastened and compound month-to-month). The principle distinction is that with a financial savings plan (or different related funding), the money is extra available.

The underside line has to do with three essential questions (which you’ll have to reply for your self):

  1. What method gives a greater rate of interest?
  2. The place ought to the funding be tied up? (Residence fairness or a financial savings/funding account?)

Different Questions

What about residence appreciation or depreciation? Merely put, this can be a fully separate problem. The “curiosity financial savings” from additional funds has to do with the mortgage rate of interest, not the current worth of the house.

What about taxes? I am not going to reply this one as a result of I am not knowledgeable tax advisor, however do not forget that the quantity of curiosity paid on a mortgage is normally deductible and the quantity of curiosity gained in a financial savings/funding account could also be taxable.

associated weblog articles
10 Methods for Paying Off Your Mortgage Early
Biweekly Mortgage Cost Plans Uncovered

Associated Content material

Extra Mortgage and Mortgage Calculators

Extra Assets associated to Additional Funds

Disclaimer: This spreadsheet and documentation on this web page are meant for academic functions solely. We consider the calculations to be right, however don’t assure the outcomes. Please seek the advice of your monetary advisor or lending establishment earlier than making any closing monetary selections. Some mortgage loans might have a prepayment penalty.