Section 1.6: Loans

In the last section, you learned about payout annuities. In this section, you will learn about conventional loans (also called amortized loans or installment loans). Examples include auto loans and home mortgages. These techniques do not apply to payday loans, add-on loans, or other loan types where the interest is calculated up front.

One great thing about loans is that they use exactly the same formula as a payout annuity. To see why, imagine that you had \$10,000 invested at a bank and started taking out payments while earning interest as part of a payout annuity. After 5 years, your balance was zero. Flip that around, and imagine that you are acting as the bank, and a car lender is acting as you. The car lender invests \$10,000 in you. Since you are acting as the bank, you pay interest. The car lender takes payments until the balance is zero.

Student Loans

When it comes to taking out loans for college, there are three major options: federal loans made by the government, federal loans made by banks or other lenders, or private loans. A student's first choice should be the federal loans, since they have the greatest stability. Federal loans have fixed interest rates for life and are regulated by Congress. To be eligible for these types of loans, a student must file their FAFSA yearly.

Student loans differ from traditional loans in the fact that in most cases, payments are deferred until after graduation. Meaning that payments don't start until after you graduate college. However, that doesn't mean that it won't accrue interest during that time. Typically speaking, the standard term on a student loan is 10 years with payments deferred until 6 months after graduation.

One nice thing about student loans is that the interest only accrues on the principal balance (simple interest). In a subsidized federal loan, the federal government covers the interest while the student is still in college. But, if interest accrues while the student is still in college, this is called an unsubsidized loan.

Unsubsidized loans will accrue interest while the student is still in college as stated above. When this happens, the loan can either be capitalized or not capitalized. In a capitalized loan, the student is not expected to pay for the interest while attending college. Instead, that interest is added onto the principle balance and will be paid after graduation. If the loan is not capitalized, then the student is required to pay for only the interest while they attend college. Both of these options have their advantages and disadvantages. It all really depends on the student.

Example 1: Student Loan Analysis

Max borrows \$6,500 for her last 3 years of college, acquiring an unsubsidized federal student loan at 6.2% interest.

  • How much interest does Max accrue while attending college?
  • What would Max's monthly payment and total amount paid be if the loan was capitalized?
  • What would Max's monthly payment and total amount paid be if the loan was uncapitalized?

Solution

Part 1: Interest During College

Since interest that accrues on a student loan while in college is simple interest, we'd use the formula $I = Prt$

$P = \$6,500$

$r = 0.062$ (6.2% as a decimal)

$t = 3$ years

$$I = Prt = \$6,500(0.062)(3) = \$1,209$$

Max accrued $1,209 in interest over the 3 years from the loan not being subsidized.

Part 2: Capitalized Loan

Capitalized means that Max does not have to pay the interest while attending college. When she starts to make payments, her new principal would be the amount that she originally borrowed plus the interest that accrued while attending college:

$$P = \$6,500 + \$1,209 = \$7,709$$

The interest rate would stay the same at $r = 0.062$ and the time would be ten years, as that is the traditional student loan length. Substituting this all into the monthly payment formula would yield:

$$M = \frac{P\left(\frac{r}{12}\right)}{1 - \left(1 + \frac{r}{12}\right)^{-12t}}$$ $$M = \frac{7,709\left(\frac{0.062}{12}\right)}{1 - \left(1 + \frac{0.062}{12}\right)^{-12(10)}}$$ $$M = \frac{39.82983\overline{3}}{1 - (1.00516\overline{6})^{-120}}$$ $$M = \frac{39.82983\overline{3}}{1 - 0.5388037746}$$ $$M = \frac{39.82983\overline{3}}{0.4611962254}$$ $$M = \$86.36$$

With the capitalized loan, Max would pay a total of $86.36 a month for 10 years:

$$12(10)(86.36) = \$10,363.20$$

Meaning that Max would have paid back a total of $10,363.20 by the time she pays off her loan.

Part 3: Uncapitalized Loan

If Max's loan was not capitalized, meaning she paid for the interest while she was attending college, the amount she has to pay back after graduation would be her original loan amount of $P = \$6,500$. When substituted into the monthly payment formula, her monthly payment would be:

$$M = \frac{\$6,500\left(\frac{0.062}{12}\right)}{1 - \left(1 + \frac{0.062}{12}\right)^{-12(10)}}$$ $$M = \frac{33.5833\overline{3}}{1 - (1.00516\overline{6})^{-120}}$$ $$M = \frac{33.5833\overline{3}}{1 - 0.5388037746}$$ $$M = \frac{33.5833\overline{3}}{0.4611962254}$$ $$M = \$72.82$$

Since she paid the interest while attending college, the total amount she paid back for the loan would be:

$$12(10)(72.82) + 1,209 = \$9,947.40$$

This option would save Max $\$10,363.20 - \$9,947.40 = \$415.80$.

Home Loans

At some point in time, you will most likely need to take out a loan for a home, known as a mortgage. A mortgage is a long-term loan with terms typically being 15 years or 30 years long, but could be a number of different lengths from 10 to 30 years. If you fail to make the payments during that time, the lender has the right to seize the property.

When acquiring a mortgage, there are two different types to consider. A fixed-rate mortgage is a mortgage in which the interest rate remains constant for the entire term of the loan. You may also consider an adjustable-rate mortgage, in which the interest rate can fluctuate during the period of the loan. Both types have their pros and cons. It all really depends on your credit score, down payment, and finances. Interests on mortgages are calculated using simple interest.

Example 2: Home Mortgage Calculation

The Conner family is looking to purchase a home for $159,000, and have been offered a 30-year fixed-rate mortgage at 5.5% interest with a 20% down payment. Calculate their down payment and monthly payment.

Solution

First, we need to calculate the down payment:

$$0.20(\$159,000) = \$31,800$$

Once we have that amount, we can figure out how much money we need to ask the bank to borrow. After all, you don't want to have to pay interest on a payment you already made. The Conners will need to finance $\$159,000 - \$31,800 = \$127,200$.

Next, we will calculate their monthly payment:

$$M = \frac{P\left(\frac{r}{12}\right)}{1 - \left(1 + \frac{r}{12}\right)^{-12t}}$$ $$M = \frac{\$127,200\left(\frac{0.055}{12}\right)}{1 - \left(1 + \frac{0.055}{12}\right)^{-12(30)}}$$ $$M = \frac{583}{1 - (1.00458\overline{3})^{-360}}$$ $$M = \frac{583}{1 - 0.1927752523}$$ $$M = \frac{583}{0.8072247477}$$ $$M = \$722.23$$

This means by the end of the 30 year term, the Conners will have paid $360(\$722.23) + \$31,800 = \$291,802.80$ for their $159,000 home.

Remaining Loan Balance

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. Remember that only a portion of your loan payments goes towards the loan balance and another portion goes 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.

Remaining Loan Balance Formula

$$P_0 = \frac{M\left[1 - \left(1 + \frac{r}{12}\right)^{-12n}\right]}{\frac{r}{12}}$$

$P_0$: The remaining balance owed on the loan

$M$: The monthly payment

$n$: The length of the remaining loan in years

$r$: The interest rate as a decimal

Example 3: Remaining Loan Balance

If a mortgage at 6% interest has a monthly payment of $1,000, how much will the borrower still owe when there is 10 years left of the loan?

Solution

This question is asking us to find $P$ the amount of money still owed on the loan, when there is $n = 10$ years left, when the monthly payment $M = \$1,000$ at $r = 0.06$ interest. Substitute these numbers into our equation and simplify:

$$P = \frac{M\left[1 - \left(1 + \frac{r}{12}\right)^{-12n}\right]}{\frac{r}{12}}$$ $$P = \frac{\$1,000\left[1 - \left(1 + \frac{0.06}{12}\right)^{-12(10)}\right]}{\frac{0.06}{12}}$$ $$P = \frac{\$1,000(1 - (1.005)^{-120})}{0.005}$$ $$P = \frac{\$1,000(1 - 0.5496)}{0.005}$$ $$P = \$90,073.45$$

Thus, the person still owes $90,073.45 on their home. It is important to note that we currently don't know how much the initial loan or term was, but that is alright. That wasn't what this question was inquiring about.

Example 4: Remaining Balance After Years of Payments

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

Solution

Before getting into the problem too much, identify the variables given:

$r = 0.04$

$n = 30$

$P_0 = \$180,000$ (note the use of the sub-zero meaning initial value)

With these three variables, we are missing a key variable to use the remaining balance formula. That means we need to first find our monthly payment.

$$M = \frac{P\left(\frac{r}{12}\right)}{1 - \left(1 + \frac{r}{12}\right)^{-12n}}$$ $$M = \frac{\$180,000\left(\frac{0.04}{12}\right)}{1 - \left(1 + \frac{0.04}{12}\right)^{-12(30)}}$$ $$M = \frac{600}{1 - (1.00333\overline{3})^{-360}}$$ $$M = \frac{600}{1 - 0.3017958652}$$ $$M = \frac{600}{0.6982041348}$$ $$M = \$859.35$$

Now we know that the monthly payment that the couple will make is $859.35 for the next 30 years. Assuming the couple is diligent in their payments, we want to find how much they'd still owe after 5 years. That means they would have 25 years of left on their loan.

$$P = \frac{M\left[1 - \left(1 + \frac{r}{12}\right)^{-12n}\right]}{\frac{r}{12}}$$ $$P = \frac{\$859.35\left[1 - \left(1.00333\overline{3}\right)^{-300}\right]}{0.00333\overline{3}}$$ $$P = \frac{\$859.35(1 - 0.369)}{0.00333\overline{3}}$$ $$P = \frac{\$859.35(0.631)}{0.00333\overline{3}}$$ $$P = \$162,830.21$$

Meaning that after making a payment of $859.35 monthly for 5 years, the couple will still owe $162,830.21.

Amortization Schedule

When a person decides they are going to purchase a home, the lender will prepare an amortization schedule. This "schedule" helps break down how each monthly payment will be dispersed. It surprises most first time home buyers when they find out how an amortization schedule works. When you first start making monthly payments, more of your payment goes towards interest than it does towards the principal of the house. The reason for this is the bank (lender) is ensuring they are getting their money back. As time progresses, the borrower will start to pay more for the principal than the interest.

Preparing an Amortization Schedule

  1. Calculate Monthly Interest = (Old Balance)(Annual Interest Rate)$({\frac{1}{12}})$
  2. Calculate Payment on Principal = (Monthly Payment) - (Interest Payment)
  3. New Balance of Principal = (Old Balance) - (Payment: Step 2)

Example 5: Amortization Schedule

The Prestons have a $160,000 mortgage with a 30 year term and a 4.5% interest rate. Prepare the amortization schedule for the first 3 months.

Solution

First, we need to find their monthly payment:

$$M = \frac{P\left(\frac{r}{12}\right)}{1 - \left(1 + \frac{r}{12}\right)^{-12n}}$$ $$M = \frac{\$160,000\left(\frac{0.045}{12}\right)}{1 - \left(1 + \frac{0.045}{12}\right)^{-12(30)}}$$ $$M = \frac{600}{1 - (1.00375)^{-360}}$$ $$M = \frac{600}{1 - 0.259896}$$ $$M = \$810.70$$

Month 1

  1. Monthly Interest: $I = \$160,000(0.045)(\frac{1}{12}) = \$600$
  2. Payment on Principal: $\$810.70 - \$600 = \$210.70$
  3. New Balance: $\$160,000 - \$210.70 = \$159,789.30$

Month 2

  1. Monthly Interest: $I = \$159,789.30(0.045)(\frac{1}{12}) = \$599.21$
  2. Payment on Principal: $\$810.70 - \$599.21 = \$211.49$
  3. New Balance: $\$159,789.30 - \$211.49 = \$159,577.81$

Month 3

  1. Monthly Interest: $I = \$159,577.81(0.045)(\frac{1}{12}) = \$598.42$
  2. Payment on Principal: $\$810.70 - \$598.42 = \$212.28$
  3. New Balance: $\$159,577.81 - \$212.28 = \$159,365.53$

Each month, the amount that goes towards the interest (Step 1) decreases, while the amount that goes towards the principal (Step 2) increases. This process will continue for 357 more months.

Extra Home Expenses

With a fixed-rate mortgage, the monthly payment can still change, but it's not because of the amount that you're paying for the home. It has to do with the extras that the borrower can choose to include. These extras can be escrowed into the monthly payment. What this means is that the borrower pays a bit more each month to account for things like yearly taxes and homeowner's insurance. Both of these are additional costs required by the borrower would typically be paid either semi-annually or annually. While a borrower can have a "fixed-rate mortgage," that only keeps the interest rate from changing on their loan. It doesn't take into account the fluctuation in the other costs.

Example 6

Jose has a monthly payment of $$\$695.89$$ for his $$\$159,000$$ home that he recently purchased. He has found insurance for $$\$742$$ a year, and he knows that taxes are going to run him about $$\$1,890$$ semi-annually. Jose has chosen to have these expenses escrowed into his monthly payment. What can he expect his new monthly payment to be?

Solution

First, we need to find the total extra expenses for the year:
$$\$742 + 2(\$1,890) = \$4,522$$

Then, divide it by 12 to find the monthly amount:
$$\dfrac{\$4,522}{12} = \$376.83$$

Now add that to his monthly payment:
$$\$695.89 + \$376.83 = \$1,072.72$$

This means that Jose is looking at a monthly payment of $$\$1,072.72$$ so his mortgage company can make those extra payments for him and he doesn't have to worry about saving that extra money for the entire year.

Having the lender create an escrow account for the extra expenses is completely optional but should be highly considered. However, the borrower also needs to take the extras into consideration when making a budget. If your budget only allows for you to spend \$700 a month, then your total monthly payment needs to be under that guideline.