Chapter 4 Finance

4.5 Multistage Finance Problems

Learning Objectives

By the end of this section, you will be able to:

  • Recognize the type of finance problem given a situation
  • Break complex finance problems into smaller, simpler pieces

Which Equation to Use?

When presented with a finance problem (on an exam or in real life), you’re usually not told what type of problem it is or which equation to use. Here are some hints on deciding which equation to use based on the wording of the problem.

The easiest types of problem to identify are loans. Loan problems almost always include words like “loan,” “amortize” (the fancy word for loans), “finance (a car),” or “mortgage” (a home loan). Look for these words. If they’re there, you’re probably looking at a loan problem. To make sure, see if you’re given what your monthly (or annual) payment is or if you’re trying to find a monthly payment.

If the problem is not a loan, the next question you want to ask is, “Am I putting money in an account and letting it sit, or am I making regular (monthly/annually/quarterly) payments or withdrawals?” If you’re letting the money sit in the account with nothing but interest changing the balance, then you’re looking at a compound interest problem. The exception would be bonds and other investments where the interest is not reinvested; in those cases you’re looking at simple interest.

If you’re making regular payments or withdrawals, the next question is, “Am I putting money into the account, or am I pulling money out?” If you’re putting money into the account on a regular basis (monthly/annually/quarterly), then you’re looking at a basic annuity problem. Basic annuities are when you are saving money. Usually in an annuity problem, your account starts empty and has money in the future.

If you’re pulling money out of the account on a regular basis, then you’re looking at a payout annuity problem. Payout annuities are used for things like retirement income, where you start with money in your account, pull money out on a regular basis, and your account ends up empty in the future.

Remember, the most important part of answering any kind of question, money or otherwise, is first to correctly identify what the question is really asking and to determine what approach will best allow you to solve the problem.

Exercise 1

For each of the following scenarios, determine if it is a compound interest problem, a savings annuity problem, a payout annuity problem, or a loans problem. Then solve each problem.

  1. Marcy received an inheritance of $20,000 and invested it at 6% interest. She is going to use it for college, withdrawing money for tuition and expenses each quarter. How much can she take out each quarter if she has 3 years of school left?
  2. Paul wants to buy a new car. Rather than take out a loan, he decides to save $200 a month in an account earning 3% interest compounded monthly. How much will he have saved up after 3 years?
  3. Keisha is managing investments for a nonprofit company. They want to invest some money in an account earning 5% interest compounded annually with the goal to have $30,000 in the account in 6 years. How much should Keisha deposit into the account?
  4. Miao is going to finance new office equipment at a 2% rate over a 4-year term. If she can afford monthly payments of $100, how much new equipment can she buy?
  5. How much would you need to save every month in an account earning 4% interest to have $5,000 saved up in 2 years?
Solution
  1. This is an annuity problem. She can pull out $1833.60 a quarter.
  2. This is a savings annuity problem. He will have saved up $7,524.11.
  3. This is a compound interest problem. She would need to deposit $22,386.46.
  4. This is a loans problem. She can buy $4,609.33 of new equipment.
  5. This is a savings annuity problem. You would need to save $200.46 each month.

Multistage Problems

Many finance problems in real life can’t be solved using a single application of any of the finance formulas we have learned in the prior sections. Instead, we have to combine multiple calculations. The calculations can continue to be done using formulas, but oftentimes people will use calculators with specialty functions for doing the calculations. In this section we determine the values needed to use the formulas but do not show the details of the solving; you could instead solve each portion using a specialty calculator if you have access to one.

Example 1

Suppose you deposited $15,000 into a bank account offering a special 6% APR. After 1 year, they lower the promotional APR to 4%, then 2 years after that lower it again to 2.5%. If the account compounds monthly, what will your account balance be 6 years after the initial deposit?

We can imagine this situation as three distinct time phases, each with a different interest rate.

A timeline that starts with $15,000 and ends with $???. There are three time intervals for 1 year, 2 years, and 3 years.
Figure 1. Timeline of interest rates

To handle the change of interest rates, it is easiest to imagine that each time the interest rate changes, we withdraw all our money and then redeposit it into a new account at a different rate.

For the first year:

[latex]P = $15,000, r = 0.06, t = 1 \text{ year}, k = 12[/latex]

Using the compound interest equation, we find the balance after 1 year would be:

[latex]A = $15,925.17[/latex]

We can then use this as the principal for the next 2 years at a different rate, as if we had withdrawn that money and reinvested it at 4%:

[latex]P = $15,925.17, r = 0.04, t = 2 \text{ years}, k = 12[/latex]

Using the compound interest equation, we find the balance after these next 2 years would be:

[latex]A = $17,249.24[/latex]

Using that as the principal for the last 3 years:

[latex]P = $17,249.24, r = 0.025, t = 3 \text{ years}, k = 12[/latex]

Using the compound interest equation, we find the balance at the end would be:

[latex]A = $18,591.23[/latex]

After the 6 years, the final balance would be $18,591.23.

Example 2

Jenny plans to retire at age 65 and estimates she will need $48,000 a year in retirement for 30 years. To save for retirement, she plans to put money every month into her 401(k) plan at work. If Jenny is currently 25, how much will she need to save each month to meet her retirement goal, assuming her retirement accounts earn an average of 7% per year?

We can think about this as two separate phases: the accumulation phase and the spending phase. We assume Jenny starts with no money in the beginning and will completely spend down her account by the time she’s 95.

A timeline that starts with $0 at age 25 and ends with $0 at age 95. $??? is in the middle at age 65.
Figure 2. Timeline of phases

To decide which phase to start with, we look to see which we have the most information for. In the first phase, we don’t know how much she will save each month, and we don’t know the ending balance of the account. For the second phase, we know everything except the starting balance of the account, so we will start the problem in the second phase. Basically, we are going to work the problem backward, using her spending requirement to determine how much she needs at retirement, then use that value to determine how much she needs to save each month.

The second phase is a payout annuity problem, where:

[latex]w = $4,000, r = 0.07, t = 30, k = 12[/latex]

Using the payout annuity formula to find the principal gives:

[latex]P = $601,230.27[/latex]

This is how much Jenny will need at retirement to meet her spending needs and fills in a part of our timeline:

A timeline that starts with $0 at age 25 and ends with $0 at age 95. $601,230.27 is in the middle at age 65.
Figure 3. Timeline of phases

Now we can work on the first phase, which is a savings annuity problem where the desired end balance is the $601,230.27 we just found.

[latex]A = $601,230.27, r = 0.07, t = 40, k = 12[/latex]

Using the savings annuity formula to solve for the deposit amount gives:

[latex]d = 229.06[/latex]

Jenny will need to save $229.06 per month to meet her retirement goals.

To work this problem using the TVM Solver calculator, click here.

Example 3

Ula just got a new job. She had $70,000 in a 401(k) at her old job that she rolled over into an IRA. She plans to continue contributing $5,000 a year into her IRA. If her account earns 6% compounded annually, how much will she have in her IRA in 10 years?

The challenge with this problem is that our savings annuity formula assumed that our account balance started at zero. While we could try to build a new formula to handle this situation, we can more easily envision it as two different money streams, as if the original $70,000 is invested in a different account than future contributions.

A timeline that starts with $70,000 and ends with $???. The end time is 10 years.
Figure 4. Timeline of savings
A timeline that starts with $70,000 and ends with $???. The end time is 10 years. Over the line says, "Deposit $5,000 per year."
Figure 5. Timeline of savings

In the first stream of money, we have $70,000 earning 6% interest for 10 years, which is a basic compound interest problem:

[latex]P = $70,000, r = 0.06, t = 10, k = 1[/latex]

Using the compound interest formula to solve for the ending balance:

[latex]A = $125,359.34[/latex]

In the second stream of money, we are depositing $5,000 a year, a savings annuity problem:

[latex]d = $5,000, r = 0.06, t = 10, k = 1[/latex]

Using the savings annuity formula to find the ending balance:

[latex]A = $65,903.97[/latex]

Now that we know the ending balance of each stream of money, we can add those together to find the total balance of the account at the end of the 10 years:

[latex]$125,359.34 + $65,903.97 = $191,263.31[/latex]

To work this problem using the TVM Solver calculator, click here.

Example 4

Five years ago a couple purchased a home for $260,000, making a 20% down payment and financing the rest with a 30-year adjustable rate mortgage fixed at 3% for the first 5 years. Now that the fixed rate period is up, the couple is facing a higher adjustable rate. They now plan to refinance into a fixed rate 30-year mortgage at 4%. What will their new monthly payments be? Assume there are no costs associated with the refinance.

To determine the monthly payments for the refinance, we first need to know how much the refinanced loan amount will be. The amount refinanced will be the same as the remaining loan balance on the original loan after 5 years. We will start by finding the details of the original loan.

The 20% down payment will be [latex]$260,000(0.20) = $52,000[/latex], leaving $208,000 to be financed.

We start by finding the payments on the original loan:

[latex]P = $208,000, r = 0.03, t = 30, k = 12[/latex]

Using the loan formula to solve for the payment,

[latex]PMT = $876.94[/latex]

Now we can find the remaining balance on the original loan after 5 years. As discussed in the last section, we can find this by determining the amount of loan that can be paid off with payments of $876.94 in the remaining 25 years:

[latex]PMT = $876.94, r = 0.03, t = 25, k = 12[/latex]

Using the loan formula to solve for the remaining balance,

[latex]P = $184,926.00[/latex]

So after 5 years, the remaining balance on the loan is $184,926.00, and that is the amount we will refinance in a new 30-year mortgage at the fixed 4% rate:

[latex]P = $184,926.00, r = 0.04, t = 30, k = 12[/latex]

Solving for the new payment amount:

[latex]PMT = $882.87[/latex]

Because of the higher interest rate, the monthly payment increased even though the loan amount was less at refinance. Most likely this increase is much smaller than the one the couple would have faced from the original loan’s rate adjusting.

Notice also that because of the refinance, the couple will end up making payments for a total of 35 years on the house.

In those first 5 years, the couple paid a total of [latex]$876.94(12)(5) = $52,616.40[/latex] and reduced the loan balance by [latex]$208,000 - $184,926 = $23,074[/latex], meaning they paid $29,542.40 in interest during the first 5 years.

In the remaining 30 years, the couple will pay [latex]$882.87(12)(30) = $317,833.20[/latex] and reduce the loan balance by $184,926, meaning they will pay $132,907.20 in interest during these 30 years.

In total, the couple will pay [latex]$132,907.20 + $29,542.40 = $162,449.60[/latex] in interest over the 35 years.

To work this problem using the TVM Solver calculator, click here.

License

Icon for the Creative Commons Attribution-ShareAlike 4.0 International License

Finite Mathematics Copyright © 2024 by LOUIS: The Louisiana Library Network is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book