Library of Real Estate Excel Models
Browse the Entire LibraryDownload the All-in-One ModelThe world’s largest library of readily accessible real estate Excel models
LIBRARY OF REAL ESTATE EXCEL MODELS
The world’s largest library of readily accessible real estate Excel models
All 128
All 128 /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 15 /Office 12 /Retail 13 /Industrial 13 /Single Family 8 /Tutorial 45 /Equity Waterfall 14 /Modules 37 /Excel Add-ins 9 /Graduate 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 23 /Standalone 32 /Acquisition 27 /Value-Add 16 /Debt 11 /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 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 1 /Season 3 0
A.CRE Apartment Development Model (Updated Dec 2021)
December 8, 2021/by Spencer BurtonLand Development Model – Multi-Scenario (Updated Dec 2021)
December 5, 2021/by Spencer BurtonExcel Pro Forma for Flipping Houses (Updated Dec 2021)
December 1, 2021/by Spencer BurtonPro Forma For Multifamily Renovation (Updated 11.17.2021)
November 17, 2021/by Michael BelascoA.CRE Self Storage Development Model (Updated Nov 2021)
November 13, 2021/by Spencer BurtonA.CRE Value-Add Apartment Acquisition Model (Updated Nov 2021)
November 9, 2021/by Spencer BurtonWatch Me Solve a REPE Technical Interview Modeling Test (Updated Nov 2021)
November 9, 2021/by Spencer BurtonIndustrial Real Estate Development Model (Updated Oct 2021)
October 24, 2021/by Spencer BurtonConstruction Draw and Interest Calculation Model (Updated Aug 2021)
October 19, 2021/by Spencer BurtonAll-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated Oct 2021)
October 13, 2021/by Spencer BurtonLinear Mortgage Payment Schedule Tool
October 6, 2021/by Spencer BurtonS-Curve Forecasting in Real Estate Development (Updated Sep 2021)
September 30, 2021/by Spencer BurtonSelf Storage Acquisition Model (Updated Sep 2021)
September 10, 2021/by Spencer BurtonReal Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Sep 2021)
September 7, 2021/by Spencer BurtonReal Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Sep 2021)
September 3, 2021/by Spencer BurtonSingle Family Residential Investment Analysis Model (Updated Aug 2021)
August 17, 2021/by Spencer BurtonHotel Development Model (Updated 8.16.2021)
August 16, 2021/by Michael BelascoA.CRE Hotel Valuation Model in Excel (Updated 08.6.21)
August 6, 2021/by Michael BelascoReal Estate Equity Waterfall Model – Monthly Periods (Updated Jul 2021)
July 27, 2021/by Spencer BurtonWatch Me Build – Custom Rent Schedule Module
July 22, 2021/by Spencer BurtonA.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jul 2021)
July 14, 2021/by Spencer BurtonCommercial Mortgage Loan Analysis Model (Updated Jul 2021)
July 11, 2021/by Spencer BurtonCustom Function to Auto-Populate Latitude and Longitude in Excel (Updated 2021)
July 3, 2021/by Spencer BurtonDeep Dive – Land Acquisition and Assemblage
June 23, 2021/by Spencer BurtonReal Estate Sources and Uses of Capital Module
June 9, 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 BurtonCalculate Residual Land Value in Excel
April 8, 2021/by Spencer BurtonResidential Land Development Pro Forma (Updated Apr 2021)
April 2, 2021/by Spencer BurtonSingle Family Home Construction Pro Forma for Home Builders (Updated Mar 2021)
March 26, 2021/by Spencer BurtonRefinance Risk Analysis Tool in Excel
March 10, 2021/by Spencer BurtonUsing Boolean Logic to Model Multiple Generations of Tenant Improvements
February 26, 2021/by Spencer BurtonMixed-Use Development Model: Condo and Retail (Updated Feb 2021)
February 21, 2021/by Michael BelascoTutorials for the A.CRE Apartment Development Model
February 11, 2021/by Spencer BurtonCondominium Development Model (Updated Feb 2021)
February 3, 2021/by Michael BelascoReal 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 BurtonSingle Tenant NNN Lease Valuation Model (Updated Dec 2020)
December 16, 2020/by Spencer BurtonUsing an IRR Matrix to Determine Hold Period
November 19, 2020/by Spencer BurtonForecasting After-Tax Cash Flow in Real Estate Analysis
October 11, 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 BelascoSetting Up a New Real Estate Financial Model – Date and Period Headers Plus Formatting
August 21, 2020/by Spencer BurtonThe Advanced Mortgage Amortization Module
August 12, 2020/by Spencer BurtonWatch Me Build – American-Style Real Estate Equity Waterfall
August 5, 2020/by Spencer BurtonReal Estate Portfolio Valuation Model (Updated Jul 2020)
July 21, 2020/by Spencer BurtonCase Study #5 – The Jefferson Branded Condo Development (Case Only)
July 20, 2020/by A.CRECase Study #4 – The Stones Hotel – Acquisition (Case Only)
July 14, 2020/by A.CREMultifamily Redevelopment Model (Updated June 2020)
June 27, 2020/by Michael BelascoActual + Forecast Construction Draw Schedule with S-Curve
May 14, 2020/by Spencer BurtonWatch Me Build – Capital Stack with Mezzanine Debt
May 4, 2020/by Spencer BurtonWhy Your IRR and XIRR are Different
May 3, 2020/by Michael BelascoWatch Me Build a Tenant Rollover Analysis Model
March 27, 2020/by Spencer BurtonGround Lease Valuation Model
March 21, 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 BelascoWatch Me Build a Residential Land Development Model
October 5, 2019/by Spencer BurtonHow to Run Monte Carlo Simulations in Excel
September 2, 2019/by Spencer BurtonWatch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated August 2019)
August 21, 2019/by Spencer Burton30/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 BurtonWatch Me Build a Dynamic Mortgage Amortization Table in Excel
June 15, 2019/by Spencer BurtonUsing the OFFSET Function in Real Estate Financial Modeling
May 11, 2019/by Spencer BurtonModeling a Property Tax Abatement in Real Estate
April 25, 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 BelascoHold-Sell Analysis in Real Estate
February 18, 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 BurtonLoan Payment Schedule and Balance Tracking Tool
December 19, 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 BurtonDevelopment Draw Schedule – Visually Customize Each Line Item
March 25, 2018/by Michael BelascoConvert Monthly Cash Flows to Quarterly and Annual Cash Flows
March 4, 2018/by Spencer Burton4-Tier Equity Multiple Waterfall – Download and Watch Me Build
January 14, 2018/by Michael Belasco1031 Exchange – Introduction, Overview, and Analysis Tool
January 12, 2018/by Michael BelascoAll-in-One (Ai1) Walkthrough #10 – Underwriting a Value-Add Office Investment
October 4, 2017/by Spencer BurtonA.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property
September 9, 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 BurtonConstruction Draw Schedule: Accounting For True LTC
January 29, 2017/by Michael BelascoTenant Sales and Occupancy Cost in Retail Underwriting
January 21, 2017/by Spencer BurtonVersion Notes: All-in-One Underwriting Model
January 1, 2017/by Spencer BurtonReal Estate Development Tracker
November 6, 2016/by Michael BelascoPhysical Occupancy Calculation Model for Real Estate
August 6, 2016/by Spencer BurtonReal Estate Capital Account Tracking Tool
June 11, 2016/by Spencer BurtonCreate A Dynamic Revenue Row to Calculate Multiple Tenant Leases
March 23, 2016/by Michael BelascoHide and Unhide Tabs using Drop-down Menus in Excel
February 24, 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 BelascoReal Estate Debt Module in Excel
February 6, 2016/by Spencer BurtonSupercharge Excel with the WST Macros Add-in
January 2, 2016/by Spencer BurtonHow to Use the Construction Draw and Interest Calculation Model
December 24, 2015/by Spencer BurtonThe Circuit Breaker – How to Fix Circular Reference Errors in Excel
December 19, 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 BurtonScenario Analysis using the Equity Waterfall Model
October 10, 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 BurtonWall St. Training – Free Excel Resources
January 28, 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.