REAL ESTATE FINANCIAL MODELS

Premium Real Estate Excel Models

Robust and Versatile Functionality with Institutional-Grade Output Analysis.

TILT Real Estate Models Are Unparalleled.

Real estate development model

CLICK HERE TO LEARN MORE

real estate acquisition model

CLICK HERE TO LEARN MORE

portfolio

Real Estate portfolio/fund model

CLICK HERE TO LEARN MORE

Real Estate Development Excel Model

The Best CRE Development Model Anywhere

TILT’s Real Estate Development Excel Spreadsheet Template boasts more functionality than you will find anywhere, many professional investor presentation output sheets, as well as clear, categorized, and hyperlinked inputs.

This video walks through the Development model with Mixed Use Commercial & Residential. Note that the Development model can be any combination of Commercial and/or Residential and/or Hotel segments.

Development Pro Forma Model Ready To Be Used For Due Diligence On Any Property Type
  • Multifamily Development Model
  • Hotel Development Model
  • Industrial Real Estate Development Model
  • Land Development Model
  • Mixed Use Development Model
  • Retail Development Model
  • Condo Development Model
  • Commercial Development Model
  • Apartment Development Model
  • Office Development Model
  • Property Development Model
  • Residential Housing Development Model
  • Townhome Development Model
  • Self Storage Development Model
  • Single Family Home Development Model
  • Affordable Housing Development Model

Real Estate Development Excel Model Functionality

Residential Property Tax Abatement
Year-by-Year Inflation Inputs on Rents & Operating Expenses
Development Phases in Series or in Parallel
Capacity for 40 Different Soft Costs
Equity Recognition for Non-Cash Contributions (eg., contributing land)
Capacity for up to 6 Individual LPs and 3 Individual GPs
Lease Up Each Unit Type Separately
EB-5 Projects
Set Exit Valuation based on cap rate or $ Input (eg., for land sales)
Various ways of inputting Revenues & OPEX (per SqFt, per Unit, etc.)
Vacancies, Concessions, & Bad Debt
20 Different Unit Types for each Property segment, and no limit on Units of each type
Functionality for Land Loan, Construction Loan, Refi Loans
Accurately Calculates Construction Loan Interest Automatically
Sensitivities on Input Assumptions for Revenues, Expenses, Interest Rates, and More.
Other revenues such as pet fees or NNN-Reimbursement
Land Lot Take-Down Schedule
Various ways to input Hard Costs (eg., per SqFt, $ Total, Cost Curve)
Functionality for Mezz Debt and Grants
Percentage-Based Developer Fees
Construction Loan Interest Rate Fixed or on Projection Curves
Multiple Methods for Equity Distributions (IRR Waterfall, GP CatchUp, etc)

Optional Functionality

Any combination of Residential and/or Commercial and/or Hotel
Multi-Date Exit Functionality can sell Different parts of project at Different Dates
Functionality For Most TIF Loans
Low Income Housing Credits (LIHTC)
Multi-Date Exit Functionality applies Exit Proceeds to Bank Debt & Remaining Dev Costs
CPACE or Current-Pay Mezz terms
Multi-Date Exit Functionality can sell units gradually over time
Free Support with your Model Purchase

 After purchase, feel free to email any specific questions on how to use the model.

TILT Analytics Can Be Your Analyst Team Member

– Populate & Analyze projects in the model together as needed

– Customize model functionality

– Walk investors through model assumptions and results

Pricing

Schedule a free call with us to discuss your model needs. Pricing depends on optional functionality. Please let us know if the Development, Acquisition, or Portfolio model is most relevant to you, which property types you need, and any other functionality requirements.

Real Estate Acquisition Excel Model

The Best CRE Acquisition Model Anywhere

TILT’s Real Estate Acquisition Excel Spreadsheet Template boasts more functionality than you will find anywhere, many professional investor presentation output sheets, as well as clear, categorized, and hyperlinked inputs.

Below are videos that walk through the Acquisition Model, one with Mixed Use Commercial & Residential, the other Hotel Acquisition. Note that the Acquisition Model can be any combination of Commercial and/or Residential and/or Hotel segments.

Pro Forma Underwriting Model Ready To Be Used For Due Diligence On Any Property Type
  • Apartment Underwriting Pro Forma Model
  • Hotel Underwriting Pro Forma Model
  • Industrial Real Estate Underwriting Pro Forma Model
  • Land Underwriting Pro Forma Model
  • Mixed Use Underwriting Pro Forma Model
  • Townhome Underwriting Pro Forma Model
  • Condo Underwriting Pro Forma Model
  • Commercial Underwriting Pro Forma Model
  • Multifamily Underwriting Pro Forma Model
  • Office Underwriting Pro Forma Model
  • Property Underwriting Pro Forma Model
  • Residential Housing Underwriting Pro Forma Model
  • Retail Underwriting Pro Forma Model
  • Self Storage Underwriting Pro Forma Model
  • Single Family Home Underwriting Pro Forma Model
  • Affordable Housing Underwriting Pro Forma Model

Real Estate Acquisition Excel Model Functionality

Equity Recognition for Non-Cash Contributions (eg., contributing land)
Capacity for up to 6 Individual LPs and 3 Individual GPs
Commercial Tenant-by-Tenant Rent Roll & Lease Terms
Vacancies, Concessions, & Bad Debt
Set Exit Valuation based on cap rate or $ Input (eg., for land sales)
Sensitivities on Input Assumptions for Revenues, Expenses, Interest Rates, and More.
20 Different Unit Types for each Property segment, and no limit on Units of each type
Functionality for Mezz Debt and Grants
Multiple Methods for Equity Distributions (IRR Waterfall, GP CatchUp, etc)
Commercial Rent Step-ups, NNN, NN, abatements, TI's, MLA
Phased Renovations with Automatic Rent Increases when Complete

Optional Functionality

Multi-Date Exit Functionality can sell Different parts of project at Different Dates
Any combination of Residential and/or Commercial and/or Hotel
Free Support with your Model Purchase

 After purchase, feel free to email any specific questions on how to use the model.

TILT Analytics Can Be Your Analyst Team Member

– Populate & Analyze projects in the model together as needed

– Customize model functionality

– Walk investors through model assumptions and results

Pricing

Schedule a free call with us to discuss your model needs. Pricing depends on optional functionality. Please let us know if the Development, Acquisition, or Portfolio model is most relevant to you, which property types you need, and any other functionality requirements.

Real Estate Portfolio / Fund Excel Model

The Best CRE Portfolio / Fund Model Anywhere

The video below walks through the Portfolio/Fund model. The Portfolio model can be used with any asset type. The Portfolio model aggregates cashflows for multipe properties. The Fund capability allows you to have overhead expenses for fund operations. The Portfolio model can be used for acquisitions and developments.

Real Estate Portfolio / Fund Excel Model Functionality

Any Asset Type, Development or Value-Add Projects
Multiple Methods for Distributing Profits to Fund Investors vs. Fund Sponsors (eg., Waterfall)
Each property with its own Timing, Costs, Loans, Income, Expenses, and Exit Sales
Output sheets for Investor Summary, Aggregate Cash Flows, and Much More
Acquisition, Disposition, and Management Fees
Capacity for 25 Properties
Capacity for 100 Fund Investors
Capacity for 5 Individual Fund Sponsors

Optional Functionality

Detailed & Itemized Development / Renovation Expense Inputs
Fund Overhead: Functionality for Fund Staff and SG&A
3rd Party LP Investors with Fund as GP
Free Support with your Model Purchase

 After purchase, feel free to email any specific questions on how to use the model.

TILT Analytics Can Be Your Analyst Team Member

– Populate & Analyze projects in the model together as needed

– Customize model functionality

– Walk investors through model assumptions and results

Pricing

Schedule a free call with us to discuss your model needs. Pricing depends on optional functionality. Please let us know if the Development, Acquisition, or Portfolio model is most relevant to you, which property types you need, and any other functionality requirements.