course-premium

Retail Property Appraisals

Course

In London

£ 2,000 + VAT

You can advance in your professional future with this training!

  • Type

    Intensive workshop

  • Level

    Intermediate

  • Location

    London

  • Class hours

    15h

  • Duration

    2 Days

If you already have the skills of our real estate analyst course, why not challenge yourself with more in our commercial property appraisal course? Emagister has this course for you, to achieve your goals!

Commercial property models are some of the most complex to master. The main reasons are: More lease terms, more ways to calculate rent, more tenants in a single building or more detailed cost-sharing agreements.

You can learn how to build a cash flow model of properties for retailers. This course takes participants step by step through the creation of a complete cash flow model of the shopping center. As a modeling course it is almost completely based on Excel. The course begins by analyzing the variables that affect the investment returns of the shopping center. Participants will calculate key performance indicators (KPIs) that can manifest themselves that influence the financial model from tenure to risk.

If you are a fund manager who completed the analyst course and need to be able to understand and model sophisticated retail assets or if you are a real estate analyst who wants to hone your skills, this course is for you.

If you want to know more details, request more information in Emagister!

Important information

Documents

  • Retail Property Appraisals.pdf

Facilities

Location

Start date

London
See map

Start date

On request

About this course

Learn how to build a Retail Property cash flow model. This course takes delegates step by step through the creation of a full shopping centre cash flow model. As a modelling course it is almost entirely Excel based. The course starts by analysing the variables that influence shopping centre investment returns. Delegates will calculate Key Performance Indicators (KPIs) that can be shown to influence the financial model from Tenancy through to Risk.

Fund managers who have done the Analyst course and need to be able to understand and model sophisticated Retail assets
Analyst and modellers who would like to improve their understanding of financial models in respect of retail property assets
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills

The CPD Accreditation

We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Risk
  • Mathematics
  • MS Excel
  • GCSE Mathematics
  • Financial
  • Creating CAPEX
  • Performance Metrics
  • Retailer Classification
  • Cross Referencing
  • Tenancy Schedule
  • Planning the rent function
  • Multi-let Cash Flows
  • Zone A calculations
  • Rental Growth
  • Rent Functions
  • Rent Projection
  • Micro Location
  • Using excel
  • Data visualisation methods
  • Lease Expiry Profiles

Teachers and trainers (1)

Bayfield Training

Bayfield Training

Proviider

Course programme

Day one

Retail Property Models

  • What makes retail property models unique?
  • Input Variables and the Profit Cycle
  • Financial Model Layout and Design
  • Understanding the nature of Retail Property Cash Flows

Advanced Cash Flow Modelling

  • Internal Rate of Return (IRR), Net Present Value (NPV) and other metrics
  • The three Rent Function methods
  • Logic Functions and Arrays
  • Multi-let Cash Flows
  • Multiple and Period Varying Growth Rates

Retail Property Rent Functions

  • Common Retail Property Lease Covenants
  • Retail Tenancy Schedules
  • Zone A calculations
  • Turnover, affordability ratios and rental capture
  • Rental Growth, inflation and fixed rent
  • Rent Functions and Rent Projection

Analysing the Tenancy Schedule

  • Hypothetical study of ‘The Galleries’ Shopping Centre
  • Unit Plan and Micro Location
  • Using Excel as a database and linking to external data sources
  • Data visualisation methods
  • The Bayfield Retail Quilt (Tenant Mix Analysis)
  • Lease Expiry Profiles and Event Analysis

Round up and Conclusions of Day One

Day Two

Shopping Centre Portfolio Case Study

  • Choosing the Retailer Classification
  • Cross Referencing Consumer Classification
  • Completing the Tenancy Schedule
  • Generating Typologies from tenancy schedules

Rent Functions for Shopping Centres

  • Breaking Complex rent functions from existing models
  • Planning the rent function
  • Events and Rents Table formulae
  • Full Rent Function

Full Project Cash Flow

  • Scenario Testing and Risk Analysis
  • Building a rent function for the case study shopping centre
  • Testing the rent function
  • Creating CAPEX and OPEX functions for the case study
  • Calculating IRR, NPV and other Investment Metrics
  • Testing the IRR for errors

Footfall and Performance Metrics

  • Destination capacity calculations
  • Footfall Signatures
  • Peak hour performance
  • Performance Metrics

Round up and Conclusions of Day Two

Additional information

For more information visit - www.bayfieldtraining.com

Retail Property Appraisals

£ 2,000 + VAT