CAGR is a great tool for comparing the performance of investments or key business metrics. However, since CAGR is calculated based on a particular timeframe, you can’t make comparisons for different periods. When it comes to calculating the performance of investments over time, CAGR is the best formula. Moreover, it helps address the limitations of the arithmetic return.

IRR is a simplification of XIRR in which only periodic cash flows are allowed. The above example shows why it would be inappropriate to use CAGR when there are more than two cash flows and the adequate measure of returns in such cases is the IRR. Typically, a fifty percent return can be expected to take several years to achieve. Since different investments often take different amounts of time for the returns to accumulate, it is useful to have a measure which makes investments with different time to return comparable.

Disadvantages of IRR

Compound annual growth rate (CAGR) measures an investment or financial metric’s annual growth rate over a set period of time that’s longer than a year. This growth rate accounts for the reinvestment of profits at the end of each financial period. Based on the terms of this equation, the compound annual growth rate in this scenario is 7.18%. This means that despite the market volatility, the investment returned 7.18% annually. It is important to note that the CAGR as calculated will probably not be experienced by the investor in any given year. In our example, the investor did not experience a return of 7.18% in any given year, but over the entire holding period the return averaged out to 7.18%.

They also need to be able to gauge the performance of any investment managers they invest alongside, including mutual funds, real estate investment trusts, and private equity firms like us. In every asset class, managers or sponsors are judged against a benchmark, whether a formal index or simply an individual investor’s self-determined hurdle rate. To back into the IRR, a financial calculator, Excel, or portfolio accounting system is ideal.

In most cases, your fellow investors will understand the value of your deal only in terms of IRR. At First National Realty Partners, we specialize in the acquisition and management of grocery store anchored retail centers. We go to great lengths to analyze the potential CAGR and IRR for every investment that we perform due diligence on.

Analyzing historical returns

See the “CAGR formula” section in our CAGR calculator page for details about the variables used, but it is basically just raising the relative return to the power of one divided by the number of periods. While this accounts for compounding, obviously no interim cash flows are involved. If an investor paid $463,846 (which is the negative cash flow shown in cell C178) for a series of positive cash flows as shown in cells D178 cagr vs irr to J178, the IRR they would receive is 10%. This means the net present value of all these cash flows (including the negative outflow) is zero and that only the 10% rate of return is earned. In other words, we can say that the main difference between IRR and CAGR is the assumption regarding the reinvestment rate of interim cash flows. On the other hand, CAGR is the average compounded growth rate for the set duration of time.

When calculating the compound annual growth rate, you’ll use a smoothed rate of growth over the period in question. While you may want your industry and company to grow steadily and predictably, that’s rarely ever the case, much less so for an extended period. And IRR is just solving the above equation for r with NPV equal to zero. Note that unlike CAGR, the IRR formula is not analytical and uses iterative summation to account for the cash flows. The IRR equation when applied to a single cash outflow followed by a single cash inflow can be shown to be equivalent to the CAGR formula.

What is the difference between an AAGR vs. CAGR?

Let’s assume an investor purchases a commercial property today for $1.5M and sells it five years later for $2M. In years one through five, the investor receives the following cash flows on an annual basis. The IRR is classified as a discount rate that utilizes net present value (NPV), making all cash flows equal to zero in a discounted cash flow (DCF) analysis.

• This takes us back to our original question – why do investment firms declare results in terms of the IRR and not CAGR.
• It will also allow investors to compare the past performance against alternative firms and asset classes over the same period.
• However, the maturity value is identical to the above case in which annual returns were fixed at 20%.
• Because the cash flows we have received in years 1,2 and 3 would be reinvested to earn some return.

When the time to return is different across the investment opportunities, annualized measurements are appropriate. Both CAGR and Simple annualized return work when there are only two cash flow events, one is suitable with compounding returns and the other with non-compounding ones. The CAGR is superior to an average returns figure because it takes into account how an investment is compounded over time. CAGR is also subject to manipulation as the variable for the time period is input by the person calculating it and is not part of the calculation itself. In this scenario, we do away with the assumption of no interim cash flows and assume that we receive Rs. 200 in Year 1, Rs. 500 in Year 2, Rs. 400 in Year 3 and Rs. 900 in Year 4. As mentioned earlier, IRR is the rate at which the present value of cash inflows equals the present value of cash outflows.

CAGR vs. IRR in Commercial Real Estate Investing

In our scenario, that rate comes to 18.92%, even though the yearly returns were significantly different. For CAGR calculations to remain accurate, there are some key actions your company will need to take. Second, all the profits for the set number of years should be reinvested. So, $5,000 absolute return on an investment of $10,000 is equal to 50% relative return. Depending on the type of investment, different types of returns are of applicable, including absolute return, relative return, periodic returns, and more complex schemes including CAGR, IRR, and XIRR among them.

In most situations, the higher the IRR, the better the investment option. IRR is often used by companies when they must choose which project is best between many options. A project that has an IRR above its cost of capital is one that will be profitable.

Along with the CAGR formula, it’s also essential to know how to calculate the internal growth rate (IGR). This refers to the highest level of growth your company can achieve without external financing. It’s a key metric, especially for startups and small businesses, as it represents the ability to increase profit without incurring debt or issuing more stock. In such cases, CAGR cannot capture these flows and so IRR is the correct profitability metric to compute. When there are multiple cash flow events IRR becomes necessary, where XIRR is an extension of IRR which allows for non-periodic cash flows. It is important for commercial real estate investors to understand that IRR can be used to build discipline into the investment process.

However, it’s equally important to review the historical performance of an investment to determine whether projections are realistic. This is caused by fluctuations in the rate of growth or revenue growth. Either way, it’s important to have a clear picture of what an investment’s value is or what it’s going to be at a later date. CAGR is a further simplification in which just a single inflow (investment event) and a single outflow (cash out event) are allowed.

Not questioning this assumption may lead to investors accepting investment results which appear better than they actually are or would be under realistic assumptions. However, growth rate is a linear measure that does not factor in compound growth. By calculating the CAGR for each vehicle, you’ll know the average return to expect during the investment period. With this information, it will be easier to compare different investments and determine the best one.

To choose the one that suits you, it’s essential that you know what to expect from all available options. When calculating CAGR, begin by dividing the investment’s value at the end of the period by its value at the start of the period. Then, raise the result to the power of one divided by the number of years. From there, you’ll subtract one from the result you get and multiply it by 100 to convert the answer into a percentage. All other things being equal, the return of investment is the leading measure by which such comparisons are made. However, calculating said return is not always as trivial and there are different ways to do it.

CAGR is very useful for finding the rate of return that the
investment would have to earn every year for the life of the investment
to turn the initial value into the future value over the given time
frame. That said, all of these methods suffer from a common limitation which is that they are not accounting for the riskiness of an investment or business project. IRR presumes that all the cash flows received will be reinvested at the same IRR rate.