£2,121.54

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

Event Information

Share this event

Date and Time

Location

Location

Imparando

56, Commercial Road

Aldgate

London

E1 1LP

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections. Development projects require greater skill and flexibility from Analysts and an ability to work with simultaneously with project partners. 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.

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


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

For more information please email: info@bayfieldtraining.com


Share with friends

Date and Time

Location

Imparando

56, Commercial Road

Aldgate

London

E1 1LP

United Kingdom

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved