Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.

Course Breakdown

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.

Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.

The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.

On this course you will…

• Learn how to calculate land and profit residuals
• Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
• You will be taught how to find maximum bidding prices for site development and building refurbishments
• Understanding development financing considerations and learn how to optimise financing
• Analyse financial and project completion risks
• Employ best practice and find solutions to common modelling problems

Who will benefit from this course?

• Developers
• Surveyors
• Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
• Fund managers
• Asset managers
• Land managers
• Planning managers
• Lenders