48 Brooks ◼ Financial Management: Core Concepts, 4e
Method 2: The TVM keys is quick and easy since all that has to be done is to enter the
values for the present value (PV), interest rate (I/Y), number of periods (N), and annuity
involved (PMT), and then solve for the future value (FV). It is important to let students
know that the PV should be entered as a negative (since it is an outflow) and that PMT
should be set to 0. Also, interest rates are to be entered in percent form, i.e., 12.13 for
12.13%, and not in decimal form.
Method 3: The spreadsheet like the calculator method, is also very quick and easy but is
even more versatile because it can be used to perform sensitivity analyses by varying the
input values, and allows for quick review of all the inputs used. Students should be
Example 3: Compounding of interest
Let’s say you want to know how much money will have accumulated into your bank
account after 4 years, if you deposit all $5,000 of your graduation gifts into the account
which pays a fixed interest rate of 5% per year, and leave it there untouched for all four
of your college years….
Formula Method:
The formula for solving this problem is as follows:
Future Value = Present Value × (1 + r)n
or
FV = PV × (1 + r)n;
Note that the total amount of interest earned over the four year period = $1077.53, and
can be broken down as follows:
Year 1: 5% × $5,000.00 = $250.00
Calculator Method:
PV = –5,000; n = 4; I = 5; PMT = 0; CPT FV = $6077.53
Spreadsheet method:
Rate = 0.05; Nper = 4; Pmt = 0; PV = –5,000; Type = 0; FV = 6077.31
Time value table method: