We have already developed the tools to solve most finance problems. Now we use these tools to solve some additional applications.
PROBLEMS INVOLVING MULTIPLE STAGES OF SAVINGS AND/OR ANNUITIES
Consider the following situations:
- Suppose a baby, Aisha, is born and her grandparents invest $5000 in a college fund. The money remains invested for 18 years until Aisha enters college, and then is withdrawn in equal semiannual payments over the 4 years that Aisha expects to need to finish college. The college investment fund earns 5% interest compounded semiannually. How much money can Aisha withdraw from the account every six months while she is in college?
- Aisha graduates college and starts a job. She saves $1000 each quarter, depositing it into a retirement savings account. Suppose that Aisha saves for 30 years and then retires. At retirement she wants to withdraw money as an annuity that pays a constant amount every month for 25 years. During the savings phase, the retirement account earns 6% interest compounded quarterly. During the annuity payout phase, the retirement account earns 4.8% interest compounded monthly. Calculate Aisha’s monthly retirement annuity payout.
These problems appear complicated. But each can be broken down into two smaller problems involving compound interest on savings or involving annuities. Often the problem involves a savings period followed by an annuity period. ; the accumulated value from first part of the problem may become a present value in the second part. Read each problem carefully to determine what is needed.
Example \(\PageIndex{2}\)
Suppose a baby, Aisha, is born and her grandparents invest $8000 in a college fund. The money remains invested for 18 years until Aisha enters college, and then is withdrawn in equal semiannual payments over the 4 years that Aisha expects to attend college. The college investment fund earns 5% interest compounded semiannually. How much money can Aisha withdraw from the account every six months while she is in college?
Solution
Part 1: Accumulation of College Savings: Find the accumulated value at the end of 18 years of a sum of $8000 invested at 5% compounded semiannually.
\[\begin{array}{l}
A=\$ 8000(1+.05 / 2)^{(2 \times 18)}=\$ 8000(1.025)^{36}=\$ 8000(2.432535) \\
A=\$ 19460.28
\end{array} \nonumber\]
Part 2: Seminannual annuity payout from savings to put toward college expenses. Find the amount of the semiannual payout for four years using the accumulated savings from part 1 of the problem with an interest rate of 5% compounded semiannually.
\(A\)= $19460.28 in Part 1 is the accumulated value at the end of the savings period. This becomes the present value \(P\)=$19460.28 when calculating the semiannual payments in Part 2.
\[\begin{array}{c}
\$ 19460.28\left(1+\frac{.05}{2}\right)^{2 \times 4}=\frac{m\left[\left(1+\frac{05}{2}\right)^{2 \times 4}-1\right]}{(.05 / 2)} \\
\$ 23710.46=m(8.73612) \\
m=\$ 2714.07
\end{array} \nonumber\]
Aisha will be able to withdraw $2714.07 semiannually for her college expenses.
Example \(\PageIndex{3}\)
Aisha graduates college and starts a job. She saves $1000 each quarter, depositing it into a retirement savings account. Suppose that Aisha saves for 30 years and then retires. At retirement she wants to withdraw money as an annuity that pays a constant amount every month for 25 years. During the savings phase, the retirement account earns 6% interest compounded quarterly. During the annuity payout phase, the retirement account earns 4.8% interest compounded monthly. Calculate Aisha’s monthly retirement annuity payout.
Solution
Part 1: Accumulation of Retirement Savings: Find the accumulated value at the end of 30 years of $1000 deposited at the end of each quarter into a retirement savings account earning 6% interest compounded quarterly.
\[\begin{array}{l}
A=\frac{\$ 1000\left[(1+.06 / 4)^{4 \times 30}-1\right]}{(.06 / 4)} \\
A=\$ 331288.19
\end{array} \nonumber\]
Part 2: Monthly retirement annuity payout: Find the amount of the monthly annuity payments for 25 years using the accumulated savings from part 1 of the problem with an interest rate of 4.8% compounded monthly.
\(A\)= $331288.19 in Part 1 is the accumulated value at the end of the savings period. This amount will become the present value \(\mathrm{P}\) =$331288.19 when calculating the monthly retirement annuity payments in Part 2.
\[\begin{array}{l}
\$ 331288.19(1+.048 / 12)^{12 \times 25}=\frac{m\left[(1+.048 / 12)^{12 \times 25}-1\right]}{(.048 / 12)} \\
\$ 1097285.90=m(578.04483) \\
m=\$ 1898.27
\end{array} \nonumber\]
Aisha will have a monthly retirement annuity income of $1898.27 when she retires.
FAIR MARKET VALUE OF A BOND
Whenever a business, and for that matter the U. S. government, needs to raise money it does it by selling bonds. A bond is a certificate of promise that states the terms of the agreement. Usually the business sells bonds for the face amount of $1,000 each for a stated term, a period of time ending at a specified maturity date.
The person who buys the bond, the bondholder, pays $1,000 to buy the bond.
The bondholder is promised two things: First that he will get his $1,000 back at the maturity date, and second that he will receive a fixed amount of interest every six months.
As the market interest rates change, the price of the bond starts to fluctuate. The bonds are bought and sold in the market at their fair market value.
The interest rate a bond pays is fixed, but if the market interest rate goes up, the value of the bond drops since the money invested in the bond could earn more if invested elsewhere. When the value of the bond drops, we say it is trading at a discount.
On the other hand, if the market interest rate drops, the value of the bond goes up since the bond now yields a higher return than the market interest rate, and we say it is trading at a premium.
Example \(\PageIndex{4}\)
The Orange Computer Company needs to raise money to expand. It issues a 10-year $1,000 bond that pays $30 every six months. If the current market interest rate is 7%, what is the fair market value of the bond?
Solution
The bond certificate promises us two things - An amount of $1,000 to be paid in 10 years, and a semi-annual payment of $30 for ten years. Therefore, to find the fair market value of the bond, we need to find the present value of the lump sum of $1,000 we are to receive in 10 years, as well as, the present value of the $30 semi-annual payments for the 10 years.
We will let P1 = the present value of the face amount of $1,000
\[P_{1}(1+.07 / 2)^{20}=\$ 1,000 \nonumber\]
Since the interest is paid twice a year, the interest is compounded twice a year and \(nt\) = 2(10)=20
\[\begin{array}{l}
P_{1}(1.9898)=\$ 1,000 \\
P_{1}=\$ 502.56
\end{array} \nonumber\]
We will let P2 = the present value of the $30 semi-annual payments is
\[\begin{aligned}
\mathrm{P}_{2}(1+.07 / 2)^{20} &=\frac{\$ 30\left[(1+.07 / 2)^{20}-1\right]}{(.07 / 2)} \\
\mathrm{P}_{2}(1.9898) &=848.39 \\
\mathrm{P}_{2} &=\$ 426.37
\end{aligned} \nonumber\]
The present value of the lump-sum $1,000 = $502.56
The present value of the $30 semi-annual payments = $426.37
The fair market value of the bond is P = P1+ P2 = $502.56 + $426.37 = $928.93
Note that because the market interest rate of 7% is higher than the bond’s implied interest rate of 6% implied by the semiannual payments, the bond is selling at a discount; its fair market value of $928.93 is less than its face value of $1000.
Example \(\PageIndex{5}\)
A state issues a 15 year $1000 bond that pays $25 every six months. If the current market interest rate is 4%, what is the fair market value of the bond?
Solution
The bond certificate promises two things - an amount of $1,000 to be paid in 15 years, and semi-annual payments of $25 for 15 years. To find the fair market value of the bond, we find the present value of the $1,000 face value we are to receive in 15 years and add it to the present value of the $25 semi-annual payments for the 15 years. In this example, \(nt = 2(15)=30\).
We will let P1 = the present value of the lump-sum $1,000
\[\begin{array}{l}
\mathrm{P}_{1}(1+.04 / 2)^{30}=\$ 1,000 \\
\mathrm{P}_{1}=\$ 552.07
\end{array} \nonumber\]
We will let P2 = the present value of the $25 semi-annual payments is
\[\begin{array}{l}
\mathrm{P}_{2}(1+.04 / 2)^{30}=\frac{\$ 25\left[(1+.04 / 2)^{30}-1\right]}{(.04 / 2)} \\
\mathrm{P}_{2}(1.18114)=\$ 1014.20 \\
\mathrm{P}_{2}=\$ 559.90
\end{array} \nonumber\]
The present value of the lump-sum $1,000 = $552.07
The present value of the $30 semi-annual payments = $559.90
Therefore, the fair market value of the bond is
\[P=P_{1} + P_{2}=\$ 552.07+\$ 559.90=\$ 1111.97\nonumber\]
Because the market interest rate of 4% is lower than the interest rate of 5% implied by the semiannual payments, the bond is selling at a premium: the fair market value of $1,111.97 is more than the face value of $1,000.
To summarize:
To find the Fair Market Value of a Bond
Find the present value of the face amount \(\mathrm{A}\) that is payable at the maturity date:
\[\mathbf{A}=\mathbf{P}_{1}(\mathbf{1}+\mathbf{r} / \mathbf{n})^{\mathbf{n} \mathbf{t}} ; \text { solve to find } \mathrm{P}_{1}\]
Find the present value of the semiannually payments of $\(m\) over the term of the bond:
\[\mathbf{P}_{2}(\mathbf{1}+\mathbf{r} / \mathbf{n})^{\mathbf{n} \mathbf{t}}=\frac{\mathbf{m}\left[(\mathbf{1}+\mathbf{r} / \mathbf{n})^{\mathbf{n} \mathbf{t}}-\mathbf{1}\right]}{\mathbf{r} / \mathbf{n}} \quad ; \text { solve to find } \mathbf{P}_{2} \]
The fair market value (or present value or price or current value) of the bond is the sum of the present values calculated above:
\[\mathrm{P}=\mathbf{P}_{1}+\mathbf{P}_{2} \]
AMORTIZATION SCHEDULE FOR A LOAN
An amortization schedule is a table that lists all payments on a loan, splits them into the portion devoted to interest and the portion that is applied to repay principal, and calculates the outstanding balance on the loan after each payment is made.
Example \(\PageIndex{6}\)
An amount of $500 is borrowed for 6 months at a rate of 12%. Make an amortization schedule showing the monthly payment, the monthly interest on the outstanding balance, the portion of the payment contributing toward reducing the debt, and the outstanding balance.
Solution
The reader can verify that the monthly payment is $86.27.
The first month, the outstanding balance is $500, and therefore, the monthly interest on the outstanding balance is
(outstanding balance)(the monthly interest rate) = ($500)(.12/12) = $5
This means, the first month, out of the $86.27 payment, $5 goes toward the interest and the remaining $81.27 toward the balance leaving a new balance of $500 - $81.27 = $418.73.
Similarly, the second month, the outstanding balance is $418.73, and the monthly interest on the outstanding balance is ($418.73)(.12/12) = $4.19. Again, out of the $86.27 payment, $4.19 goes toward the interest and the remaining $82.08 toward the balance leaving a new balance of $418.73 - $82.08 = $336.65. The process continues in the table below.
|
Payment #
|
Payment
|
Interest
|
Debt Payment
|
Balance
|
|
1
|
$86.27
|
$5
|
$81.27
|
$418.73
|
|
2
|
$86.27
|
$4.19
|
$82.08
|
$336.65
|
|
3
|
$86.27
|
$3.37
|
$82.90
|
$253.75
|
|
4
|
$86.27
|
$2.54
|
$83.73
|
$170.02
|
|
5
|
$86.27
|
$1.70
|
$84.57
|
$85.45
|
|
6
|
$86.27
|
$0.85
|
$85.42
|
$0.03
|
Note that the last balance of 3 cents is due to error in rounding off.
An amortization schedule is usually lengthy and tedious to calculate by hand. For example, an amortization schedule for a 30 year mortgage loan with monthly payments would have (12)(30)=360 rows of calculations in the amortization schedule table. A car loan with 5 years of monthly payments would have 12(5)=60 rows of calculations in the amortization schedule table. However it would be straightforward to use a spreadsheet application on a computer to do these repetitive calculations by inputting and copying formulas for the calculations into the cells.
Most of the other applications in this section's problem set are reasonably straightforward, and can be solved by taking a little extra care in interpreting them. And remember, there is often more than one way to solve a problem.
