In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and operate very similarly. This model can also be used as a condo only model with the click of a button, which I’ll discuss a bit later. Below is a detailed video walk through  and at the bottom, you can find the link to download the model.

Video – Mixed-Use Condo Development Model

What’s Included in the Mixed Use Development Model Condo/Retail

This model includes 9 tabs as follows:

  • The Control Room (ControlRoom)
    • This tab will grow over time, but for right now, this section is where you will come to turn the retail component on or off. When off, this model will function as a condo only development model.
  • The Summary Tab (Summary)
    • Organized in seven sections to provide a clean and clear overview of the essential metrics and information you would want to get a quick overview. There are a few in inputs on this tab, so be sure to look for the blue text in the following cells: C8:C10, C13, C27, C27, I35.
  • The Annual Cash Flow Tab (Annual CF)
    • As described, a roll up of the monthly cash flows into annual periods.
  • The Condo Inputs Tab (CondoInputs)
    • This is where all the inputs for the condo component are dialed in. This is also where the financing assumptions can be found. Please watch the video for a detailed walk through
  • The Retail Inputs Tab (RetailInputs)
    • This is where all the inputs for the retail component are dialed in. Again, please watch the video for a detailed walk through.
  • The Budget Tab (Budget)
    • This is where all the budget items are input. There is a Budget Inputs section on the right hand side and within that are six sub-sections where you can categorize the budget and then insert line items within. This will then automatically update and format the Budget Summary and Budget Detail section on the left.
  •  The Monthly Cash Flow Tab (CF)
    • In this tab, we show all the cash flows over monthly periods from construction to sale. This tab allows us to control the timing and how the cash flows over that time.
  • The Custom Monthly Cash Flow Tab (CustCF)
    • If you have a unique cash outflow that doesn’t fit in with any of the options available, you can select custom for the particular line item in the CF tab and come here to input the cash flow.
  • The Waterfall Tab (Waterfall)
    • this tab allows you model partnership cash flows over three tiers and using either an IRR or Equity Multiple hurdle.

Download the Mixed-Use Condo/Retail Development Model

To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – typical real estate DCF models sell for $100 – $300+ per license). Just enter a price together with an email address to send the download link to, and then click ‘Continue’. If you have any questions about our “Pay What You’re Able” program or why we offer our models on this basis, please reach out to either Mike or Spencer.

We regularly update the model (see version notes). Paid contributors to the model receive a new download link via email each time the model is updated.

About the Author: Michael Belasco has over ten years of real estate and construction experience. He currently works for a global real estate investment, development, and asset management firm in San Francisco managing large scale development projects in the city. Michael has both an MBA and Master in Real Estate with a concentration in Real Estate Finance from Cornell University.