How do you deal with multiple IRRs or no IRR scenarios? (2024)

IRR is the discount rate that makes the net present value (NPV) of a series of cash flows equal to zero. It represents the annualized return of a project or investment, assuming that the cash flows are reinvested at the same rate. IRR is widely used in cash flow management because it can compare projects or investments with different sizes, durations, and risk profiles. It can also indicate whether a project or investment meets a minimum required return or a hurdle rate.

IRR can fail to provide a clear answer when the cash flow pattern is unconventional, meaning that it changes signs more than once. For example, a project may have an initial outflow, followed by several inflows, then another outflow, and then more inflows. In this case, there may be more than one discount rate that makes the NPV equal to zero, resulting in multiple IRRs. Alternatively, there may be no discount rate that makes the NPV equal to zero, resulting in no IRR. This can happen when the initial outflow is larger than the sum of the inflows, or when the cash flows are too irregular.

When you encounter multiple IRRs, you need to be careful about which one to use for decision making and performance evaluation. One way to deal with multiple IRRs is to use the modified internal rate of return (MIRR), which assumes that the cash flows are reinvested at a different rate than the IRR, usually the cost of capital or the opportunity cost. MIRR eliminates the problem of multiple IRRs by providing a unique and consistent measure of return. However, MIRR may not reflect the true profitability of a project or investment, as it ignores the actual reinvestment rate of the cash flows.

When you encounter no IRR, you need to look for other criteria to evaluate a project or investment. One way to deal with no IRR is to use the net present value (NPV), which is the difference between the present value of the cash inflows and the present value of the cash outflows. NPV measures the absolute value added by a project or investment, and it is positive when the return exceeds the discount rate. NPV does not depend on the cash flow pattern, and it always provides a unique and consistent answer. However, NPV may not reflect the relative profitability of a project or investment, as it does not account for the size or duration of the cash flows.

IRR is not the only criterion for cash flow management, and there are some alternatives and limitations to consider. For example, when projects or investments have different scales or time horizons, IRR may not rank them correctly, so you may need to use the profitability index (PI) or equivalent annual annuity (EAA). Additionally, IRR may not reflect the risk-adjusted return of a project or investment when the discount rate varies over time or across scenarios, so you may need to use the weighted average cost of capital (WACC) or adjusted present value (APV). Finally, IRR may not capture the value of flexibility or uncertainty in a project or investment when there are options to delay, expand, or abandon it - in this case, you may need to use real options analysis (ROA).

Cash flow management is a vital skill for any business or investor, as it affects the liquidity, profitability, and sustainability of your operations. To improve your cash flow management skills, you need to understand the concepts and tools of financial analysis, such as IRR, NPV, MIRR, and others. You also need to practice applying them to real-world scenarios and problems, such as dealing with multiple IRRs or no IRR situations. You can learn more about cash flow management from online courses, books, podcasts, blogs, and mentors.

This is a space to share examples, stories, or insights that don’t fit into any of the previous sections. What else would you like to add?

Cash Flow Management

+ Follow

Thanks for your feedback

Your feedback is private. Like or react to bring the conversation to your network.