Scenarios and Sensitivities · Part of the EiP Academy
Analysis: Scenarios and Sensitivities
Test your assumptions and show how a deal holds up when the numbers change, using scenarios, sensitivities and Excel data tables.
Intermediate
4.0 CPD hours
about this course
Show how a deal holds up when the numbers change
This course teaches the two core ways to test a property model: scenarios, where several assumptions change together, and sensitivities, where one or two change at a time.
You set up both in Excel, run them with data tables and learn how to read the results, so you can explain what drives a deal.
Who this course is for
Analysts who build or check property models
Acquisitions and asset management professionals
Candidates preparing for modelling tests
Anyone wanting to assess risk before investing
What you'll end up with
This is what you'll learn to do
By the end of the course, you will be able to stress test a model and explain the results to a senior colleague.
Set up scenarios in a model
Run scenarios and compare the results
Build sensitivity tables with Excel data tables
Spot which assumptions move the answer most
Explain the risk in a deal using clear outputs
What you will learn
Skills you can use at work straight away
Scenario set-up
Scenario analysis
Sensitivity analysis
Excel data tables
Testing assumptions
Reading and explaining results
Practical examples
Excel examples and downloadable files to work through.
Supporting materials
Everything you need alongside the lessons.
Academy access
Included in the EiP Academy, with future updates while your membership is active.
Want more than one course?
Get all our courses in the EiP Academy
All of our courses, the EiP Model Library and a community of property professionals, in one membership.
FAQs
What is the difference between a scenario and a sensitivity?
A scenario changes several assumptions together, such as a downside case. A sensitivity changes one or two assumptions at a time to show how much each one moves the result. The course covers both.
Do I need to know how to use data tables first?
No. The course teaches data tables from the start. You should be comfortable with a basic property cash flow in Excel.
Why does sensitivity analysis matter in real estate?
Every model rests on assumptions about rent, costs, yields and timing. Testing them shows investors and lenders how much risk is in a deal, which is what they will ask about.
How long will I have access?
You have unlimited access for 12 months, in line with the EiP Academy, which is a 12-month programme. Nothing renews automatically, and you can renew when the period ends.
Do I get instant access?
Yes. Access is sent to you by email as soon as your order is confirmed.
Is this course included in the EiP Academy?
Yes. It is included in the EiP Academy, together with the other courses, the EiP Model Library and a community of property professionals. If you want more than one course, take a look at the Academy.
167-169 Great Portland Street, 5th Floor, London, W1W 5PF
© Excel in Property Limited 2026