Skip to main content
diversification.com
← Back to A Definitions

Adjusted average irr

What Is Adjusted Average IRR?

Adjusted Average Internal Rate of Return (Adjusted Average IRR) is a sophisticated financial metric used in investment analysis and capital budgeting to evaluate the profitability of a project or investment, particularly when conventional Internal Rate of Return (IRR) presents limitations. It falls under the broader financial category of investment analysis. While the traditional IRR assumes that positive cash flows generated by a project are reinvested at the same rate as the project's IRR, the Adjusted Average IRR modifies this assumption. This adjustment provides a more realistic measure of a project's anticipated return by factoring in a more probable reinvestment rate, often the firm's cost of capital or a predetermined financing rate. The Adjusted Average IRR aims to provide a clearer picture of an investment's true economic return, especially for projects with unconventional cash flow patterns or differing scales.

History and Origin

The concept of the Internal Rate of Return (IRR) gained prominence as a tool for project evaluation within the field of capital budgeting. However, as financial projects became more complex, particularly with varied cash flow patterns, the inherent limitations of IRR became apparent. One significant historical development influencing the need for robust investment evaluation tools was the passage of landmark legislation such as the Investment Company Act of 1940 in the United States. Enacted in response to the Stock Market Crash of 1929 and the subsequent Great Depression, this Act regulated investment companies and mandated greater transparency and disclosure, fostering an environment where more precise financial metrics were increasingly valued10, 11.

Academics and practitioners recognized that the standard IRR's assumption of reinvestment at the project's own rate could lead to misleading conclusions, especially when this rate differed significantly from a firm's actual cost of capital or available market rates. This led to the development of modified versions of IRR, such as the Modified Internal Rate of Return (MIRR), from which the concept of Adjusted Average IRR derives its fundamental principles. These modifications sought to overcome the shortcomings of the traditional IRR, offering a more reliable measure of a project's true profitability and return.

Key Takeaways

  • Adjusted Average IRR refines the traditional Internal Rate of Return by employing a more realistic reinvestment rate for positive cash flows, often the cost of capital.
  • It is particularly useful for evaluating projects with irregular or non-conventional cash flow streams.
  • This metric provides a single, unambiguous rate of return, unlike traditional IRR which can yield multiple values in certain scenarios.
  • Adjusted Average IRR aids in comparing investment opportunities of different scales and durations more accurately.
  • It helps address the "reinvestment rate assumption" problem inherent in the standard IRR calculation.

Formula and Calculation

The Adjusted Average IRR, often synonymous with the Modified Internal Rate of Return (MIRR), is calculated by discounting all cash outflows to a present value at a financing rate and compounding all cash inflows to a future value at a reinvestment rate. These two consolidated figures are then used to calculate the rate of return.

The formula for the Modified Internal Rate of Return (MIRR), which conceptually aligns with Adjusted Average IRR, is:

MIRR=(FVpositive_cashflowsPVnegative_cashflows)1n−1MIRR = \left( \frac{FV_{positive\_cashflows}}{PV_{negative\_cashflows}} \right)^{\frac{1}{n}} - 1

Where:

  • (FV_{positive_cashflows}) = Future Value of all positive cash flows compounded to the end of the project at the reinvestment rate. This involves calculating the future value of each positive cash flow and summing them up.
  • (PV_{negative_cashflows}) = Present Value of all negative cash flows (initial investment and subsequent outflows) discounted to the beginning of the project at the financing rate (or cost of capital).
  • (n) = Number of periods (years) in the project.

To calculate (FV_{positive_cashflows}):

FVpositive_cashflows=∑t=1nCFt+(1+rreinvestment)n−tFV_{positive\_cashflows} = \sum_{t=1}^{n} CF_t^+ (1 + r_{reinvestment})^{n-t}

To calculate (PV_{negative_cashflows}):

PVnegative_cashflows=∑t=0nCFt−(1+rfinancing)tPV_{negative\_cashflows} = \sum_{t=0}^{n} \frac{CF_t^-}{(1 + r_{financing})^t}

Here, (CF_t+) represents a positive cash flow in period (t), (CF_t-) represents a negative cash flow in period (t), (r_{reinvestment}) is the reinvestment rate, and (r_{financing}) is the financing rate. The primary goal is to address the implicit reinvestment rate assumption of the standard IRR.

Interpreting the Adjusted Average IRR

Interpreting the Adjusted Average IRR involves comparing its calculated percentage to a predetermined hurdle rate or the company's cost of capital. If the Adjusted Average IRR exceeds this benchmark, the project is generally considered financially viable and attractive. A higher Adjusted Average IRR indicates a more desirable investment opportunity.

This metric offers a more nuanced perspective than the traditional Internal Rate of Return because it explicitly accounts for the rate at which cash flows can actually be reinvested or financed. For example, if a project's cash flows are substantial and frequent, the assumption of reinvesting them at the project's own high IRR might be unrealistic. The Adjusted Average IRR addresses this by allowing the user to specify a more achievable reinvestment rate, such as the market interest rate or the firm's opportunity cost of capital. This makes the Adjusted Average IRR a valuable tool for effective project evaluation, offering a more robust measure of profitability.

Hypothetical Example

Consider a hypothetical real estate development company, "GreenSpace Properties," evaluating two mutually exclusive projects: a small residential complex (Project A) and a larger commercial office building (Project B).

Project A: Residential Complex

  • Initial Investment (Year 0): -$1,000,000
  • Year 1 Cash Flow: +$300,000
  • Year 2 Cash Flow: +$400,000
  • Year 3 Cash Flow: +$500,000
  • Year 4 Cash Flow: +$200,000 (Sale proceeds)

Project B: Commercial Office Building

  • Initial Investment (Year 0): -$5,000,000
  • Year 1 Cash Flow: +$1,000,000
  • Year 2 Cash Flow: +$1,500,000
  • Year 3 Cash Flow: +$2,000,000
  • Year 4 Cash Flow: +$3,000,000 (Sale proceeds)

GreenSpace Properties uses a cost of capital of 8% for both financing and reinvestment rates.

Calculation for Project A (Adjusted Average IRR):

  1. Present Value of Negative Cash Flows (PV of Outflows):
    The only negative cash flow is the initial investment: -$1,000,000 at Year 0.
    (PV_{negative_cashflows} = $1,000,000)

  2. Future Value of Positive Cash Flows (FV of Inflows) at 8% reinvestment rate:

    • Year 1: ( $300,000 \times (1 + 0.08){4-1} = $300,000 \times (1.08)3 \approx $377,913 )
    • Year 2: ( $400,000 \times (1 + 0.08){4-2} = $400,000 \times (1.08)2 \approx $466,560 )
    • Year 3: ( $500,000 \times (1 + 0.08){4-3} = $500,000 \times (1.08)1 \approx $540,000 )
    • Year 4: ( $200,000 \times (1 + 0.08){4-4} = $200,000 \times (1.08)0 = $200,000 )
      (FV_{positive_cashflows} \approx $377,913 + $466,560 + $540,000 + $200,000 = $1,584,473)

  3. Adjusted Average IRR for Project A:
    (MIRR_A = \left( \frac{$1,584,473}{$1,000,000} \right){\frac{1}{4}} - 1 \approx (1.584473){0.25} - 1 \approx 1.1221 - 1 = 0.1221 \text{ or } 12.21%)

Calculation for Project B (Adjusted Average IRR):

  1. Present Value of Negative Cash Flows (PV of Outflows):
    (PV_{negative_cashflows} = $5,000,000)

  2. Future Value of Positive Cash Flows (FV of Inflows) at 8% reinvestment rate:

    • Year 1: ( $1,000,000 \times (1.08)^3 \approx $1,259,712 )
    • Year 2: ( $1,500,000 \times (1.08)^2 \approx $1,749,600 )
    • Year 3: ( $2,000,000 \times (1.08)^1 \approx $2,160,000 )
    • Year 4: ( $3,000,000 \times (1.08)^0 = $3,000,000 )
      (FV_{positive_cashflows} \approx $1,259,712 + $1,749,600 + $2,160,000 + $3,000,000 = $8,169,312)

  3. Adjusted Average IRR for Project B:
    (MIRR_B = \left( \frac{$8,169,312}{$5,000,000} \right){\frac{1}{4}} - 1 \approx (1.6338624){0.25} - 1 \approx 1.1307 - 1 = 0.1307 \text{ or } 13.07%)

In this hypothetical example, Project B has a higher Adjusted Average IRR (13.07%) compared to Project A (12.21%). Based solely on this metric, Project B would be the preferred investment, indicating a higher annual rate of return given the specified reinvestment and financing rates. This demonstrates how financial modeling with Adjusted Average IRR provides a clear comparative measure.

Practical Applications

Adjusted Average IRR is a critical financial metric with various practical applications across different investment sectors. In corporate finance, it is frequently used in capital budgeting decisions, helping companies evaluate and prioritize major projects such as new plant construction, equipment upgrades, or research and development initiatives. Its ability to incorporate a realistic reinvestment rate makes it suitable for long-term projects with complex cash flow patterns, offering a more dependable measure for project selection.

In the real estate industry, where projects often involve substantial initial investments, fluctuating income streams, and long horizons, the Adjusted Average IRR provides a robust method for evaluating potential returns9. It helps real estate developers and investors assess the viability of property acquisitions, development projects, and renovation ventures by providing a clear, adjusted annual rate of return. For portfolio managers, Adjusted Average IRR can be a valuable tool for comparing disparate investment opportunities, allowing for more informed decisions on asset allocation and diversification strategies. By providing a single, consistent measure, it facilitates a more accurate comparison of the inherent profitability of different investments.

Limitations and Criticisms

Despite its advantages, the Adjusted Average IRR, like any financial metric, has its limitations. One primary criticism is that while it attempts to address the traditional IRR's flawed reinvestment assumption, the choice of the appropriate reinvestment rate itself can be subjective8. Different analysts might use different rates (e.g., the firm's cost of capital, a risk-free rate, or an average market return), leading to varying Adjusted Average IRR results and potentially different investment decisions. This reliance on an external reinvestment rate introduces an element of estimation that can impact the perceived profitability.

Furthermore, while Adjusted Average IRR typically resolves the multiple IRR problem that can arise with unconventional cash flow streams, it still relies on discounted cash flow principles6, 7. This means that the accuracy of the Adjusted Average IRR is highly dependent on the precision of the projected cash flow estimates, which are inherently uncertain and subject to various market and operational risks. Unexpected changes in market conditions, project costs, or revenue streams can significantly alter the actual return from what was initially projected. Critics also point out that while Adjusted Average IRR is an improvement, it may not always be intuitive for all stakeholders, potentially requiring additional explanation compared to simpler metrics like payback period or return on investment (ROI)5. For a comprehensive risk assessment, the Adjusted Average IRR should be used in conjunction with other financial metrics, such as Net Present Value (NPV), which provides a dollar value of the project's profitability, and sensitivity analysis, which tests the impact of changing assumptions4.

Adjusted Average IRR vs. Modified Internal Rate of Return (MIRR)

The terms "Adjusted Average IRR" and "Modified Internal Rate of Return (MIRR)" are often used interchangeably in practice, referring to the same fundamental concept. Both aim to correct the inherent flaw of the traditional Internal Rate of Return (IRR), which assumes that all positive cash flows generated by a project are reinvested at the project's own IRR. This assumption can be unrealistic, particularly if the project's IRR is exceptionally high or low compared to prevailing market rates or the company's cost of capital.

The key distinction, if any, often lies in the specific methodology or explicit naming used by financial institutions or software for similar calculations. MIRR is the more widely recognized and formally defined term. Both MIRR and Adjusted Average IRR address the two main limitations of standard IRR:

  1. Reinvestment Rate Assumption: They assume that positive cash flows are reinvested at a specified external rate (e.g., the firm's cost of capital or a safe market rate) rather than the project's own calculated IRR. This provides a more realistic assessment of what can be earned on the cash generated by the project2, 3.
  2. Multiple IRRs: For projects with unconventional cash flow patterns (e.g., initial outflow, then inflows, then another outflow), traditional IRR can yield multiple valid internal rates, making interpretation ambiguous. MIRR (and thus Adjusted Average IRR) resolves this by consolidating cash flows into a single initial outlay and a single terminal value, leading to a unique solution1.

Essentially, Adjusted Average IRR is a descriptive term for a calculation that functions identically to the Modified Internal Rate of Return, offering a more refined and reliable measure of project profitability compared to the simpler, but sometimes misleading, traditional IRR.

FAQs

What is the primary problem Adjusted Average IRR solves?

The primary problem Adjusted Average IRR solves is the unrealistic reinvestment rate assumption of the traditional Internal Rate of Return (IRR). Standard IRR assumes that all positive cash flows are reinvested at the project's own IRR, which may not be feasible in real-world scenarios. Adjusted Average IRR allows for a more realistic reinvestment rate, often the firm's cost of capital.

How does the Adjusted Average IRR differ from a simple average return?

The Adjusted Average IRR is a sophisticated financial metric that considers the time value of money and the timing of cash flows, unlike a simple average return. A simple average return merely calculates the arithmetic mean of returns over a period, ignoring when those returns occurred or at what rate they could be reinvested. Adjusted Average IRR discounts and compounds cash flows to reflect their value over time, providing a true annual percentage rate.

Can Adjusted Average IRR be used to compare projects of different sizes?

Yes, Adjusted Average IRR is generally better suited for comparing projects of different sizes than the traditional IRR. While IRR can sometimes mislead due to its focus on a percentage rather than absolute value, the Adjusted Average IRR's methodology, particularly by addressing the reinvestment rate and often being used alongside Net Present Value (NPV), allows for a more comprehensive comparison of projects regardless of their initial investment or scale.

Is Adjusted Average IRR widely used in financial analysis?

While not as commonly cited as the traditional Internal Rate of Return (IRR), the underlying principles of Adjusted Average IRR, primarily through the Modified Internal Rate of Return (MIRR), are widely accepted and used by financial professionals. It is particularly valued in capital budgeting and investment analysis for projects with complex cash flow patterns where the standard IRR's limitations are significant.

What are common reinvestment rates used in Adjusted Average IRR calculations?

Common reinvestment rates used in Adjusted Average IRR (MIRR) calculations include the firm's weighted average cost of capital (WACC), a predetermined hurdle rate, or a risk-free rate such as the yield on government bonds. The choice of reinvestment rate should reflect the most realistic rate at which the company expects to reinvest its intermediate cash flows.