Chapter 4: Time Value of Money
Chapter 4: Time Value of Money
Chapter 4: Time Value of Money
n
Ln i
−
=
+
$1,000,000 PV $100,000 1 i 1.08 n FV = = + =
ln (1,000,000) ln (100,000)
ln(1.08)
n
−
=
13.82 11.51 30
0.077
years −
==
By Table: 0, ( ) n in FV = PV FVIF
,
0
n
in
FVIF FV
PV
⇒=
8,
1,000,000 10
n 100,000 FVIF = =
From the Table I at i=8 we find that the number of periods that yield 10 FVIF is 30
Or 0, ( ) n in PV = FV PVIF
0
i ,n
n
PVIF PV
FV
⇒=
8,
100,000 0.1
n 1,000,000 PVIF = =
From the Table II at i=8 we find that the number of periods that yield 0.1 PVIF is 30
19
By calculator:
Clean the memory: CLR TVM �
FUTURE VALUE OF ANNUTIES
An annuity is a series of equal payments at fixed
intervals for a specified
number of periods.
PMT = the amount of periodic payment
Ordinary (deferred) annuity: Payments occur at the end of
each period.
Annuity due: Payments occur at the beginning of each
period.
INPUTS
OUTPUT
I/Y PV PMT
N
8 -100,000 0
29.9188
1,000,000
CPT
FV
CE/C 2nd FV
20
Example: Suppose you deposit $100 at the end of each
year into a savings
account paying 5% interest for 3 years. How much will you
have in the
account after 3 years?
( ) 1( ) 1 1 .... n n
2
(1 ) nn FVAND = FVAN + i
2- BY Table III:
,( ) n in FVAN = PMT FVIFA ==� Ordinary Annuity
( ) , ( )1 n in FVAND = PMT FVIFA + i ==� Annuity Due
24
3- BY calculator:
Ordinary Annuity:
1- Clean the memory: CLR TVM�
2- Set payment mode to END of period: BGN �
SET �
3- Make sure you can see END written on the screen then
press
NOTE: If you do not see BGN written on the upper right
side of the screen,
you can skip
Step 2 and 3.
INPUTS
OUTPUT
N I/Y PV PMT
30
315.25
-100
CPT FV
5
CE/C 2nd FV
2nd PMT
2nd ENTER
CE/C
25
Annuity Due:
Clean the memory: CLR TVM �
Set payment mode to BGN of period: BGN �
SET �
Make sure you can see BGN written on the screen then
press
INPUTS
OUTPUT
N I/Y PV PMT
30
331.10
-100
CPT FV
5
CE/C 2nd FV
2nd PMT
2nd ENTER
CE/C
26
Example:
You agree to deposit $500 at the end of every year for 3
years in an investment
fund that earns 6%.
Time line
Before solving the problem, List all inputs:
I = 6% or 0.06
N= 3
PMT=500
PV= 0
FV=?
Solution:
By formula:
(1 ) 1n
n
i
FVAN PMT
i
⎡+−⎤
=⎢⎥
⎢⎣ ⎥⎦
(1 0.06)3 1 500
0.06
⎡+−⎤
=⎢⎥
⎣⎦
500 1.191 1 1,591.80
0.06
⎡−⎤=⎢⎥=⎣⎦
By Table: , ( ) n in FVAN = PMT FVIFA
3 6,3 FVAN = 500(FVIFA )
= 500(3.184) = 1,592
01
$500
2
$500
6%
3
$500
FV=?
27
By calculator:
Clean the memory: CLR TVM�
Make sure you do not see BGN written on the upper right
side of the screen.
By Excel: =FV (0.06, 3, -500, 0, 0)
INPUTS
OUTPUT
N I/Y PV PMT
30
1,591.80
-500
CPT FV
6
CE/C 2nd FV
28
Now assume that you deposit the $500 at the beginning of
the year not at the
end of the year.
Time line
Before solving the problem, List all inputs:
I = 6% or 0.06
N= 3
PMT=500 (beg)
PV= 0
FV=?
Solution:
By formula:
(1 ) 1 ( )
1
n
n
i
FVAND PMT i
i
⎡+−⎤
=⎢⎥+
⎢⎣ ⎥⎦
()
3
1 0.06 1
500 (1 0.06)
0.06
n
FVAND
⎡+−⎤
=⎢⎥+
⎢⎣ ⎥⎦
500 0.191 (1.06) 1,687.30
0.06
= ⎡ ⎤ = ⎢⎣ ⎥⎦
By Table: () , ( )1 n in FVAND = PMT FVIFA + i
() FVAND = 500(FVIFA ) 1+ 0.06
3 6,3
= 500(3.184)(1.06) = 1,687.52
0
$500
1
$500
2
$500
6%
3
FV=?
29
By calculator:
Clean the memory: CLR TVM �
Set payment mode to BGN of period: BGN �
SET �
Make sure you can see BGN written on the screen then
press
By Excel: =FV (0.06, 3, -500, 0, 1)
INPUTS
OUTPUT
N I/Y PV PMT
30
1,687.31
-500
CPT FV
6
CE/C 2nd FV
2nd PMT
2nd ENTER
CE/C
30
PRESENT VALUE OF ANNUTIES
Problem: You have a choice
a) $100 paid to you at the end of each of the next 3 years
or
b) a lump sum today.
i = 5%, since you would invest the money at this rate if
you had it.
How big does the lump sum have to be to make the
choices equally good?
Formula:
()()()
()
( ) i,n
n
n12n
PMT PVIFA
i
1i
11
PMT
1i
.... PMT
1i
PMT
1i
PVA PMT
=
⎥⎥⎥⎥
⎦
⎤
⎢⎢⎢⎢
⎣
⎡
+
−
=
+
++
+
+
+
=
Present Value Interest Factor
0123
Time
÷1.05 ÷1.052
÷1.053
95.24
90.70
86.38
PVAN3 = 272.32
100 100 100
31
$100(2.7232) $272.32
.05
1.05
11
PVA $100 3
3
==
⎥⎥⎥
⎦
⎤
⎢⎢⎢
⎣
⎡−
=
Note: For annuities due, simply multiply the answer
above by (1+i)
PVANDn (annuity due) = PMT (PVIFAi,n) (1+i)
To solve for the present value of Annuities, You need:
1-Payemnt or annuity amount (PMT)
2-Interest rate per period (i)
3-Number of periods (n)
1- BY Formula:
()
11
1n
n
i
PVAN PMT
i
⎡−⎤⎢+⎥=⎢⎥
⎢⎥
⎢⎥
⎣⎦
==� Ordinary Annuity
()()
11
1
1
n
n
i
PVAND PMT i
i
⎡−⎤⎢+⎥=⎢⎥+
⎢⎥
⎢⎥
⎣⎦
==� Annuity Due
(1 ) nn PVAND = PVAN + i
32
2- BY Table IV:
PVANn = PMT (PVIFAi,n ) ==� Ordinary Annuity
( ) , ( )1 n in PVAND = PMT PVIFA + i ==� Annuity Due
3- BY calculator:
Ordinary Annuity:
Clean the memory: CLR TVM�
Make sure you do not see BGN written on the upper right
side of the screen.
INPUTS
OUTPUT
N I/Y FV PMT
30
272.32
-100
CPT PV
5
CE/C 2nd FV
33
Annuity Due:
Clean the memory: CLR TVM �
Set payment mode to BGN of period: BGN �
SET �
Make sure you can see BGN written on the screen then
press
INPUTS
OUTPUT
N I/Y FV PMT
30
285.94
-100
CPT PV
5
CE/C 2nd FV
2nd PMT
2nd ENTER
CE/C
34
Example:
You agree to receive $500 at the end of every year for 3
years in an investment
fund that earns 6%.
Time line
Before solving the problem, List all inputs:
I = 6% or 0.06
N= 3
PMT=500
FV= 0
PV=?
Solution:
By formula:
()
11
1
n
n
i
PVAN PMT
i
⎡−⎤⎢+⎥=⎢⎥
⎢⎥
⎢⎥
⎣⎦
( )3
11
1 0.06
500
n 0.06 PVAN
⎡−⎤⎢+⎥=⎢⎥
⎢⎥
⎢⎥
⎣⎦
11
500 1.191
0.06
⎡−⎤⎢⎥
=⎢⎥
⎢⎥
⎣⎦
= $1,336.51
0
PV=?
1
$500
2
$500
6%
3
$500
35
By Table: PVANn = PMT (PVIFAi,n )
3 6,3 PVAN = 500(PVIFA )
= 500(2.673) = 1,336.51
By calculator:
Clean the memory: CLR TVM�
Make sure you do not see BGN written on the upper right
side of the screen.
By Excel: =PV (0.06, 3, -500, 0, 0)
INPUTS
OUTPUT
N I/Y FV PMT
30
1,336.51
-500
CPT PV
6
CE/C 2nd FV
36
Now assume that you receive the $500 at the beginning of
the year not at the
end of the year.
Time line
Before solving the problem, List all inputs:
I = 6% or 0.06
N= 3
PMT=500 (beg)
FV= 0
PV=?
Solution
By formula:
()()
11
1
1
n
n
i
PVAND PMT i
i
⎡−⎤⎢+⎥=⎢⎥+
⎢⎥
⎢⎥
⎣⎦
( )3
11
1 0.06
500 (1 0.06)
n 0.06 PVAND
⎡−⎤⎢+⎥=⎢⎥+
⎢⎥
⎢⎥
⎣⎦
11
500 1.191 (1.06)
0.06
⎡−⎤⎢⎥
=⎢⎥
⎢⎥
⎣⎦
= 1, 416.70
0
$500
PV=?
1
$500
2
$500
6%
3
37
= 500(2.673)(1.06) = 1, 416.69
By calculator:
Clean the memory: CLR TVM �
Set payment mode to BGN of period: BGN �
SET �
Make sure you can see BGN written on the screen then
press
By Excel: =PV (0.06, 3, -500, 0, 1)
INPUTS
OUTPUT
N I/Y FV PMT
30
1,416.69
-500
CPT PV
6
CE/C 2nd FV
2nd PMT
2nd ENTER
CE/C
38
Perpetuities
A perpetuity is an annuity that continues forever.
11
(1 )n
n
PVAN PMT i
i
⎡−⎤⎢+⎥=⎢⎥
⎢⎥
⎢⎣ ⎥⎦
()
As n gets very large, 1 0
1 ni
→
+
0
PVPER ( perpetuity) PMT 1 0
i
⎡−⎤=×⎢⎥⎣⎦
PMT 1 PMT
ii
= ×⎛ ⎞ = ⎜ ⎟
⎝⎠
Formula:
0
PVPER PMT
i
=
39
UNEVEN CASH FLOWS
How do we get PV and FV when the periodic payments are
unequal?
Present Value
( ) ( )n
n
2
12
0 1i
.... CF
1i
CF
1i
PV CF CF
+
++
+
+
+
=+
Future Value
( ) ( ) ( )0
n
n1
1
n
0 FV = CF 1+ i + CF 1+ i + ....+ CF 1+ i −
0123
÷1.05 ÷1.052
÷1.053
95.24
45.35
172.77
$313.36
100 50 200
0123
100 50 200.00
52.50
110.25
$362.75
5%
×1.05
×1.052
40
Example:
Present Value of Uneven Cash Flows
41
By Calculator:
Clean the memory:
Input cash flows in the calculator’s CF register:
CF0 = 0 � 0
CF1 = 100 � C01 100 F01 1
CF2 = 200 � C02 200 F02 1
CF3 = 300 � C03 300 F03 1
Press , then the it will ask you to enter the Interest rate (I)
Enter I = 10 � 10
Use to get to the NPV on the screen
When you read NPV on the screen, press
You will get NPV = $481.59 (Here NPV = PV.)
NOTE:
To calculate the future value of uneven cash flows, it is
much easier to start by
calculating the Present value of the cash flows using NPV
function then
calculate the future value using the future value of a
single cash flow rules. The
single cash flow in this case will be the present value.
CF 2nd CE/C
ENTER
ENTER ENTER
ENTER ENTER
ENTER ENTER
NPV
ENTER
CPT
42
Simple and Compound Interest
Simple Interest
� Interest paid on the principal sum only
Compound Interest
� Interest paid on the principal and on interest
Example:
Calculate the future value of $1000 deposited in a saving account
for 3 years earning
6% . Also, calculate the simple interest, the interest on interest,
and the compound
interest.
FV3 = 1000 (1.06) 3
= $1,191.02
Principal = PV = $1000
Compound interest = FV – PV = 1191.02 – 1000 = 191.02
Simple Interest = PV * i * n =1000 * 0.06 * 3 = $180
Interest on interest = Compound interest - Simple Interest
= 191.02 – 180 =
11.02
43
Effect of Compounding over Time
Other Compounding Periods
So far, our problems have used annual compounding. In
practice, interest is
usually compounded more frequently.
44
Example: You invest $100 today at 5% interest for 3 years.
Under annual compounding, the future value is:
()
$115.76
$100(1.1576)
$100(1.05)
FV PV 1 i
3
3
3
=
=
=
=+
What if interest is compounded semi-annually (twice a
year)?
Then the periods on the time line are no longer years, but
half-years!
Time:
$115.97
$100(1.1597)
$100(1.025)
(1 )
n No.of periods 3 2 6
2.5%
2
i Periodic interest rate 5%
6
6
=
=
=
=+
==×=
===
FV
FV PV i n
n
Note: the final value is slightly higher due to more
frequent compounding.
0
2.5%
6 months
PV=100
FV6=?
123456
45
Important: When working any time value problem, make
sure you keep
straight what the relevant periods are!
n = the number of periods
i = the periodic interest rate
From now on:
n = m*n
i = i/m
Where m = 1 for annual compounding
m = 2 for semiannual compounding
m = 4 for quarterly compounding
m = 12 for monthly compounding
m = 52 for weekly compounding
m = 365 for daily compounding
For continuously compounding: (1+i) n =e in
=� FVn = PV (e) in
=� PV = FVn (e) -
6-24
Will the FV of a lump sum be larger or
smaller if compounded more often,
holding the stated I% constant?
�LARGER, as the more frequently compounding
occurs, interest is earned on interest more often.
Annually: FV3 = $100(1.10)3 = $133.10
0 1 2 3 10%
100 133.10
Semiannually: FV6 = $100(1.05)6 = $134.01
0123
5%
456
134.01
0123
100
46
EFFECTIVE INTREST RATE
You have two choices:
1- 11% annual compounded rate of return on CD
2- 10% monthly compounded rate of return on CD
How can you compare these two nominal rates?
A nominal interest rate is just a stated (quoted) rate. An
APR (annual
percentage rate) is a nominal rate.
For every nominal interest rate, there is an effective rate.
The effective annual rate is the interest rate actually
being earned per year.
To compare among different nominal rates or to know
what is the actual rate
that you’re getting on any investment you have to use the
Effective annual
interest rate.
Effective Annual Rate: 1 1
m
eff
ii
m
=⎛+⎞−⎜⎟
⎝⎠
To compare the two rates in the example,
1-
1 1 0.11 1 0.11
eff 1 i = ⎛⎜ + ⎞⎟ − =
⎝⎠
or 11% (Nominal and Effective rates are equal in annual
compounding)
2-
12 1 0.10 1 0.1047
eff 12 i = ⎛⎜ + ⎞⎟ − =
⎝ ⎠ or 10.47 %
You should choose the first investment.
47
To compute effective rate using calculator:
ICONV �
Enter Nominal Rate � NOM 10
Enter compounding frequency per year (m) � C/Y 12
Compute the Effective rate � EFF
Nominal Versus Real Interest Rate
Nominal rate f r is a function of:
� Inflation premium n i :compensation for inflation and
lower
purchasing power.
� Real risk-free rate f r′ : compensation for postponing
consumption.
(1+ rf ) = (1+ rf′ )(1+ i n )
ffnfnr = r ′ + i + r ′i
ffnr ≈ r ′ + i
2nd 2
ENTER
ENTER
CPT
48
Amortized Loans
An amortized loan is repaid in equal payments over its life.
Example: You borrow $10,000 today and will repay the loan in
equal installments at
the end of the next 4 years. How much is your annual payment if
the interest rate is
9%?
Inputs:
The periods are years. (m=1)
n=4
i = 9%
PVAN4 = $10,000
FV =0
PMT = ?
PVAN 4 = PMT (PVIFA9%,4 )
$10,000 = PMT (3.240)
$10,000
3.240
PMT = = $3,087
Time 0 9% 1 2 3
PVA N= $10,000 PMT PMT PMT
4
PMT
49
Interest amount = Beginning balance * i
Principal reduction = annual payment - Interest amount
Ending balance = Beginning balance - Principal reduction
Beginning balance: Start with principal amount and then
equal to previous
year’s ending balance.
As a loan is paid off:
• at the beginning, much of each payment is for interest.
• later on, less of each payment is used for interest, and
more of it is applied
to paying off the principal.