Mixed-Use Acquisition Pro Forma Model
The complete real estate financial model for mixed-use acquisitions. Model any combination of residential, commercial, and/or hotel uses.
Mixed-Use Video coming soon
Supported Property Types
The Acquisition Pro Forma Model is ready for due diligence on any property type. Models can be any combination of Residential, Commercial, and/or Hotel.
Why Choose TILT?
Built for real estate professionals who need depth, flexibility, and a model they can trust.
Depth & Professional Outputs
One model with the depth and functionality to handle your entire deal. Smart input features and a hyperlinked table of contents keep everything organized on a single input page, driving 50+ polished output sheets ready to present to investors, lenders, and partners.
Proven & Refined for Over a Decade
The same model, continuously enhanced and improved for 10+ years. Vetted and validated by hundreds of clients across every deal type. A model you can trust.
Not Cloud-Based, No Per-User Fees
No subscriptions, no per-seat licensing. Everyone at your company can use the model. Work offline, keep your data local, and TILT can customize it to fit your specific needs.
Free Technical Support
Get help with model questions directly from the person who built it. Fast response times and client feedback actively incorporated into model improvements.
Acquisition Pro Forma Features & Functionality
Built on proven institutional methodology with advanced Excel functionality that eliminates circular references and maximizes flexibility.
Base Functionality
Inputs & Smart Features
Inputs All on One Page
No hunting through tabs: all inputs displayed, categorized, and hyperlinked.
Show Only Rows with Data
One-click toggle to display only non-zero rows for clean, focused output.
Show/Hide Output Sheets
Easy toggle to display only the sheets you need for each presentation.
Print Selected Reports from TOC
Select and print multiple output reports as a packet directly from the table of contents.
Smart Uses and Sources
Unlike traditional models, ours understands timing and availability each month.
Auto Loan Interest Calculation
Accurately calculates loan interest without circular references or iterative calculations.
Input Error Check
Automatically detects common errors with clearly labeled warnings.
Flexible Input Methods
Enter values as $/SF, $/unit, $/month, or $total, whatever fits your workflow.
Hyperlinked Table of Contents
Navigate 50+ sheets instantly with a clickable, organized TOC.
Right-Click Sheet Reordering
Reorganize output sheets with a simple right-click menu, no dragging required.
Auto-Updating Sheet Names
Rename any sheet and the TOC updates automatically, no manual fixes.
Underwriting & Rent Roll
Commercial Tenant-by-Tenant Rent Roll
Input detailed lease terms for each commercial tenant with individual rent schedules, escalations, and expiration dates.
Vacancies, Concessions & Bad Debt
Factor in occupancy losses year by year for realistic revenue projections.
Commercial Rent Step-ups & Lease Structure
Model NNN, NN leases, rent abatements, TI's, and management and leasing assumptions for commercial tenants.
20 Different Unit Types per Property Segment
No limit on units of each type: scale your analysis to any property size.
Capital Stack & Partnership
Equity Recognition for Non-Cash Contributions
Acknowledge equity for land contributions or other non-cash assets contributed to the partnership.
Capacity for 6 Individual LPs and 3 Individual GPs
Detailed partnership structuring for complex joint ventures with up to 6 limited partners and 3 general partners.
Multiple Equity Distribution Methods
IRR waterfall, GP catch-up, fixed percentage, and other distribution methods for flexible profit-sharing structures.
Mezz Debt and Grants
Utilize multiple sources of financing alongside the acquisition loan.
Investment Returns & Exit
Flexible Exit Valuation
Set exit valuation based on cap rate or $ input for standard sales or specialized scenarios like land sales.
Comprehensive Sensitivity Analysis
Automatic "what-if" analysis on input assumptions for revenues, expenses, interest rates, and more.
Phased Renovations with Automatic Rent Increases
Schedule unit renovations over time with rent bumps that automatically apply when each phase completes.
Optional Additional Functionality
Any Property Combination
Support any mix of residential, commercial, and/or hotel in one model.
Multi-Date Exit
Sell different units at different dates over the project lifecycle.
Ready to Elevate Your Acquisition Analysis?
Get started with the industry's most comprehensive real estate acquisition model.
Frequently Asked Questions
A real estate acquisition pro forma model is the financial model used to underwrite the purchase of an existing property. It forecasts in-place and projected cash flows, value-add scenarios, refinancing, and exit returns. Unlike a development model (which starts at land), an acquisition model starts at purchase. The TILT acquisition model handles single-asset and mixed-use deals in one engine.
Yes. The TILT acquisition model handles any combination of residential, commercial, and hotel uses in a single property or portfolio. Up to 20 commercial segments and 40 residential segments per project. Shared underwriting plus segment-level rent roll, operating expense, and exit assumptions.
Yes. The same model handles residential-only, commercial-only, or hotel-only acquisitions with no extra setup. You leave the unused segments empty. Most TILT clients start with a single asset class and add segments as their deal flow expands.
Yes for commercial and retail segments. The model supports lease-by-lease modeling with lease term, abatements, TI allowances, NNN versus gross, escalations, and renewal probability. Residential segments use unit-mix-level rent inputs.
Yes. Renovation premium modeling, phased lease-up with rent increases, and refinancing for cash-out or LTV targets are all standard. Exit valuation works on cap rate or direct dollar input. Most acquisition clients use the model specifically for value-add underwriting.
TILT can customize the model. If your acquisition needs a specific lease structure, refinancing variation, or output sheet the standard build does not cover, Justin builds it in for an hourly fee.
Most clients have their first acquisition running within an hour. Every TILT model purchase includes 1 hour of complimentary setup help with Justin. Free ongoing technical support is also included.
Schedule a Free Call
Ready to elevate your real estate acquisition analysis? Fill out the form and our team will get back to you within one business day.
Why Choose TILT Analytics?
- 50+ professional output sheets
- Institutional-grade methodology
- Expert technical support
- Customization options available
Know a colleague who could use TILT? Refer them and you'll both get 10% off.