Real Estate Financial Modelling in Excel & interview prep workshop by Bayfield
20
Registered
Registration
Registration is now closed (this event already took place).
Details
We are pleased to invite you to an Real Estate Financial Modelling in Excel & interview prep workshop led by Andri Rabetanety, Bayfield. This course will provide hand on experience on Real Estate financial modelling. Please note, the training is CPD Certified (can be added on LinkedIn). Please bring your own laptops.
The course outline can be found below, as well as more information about our tutor.
We look forward to seeing you there!
Best,
Real Estate Club ExCo 2018-2019
Course Instructor – Andri Rabetanety
Andri has a Investment and Fund Management experience focusing on Real Estate for over 10 years. This is a short summary of his experience:
• Led the deals on UK hotel development and Luxembourg office investments.
• Debt management: hedging and refinancing negotiations (UFG WM Real Estate).
• Portfolio Management and cashflow management (Generale Continental)
His professional and educational qualifications are:
• Universite de Cergy Pontoise: PhD Candidate on the topic performance of private equity real estate funds
• ESSEC Business School: Executive MBA in Real Estate Management (Exchange program with IREBS Regensburg)
• ENSIMAG & Universität Karlsruhe: Engineer & Master of Science degree in Applied Mathematics & Computer Science
Bayfield Workshop - Course Outline
DAY 1.
• Term and 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
DAY 2.
• The ‘Rent Function’ concept and Logic functions (IF, OR, AND)
• Sensitivity analysis
• 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)
• Different debt structures
• Cashflow mezzanine debt
Where
The Sammy Ofer Centre
LT16
117 Marylebone Road, London, NW1 5PT