Real Estate Professional Courses
Basic Real Estate Financial Modelling and Microsoft Excel
Suitable for : Excel Beginners
A course designed for Excel beginners and those with little to no familiarity with basic Excel functions or formulas, but wish to develop their skills to be capable of ;
- Answering Excel-based lecture and coursework questions and case studies
- Forecasting out future cash flows using a set of assumptions
Online | Via MS Teams | Afternoon and Evenings
Lessons: 4 |
Coursework: No
Final Exam: No
Course Pre-requisites: None, aside from access to Microsoft Excel
Available Now
Basic Real Estate Financial Modelling and Microsoft Excel
Online Training Over MS Teams
4 LESSONS
£600
Intermediate Real Estate Financial Modelling
Suitable for : Investment Analysts and Graduates
A course designed for students with basic familiarity with Excel, but wish to take their financial modelling skill and abilities to the next level. This course will teach you the solid skills required to ;
- Perform competently in interview-based financial modelling case study tests (from 1-4 hours long) against other candidates
- Tackle tough Excel-based courseworks and dissertations and achieve First/Merit/Distinction grades
- Carry out moderately complex Investment and Development appraisals and financial analysis at a professional level
Below is the Generalist course route, but selection of cases chosen can be altered to suit student’s specific specialism/asset class.
COURSE MODULES:
- Recap of Basic Excel Functions and Application to Real Estate
- Putting together an Investment Appraisal (Case Study 1)
- Putting together a Development (residual value) Appraisal (Case Study 2)
- Modelling sensitivities and Private Equity investor profit shares
- Full Work-through, Solution and Review of Case study 3
- Full Work-through, Solution and Review of Case study 4
LESSON 4 Take-Home Coursework – Case Study 3Student can choose from an Office, Industrial or Retail real-life case study
LESSON 5 Take-Home Coursework – Case Study 4 – Hotel real-life case study
Online | Via MS Teams | Afternoon and Evenings
Lessons: 6 |
Coursework: Yes
Final Exam: No
Course Pre-requisites: Basic Microsoft Excel
Available Now
Intermediate Real Estate Financial Modelling
Online Training Over MS Teams
6 LESSONS
£900
Advanced Real Estate Financial Modelling
Suitable for : Investment Analysts and Financial Modellers
The ultimate financial modelling course designed for students wishing to transition from basic ability with Excel to fully proficient Financial Modeller.
This course will deliver the student the tools needed to professionally model almost any business scenario, problem or financial appraisal and is mainly directed to students that will be taking on this responsibility within their firm as the main part of their full-time job. It is also directed to students taking more challenging (2+ hour) interview -based financial modelling tests.
The course is similar to the Intermediate course, except the cases become more challenging and require a heightened ability to adapt to model various scenarios.
The course concludes with a final examination which is reviewed and marked.
Below is the Generalist course route, but selection of cases chosen can be altered to suit student’s specific specialism/asset class.
COURSE MODULES:
- Recap of Basic Excel Functions and Application to Real Estate
- Putting together an Investment Appraisal (Case Study 1)
- Putting together a Development (residual value) Appraisal (Case Study 2)
- Modelling sensitivities and Private Equity investor profit shares
Take Home Coursework – (Case Study 3)– Student can choose from an Office, Industrial or Retail real-life case study - Full Work-through, Solution and Review of Case study 3
Take-Home Coursework – (Case Study 4) – Hotel real-life case study - Full Work-through, Solution and Review of Case study 4
Take-Home Coursework – (Case Study 5) – Advanced Commercial Real Estate Case Study - Full Work-through, Solution and Review of Case study 5
Take Home Coursework – (Case Study 6) – Advanced Residential Development Real Estate Case Study - Full Work-through, Solution and Review of Case study 6
CASE STUDY EXAMINATION – to be completed over weekend.
Online | Via MS Teams | Afternoon and Evenings
Lessons: 8 |
Coursework: Yes
Final Exam: Yes
Course Pre-requisites: None, aside from access to Microsoft Excel
Available Now
Advanced Real Estate Financial Modelling
Online Training Over MS Teams
8 LESSONS
£1200
Real Estate Financial Modelling (for Professionals)
Suitable for : Professionals
A fully-tailored financial modelling course that is targeted to professionals and is fully customised to address a specific knowledge or skill-based need in the context of the business/business requirements.
Common financial analysis and business problems addressed through building financial appraisal models can include ;
- A Private Equity deal with a complex GP/LP profit sharing mechanism with GP catch-ups requiring to be modelled to determine the returns for each investor
- The building of a portfolio model serving as an aggregation to individual asset appraisal models, with the ability to perform sensitivities at a portfolio level
- Modelling in various tranches of Debt into the capital stack
- The building of an Institutional-grade fund model that can be used for fundraising efforts and distributed out to potential investors
Please be in touch to discuss your business objectives and how we can structure a course to deliver on the specific knowledge required.
Online | Via MS Teams | Afternoon and Evenings
Lessons: To Be Discussed
Available Now
Real Estate Financial Modelling (for Professionals)
Online Training Over MS Teams
FULLY CUSTOMISED
Basic Real Estate Financial Modelling and Microsoft Excel
Suitable for : Excel Beginners
A course designed for Excel beginners and those with little to no familiarity with basic Excel functions or formulas, but wish to develop their skills to be capable of ;
- Answering Excel-based lecture and coursework questions and case studies
- Forecasting out future cash flows using a set of assumptions
Online | Via MS Teams | Afternoon and Evenings
Lessons: 4 | Learning Hours: 8
Coursework: No
Final Exam: No
Course Pre-requisites: None, aside from access to Microsoft Excel
Available Now
Basic Real Estate Financial Modelling and Microsoft Excel
Online Training Over Teams
4 LESSIONS
£600
Intermediate Real Estate Financial Modelling
Suitable for : Investment Analysts and Graduates
A course designed for students with basic familiarity with Excel, but wish to take their financial modelling skill and abilities to the next level. This course will teach you the solid skills required to ;
- Perform competently in interview-based financial modelling case study tests (from 1-4 hours long) against other candidates
- Tackle tough Excel-based courseworks and dissertations and achieve First/Merit/Distinction grades
- Carry out moderately complex Investment and Development appraisals and financial analysis at a professional level
Below is the Generalist course route, but selection of cases chosen can be altered to suit student’s specific specialism/asset class.
COURSE MODULES:
- Recap of Basic Excel Functions and Application to Real Estate
- Putting together an Investment Appraisal (Case Study 1)
- Putting together a Development (residual value) Appraisal (Case Study 2)
- Modelling sensitivities and Private Equity investor profit shares
- Full Work-through, Solution and Review of Case study 3
- Full Work-through, Solution and Review of Case study 4
LESSON 4 Take-Home Coursework – Case Study 3Student can choose from an Office, Industrial or Retail real-life case study
LESSON 5 Take-Home Coursework – Case Study 4 – Hotel real-life case study
Online | Via MS Teams | Afternoon and Evenings
Lessons: 6 | Learning Hours: 12
Coursework: Yes
Final Exam: No
Course Pre-requisites: Basic Microsoft Excel
Available Now
Intermediate Real Estate Financial Modelling
Online Training Over Teams
6 LESSIONS
£900
Advanced Real Estate Financial Modelling
Suitable for : Investment Analysts and Financial Modellers
The ultimate financial modelling course designed for students wishing to transition from basic ability with Excel to fully proficient Financial Modeller.
This course will deliver the student the tools needed to professionally model almost any business scenario, problem or financial appraisal and is mainly directed to students that will be taking on this responsibility within their firm as the main part of their full-time job. It is also directed to students taking more challenging (2+ hour) interview -based financial modelling tests.
The course is similar to the Intermediate course, except the cases become more challenging and require a heightened ability to adapt to model various scenarios.
The course concludes with a final examination which is reviewed and marked.
Below is the Generalist course route, but selection of cases chosen can be altered to suit student’s specific specialism/asset class.
COURSE MODULES:
- Recap of Basic Excel Functions and Application to Real Estate
- Putting together an Investment Appraisal (Case Study 1)
- Putting together a Development (residual value) Appraisal (Case Study 2)
- Modelling sensitivities and Private Equity investor profit shares
Take Home Coursework – (Case Study 3)– Student can choose from an Office, Industrial or Retail real-life case study - Full Work-through, Solution and Review of Case study 3
Take-Home Coursework – (Case Study 4) – Hotel real-life case study - Full Work-through, Solution and Review of Case study 4
Take-Home Coursework – (Case Study 5) – Advanced Commercial Real Estate Case Study - Full Work-through, Solution and Review of Case study 5
Take Home Coursework – (Case Study 6) – Advanced Residential Development Real Estate Case Study - Full Work-through, Solution and Review of Case study 6
CASE STUDY EXAMINATION – to be completed over weekend.
Online | Via MS Teams | Afternoon and Evenings
Lessons: 10 | Learning Hours: 20
Coursework: Yes
Final Exam: Yes
Course Pre-requisites: None, aside from access to Microsoft Excel
Available Now
Advanced Real Estate Financial Modelling
Online Training Over Teams
8 LESSIONS
£1200
Real Estate Financial Modelling (for Professionals)
Suitable for : Professionals
A fully-tailored financial modelling course that is targeted to professionals and is fully customised to address a specific knowledge or skill-based need in the context of the business/business requirements.
Common financial analysis and business problems addressed through building financial appraisal models can include ;
- A Private Equity deal with a complex GP/LP profit sharing mechanism with GP catch-ups requiring to be modelled to determine the returns for each investor
- The building of a portfolio model serving as an aggregation to individual asset appraisal models, with the ability to perform sensitivities at a portfolio level
- Modelling in various tranches of Debt into the capital stack
- The building of an Institutional-grade fund model that can be used for fundraising efforts and distributed out to potential investors
Please be in touch to discuss your business objectives and how we can structure a course to deliver on the specific knowledge required.
Online | Via MS Teams | Afternoon and Evenings
Lessons: To Be Discussed
Available Now
Real Estate Financial Modelling (for Professionals)
Online Training Over Teams
CUSTOMISED LESSONS
Available Now
Basic Real Estate Financial Modelling and Microsoft Excel
Online Training Over MS Teams
4 LESSIONS
£600
Available Now
Intermediate Real Estate Financial Modelling
Online Training Over MS Teams
6 LESSIONS
£900
Available Now
Advanced Real Estate Financial Modelling
Online Training Over MS Teams
8 LESSIONS
£1200
Available Now
Real Estate Financial Modelling (for Professionals)
Online Training Over MS Teams
FULLY CUSTOMISED