There are situations where there may be more than one possible Rate of Return or Interest Rate for a series of cash flows. This issue is addressed in Chap. 7A and here you will see how to use a spreadsheet to aid in evaluating such situations. In addition, you will use separate borrowing and investing interest rates to evaluate a complex opportunity by finding the Modified Internal Rate of Return.
Click on a topic below.
Evaluating How Many Roots There Are and Estimating Them
Modified Internal Rate of Return