Real Estate Financial Model

Description
Property Details:


* The Land area is 1.9 acres. Will be used 50% of the area for building apartments & Remaining 50% of the area is for Clubhouse, Parking & Amenities. The property is RERA Approved.
* As per Government rules. The land Floor Space index shouldn't 2.4x.
* Landowner & Builder is the same. Initially, he was able to adjust around 16Cr ( Not a one-shot investment into the land. Purchased pieces over the period ). In this Model considered by Mar 2020. Land was purchased
* Construction starts from the Next mth of the land purchase. ( Detail breakup is in Input Sheet )
* The remaining development cost was adjusted by business loans. Builder is able to get 2 term loans & 1 bank debt. Where term loans were backed by collateral ( 20 flats + other 50% of land )

The model flows in this way

1. Development Cost vs The funding of Cost
2. Units Sold ( Pre Construction Phase, Construction Phase, After Construction Phase )
3. Simple Income Statement (NOI Calculation )
4. Debt Repayment Schedule
5. Cash Flows ( Unlevered vs Levered Cash Flows )


The structure of the Real Estate Financial Model is as follows
1. Summary 
2. Inputs & Assumptions
3. Detail Monthly section
4. Yearly Section
5. Debt Repayment Schedule