Internal Rate of Return (IRR) Calculator
Key Takeaways
- Internal rate of return (IRR) estimates the long-term yield of an investment while accounting for the time value of money.
- IRR is useful when investors want to compare multiple potential rental property investments over a longer ownership period.
- The IRR calculator uses inputs like initial investment cost, number of time periods/months, and net cash inflow to estimate projected return.
- By using an IRR calculator, you can compare projected cash flows more clearly and make more informed decisions about which investment opportunities best align with your goals.
Internal Rate of Return (IRR)
When evaluating an investment property, using rental metrics and analytics is crucial for making informed decisions. Metrics provide a clear picture of a property's current or potential financial performance, helping investors gauge profitability and mitigate risks.
Internal rate of return (IRR) is one metric that can help investors optimize their portfolios, ensuring they make the most out of their real estate ventures. Using an online calculator to find IRR is a simple and efficient way to measure the profitability of your investment.
What is IRR?
Internal rate of return, or IRR, is a metric commonly used by investors during capital budgeting to predict the long-term yield of an investment while accounting for the time value of money. It estimates a property's profitability over the period you will own it, expressed as a percentage you could generate based on each individual dollar invested.
Because IRR is a uniform investment metric, it can be used to compare multiple potential investments and make decisions about which ones to pursue. The property with the highest IRR can be considered the one with the most profit potential.
IRR Formula
IRR is rarely calculated by hand. Most investors interested in knowing their IRR will use an online IRR calculator or spreadsheet to quickly find IRRs for multiple properties. However, taking a quick look at the formula can help you better understand the required inputs (what you need to know before you can calculate IRR) as well as the output of the formula.
Below is the IRR formula:
To understand this formula, it's helpful to focus on the left half first: Net Present Value (NPV). NPV is the difference between the present value of cash inflows and outflows over a period of time. You'll notice that the NPV is calculated using the right half of the formula above. If NPV is greater than zero (NPV > 0), the investment is expected to generate more cash than the initial investment amount. This would indicate a profitable investment, where net cash flow is positive. On the other hand, if NPV < 0, the investment is expected to generate less cash than its cost-not profitable.
IRR is based on NPV. IRR is essentially a discount rate that makes the total value of the investment equal to zero. In other words, it's the rate at which the NPV equals zero. That's why the whole formula is set equal to zero above.
Overall, IRR represents the annualized effective compounded return rate of a potential investment. It's a powerful metric that many investors use to compare their projected cash flows in a slightly more sophisticated way than is possible with ROI.
IRR Formula Breakdown
| IRR Component | What It Means |
|---|---|
| IRR | The annualized effective compounded return rate of a potential investment. |
| NPV | Net present value of the cash flows. |
| Ct | Net cash inflow during a specific time period. |
| C0 | Total initial investment costs. |
| t | Number of time periods, such as 12 months. |
| Time value of money | The idea that money available now is worth more than the same amount in the future because of its earning potential. |
When to Use IRR
The IRR calculation is best used for determining the future value of a real estate investment in comparison to other investments. It's a helpful tool for making decisions and tipping the scale in one way or another when you aren't sure what the investment performance will look like for all your options. Because IRR also accounts for the time value of money and other long-term factors relevant to future cash flows, it can give you a more accurate assessment of a property's potential value in the future based on its value today.
How to Use the IRR Calculator
Using REI Grove's IRR real estate calculator can save you time and effort when evaluating properties. Rather than grappling with the complex formula above, you can simply enter the following inputs to get an accurate estimate of your IRR.
Inputs
Below are the inputs you'll need to use this IRR real estate calculator:
- Initial investment cost
- Number of time periods/months
- Net cash inflow
Initial investment cost is the amount of money you initially invested in a property. This would be equivalent to the property's purchase price if you paid in cash, or the down payment you made plus closing costs and any other upfront investments if you financed the purchase.
The number of time periods/months is simply the number of "periods" the formula will iterate over, usually just '12' for an annual analysis divided into monthly periods.
Lastly, your net cash inflow is your investment return over one month (or the period you specified above). In other words, this would be the rental income your property generated over a month minus its expenses. It's the difference between the property's cash inflows and outflows.
IRR Calculator Inputs at a Glance
| Input | What It Means | Examples or Notes |
|---|---|---|
| Initial investment cost | The amount of money initially invested in the property. | Purchase price for a cash purchase, or down payment plus closing costs and upfront investments for a financed purchase. |
| Number of time periods/months | The number of periods the formula will iterate over. | Usually 12 for an annual analysis divided into monthly periods. |
| Net cash inflow | The investment return over one month or another specified period. | Rental income generated during the period minus expenses. |
Outputs
The IRR calculator will generate two outputs based on the above inputs you enter:
- Interim cash flow analysis over each period
- IRR (%)
The interim cash flow analysis allows you to see your projected cash flow for each interim period of the whole (in the usual case, for each month of the year). The calculator will also generate your projected IRR, specified as a percentage.
IRR Calculator Outputs at a Glance
| Output | What It Shows |
|---|---|
| Interim cash flow analysis | Projected cash flow for each interim period, usually each month of the year. |
| IRR (%) | The projected internal rate of return, expressed as a percentage. |
How to Interpret Your IRR
What is a good IRR?
Generally speaking, the higher the IRR, the more profitable the investment will be. However, whether a specific IRR is "good" or "bad" also depends on the other options you're comparing, your individual goals as an investor, and your personal risk tolerance.
For instance, let's say you're comparing two properties: Property A with an IRR of 27% and Property B with an IRR of 20%. It might seem like Property A is obviously the best choice, as it has the higher profit potential.
However, let's say Property A has a longer development timeline or needs major initial rehabbing before it can be operational. If you don't have the experience or bandwidth to take on that large of a project, Property B might actually be the better choice from a holistic sense-despite the fact that you'll be taking on slightly more risk and trading some profit potential for less time and effort.
As you can see from the above example, IRR is just like any other real estate metric in that it should be considered in context. For the most complete understanding, it's best to pair IRR with other informative metrics like ROI, cap rate, annual growth rate, and others.
Conclusion
Internal rate of return (IRR) is a powerful metric for real estate investors, offering a comprehensive view of an investment's potential profitability over time. By understanding IRR, investors can make more informed decisions and compare multiple investment opportunities with greater confidence that positive cash flows will result.
Using an IRR calculator online, like REI Grove's, simplifies this complex calculation, saving time and ensuring accuracy for your planning.
FAQs
What is IRR in real estate?
Internal rate of return (IRR) is a metric investors use to estimate the long-term yield of a real estate investment while accounting for the time value of money.
How do you calculate IRR?
Most investors use an online calculator or spreadsheet to calculate IRR because the formula is complex and requires finding the discount rate that makes the net present value of future cash flows equal zero.
What inputs do I need for an IRR calculator?
To calculate your IRR, you'll need initial investment cost, number of time periods/months, and net cash inflow.
What does initial investment cost mean?
Initial investment cost is the amount of money initially invested in the property. This may include the purchase price for a cash purchase, or the down payment, closing costs, and other upfront investments for a financed purchase.
What does net cash inflow mean?
Net cash inflow is the investment return over one month or another specified period. It is the difference between the property's cash inflows and outflows.
What does an IRR calculator output?
An IRR calculator typically outputs interim cash flow analysis over each period and the projected IRR percentage.
What is a good IRR?
Generally speaking, the higher the IRR, the more profitable the investment will be. However, whether an IRR is "good" depends on the investor's goals, risk tolerance, and the time or effort required for the investment.
Should investors only use IRR to evaluate a property?
No. IRR is useful, but investors should also consider metrics like ROI, cap rate, annual growth rate, and other property-specific factors before making an investment decision.
How is IRR different from ROI?
IRR accounts for the time value of money and projected cash flows over time, while ROI offers a simpler comparison of return relative to the cost of the initial investment.