Real Estate Discounted Cash Flow Model Development and Design : The process of developing a new DCF model at a multinational real estate consultancy

Abstract: Due to increasing skill and awareness of overall functions in programs such as Excel, an increasing number of analysts at real estate firms and consultancies have started developing "desktop" versions of valuation models used for professional appraisal of property value. Due to personal preferences, differences in schools and professional backgrounds, these so called desktop models vary in quality, robustness, accuracy, design and user friendliness. Professional software suites are not suitable either, as they are expensive, hard to learn, hard to adapt to specific needs of the business, outdated design and need of additional IT resources. At a multinational Real Estate consultancy such as Jones Lang LaSalle, requirements on tools used for professional opinions on questions as important as property value, are rigorous. Therefore, decision was made to develop a new DCF model which would be closely monitored by management and have a prismatic approach meaning that the model would satisfy the needs of more than one division at Jones Lang LaSalle. When reviewing existing models and practices at the company, the result became a tailored DCF valuation model that was focused on increasing efficiency of appraisers at Jones Lang LaSalle. Aside from being robust and technically sophisticated, the result also suited the specific needs of Jones Lang LaSalle in terms of features and user interface. Development of the model involved several divisions to ensure that the needs were met for Research & Valuation, Capital Markets, Corporate Solutions and Asset Management at Jones Lang LaSalle.