Skip to content

Learn how to construct a robust real estate financial model to assess the financial risk and return profile of development, re-development, refurbishment and value-add investments. Break down the complexities of real estate value-add strategies and create an elegant cash flow with best practices and up-to-date excel functions. Master sensitivity analysis which will enhance your real estate financial analysis, error checking skills and improve your underwriting processes.

Duration – 3 days

CPD Hours – 21

Location: Central London

Level – Intermediate – Advanced

  • Overview
  • Prices & Dates
  • Content
  • Participants
  • Testimonials

Real Estate Development, Value Add Strategies & Financial Modelling

Course Overview

Learn how to construct a robust real estate financial model to assess the financial risk and return profile of development, re-development, refurbishment and value-add investments.

Break down the complexities of real estate value-add strategies and create an elegant cash flow with best practices and up-to-date excel functions.

Master sensitivity analysis which will enhance your real estate financial analysis, error checking skills and improve your underwriting processes.

Pricing

Prices exclude VAT (if applicable) Contact us for Partner discounts.

In Person

Attend the course in person, in Central London.

£2,620

Early Booking
SAVE £235

Early Bird Discount when you book & pay at least 30 days in advance.

Virtual Live

Attend the course, live from anywhere in the World.

£2,145

Early Booking
SAVE £195

Early Bird Discount when you book & pay at least 30 days in advance.

On Demand

Instant download of course materials & videos.

£1,716

Lifetime Instant
Access

Early Bird Discount when you book & pay at least 30 days in advance.

In House

Book this course for your in house team.

Price On Request

Please contact if your would like to discuss specific requirements or simple fill out our booking form below.

Dates

9
Dec
2024

Real Estate Development, Value Add Strategies & Financial Modelling – 3 day

Clock Icon 09:00 AM - 05:00 PM

Location Icon London

Find Out More
9
Dec
2024

Real Estate Development, Value Add Strategies & Financial Modelling – 3 day Virtual Live

Clock Icon 09:00 AM - 05:00 PM

Location Icon Virtual Online Live

Find Out More

Course Content

Day 1

Residual Valuation Appraisal

Property Yields

Land Value

Profit Appraisal

Gross and Net Development Values

Return on GDV, Cost and Equity

Proforma Development Cash Flow

Inputs:

  • Timings: purchase date, works start date, planning, lead in, construction and refurbishment, void period, lease start, sale date
  • Revenue: sales proceeds, estimated rental value per sqf, net internal areas, rental growth and target returns
  • Development Costs: construction and refurbishment, site purchase and vacant possession value, contingency, professional fees, statutory costs, allowances and rights 
  • S-Curve vs. Straight Line

Outputs:

  • Internal Rate of Return (IRR)
  • Net Present Value (NPV)
  • Maximum Bidding Price
  • Total profit, profit on cost and equity multiple

Financial Viability Testing & Analysis

Data tables & sensitivity analysis

Risk visualisation techniques

Case study: Un-geared office redevelopment in the UK

Day 2

Development finance

  •           Debt & Equity Structures
  •           Senior Debt
  •           Mezzanine Loan

Geared Cashflow

Debt Types

  •          Rolled-up interest senior debt
  •          Equity first capital deployment waterfall
  •          Debt repayment structures for development finance

Joint-venture structures

  •          Equity waterfall structure
  •          Preferred returns
  •          Promote Cash Flow

Capitalised interest & circularities

Case Study: Geared office redevelopment in the UK

Day 3

Details

  • Current in-place leases, operating expenses – vacancy costs, including rates and empty costs
  • Site acquisition including options, pre-development and planning costs
  • Equity and debt drawdowns, including mezzanine finance

Construction period

  •      Development hard and soft costs using S-curve, Straight line and Known curves
  •      Construction finance drawdowns following an equity-first model

Lease-up and stabilisation period

  •       New leases with gross and net lease clauses
  •       Tenant incentives such as rent-free and capital expenditure contributions
  •       Operating expenses – delayed rates, letting fees, service charges and void costs

Investment options modelling

  •      Lease re-gearing, hold or sell
  •      Re-develop, refinance and hold
  •      Re-develop, stabilise and sell

Sources of funds

  •      Calculating debt and equity peaks
  •      Modelling the debt repayment waterfall
  •      Calculating total cost of debt (interest and fees)

Carried Interest / Promote Structures

  •              Profit shares and preferred equity returns
  •              Equity returns based on different IRR tiers

Risk modelling and presentation

      Financial ratios: IRR, NPV, Residual Land Value, Profit on Cost, Profit on GDV, Equity Multiple

      Sensitivity analysis (2-way data tables)

      Scenario analysis

Investment surveyors

Real estate finance professionals

Property consultants.

Upcoming Courses

On Demand Booking

Real Estate Development, Value Add Strategies & Financial Modelling