Real Estate Investment Modelling: 4 Days Workshop | Sydney

Bring your team and save:

1. Groups of three or more receive a 10% discount

2. Organizations hosting an in-house session with 10+ participants enjoy a 15% discount.

Duration: 4 Days
Delivery Mode: Classroom (In-Person)
Language: English
Credits: 32 PDUs / Training Hours
Certification: Course Completion Certificate
Refreshments: Lunch, snacks and beverages will be provided during the session

Course Overview:

Learn the fundamentals of Real Estate financial modelling then apply this knowledge to the real world financial modelling challenges in the property development sector. This course provides a sound understanding of both the principles of real estate financial modelling and the practical application of these to real-world situations through the use of spreadsheets.

The course then builds upon the real estate financial modelling principles and practices learned to apply these to property developments and the financing of these. In this way, participants improve their mastery of real estate investment evaluation principles and concepts, then see how to apply these in practical applications.

Finally, the course describes how to both detect and prevent errors from occurring.

Learning Objectives:

• Real estate professionals often need to go beyond what pre-built financial models like Estate Master provide. Examples include analysing unique situations, complex deals, or just to ensure they understand the fundamentals of their project’s forecast.
• This course provides an excellent grounding in building financial models for real estate property developments of all kinds. The examples used are primarily from projects where property is acquired, developed, then split-up and sold (although the same principles can be applied to all kinds of real estate financial modelling).
• If you already have some experience in property investment or development, and would like to take your modelling skills to the next level, making your models more flexible, robust and user-friendly, then this is an excellent course for you.
• Extensive worked examples and models are used throughout the course so that participants gain valuable experience in designing solutions to real-world financial modelling challenges in the property sector.

Target Audience:

• Property Analysts
• Finance Analysts
• Lenders/bankers involved with property
• Property Consultants
• CFOs & Accountants
• Property Investors
• Property Developers
• Property Syndicate Professionals
• Property Managers
• Providers of Public Housing Projects

Why Choose This Course?

This course blends practical Excel skills with real-world property modelling, helping you build flexible, accurate financial models from scratch. Through case studies and hands-on exercises, you’ll gain the confidence to evaluate complex real estate projects, improve decision-making, and avoid common modelling errors—making it highly valuable for both beginners and experienced professionals.

©2026 MG Aussie Events. This content is protected by copyright law. Copy or Reproduction without permission is prohibited.

Why People Should Opt for In-House Training?

In-house training is tailored specifically to your organisation’s needs, using your real projects, data, and challenges. It ensures consistent skill development across teams, improves collaboration, and delivers immediate practical impact—making learning more relevant, efficient, and cost-effective than generic public courses.

Contact us today to schedule a customized in-house, face-to-face session:

Info: This one-day intensive workshop helps participants to get the most out of the remainder of the course. It covers key, advanced areas of Excel that are relevant to real estate financial modelling and project evaluation.

Info: ● Working with large data sets
● Summarising and aggregating data
● Extracting data that matches criteria using flexible formulas
● Error handling
● Ways of improving structure
● Techniques for keeping formulas consistent yet flexible
● Combining and splitting cells according to the content they contain
● Advanced techniques for creating automatically expanding charts and ranges
● Introduction to macros & when to use these
We then apply and practise these functions during the remainder of the course.

Info: ● What is a financial model?
● What is included in the scope of a financial model?
● What makes a good spreadsheet model?

Info: ● The 7 steps of financial model building
● How to compare and contrast different scenarios
● Best practice guidelines and financial modelling standards
● Compare and contrast functions, formatting and functionality
● Designing for flexibility and scalability
● Designing for consistency
● Designing for usability and functionality
● Designing checks and balances
● Best practices for creating and displaying checks and balances
● Using financial modelling standards
● Compare different financial modelling standards
● Examples of standards and how to apply these
● Setting up Excel for efficient financial modelling
● Learn the tips and techniques that will dramatically speed up the creation
of your financial models
● Using VBA in financial models
● When is it appropriate & when is it not appropriate?
● What things is it best suited for in financial modelling?

Info: Identify the key components of a standards-based, real estate financial modelling
template

Info: Topics covered include:
● Principles of discounted cash flow (DCF) modelling
● Investment indicators: WACC, NPV, IRR, Payback
● Valuation techniques & considerations
● Escalation factors for revenue, costs and CAPEX
● S-Curve real estate financial modelling for construction costs
● Modelling uncertainty using sensitivity & scenario analysis
● Model optimisation to consider constraints: tools and techniques available
● Presentation and interpretation of results: charts & presentations
● Methods for comparing and selecting projects: key charts & techniques

Info: Design and scope the model: what should be included/excluded? What are the key
outputs & sensitivities? How will the model need to be designed to provide these?

Info: How to design and build a model that is flexible, robust, and user-friendly. Learn how to
allow for future expansion, change of strategy, different scenarios and sensitivities in a
way that allows the user to easily switch between these.

Info: Create a cash flow model for a property development project, building up the model
line-by-line.

Info: How to model debt finance in property models.
Topics covered include:
● Typical banking covenants and financing arrangements
● Simple debt schedules
● More complex debt waterfalls
● Dealing with fees, interest expense, drawdowns, and interest capitalisation
● Cash sweep

Info: Extend your model to include debt financing and loan covenants

Info: Calculate and sense-check the key outputs: charts, investment indicators.

Info: Identify key risk areas and then incorporate sensitivity factors for these. Build a
sophisticated scenario manager to run multiple scenarios and highlight the results.

Info: How to detect and prevent errors from occurring.
Topics covered include:
– Why audit financial models?
– Excel’s auditing tools
– Automated testing tools: role, purpose, limitations, demonstration
– Model documentation

Info: Build controls and checks then summarise these so the model’s integrity can be
checked and reviewed easily.

Know what’s Happening Next — before everyone else does.

Get App

Host or Publisher MG Aussie