Internal Rate Of Return (IRR) Calculator & Usage

What is IRR: Internal Rate of Return?

The internal rate of return (IRR) is one of the most important metrics in commercial real estate finance. It represents the percentage rate earned on each dollar invested for each period it is invested. IRR uses the concept of time value of money, which means that money an investor has now is more valuable than money an investor has later. Commercial property investors often calculate the IRR to compare different potential investments to determine what is the most profitable opportunity. All other things being equal, the potential investment with the largest IRR is the most lucrative venture.

IRR Calculator

Calculating the IRR is a common way to evaluate real estate projects of disparate sizes. For example, a $7 million investment that yields $21 million in return has a higher IRR than a $70 million investment that yields $140 million.

The IRR isn't a perfect calculation because it doesn't consider the cost of capital. Also, it can't be used to calculate the rate of return of different projects that don't have exits on the same time horizon. It also doesn't take into account the size of the rate of the return, which should impact the interest of an investor. For example, an investor can choose to invest $20 for a return of $100, which has a much higher IRR than an investment of $20 million for a return of $40 million. Finally, IRR also does not factor in the risk of an investment, which is extremely important to most commercial real estate investors.

The IRR formula

Where,

t = time,

C = cash flow,

r = internal rate of return, and

NPV = net present value.

Through this formula, we see that the IRR for any commercial real estate property investment is simply the percentage that brings the property's net present value (NPV) to zero. Both IRR and NPV can be used in discounted cash flow (DCF) analysis to determine the current value of a set of cash flows using a predetermined discount rate. That makes it easy for investors to compare the potential investment gains from a commercial property to the potential gains from another investment, such as a stock, bond, or a different piece of real estate.

IRR vs. Modified Internal Rate of Return (MIRR)

Modified internal rate of return, or MIRR, is a variant of IRR that takes into account the fact that a commercial real estate investor is likely reinvesting any positive cash flow they receive into a different investment. It uses the investor’s estimated rate of return on this reinvested cash, known as the “reinvestment rate” to calculate an new IRR, or “modified” IRR that will more accurately represent an investor’s overall return.

IRR vs. Equity Multiple

IRR is often compared with equity multiple, another essential commercial real estate metric. Equity multiple can be calculated using the formula:

Equity Multiple = Total Cash Distributions/Total Equity Invested

Unlike IRR, equity multiple does not incorporate the concept of time value of money. In general, equity multiple is a better way to determine the overall return of an investment over a longer period of time, while IRR may be a better way to calculate the return of a shorter-term commercial real estate investment.

IRR Final Thoughts

The internal rate of returns is a key metric when it comes time to defining the relationship between time and yield on a commercial real estate investment. It is most commonly used by investors that have sensitivity to velocity of capital such as merchant builders. Regardless of your investment goals, it's important to understand all the metrics as they relates to commercial real estate investment underwriting.

Want to learn more? Fill out the form below to speak with a commercial mortgage specialist.

Tagged: Commercial Real Estate Loans Internal Rate Of Return IRR metrics commercial property underwriting