The Goal Seek template sets the F3 value to zero by changing the ROIC value (cell E8). The
result is i ROIC 10.55% per year. As before, since 10.55% 9%, the MARR, the project
is economically justifi ed.
Comment
Note that the rate by the ROIC method (10.55%) is different than the MIRR rate (9.39%). Also
these are both different than the multiple rates determined earlier (7.47% and 41.35%). This
shows how dependent the different methods are upon the additional information provided
when multiple i * rates are indicated by the two sign tests.