Commercial Real Estate Financial Model

Description
This is a financial model for a mixed-use real estate project (retail, offices & residentials). It shows assumptions, projected financials & performance summary. The model assumes that the land is on a long term lease. The project owners plan to build a commercial building/mall with offices and retail spaces. There is provision made residentials but currently they are set to zero but can be adjusted. The lease rental is calculated as a percentage of the land value. The project is purely (100%) for rental and not for sale but there is a field to change the percentages from 0% sales to the desired rate.
In the model, the capital expenditure is computed based on a building rate per SQM which can be adjusted depending on the location.
In the model, you can adjust the rental rates, parking rates, rate at which rental rates grow, property management rates as % of rentals, insurance rates, maintenance rates, time taken to implement the project. Additionally, In the assumptions, one can adjust the debt to equity mix to show how the project will be financed plus the adjust the bank lending rates.
At the end, you will come up with financial statements showing the project cash flows for both monthly and annualized. There is a performance summary tab which shows key performance metrics e.g. IRR, NPV, Payback, Gross and Net Yields etc.