MODULE 1 - ABOUT
The purpose of financial modeling for property development.
Pros and cons
Static model vs cash flow
MODULE 2 - DUE DILIGENCE
Quantify demand to figure out if the site you're looking to purchase is high quality.
Free tools to analyse a site from state-level indicators all the way down to site
specific factors
MODULE 3 - PLANNING & DESIGN
Use the local planning code to create your building areas.
Interpret local planning scheme
Create massing diagram
Figure out gross and net areas
How to design a project with setbacks
Apartment & townhouse site massing
Using comparables to inform your design
MODULE 4 - FEASIBILITY ANALYSIS IN EXCEL
Step by step walkthrough to build your own institutional-grade feasibility.
Inputs
Financing
Cash Flow
Outputs and summary
S-curve
Cash flow waterfall
Funding table
MODULE 5 - FEASIBILITY ANALYSIS IN ESTATE MASTER DF
The exact method I used to model a project and purchase $500m of property using Estate
Master.
Preferences & settings
Best practices
How to use Estate Master
Inputs
Linking cells
Financing
Cash flow
Summary
Custom tabs
Scenario analysis and iteration
MODULE 6 - FINANCING & THE CAPITAL STACK
Everything you need to know about getting your project funded.
Key terms
How funding works
Finance application basics
Pricing
The capital stack
Key elements of a loan
Enhancing returns
MODULE 7 - DOWNLOADS
Excel working model
Estate Master template
Due Diligence checklist PDF
