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

Commercial Development Model

A fully dynamic commercial development model

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

MAIN ADVANTAGES OF THE MODEL

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.


MAIN PURPOSE OF THE MODEL

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.


MAIN CONTENTS

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.


KEY OUTPUTS

- 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

Discuss

Further information

Analysis of a commercial development project

Commercial property up to 8 tenants

Will not suit for acquisition projects

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Oksana Babenka


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Commercial Development Model?

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


0.0 / 5 (0 votes)

please wait...