Thursday, April 23, 2009

Amortization Schedules and Principal Prepayment, Part 1: Shortening a 30-Year Mortgage Into 15

I’ve been tinkering around with my mortgage. Have you ever wondered how the monthly payment was determined? It’s called amortization. An amortization schedule is a way to make equal payments over a period of time, but have the payments split between principal and interest so that the interest paid over time decreases over time along with the loan amount remaining. It is a balancing act to be fair to both borrower and lender, and you can find a mathematical derivation here.

The most direct way to see where you are on your amortization schedule is to ask your lender to send you a copy. Alternatively, you can generate one yourself by using a mortgage calculator with this feature. Here is the amortization schedule for a $200,000 loan with a fixed interest rate of 5% over 30 years.

(May not be visible in RSS format. Here is the direct link.)

As you can see, in the beginning most of your payment goes towards interest, and only a little reduces your principal, or outstanding loan amount. As time goes on, your payment stays the same, but the chunk going towards interest decreases as the principal shrinks.

Mortgage Principal Prepayment
If you want to pay off the loan in less than 30 years, you’ll have to pay more than required. This is known as principal pre-payment. The effect of making such additional payments can be visualized by imagining that it moves you “ahead” in the amortizaton schedule.

Here’s an example using the schedule shown above. Let’s say you’re just getting ready to make your first payment of $1,074. At this rate, you still have 359 out of 360 monthly payments left to go! How much money would it take to shave off one extra payment off the end? To find that, you just have to look at the principal portion of Month #2, which I highlighted orange: $241.

If you pay $241 additional with your first payment now, you’ll won’t have to pay the $1,074 due on Month #360. Why is this? Working backwards, you can confirm that this is pretty much a 5% compounded return on $241 for 30 years, as expected. In addition, you’ll be shifted forward to Month #3 on the schedule. So next month your (still required) payment of $1,074 will have a bit more applied towards principal, and a bit less towards interest.

Making a 30-year Mortgage into a 15-year Mortgage
This actually creates an interesting way to shorten your mortgage. What if you kept paying the next month’s principal payment on top of your required $1,074 each month. You’d add on $241, then $243, then $245, and so on. Every month you’d shave off one month off the end, leaving you with a 15-year mortgage! You can also imagine this as skipping every other payment by just paying the principal and saving the interest.

This can work out nicely because the extra required will start out reasonably low at $241, and increase gradually with time along with your income and/or cashflow.

An alternative is to add $510 to every payment each month to shorten the term to 15 years. Although if you’re sure you want to do that, you might want to just get a 15-year fixed mortgage at a lower interest rate.

Read more about Amortization Schedules and Principal Prepayment, Part 1: Shortening a 30-Year Mortgage Into 15…



No comments: