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

Mon Oct 19 2020 at 10:00 am to Tue Oct 20 2020 at 05:00 pm
London, United Kingdom

London, United Kingdom

Created By:
Bayfield Training
Spread the word
Create flexible real estate financial models in Excel. This financial modelling course shows how to develop rent functions and net operating income. It also shows how to value and appraise property investments and calculate, interpret and analyse the results. 

On this course, you will…


Learn how to structure an investment cash flow from first principles and how to value and appraise property investments

Learn how to model lease behaviour and create income forecast

Build OPEX and CAPEX into your cash flow

Analyse risk using sensitivity tables and charts

Employ best practice and find solutions to common modelling problems


 

Who will benefit from this course?


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.


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)


 

For more information visit - Bayfield Training 

iCause.com promotes public events for free and helps event organizers connect with nonprofits to attract more participants like you.

Additionally, the iCause Global Foundation enables good people to fund great causes around the world. Together, our impacts are limitless!

Created By:
Bayfield Training
Spread the word

More Events in london

Social Media Intelligence SOCMINT - Training Course

The Frontline Club , 13 Norfolk Place, W2 1QJ London, UK, London, United Kingdom

Mon Oct 19 2020

BCS Business Analysis Practitioner

Global Edulink Ltd. , City View House, London, United Kingdom

Mon Oct 19 2020

Wedding Planner Course (Advance) Certificate | 5 Days Live Classes

Amoretti Weddings Academy , 337 city road, EC1V 1LJ London, UK, London, United Kingdom

Mon Oct 19 2020

Rhyme Time at Leytonstone Library

Leytonstone Library , 6 Church Lane, London, United Kingdom

Mon Oct 19 2020
View all events in London