A fine WordPress.com site

A little piece of financial math

Like many homeowners, I don’t put a lot of thought into my mortgage payments. Indeed, it suffices for me to know that if I pay the bank the amount that they asked for, then they’ll stay off my back for at least a month. Most of the Canadian banks have a mortgage calculator on their website, and I’ve never put much thought as to how it works.

This changed when my wife, who’s getting certified as a professional accountant, asked me how to perform what turns out to be equivalent to calculating a mortgage. The derivation is quite intricate and surprisingly satisfying mathematically, so I thought I would share.

Let us set up the problem as follows. Suppose that you borrowed an amount from a lender, and the interest rate is percent per period. You are to pay the lender back in equal payments, including all interest and principal. How do you calculate the amount of each payment, and the total cost of borrowing (excluding time value of money which is not part of the problem)?

This question seems quite intractable, as there are many unknowns. However, in a realistic situation are all known. In concrete terms, suppose you borrowed dollars to buy a house, at an interest rate of 3% per month. You are to pay the bank back over a period of 25 years, or months. Therefore, our final formula would make use of the parameters , or in other words, we wish to derive the payment amount as a function of .

To do this, let us think about the first payment, say . We have to pay amount in interest, and an amount in principal. Therefore, we have

The next payment, , we pay an interest equal , since the principal has been reduced by , and a principal amount equal to . Making use of the fact that each payment is equal, i.e. , we have

.

Likewise, for the third payment, we have

.

We now have enough data to make an induction hypothesis, namely

.

If we assume the induction hypothesis, then we have

Now we use the fact that after payments, we must pay back the principal. In other words, we must have

which is equivalent to

The partial geometric series on the left hand side can be evaluated to be