Skip Main Navigation
Page Content

Save This Event

Event Saved

Real Estate Developer (Financial Modelling in Excel) - ASRE

Bayfield Training Ltd

Wednesday, 27 September 2017 at 10:00 - Thursday, 28 September 2017 at 17:00 (CEST)

Real Estate Developer (Financial Modelling in Excel) -...
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Two-Day Developer 25 Sep 2017 €1,500.00 €12.04
Bookings from UK 27 Sep 2017 €2,250.00 €12.04

Who's Going

Loading your connections...

Share Real Estate Developer (Financial Modelling in Excel) - ASRE

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

If you are an ASRE student, please contact us for discounts applicable to you.

For more information visit - Bayfield Training 

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

Save This Event

Event Saved

When & Where

Jollemanhof 5

Wednesday, 27 September 2017 at 10:00 - Thursday, 28 September 2017 at 17:00 (CEST)

  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
Real Estate Developer (Financial Modelling in Excel) - ASRE
Things to do in Amsterdam, NH 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.