Real Estate Analyst (Financial Modelling in Excel)
Course
Online
Description
-
Type
Intensive course
-
Level
Beginner
-
Methodology
Online
-
Duration
2 Days
Create flexible real estate financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 20 years, and is without doubt the core financial modelling training in your career portfolio.
Important information
Documents
- Real Estate Analyst.pdf
About this course
On this course you will...
•Revise income mathematics
•Learn how to structure a cash flow
•Learn how to build lease behaviour into income streams
•Build in different debt structures
•Analyse using sensitivity and scenario analysis
•Employ all the short-cuts and solutions to common modelling problems
Real Estate Analysts and Investors
Surveyors
Portfolio Analysts
Investment Managers
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.
The CPD accreditation
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
- Excel
- Financial Modelling
- Real Estate
- Financial Training
- Cash Flow
- Returns
- Property
- Reversion
- Valuation
- MS Excel
Teachers and trainers (1)
John Piedrahita
Trainer
Course programme
Day One
Know how to build a property asset cash flow, analyse geared, and un-geared 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
- 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)
- Sensitivity analysis
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
- 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)
Additional information
Real Estate Analyst (Financial Modelling in Excel)