Interest Rate Comparison: Simple vs. Compound
Interest Rate Comparison: Simple vs. Compound
Amount at Beginning
--
Period
of Interest Period
Interest Earne,t Ainount at Enil
Perfod
~ 1!:_1 ):------._ .!1:!oo_
for Period of lnte ...,,t
2
-1. . __ __ ·-
, - ---
$ 1,000 $
.
1,100 1,21 0
1 210 1,210(0.J Q) l 3 -
3 ' ------ , 31
•.:.
$1 ,100
:
0
:
•.:
$1 ,210
1
..:
;-~ $T
$1,000
:
f
$1 ,100
...: 3
f
$1 ,210
SOLUTION
Given: P = $24, i = 8% per year, and N = 384 years.
Find: F, based on (a) 8% simple interest and (b) 8% compound i Ere:-est.
(a) With 8% simple interest,
IIUIU~
Suppose you are offered the alternative of receiving either $~,000 at ~e ~nd of five Years
:
or P dollars today. There is no question that the $3,000 will be p~1d m full (no risk)
Because you have no current need for the money, you would deposit the P dollars in ·
account that pays 8% interest. What value of P would make you indifferent to yo:
choice between P dollars today and the promise of $3,000 at the end of five years?
STRATEGY: Our job is to determine the present amount that is economically equiva.
lent to $3,000 in five years, given the investment potential _of 8% per_ year. Note that
the statement of the problem assumes that you would exercise the option of using the
earning power of your money by depositing it. The "indifference" ascribed to you
refers to economic indifference; that is, in a marketplace where 8% is the applicable
interest rate, you could trade either cash flow for the other.
SOLUTION
Given: F = $3,000, N = 5 years, and i = 8% per year.
Find: P.
Equation: Eq. (3.3), F = P(I + i)N.
Rearranging terms to solve for P gives
p = F
(1 + i)N
Substituting yields
$3,000
P = -- - = $2042
(1 + 0.08) 5 '
We summarize the problem graphically in Figure 3.6.
$J,oooo -f.
o.o8J ,s
$2,042
0 0
$2,205
I
0 0
$2,381 $2,572 $2,778 $3,000
I
0 1 2 3 4 5
Years
Figure 3 6 y ·
. . anous dollar amounts that w1·n b .
$3,000 m five years oiven an · t e econorrucally equivalent to
' o m erest rate of 8% (Example 3 _3).
Vi
$2,042(1 + 0.08) 3
t
0 1 2
Years
I
I
3 4 5
(a)
$2,572
17 '
I
$3,000
I
I
4 5
0 1 2
Years
(b)
Base period
Equation:
(a) F = P(l + i)N.
(b) P = F(l + i)-N_
Notation: The usual terminology of F and P is confusing in tbis example, since
the cash flow at n = 3 is considered a future sum in part (a) of the solution and a past
cash flow in part (b) of the solution. To simplify matters, we are free to arbitrarily
designate a reference point n = 3 and understand that it need not to be the present.
Therefore, we assign the equivalent cash flow at n = 3 to a single variable, V3.
(a) The equivalent worth of $2,042 after three years is
V3 = 2,042(1 + 0.08) 3
= $2,572
(b) The equivalent worth of the sum $3,000 two years earlier is
V3 = F(l + i)-N
= $3,000(1 + 0.08)-2
= $2,572
(Note that N = 2 beca th .
ing is calculated in duse at !s the number of periods during which discount·
() . . or er to amve back at year 3.)
c While our solut10n doesn't strict! .,
ti me, they will b · Ypr?ve th at the two cash flows are equivalent at :Ul)
e equ1vc1 Ient at any time I
r
• ct.
as ong as we use an interest rate ot S r.
Changing the Interest Rate Oestri
Equivalence
In Example 3.3, we determined that, given an interest rate of 8% per year, receiving
$2,042 today is equivalent to receiving $3,000 in five years. Are these cash flows
also equivalent at an interest rate of 10%?
SOLUTION
Given: P = $2,042, i = 10% per year, and N = 5 years.
Find: F and is it equal to $3,000?
We first determine the base period under which an equivalence value is computed.
Since we can select any period as the base period,)et's select N = 5. Then we need
to calculate the equivalent value of $2,042 today five years from now.
F = $2,042(1 + 0 .10) 5 = $3,289.
Since this amount is greater than $3,000, the chang.. in interest rate breaks the equiv-
alence between the two cash flows.
[ Opdon•
. 1 · End-o f-year repayment of interest, and
Opt•~" . ment at end of loan $100 $100
principal repay $1 ,100
Option 2: One end-of-loan repayment of both
principal and interest () () -----
1,331
Determine whether these options are equivalent, assuming that the appropriate inter.
est rate for the comparison is 10%.
STRATEGY: Since we pay the principa] after three years in either plan, the repayment
of principal can be removed from our analysis. This is an important point: We can ig.
nore the common elements of alternatives being compared so that we can focus en.
tirely on comparing the interest payments. Notice that under option 1, we will pay a
total of $300 interest, where1:, s nnder option 2, we will pay a total of $331. Before con-
cluding that we prefer opUo::., L , rc.::member that a comparison of the two cash flows is
based on a combination rJJ" pafnent amounts and the timing of those payments. To
make our comparison, we must compare the equivalent value of each option at a sin-
gle point in time. Since option 2 is already a single payment at n = 3 years, it is sim-
plest to convert the cash flow pattern of option 1 to a single value at n = 3. To do this,
we must convert the three disbursements of option 1 to their respective equivalent val-
ues at n = 3. At that point, since they share a time in ccrnr,1on. vve can simply sum
them in order to compare them with the $331 sum in opdcn 2 ,'. Figure 3.8).
SOLUTION
Given: Interest payment series; i = 10% per year.
Find: A single future value F of the flows in option I.
Equation: F P(l + i)N, applied to each disbursement in the cash flow diagram.
Nin Eq. (3.3) 1s the number of periods during which interest is in effect and n is the
period number (i.e., for year 1, n = 1). We determine the value of F b~ finding the
interest period for e~ch payment. Thus, for each payment in the series, N can be cal-
3 ~y subtractJng n from the total number of years of the loan (3). That is,
cul"_ted
N - n. Once the value of each payment has been found, we sum the payments.
Option I
0 I Option 2
1-- 2 3 ? 0
l l 1
1 2 3
Figure ) 8 I . . $33 1
. nterest earn,noc f~ ..•
F3 for $100 at n = 1: $100(1 + 0.10) 3 - 1 = $121
F3 for $100 at n = 2: $100(1 + 0.10) 3 - 2 = $110
F3 for $100 at n = 3: $100(1 + 0.10) 3 - 3 = $100
Total = $331
By converting the cash flow in option 1 to a single future payment at year 3, we can
compare options 1 and 2. We see that the two repayment schedules are equivalent. Thus,
the bank would be economically indifferent to a choice between the two plans. Note that
the final interest payment in option 1 does not accrue any compound interest.
Interest Rate and Economic Equivalence
SOLUTION
Given: P = $2,000, i = 10% per year, and N = 8 years (Figure 3.11).
Find: F.
We can solve this problem in any of three ways.
i = 10%
•
I
I
I
I
0 I
!
I I I I I I I I
1 2 3 4 5 6 7 8
Years
$2,000
1. Using a calculator. You can simply use a calculator to evaluate the ( I + it fac-
tor (financial calculators are pre-programmed to solve most future-value problems):
F = $2,000(1 + 0.10) 8
= $4,287.18
2. Using compound-interest tables. The interest tables can be used to locate the
compound-amount factor for i = 10% and N = 8. The number you get can be
substituted into the equation. Compound-'interest tables are included as Appendix
B of this book. From the tables, we obtain
F = $2,000(F / P, 10%, 8) = $2,000(2.1436) = $4,287.20
This is essentially identical to the value obtained by the direct evaluation of the
single-cash-flow compound-amount factor. The slight difference is due to round-
ing errors in the table.
3. Using Excel. Many financial software programs for solving compound-inter~SI
problems are available for use with personal computers. Excel provides financial
funcLions to evaluate various interest formulas where the future-worth calcula·
tion looks like Figure 3.12. '
A B
1 p $ 2,000
2 N 8
3 i 10%
4
5 F $4,287 .18 =FV(10%,8,0,-2000)
Suppose that $1,000 is to be received in five years. At an annual interest rate of 12%,
what is the present worth of this amount?
SOLUTION
Given: F = $1,000, i = 12% per year, and N = 5 years.
Find: P.
P = $1,000(1 + 0.12)-5 = $1,000(0.56743) = $567.43.
Using a calculator may be the best way to 1nake-this s1tnpte calculation. To have $1,000
in your savings account at the end of five year:,'., rnust deposit $567 .43 now. yr,u.
We can also use the interest tables to find that
(0.56743 )
A B
1 F $ 1,000
2 i 12%
3 N 5
4
5 p $567.43~ =PV(12%,5,0,-1000)
Suppose you buy a share of stock for $20 and sell it for $40. Then your profit is $
If that happens within a year, your rate of return is an impressive l OOo/,. 20
( $20 /$20 = I). If it takes five years, what would be the average annual rate of re~
turn on your investment? (See Figure 3.14.)
$20
i= ?
0
1 2 3 4 5
Years
$10
A B
1 F $ 40.00
2 p $ 20.00
3 N 5
4 , =RATE(5,0, -20,40)
5 ; 14.87%
$12,000
!
0 i = 20%
I I - - - N =?
I I
$6,000
SOLUTION
Given: P = $6,000, F = $12,000, and i = 20% per year.
Find: N (years).
Using the single-payment compound-amount factor, we write
F = P(I + i)N = P(F/P,i,N)
A B
1 F $ 12,000
2 p $ 6,000
3 ; 20%
4
5 N 3.80 - =NPER(20% ,0,-6000,12000)
COMMENTS: A very handy rule of thumb, called the Ruk. of 72, estimates approximatr
ly how long it will take for a sum of money to double. '} 1:e rule states that, to find th
time it takes for a present sum of money to grow by a factor of two, we divide 72 byth
interest rate. In our example, the interest rate is 20%. Therefore, the Rule of72 indicalc:
72 /20 = 3.60, or roughly four years, for a sum to double. This is, in fact, relativtl)
close to our exact solution. Figure 3.18 illustrates the approximate number of years r,-
quired to double an investment at various interest rates using the Rule of 72.
18
years
Imagine! If you were to nvest
at a higher rate, you'd de uble
money that much faster!
12
years
9
years
6
years 5.14
years
4% 6% 8% 10% 12% 14%
Pres
Wilson Technology, a growing machine shop, wishes to set aside money now to in-
vest over the next four years to use to automate its customer service department. The
company can earn 10% on a lump sum deposited now, and it wishes to withdraw the
money in the following increments.
Year 1: $25,000 to purchase a computer and database software designed for
customer service use.
Year 2: $3,000 to purchase additional haTdware to accommodate anticipated
growth in use of the system.
Year 3: No expenses .
Year 4: $5,000 to purchase software upgrades.
How much money must be deposited now to cover the anticipated payments over the
next four years? Assume each withdrawal and payment to occur at the end of each
year.
STRATEGY: This problem is equivalent to asking what value of P would make you in-
different in your choice between P dollars today and the future expense stream
($25,000, $3,000, $0, and $5,000). One way to deal with an uneven series of cash
flows is to calculate the equivalent present value of each single cash flow and to sum
the present values to find P. In other words, the cash flow is broken into three parts,
as shown in Figure 3 .19.
SOLUTION
Given: Uneven cash flow in Figure 3.19 with i = 10% per year.
Find: P.
P = $25,000(P /F, 10%, 1) + $3,000(P /F , 10%, 2)
+ $5,000(P / F, 10%, 4)
= $28,622
lAPTER 3 Interest Rate and Economic Equivalence
$25,000
$3,000 $5,000
0
I 1 2 3 4
I
I Years
=
I
0
$25,000 p
D
$3,000 $5,000
I 1 2 3 4
+
0
I I + I I +
0
I I I I
j
1 2
' n
3 4
n
I I 1 2 3 4
y
t
P1
P1 = $25,000(PIF, 10%, 1)
= $22,727
Pz
P4
n
Pz = $3,000(PIF, 10%, 2) P4 = $5,000(PIF, 10%, 4)
= $2,479 = $3,415
P= P1 + P2 + P4 = $28,622
COMMENTS: To see if $28,622 is indeed sufficient, let's calculate the balance at the
end of each year. If you deposit $28,622 now, it will grow to (1.10)($28,622), or
$31,484, at the end of year 1. From this balance, you pay out $25,000. The remain-
ing balance, $6,484, will again grow to (1.10)($6,484), or $7,132, at the end of year
2. Now you make the second payment ($3,000) out of this balance, which will leave
you with only $4,132 at the end of year 2. Since no payment occurs in year 3, the
balance will grow to (1.10)2($4,132) , or $5,000, at the end of year 4. The final
-
withdrawal in the amount of $5,000 will deplete the balance completely.
1 2 3 4 5
$300
$400
$500
$300(F /P, 5%, l)(F /P, 6%, 2)(F /P, 4%, 2) = $382.82
Balance at n = 3
Balance at n= 5
Balance at n=5
2
Source: [Link] [Link]/news/locker-room/cc-sabathias-new- l 61-mi 11 ion-contract-includes-
9-mi Ili on-signing-bonus/
With the salary and signing bonus paid at the end of each season, the net
al payment schedule looks like Table 3.3. annu.
2008 $6,000,000
$14,000,000 $3,000,000 $17,000,000
2009
$23,000,000 $23,000,000
2010
$23,000,000 $23,000,000
2011
$23,000,000 $23,000,000
2012
2013 $23,000,000 $23,000,000
How much is Sabathia's contract actually worth at the time of signing? Assume
that Sabathia's interest rate is 6% per year and payments are made at the end of
each season.
SOLUTION
Given: Payment series given in Figure 3.21 , with i = 6% per year.
Find: P.
$6M
Figure 3.21 A cash flow diagram for Sabathia's contract with the
New York Yankees.
COMMENTS: Unlike most players, Sabathia will have his salary paid in semimonthly
installments over all 12 months of the year, meaning he will have received six pay-
ments of $583,333 before opening day, April 6. In Chapter 4, we will consider equiv-
alence calculations with these more frequent payments.
l:lniforrn Serie ;,
Suppose you make an annual contribution of $3,000 to your savings account at the
end of each year for 10 years. If the account earns 7% interest annually, how much
can be withdrawn at the end of 10 years (Figure 3.23)?
SOLUTION
Given : A = $3,000, N = IO years, and i = 7% per year.
Find: F .
r
i= 7% Years I
0 1 2 3 4 5 6 7 8 9
l l l l l l l l l
A= $3,000
1
2
3 $3,000.00 $5,515.38
4 $3 ,000 .00 $5,154.56
5 $3,000.00 $4,817.34
6 $3 ,000.00 $4,502.19
7 $3,000 .00 $4 ,207.66
8 $3,000.00 $3,932 .39
9 $3 ,000.00 $3,675.13
10 8 $3 ,000 .00 $3,434.70
9 $3,000.00 $3,210.00
10 $3,000.00 $3,000.00
=F\1(7% ,10, -3000)
SOLUTION
Given: Cash flow as shown in Figure 3.25, and i = 7% per year.
Find: F 10 .
i=7% F
i
First deposit occurs at n = 0 I
Years I
(D
1 2 3 4 5 6 7 8 9 •10
I
+ + l l l A= $3,000
+ + l l
Figure 3.25 Cash flow diagram (Example 3.15).
· Ienee
'TER 3 Interest Rate and Economic Equiva
=FV(7% ,10,-3000,0,1)
COMMENTS: Another way to determine the ending balance is to compare the 1'//
cash flow patterns. By adding the $3,000 deposit at period 0 to the original cash fl~
and subtracting the $3,000 deposit at the end of period 10, we obtain the second [Link]
flow. Therefore, the ending balance can be found by making the following adjll5!.
ment to the $41,449.20:
SOLUTION
Given: F = $1,428,747, N = 65 - n, and i = 7% per year.
Find: A.
The required annual contribution as a function of starting age n can be determined as
For example, if you wait even three years (or age 23), your annual contributions
would have to increase to nearly $6,195 to save that same amount by age 65. And if you
were to wait until age 40, you'd have to contribute nearly $22,589 a year! Figure 3.26
illustrates the general trend of required annual contributions and Table 3.4 illustrates the
cost of procrastination at each age.
$12,963
f v--===~·$8,911
Number of years delayed
u
0
• $6,195
23 28 33 38
Starting age of contribution
C I D I E
B I
A
.... •.
.. ...
1 '
2 I I Annaul I Investm ent I Final
3 Start I End I Contribution I Return I Value
,. •~·i ;.ti/.-.: ,,,.:~J~,:-Y~ •. .· '· .,. '",•''
4
65 $4,339.73 7% $1,428,747
5 18
6 19 65 $4,657.66 7% $1,428 ,747
7 20 65 $5,000 .00 7% $1,428,747
8 21 65 $5,368.79 7% $1 ,428,747
9 22 65 $5,766 .27 7% $1,428,747
10 23 65 $6,194 .91 7% $1,428,747
11 24 65 $6,657 .42 7% $1,428 ,747
12 25 65 $7,156.79 7% $1,428 ,747
13 26 65 $7,696.32 7% $1,428,747
14 27 65 $8,279 .66 7% $1,428,747
15 28 65 $8,910 .88 7% $1,428,747
16 29 65 $9,594 .48 . 7% $1,428 ,747
17 30 65 $10,335.49 7% $1,428,747
18 31 65 $ 11,139.56 7% $1 ,428,747
19 32 65 $12,012.99 7% $1,428,747
20 33 65 $12,962.90 7% $1 ,428 ,747
21 34 65 $ 13,997.30 7% $1,428,747
-
22 35 65 $15,1 25.29 7% _______ $1,428 .747 _
23 36 65 $16,357.22 7% $ 1 ,42 ,2,. 74 7
24 37 65 $17,704 .92 1% --·--1- ______ _$ 1 A:?.f; ,7./4~ - I
25 38 65 $ 19,181 .97 7% l . i ,L!2S ,7•i7 ,
-·-·-·:=~--:
----- -
26 39 65 $20,804.02 7% i S 1·.~,28,7 47 _\
27
28
40 65 $22,589.22
J;~~.;:t,...-...,s,rJ'-': '§•::-· · """'
,,,~ ,. -..wi
u ,,
:'• 747,•'<t>i .if, d
.,,.,_;...,~A~-... ~•'
Consider three investment plans for an individual who just celebrated his 24th birth-
day at an annual interest rate of 8% (Figure 3.27):
Plan A. Invest $2,000 per year for the first 10 years of your career. At the end of 10
years, make no further investments, but reinvest the amount accumulated at
the end of 10 years for the next 31 years.
Plan B. Do nothing for the first 10 years. Then start investing $2,000 per year for
the next 31 years.
Plan C. Invest $2,000 per year for the entire 41 years.
Note that all investments are made at the birthday of each year; the first deposit will
be made on the 25th birthday ( n = l), and you want to calculate the balance on the
65th birthday (n = 41 ).
Investor A
012345678910 4041
r
lllll!!lll
I I
I
$2,000
Investor B tF
llllllll[. . . lllllllllll
0 1 2 3 4 5 6 7 8 9 101112 4041
I I I I I I I I I I I
$2,
Investor C tF
0 1 2 3 4 5 6 7 8 9 10 4041
SOLUTION
Given: Three different deposit scenarios with i = 8% aild 1V = 41 years.
Find: Balance at the end of 41 years (or on the 65th birthday ).
Plan A:
Balance at the end of IO years
= $314,870.34
Plan B:
F65 = $2,000(F / A, 8%, 31)
$246,691.74
= $246,691.74
Plan C:
F6s = $2,000(F / A, 8%, 41)
$561,562.08
= $561,562.08
To illustrate your balance changes at the end of each year, you may want to construct
a tableau such as the one shown in Table 3.5. Note that, due to rounding errors, the
final balance figures can be slightly off from those calculated by interest fo rmulas.