Calculating a Mortgage
- While there are plenty of mortgage calculators out there
- It’s good to know the math behind it
- If nothing else
- You can impress your friends and family
Mortgages can be complicated business – fortunately there are a ton of great calculators out there that take the legwork out of all the tricky math.
But as your teachers probably told you in school time and time again, it’s good to actually know how things work too.
And hey, it’s never smart to rely too heavily on technology in case something goes wrong. Oh, and you can impress your friends too. Well, probably not, but let’s move on.
That brings us to how mortgage interest works. Ready to do some light algebra? Neither am I, but let’s try it anyway.
The Interest Part Is Easy
- It’s very easy to calculate mortgage interest
- A standard calculator will do the job
- If you just need to run a quick calculation
A simple way to determine how much your interest payment is each month is to multiple your loan amount by the interest rate, and then divide by 12.
$200,000 x 0.035 / 12= $583.33
So in the scenario above, we’d come up with $583.33. This would be the interest portion of your monthly mortgage payment. Pretty basic stuff here. No algebra required!
But times have changed, and now everyone wants to pay off their mortgages. Funny how things change…
How Do You Calculate the Entire Payment, Including Principal?
- The formula is a bit more complex
- But you can still do it by hand
- If you’ve got nothing better to do
Most people probably don’t care nor want to know this second part, but I figured I’d share just to cover all the bases and blow your mind.
If you want to calculate your entire mortgage payment, including both the principal and interest portion, you need to use the very complex monthly mortgage payment formula below.
And yes, it’s heavy on the algebra, real heavy for those of us not so thrilled with math. Warning: It’ll hurt your head.
Here Is the Mortgage Formula
P = L[c(1 + c) n]/[(1 + c) n – 1]
P= monthly payment
L = loan amount = $200,000
C = periodic interest rate = 0.002917 (3.5%/12 months)
N = number of payments = 360 (30 years)
Lost yet? Don’t worry; I won’t make you do the math. Heck, I used an algebraic calculator to come up with the answer.
Let’s break it down:
P = 200,000[0.002917(1.002917)^360]/ [(1.002917)^360-1]
P = 200,000 x 0.00449045
P = $898.09
Still with me? Phew. So the total monthly mortgage payment is $898.09. And because we know the interest portion already ($583.33), the principal portion of the payment must be $314.76.
Of course, it’s not that simple, nothing ever is. This calculation above is only good for the very first payment based on the $200,000 loan amount and a 30-year amortization schedule.
When calculating the following month’s payment, you would have you use the new loan balance, which falls to $199,685.24 thanks to that $314.76 principal payment.
Fortunately, we already know the total payment amount, which is fixed for the full loan term, so we can just calculate interest and then the rest must be principal.
In month two we calculate interest by doing the following:
$199,685.24 x 0.035 / 12 = $582.42
Taking our fixed total monthly payment amount of $898.09 and subtracting $582.42, we come up with $315.67, which is the second principal payment.
As you can see, the interest portion of the payment dropped slightly, while the principal portion increased.
Over time, the interest portion of the mortgage payment falls, thanks to the smaller outstanding balance, and the principal portion of the payment rises.
In fact, at the end of the loan term, assuming you don’t refinance or prepay, the interest portion will account for just a few bucks of the total payment.
However, the total payment amount doesn’t change. It’s just how your payment is allocated over time that changes.
I’ve probably confused more people than intended here, but it’s always good to know how things work, even if you don’t actually do the math yourself.
For the record, I recommend using a mortgage calculator as opposed to trying to do all this math by hand. It’s interesting to know how it is calculated, but way too much work.
Read more: Are mortgage calculators actually accurate?
(photo: Jorge Franganillo)