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

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




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 -

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

Znajdź więcej ciekawych wydarzeń
Pobierz zalecenia zdarzeń na podstawie Twojego Facebooka smaku. Zdobądź to teraz!Pokaż mi odpowiednie imprezy dla mnieNie teraz