Real Estate Risk and Sensitivity Analysis Bootcamp
The objective of this course is to equip participants with a comprehensive understanding of how to measure, model, and manage real estate investment risk using both deterministic and probabilistic frameworks.
Through hands-on financial modelling in Excel, participants will learn to apply techniques such as sensitivity analysis, dynamic scenario modelling, Monte Carlo simulation, and Value at Risk (VaR) to evaluate project performance under uncertainty.
The course bridges theory and application, empowering participants to make data-driven, risk-adjusted investment decisions aligned with professional portfolio and asset management standards.
Learning Outcomes
By the end of this course, participants will be able to:
- Identify and differentiate between key types of real estate risk (paradigm, business, and market) and understand their implications for investment strategy and modelling.
- Apply deterministic modelling techniques (one-way and two-way sensitivity analysis, dynamic scenarios) to quantify how changes in assumptions affect project viability and financial performance.
- Implement probabilistic frameworks such as Monte Carlo simulation and Value at Risk (VaR) to model uncertainty.
- Optimise portfolio risk and return using Excel tools such as Solver, enabling evidence-based decisions that align investment allocations with varying risk tolerances.
Who Will Benefit from this Course
This bootcamp is designed for professionals and students seeking to deepen their analytical and modelling skills in real estate finance and investment management, including:
- Real Estate Investment Analysts and Associates seeking to enhance risk analysis and scenario modelling skills.
- Portfolio and Fund Managers responsible for asset allocation decisions.
- Financial Modellers and Valuation Specialists who need to integrate deterministic and probabilistic frameworks into real estate models.
- Students, Academics, and Career Changers in finance, economics, or property investment looking to gain practical, Excel-based risk analysis capabilities.
Course Outline
Introduction – Exploring Real Estate Risk
- Risk Taxonomy
- Deterministic vs Probabilistic Frameworks
Base Model Overview
- Model Investment Assumptions
Deterministic Frameworks – Sensitivity Analysis
- One- way (Univariate) Sensitivity Analysis – Exercise
- Two – Way (Bivariate) Sensitivity Analysis – Exercise
Deterministic Frameworks – Dynamic Scenario Models
- Setting Up the Dynamic Scenario Model
- Defining Scenario Parameters
- Integrating Scenario Selection with XLOOKUP
- Base Case Scenario
- Best Case Scenario
- Worst Case Scenario
- Favourable Lending Scenario
- Poor Lending Scenario
- Strong Economy Scenario
Probabilistic Framework: Monte Carlo Simulation
- Step 1 – Creating the Monte Carlo Simulation Framework in Excel
- Step 2 – Setting the input Parameters
- Considerations for Setting Input Parameters
- Step 3 – Generating Random Values for Simulation Inputs
- Generating a Random LTV Value
- Extending the Randomisation Process to Other Inputs
- Step 4 – Simulation Results
- Simulated Scenario
- Base Case Scenario
Probabilistic Framework: Value at Risk (VaR)
- Interpreting VaR Results
- Three Key Elements of VaR
- Visualising VaR on the Distribution
- Calculating the Value at Risk of a 3-Asset REIT Portfolio (40 years)
- Analysis of Portfolio and Individual REIT Performance
- Portfolio Value at Risk (VaR) Assessment
- Optimising Portfolio Risk Using Solver
Bonus: Risk Analysis Automation with Python
Course Details
Time to complete: 10 Hours
Delivery: Online
Student Discount: Available on request
Buy Online: Online Learning Academy
Price Per Person
Online
- Course Delivery
- Course Files
- Online Learning Resources
