Prime Multifamily Development Pro Forma Model with Commercial Units
Originally published: 20/05/2020 21:33
Last version published: 15/06/2020 09:52
Publication number: ELQ-65629-4
View all versions & Certificate
certified

Prime Multifamily Development Pro Forma Model with Commercial Units

An extended version of my Multifamily Development Model

Description
This is a prime version of my ready-to-use multifamily development financial model/pro forma.

The standard version can be found under the link:

https://www.eloquens.com/tool/RyajuwRZ/finance/real-estate/apartment-development-pro-forma-excel-model

In addition, this prime version includes a well-designed dashboard, DCF valuation, mezzanine financing option, and a built-in equity waterfall structure.

This model will serve you perfectly for a proper analysis of a real estate residential development opportunity which might include a commercial component. This model was created specifically for multifamily developments of flexible sizes. This model can be used for multifamily developments which include commercial units.

In case you are looking for the financial model suitable for other property types, please contact me directly and I will be able to upload for you.

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.

To make things as easy as possible for you, I have included a video guide which explains the model is great detail.

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.

The best thing is that I update my models non-stop, so after the purchase, you are eligible to use a new version with added features and calculations.


MAIN PURPOSE OF THE MODEL

This prime version of multifamily development model will help you to:
- Present main economics of the development project on a nice dashboard;
- Estimate profitability and returns of the development project;
- Present sources and uses of capital and measure financing costs;
- Check feasibility of various 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 + Video Explanatory Guide (around 60-70 min)

The model consists of 8 interconnected tabs.

- Assumptions Tab (flexible construction budget, flexible construction timing and rental assumptions, flexible exit timing and pricing);
- Dashboard
- 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 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;
- Common 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 + Video Guide

Acquire business license for $110.00

Add to cart

Add to bookmarks

Discuss

Further information

Analysis and valuation of a multifamily development opportunity

Multifamily/Apartment development type requiring mezzanine financing option and waterfall analysis
Mixed-use development opportunity which includes the multifamily and commercial units

Will not suit other commercial property types and built-to-sell projects.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Oksana Babenka

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Prime Multifamily Development Pro Forma Model With Commercial Units?

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


0.0 / 5 (0 votes)

please wait...