The internal rate of return (IRR) is a metric used by real estate professionals to determine the net money you’ve made on an investment by considering the timing and magnitude of the return. However, its main use is to compare investments. By calculating the IRR of many potential investments, you can see which one is wiser. The calculated IRRs must be higher than the company’s cost of capital, and whichever one is highest is the wiser investment (provided they have equal risk).
The manual calculation for IRR is highly complex, and can only be solved through tedious trial and error.
This equation is as complicated as it looks, and it’s only a three-year calculation. To solve it, you would have to keep testing potential IRRs until you get an NPV equal to zero. Your result would be the minimum percentage interest your company has to achieve in order to merely break even on an investment.
For such a tricky calculation, we highly recommend you use an Excel spreadsheet or a calculator such as this to make it go a lot smoother.
For more information on IRRs, check out the following links:
On how to calculate it manually
Mixed Use: 7.195
Office: 7.195
Retail: 7.195
2-4 Units: 7.195
Multi-Family: 7.195
Portfolio of 2-4 family homes: 7.195
single family: 7.195
portfolio of single family homes: 7.195
Principal and Interest: $0
Total Monthly Payment: $0