Skip Main Navigation
Page Content

Save This Event

Event Saved

Bayfield Training - Real Estate Developer (Financial Modelling in Excel)

Bayfield Training Ltd

Thursday, 30 March 2017 at 10:00 - Friday, 31 March 2017 at 17:00 (BST)

Bayfield Training - Real Estate Developer (Financial...
Available Dates

Ticket Information

Ticket Type Sales End Price Fee VAT Quantity
Two-day RE Developer course 30 Mar 2017 £1,750.00 £19.95 £353.99

Who's Going

Loading your connections...

Share Bayfield Training - Real Estate Developer (Financial Modelling in Excel)

Event Details

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.


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

For more information visit - Bayfield Training 

Do you have questions about Bayfield Training - Real Estate Developer (Financial Modelling in Excel)? Contact Bayfield Training Ltd

Save This Event

Event Saved

When & Where

City Business Library
EC2V 7HH London
United Kingdom

Thursday, 30 March 2017 at 10:00 - Friday, 31 March 2017 at 17:00 (BST)

  Add to my calendar


Bayfield Training Ltd

Leaders in Real Estate Executive Education, Est. 1998.

We can provide all of our courses not  only publically, but In-House and 121 as well. Prices may vary.


Terms & Conditions

Cancellations - The course fee is non-refundable. 100% of the course fee is due if cancelled within 10 working days prior to the start of the course.





  Contact the Organiser
Bayfield Training - Real Estate Developer (Financial Modelling in Excel)
Things to do in London Course Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.