Development Modelling · Part of the EiP Academy
How to Model a Development: From Residual to DCF
Residual land value, development cash flows and discounted cash flow analysis, built step by step in Excel.
Intermediate
8.0 CPD hours
about this course
From residual land value to a full DCF
This course starts with the difference between a residual and a development appraisal, then builds an appraisal covering floor area, GDV, costs, debt and profit metrics.
It then moves into a full development DCF, with rental income, occupancy ramp up, hold period income and costs, and capex profiles such as the S-curve.
Who this course is for
Development analysts and appraisers
Surveyors and valuers who review schemes
Acquisitions professionals looking at development
Asset managers working on refurbishments
Graduates moving into development
Candidates preparing for development modelling tests
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 appraise a scheme and build a development cash flow from a blank workbook.
Explain when to use a residual and when to use a development appraisal
Model GDV, costs and debt in an appraisal
Solve for residual land value and profit metrics
Build a full development DCF with income and costs
Spread capex with straight line, S-curve, front-loaded and rear-loaded profiles
What you will learn
Skills you can use at work straight away
Residual land value
Development appraisals
GDV and floor areas
Development costs and finance
Appraisal profit metrics
Capex profiles and S-curves
Hold period income and costs
Development DCF
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 residual and a development appraisal?
A residual appraisal works backwards from the finished value to find what a developer can pay for the land. A development appraisal tests the profit on a known scheme and price, also known as a viability study.
Does the course cover S-curves and capex profiles?
Yes. You model capex with straight line, S-curve, front-loaded and rear-loaded profiles, and compare them.
Is this course useful if I am not a developer?
Yes. Valuers, analysts and acquisitions teams all need to review development appraisals. The course explains the terms and the logic as it goes.
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