Mixed-Use Development Model: Condo and Retail (Updated July 2025)
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 Development Model – Condo & Retail
In this video, I walk you through how to use my Mixed-Use Condo Development Model.
Version 2.0 – Update Video
Note: the video update is from the Condo Development Model as the major updates to the Condo/Retail model were identical. So, all the updates described in this video will be compatible with this updated model.
What’s Included in the Mixed Use Development Model Condo/Retail
This model includes 10 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.
- Buyer Deposit Tracker Tab
- If you are using buyer deposits to help fund your development project, the Buyer Deposit tab allows you the option to track deposits from buyers and apply them to pay for development costs. Click here, and check out the Buyer Deposit Module – Condo Development Model video walkthrough, which is perfectly applicable to the Mixed-Use Development model: Condo and Retail.
- 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.
Frequently Asked Questions about the Mixed-Use Development Model: Condo and Retail
Version Notes
v3.5
- Renamed “Deposits Utilized” to “Total Deposits Used (Construction + Closing)” for clarity (Cell C252 – CF tab)
- Updated the formula in Cell D252 (CF tab) to correctly reference the newly renamed “Total Deposits Used (Construction + Closing)” value
- Relocated the calculation of “Buyer deposits utilized for construction (%)” from Cell F252 to Cell F254 (CF tab) to improve layout logic
- Revised the formula to correctly deduct buyer deposits from the sales cash flow during presales, preventing duplication at closing (Row 198 – Condo Revenue, CF tab) and appropriately reflecting the deposits as cash available (Row 265 – CF tab)
- Adjusted the formula for “Cash Available” calculation (Row 265 – CF tab), preventing duplication of buyer deposits at closing
- Adjusted the net unlevered cash flow calculation to consider the buyer deposits utilized for construction (Row 279, CF tab)
- Corrected the sale expenses deduction logic at construction completion, considering buyer deposits (Row 201 – CF tab)
- Adjusted formula to correctly capture the Loan Fee (Row 274, CF tab)
- Adjusted formula to correctly calculate the Retail Sale (Row 246, CF tab)
- Summary Tab Adjustments (Cost/Revenue Analysis):
- Modified the $/SSF Sale Price formula (Cell I36) to include now “Deposits Utilized for Construction
- Adjusted the $/SSF Less Expenses formula (Cell I37) to account for “Deposits Utilized for Construction”
- Included ‘Cash Flow from Operations (Retail)’ in the analysis.
- Updated the Gain (Loss) calculation (Cell I43) to include the impact of ‘Cash Flow from Operations (Retail)’
- Adjusted formula to correctly calculate the distribution calculation as % (GP %) in Tier 2 (Cell D30 – Waterfall tab)
v3.2
- Corrected the formula to accurately deduct buyer deposits from sales cash flow during presales (Row 198 – Condo Revenue, CF tab).
- Corrected the formula to properly incorporate buyer deposits in the draw schedule (Rows 258 – Equity Required and 263 – Debt Funded, CF tab)
- Updated the formula to capture parking stall revenue and the remaining buyer deposit at construction completion (Row 265 – Cash Available, CF tab)
v3.1
- Adjusted formula to correctly capture the start and end dates for the custom growth forecasting method (Columns G and I – CF tab)
v3.0
- Added a buyer deposit module
- Incorporated buyer deposit details for financing throughout the model.
- Added warnings (red box) on each tab when loan recalibration is required.
v2.3
- Adjusted typing error in Cell B49 – Summary Tab.
- Adjusted the interest rates index reference from Libor to SOFR.
v2.2
- Adjusted “Sell out Date” formula (Cell E14 – CondoInputs) to correctly capture the cash flow of the “Number of condo units sold in last month”.
v2.1
- Adjusted the name of “Taxes” to “Condo Taxes” for both the “Annual CF” tab (Cell B26) and “CF” tab (Cell C202), to correctly capture that cash flow in the “Annual CF” tab.
v2.0
- Major Summary tab overhaul and redesign
- Moved construction debt assumptions and summary section from the CondoInputs tab to the Summary tab
- Added Recalibrate Loan notifications on the Summary tab
v1.1
- Added error check in CF tab to ensure total cash flow distributed equals total amount budgeted for.
- Added Totals column to draw schedule in CF tab for equity, debt, interest, and loan fees.
- Fixed error to add parking stall revenue to total revenue in CF tab.
- Added parking stall revenue to Annual CF tab
- Fixed error on Net Proceeds calcs on the Annual CF tab
v1.0
- Initial Launch