Course description
A real estate financial model is the abstract representation of an
investment scenario. Building a Real Estate Financial Model requires
theory, maths and excel.
This one day course has been developed to teach essential real estate
financial modelling theory, functions and formulas to individuals
working in the real estate sector. The training aims to give delegates a
grasp of MS Excel and its usage in real estate cash flow modelling. You
will be able to set up a financial modelling cash flow from a blank
spreadsheet by using the most common shortcuts, formulas and
functions.
After building a model from scratch, delegates have the opportunity to
run simple, and then more complex, valuations through KEL’s industry
standard program – KEL Investment Valuer.
Delegates will have full access to the KEL software during the course,
ensuring an immersive user experience of the tool.
This is an excellent starter/refresher course, whether you’re a recent
graduate or a mid/senior professional.
Included in the Course
- Bayfield Training & KEL Certificate
- Course Manual
- Course Files
- Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
- Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee
Suitability - Who should attend?
• Surveyors that need to learn how to use DCF as a valuation method
• Graduate Real Estate professionals
• Real Estate professionals at any level with exposure to RE financial models on a frequent basis
• APC candidates
• Mid-Senior professionals looking for a refresher on core model building skills and best practice
• Any professionals looking to learn how to build a real estate focused model from scratch.
Training Course Content
Course Outline
Day One
Conventional valuations
- Term & Reversion
- Layer or Hardcore Method
- Over Rented
Real Estate cash flow models (Single-Let)
- Annual Discounted Cash Flows
- » “What If” Analysis
- Quarterly Discounted Cash Flow
- Cash Flows with a Rent Review
- Multiple Rent Reviews
- NPV and IRR
KEL - Property Valuation Software
- Introduction to KEL
- Overview of KEL Investment Valuer program
- Hands-on inputting of case study data
- Inclusion of breaks, voids, capex & irrecoverables
- Conventional capitalisation valuation
- IRR & NPV calculations
- Reporting
- Sensitivity Analysis
- Interrelation between KEL Investment Valuer MS Excel
Additional Topics
- IF Functions
- Goal Seek
- Sensitivity Analysis: Data Tables
Why choose Bayfield Training
Over 25 years in business
Original Content, Unique Delivery
+90% courses review rating from past delegates
Customer Outreach Award 2019
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Expenses
Classroom-based: £450 + VAT
Number of days: One day
Course type: Strategy
Pre-requisite: None
Request info
Bayfield Training - Real Estate Executive Education
Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun 25 years ago as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and...