This is “Other Methods”, section 13.5 from the book Finance for Managers (v. 0.1). For details on it (including licensing), click here.

For more information on the source of this book, or why it is available for free, please see the project's home page. You can browse or download additional books there. To download a .zip file containing this book to use offline, simply click here.

Has this book helped you? Consider passing it on:

PLEASE NOTE: This book is currently in draft form; material is not final.

- Evaluate some other methods to evaluating capital budgeting.
- Calculate Profitability Index.
- Discuss MIRR.

So far we have learned payback period, NPV and IRR. These three are the most widely used and methods to evaluate capital projects, and are sufficient for most companies, but many other methods exist. Here we’ll discuss two other methods: Profitability index and MIRR.

Profitability index (PI)Present value return per dollar of investment. shows the relative profitability of any project: in essence, a ‘bang for your buck’ calculation. It is the present value per dollar of initial cost. The higher the profitability index, the better, and any PI greater than 1.0 indicates that the project is acceptable because it adds to corporate value.

Equation 13.3 Profitability Index

$$\text{ProfitabilityIndex}=\frac{\text{PresentValueofFutureCashFlows}}{\text{InitialCost}}$$For Gator Lover’s the PI’s are as follows:

$$\text{ProfitabilityIndexProjectA}=\frac{\text{\$}\mathrm{58,861.80}}{\text{\$}\mathrm{48,000}}=1.22$$ $$\text{ProfitabilityIndexProjectB}=\frac{\text{\$}\mathrm{56,567.66}}{\text{\$}\mathrm{52,000}}=\text{1}.0\text{8}$$The profitability index is higher for Project A. PI doesn’t work as well if the initial investment is spread out over time, or if the cash flows aren’t ordinary, which is why we prefer NPV.

Our final method of evaluating capital projects worth discussing is modified internal rate of return (MIRR)Internal rate of return assuming that the funds earned cannot be reinvested at IRR.. IRR is the expected rate of return if the NPV = 0. This assumes that early inflows will be reinvested at the return of the project itself! Often, the funds earned from a project cannot be reinvested at IRR, but instead earn a lower rate. Therefore, *IRR can overstate the expected rate of return*. To compensate for this overstatement, modified internal rate of return (MIRR) was created. MIRR assumes that funds can be reinvested at the weighted average cost of capital (WACC) or some other specifically stated rate.

In our IRR example, we used a hurdle rate of 10%. But what if the inflows could only be reinvested at 8%? To calculate MIRR, we would use the 8%. Lucky for us, spreadsheets have a function to do this quite easily:

=MIRR(cash flows from period 0 to *n*, rate for outflows, reinvestment rate)

Project A MIRR (reinvested at 8%) = 12.89%

Project B MIRR (reinvested at 8%) = 11.63%

Compared with our original IRRs of 12.88% for Project A and 15.43% for Project B, it’s easy to see that the reinvestment rate has a large impact. Some shortfalls, however: it’s harder to calculate (esp. without technology), and requires knowledge of the WACC. If we have the WACC, however, why not calculate NPV?

Table 13.3 "Gater Lover’s Ice Cream: Summary Chart for Capital Budgeting Decision Making Techniques" a summary chart for the capital budgeting decision making techniques for Gator Lover’s Ice Cream’s potential projects: Project A and Project B.

Table 13.3 Gater Lover’s Ice Cream: Summary Chart for Capital Budgeting Decision Making Techniques

Project A | Project B | |
---|---|---|

Initial Investment |
($48,000) | ($52,000) |

Technique | ||

Payback Period | 3.2 years | 2.8 years |

NPV | $8,861.80 | $6,567.66 |

IRR | 16.99% | 15.43% |

Profitability Index | 1.22 | 1.08 |

MIRR | 12.89% | 11.63% |

Winner! |
Project A |

And the winner is…Project A. While Project B has a faster payback period, Project A wins in every other category, especially the critical NPV category. If we can only choose one project, Gator Lover’s Ice Cream should open a new store (Project A) instead of investing in a new machine (Project B). Of course, if we can do both, that should be our choice.

There exist other methods to evaluate projects. We learned Profitability Index and MIRR

- Profitability index is bang for your buck.
- MIRR assumes a different reinvestment rate than IRR.

- Calculate PI for Exercises 1 & 2 in Section 13.3 "Net Present Value".
- Explain how the MIRR would compare to IRR for the projects in Exercises 1 & 2 in Section 13.3 "Net Present Value" if the reinvestment rate is 8%.