Real Estate Development School

Commercial Real Estate Developer

Introduction to Real Estate in Excel

Real Estate Developer

Learn what constitutes Development physically and economically

Gain an insight into the Development Process at a Macro & Micro level

Learn the different characteristics of Real Estate Sectors

Recognise spreadsheet navigation and presentation tricks

Learn spreadsheet modelling best practice

Understand financial mathematics & conventional valuations

Develop proficiency in creating robust models.

Construct a Development focused Financial Model starting from foundational principles

Analyse financial and project completion risks

Real Estate Professionals who would like to update their skills in latest practices in Development

Professionals practicing in an associated field, Legal, Planning, Managing, Agency, Owners and Financiers

Graduates looking to work in corporate Real Estate development

Managers who would like to communicate more effectively with investors and owners during the formation phases of development

Real Estate professionals at any level with exposure to real estate financial models on a frequent basis

APC candidates

Mid-Senior professionals looking for a refresher on core model building skills and best practice

The Real Estate Market System

Development Models

The Economics of Development

Profiles of Developers

Risk and Rewards of different types of project

Who builds what and why?

Use looking for a site

Site looking for a use

Planning inputs

Best Use Value

Viability Assessments

Worth vs Value

Financing

Evaluation

Market Analysis

Design Principals

Time line and risk profile

External influencers

Development pressure and Prospects

Disposal of Development

Owners, Tenants, Public Sector

Development Team

Contractors

Agency

Modelling Life Cycle

Types of Model

Modelling Timescale

Introduction

Compound Growth

Present Values

Net Present Value

Internal Rate of Return

Introduction

Term & Reversion

Layer Method

Over Rented

Equivalent Yield

Introduction – Understand UK Leases

Annual Discounted Cash Flows

“What If” Analysis

Quarterly Discounted Cash Flow

Cash Flows with Rent Review

Multiple Rent Reviews

Pivot tables, V-Lookups, Data Tables and More…

IF & SUMIF

Sensitivity Analysis: Data Table & Changing Calculation Options

V-Lookups

Pivot Tables

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

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

CPD Accredited Certificate & LinkedIn Proficiency Badge

Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee

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