
SECTION 2. 1 Single-Payment Factors (F / P a
nd
P / F)
Use the P/F factor
to
determine P three years earlier.
P = F(P / F,i,n) = $50,000(P / F,20%,3)
= 50,000(0.5787) = $28,935.00
An
equivalence statement
is
that $28,935 three years ago is the same as $50,000
today, which will grow
to
$124,415 five years from now, provided a 20% per year
compound interest rate is realized each year.
Use
th
e PY function
PV(i
%,
/1
,A,F) and omit the A value. Figure
2-2a
shows the result
of
ent
er
in
g PV(20%,3,,50000)
in
ce
ll
F4 to be the same as using the P / F factor.
Solution by
Computer
(c) Figure
2-2b
is a complete spreadsheet solution on one worksheet with the chart.
Two columns are used for 20% and 5% computations primarily so the graph can be
developed
to
compare the F and P values. Row
14
shows the F values using the FY
function with the format FY(i%,5,0,
- 50000) where the i values are taken from cells
C5 and
05.
The future worth F = $124,416
in
cell C14
is
the same (round-off
considered)
as
that calculated above. The minus sign on 50,000 makes the result a
po
siti
ve
number for the chart.
The PY function
is
used
to
find
the P values
in
row
6.
For example,
th
e present
worth at
20%
in
year
-3
is
determined
in
cell C6 using the PY function. The
re
sult
P = $28,935 is
dl
e same as
th
at obtained by using the P / F factor previously. The
chart graphica
ll
y shows the noticeable difference that 20% versus 5% makes over
the 8-year span.
EXAMPLE
2.3
.il
An
independent engineering consultant reviewed records and found tbat the cost
of
office supplies varied
as
shown
in
the pie chart
of
Figure
2-3.
If the engineer wants to
know the equivalent value
in
year
10
of
only the three largest amounts, what
is
it at
an
interest rate
of
5% per year?
YrO
Yr
4
---L-----~
Y:-r-::5
Figure
2-3
Pie chart
of
cos
ts
, Example 2.3.
55
Q-
So
lv
~
E-Solve