Learn how to model Real Estate Development Projects in Excel

This 100% hands on course shows you how to ‘run the financials’ on a development project using Excel. On this course you will build a costs orientated cash flow from scratch with phased sales income then calculate the IRR, NPV and Equity Profit Multiple. You will also learn how these and other metrics can be used together and how they can sometimes produce spurious results. The course will also show you how to construct, optimise and understand the unique features of development finance as well as how to calculate and interpret project and financial risk. 

Ideal for property developers, lenders, analysts and consultants.

Included:  

1. Comprehensive course material  2. All Excel models used  3. Two months post course support.

Course Contents:

DAY ONE - Learn how to build a detailed property development project cash flow

Introduction to Excel

Annual discounted cash flow modelling

Cash flow input selection

Analysis & use of date series

Internal Rate of Return (IRR) and Net Present Value (NPV)

Comparing Value, price and worth

Quarterly cash flow modelling

Borrowing and analysing feared returns

Introducing events into cashflows

Logic functions(IF, OR, AND)

Analysing the IRR for errors (Data tables, Charting)

Introduction to the Development model

Development cash flows versus Investment cash flows

DAY TWO - Learn how to add financing to and perform risk analysis on development projects

Purchase price and acquisition costs

Phased Sales, marketing and disposal costs

Fixed construction costs, variable and incidental costs, construction fees

Professional fees

Income and expenditure project functions

Logic functions, logic tables and array formulae

Multiple IRRs, competing projects, scoping and linear programming, maximum performance
Return metrics

Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV), Target equity profit ratio (EPR)

Debt Finance, LTV, Interest cover and front fees

Debt scheduling: brought forward and carried forward method

Random variables, input distributions and simulation modelling