Financial Modeling Insights
Expert guides, tutorials and market analysis from corporate finance professionals
The Modeling Hub opens 20 August: the Real Estate Financial Modeling platform is almost here
For the past month, this series walked through one project: a 50,000 sqm parcel in Saudi Arabia, taken from a highest and best use question all the way to a net investor IRR. Area statement, cost stack, financing…
Written by Ahmad DinLatest Articles
Return analysis and the fund layer: three IRRs, one project
Over six articles, one project has been built from the ground up: an area statement, a cost stack of SAR 887M, a pre-sales program, a financing structure, and…
Written by Ahmad Din
Cost of sales and operating assets: two engines, one model
The series so far has built one project from the ground up: an area statement, a cost stack of SAR 887M, a pre-sales program with three curves, and a financing…
Written by Ahmad Din
Residential pre-sales: collections are not revenue
The series so far has built one project: a 50,000 sqm parcel turned into an area statement, then a cost stack of SAR 887M. This article starts the revenue…
Written by Ahmad Din
Financing structure and IDC: from funding requirement to the interest loop
The series so far: a 50,000 sqm parcel became an area statement, the area statement became a cost stack of SAR 887M, and the residential component became a…
Written by Ahmad Din
Structuring construction costs: from built-up area to total development cost
In the previous article, our 50,000 sqm parcel produced 125,000 sqm of revenue-earning GFA, allocated across residential, hotel, and retail. This article…
Written by Ahmad Din
Highest and Best Use: the first decision every real estate model must answer
Every developer starts with the same question: what is the highest and best use of this land? Sell it as residential? Operate it as a hotel? Lease it as…
Written by Ahmad Din
A template is not a defensible model.
A mixed-use model I rebuilt earlier this year, hospitality and residential, in Saudi Arabia, had over 40,000 rows in a single input tab. Other tabs ran past…
Written by Ahmad DinStay Updated
Get the latest financial modeling insights delivered to your inbox.
No spam. Unsubscribe anytime.