Residential Acquisition Pro Forma Model
The complete real estate financial model for residential acquisitions. Model multifamily, apartments, condos, townhomes, and more.
Supported Residential Property Types
The Residential Acquisition Pro Forma Model is ready for due diligence on any residential property type.
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.
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
Need a polished OM? Try Henry.ai for beautiful decks in minutes. Mention TILT for 10% off.