SmartHelping / Real Estate / Excel
Mixed-Use Real Estate
Model a property with several uses on one connected timeline. Forecast development or acquisition costs, rent, occupancy, financing, and exits for up to seven use types, then review project cash flow and investor returns over up to 10 years.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Includes both unit-based and square-foot-based templates.
See the model in action
Walk through the property, financing, and return calculations.
Two templates. One purchase.
Choose the input approach that fits the property.
Both versions support a mixed-use investment such as residential, office, and retail space within one location or a group of locations.
Unit-based template
Build rental assumptions around units and rent per unit per month, with separate occupancy, rent growth, and operating costs for each use.
Square-foot-based template
Use average rent per square foot and average operating expense per square foot as the primary drivers. This version is included with the unit-based template.
Separate assumptions. Consolidated results.
Give each use its own operating plan.
Development or acquisition costs
Schedule up to 22 hard and soft cost categories for each use on a monthly basis. For an acquisition, enter the purchase price in the cost schedule. Select financed costs and financing percentages.
Space, units, and rental income
Set square footage, units, the month rent begins, and the relevant rent inputs. The unit-based setup includes maximum monthly rent and average monthly rent per square foot.
Lease-up and rent growth
Define starting occupancy, monthly occupancy improvement, and stabilized occupancy. Set rent growth for years 2–3 and a separate rate for year 4 onward.
Operating expenses
Use up to 17 operating expense slots with annual expense growth. Separate costs by use to support an individual net operating income calculation.
Separate sale assumptions
Set an exit month, exit cap rate, and selling fees for each use. Sell different portions at different times or align their exits.
One project timeline
Name up to seven uses and define the model start year. Bring their development, operations, and exit cash flows together for a forecast of up to 10 years.
Optional leverage
Follow financing from development through exit.
Model an all-cash investment or use up to three debt facilities. Financing assumptions connect construction funding, amortizing debt, and an optional refinance.
Construction funding
Model interest-only construction financing, choose whether interest accrues or is paid monthly, and set the financed share of negative development cash flow. The remaining funding need flows to equity.
Amortizing debt
After the interest-only period, the model transitions into scheduled principal and interest payments using the defined amortization terms.
Refinance and exit
Set a refinance month, cap rate, and loan-to-value assumption. Refinance proceeds repay the initial loan, with any excess available for distribution. The remaining debt is repaid at the final project exit, with prepayment penalty inputs for refinancing and sale.
Cash flow and investor economics
Review the deal from the property and partner perspectives.
The joint venture structure is optional. Set the investor pool to 0% when a separate investor allocation is not needed.
Monthly and annual cash flow
Review detailed cash flows across the forecast, including development or acquisition costs, rental operations, financing, and sale proceeds.
Investor / sponsor waterfall
Follow monthly distributions to the investor and sponsor (LP/GP), by hurdle and in total. Review final exit IRR and discounted cash flow analysis for each.
Annual executive summary
See the major income and expense lines through net operating income, together with cash flow items and investor / sponsor contributions and distributions.
Deal visualizations
Review charts covering the investment over its forecast period to help explain the relationship between assumptions, cash flow, and results.
Also included in these bundles
Explore a broader real estate and joint venture toolkit.
Real Estate Financial Models
Explore templates for property acquisitions, development, operations, financing, and investment returns.
View the Real Estate bundleJoint Venture Waterfall Templates
Explore templates for investor and sponsor distributions, preferred returns, hurdles, and joint venture structures.
View the Joint Venture bundleSupporting tools and concepts
Review the assumptions behind the forecast.
Questions before you start
A few useful details.
Are both input versions included?
Yes. The $75 purchase includes both the unit-based and square-foot-based Excel templates.
How many different property uses can I model?
Define up to seven uses, each with separate development or acquisition costs, operating assumptions, net operating income, and exit assumptions.
Can I analyze an all-cash deal?
Yes. Debt is optional, so the model can be configured for an all-cash investment.
Does the investment have to be a joint venture?
No. Set the investor pool to 0% when a separate investor allocation is not needed.
Can different parts of the property sell at different times?
Yes. Each use has its own exit month, cap rate, and selling fee assumptions.
Bring the whole property into view
Connect each use to the investment outcome.
Both Mixed-Use Real Estate Excel templates — $75, one-time purchase.
