Get to grips with the latest developments in real estate modelling. This intensive 3-days course will enable you to develop your own spreadsheets for different property types, allowing you to model any real estate investment scenario quickly and effectively.
•MODELLING BEST PRACTICES • IN-DEPTH CASE STUDIES
• ENHANCE REAL ESTATE PERFORMANCE
Back up your real-estate investment strategy with the ability to develop sound financial models
Learn to develop models for different property types allowing you to run investment scenario quickly and effectively. Build pro-forma models for the main property types, using statistical skills to better evaluate real estate investments and creating waterfall structure models, using advanced Excel features to conduct risk analysis. The focus will be on developing flexible models, which are easy to audit.
IN JUST 3 DAYS YOU WILL:
- Develop fully flexible financial models from scratch
- Develop detailed cashflow models, accounting for various lease structures
- Identify the strengths and weaknesses of a project
- Create sensitivity tables
- Incorporate risk into your model and conduct stress-testing simulations
- Conduct optimization analysis
- Explore various sources of capital in commercial real estate
- Examine a variety of private debt structures
- Model cashflows in MPTs, CMOs and CMBSs structures
raising capital and owning properties through REITs - Learn how to determine cost of capital for a REIT and apply REIT valuation models
MEET YOUR TRAINER
Our Expert Trainer is a well-recognised expert in real estate and corporate finance with over 15 years of experience in the field. She has consulted for investment professionals in the USA, the Caribbean, Europe, Asia, Africa and the Middle East. She has advised on the development, acquisition and disposition of commercial real estate (hotel, office, industrial, residential and mixed-use), M&As – valuation, post-merger integration, and exit opportunities; corporate restructuring; and business plan evaluation. She has also served as an advisor in setting up REITs and the use of tax-deferred exchanges.
She researches in the areas of commercial real estate valuation, real estate asset pricing, real estate in a mixed-asset portfolio corporate governance, real estate investment trusts and corporate financing strategy and restructuring. Our Expert Trainer has written several book chapters and published over 30 articles in leading international journals including the Journal of Banking and Finance, Financial Management, Journal of International Money and Finance, Real Estate Economics, Journal of Real Estate Finance and Economics, among others and has presented at 100+ international conferences. She has won multiple awards and grants for her work over the years.
Organisations that will benefit:
- Hotel Groups
- Real Estate Developers
- Investment Banks
- Property Developers
- Private Equity
- Property Consultants
- Investors
- Hedge Funds
- Banks
Who will attend:
- C-level Executives
- Project Managers
- Real Estate Analysts
- Financial Managers
- Risks Managers
- Investment Managers
COURSE AGENDA
Day 1: Real Estate Modelling ⇓
- Introduction to Real Estate Investment
- Real Estate as an Asset Class
- Cash Flow Analysis using Excel
- Excel Examples: Hotel investment valuation model; building two-way sensitivity tables
- Case Study: Conduct valuation of several different property types and make a recommendation to hold/sell based on portfolio target criteria
Day 2: Construction and Development ⇓
- Partnerships
- Case Study: Modelling a cashflow waterfall structure with preferred returns, promote structure and IRR lookbacks
- Construction and Development
- Excel Examples: Construction template
- Case Study: Modelling construction and development pro-forma cashflows for an office development project
Day 3: Real Estate Capital Markets ⇓
- Introduction to Capital Markets
- Sources of Private Commercial Debt
- Excel Examples: Participation loans; sale lease back; convertible mortgage; accrual loans
- The Secondary Mortgage Market
- Excel Examples: MPS, CMOs, IO-PO, CMBS
- Real Estate Investment Trusts
- Case Study: REIT valuation
- Case Study: Direct vs. indirect real estate investments; potential benefits from allocating part of assets to an indirect real estate vehicle such as a REIT
- Course conclusion
For further information please call: +44 (0)1372 308547
or click on the brochure tab below
“The Trainer knows the materials well and blends in real-life experiences with theory to demonstrate with applications to real-life situations. Very hands-on.”
- Past Client
“The Trainer is very knowledgeable and has a sound understanding of the topic.”
- Past Client