Introduction
If you are gearing up for an interview that includes a timed Financial Modelling test, our course will equip you with the skills necessary to outperform other candidates.
We will instruct you in the art of precision, neatness, working efficiently, analytical thinking and employing industry best practices. The course is structured to emulate a typical Real Estate Financial Modelling test, requiring unlevered and levered analysis of an office redevelopment opportunity.
This course has been specifically designed to assist professionals applying for Real Estate positions where a Real Estate Financial Modelling test is a requisite part of the interview process.
Learning Outcomes
By the end of this course, participants will be able to:
- Build a real estate financial model from scratch under time pressure
- Approach modelling tests with a clear structure and strategy
- Apply best practices for model clarity, organisation, and usability
- Use key Excel formulas efficiently and accurately
- Identify and fix errors quickly using structured checks
-
Interpret outputs and explain investment performance confidently
Course Curriculum
- Prerequisite Formulas (24:25)
- Introduction & Strategy Game Plan (19:41)
- Tenancy Schedule (64:50)
- Rental Cash Flow (59:15)
- Build the Cash Flow (96:37)
- Dashboard (39:29)
- Error Checking & Clean up (57:10)
- Analysis (38:38)
- Wrap up and Tips
- The Cash flow - Step by step infographic presentation
- Dorset Rise - Completed Real Estate Financial Model
- Further resources (5:44)
- What's next & Feedback
- Related Bayfield courses
✔ A full real estate financial modelling test simulation
✔ Step-by-step guidance on how to approach and complete the test
✔ Practical techniques to improve speed, accuracy, and efficiency
✔ Industry best practices for structuring and presenting models
✔ 7 CPD hours and CPD-accredited certificate
✔ Downloadable course materials and resources
Students may be eligible for a discounted rate on this course. For more information, please contact our sales advisor:
Jacob Noble
j.noble@bayfieldtraining.com
Featured Courses
Would you like to speak to one of our friendly learning & course advisors?
We're here to help you choose the right course and answer any questions.