Simple Loan Calculator. Some mortgage calculations can be extremely simple, and also the reason for the simple mortgage calculator spreadsheet below will be demonstrate this with shine.

Simple Loan Calculator. Some mortgage calculations can be extremely simple, and also the reason for the simple mortgage calculator spreadsheet below will be demonstrate this with shine.

Unlike a number of our different mortgage and mortgage calculators, the Simple mortgage Calculator utilizes just the fundamental integral monetary formulas to calculate either the fees (using the PMT formula), the rate of interest (using the speed formula), the mortgage levels (using the PV formula), or perhaps the quantity of costs (using the NPER formula).

On Line Mortgage Calculator

You are able to this online calculator to execute quick calculations, or you can download the spreadsheet observe ways to use formulas in succeed.

Straightforward Loan Calculator

Easy Loan Calculator


Other Models

Licenses: Personal usage (not for distribution or selling)

"No setting up, no macros – merely a simple spreadsheet" – by Jon Wittwer


This loan calculator makes use of the PMT, PV, SPEED, and NPER solutions to estimate the repayment, Loan Amount, Annual Interest, or Term duration for a fixed-rate loan. Useful for both auto and home loans. See below for additional information.

How to Use the mortgage Calculator Spreadsheet

This calculator shows 4 distinct financing computations. Descriptions for every single regarding the industries are given under, in addition to examples based on how to make use of all the selection.

Menstruation each year: The number of payments each year. Input 12 for Monthly, 52 for Weekly, 1 for Annual an such like.

Loan Amount: This is basically the levels which you have lent. You can even enter your current balance, should you too modify the word of mortgage becoming the sheer number of many years kept to settle the mortgage.

Annual interest: This calculator thinks a hard and fast interest rate, as well as the interest was combined each years.

Repayment (Per stage): this is actually the quantity this is certainly paid each course, like both major and interest (PI).

Name of Loan (in many years): Mortgage loans usually have 15 or 30-year terminology. Automotive loans are usually between 2 and five years. For a 6-month phase, enter =6/12 or 0.5. If you registered your present balances inside Loan Amount, next for Term enter the number of years you have got leftover until the loan is paid down.

Choice A: Solve for any mortgage cost using PMT()

Make use of this choice once you learn how a lot you ought to borrow and would like to find out how the rate of interest or phase influences the repayment. Including, a 5-year, $15,000 mortgage at 7.5% interest creates a monthly payment of $300.57. The whole interest settled during the longevity of the loan try determined to be $3,034.15.

Choice B: Solve when it comes to Loan Amount utilizing PV()

Utilize this option whenever you know-how much you really can afford to pay each month and want to find out how large of that loan you will get. Take into account that there is additional fees in addition to standard financing installment (principal+interest), such as for example insurance coverage, taxation, etc.

Like, with a $250 payment, should you got a 5-year financing with a 6percent interest, the borrowed funds quantity try calculated become $12,931.39.

Choice C: Remedy the rate of interest utilizing RATE()

It’s not as common to resolve the interest as you might not have any power over exactly what your rate of interest can be (aside from looking around to discover the best people). But this choice might ideal for educational uses.

Alternative D: Remedy for label utilizing NPER()

Use this choice if you would like repay your loan very early through extra money. Eg, recommend returning to the sample for solution A. For the same amount borrowed and interest, should you decide shell out $60 extra every month or $360.57, the expression try calculated is 4.03 years (instead of 5 such as option A) – definition you had pay your loan practically 12 months early. You would also wind up having to pay about $600 much less interest overall. This assumes there are no penalties for making higher costs.

Some individuals prefer to get financing with longer terminology and make normal added money. The main benefit of this method is that if you run into hard times, possible end deciding to make the extra money. The disadvantage is that if there isn’t the self-discipline to help make the further money, you will end up spending a lot more interest overall.