
274
CHAPTER 7 Rate
of
Return Analysis: Single Alternative
is exceeded each month. Kathy has
an
internal report
from the Customer Relations Department that itemizes
the net cash flows below for the Homeworth account
during the last
10
years.
Year
Cash Flow
($1
000)
1993 $200
1994 100
1995
50
1996
- 1800
1997 600
1998 500
1999
400
2000 300
2001 200
2002 100
The report also states that the annual rate
of
return
is
between
25
and
50
%, but no further information
is
provided. This information
is
not detailed enough for
Kathy to evaluate the company's request.
Over the next few hours, Bob and Kathy had a se-
ries
of
discussions as Bob worked to answer Kathy's
increasingly more specific questions. The following
is
an abbreviated version
of
these conversations. Luck-
ily, both Bob and Kathy took an engineeling economy
course during their undergraduate work, and their pro-
fessors covered the method to
find
a unique rate
of
re-
turn for any cash flow
se
rie
s.
Development
of
the Situation
I. Kathy asked Bob to do a preliminary study to
find
the correct rate
of
return.
She
wanted only
one number, not a range, and not two or three
possible values.
She
did, however, have a passing
interest
in
initially knowing the values
of
multi-
ple rates, if they do exist,
in
order to determine if
the report from customer relations was correct or
just
a "shot in the dark."
Kathy told Bob that the
MARR
for the com-
pany
is
15
% per year for these major clients.
She
also explained that the 1996 negative cash flow
was caused by
an
on-site equipment upgrade
when Homeworth expanded its manufacturing
capacity and increased power usage about 5-fold.
2.
Once Bob had finished his initial analysis, Kathy
told him that she had forgotten to tell him that the
rate
of
return earned externally on the positive
cash flows from these major clients is placed into
a venture capital pool headquartered
in
Chicago.
It has been making 35% per year for the last
decade.
She wanted to know
if
a unique return
still existed and
if
the Homeworth account was
financially viable
at
a MARR
of
35%.
In respon
se
to this request, Bob developed
the four-step procedure outlined below to
closely estimate the composite rate
of
return
i'
for any reinvestment rate c and two multiple
rates
i'l'
and if. He plans to apply this procedure
to answer this latest question and show the re-
sults to Kathy.
Step
1.
Determine the
i*
roots
of
the
PW
rela-
tion for the cash flow series.
Step 2. For a given reinvestment rate c and the
two
i*
values from step 1, determine
which
of
the following conditions
applies:
(a)
If
c <
ii',
then i' < if.
(b)
If
c >
if,
then i' > if.
(c)
If
iii'
< c < ii', then
i'
can be less
than
c or greater than
c,
and
if
<
i
'<
i
f.
Step 3. Guess a starting value for i' according
to the result from step 2. Apply the
net-investment method from periods
j
to
n.
Repeat this step until
F"
is
close
to O.
If
this
Fil
is
a small positive value,
guess another
i'
that
wi
II
result
in
a
small negative
F"
value, a
nd
vice
versa.
Step 4. Using the two
F"
results from step 3,
linearly interpolate i' such that the
corresponding
F"
is
approximately
zero.
Of
course, the final
i'
value can
also be obtained directly in step 3,
without interpolation.