
SECTION 8.5 Rate
of
Return Evaluation Using
AW
Figure
8-Sb
provides an excellent opportunity to see why the
ROR
method
can result in selecting the wrong alternative when only
i*
values are used to se-
lect between two alternatives. This is
sometimes
ca
ll
ed
the ranking
inconsistency problem
of
the
ROR
method. The inconsistency occurs when the
MARR is set less than the breakeven rate between two revenue alternatives.
Since the
MARR
is established based on conditions
of
the
economy
and
mar
-
ket,
MARR
is
established external to any particular alternative evaluation. In
Figure
8-Sb, the breakeven rate is 29.41 %, and the
MARR
is 30%.
If
the
MARR
were established
lower
than breakeven, say at 26%, the incremental
ROR
analysis results
in
correctly selecting B,
because
!1i*
= 29.41 %, which
exceeds 26%.
But
if only the
i*
values were used, system A
would
be
wrongly
chosen, because its
i*
= 39.31
%.
This
error
occurs
because
the rate
of
return
method assumes
reinvestment
at the alternative's
ROR
value (39.31 %), while
PW
and AW analyses use the
MARR
as the reinvestment rate.
The
conclusion
is
simple:
If
the
ROR
method
is
used to evaluate two
or
more alternatives, use the
incremental cash flows
and
.:li* to make the decision between alternatives.
8.5
RATE
OF RETURN EVALUATION USING
AW
Comparing alternatives by the
ROR
method (correctly performed) always leads
to the same selection as
PW,
AW,
and
FW
analyses, whether the
ROR
is deter-
mined using a
PW-based, an AW-based,
or
a
FW
-based relation. However, for the
AW-based technique, there are two equivalent ways to perform the evaluation:
using the
incremental cashflows over the
LCM
of
alternative lives,
just
as for the
PW-based relation (previous section),
or
finding the A W for each alternative's
actual cash flows and setting the difference
of
the two equal to zero to find the
!1i*
value.
Of
course, there is no difference between the two approaches
if
the
alternative lives are equal. Both methods are summarized here.
Since the
ROR
method requires comparison for equal service, the incremen-
tal cash flows must be evaluated over the
LCM
of
lives. When solving by hand
for
!1i*,
there may be no real computational advantage to using A
W,
as was found
in Chapter 6. The same six-step procedure
of
the previous section (for
PW
-based
calculation) is used, except in step 5 the AW-based relation is developed.
For comparison by computer with equal
or
unequal lives, the incremental cash
flows must be calculated over the
LCM
of
the two alternatives' lives. Then the
IRR function is applied to find
!1i*.
This is the same technique developed
in
the
previous section and used in the spreadsheet in Figure
8-2. Use
of
the IRRfunc-
tion
in
this manner is the correct way to use Excel spreadsheet functions to com-
pare alternatives using the ROR method.
The second A W-based method takes advantage
of
the AW tech
nique's
assump-
tion that the equivalent
AW
value is the same for each year
of
the first and all suc-
ceeding life cycles. Whether the lives are equal
or
unequal, set up the A W relation
for
the cash flows
of
each alternative, form the relation below, and solve for
i*.
0=
AW
B
-
AW
A
[8.3]
Equation [8.3] applies to solution by hand only, not solution by computer.
291
~
E·Solve
AW and
li
fe
cycles