Analyzing and evaluating real estate investments requires more than old-style "gut instinct." Financial models have become vital tools in the decision-making process. Investors and developers are not always aware of the complexities of these models but need to understand the key metrics used.
Understanding the key metrics in real estate financial models involves analyzing the complex relationships, expressed as mathematical formulae, between assessed income, expenditure, and risk within a specific time frame relating to a proposed property-related transaction.
Constructing a financial model is a task I would leave to an expert (we offer a course on it), but that doesn’t mean one can simply accept the information it provides. Understanding the key metrics used is essential for making an informed decision about the risks and returns offered by a real estate opportunity. Let’s examine them in detail.
Heads Up; ‘Estimates’ are Used in Models
A real estate metric is a measure used to estimate a property's performance. The metrics' variables are often assumptions rather than actual values, as you look at future, not present, income and expenditure.
Always keep this in mind when reviewing real estate financial models.
Now let’s jump into the metrics.
Return on Investment
Return on investment (ROI) is a core metric that measures the rate of return an investor expects a real estate investment to produce as a percentage of their investment in the property. This metric lets investors compare various real estate investment options to determine the best opportunity.
ROI = (Investment Gain - Investment Cost) / Investment Cost
ROI measures the profit you would make if the property were sold and is effectively the difference between the current market value and the purchase price of the property plus all further costs.
Cash-on-Cash Return
While sometimes used synonymously with ROI, cash-on-cash return is a metric that, as the name implies, only measures the ratio of cash earned to cash spent during the year:
COCR= Annual Net Cash Flow/Invested Equity
It gives investors a clear understanding of the property's ability to generate cash flow relative to the initial equity investment. It is commonly used in assessing the performance of rented properties.
Net Operating Income
Net Operating Income (NOI) is a fundamental real estate financial modeling metric. Expressed as an amount rather than a percentage, it is the operating income a property generates after deducting all operating expenses. Financing costs, capital expenditures, and taxes are excluded from this calculation.
NOI=Gross Operating Income−Operating Expenses
Investors often use the NOI metric to assess a property's profitability and as a basis for further calculations, including property valuation and debt service coverage.
Debt Service Coverage Ratio
I’ve mentioned debt service coverage, so let’s examine this metric for the investor. It measures a property’s ability to cover its annual debt service payments (including interest).
It is calculated by dividing the annual Net Operating Income (NOI) by its annual debt service payments.
DSCR=NOI/Debt Service payments (principal and interest)
Real estate financial models include DSCR calculations to help investors understand the capacity of a property to repay debt and determine an appropriate loan amount and terms. A DSCR higher than 1 means that the property has sufficient income to cover debt payments.
Capitalization Rate (Cap Rate)
The Capitalization rate is a financial metric investors use to analyze real estate investments by determining their potential rate of return based on the net income a real estate investment is expected to generate over one year.
Cap Rate = NOI/Property Value
In training as a valuer, I learned that this equation can be used to calculate the cap rate if the other two variables are known but can also be used to establish market value for buyers by adapting it:
Property Value = NOI x Cap Rate
In this example, the cap rate is determined by comparing the subject property with similar examples in the area.
Net Present Value
Net Present Value (NPV) is an important metric but a little more complicated (I find) to calculate. It measures the present value of all future cash flows generated by an investment, discounted usually at the investor's required rate of return.
This, then, values the future income stream and provides a basis for deciding if a property is priced correctly. The complication is that you need to estimate both the timing and the level of future cash flows and decide on the minimum acceptable rate of return.
Here’s a link to assist you in calculating NPV.
Internal Rate of Return
Internal Rate of Return (IRR) is another essential real estate financial modeling metric. Where NPV is expressed in dollar terms, IRR is a percentage, the annualized rate of return an investment is expected to generate over the period it is held.
Taking the time value of money into account, IRR is the most accurate return metric. It provides investors with the best means of comparing the long-term profitability of competing investment possibilities.
To calculate the IRR of an investment, you need to set the NPV to zero and solve for the discount rate. Fortunately for non-mathematical real estate investors, Excel and other spreadsheet programs have built-in functions to calculate IRR.
Loan to Value (LTV)
This important metric is a lot simpler to calculate than IRR! Used by lenders and investors, it simply compares the loan amount with the property's assessed value.
LTV = Loan amount/Property Value
For the lender, the lower the LTV ratio, the less risk is involved in the investment, as the investor has a more significant stake in the property. The more equity invested, the lower the finance costs, so the investor also benefits from a lower LTV, although the risk is increased.
Yield On Cost (YoC)
The yield on cost is a helpful metric for investors focused on a property's income-generating potential. To calculate Yield on Cost, divide the property's stabilized Net Operating Income (NOI) by its total cost (including acquisition, construction, renovation, and other related expenses).
YOC = NOI/Total Project Cost
This is a simple metric but a good initial assessment of the viability of a real estate project.
Conclusion
There are other metrics, such as the Gross Rental Multiplier, the Equity Multiplier, and the Break Even Multiplier, but I’ve highlighted the nine key metrics that, when understood, will be of greatest value in creating an efficient and accurate real estate financial model.