Analysis: Scenarios & Sensitivities
Learn how to assess risk and evaluate opportunities using scenario analysis and sensitivity modelling in Excel. Build practical skills in cash flow analysis, assumption testing, and data tables used in real estate financial modelling and investment underwriting.
DIFFICULTY LEVEL: Beginner
CPD HOURS: 4.0
Analysis: Scenarios & Sensitivities
Learn how to assess risk and evaluate opportunities using scenario analysis and sensitivity modelling in Excel. Build practical skills in cash flow analysis, assumption testing, and data tables used in real estate financial modelling and investment underwriting.
DIFFICULTY LEVEL: Beginner
CPD HOURS: 4.0
Course Overview
Strong real estate analysis is not just about building a model - it’s about understanding how changes in assumptions impact performance, risk, and investment decisions.
This course introduces the principles of scenario analysis and sensitivity modelling used in commercial real estate financial modelling, helping you understand how analysts evaluate uncertainty, test assumptions, and assess downside risk across investments and developments.
You’ll learn how to build and apply sensitivity tables in Excel, analyse the impact of changing assumptions, and use practical techniques to improve investment analysis and underwriting decisions.
Using real estate examples throughout, the course focuses on the practical application of scenarios and sensitivities in cash flow modelling, valuation analysis, and investment underwriting.
Whether you are new to financial modelling or looking to strengthen your analytical skills, this course provides a practical introduction to one of the most important areas of real estate investment analysis.
What you will learn
By the end of this course, you’ll be able to:
Understand what scenario analysis and sensitivity analysis are and why they are important in real estate financial modelling
Assess risk and evaluate opportunities using different modelling assumptions
Identify the most common assumptions tested in commercial real estate analysis
Build and use sensitivity tables in Excel
Apply scenario analysis techniques to investment and development cash flows
Understand how changes in rent, yield, timing, costs, and finance assumptions impact returns
Improve cash flow analysis and investment underwriting techniques
Use key Excel functions, formulas, and shortcuts to support financial analysis
Present clearer, more informed investment recommendations using sensitivity analysis
Who this course is for
This course is designed for anyone looking to improve their analytical and financial modelling skills within commercial real estate.
It is particularly valuable for:
Real estate analysts and graduates
Investment and acquisitions professionals
Development and asset management professionals
Surveyors and valuation professionals
Anyone involved in underwriting or investment decision-making
Professionals looking to improve Excel-based risk analysis skills
No advanced modelling experience is required.
Ready to improve your analytical skills?
Join the EiP Academy to access this course alongside the full library of real estate financial modelling training, live support sessions, downloadable tools, and practical commercial real estate case studies.
FAQs
What is scenario and sensitivity analysis?
Scenario and sensitivity analysis are techniques used in financial modelling to assess how changes in assumptions impact investment performance, cash flow projections, and returns.
Why is sensitivity analysis important in real estate?
Sensitivity analysis helps real estate professionals understand risk, test assumptions, and evaluate how changes in variables such as rent, yield, costs, timing, and finance can affect investment outcomes.
Will I learn how to build sensitivity tables in Excel?
Yes. The course includes practical training on how to build and use Excel data tables and sensitivity analysis tools commonly used in real estate financial modelling.
Is this course suitable for beginners?
Yes. The course is designed as an accessible introduction to scenario and sensitivity analysis, making it suitable for beginners and early-career professionals.
Is this focused on commercial real estate?
Yes. The course uses practical commercial real estate examples and focuses on applications within investment analysis, underwriting, valuation, and development modelling.
What Excel skills are covered?
You’ll learn key Excel functions, formulas, shortcuts, and modelling techniques used to support scenario analysis, assumption testing, and cash flow analysis.
FOLLOW US
COMPANY
CUSTOMER CARE
LEGAL
Copyright © 2026. EiP. All Rights Reserved.