Mortgage Amortization Formula Proof with Balloon Payment

A mortgage loan is simply a loan taken where the house or property is used as collateral in case the borrower cannot pay off the loan in time. Payments are made periodically, usually monthly, and are most often times constant. This simplifies the finances of the borrower greatly. The process of paying off the loan is called amortization.

The basic amortization formula to determine the periodic payment amount when given the length of the loan, interest rate, and principle loan amount is shown below:

A = P\frac{i(1+i)^n}{(1+i)^n - 1}

where:

  • A = periodic payment amount
  • P = amount of principle or loan owing (subtracting any down-payments)
  • i = period interest rate
  • NOTE: if installments are monthly and interest rate is annual, need to divide by 12
  • n = total number of payments

Another mortgage repayment strategy is to include a large lump sum often called a final balloon payment at the end of the mortgage term. The idea behind this strategy is to lower the monthly payment amount at the cost of increased overall interest that is paid by saving up to pay the final balloon payment. This strategy is recommended for personal home owners but for businesses revenue predictions that increase in the future this strategy may be viable. The mortgage amortization formula including the final balloon payment is shown below:

A = P\frac{i(1+i)^n}{(1+i)^n - 1} - \frac{iB}{(1+i)^{n+1} - (1+i)}

where:

  • B = Final Balloon Payment
  • If the borrower wants to only amortize part of the loan or mortgage, they can decide to make constant payments, A, until a specific time and then pay off the remaining loan with one large payment, B.
  • If B = 0, then the amortization formula is the same as the basic one.

Derivation of the Basic Amortization Formula

The derivation of the basic amortization formula is based on the requirements that the periodic payments and interest rate are constant over the length of the mortgage loan. If the interest rate is variable then the formula will still work but will have to be split into intervals of constant interest rates.

The interest is compounded periodically using the basic principles of Compound Interest. This basically means that during each period of payment, interest is added to the total principle loan amount that is still being payed. Thus the overall payment once the mortgage loan is fully paid off is usually substantially higher than the loan amount depending on the interest rate.

To begin the derivation, first let p(t) represent the principle amount owing or payment balance at time t:

p(0) = P = Initial ~ loan ~ amount
Thus, ~ p(0) ~ is ~ initial ~ balance

The balance at the first period after the first payment, A, is made must account for the added interest, p(0)i:

p(1) = p(0) + P(0)i - A
= p(0)(1+i) - A
= P(1+i) - A

And to simplify the derivation, let r = 1 + i so that:

P(1) = Pr - A

Similarly, for the balance at the second payment period we add interest from the balance of the first payment period:

p(2) = p(1) + p(1)i - A
= p(1)(1+i) - A
= p(1)r - A = [Pr - A]r - A
= Pr^2 - Ar - A
= Pr^2 - A(1+r)

Now there starts appearing a pattern and can extend this to a general payment period at time t:

p(3) = p(2)r - A
= Pr^3 - Ar^2 - Ar - A
= Pr^3 - A(1+r+r^2)
...
p(t) = p(t-1)r - A
= Pr^t - A(1 + r + r^2 + ... + r^{t-1})

It is important to note that the term in the above equation, 1+r+r^2+⋯+r^(t-1), is a Geometric Series and can be written by the formula below (the proof can be found here: Geometric Series Proof):

1 + r + r^2 + ... + r^{t-1}
= \sum\limits_{t=1}^t r^{k-1} = \frac{1-r^t}{1-r}

Thus we can rewrite the equation for the balance at any time t:

p(t) = Pr^t - A\frac{1-r^t}{1-r}

At the end of the term, at t=n, the mortgage loan is fully paid off thus the final balance is zero. This means that the above equation can be rearrange to solve for the monthly payment, A:

p(n) = 0 = Pr^n - A\frac{1-r^n}{1-r}
A\frac{1-r^n}{1-r} = Pr^n
A = Pr^n\frac{1-r}{1-r^n}

Now we can replace r with 1 + r to get:

A = P(1+i)^n\frac{1 - (1+i)}{1-(1+i)^n}
=P(1+i)^n\frac{-i}{1-(1+i)^n}

Now rearranging the equation by multiplying by -1/-1 to get rid of the negative sign in the numerator, we finally get the basic mortgage amortization formula:

A = P\frac{i(1+i)^n}{(1+i)^n - 1}

Derivation of the Mortgage Amortization Formula including Balloon Payment

If the mortgage repayment strategy includes a final balloon payment, the only difference in derivation is that the final balance at the end of the term, p(n) is not fully paid off and thus is not equal to zero. Also it is important to note that the final balloon payment also includes the interest added from the final balance. Thus the final balloon payment is equal to the final balance, p(n), plus interest added to p(n):

B = p(n) + p(n)i = p(n)(1+i)

It is important to note that the actual final payment to be made is the balloon payment plus the interest added to the previous balance, thus tual final payment = B + p(n)i.

Now in simplifying this derivation we will replace 1+i with r and use the equation for p(n) that is written in term of r as well as rearrange the equation to solve for the periodic payment, A:

B = p(n)r
\frac{B}{r} = p(n) = Pr^n - A\frac{1-r^n}{1-r}
A\frac{1-r^n}{1-r} = Pr^n - \frac{B}{r}
A = Pr^n\frac{1-r}{1-r^n} - \frac{B}{r}\frac{1-r}{1-r^n}

Now we can replace r with 1+i and notice that the first part of the above equation is just simply the basic amortization formula, thus we get:

A = P\frac{i(1+i)^n}{(1+i)^n - 1} - B\frac{1-(1+i)}{(1+i)(1-(1+i)^n)}
A = P\frac{i(1+i)^n}{(1+i)^n - 1} - B\frac{-i}{(1+i)-(1+i)^{n+1}}

Now to further simplify the equation, we multiply the second term by -1/-1 to remove one of the negative signs so the formula visually shows that the periodic payment is lower when there is a final balloon payment. Thus, finally we have the mortgage amortization formula including the final balloon payment:

A = P\frac{i(1+i)^n}{(1+i)^n - 1} - \frac{iB}{(1+i)^{n+1}-(1+i)}

It is important to note that if B = 0, then the above equation simply becomes the basic amortization formula. Also while this formula is often used for mortgage related purpose, this same formula can be used for other debt or loans such as short terms loans, student loans, and credit cards since they all follow the same concept of compounded interest. Also it is possible to rearrange the formula to solve for B, P, and n but solving for i are done through numerical methods and are not as straight forward.:

View Comments