Real Estate Finance & Modelling for Development & Investment (Online Course)
WHEN
TBA
WHERE
Live Online Course
BOOK NOW
Limited seats available.
Register 3 persons to enjoy group discount.
Overview
Real estate construction or investment requires a high level of technical expertise in building and using financial models if the building is to be profitable for its builder or owner. This has not always been available, with the result that a large percentage of real estate has been built or bought without the necessary understanding or planning to underpin decision making. The consequence of this lack of planning has often been disastrous, especially in a crisis.
Session 1 – 4 will teach you all the available techniques of real estate finance, investment and development, and how to apply them practically through the use of Excel, as well as providing insights into real estate modelling software such as Argus/Estatemaster. An extensive use of international case studies will be adopted to illustrate the principles covered. Ultimately delegates will get practical tips on layout and style in building and analysing user-friendly models which are available as additional benefits of the course as well as developing management, investment and sales skills for the massive global real estate market.
Session 5 – 8 will teach you all the available techniques and how to practically apply them through the use of Excel. Laptop will be required and an extensive use of case studies will be adopted to illustrate the principles covered. Ultimately delegates will get practical tips on layout and style in building and analysing user-friendly models which are available as additional benefits of the course.
Benefits of Attending
- Learn market analysis techniques, data and reports
- Analyse the risk and returns of investing in real estate
- Evaluate discounted cash flow valuation, investment and development frameworks and financial models for lending analysis
- Analyse and build robust models for complex property development and portfolio
- Take away a wide range of financial models for real estate
Live Online Course – How It Works
The structure of our virtual learning program is designed to keep the same levels of engagement and networking as our on-site public courses. Course content is delivered through our easy-to-use online learning platform and is supplemented by case studies and practical exercises.
Like our classroom-based public courses, you will have live interaction with our course facilitators and other participants. Our live online courses are led by our experienced instructors, who will provide you with easily digestible content, using knowledge learned from many years in the industry, during scheduled times. Delegates will receive copies of the course materials electronically.
This course is scheduled to take place over 8 live online sessions using virtual learning technology.
Course Agenda
Session 1: 23rd July 2020, 8 – 11:30am GMT+1 (London time)
Property and the Economy
- Real estate in the economy
- Case Study: Rising land values and their measurement
- Valuation of real estate
- Case Study: The concept of valuer independence
- Case Study: Winners and losers. The impact of Covid-19 on real estate markets around the world
Session 2: 27th July 2020, 8 – 11:30am GMT+1 (London time)
Analysing Real Estate
- Key building blocks
- Exercises: The use of comparables to derive property values
- The decision to invest
- Homework: Net Present Value and Internal Rate of Return
Session 3: 29th July 2020, 8 – 11:30am GMT+1 (London time)
Financial and Legal Structures in Real Estate Analysis
- Financial leverage in real estate
- Exercises: calculating mortgage payments and structures
- Real estate models
- Legal issues in property investment
- Homework: Evaluating and comparing examples of feasibility studies
Session 4: 5th August 2020, 8 – 11:30am GMT+1 (London time)
Management, Markets and Risk
- Real estate sales and marketing
- Case Study: How to market real estate in the Covid-19 crisis
- Indirect property investment
- Management and risk
- Case Study: Managing real estate in the Covid-19 crisis
- Homework: Using sensitivity, scenario and Monte Carlo analysis in a real estate financial model
Session 5: 6th August 2020, 8 – 11:30am GMT+1 (London time)
Financial Modelling in Excel
- Using Excel for modelling
- Homework: Evaluating good and bad Excel financial models
- Equity valuation
Session 6: 11th August 2020, 8 – 11:30am GMT+1 (London time)
How Real Estate Models Work
- Objectives and elements of real estate models
- Case Study: Evaluating valuation and cash flow models
- Real estate development modelling issues
- Real estate investment modelling issues
- ARGUS/ESTATEMASTER – an alternative to Excel real estate models
- Case Study: Demonstration of Argus
- Methods of handling risk
- Homework: Review of several real estate development (CS) and real estate investment (BL) models and their decision-making input
Session 7 & 8: 13th & 18th August 2020, 8 – 11:30am GMT+1 (London time)
Building A Real Estate Model
- Based on a real example, provided by an equity investor in a real estate transaction, delegates will build a real estate BL model.
- Homework: step-by-step input, operations, amortisation and valuation worksheet creation
- Course Conclusion
Training Methodology
This course will teach you all the available techniques and how to practically apply them through the use of Excel and other softwares. Extensive use of case studies will be adopted to illustrate the principles covered. Ultimately you will get practical tips on layout and style in building and analysing user-friendly models which are available as additional benefits of the course.
Pre-Course Questionnaire
We would like to customise the workshop based on your specific needs. Pre-Course Questionnaire will be sent prior to the workshop for analyse in advance and to be addressed during the course.
Course Certificate
Upon the successful completion of this course, you will receive a Certificate of Completion bearing the signatures from both the Course Director and the Course Organiser. This Certificate will testify your endeavour and serve towards your professional advancement.
Who Will Attend
- Real estate developers
- Investors
- Banks & lawyers
- Government & regulators
- Fund & asset management
- REITs
- Hotel groups
- Tax, legal & accounting consultants
- Market analysts
You Might Also Be Interested In
Real Estate Finance, Investment, Valuation & Modelling
You will learn all the available techniques of real estate finance, investment and development, and how to apply them practically through the use of Excel, as well as providing insights into real estate modelling softwares
Dates To Be Advised
Public Private Partnership (Online Course)
Mastering PPP project analysis, financing, contracts & transaction management techniques
Dates To Be Advised
Project Finance & Project Financial Modelling (Online Course)
Project finance and financial modelling best practices with practical case studies