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. We will also cover the use of pivot tables to clean and organise your data.
This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.
On this course, you will…
- Learn spreadsheet modelling best practice
- Look over excel tips for general day to day use in MS Excel
- Recognise spreadsheet navigation and presentation tricks
- Understand financial mathematics & conventional valuations
- Identify real estate cash flow model single-let common functions and formulas
- Inspect Pivot tables, V-look ups and many other topics
Included in the Course
- A Bayfield Training Certificate
- Course Manual (In-Person Course Delegates receive a Hard Copy, Virtual Course Delegates receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee)
- 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
Bayfield Training is a prominent global supplier of investment grade Real Estate executive education and they have a huge extended network of experts, specialists and professionals within the field of Real Estate Financial Modelling. Using both practitioners and academics who have studied and worked at the highest level, this course provided by Bayfield gives participants a total learning experience due to the relevant and up to date content.
Upcoming start dates
Suitability - Who should attend?
Participants who should attend this course are:
- Graduate Real Estate professionals
- Real Estate professionals at any level with exposure to real estate 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
This one day course will cover:
Spreadsheet modelling best practice
- Modelling Life Cycle
- Types of Model
- Modelling Timescale
Financial mathematics
- Introduction
- Compound Growth
- Present Values
- Nat Present Value
- Internal Rate of Return
Conventional valuations
- Introduction
- Term & Reversion
- Layer Method
- Over Rented
- Equivalent Yield
Real Estate cash flow models (Single-Let)
- Introduction – Understand UK Leases
- Annual Discounted Cash Flows
- “What If” Analysis
- Quarterly Discounted Cash Flow
- Cash Flows with Rent Review
- Multiple Rent Reviews
- Pivot tables, V-Lookups, Data Tables and More…
Additional topics:
- IF & SUMIF
- Sensitivity Analysis: Data Table & Changing Calculation Options
- V-Lookups
- Pivot Tables
Other Excel tips and tricks, including navigation and presentation:
- Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC
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.
Reviews
Average rating 5
Trainer was very good - clear, easy to follow and highly knowledgable.
The trainer was brilliant. They were hugely knowledgeable and approachable throughout the entire session. The trainer was also positive and passionate and led the session at a g...
Expenses
This Introduction to Real Estate in Excel course is available to participants In-person for £600 + VAT or Virtually for £500 + VAT.
*Price for a place on public course in the UK. Please enquire for prices relevant to other locations.
If required, the training is also available as an in-house and online course. Please contact Bayfield Training for more information.
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...
Really thorough, easy to follow & good length of time.