Real Estate Financial Model Proforma

Description
Sample Real Estate Consolidated Cashflow with IRR analysis for 10 year period for 4 properties.
Sources, Uses, P&L, Cashflow, Assumptions,rent roll over etc.
This is a simple model proforma for Real Estate .
An excel file with Consolidated Cash flow property assumptions- along with P&L and other assumptions,individual units cash flows for 4 units along with a sheet 2 for calculating rent roll overs for each units in line with the assumptions.
If you need more such models, you can let me know, i can customize it for your needs.
All calculations are with formula and no vba involved. it is a direct to use, by just changing assumptions and unit names for a simple review.
There is no water fall structure in this model.
Ensure all yellow cells are for input and it will automatically calculate rest.
For lease assumption- check what type of lease and input the assumptions accordingly for New and Renewal with vacancy details as well as % commission if any.
Note: All the rental details for each month are calculated in a separate sheet 2 tab for calculation purpose. This is not a comprehensive model. Only a sample which you can customize for any other property