According to the Wall Street Journal, 99% of big real estate developments fail in some fashion. Today, with so much data available, financial modeling has become a crucial tool, but inaccurate data can lead to costly decision errors. I’ve seen even expert modelers making mistakes, and you, as an investor, must understand and avoid these pitfalls.
Common mistakes found in real estate financial models include making inaccurate assumptions, miscalculating income and expenditure projections, and misjudging macroeconomic trends. Neglecting to update the model regularly to reflect market variations, is another commonly found issue.
A good real estate financial model allows investors to analyze accurately the returns that can be expected from a real estate project and the risks involved. The model can be the deciding factor in whether to invest in or proceed with a project. In this article, I'll briefly identify the common mistakes in real estate models and discuss how to avoid them.
Real Estate Financial Modelling–Avoiding Common Mistakes
Most of the mistakes in the financial real estate models I’ve studied result from the misinterpretation or misjudgment of the data available, whether related to project-specific assumptions or more general macroeconomic factors.
Under-Estimating Finance Costs
The financing of a real estate project involves a blend of lenders, each with their own set of criteria:
- Senior debt is finance acquired from banks or bondholders, provided on a “last in, first out” basis. They provide finance only after the subordinated debt has been fully utilized, and it is then used to complete the project. Repayment of this debt takes priority over all other repayments. Interest is characteristically lower because of reduced risk.
- Subordinated or Junior Debt is unsecured debt provided by preferred or common lenders in the project, who are paid at a higher interest rate.
- Shareholders provide third-party equity and share in the profits generated if and when the real estate development is sold.
The weighted average cost of capital will depend on the blend of senior and junior debt and the nature of the real estate project. Assessing the cost of capital requires creating a model that takes into account interest rates, timing of draws and repayments, and cash flow.
It is a complex calculation and one that is easy to underestimate. The best way to avoid this mistake is to employ an expert financial modeler who understands all the many variables involved in calculating the least costly alternative.
Making Unrealistic Assumptions
Most of us in the real estate industry are unrepentant optimists. While realistic forecasting of income and expenditure is the basis of all real estate financial modeling, an enthusiastic developer or investor can make overly optimistic assumptions. They may look great on paper but don’t translate into reality.
- Miscalculating Rental Income: Overoptimistic estimates of rental values and anticipated growth, as well as underestimating vacancies and turnover rates will affect income forecasts. Overlooking the risks associated with poor-quality leases will also have a similar impact.
- Inaccurate Projection of Expenses: Income is one variable in assessing a property's NOI (Net Operating Income), an essential element of the financial model. Incorrect estimates of future expenses such as maintenance, management fees, insurance, and local, state and federal taxes is the other side of that coin.
You will need to exercise due diligence to avoid mistakes in assessing projected income and expenses. Market research of comparable properties in the area will provide accurate information on which to base forecasts. I suggest also that you consult real estate specialists in the area regarding rentals, local market forces that affect the supply of and demand for the specific property type, and other relevant information.
Ignoring Macroeconomic Trends
Many property developers and investors in residential and commercial real estate tend to assume that there is a reliable upward trend in prices and value, with the occasional but temporary exception that can be overlooked in the long term. Let me tell you—that’s a dangerous assumption to make.
Real estate financial models are subject to cyclical changes in national and international markets and are affected by factors far beyond local fluctuations. Political stability, interest rate changes, economic trends, and inflationary pressures will all affect a project's viability and you must consider this when making any investment decisions.
Let me explain. Over the last 30 years, commercial construction cost inflation has averaged 4.2%, and for residential, 4.6%—generally about double the consumer price index. In periods of rapid growth, this can grow to as much as 8% and 10%, respectively. Since 2020, the cost of building materials has increased by 37.7%.
When building a financial model for a potential property investment, you must look at historical data, establish where on the economic cycle your proposed project currently stands. Consider adjusting your model to take current trends into account, such as market confidence, interest rates, construction costs, and rental demand.
Not Identifying an Exit Strategy
The financial viability of any property depends on the owners' exit strategy. Will it be sold once the project is complete, or will it be refinanced and held for a period? What will the residual value of the property be once completed, and what will the highest return on investment?
Avoid this uncertainty by having a defined end plan in place before embarking on the project. Alternatively, use different scenarios in the financial model to establish the various returns that can be expected, given market trends during the investment period.
Over-Complicating the Financial Model
The more variables you build into your model, the more accurate it will be. But the more complex it is, the less understandable it will be and the more likely to have mistakes and inaccuracies.
To make the financial model clear and understandable, include only the most important variables and keep the model easy to follow. The assumptions used should be based on verifiable data, and the whole model should be reviewed regularly to make adjustments necessary to reflect current market trends.
Conclusion
Real estate financial modeling is essential in establishing the viability of a property acquisition or development. A robust model balances complexity with practicality, and the modeler ensures the variables are accurate, updated, and relevant. Knowing how to avoid mistakes is critical to making the right real estate investment decisions.