Commercial Development Model
Originally published: 19/10/2021 08:08
Publication number: ELQ-28622-1
View all versions & Certificate

Commercial Development Model

A fully dynamic commercial development model

This fully dynamic Excel model includes a well-designed dashboard, sources and uses presentation, DCF valuation, mezzanine financing option, and a built-in equity waterfall structure.

This model can be used for the analysis of a commercial development with up to 8 units. NNN leases can be applied or other lease structures to each unit/tenant. Number of units can be extended on request.


If you are looking for a professional financial model that can deliver all the main economics of an investment WITHOUT giving you the headache of running through a million of unnecessary cells and unclear terminology, then my models are for you.

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.


This commercial development model will help you to:
- Present main economics of the development project;
- Estimate profitability and returns of the development project;
- Present sources and uses of capital and measure financing costs;
- Check feasibility of various lease structures and floor plans;
- Assess a range of construction budgets and timing assumptions;
- Assess a range of rental and exit scenarios;
- Apply mezzanine financing option to the financing structure;
- Split the final distributions between General and Limited Partners.


The package includes 1 ready-to-use Unlocked Excel File + Explanatory Consultation on request

The model consists of 9 interconnected tabs.

- Assumptions Tab (flexible construction budget, flexible construction timing and rental assumptions, flexible exit timing and pricing);
- Dashboard Presentation (Investment Summary);
- Sources and Uses Presentation;
- Annual & Monthly Cash Flows;
- Operations Summary, which calculates operating revenues and expenses;
- Draw Schedule, which presents sources and uses of the capital;
- Financing/Loan Amortization which includes the refinancing of the construction loan;
- Cost Curves, which support the cost distribution over time.


- Sources and Uses Presentation;
- Dashboard Presentation 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;
- Equity Waterfall.

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 + Explanatory Consultation on request

Acquire business license for $120.00

Add to cart

Add to bookmarks


Further information

Analysis of a commercial development project

Commercial property up to 8 tenants

Will not suit for acquisition projects


  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


More Best Practices from Oksana Babenka

See all

Any questions on Commercial Development Model?

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

0.0 / 5 (0 votes)

please wait...