Master unit-level financial modelling techniques for repositioning underperforming residential assets.

This hands-on course guides participants through building a fully integrated, unit-by-unit cash flow model for value-added residential investments. The case study focuses on a residential asset repositioning strategy with the objective of delivering high-quality, premium rental apartments.

• The model begins with an already built, stranded asset that an investor intends to retrofit to meet modern standards.
• The retrofitting process occurs as existing tenants vacate the property.
• The investor will retain ownership of the residential complex to lease the upgraded units to new tenants.

If you’re looking to master the modelling of these types of assets, this course will provide you with advanced skills and guide you in applying best practices to your work.

Teaching Technique: The course will be led by our facilitator, an industry expert, who will guide you through a step-by-step process, enabling you to construct the model alongside their instruction.

In this course, you will learn to:

• Build the model from scratch on a unit-by-unit basis.
• Apply advanced formatting techniques and organisational best practices.
• Master key Excel functions and formulas used in real estate modelling.
• Incorporate error-checking methods to ensure model accuracy.
• Enhance model visualisation for clearer interpretation and actionable insights.
• Build dashboards, return metrics, and sensitivity analysis tools

By the end of the course, participants will have the tools to underwrite residential retrofit projects, analyse investment performance, and confidently present cash flow models to investors or lenders.

Who should attend this course:

• Real Estate Analysts interested in expanding their knowledge of property investment models and retrofitting projects.
• Real Estate Professionals: Including developers, property managers, and investors looking to enhance their financial modelling skills specific to rental properties.
• Real Estate Consultants: Seeking to provide better advisory services by mastering advanced modelling techniques.
• Asset Managers: Responsible for managing real estate portfolios and interested in learning best practices for modelling and retrofitting underutilised assets.
• Urban Planners and Architects: Who want to understand the financial aspects of retrofitting and developing high-end rental flats.
• MBA and Real Estate Program Students: Aspiring to gain practical, hands-on experience in real estate financial modelling.

Course Outline