Insights
Practical perspectives on real estate finance, financial modeling, and deal analysis. From underwriting best practices to Excel techniques, these articles share what we've learned building models for investors, developers, and lenders.
TILT Real Estate Development Pro Forma: Model Features
A detailed reference to the TILT real estate development pro forma, including its input structure, project-cost logic, capital stack, partnership waterfalls, and 50+ output reports.
Stacked SAFEs: How Multiple SAFE Notes Convert at Your Series A
How multiple SAFEs convert at a Series A, why the dilution compounds instead of adding up, and the errors that cost founders 8 to 15 points of ownership.
Solar Project Finance After OBBBA: Modeling the 2026 Tax-Credit Uncertainty
OBBBA gives solar and wind until July 2026 to begin construction. How to model the accelerate, delay, or restructure decision, and what the FEOC rules do to the cost stack.
Office to Residential Conversion: The Underwriting Framework That Quantifies the Kill Factors
Four physical kill factors decide whether an office building can become apartments, and what acquisition discount the math actually requires.
What Every LP Expects in a Real Estate Fund Model
The five things institutional LPs test in a fund model, and what the ILPA template change means for sponsors raising in 2026.
Hotel Underwriting: RevPAR, ADR, and the Metrics That Matter
Why hotels price like a business rather than a lease, and how RevPAR, seasonality and expense ratios drive the pro forma.
Underwriting the AI Revolution: A Guide to Data Center Investment
AI data centers underwrite on power, not square footage. How to model revenue per kilowatt, cooling capex and tenant concentration.
The Definitive Commercial Real Estate Development Checklist
The four phases of a development in order, and the entitlement and due diligence surprises that kill projects after acquisition.
The Great Office Reset: How Developers Are Tackling the Oversupply Crisis
The office correction is happening on the supply side. Conversion, demolition and halted starts, and how to underwrite each one.
Good Financial Model vs. Bad Financial Model: A Guide to Best Practices
The FAST standard, the four habits that turn a model into a liability, and how to audit a spreadsheet you did not build.
A Guide to NNN Leases: How to Underwrite Net-Lease Real Estate
Net lease underwriting is a credit exercise in real estate clothing. Tenant credit tiers, 2026 cap rate ranges, and lease traps.
How to Underwrite a Multifamily Acquisition: A Step-by-Step Guide
Build revenue from the T12 and rent roll instead of the broker’s pro forma, and model the tax reassessment that follows the sale.
That $100M Exit Where Employees Got Zilch? Here’s How Leadership Can Prevent It.
Why a fully diluted percentage is not an ownership stake, how preference overhang absorbs an exit, and how carve-outs are sized.
What Is a Cap Rate? The Ultimate Guide for Real Estate Investors
What a cap rate measures, why values move inversely to it, and why the exit cap assumption swings IRR more than anything else.
How to Build a Real Estate Pro Forma in Excel from a Blank Sheet
Build a property pro forma in Excel from an empty sheet: assumptions tab, cash flow waterfall, debt, reversion and investor returns.
Your Construction Loan Interest Rate Isn’t the Only Number That Matters
Cost overruns, delays and appraisal shortfalls usually outweigh the rate you negotiated. How to size each risk before you sign.
Understanding Equity Waterfalls in Real Estate: A Guide for Investors and Developers
How profits move through return of capital, preferred return, catch-up and the split, and why those tiers are not interchangeable.
How the EB-5 Program is Revolutionizing Real Estate Development
How EB-5 capital funds development, what the investment and job creation tests require, and where these deals run into trouble.
Understanding Tax Increment Financing (TIF): A Simple Guide for Real Estate Development Financial Modeling
How TIF captures the growth in property tax revenue to fund infrastructure, and how to build the increment into a development model.
Low-Income Housing Tax Credits (LIHTC) and How They Fit into Financial Models
How housing credits convert into equity, what investors pay per dollar of credit, and where LIHTC sits in the capital stack.
Understanding Mezzanine Debt and Its Role in Financial Modeling
Where mezzanine sits in the stack, what it costs, and how to model PIK interest that accrues and compounds to maturity.
A Comprehensive Guide to Financial Modeling for Real Estate
What real estate models are for, how development, acquisition and fund models differ, and why cash flow timing matters most.
Update: User Feature Enhancements Nov. 6, 2024
Product update: three enhancements to how TILT models organize data and handle the output sheets.
TILT Models Redesigned
Product update: a redesigned model interface with key metrics on the inputs sheet and a one-click output cleanup.
TILT’s New Blog
The first post on this blog, and the topics it set out to cover.


