8.6: Remaining Loan Balance

Last updated
Save as PDF

Page ID: 62015

$ \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}}$

$ \newcommand{\vectorA}[1]{\vec{#1}} % arrow$

$ \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow$

$ \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vectorC}[1]{\textbf{#1}} $

$ \newcommand{\vectorD}[1]{\overrightarrow{#1}} $

$ \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} $

$ \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} $

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $

$\newcommand{\avec}{\mathbf a}$ $\newcommand{\bvec}{\mathbf b}$ $\newcommand{\cvec}{\mathbf c}$ $\newcommand{\dvec}{\mathbf d}$ $\newcommand{\dtil}{\widetilde{\mathbf d}}$ $\newcommand{\evec}{\mathbf e}$ $\newcommand{\fvec}{\mathbf f}$ $\newcommand{\nvec}{\mathbf n}$ $\newcommand{\pvec}{\mathbf p}$ $\newcommand{\qvec}{\mathbf q}$ $\newcommand{\svec}{\mathbf s}$ $\newcommand{\tvec}{\mathbf t}$ $\newcommand{\uvec}{\mathbf u}$ $\newcommand{\vvec}{\mathbf v}$ $\newcommand{\wvec}{\mathbf w}$ $\newcommand{\xvec}{\mathbf x}$ $\newcommand{\yvec}{\mathbf y}$ $\newcommand{\zvec}{\mathbf z}$ $\newcommand{\rvec}{\mathbf r}$ $\newcommand{\mvec}{\mathbf m}$ $\newcommand{\zerovec}{\mathbf 0}$ $\newcommand{\onevec}{\mathbf 1}$ $\newcommand{\real}{\mathbb R}$ $\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}$ $\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}$ $\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}$ $\newcommand{\laspan}[1]{\text{Span}\{#1\}}$ $\newcommand{\bcal}{\cal B}$ $\newcommand{\ccal}{\cal C}$ $\newcommand{\scal}{\cal S}$ $\newcommand{\wcal}{\cal W}$ $\newcommand{\ecal}{\cal E}$ $\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}$ $\newcommand{\gray}[1]{\color{gray}{#1}}$ $\newcommand{\lgray}[1]{\color{lightgray}{#1}}$ $\newcommand{\rank}{\operatorname{rank}}$ $\newcommand{\row}{\text{Row}}$ $\newcommand{\col}{\text{Col}}$ $\renewcommand{\row}{\text{Row}}$ $\newcommand{\nul}{\text{Nul}}$ $\newcommand{\var}{\text{Var}}$ $\newcommand{\corr}{\text{corr}}$ $\newcommand{\len}[1]{\left|#1\right|}$ $\newcommand{\bbar}{\overline{\bvec}}$ $\newcommand{\bhat}{\widehat{\bvec}}$ $\newcommand{\bperp}{\bvec^\perp}$ $\newcommand{\xhat}{\widehat{\xvec}}$ $\newcommand{\vhat}{\widehat{\vvec}}$ $\newcommand{\uhat}{\widehat{\uvec}}$ $\newcommand{\what}{\widehat{\wvec}}$ $\newcommand{\Sighat}{\widehat{\Sigma}}$ $\newcommand{\lt}{<}$ $\newcommand{\gt}{>}$ $\newcommand{\amp}{&}$ $\definecolor{fillinmathshade}{gray}{0.9}$

Learning Objectives

Be able to calculate the remaining balance on a loan.

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 loan will these loan payments be able to pay off in the remaining time on the loan?”

Example 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 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

$\begin{array}{ll} d = \$1,000 & \text{the monthly loan payment} \\ r = 0.06 & 6\% \text{ annual rate} \\ k = 12 & \text{since we’re doing monthly payments, we’ll compound monthly} \\ t = 10 & \text{since we’re making payments for 10 more years} \end{array} $

$P_{0}=\frac{1000\left(1-\left(1+\frac{0.06}{12}\right)^{-12(10)}\right)}{\left(\frac{0.06}{12}\right)}$

$P_{0}=\frac{1000\left(1-(1.005)^{-120}\right)}{(0.005)}$

$P_{0}=\frac{1000(1-0.5496)}{(0.005)}=\$ 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:

1) Calculating the monthly payments on the loan

2) Calculating the remaining loan balance based on the remaining time on the loan

Example 2

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

Solution

First we will calculate their monthly payments.

We’re looking for $d$.

$\begin{array}{ll} r = 0.04 & 4\% \text{ annual rate} \\ k = 12 & \text{ since they’re paying monthly} \\ t = 30 & \text{30 years of payments on the original loan} \\ P_0 = \$180,000 & \text{the starting loan amount} \end{array} $

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

$180,000=\frac{d\left(1-\left(1+\frac{0.04}{12}\right)^{-12(30)}\right)}{\left(\frac{0.04}{12}\right)}$

$180,000=\frac{d\left(1-(1.00333)^{-360}\right)}{(0.00333)}$

$180,000=d(209.562)$

$d=\frac{180,000}{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.

$\begin{array}{ll} d = \$858.93 & \text{the monthly loan payment we calculated above} \\ r = 0.04 & 4\% \text{ annual rate} \\ k = 12 & \text{since they’re paying monthly} \\ N = 25 & \text{since they’d be making monthly payments for 25 more years} \end{array} $

$P_{0}=\frac{858.93\left(1-\left(1+\frac{0.04}{12}\right)^{-12(25)}\right)}{\left(\frac{0.04}{12}\right)}$

$P_{0}=\frac{858.93\left(1-(1.00333)^{-300}\right)}{(0.00333)}$

$P_{0}=\frac{858.93(1-0.369)}{(0.00333)} \approx \$ 162,758$

The loan balance after 5 years, with 25 years remaining on the loan, will be $\$ 162,758$

Over that 5 years, the couple has paid off $\$ 180,000-\$ 162,758=\$ 17,242$ 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-\$ 17,242=\$ 34,292.80$ of what they have paid so far has been interest.

Search

Text Color

Text Size

Margin Size

Font Type