LIBRARY OF REAL ESTATE EXCEL MODELS
The world’s largest library of readily accessible real estate Excel models
BECOME A REAL ESTATE FINANCIAL MODELING PRO
Proven Curriculum | Specialty Endorsements | Easy-To-Use Platform
LIBRARY OF REAL ESTATE EXCEL MODELS
The world’s largest library of readily accessible real estate Excel models
Share the Library with Others
All 154
All 154 /General 0 /Market News 0 /RE Education 0 /Net Lease 0 /Careers 0 /Real Estate Financial Modeling 0 /Excel Tips 0 /Excel Models 0 /Argus 0 /Interesting Deals 0 /Leases 0 /Interviews 0 /Hotel 9 /Portfolio 2 /Apartment 16 /Office 15 /Retail 16 /Industrial 16 /Single Family 9 /Tutorial 46 /Equity Waterfall 18 /Modules 39 /Excel Add-ins 9 /University Real Estate Education 0 /Real Estate Taxes 0 /Stochastic Modeling 0 /Investment Analysis 0 /Masters in Real Estate Profiles 0 /Asset Management 4 /Land Development 10 /Basics 0 /Compensation Statistics 0 /Crowdfunding 0 /Building SF 0 /Development 29 /Standalone 40 /Acquisition 35 /Value-Add 18 /Debt 13 /Special Topics 0 /A.CRE All-in-One (Ai1) Model 18 /Condo 5 /Technology 0 /Resume 0 /Book Reviews 0 /Jobs 0 /A.CRE Job Board 0 /Tutorials 0 /Back Of The Envelope 0 /Real Estate Mental Math 0 /MBA in Real Estate 0 /Ai1 Download 0 /Ai1 Tutorials 0 /Role Types 0 /A.CRE 101 - Basic Concepts in Commercial Real Estate 0 /Watch Me Build 0 /CRE Vocabulary 0 /Deep Dive 0 /Sources of Capital 0 /Real Estate Private Equity 0 /Development 0 /Self Storage 2 /Land 0 /Real Estate Financial Modeling Accelerator 0 /Acquisitions 0 /Asset Management 0 /Valuation 0 /Entitlements 0 /Careers (Deep Dive) 0 /Audio Series 0 /Season 1 0 /Google Sheets 0 /Undergraduate Education 0 /Real Estate Legal 0 /Acquisition 0 /Season 2 0 /Promo 0 /Leasing 0 /Affordable Housing 1 /Letter of Intent 0 /Office 0 /Abstract 0 /Real Estate Case Studies 0 /Acquisition 0 /Apartment 0 /Value-Add 0 /Office 0 /Retail 0 /Core 0 /STNL 0 /Hotel 0 /PSA 0 /Multifamily 0 /Day in the Life 0 /Includes Solution 0 /Value-Add 0 /Partnership 0 /Industrial 0 /Development 0 /Land 0 /Retail 0 /Accelerators in Action 0 /Asset Management 0 /Contract to Close 0 /Townhome 2 /Season 3 0 /International CRE 0 /Modelos Financieros Inmobiliarios 0 /Apartamento 0 /Español 0 /Tutoriales 0 /Terreno 0 /Modelado Financiero Inmobiliario 0 /Tips de Excel 0 /Educación 0 /A.CRE 101 - Conceptos Básicos en Bienes Inmuebles Comerciales 0 /Mirame Construir 0 /LinkedIn Networking 0 /A.CRE Real Estate Sponsor Series 0 /Condominio 0 /Industrial 0 /Cascada de Equidad 0 /Student Housing 1 /Glosario 0 /Artificial Intelligence 0 /Hotel 0 /Adquisición 0 /Desarrollo 0 /RV Park 2 /Métricas 0 /Indicadores 0 /Deuda 0 /Préstamo 0 /Universidades de Bienes Inmuebles 0 /Maestría en Bienes Inmuebles 0 /Maestría en Administración de Empresas 0 /Carreras 0 /Inteligencia Artificial 0 /Real Estate Clubs 0 /Profundiza 0 /Valuación 0 /First CRE Job 0 /Centros Comerciales 0 /Bienes Inmuebles de America Latina 0 /LatAm CRE 0 /AI Applications for CRE 0 /AI Training 0 /AI Tools for CRE 0 /Multifamiliar 0 /Multifamily 0 /Income Approach 0 /Enfoque Basado en Ingresos 0 /Tipos de Roles 0 /Oficina 0 /Season 4 0 /Caso de Estudio Inmobiliario 0 /Adquisición 0 /Hotel 0 /Art of Underwriting 0 /1031 Exchange 0 /LinkedIn 101 0 /Entrevistas 0 /Complemento de Excel 0 /Estudiante 0 /Eventos 0 /Reseña de libros 0 /Multifamily 1 /Aplicaciones IA 0 /Build-to-Rent 1 /Custom GPT 0 /Unifamiliar 0 /GPT Personalizado 0 /Temas Especiales 0 /Análisis de inversión 0 /Gestión de activos 0 /A.CRE Consulting Podcast Season 1 0 /Carreras en Bienes Raíces 0 /Real Estate Rates 0 /Desarrollo Inmobiliario 0 /Season 5 0 /Funciones de Excel 0 /Short Term Rental 0 /Acquisitions 0 /Rentas a Corto Plazo 0 /AI 0 /Season 6 0 /AI.Edge 0 /Contracts 0 /Data Center 0 /Data Center 1 /Centro de Datos 0 /Valuation 0 /Cell Tower 0 /Torre de Telefonía Móvil 0 /Multipliers Podcast 0 /Season 1 0 /Multiplicadores 0 /Podcast multiplicadores 0 /Bienes raíces comerciales 0 /Financiación Inmobiliaria 0 /Crypto 0 /Cripto 0 /Mercado Inmobiliario 0 /Tecnología e Innovación 0 /AI Skills 0
A.CRE Apartment Development Model (Updated June 2026)
June 12, 2026/by Spencer BurtonPro Forma For Multifamily Renovation (Updated June 2026)
June 8, 2026/by Michael BelascoCommercial Mortgage Loan Analysis Model (Updated June 2026)
June 8, 2026/by Spencer BurtonBack-of-the-Envelope Office, Retail, Industrial Acquisition Model (Updated June 2026)
June 5, 2026/by Michael BelascoResidential Land Development Pro Forma (Updated June 2026)
June 1, 2026/by Spencer BurtonA.CRE Value-Add Apartment Acquisition Model (Updated May 2026)
May 28, 2026/by Spencer BurtonReal Estate Asset Management Model (Updated May 2026)
May 27, 2026/by Arturo ParadaIndustrial Real Estate Development Model (Updated May 2026)
May 19, 2026/by Spencer BurtonAll-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated May 2026)
May 19, 2026/by Spencer BurtonMultifamily (Apartment) Acquisition Model (Updated May 2026)
May 15, 2026/by Spencer BurtonGround Lease Valuation Model (Updated May 2026)
May 5, 2026/by Spencer BurtonReal Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Apr 2026)
April 22, 2026/by Michael BelascoData Center Development Model (Updated Apr 2026)
April 21, 2026/by Arturo Parada3-Tiered Acquisition Debt Module (Updated Apr 2026)
April 15, 2026/by Michael BelascoHotel Acquisition Model – The Basic Model (Updated April 2026)
April 1, 2026/by Michael BelascoMultifamily Redevelopment Model (Updated March 2026)
March 27, 2026/by Michael BelascoCell Tower Valuation Model (Updated March 2026)
March 3, 2026/by Arturo ParadaStudent Housing Acquisition Model (Updated Feb 2026)
February 23, 2026/by Spencer BurtonCommercial Real Estate Lease Analysis Tool (Updated Feb 2026)
February 23, 2026/by Spencer BurtonWatch Me Build A Construction Draw Schedule (Updated Feb 2026)
February 21, 2026/by Michael BelascoVision Reveals Hidden Value in CRE. Math Captures It.
February 20, 2026/by Arturo ParadaSelf Storage Acquisition Model (Updated Jan 2026)
January 20, 2026/by Spencer BurtonSupercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated Jan 2026)
January 5, 2026/by Spencer BurtonCondominium Development Model (Updated Dec 2025)
December 10, 2025/by Michael BelascoOffice Real Estate Development Model (Updated Nov 2025)
November 10, 2025/by Spencer BurtonThe First Dollars In: Modeling Pursuit Capital In Real Estate Deals
October 30, 2025/by Arturo ParadaRetail Real Estate Development Model (Updated Oct 2025)
October 28, 2025/by Spencer BurtonExcel Pro Forma for Flipping Houses (Updated Sept 2025)
October 2, 2025/by Spencer BurtonWatch Me Solve a REPE Technical Interview Modeling Test (Updated Sept 2025)
September 17, 2025/by Spencer BurtonA.CRE Self Storage Development Model (Updated Aug 2025)
August 13, 2025/by Spencer BurtonLand Development Model – Multi-Scenario (Updated Aug 2025)
August 8, 2025/by Spencer BurtonUnderstanding Stabilization Through The Lens Of Operating Expense Ratio
August 7, 2025/by Arturo ParadaA.CRE Build-to-Rent (BTR) Development Model (Updated Aug 2025)
August 6, 2025/by Spencer Burton30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025)
July 21, 2025/by Michael BelascoReal Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated July 2025)
July 18, 2025/by Spencer BurtonMixed-Use Development Model: Condo and Retail (Updated July 2025)
July 11, 2025/by Michael BelascoSingle Family Home Construction Pro Forma for Home Builders (Updated July 2025)
July 1, 2025/by Spencer BurtonWatch Me Build a Residential Land Development Model (Updated June 2025)
June 8, 2025/by Spencer BurtonSingle Tenant NNN Lease Valuation Model (Updated May 2025)
May 19, 2025/by Spencer BurtonShort-Term Rental Acquisition Model
April 5, 2025/by Arturo ParadaTutorial on How to Model Irregular Growth Rates in Real Estate
March 17, 2025/by Spencer BurtonSimple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2024)
December 30, 2024/by Spencer BurtonReal Estate Equity Waterfall Model with Catch Up and Clawback (Updated Dec 2024)
December 12, 2024/by Spencer BurtonWatch Me Build a Dynamic Mortgage Amortization Table in Excel (Updated September 2024)
September 25, 2024/by Spencer BurtonDeep Dive – Land Acquisition and Assemblage (Updated September 2024)
September 23, 2024/by Spencer BurtonWatch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated Aug 2024)
August 27, 2024/by Spencer BurtonHow to Run Monte Carlo Simulations in Excel (Updated Aug 2024)
August 18, 2024/by Spencer BurtonLoan Payment Schedule and Balance Tracking Tool (Updated Aug 2024)
August 9, 2024/by Spencer BurtonReal Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Jul 2024)
July 27, 2024/by Spencer BurtonLinear Mortgage Payment Schedule Tool (Updated July 2024)
July 24, 2024/by Spencer BurtonCase Study #10 – Class A Industrial Warehouse + Rooftop Solar PV Plant (Case + Solution)
July 9, 2024/by Padmaa IyerHold-Sell Analysis in Real Estate (Updated June 2024)
June 28, 2024/by Spencer BurtonUnderwriting a Tenant with Private Credit (Updated June 2024)
June 18, 2024/by Spencer BurtonWhy Your IRR and XIRR are Different (Updated June 2024)
June 5, 2024/by Michael BelascoCase Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024)
June 4, 2024/by Michael BelascoA.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property (Updated May 2024)
May 31, 2024/by Spencer BurtonForecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2024)
May 29, 2024/by Spencer BurtonCase Study #4 – The Stones Hotel Acquisition – Case Only (Updated May 2024)
May 28, 2024/by Michael BelascoAdvanced Mortgage Amortization Module (Updated May 2024)
May 26, 2024/by Spencer BurtonReal Estate Debt Module in Excel (Updated May 2024)
May 14, 2024/by Spencer BurtonTiming of Preferred Return vs Return of Capital in an Equity Waterfall with IRR Hurdles (Updated May 2024)
May 10, 2024/by Spencer BurtonWatch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024)
May 5, 2024/by Spencer BurtonReal Estate Capital Account Tracking Tool (Updated Apr 2024)
May 1, 2024/by Spencer BurtonHide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)
April 28, 2024/by Spencer BurtonWatch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024)
April 28, 2024/by Spencer BurtonAdvanced Mortgage Amortization Schedule – Custom GPT by A.CRE
April 27, 2024/by Spencer BurtonMultifamily Development Model (Updated April 2024)
April 17, 2024/by Michael BelascoConstruction Draw and Interest Calculation Model (Updated Feb 2024)
February 25, 2024/by Spencer BurtonReal Estate Sources and Uses of Capital Module (Updated Feb 2024)
February 25, 2024/by Spencer BurtonReal Estate Development Tracker (Updated Feb 2024)
February 24, 2024/by Michael BelascoHotel Development Model (Updated February 2024)
February 1, 2024/by Michael BelascoRV Park Development Model (Initial Release)
January 30, 2024/by Michael BelascoModeling a Property Tax Abatement in Real Estate (Updated Jan 2024)
January 23, 2024/by Spencer BurtonA.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jan 2024)
January 18, 2024/by Spencer BurtonUsing an IRR Matrix to Determine Hold Period (Updated Dec 2023)
December 26, 2023/by Spencer BurtonActual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023)
December 19, 2023/by Spencer BurtonRefinance Risk Analysis Tool in Excel (Updated Nov 2023)
November 4, 2023/by Spencer Burton1031 Exchange – Overview and Analysis Tool
October 12, 2023/by Michael BelascoCalculate Residual Land Value in Excel (Updated Jul 2023)
July 14, 2023/by Spencer BurtonThe Circuit Breaker – How to Fix Circular Reference Errors in Excel
June 19, 2023/by Spencer BurtonRV Park Acquisition Model (Updated May 2023)
May 2, 2023/by Michael BelascoSingle Family Residential Investment Analysis Model (Updated Apr 2023)
April 27, 2023/by Spencer BurtonSingle Family Rental Proforma (Updated Apr 2023)
April 22, 2023/by Michael BelascoLetter of Intent for Multifamily Real Estate
January 11, 2023/by Ron RohdeLetter of Intent for Commercial Industrial Purchase
November 30, 2022/by Ron RohdeCreate A Dynamic Revenue Row to Calculate Multiple Tenant Leases (Updated Nov 2022)
November 17, 2022/by Michael BelascoA.CRE Hotel Valuation Model in Excel (Updated Sept 2022)
September 5, 2022/by Michael BelascoReal Estate Portfolio Valuation Model (Updated Aug 2022)
August 14, 2022/by Spencer BurtonReal Estate Confidentiality Agreement
August 2, 2022/by Ron RohdeTenant Sales and Occupancy Cost in Retail Underwriting (UPDATED JUNE 2022)
June 2, 2022/by Spencer BurtonPublicly Traded Tenant Analysis Tool (Updated May 2022)
May 28, 2022/by Michael BelascoScenario Analysis Tool using the Equity Waterfall Model (UPDATED MAY 2022)
May 24, 2022/by Spencer BurtonPhysical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022)
May 6, 2022/by Spencer Burton4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022)
April 28, 2022/by Michael BelascoDevelopment Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022)
April 26, 2022/by Michael BelascoSetting Up a New Real Estate Financial Model – Date and Period Headers Plus Formatting (Updated Apr 2022)
April 23, 2022/by Spencer BurtonOffice Purchase and Sales Agreement
April 21, 2022/by Ron RohdeConstruction Draw Schedule: Accounting For True LTC (Updated Apr 2022)
April 20, 2022/by Michael BelascoConvert Monthly Cash Flows to Quarterly and Annual Cash Flows (Updated Mar 2022)
March 27, 2022/by Spencer BurtonTutorials for the A.CRE Apartment Development Model
February 1, 2022/by Spencer BurtonS-Curve Forecasting in Real Estate Development (Updated Sep 2021)
September 30, 2021/by Spencer BurtonReal Estate Equity Waterfall Model – Monthly Periods (Updated Jul 2021)
July 27, 2021/by Spencer BurtonCustom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2021)
July 3, 2021/by Spencer BurtonCould You Be Exiting Too Early? Don’t Forget to Analyze Your Reinvestment Rate
May 12, 2021/by Michael BelascoTutorials for A.CRE Value-Add Apartment Acquisition Model
May 11, 2021/by Spencer BurtonUsing Boolean Logic to Model Multiple Generations of Tenant Improvements
February 26, 2021/by Spencer BurtonReal Estate Acquisition Due Diligence Checklist
January 19, 2021/by Spencer BurtonReal Estate Development Due Diligence Checklist
January 17, 2021/by Spencer BurtonApartment Acquisition Model with Monte Carlo Simulation Module (Updated Jan 2021)
January 6, 2021/by Spencer BurtonWatch Me Build – IRR Partitioning in Excel
September 16, 2020/by Spencer BurtonWatch Me Build – Capital Stack with Mezzanine Debt
May 4, 2020/by Spencer BurtonWatch Me Build a Tenant Rollover Analysis Model
March 27, 2020/by Spencer BurtonAll-in-One (Ai1) Walkthrough #2 – Office, Retail, Industrial Rent Roll Tab
March 16, 2020/by Spencer BurtonLIHTC (Low Income Housing Tax Credits) Overview and Calculator
February 20, 2020/by Michael BelascoWatch Me Build a Multifamily Real Estate Model (Updated Feb 2020)
February 19, 2020/by Spencer BurtonDynamic Amortization Schedule (Updated 2.06.2020)
February 6, 2020/by Michael BelascoUsing VBA to Hide Rows in Excel
February 1, 2020/by Spencer BurtonWatch Me Build Data Tables For Real Estate Sensitivity Analysis
January 27, 2020/by Michael BelascoModeling a Mortgage Loan Assumption Using the All-in-One
January 26, 2020/by Spencer BurtonHow to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel
January 1, 2020/by Spencer BurtonWatch Me Expand the Home Construction Pro Forma
December 30, 2019/by Spencer BurtonAll-in-One (Ai1) Walkthrough #1 – Permanent Debt Tab (Updated Nov 2019)
November 20, 2019/by Spencer BurtonUsing Conditional Formatting in Real Estate Financial Modeling
November 19, 2019/by Spencer BurtonTutorials For The Hotel Valuation Model (Updated 07.23.19)
July 23, 2019/by Michael BelascoUsing the Floating Summary Box in Real Estate Modeling
July 16, 2019/by Spencer BurtonUsing the OFFSET Function in Real Estate Financial Modeling
May 11, 2019/by Spencer BurtonCreate a Dynamic Real Estate Chart in Excel
March 10, 2019/by Spencer BurtonQuick Tutorial: Add Line Items to OpSt Sheet in All-in-One
February 10, 2019/by Spencer BurtonExcel-Based Restaurant Selection Tool for the Overly Indecisive
December 22, 2018/by Spencer BurtonHotel Proforma Basics – Hotel Cash Flow Projection
December 12, 2018/by Michael BelascoUnderstanding Treatment of Time 0 in the All-in-One Model
August 25, 2018/by Spencer BurtonAll-in-One (Ai1) Walkthrough #10 – Underwriting a Value-Add Office Investment
October 4, 2017/by Spencer Burton3 Tiered Waterfall Module Added to the Condo Development Model
September 4, 2017/by Michael BelascoAll-in-One (Ai1) Walkthrough #9 – Print Mode and the IRR Matrix Report
August 27, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #8 – Tenancy Analysis Report for Office, Retail, and Industrial
August 12, 2017/by Spencer BurtonNew Support Forum for the All-in-One (Ai1) Underwriting Model
July 13, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #7 – Ground Lease Valuation Module
June 14, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #6 – Underwriting a Hypothetical Multifamily Acquisition
May 25, 2017/by Spencer BurtonA Note About The Limitations of Microsoft Excel in Modeling Real Estate
April 22, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #5 – The Residual Land Value Calculation Module
April 15, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #4 – The Rate Matrix Module
April 4, 2017/by Spencer BurtonAll-in-One (Ai1) Walkthrough #3 – Modeling a Hypothetical Retail Development Investment
March 21, 2017/by Spencer BurtonVersion Notes: All-in-One Underwriting Model
January 1, 2017/by Spencer BurtonSupercharge Excel with the WST Macros Add-in
April 18, 2016/by Spencer BurtonHow to Use the Apartment Acquisition Model’s Monte Carlo Simulation Module
February 21, 2016/by Spencer BurtonWaterfall Model For Real Estate Joint Ventures with Catch Up
February 15, 2016/by Michael BelascoHow to Use the Construction Draw and Interest Calculation Model
December 24, 2015/by Spencer BurtonReal Estate Waterfall Model – Equity Multiple Hurdles
December 1, 2015/by Spencer BurtonApartment Valuation Tutorial Using the Real Estate Acquisition Model
November 14, 2015/by Spencer BurtonHow to Use My Real Estate Equity Waterfall Model
August 9, 2015/by Spencer BurtonUpdate to Portfolio Acquisition Model
July 19, 2015/by Spencer BurtonReal Estate Development ROI Models
July 5, 2015/by Spencer BurtonHotel Value-Add Assignment Example
April 16, 2015/by Spencer BurtonMultifamily Development Model
February 10, 2015/by Spencer BurtonAbout this Library of Excel Models
Over the last few years, we’ve worked to build the world’s largest library of readily accessible Excel models (real estate pro formas) for commercial and residential real estate professionals.
All models are built in Microsoft Excel 2013 or newer. We have built models for virtually every real estate property type (e.g. retail, industrial, office, multifamily, hotel, etc), investment type (e.g. development, acquisition, value-add, etc), and analysis purpose.
All models are offered either completely free, or on a “Pay What You’re Able” basis with no minimum.
We offer our models on this basis because 1) this is first and foremost a resource for young professionals and students to learn, 2) our readers come from across the globe and from all socioeconomic levels, and 3) not all of our models have been thoroughly audited and tested for errors.
If there is a model or concept you’d like us to add to this library. Or if you spot a bug in a model needing fixed, please don’t hesitate to contact us.
How to Browse the Library
Browse the library above by property type and/or model type. Looking for an Excel model to value an apartment complex? Click the ‘Apartment’ link at the top of the library grid and the library will automatically sort by apartment models.
Models are either standalone or modules. Standalone models require no other components.
Modules on the other hand are meant to add to an existing model for further analysis. For instance, we have several Equity Waterfall models that are modules. The partnership-level cash flows need to be modeled separately, and then linked to the waterfall to calculate the partnership-level returns.
Note About Models
Models downloaded from A.CRE may contain errors. Verify formulas/methodology before basing investment decisions on any model here. Read our Terms and Conditions of Use and Disclaimer.