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 147
All 147 /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 17 /Industrial 15 /Single Family 9 /Tutorial 45 /Equity Waterfall 17 /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 3 /Land Development 10 /Basics 0 /Compensation Statistics 0 /Crowdfunding 0 /Building SF 0 /Development 28 /Standalone 40 /Acquisition 33 /Value-Add 17 /Debt 12 /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 0 /Glosario 0 /Artificial Intelligence 0 /Hotel 0 /Adquisición 0 /Desarrollo 0 /RV Park 0 /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 0 /Aplicaciones IA 0 /Build-to-Rent 0 /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
All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Nov 2024)
November 19, 2024/by Spencer BurtonCondominium Development Model (Updated Nov 2024)
November 15, 2024/by Michael BelascoA.CRE Build-to-Rent (BTR) Development Model (Updated Nov 2024)
November 14, 2024/by Spencer BurtonMixed-Use Development Model: Condo and Retail (Updated Nov 2024)
November 13, 2024/by Michael BelascoIndustrial Real Estate Development Model (Updated Nov 2024)
November 7, 2024/by Spencer BurtonCase Study #13 – “BioMedica” Chain Drugstore – Build-to-Suit Investment in Colombia (Case Only)
October 8, 2024/by Emilio TovarWatch 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 Residential Land Development Model (Updated Sept 2024)
September 7, 2024/by Spencer BurtonReal Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Sept 2024)
September 6, 2024/by Spencer BurtonSupercharge Excel with the ‘Excel 4 CRE’ Add-In (Updated Aug 2024)
August 29, 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 BurtonWatch Me Solve a REPE Technical Interview Modeling Test (Updated July 2024)
July 17, 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 BurtonLand Development Model – Multi-Scenario (Updated Jun 2024)
June 20, 2024/by Spencer BurtonUnderwriting a Tenant with Private Credit (Updated June 2024)
June 18, 2024/by Spencer BurtonA.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jun 2024)
June 17, 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 BurtonGround Lease Valuation Model (Updated May 2024)
May 29, 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 BurtonSingle Tenant NNN Lease Valuation Model (Updated May 2024)
May 21, 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 BelascoExcel Pro Forma for Flipping Houses (Updated Apr 2024)
April 11, 2024/by Spencer BurtonA.CRE Apartment Development Model (Updated Apr 2024)
April 7, 2024/by Spencer BurtonRetail Real Estate Development Model (Updated Apr 2024)
April 1, 2024/by Spencer BurtonOffice Real Estate Development Model (Updated Apr 2024)
April 1, 2024/by Spencer BurtonCommercial Mortgage Loan Analysis Model (Updated Mar 2024)
March 7, 2024/by Spencer BurtonConstruction 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 BurtonA.CRE Self Storage Development Model (Updated Feb 2024)
February 25, 2024/by Spencer BurtonReal Estate Development Tracker (Updated Feb 2024)
February 24, 2024/by Michael BelascoResidential Land Development Pro Forma (Updated Feb 2024)
February 23, 2024/by Spencer BurtonHotel 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 BurtonSingle Family Home Construction Pro Forma for Home Builders (Updated Jan 2024)
January 13, 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 BurtonSelf Storage Acquisition Model (Updated Nov 2023)
November 18, 2023/by Spencer BurtonA.CRE Value-Add Apartment Acquisition Model (Updated Nov 2023)
November 17, 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 BelascoCommercial Real Estate Lease Analysis Tool (Updated Jul 2023)
July 31, 2023/by Spencer BurtonCalculate 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 BelascoStudent Housing Acquisition Model (Updated Apr 2023)
April 8, 2023/by Spencer BurtonLetter 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 BurtonPro Forma For Multifamily Renovation (Updated 11.17.2021)
November 17, 2021/by Michael BelascoS-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 BurtonReal Estate Equity Waterfall Model with Catch Up and Clawback (Updated May 2021)
May 1, 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 BurtonMultifamily (Apartment) Acquisition Model (Updated Dec 2020)
December 27, 2020/by Spencer BurtonSimple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2020)
December 22, 2020/by Spencer BurtonWatch Me Build – IRR Partitioning in Excel
September 16, 2020/by Spencer BurtonReal Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020)
August 26, 2020/by Michael BelascoMultifamily Redevelopment Model (Updated June 2020)
June 27, 2020/by Michael BelascoWatch 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 BurtonWatch Me Build A Construction Draw Schedule (Updated Jan 2020)
January 25, 2020/by Michael BelascoHow 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 BurtonHotel Acquisition Model – The Basic Model (Updated 10.9.2019)
October 9, 2019/by Michael Belasco30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights
August 7, 2019/by Michael BelascoTutorials 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 Burton3-Tiered Acquisition Debt Module
February 26, 2019/by Michael BelascoQuick 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 BelascoBack-of-the-Envelope Office, Retail, Industrial Acquisition Model (Updated 10.1.2018)
October 1, 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.