Mixed Use Development Pro Forma Sales & Rental Scenarios
Originally published: 01/07/2020 06:10
Last version published: 04/07/2020 06:24
Publication number: ELQ-86218-3
View all versions & Certificate

Mixed Use Development Pro Forma Sales & Rental Scenarios

Detailed mixed-use real estate development pro forma which considers 2 scenarios: sale and rental.

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.


- 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.

This Best Practice includes
1 Unlocked Excel File

Acquire business license for $110.00

Add to cart

Add to bookmarks


Further information

Determine the returns from mixed-use development projects

Development projects consisting of both residential and commercial components

Not ideal for large commercial developments (retail, office, hotels)

5.0 / 5 (1 votes)

please wait...