Chapter 4 Time Value of Money
Chapter 4 Time Value of Money
Chapter 4 Time Value of Money
So,
(F/A, i%, 8) = 10
Again, this can be solved using the interest tables and
interpolation, but we generally resort to a computer solution.
(F/A, 6%, 8) = 9.8975
(F/A, 7%, 8) = 10.2598
Finding i
Spreadsheet/Excel functions to find N and i.
The Excel function used to solve for N is
NPER(rate, pmt, pv), which will compute the
number of payments of magnitude pmt required to
pay off a present amount (pv) at a fixed interest
rate (rate).
One Excel function used to solve for i is
RATE(nper, pmt, pv, fv), which returns a fixed
interest rate for an annuity of pmt that lasts for nper
periods to either its present value (pv) or future value
(fv).
Deferred Annuities (Uniform Series)
(A=$224.75 & F= 0)
Deferred Annuities (Uniform Series)
P0 = A(P/A, i%, N-J) (P/F, i%, J)
𝑵 𝑵
𝑷ൗ = (𝟏 + 𝒊) −𝟏 𝑭ൗ = (𝟏 + 𝒊) −𝟏
𝑨 𝒊(𝟏 + 𝒊)𝑵 𝑨 (𝟏 + 𝒊)𝑵
𝑭ൗ = (𝟏 + 𝒊)𝑵 𝟏
𝑷 𝑷ൗ =
𝑭 (𝟏 + 𝒊)𝑵
Sometimes cash flows change by a constant
amount each period: Arithmetic Gradient
We can model these situations as a uniform
gradient of cash flows. The table below shows
such a gradient.
End of Period Cash Flows
1 0
2 G
3 2G
: :
N (N-1)G
It is easy to find the present value of a
uniform gradient series.
Similar to the other types of cash flows, there is a
formula (albeit quite complicated) we can use to find
the present value, and a set of factors developed for
interest tables.
The other factors can be found from these. Please refer book
Active Learning 20
You have $1000 to invest for two years. Your bank offers 5%
interest, compounded continuously for funds in a money
market account. Assuming no additional deposits or
withdrawals, how much money will be in that account at the
end of the two years?
F = $10,000 (F/P, 5%, 2) = $10,000*e (0.05) (2) = $11,052