wtorek, 15. październik 2019, Warsaw, Bayfield Training - European Real Estate Analyst - Warsaw

Z 15. październik 2019 - 10:00
Do 16. październik 2019 - 17:00
Zobacz na mapie
0 Ludzi uczestniczy
Opis wydarzenia
European Real Estate Analyst
Included with course

All Excel models used on the course, provided on disk

Comprehensive course manual (also available separately and designed for self-study)

2-months post course email and telephone support

Pokaż więcej
Course Outline
Day One
Know how to build a property asset cash flow, analyse geared, and ungeared 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

Switching between Annual, Quarterly and Monthly DCF models

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)

Analysing the IRR for errors (data tables, charting)

Sensitivity analysis and Scenario testing

International comparison of property market

Day Two
Know how to build a multi-let property cash flow and analyse advanced debt structures.

The ‘Rent Function’ and Multi-let cash flows

The ‘date problem’ and assumptions in property asset cash flows

Pattern of rents in UK, European and Index linked leases (Arrays, Lookups)

Reducing the rent function, intermediate calculations and modelling theory

Modelling leases 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)

Creating Annual summaries of quarterly/monthly cash flows

Modelling stressed cash flows for debt purposes

Interest only and amortising loans (PMT)

For more information visit -

Bayfield Training - European Real Estate Analyst - Warsaw, Warsaw zdarzenie

Fundamental Training - Poland
czwartek 05. grudzień 2019
Big Data w biznesie - dwudniowe szkolenie
sobota 25. lipiec 2020
ISO 27001 Lead Auditor Training in Warsaw Poland
poniedziałek 04. listopad 2019
ISO 27001 Lead Implementer Training in Warsaw Poland
niedziela 10. listopad 2019
Integra-Connect Warsaw Networking Event
czwartek 05. grudzień 2019
Znajdź więcej ciekawych wydarzeń
Pobierz zalecenia zdarzeń na podstawie Twojego Facebooka smaku. Zdobądź to teraz!Pokaż mi odpowiednie imprezy dla mnieNie teraz