European Real Estate Analyst (Financial Modelling in Excel)
Course
Online
Access now to this complete course!
-
Type
Intensive course
-
Level
Beginner
-
Methodology
Online
-
Duration
2 Days
Emagister presents you this interesting course of European real estate analyst. You can learn how to generate cash results from European lease codes and conventions. The course reviews the theory of financial models before a detailed analysis of the agreements that exist in the many jurisdictions of continental Europe. Investments in the European sector take into account the permutations of agreements and projections of subsequent rents.
This course shows how to develop cash flow models while minimizing the complexity and size of rental functions.
With this complete program, the technical structures and techniques of financial modeling, the agreements that predominate in different countries across Europe, the technical and technical solutions to project flexible rental functions. You will also learn to apply and analyze debt structures and analyze using sensitivity and scenario analysis.
Are you interested in this course? We invite you to request more information in Emagister. That way you can contact them and our advisors will give you all the details you need to know. Do not miss this magnificent opportunity to progress in your professional career and knowledge!
Important information
Documents
- European Real Estate Analyst.pdf
About this course
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.
Pre-requisite: Real Estate Analyst
We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com.
Reviews
Subjects
- Cash Flow
- Real Estate
- Property
- Use of date series
- Equivalent Yield
- Comparing Value
- Analysing the IRR for errors
- Scenario testing
- Loans
- Rent function
- Break clauses
- Voids
- Upward only covenants
- Annual summaries
- Amortising loans
- Date series
- Price
- DCF models
- Property Market
- Sensitivity Analysis
Teachers and trainers (1)
Bayfield Training
Proviider
Course programme
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)
European Real Estate Analyst (Financial Modelling in Excel)