Property Development Excel Model

Description
This is a simple and insightful financial model for property development projects. The model uses typical cost structure including land acquisition costs, construction costs (i.e. hard costs), soft costs (e.g. architect, project management, advertising, property taxes, etc.) and financing costs. Revenues are based on when the sales will start. Cashflows are based on the construction and unit sales timeline.

The model also assumes that equity is the first source of funding any expenditures and the last recipient when property sales start.

The model has monthly cashflows across a maximum 24-month development and sales planning timeline; Internal return of return (IRR) is calculated based on these cashflows.

The model calculates the required equity and bank financing based on the assumed gearing. To facilitate decision making, the model has a dashboard that will show the impact on the financial outcome (sales, profits, equity requires, IRR) of the various assumptions almost instantaneously.

The dashboard also show the cash ebbs and flows from equity investors, from the initial month and equity call is made to the last equity distribution is made from the sales of units.

The model is simple enough to be a building block for a deeper analysis using Monte Carlo Analysis.