Real Estate Modelling

Delegates will gain a thorough practical understanding of the intricacies of Excel real estate financial models. They use the construction of an office tower as a working project, and build both a Construct & Sell and Buy & Let model. Using proven templates, delegates cover the role of debt and equity, construction debt corkscrews, debt repayment waterfalls, debt covenants, how to model risk, and the effect of taxation and depreciation on debt and equity. Agenda Summary ï Using Excel for Modelling ï Equity Valuation ï Fundamentals of Real Estate Models ï Real Estate Development Modelling Issues ï Real Estate Investment Modelling Issues ï ARGUS and ESTATEMASTER ñ An Alternative to Excel Real Estate Models ï @RISK ñ Monte Carlo Software Case Studies and Exercises ï Evaluating Good and Bad Excel Financial Models ï Valuation and Cash Flow Models ï Examples of Real Estate Development Models ï Review of Several Real Estate Investment Models and Their Decision-Making Input ï Building a Construct and Sell (CS) Model ï Building a Discounted Cash Flow Model (DCF) Model