Bayfield Training - Real Estate Developer (Development DCF Modelling)

Schedule

Mon, 22 Apr, 2024 at 10:00 am to Wed, 26 Nov, 2025 at 04:30 pm

UTC+01:00

Location

London | London, EN

Advertisement
Learn how to build a Real Estate Development cash flow model in Microsoft Excel from scratch in two intensive days
About this Event

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.


Breakdown of training

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


Course Outline

Day One

Learn how to build a discounted cash flow, analyse returns and understand the components of development models

  • Gross versus Net Yields, calculating Net Development Value (NDV)
  • Profit residual, with and without financing
  • Site residual, how to calculate profit without knowing your costs.
  • Introducing financing to site residual calculations
  • Purchase price and acquisition costs
  • Phased Sales, marketing and disposal costs
  • Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
  • Professional fees
  • Income and expenditure project functions
  • Logic functions, logic tables and array formulae


Day Two

Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects

  • Multiple IRRs, competing projects, scoping and linear programming, maximising 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),
  • Modelling construction costs using S-curve , variable costs,incidental costs and construction fees
  • Switching between scenarios
  • Introduction to Development financing, Pari Passu versus Equity First Financing
  • Debt scheduling: brought forward and carried forward method
  • Consideration of the impact of development finance interest, fees and covenants


Included in the Course

  • CPD Accredited Certificate & LinkedIn Proficiency Badge
  • Hard Copy Course Manual
  • Course Files
  • Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
  • Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


This Two day Financial Modelling in Excel course is also available in the classroom, please feel free to contact the Bayfield Training Sales team for more details on this and any other questions you may have:

E - [email protected]

W - www.bayfieldtraining.com

Advertisement

Where is it happening?

London, United Kingdom

Event Location & Nearby Stays:

Tickets

GBP 2162.34

Bayfield Training Ltd

Host or Publisher Bayfield Training Ltd

It's more fun with friends. Share with friends

Discover More Events in London

Sea Life London Anytime Entry
Tue, 30 Sep at 12:00 am Sea Life London Anytime Entry

Sealife London Aquarium

London Dungeon - Anytime Ticket
Tue, 30 Sep at 12:00 am London Dungeon - Anytime Ticket

Shrek's Adventure London

London Eye Fast Track Flexi
Tue, 30 Sep at 12:00 am London Eye Fast Track Flexi

Riverside Rooms

Speed Business Networking for Professionals at Bonds Mayfair
Tue, 30 Sep at 06:30 am Speed Business Networking for Professionals at Bonds Mayfair

Bonds Mayfair

BUSINESS MEETUPS
Tue, 30 Sep at 07:00 am Mark Flinn

Army & Navy Club

Gamified Walk in London\u2019s South East: A Riverside History
Tue, 30 Sep Gamified Walk in London’s South East: A Riverside History

Rotherhithe Station (Stop V)

Advanced Paediatric Life Support(APLS), 30\/09\/2025 - 01\/10\/2025
Tue, 30 Sep at 08:00 am Advanced Paediatric Life Support(APLS), 30/09/2025 - 01/10/2025

Chelsea and Westminster Hospital

WORKSHOPS NONPROFIT
DTFS - Digital Transformation & Innovation in Financial Services Conference
Tue, 30 Sep at 08:30 am DTFS - Digital Transformation & Innovation in Financial Services Conference

One American Square

BUSINESS CONFERENCES
Startups Fund Raising Program
Fri, 18 Sep at 06:00 pm Startups Fund Raising Program

London

BUSINESS WORKSHOPS
British Film Festival, Monthly  VIP Seminar & Networking Event
Fri, 27 May at 06:00 pm British Film Festival, Monthly VIP Seminar & Networking Event

The Argyle

FESTIVALS ENTERTAINMENT
ADEJA HERBAL EXPERIENCE FOR REPARATIONS NOW
Wed, 01 Nov at 08:00 pm ADEJA HERBAL EXPERIENCE FOR REPARATIONS NOW

41 W Green Rd

SPORTS WORKSHOPS
MIXED RACE QUESTION Tottenham N15 Haringey West Green Road Seven Sisters
Fri, 10 Nov at 08:00 pm MIXED RACE QUESTION Tottenham N15 Haringey West Green Road Seven Sisters

41 - 47 West Green Rd

SPORTS WORKSHOPS
ADEJA BLACK RASTAFARI POWER AGAINST RACISM WHITE SUPREMACY TOTTENHAM N15
Fri, 17 Nov at 07:00 pm ADEJA BLACK RASTAFARI POWER AGAINST RACISM WHITE SUPREMACY TOTTENHAM N15

41 - 47 West Green Rd

NONPROFIT PARTIES
ADEJA REPARATION TASK FORCE INTERNATIONAL
Wed, 27 Dec at 07:00 pm ADEJA REPARATION TASK FORCE INTERNATIONAL

41 W Green Rd

WORKSHOPS
NO IRISH NO BLACKS NO DOGS-Reparations for Black and Mixed-Black in Ireland
Fri, 05 Jan at 07:00 pm NO IRISH NO BLACKS NO DOGS-Reparations for Black and Mixed-Black in Ireland

41 - 47 West Green Rd

DOG
ADEJA takeover of TAOBQ 2024 - Meetings  in Tottenham Haringey
Fri, 05 Jan at 07:00 pm ADEJA takeover of TAOBQ 2024 - Meetings in Tottenham Haringey

41 - 47 West Green Rd

SPORTS
STOP RACIST DRUGS  RACIAL NARCOTICS  TOTTENHAM HARINGEY WORLDWIDE CRACKDOWN
Fri, 05 Jan at 07:00 pm STOP RACIST DRUGS RACIAL NARCOTICS TOTTENHAM HARINGEY WORLDWIDE CRACKDOWN

41 - 47 West Green Rd

PARTIES ENTERTAINMENT
REPARATIONS CENTRAL BANK BUILDING PLAN TOTTENHAM HARINGEY
Fri, 12 Jan at 07:00 pm REPARATIONS CENTRAL BANK BUILDING PLAN TOTTENHAM HARINGEY

41 - 47 West Green Rd

SPORTS WORKSHOPS
RACIAL MODELS WANTED FOR EUGENICS AND REPARATIONS SHOW TOTTENHAM HARINGEY
Fri, 12 Jan at 07:00 pm RACIAL MODELS WANTED FOR EUGENICS AND REPARATIONS SHOW TOTTENHAM HARINGEY

41 - 47 West Green Rd

WORKSHOPS BUSINESS
BLACK LEADERSHIP AND THE BLACK MESSIAH - TOTTENHAM HARINGEY LONDON
Fri, 19 Jan at 07:00 pm BLACK LEADERSHIP AND THE BLACK MESSIAH - TOTTENHAM HARINGEY LONDON

Reparation Corner, 41 - 47 West Green Rd, Tottenham, Haringey. N15

BUSINESS ART

What's Happening Next in London?

Discover London Events