Mixed-Use Real Estate Model: Leverage and Joint Venture Options

 This is one of the most satisfying financial models I have done in the real estate space. It is for mixed-use properties, which means an investment in a given location / cluster of locations and each area can be used for different things i.e. residential / offices / food places / or what have you. Each 'use' is separated into its own development costs, operating assumptions, and exit caps, but they are all consolidated on the same model timeline with this Excel template. Model for up to 10 years.

Pricing

After purchase, the template will be sent to your PayPal / Purchasing e-mail. This template is included in the Joint Venture bundle and Real Estate bundle.

The model starts off by letting the user define the name of each 'use' type for up to 7 different uses as well as the start year of the model. On each use type, there is a configuration for exit month, exit cap rate, and selling fees. This means you can plan to sell the various sections off at different times if so desired or all at once. Each 'use' has its own separate net operating income.

In order to allow for a separate net operating income for each 'use', the template allows assumptions to be entered individually for the rental income / occupancy / operating expenses. Each of the 7 types can be configured based on the following:

  • Development costs (monthly schedules for each with up to 22 slots for hard/soft costs). If this is an acquisition, the price can be entered here instead.
  • Sq.Ft.
  • Units
  • Start Month of Rent
  • Rent per Unit/Mo
  • Max Monthly Rent
  • Avg. Rent per Sq. Ft. / Mo.
  • Rent Growth (yr. 2-3)
  • Rent Growth (yr. 4+)
  • Starting Occupancy
  • Monthly Improvement
  • Stabilized Occupancy
  • 17 operating expense slots and annual expense growth rate
One of the biggest features of this financial model for real estate investment analysis includes the use of leverage. There are up to three different debt facilities that can be used for financing. Also, the user can opt out of debt and it can be an all-cash deal. That can easily be configured with the flip of a switch.

If leverage is used, the model automatically pulls any negative monthly cash flows from development into a construction loan that is interest only. On that loan, the interest can be determined to accrue or be paid monthly.

Based on the interest-only term, the initial loan will populate when that period is over and regular principal and interest payments will populate per the defined amortization terms. 

Finally, the user can also define a month that ReFi (refinance) happens and based on inputs for cap rate and LTV, this new loan will be used to pay back the initial loan and distribute any excess cash to investors. The new amortization costs will then populate accordingly and upon exit of the entire project, that final loan will be repaid based on remaining principal.

I did include options for prepay penalty fees on both the ReFi event and exit event.

Final output summaries include:
  • Monthly and Annual Cash Flow detail (shows every single item per the assumptions)
  • Monthly Waterfall (shows the cash flows going to the Investor / Sponsor (LP/GP) in each hurdle and in aggregate as well as the final exit IRR and DCF Analysis for each. Again, this does not have to be a joint venture and you can simply hit 0% for the investor pool if not needed.
  • Annual Executive Summary - this is sort of like an income statement in that it aggregates all the major line items and gets down to Net Operating Income. All major cash flow items are also included on here and the final cash contribution/distribution to investors / sponsors.
  • Visualizations - I really took time to make these visuals worthwhile and helpful. They give great clarity to all aspects of the deal over the 10 year period.
Screenshots of Template:
mixed-use real estate types

mixed-use real estate development

mixed-use real estate operations

mixed-use real estate leverage

mixed-use real estate refinance

mixed-use real estate income statement

mixed-use real estate cash flow

mixed-use real estate waterfall

mixed-use real estate waterfall 2

mixed-use real estate DCF Analysis

mixed-use real estate visuals

mixed-use real estate visuals 2

mixed-use real estate visuals 3

mixed-use real estate visuals 4

mixed-use real estate pro forma 1

mixed-use real estate pro forma 2

mixed-use real estate pro forma 3

mixed-use real estate pro forma 4