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)


  • Rate this Downloadable Best Practice

    Write a review

  • Aris Gonzalez(last updated: 19/04/2021 02:04)
    Good value, simple to follow model
    Simple, easy to catch the drift of the model and dynamics.


More Best Practices from Oksana Babenka

See all

Discussion feed for Mixed Use Development Pro Forma Sales & Rental Scenarios

The user community and author are here to help. Go ahead!

  • Tim McCoskey
    do you have a presentation on You Tube, or a demo of some sort?
    arrow_drop_uparrow_drop_downReply reply

    5.0 / 5 (1 votes)

    please wait...