Ground-Up Commercial Development

Commercial Real Estate Development Financial Model

The complete real estate financial model for commercial developments. Model office, retail, industrial, warehouse, and more.

And when deals come in faster than you can underwrite them, we can work as part of your team as needed.

Walkthrough of the TILT commercial development model

The video showcases a mixed-use commercial/residential version, but you can get commercial only.

500+
firms use TILT models
$1M–$1B+
deal sizes underwritten
15+ yrs
building financial models
5,000+ hrs
spent building this model

Commercial Property Types

Use up to 20 commercial segments. Each segment can have its own use, square footage, rent structure, and operating expenses.

  • Office
  • Retail
  • Industrial / Warehouse
  • Flex
  • Data Center
  • Self Storage
  • Commercial Land Development
Need more than commercial? Mixed-Use Residential Hotel Quick Model

Pro Forma Output Reports & Presentations

Professional, print-ready output sheets designed for investor presentations, lender packages, and internal analysis.

Summary Analysis
Sensitivity Analysis
LP Cash Flows
LP Cash Flow Chart
Breakeven Chart
Cash In / Cash Out
Cash Flow From Operations
Deal Summary
Uses & Sources
P&L Detailed
Shareholder Return Detail
Uses & Sources

“The level of detail and sheer power of various residential and commercial scenarios within the TILT model is truly mind blowing! I have truly never seen anything close to what Justin's model can do.”

Read the full quote Hide the full quote

“During my 10 years in commercial and residential development, I've worked with a ton of proformas. Discovering TILT's model felt like finding the Holy Grail of development proformas. The level of detail and sheer power of various residential and commercial scenarios within the TILT model is truly mind blowing! I have truly never seen anything close to what Justin's model can do. Also invaluable is Justin and his team's availability to do custom, a-la-carte, project-specific tweaks to the proforma. Equally impressive are the investor/lender-facing summary sheets, which are easy to understand and visually impeccable.”

Gabe Rogel
Founder & CEO, Arête Lofts

Use the arrow keys to page through all the sheets. Esc to close.

Get the Model
Justin Acciavatti, founder of TILT Analytics

Who builds it

Justin Acciavatti builds and supports every TILT model.

Justin has spent 15+ years building financial models, primarily for real estate developers and investors, with additional experience in investment banking, M&A, and startup finance. More than 500 firms use TILT models, and you work directly with him.

Try before you buy

Book a complimentary 15 to 30 minute screen-share before you buy. Justin will run your deal structure through the model so you can see whether it fits. If you buy, that time counts toward the one hour of working time included with the model.

Try your deal in the model

Part of your team

We can work together to efficiently run projects through the model, analyze results, prepare OMs and investor decks.

See RE Analyst services

“We value TILT's flexibility, analytical support, and ability to tailor the model to real-world execution requirements.”

Read the full quote Hide the full quote

“TILT Analytics has been a strong partner in refining and customizing our development modeling to fit our specific business strategy. Their team has been responsive and collaborative through multiple revisions, and they have been willing to work through complex underwriting issues in detail when needed. We value their flexibility, analytical support, and ability to tailor the model to real-world execution requirements.”

Isaac Kyle
Founder & CEO, Realty Logix

What the commercial development model handles

Built on proven institutional methodology with advanced Excel functionality that eliminates circular references and maximizes flexibility.

Inputs & Smart Features 11 features
  • Auto Loan Interest Calculation
    Accurately calculates construction loan interest without circular references or iterative calculations.
  • Smart Uses and Sources
    Unlike traditional models, ours understands timing and availability each month.
  • Inputs All on One Page
    No hunting through tabs: all inputs displayed, categorized, and hyperlinked.
  • Print Selected Reports from TOC
    Select and print multiple output reports as a packet directly from the table of contents.
  • Show/Hide Output Sheets
    Easy toggle to display only the sheets you need for each presentation.
  • Show Only Rows with Data
    One-click toggle to display only non-zero rows for clean, focused output.
  • 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.
Units & Revenue 9 features
  • Up to 20 Commercial Unit Types
    Each segment can have its own use, square footage, rent structure, and operating expenses, with unlimited units per type.
  • Commercial Lease Structures
    Model NNN, gross, or modified gross leases by commercial segment.
  • Commercial Triple Net
    Matches NNN expenses with tenants; understands vacancy impact on reimbursements.
  • Lease Up by Unit Type
    Manage lease-up schedules separately for each unit type with pre-leasing %.
  • Percentage Rent
    Commercial units can receive a percentage of tenant revenue in addition to base rent.
  • Other Revenues
    Capture recurring revenue such as parking and percentage rent.
  • 30 Operating Expense Lines
    Input per year, per unit, per sqft, or % of rent for each commercial segment.
  • Year-by-Year Inflation
    Incorporate granular inflation inputs for rents and operating expenses.
  • Vacancies, Concessions & Bad Debt
    Factor in occupancy losses year by year for realistic projections.
Development & Construction 7 features
  • 20 Development Phases
    In series or parallel, tied to project costs with custom timing control.
  • 50 Hard Cost Line Items
    Use itemized draw schedules with specific start/end dates for each cost.
  • Land Lot Take-Down Schedule
    Purchase large land lots in multiple transactions over time.
  • Land Parcels with Acreage
    Function with land plots or development pads based on acreage or land sqft.
  • Gantt Chart Output
    Visual timeline showing all development phases and milestones at a glance.
  • Link Soft Costs to Phases
    Assign soft costs to phases: timing automatically updates when schedules change.
  • 100 Soft Cost Line Items
    Itemize up to 100 soft costs with category names, timing, and phase linkage.
Financing & Debt 5 features
  • Refinance Loans
    %LTV requirements, cash-in-pocket calculations, and DSCR target inputs.
  • Mezz Debt and Grants
    Utilize multiple sources of financing alongside the construction loan.
  • Land Loan Prior to Construction
    Functionality for separate loans for land purchase and construction phases.
  • Construction Loan Cash Flow Sheet
    Dedicated output showing monthly draws, interest accrual, and payoff timing.
  • Interest Rate Options
    Fixed or tied to projection curves for adaptable financial modeling.
Partnership & Equity 6 features
  • Multiple Equity Distributions
    IRR waterfall, GP catch-up, fixed percentage, and more for flexible profit-sharing.
  • Up to 6 LPs and 6 GPs
    Detailed partnership structuring for complex joint ventures.
  • GP Fees Earned as Equity
    Development fees can be earned equity rather than cash during construction.
  • Non-Cash Contributions
    Acknowledge equity for land contributions to specific LP or GP partners.
  • LP/GP Timing Toggle
    Control simultaneous or separate capital contributions and payout timing.
  • GP Returns on Deal Summary
    Toggle to display GP-specific returns directly on the deal summary output.
Analysis & Reporting 6 features
  • 50+ Output Sheets
    The most comprehensive model available with hyperlinked table of contents.
  • Print-Ready Output Sheets
    Professional, investor-ready reports for presentations with key data and projections.
  • Sensitivity Analysis
    Automatic "what-if" analysis for exit years, rents, operating expenses, hard costs, and more.
  • Untrended/Stabilized Analysis
    Understand how much of your returns are based on inflationary assumptions vs. real growth.
  • Key Metrics Visible
    IRR, equity multiple, and key metrics displayed throughout inputs for real-time monitoring.
  • Calendar or Operating Year P&L
    Toggle between calendar year and fiscal year reporting views.
Optional Additional Functionality 6 add-ons
  • Multi-Date Exit
    Sell different units at different dates over the project lifecycle.
  • Tax Increment Financing (TIF)
    Integrate local economic development incentives into project models.
  • CPACE Financing
    Commercial Property Assessed Clean Energy financing integration.
  • LIHTC
    Low Income Housing Tax Credits with federal/state credits in capital stack.
  • Mezz Debt
    Mezzanine debt with flexible payback options for tailored structures.
  • Any Property Combination
    Add residential and/or hotel uses if your deal expands beyond commercial.

Ready to model your deal together?

The base model covers one property type. Add the functionality your deal needs a la carte.

Get a price for the model you need

And if you need more than the model, we can work as part of your team: underwriting deals, preparing OMs and investor decks, and building custom models.

Frequently asked questions

The model

What is a commercial development pro forma model?

It is a financial model for a ground-up commercial project. It forecasts rent, construction costs, lease-up, financing, and returns from land purchase through stabilization or sale. The TILT model supports up to 20 commercial segments.

What's the difference between a development model and an acquisition model?

A development model covers a project you are building, including land, construction costs, loan draws, lease-up or ramp-up, and stabilization. An acquisition model starts with an existing property and its current rent roll or operating results.

Is the model a downloadable Excel file?

Yes. It is a macro-enabled .xlsb Excel workbook that you download and run on your computer. Nothing runs in the cloud, and your files stay local. The license covers your company rather than individual users.

Does the model handle office, retail, industrial, and mixed commercial uses?

Yes. It supports up to 20 commercial segments, each with its own use, square footage, rent structure, and operating expenses. You can combine office, retail, industrial, flex, and other commercial uses in one project. Each segment can use NNN, gross, or modified gross leases.

Can the model handle tenant-by-tenant rent rolls?

The development model uses segment-level rent, lease-up, and concession inputs. Tenant-by-tenant detail can be added as a paid customization. For an existing property with a current rent roll, use the commercial acquisition model.

How many development phases can I model?

Up to 20 phases, in series or in parallel. Phase timing controls cost spending, loan draws, and revenue start dates.

How is this different from a free commercial development template?

Free templates are usually built for simple deals. The TILT model supports multiple commercial uses, phased development, construction financing, optional financing add-ons, and partnership waterfalls. It also includes setup help and technical support.

Financing & structure

Does the model handle construction loan draws and interest?

Yes. The model tracks monthly draws, interest accrual, and payoff timing without circular references. You can size the loan by LTC, a dollar amount, stabilized DSCR, or percent of stabilized value.

What's the difference between sizing a construction loan by LTC and by DSCR?

LTC sizes the loan as a percentage of total project cost. DSCR sizes it based on the debt service the stabilized property can support. The model supports both methods.

Does the model handle C-PACE, TIF, LIHTC, and other complex financing?

Yes. Optional paid add-ons include C-PACE, TIF, LIHTC, mezzanine debt, and multi-date exit. The model also supports grants and separate land and construction loans.

Does the model handle GP and LP waterfalls?

Yes. You can model up to 6 LP investors and 6 GP sponsors with preferred returns, IRR hurdles, and promote splits. The results flow to the deal summary and investor cash flow sheets.

Buying & support

How much does the model cost?

Pricing includes a base model and any optional features your project needs. The license covers your company rather than individual users. Use the form below to request a quote.

Can you help put my project data into the model?

Yes. TILT can enter your cost budget and other project inputs on an hourly basis. Your project information stays confidential.

What if my project later adds residential or hotel?

You can upgrade to the mixed-use version and add residential or hotel uses when you need them.

How often is the model updated?

The model is updated throughout the year. A full annual renewal includes features added during the year. Contact TILT for current renewal options.

What if I need a feature the model doesn't have?

TILT can add a financing structure, output sheet, or waterfall for an hourly fee.

Can TILT work with us beyond the model?

Yes. RE Analyst services can help enter project data, review underwriting, prepare offering memorandums and investor decks, and build custom models. Work is available by the hour or on retainer.

What's included after I get the model?

Each model includes up to one hour with Justin. You can use 15 to 30 minutes before buying to review your deal structure. That time counts toward the hour, and you can use the rest to set up your first project. Ongoing technical support is free. Project input and analysis are available by the hour.

What do I need to run the model?

You need the 64-bit Microsoft 365 desktop version of Excel on Windows or Mac, with macros enabled. Do not use Excel for the web because its macro support is limited.

How do I get the model?

Use the form below to describe your project. Justin will confirm the model fits and provide a quote. You can also book a free 15 to 30 minute screen-share before you buy.

Talk to Justin.

Tell us what you need in the model. We'll confirm it fits, price it, and set you up on your first deal.

  • 50+ investor-ready output sheets
  • One hour of working time with Justin included, including any pre-purchase screen-share
  • Free ongoing technical support
  • Custom work available if you need it
  • Underwriting, OM prep, and custom modeling as part of your team

Prefer email? [email protected]

Know a colleague who could use TILT? Refer them and you'll both get 10% off.

What property type are you focused on? (Select all that apply)
Have you seen the video walk-through of the models you're interested in?