Looks like this event has already ended.
Check out upcoming events by this organizer, or organize your very own event.
Real Estate Analyst (Financial Modelling)
Tuesday, May 25, 2010 at 10:00 AM - Wednesday, May 26, 2010 at 4:30 PM (BST)
London, United Kingdom
Learn how to model Commercial Real Estate Investments in Excel
This 100% hands on course shows you how to model the income from property investments such as offices, industrial buildings and shopping centres. It then shows you how to value property as well as calculate, interprate and risk assess the results.
Ideal for property investors, lenders, analysts and consultants.
1. Comprehensive course material 2. All Excel models used 3. Two months post course support.
DAY ONE - Valuations, Cash Flows and Risk Analysis
Conventional valuations, calculations and yield definitions
Calculating the equivalent yield using Excel's optimising tools
Single let property discounted cash flow
Model Inputs: Rents, yields, growth rates, target rates
Model Outputs: Internal Rate of Return (IRR), Net Present Value (NPV)
Analysis of Price, Value and Worth
Analysis and use of date series
Adding debt finance and anlysing geared returns
Introducing rent reviews and other events into the cash flow's income function
The rent function concept and logic functions (IF, AND, OR)
Analysing the IRR for errors (Multiple IRRs, Re-investment Rates, Cross-over rates)
Sensitivity analysis and scenario testing
DAY TWO - Advanced Rent Modelling & Debt Finance
Rent function solutions for multi-let cash flows e.g. shopping centres
The date problem and other assumptions in multi-let cash flows
The impact of lease terms on rental cash flows in UK versus continental Europe
Optimisation of events (lease diversification)
Modelling stressed cash flows for bank lending
Interest only and amortising loans
Debt criteria: rent weighted minimum interest cover, maximum LTV
Origination fees and pre-payment penalties
Data validation, templates, auditing, password protection and other functions
Event to be held at Berwin Leighton Paisner offices
When & Where
Bayfield Training Ltd
Real Estate Financial Modelling Specialists, London est. 1998
In-house courses also available please enquire 020 7866 8180