# IRR Internal Rate of Return (IRR) definition

The main idea behind any investment is simple: to invest money with the hope of gaining greater financial benefits when sold. In real estate, this means expecting a profit upon selling. But how can you confirm this expected profit before investing? The Internal Rate of Return (IRR) provides an answer. This article explains the role, working, and applications of IRR in real estate investment.

What is IRR?

Given the unpredictability of future events and volatile economies, determining the exact return on investment is impossible. However, smart investors make informed predictions. This is where IRR comes in. IRR is a discounted cash flow analysis that indicates the break-even point and predicts the profitability of potential investments, including real estate.

Essentially, IRR estimates the annual growth rate of an investment. Knowing the potential returns helps investors decide whether to proceed. Calculating IRR is similar to net present value (NPV), but with NPV set to zero. In simpler terms, IRR determines the expected annual growth rate of an investment.

To understand IRR, grasp the concept of net present value (NPV). NPV measures the difference between the current value of cash inflows and outflows over a given period. For real estate investments, inflows could be tenant rents, while outflows could include mortgage payments and maintenance costs. NPV helps businesses decide whether to invest based on expected cash generation and predicts potential earnings or losses from a project.

Understanding the discount rate is crucial in understanding IRR. Future money is worth less than present earnings. The discount rate calculates the value of future cash flows when determining an investment’s present value.

At its core, IRR determines the rate at which an investment generates returns. A higher IRR indicates greater potential for profitability. IRR considers all cash flows, positive or negative, and the required rate of return that balances them to zero.

Due to these reasons, IRR is considered one of the most reliable methods for measuring risk-adjusted returns. Real estate investors should consider IRR when assessing investment properties or decisions involving capital expenditure.

How is IRR Calculated?

To calculate IRR, you need two components:

1. Cash Flows, including expected cash outflows and inflows
2. Total Initial Investment Costs

Once you have these two components, you use them to develop the IRR formula. First, set the NPV to zero (solving for the discount rate). Next, divide the future value by the present value, raise it to the inverse power of n (1 ÷ n, where “n” represents the number of investment periods), and subtract one from the result. The IRR formula can be expressed as Internal Rate of Return (IRR) = (Future Value ÷ Present value)^(1 ÷ Number of Periods) – 1. Simplify the process by using an IRR calculator.

Remember, when applying the IRR formula, every investment has a cost, and the initial payment is an outflow. Future cash flows depend on the accuracy of our return prediction and any additional capital required for success.

Calculating the IRR manually can be complex and involve guesswork to achieve an NPV of zero. That’s why financial analysts and investors rely on software, like Microsoft Excel, to determine the IRR. Excel simplifies the process with its IRR function, allowing easy input of cash flows. To access the feature, click the Formulas Insert (fx) icon in Excel.

Excel’s IRR function also offers two related calculations: the XIRR function and the MIRR function. The XIRR function calculates the IRR when cash flows are unevenly spaced, accommodating varying dates of investments and withdrawals. The MIRR function considers reinvestment and borrowing rates, improving on the IRR formula.

Excel’s IRR function assumes a constant discount rate for all cash flows and considers positive and negative cash flows to estimate investment profitability. It’s an essential tool for financial analysts and investors when evaluating potential investments.

IRR is used in various applications, such as determining the value of real estate projects and comparing prospective returns for new business ventures. It’s also relied upon when evaluating stock buyback programs to ensure higher ROI compared to alternative fund usage.

Investors can leverage IRR to compare different assets and make informed decisions. According to the IRR Rule, projects with an annual rate of return higher than the minimum required return should be accepted. Organizations often use their Weighted Average Cost of Capital (WACC) as the benchmark for hurdle rates.

It’s worth noting that there isn’t a standard “good” IRR as it varies based on project type, size, and investor preferences. Generally, an IRR of 18% or 20% is considered very good in real estate. A positive IRR is desirable, while a negative IRR indicates a potential loss. However, it’s important to keep in mind that IRR reflects capital expenditure and proceeds and does not account for external factors like inflation and cost of capital.

When comparing IRR to other metrics like CAGR or ROI, consider the nature of the investment or project. CAGR is suitable for consistent cash flow streams, while IRR is beneficial for complex investments with varying cash flows.

For example, let’s consider an investor who buys two rental properties and expects cash flow from monthly rent payments. Over five years, the investor invests a total of \$200,000, including the initial investment. Property A starts generating positive cash flows in its fourth year, while Property B starts generating positive cash flows in its first year. By the end of year five, both properties yield an ROI of \$300,000, but at different times. The internal rate of return (IRR) of Property B is higher because it starts generating profits earlier than Property A.

In conclusion, the IRR formula is a crucial tool in financial analysis, helping investors and analysts evaluate the profitability of potential investments. It maximizes investment opportunities.

## Invest easily in real estate with Foothold

If you want to invest in real estate, check out our available properties here.