Mixed Use Development Pro Forma Sales & Rental Scenarios
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
![Mixed Use Development Pro Forma Sales & Rental Scenarios - Templarket - Business Templates Marketplace]()
This is ready to use mixed-use development pro forma which considers 2 scenarios: sale and rental.
The user can switch between scenarios. The results will re-calculate automatically.
The model considers a flexible number of residential and a flexible number of commercial units.
The contents are as follows:
- Assumptions Tab (flexible construction budget, flexible construction timing and rental assumptions, flexible exit timing, and pricing)
- Annual & Monthly Cash Flows;
- Sales Scenario Calculations, which presents sales proceeds and expenses considering
- Operations Scenario Calculations, which presents operating revenues and expenses;
- Draw Schedule, which presents sources and uses of the capital;
- Financing/Loan Amortization + Mezzanine financing which includes the refinancing of the construction loan;
- Cost Curves, which support the cost distribution over time.
This model is:
- Clean and transparent;
- Professional;
- Reliable;
- 100% dynamic;
- Easy to use, understand and modify;
- Prepared by an industry professional with a significant track record;
- Institutional quality;
- Presentable;
- Includes only useful information.
KEY OUTPUTS
- Sources and Uses of capital;
- Dashboard with all the main metrics;
- Cost/Unit, Sale Price/Unit, Net Rental Revenue;
- NOI, Debt Service, Net Leveraged Cash Flow;
- Exit Sale Price is calculated on stabilized NOI and assumed exit cap rate;
- NPV, DCF Valuation;
- DSCR, Cash on Cash Return, IRR, Equity Multiple, Net Profit;
- Financing components including mezzanine loan and refinancing of the construction loan.
In case you have any questions or concerns before purchase, please feel free to contact me directly.
If you have specific requirements for the model or need a consultation, please also contact me.
The user can switch between scenarios. The results will re-calculate automatically.
The model considers a flexible number of residential and a flexible number of commercial units.
The contents are as follows:
- Assumptions Tab (flexible construction budget, flexible construction timing and rental assumptions, flexible exit timing, and pricing)
- Annual & Monthly Cash Flows;
- Sales Scenario Calculations, which presents sales proceeds and expenses considering
- Operations Scenario Calculations, which presents operating revenues and expenses;
- Draw Schedule, which presents sources and uses of the capital;
- Financing/Loan Amortization + Mezzanine financing which includes the refinancing of the construction loan;
- Cost Curves, which support the cost distribution over time.
This model is:
- Clean and transparent;
- Professional;
- Reliable;
- 100% dynamic;
- Easy to use, understand and modify;
- Prepared by an industry professional with a significant track record;
- Institutional quality;
- Presentable;
- Includes only useful information.
KEY OUTPUTS
- Sources and Uses of capital;
- Dashboard with all the main metrics;
- Cost/Unit, Sale Price/Unit, Net Rental Revenue;
- NOI, Debt Service, Net Leveraged Cash Flow;
- Exit Sale Price is calculated on stabilized NOI and assumed exit cap rate;
- NPV, DCF Valuation;
- DSCR, Cash on Cash Return, IRR, Equity Multiple, Net Profit;
- Financing components including mezzanine loan and refinancing of the construction loan.
In case you have any questions or concerns before purchase, please feel free to contact me directly.
If you have specific requirements for the model or need a consultation, please also contact me.
