
What Makes Tampa Commercial Real Estate Shine: Industries
The state of Florida and Tampa has one overriding major industry that is senior to all other industries. I call it the “population growth industry” 😊.
Checking the performance of stocks and bonds can be easily done by logging into a brokerage account for updates. However, identifying current and future real estate returns is much more difficult because the same property does not change hands every day.
Of the various financial analysis metrics available to real estate investors, IRR is one of the most often used calculations. IRR in real estate incorporates key investment criteria to help identify property that meets the specific goals of each individual investor.
Internal rate of return (IRR) is a financial metric used to measure the profitability of an investment over a specific period of time and is expressed as a percentage. For example, if you have an annual IRR of 12%, that means you have 12% more of something than you did 12 months earlier.
The IRR calculation combines profit and time into one formula:
A good way to think about IRR is that it is the discount rate – or interest rate – that makes the net present value (NPV) of the cash flows you receive equal to zero.
By weighting the periodic cash flows, IRR helps you to make a fair comparison to alternative investments with cash flows that occur at different points in time. That’s because a dollar actually received today is worth more than the promise of a dollar received several years from now, due to factors such as inflation, unknown future events, and general investment risk.
As a real estate investor, you have a required rate of return on the capital being deployed in order for the investment to make sense. Everything else being equal, the investment that generates an IRR greater than or equal to your required rate of return will be worthwhile taking a closer look at.
The formula for calculating IRR looks like this:
Source: Corporate Finance Institute
Although it may look complicated at first, the IRR formula is easier to understand when you isolate the different parts. Now let’s look at some examples of how IRR is used in real estate investing.
Let’s assume you invest $100,000 in a property with a holding period of five years. If you choose the wrong investment and have no cash flows and no profit or loss at the time of sale, your IRR is 0%.
However, the three more likely potential outcomes are:
Assuming your required rate of return is 6%, the only outcome that is worth considering is the last one with an IRR of 15.66%.
In real life, investment real estate works quite a bit differently, with cash flows varying from month to month and year over year. To easily explore different IRR scenarios, you can create a simple Excel spreadsheet with three columns:
You may also want to create one field for your financing rate and another field for your reinvestment rate. Then, you can use three different Excel functions to calculate IRR:
Microsoft has an easy-to-understand guide of how to calculate NPV and IRR in Excel: Go with the cash flow
Note that in order to calculate the potential IRR of a real estate investment you’ll need to make four assumptions:
Minor changes in these four assumptions can have a significant impact on your IRR, such as receiving cash flows monthly or annually.
For example, if you invest $100,000 and receive $1,000 the first month, you now have $101,000. That’s 1% more than your original investment, and a monthly IRR of 1%.
Assuming your investment grows by 1% each month, in the second month you would have made $102,010 ($101,000 x 1.01), and by the end of 12 months you would have made a total of $12,682.50 from your original investment.
The annual IRR of 12.68% ($112,682.50 / $100,000) – 1 = 0.1268 or 12.68%. On the other hand, if you received a single annual distribution of $12,000 from your $100,000 investment, your annual IRR would be just 12%.
IRR is a comprehensive way of thinking about the potential profitability of a real estate investment.
When you think about what a good IRR is, it’s important to take a detailed look at the prospective investment and understand that an IRR isn’t always what it appears to be.
For example, a project may boast a big top-level IRR, but the net IRR to you as an investor is lower because of asset management fees taken by the developer or sponsor before distributions are made. On the other hand, an IRR may be understated due to the industry standard of calculating investment returns on an annual basis, when distributions are actually made monthly or quarterly.
Core Plus, Core, and Value Add investments will also yield different IRRs due to the anticipated income stability and the level of risk:
IRR is a good way to calculate the potential returns of a specific property. However, the IRR calculation is just one of the many formulas you can use to calculate investment returns:
Levered or leveraged IRR uses the cash flows when a property is financed, while unlevered or unleveraged IRR is based on an all cash purchase.
Unlevered IRR is often used for calculating the IRR of a project, because an IRR that is unlevered is only affected by the operating risks of the investment. On the other hand, levered IRR is influenced by both the operating risks and potential financing risks such as interest rate changes or the lender requirement for an additional down payment if the property is underperforming.
The IRR and MIRR functions in Excel can be used to calculate potential IRRs for investments that are unleveraged and leveraged.
Both IRR and NPV have several things in common such as using periodic cash flows, taking into account the time value of money, assumed rental rates, and exit selling price. But there are some significant differences between IRR and NPV as well.
NPV indicates the potential return on a project in terms of dollars, while IRR represents a percentage return. When investing in a value add property, NPV may provide a better idea of a project’s value. NPV does not change if cash flows fluctuate between positive and negative over the holding period while IRR results may be ambiguous.
ROI provides a quick measurement of return by dividing the gain from an investment by the cost of the investment. While calculating ROI is easy to do and understand, it is best used for investments held for a short period of time. That’s because ROI does not take into account the length of time needed to generate the return, so an investment held for one year or 50 years could have the same ROI.
ROI focuses on profits rather than distributions. As with NPV, the ROI calculation is not affected by cash flows that change from positive to negative and back again, while calculating the IRR of an investment with varying cash flows can lead to inconclusive results.
Equity multiple is calculated by dividing the total cash distributions from an investment to the amount of equity invested. If you invest $100,000 and get back $300,000, your equity multiple is 3.0. On the other hand, IRR measures the compounded annual percentage rate earned on each dollar invested over the holding period, and also takes into account the time value of money.
Because of the way IRR is calculated, a property may offer a high IRR and return your capital faster but may not create more profit. Both IRR and equity multiple are important calculations to understand, but by putting too much emphasis on IRR an investor may overlook a property that generates greater returns on equity.
IRR measures your total return of the entire holding period of an investment, while cash on cash return gives you the current return on your investment. Cash on cash is calculated by dividing the cash received over a certain period of time – usually a given year – by the cash invested to realize that return.
For example, a property that returns $10,000 in profits from a $100,000 investment would have a cash on cash return of 10%. If the profits next year are $5,000, the cash on cash return would be 5%, followed by 15% in year three if the property generates profits of $15,000. Using this same scenario, the IRR would be 9.85% over the holding period, including return of the original investment.
XIRR is an Excel function that allows you to assign specific dates in each periodic cash flow, which in turn makes the internal rate of return calculation more accurate. That’s because the IRR function in Excel calculates the internal rate of return over annual periods at the end of the year.
Because IRR calculations are time sensitive and give more weight to cash flows that are received earlier in the investment, using XIRR to tell Excel that cash flows begin in Q1 or Q2 rather in one lump sum on December 31st can have a significant positive impact on the calculated rate of return.
WACC (weighted average cost of capital) represents the combined average cost of equity and debt used to acquire an investment. Investors use WACC to set the minimum base rate of return before deciding whether or not to invest.
The formula for WACC weights the cost of equity and debt used to finance a property using the following formula:
With LTV being the loan-to-value ratio, CD the interest rate of the loan, and CE the required rate of return or IRR by investors. In the above example, the required rate of return is 0.12 or 12%, which must be greater than the WACC in order to cover the cost of financing.
TWR (time weighted return) is normally used in open-end investment funds to capture the true performance of a property by eliminating the effects of capital contributions, withdrawals, management, and advisory fees. The calculation allows an investor to analyze the true performance of an asset and the investment manager, versus just the return on capital invested.
TWR is calculated by dividing performance periods into monthly or quarterly intervals, calculating the IRR for each interval, then linking the periodic IRRs together to determine the overall TWR of an investment.
In essence, TWR calculates the return if the property were purchased at the beginning of each period and sold at the end of each period. By contrast, the traditional IRR calculation is based on the initial acquisition price, periodic cash flows, and sale price at the end of the holding period.
It’s important not to rely on any single metric when you analyze potential real estate investments, and IRR is no exception.
To be fair, IRR does provide several advantages, such as the timing and present value of future cash flows, ability to compare the potential returns of a project to your unique investment criteria, and relative ease of calculation when using an Excel spreadsheet or financial calculator.
However, the IRR of an investment does not take into account important factors such as the viability and risk of a project, unanticipated capital expenses, or the actual profit in terms of dollars. Future rental rates and vacancy levels can also be difficult to predict, with erroneous assumptions making an IRR calculation widely overstated.
Lastly, as we’ve seen in this article, IRR calculations can easily be manipulated to make returns greater than what they actually are to an investor.
That’s why it’s important for investors to develop their own set of metrics and calculations to use when evaluating a potential real estate investment. At the end of the day, IRR is just one of many ways to help decide whether or not a property makes good investment sense for you.
Sign up to learn more about how to invest in office buildings and to get early access to our next investment opportunity.
The state of Florida and Tampa has one overriding major industry that is senior to all other industries. I call it the “population growth industry” 😊.
A boom market makes real estate investing look easy. Investors chasing fast yields flood the market, bidding properties up to the point where the yield isn’t there.
Experienced commercial real estate investors and tenants always use a LOI when entering into a potential transaction or buy, sell, or lease office space. Although LOIs are frequently used to buy or lease commercial real estate, parties sometimes make critical mistakes that could easily be avoided.