7.6: Remaining Loan Balance

Last updated
Save as PDF

Page ID: 69496

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $ $ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $$\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$ $\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$$\newcommand{\AA}{\unicode[.8,0]{x212B}}$

With loans, it is often desirable to determine what the remaining loan balance will be after some number of years. For example, if you purchase a home and plan to sell it in five years, you might want to know how much of the loan balance you will have paid off and how much you have to pay from the sale.

To determine the remaining loan balance after some number of years, we first need to know the loan payments, if we don’t already know them. Remember that only a portion of your loan payments go towards the loan balance; a portion is going to go towards interest. For example, if your payments were $1,000 a month, after a year you will not have paid off $12,000 of the loan balance.

To determine the remaining loan balance, we can think “how much of the loan will these loan payments be able to pay off in the remaining time on the loan?”

Example $\PageIndex{1}$

If a mortgage at a 6% interest rate has payments of $1,000 a month, how much will the loan balance be 10 years from the end of the loan?

Solution

To determine this, we are looking for the amount of the loan that can be paid off by $1,000 a month payments in 10 years. In other words, we’re looking for $P_0$ when

The monthly loan payment:

$d = $1000$

6% annual rate:

$r = 0.06$

Since we’re doing monthly payments, we’ll compound monthly:

$k = 12$

Since we’re making monthly payments for 10 more years:

$N = 10$

$P_0 = \dfrac{1000 \left( 1 - \left( 1+ \dfrac{0.06}{12} \right)^{-10(12)} \right) }{\left(\dfrac{0.06}{12}\right)} $

$P_0 = \dfrac{1000 \times \left( 1 - \left( 1.005 \right)^{-120} \right) }{\left( 0.005 \right)} $

$P_0 = \dfrac{1000 \left( 1 - 0.5496 \right) }{\left( 0.005 \right)} = $90,073.45$

The loan balance with $10$ years remaining on the loan will be $$90,073.45$.

Often times, answering remaining balance questions requires two steps:

Calculating the monthly payments on the loan
Calculating the remaining loan balance based on the remaining time on the loan

Example $\PageIndex{2}$

A couple purchases a home with a $180,000 mortgage at 4% for 30 years with monthly payments. What will the remaining balance on their mortgage be after 5 years?

Solution

First, we will calculate their monthly payments, i.e., we’re looking for $d$.

4% annual rate:

$r = 0.04$

Since they’re paying monthly:

$k = 12$

30 years:

$N= 30$

The starting loan amount:

$P_{30} = $180,000$

We set up the equation and solve for $d$.

$180000 = \dfrac{d \left( 1- \left( 1+ \dfrac{0.04}{12} \right)^{-30(12)} \right) }{\left(\dfrac{0.04}{12}\right)} $

$180000 = \dfrac{d \left( 1- \left( 1.00333 \right)^{-360} \right) }{\left( 0.00333 \right)} $

$180000 = d(209.562) $

$d = \dfrac{180000}{209.562} = $858.93 $

Now that we know the monthly payments, we can determine the remaining balance. We want the remaining balance after $5$ years when $25$ years will be remaining on the loan. So, we calculate the loan balance that will be paid off with the monthly payments over those $25$ years.

The monthly loan payment we calculated above:

$d = $858.93$

4% annual rate:

$r = 0.04$

Since they’re doing monthly payments:

$k = 12$

Since they’d be making monthly payments for 25 more years:

$N = 25$

$P_0 = \dfrac{858.93 \left( 1 - \left( 1+ \dfrac{0.04}{12} \right)^{-25(12)} \right) }{\left(\dfrac{0.04}{12}\right)} $

$P_0 = \dfrac{858.93 \times \left( 1 - \left( 1.00333 \right)^{-300} \right) }{\left( 0.00333 \right)} $

$P_0 = \dfrac{858.93 \left( 1 - 0.369 \right) }{\left( 0.00333 \right)} = $155,793.91$

The loan balance after $5$ years, with $25$ years remaining on the loan, will be $$155,793.91$.

Over that $5$ years, the couple has paid off $$180,000 - $155,793.91 = $24,206.09$ of the loan balance. They have paid a total of $$858.93$ a month for $5$ years ($60$ months), for a total of $$51,535.80$, so $$51,535.80 - $24,206.09 = $27,329.71$ of what they have paid so far has been interest.

Example \(\PageIndex{1}\)

Solution

Example \(\PageIndex{2}\)

Solution