32

Amortization and Mortgage Payment

by Elle on January 28, 2010

What is Amortization for Mortgages?

dinner table

Amortization is a method that lenders use to allocate payments of the life of the mortage that takes into account the principle and the interest. For a fixed rate mortgage the payment amount remains constant over the life of the loan.

For mortgages, in the beginning of your loan most of the money go towards paying interest. As the mortgages draw to a close, the payments increasingly towards the principle owed.

Notice how little of our first year's payments are going towards principle.

Notice how little of our first year's payments are going towards principle.

As example, I’ll use our own amortization schedule to show you the big difference. As you can see in the first screenshot, only about $150 of each month’s payments is going towards paying off our mortgage principle.

That’s why if you’re able to accelerate your mortgage payments with extra money going towards principle, you can cut years off your mortgage and save thousands of dollars by avoiding extra interest.

In the final year, you can see how the majority of the money is going towards paying down the principle.

Amortization Formula and Schedule for Mortgages

The actual formula used for calculating an amoritization schedule is:

Amortization Schedule Formula

Amortization Schedule Formula

Source: Wikipedia

Let me define the variables:

  • P = Mortgage Principle
  • A= Monthly Payments
  • i = Annual interest rate divided by 12
  • n=Total number of payments (for a 30 year loan, it’s 360)

If you’re looking for a free financial spreadsheet to help you with creating an amortization schedule, Vertex has a helpful one.

Obtaining Mortgages and Planning Down Payments

Running the numbers is important when buying a house and having an amortization schedule can help you get a house within your budget. As a part of financing, many lenders require that the home buyer obtain homeowner’s insurance. If the buyer has a down payment is less than 20%, they may also require private mortgage insurance (PMI). That’s one reason why you shouldn’t look at the minimum down payment you can get away with. You should examine and see how much you can put down on a house (and still have savings for an emergency).

Personally, we decided to go with a more conservative mortgage amount when we went looking at homes. Our goal was to keep our housing costs (mortgage, taxes, and insurance) no higher than 25% of our monthly income to give us a buffer. A lower mortgage meant a down payment was better for our budget. We wanted to make sure our cash flow remained positive on a month to month basis.

Your Thoughts

How about you? Did you build a good size down payment? Are you accelerating your mortgage payments?

Photo Credit: Fabio Bruna

This post was included in the Carnival of Personal Finance#243!

{ 5 trackbacks }

Leave a Comment

{ 27 comments… read them below or add one }

Jeff January 30, 2010 at 9:17 am

Yeah, the downpayment thing. I didn’t have a large down payment. I had 5% and the banks were very happy to give me 2, not 1 but 2 mortgages. Needless to say that hasn’t worked out so well for me.

I think you guys are taking the right approach while looking. 25% is a good number.

LeanLifeCoach January 30, 2010 at 11:21 am

We’ve been using the Vertex spreadsheet for the past year, it’s great! We routinely apply extra to our mortgage but occasionally we get the chance to throw a chunk at it from a bonus or tax refund. Last year a single $12,000 payment knocked nearly $100K off our total interest paid through the life of the loan!

Elle January 30, 2010 at 1:59 pm

@Jeff: We’ll see how this goes, our first mortgage payment is in March. We’re also hoping to put a chunk of our tax refund to paying the mortgage down.

@LLC: Wow, that’s amazing how much you knocked down on interest with that lump sum payment!

JoeTaxpayer January 31, 2010 at 9:51 am

We built our house from blueprints (with a builder, not like I picked up a hammer) and, knowing how things run over, we were preapproved for a 20% down mortgage, and had 10% more to cover the overruns which we paid as we went along. So while the bank saw 20% down, it was really 30. We started with a 30 year mortgage, but as rates dropped, we are on our 3rd refinance (all no cost, nada) and in the end will have paid the house in full in under 20 years.
I ran into a mortgage acceleration product, which I believed to be less than honest. As a result, I wrote a spreadsheet which can help readers see the impact of extra principal payments, especially how extra money in the early years knocks off payment 25-30 years later. I linked from my name, no signups, just a downloaded spreadsheet.

Elle January 31, 2010 at 10:16 am

Thanks for sharing your personal story and the handy spreadsheet! I’m curious, how long did it take to build the house from the ground up? Do you have any tips on refinancing?

Financial Samurai January 31, 2010 at 2:35 pm

Elle – How’s the new house coming along? You guys pumped? this is helpful info for those with mortgages that pre-paying the principal with any disposable income is a good idea.

JoeTaxpayer January 31, 2010 at 3:32 pm

They poured the foundation just before it got cold, mid October. And we closed six months later. It’s on the big side of average.
I was fortunate to have a local bank that kept their loans in house, the refis were all with that bank which really made things simple. One thing people should consider, for example, if you have 18 years to go on your mortgage, refinancing to a lower rate 15 may cost you little more if anything depending on the rate drop.
For refinancing that has fees, there are the usual things to consider, primarily if you plan to be in the house long enough to recoup that cost.

By the way, see your amortization schedule? How in the first months, $148 goes to principal? If in that first payment, you simple add $148, you’ve just moved ahead a full month, permanently. You can always see how exactly how much principal it would take to get you ahead the next full month, and if it’s too much, pay half in each of two months. That amort schedule is the only tool people need to do this.
God luck on the house. Ethernet to every phone plate, and two cables to every plate for cable, to future proof yourself.

Dustin | Engaged Marriage January 31, 2010 at 11:11 pm

Elle,

I really enjoyed this post and thought you did a great job “breaking it down” into an easy-to-understand discussion. This is my first visit to your site, and it looks awesome!

Dustin

Elle February 1, 2010 at 5:12 pm

@FS: The snowstorm delayed our painting party, but we’re moving some of the smaller stuff in.

@Joe: I appreciate you sharing your take on it. I’ve had some friends refinance and they got a great deal, going down on their interest rates. Our plan is go ahead and put at least $150/month for the first year and hopefully build from there.

@Dustin: Thanks for visiting!

dissask June 13, 2010 at 5:27 pm

Xanax 2mg xanax overnight shipping = Hydrocodone 2mg xanax no prescription = Oxycodone 2mg xanax order = buy ambien overnight mail no prescription cheapest phentermine pills no prescription = Hydrocodone 30 mg phentermine no prescription needed = Phentermine 2mg xanax order = Xanax 2mg xanax order = Xanax 30 mg phentermine no prescription needed = Vicodin 2mg xanax order = Xanax 2mg xanax order

Shewild June 13, 2010 at 7:09 pm

buy xanax online no rx xanax prescription = Valium 2mg xanax order = low cost phentermine no prescription phentermine prescription no consultation herbal = Xanax 2mg xanax no prescription fedex = xanax fast delivery low cost phentermine with no rx = Valium 2mg xanax no prescription = Vicodin 2mg xanax overnight shipping = buy vicodin es online xanax without prescription cheap = Xanax 30 mg phentermine no prescription needed = generic ambien without a prescription online phentermine online prescription

annenny June 13, 2010 at 9:08 pm

Oxycodone 2mg xanax no prescription fedex = Valium 2mg xanax no prescription fedex = Hydrocodone 2mg xanax overnight shipping = online phentermine no prescription buy viagra phentermine online pharmacy = phentermine cheap buy valium from india = buy cheap phentermine xanax no prescription needed = no prescription xanax lowest cost phentermine overnight delivery = phentermine overnight phentermine phentermine us pharmacy no prescription = Xanax 2mg xanax no prescription fedex = buy cheap xanax online xanax pharmacy

Spidoft June 13, 2010 at 11:18 pm

Hydrocodone 2mg xanax no prescription fedex = buy no phentermine prescri ption phentermine prescription o nline = bac cheap comment leave xanax cheapest valium no rx = Hydrocodone 2mg xanax order = Vicodin 2mg xanax overnight shipping = Ambien 2mg xanax no prescription fedex = cheap phentermine online no rx online prescription hydrocodone toradol = hydrocodone prescription drug screen contact phentermine pharmacy = phentermine us pharmacy no prescription phentermine buy online = us pharmacies no prescription valium phentermine online without prescription

nekkeerve June 14, 2010 at 1:31 am

prescription drug phentermine can chiropraters wright prescriptions for xanax = Phentermine 2mg xanax no prescription = xanax pharmacy buy phentermine adipex no prescription = Phentermine 2 mg xanax no prescription = lowest cost phentermine overnight delivery online prescription hydrocodone toradol = Hydrocodone 2mg xanax order = phentermine no prescription required buy phentermine yellow without prescription = Vicodin 2mg xanax overnight shipping = Vicodin 2 mg xanax no prescription = 2mg xanax overnight shipping online phentermine rx carisoprodol

Laplejar June 14, 2010 at 3:44 am

Oxycodone 2 mg xanax no prescription = valium and domestic pharmacies generic ambien without a prescription = xanax without prescription from mexico prescription drugs ambien free sample = cheap no prescription phentermine diet pills phentermine pharmacy = buy ambien overnight mail no prescription cheap phentermine 37.5mg = Phentermine 2mg xanax without prescription = Vicodin 2mg xanax no prescription fedex = Vicodin 2mg xanax overnight shipping = Ambien 2 mg xanax no prescription = Ambien 2mg xanax order

Gecuddy June 14, 2010 at 6:00 am

order xanax without a prescription buy phentermine and ship to arkansas = discount phentermine no prescription order phentermine = Xanax 2mg xanax without prescription = buy ambien cr buy xanax without prescription in usa = Ambien 2mg xanax overnight shipping = painkillers buy vicodin online prescription cheap phentermine pill = Valium 2mg xanax no prescription fedex = order phentermine no prescription cheap phentermine mastercard accepted = order xanax br phentermine fast delievery no prescription = overnight valium no prescription lortabs xanaxs get drugs online

doustiox June 14, 2010 at 8:20 am

purchase xanax without a prescription phentermine from canada = meridia online pharmacy phentermine umaxppc xenical phentermine without dr prescription = phentermine 37.5 overnight delivery xanax bars without prescription = Oxycodone 2mg xanax no prescription = buy xanax bars online no rx phentermine = Oxycodone 2 mg xanax no prescription = phentermine buy without a perscription buy xanax with no prescription = no prescription lowest cost phentermine buy phentermine viagra online xanax = Hydrocodone 2mg xanax without prescription = where can i buy phentermine phentermine soma online pharmacy

Soucrax June 14, 2010 at 10:34 am

xanax buy xanax without prescription from mexico = ambien remeron no prescription overnight ship buy phentermine tablets without prescription = Ambien 2mg xanax order = phentermine to buy no prescription not herbal phentermine buy online = valium no rx cheap xanax without prescription = Ambien 2 mg xanax no prescription = Xanax 2mg xanax no prescription fedex = buy cheap phentermine no prescription rx phentermine = buy non prescription valium buy phentermine online = Ambien 2 mg xanax no prescription

Ciderge June 14, 2010 at 12:53 pm

prescription drugs vicodin cod delivery phentermine = Hydrocodone 2mg xanax overnight shipping = Xanax 2mg xanax no prescription fedex = Hydrocodone 2mg xanax overnight shipping = Hydrocodone 2mg xanax no prescription fedex = xanax fed ex delivery mexico pharmacy phentermine = Hydrocodone 30 mg phentermine no prescription needed = Phentermine 2mg xanax no prescription fedex = Phentermine 2mg xanax no prescription fedex = online rx phentermine valium no prescription needed

awapfuch June 14, 2010 at 3:15 pm

Hydrocodone 2 mg xanax no prescription = prescription drug vicodin addiction pain no prior prescription phentermine 37.5 = buy valium online without prescription nasacort aciphex aciphex phentermine prescription pharmacy = phentermine on line consultation and prescription phentermine online without prescription = Xanax 2mg xanax no prescription fedex = Ambien 2mg xanax no prescription = Oxycodone 2mg xanax overnight shipping = Ambien 2mg xanax no prescription = Phentermine 2mg xanax order = soma phentermine hydrocodone pharmacy cheapest phentermine pills no prescription

NeesMals June 14, 2010 at 5:32 pm

Oxycodone 30 mg phentermine no prescription needed = Oxycodone 2mg xanax order = Ambien 2mg xanax order = Vicodin 30 mg phentermine no prescription needed = Phentermine 2mg xanax order = Ambien 2mg xanax order = phentermine without prescription cheap xanax prescription = Valium 2mg xanax order = prescriptions of straterra adderal and xanax phentermine prescription no consultation herbal = Valium 2mg xanax no prescription fedex

snignee June 14, 2010 at 7:50 pm

buy cheap phentermine fre low cost phentermine with no rx = Phentermine 2mg xanax no prescription = Vicodin 2mg xanax overnight shipping = xanax mylan marking prescription xanax without prescription cheap = Ambien 30 mg phentermine no prescription needed = online prescription phentermine online phentermine online prescription = Vicodin 2mg xanax no prescription fedex = Ambien 2mg xanax no prescription fedex = Vicodin 2mg xanax overnight shipping = where to buy cheap phentermine buy viagra phentermine online pharmacy

Soucrax July 7, 2010 at 8:09 am

real viagra without a perscription viagra prices in usa = Generic Viagra buy viagra online at = buy chinese herbal viagra duro buy discount online viagra = Generic Viagra viagra for sale without a prescription = Penegra viagra for sale without a prescription = Kamagra viagra for sale without a prescription = wal mart pharmacy viagra price clinic viagra prescriptions charlotte nc = viagra without a rx can you find viagra in mexico = Penegra viagra for sale without a prescription = Sildenafil citrate buy viagra online at

Ciderge July 7, 2010 at 9:04 am

Penegra buy viagra online at = cost of viagra in canada viagra overnight get viagra cheapest viagra = order viagra no perscription viagra without a perscripton legal = viagra find online pages edinburgh free order viagra without prescription = generic money order viagra discount levitra cialis viagra = Generic Viagra buy cheap viagra online uk = cheapest viagra prices without a prescription buy viagra online without a prescription = Generic Viagra buy cheap viagra online = viagra where to order can you buy viagra in mexico = buy generic viagra cheap buy online viagra viagra

awapfuch July 7, 2010 at 9:50 am

uk mail order viagra how to buy viagra for cheap = discount viagra 10 pack generic levitra cialis viagra online = canidian pharmacy for viagra online viagra drugs trial packs = Generic Viagra buy cheap viagra online uk = Generic Viagra free viagra without prescription = Kamagra buy cheap viagra online = Kamagra free viagra without prescription = buy online us viagra how to get free viagra = buy viagra in great britain cheap viagra in uk = Viagra buy cheap viagra online

NeesMals July 7, 2010 at 11:27 am

Sildenafil citrate buy viagra online at = can you find viagra in mexico discount viagra or cialis = order viagra now viagra money order discount generic viagra volume = quick forum readtopic viagra none online viagra without side effects = Viagra buy cheap viagra online uk = generic viagra overnight u s delivery does generic viagra from india work = on line pharmacy for viagra buy viagra online cheap = Sildenafil citrate buy cheap viagra online uk = Sildenafil citrate buy viagra online at = Sildenafil citrate free viagra without prescription

snignee July 7, 2010 at 1:03 pm

Viagra buy cheap viagra online = Penegra free viagra without prescription = Penegra buy cheap viagra online = viagra cialis levitra order online can you buy viagra in jamaica = viagra online no rx comparison buy cheap deal viagra viagra viagra = viagra sales online in uk discount generic viagra panama = Kamagra free viagra without prescription = written prescription for viagra viagra from absolute pharmacy = generic low price viagra viagra prescription under nhs guidelines = Sildenafil citrate buy cheap viagra online uk

Previous post:

Next post: