Real Estate Analyst (Financial Modelling in Excel)

Bayfield Training

Course

In London

£ 1,750 + VAT

The best Financial Analysis courses

See all

See all

Description

  • Type

    Intensive workshop

  • Level

    Beginner

  • Location

    At 2 venues

  • Class hours

    14h

  • Duration

    2 Days

Create flexible real estate financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 20 years, and is without doubt the core financial modelling training in your career portfolio.

Important information

Documents

  • Real Estate Analyst.pdf

Facilities

Location

Start date

London
See map
56 Commercial Road Aldgate E1 1LP London United Kingdom, E1 1LP

Start date

On request
London
See map

Start date

On request

About this course

On this course you will...
•Revise income mathematics
•Learn how to structure a cash flow
•Learn how to build lease behaviour into income streams
•Build in different debt structures
•Analyse using sensitivity and scenario analysis
•Employ all the short-cuts and solutions to common modelling problems

Real Estate Analysts and Investors
Surveyors
Portfolio Analysts
Investment Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.

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

  • Excel
  • Financial Training
  • Cash Flow
  • MS Excel
  • Returns
  • Real Estate
  • Financial
  • Property
  • Valuation
  • Reversion
  • Analyse

Teachers and trainers (1)

Bayfield Training

Bayfield Training

Proviider

Course programme

Course Outline

Day One

Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.

  • Term & Reversion and Layer Method Valuation (Intro to Excel)
  • Equivalent Yield (Solver, Scenario and Goal Seek functions)
  • Single-Let Discounted Cash Flow
  • Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
  • Analysis and use of date series
  • Internal Rate of Return (IRR) and Net Present Value (NPV)
  • Comparing Value, Price and Worth
  • Adding borrowing and analysing geared returns
  • Introducing Rent Reviews and other ‘events’ into cash flows
  • The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
  • Sensitivity analysis
Day Two

Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.

  • The ‘Rent Function’ and Multi-let cash flows
  • The ‘date problem’ and assumptions in property asset cash flows
  • Reducing the rent function, intermediate calculations and modelling theory
  • Modelling lease expiries, break clauses, voids, and upward only covenants
  • Incorporating time-varying rental growth rates
  • Analysing multi-let cash flows to see if the leases are sufficiently diversified
  • Further IRR analysis (XIRR, MIRR)

Additional information

For more information visit - www.bayfieldtraining.com

See related categories

Real Estate Analyst (Financial Modelling in Excel)

£ 1,750 + VAT

The best Financial Analysis courses

See all

See all