Real Estate Financial Modeling

All | Argus| Excel Models | Excel TipsStochastic Modeling
Click to Browse the Library of Excel Models

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Sep 2022)

Prior to launching the Accelerator program, Michael and I fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling…
, , , , ,

Using an IRR Matrix to Determine Hold Period (Updated Sep 2022)

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Sep 2022)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , , , , ,

A.CRE Hotel Valuation Model in Excel (Updated Sept 2022)

I am excited to introduce our new Hotel Valuation (Acquisition) Model to underwrite both stabilized and value-add hotel opportunities. This hotel pro forma is designed to allow users to do everything from a quick back of the envelope exercise…
, ,

A.CRE Real Estate Financial Models Download Guide

Since I started working with A.CRE, I wanted to find a way to easily find the different models, modules, tools, and tutorials the guys have shared from the Library of Excel Real Estate Financial Models. After some time helping out our readers…
, , , ,

A.CRE Apartment Development Model (Updated Aug 2022)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, , , ,

A.CRE Self Storage Development Model (Updated Aug 2022)

We've received numerous requests over the years for a Self Storage Development Model in Excel. With strong investment and development activity in this niche property type, I recognize a self storage model on A.CRE is long overdue. But with so…
, , , ,

Real Estate Portfolio Valuation Model (Updated Aug 2022)

I built, and would like to share, a real estate portfolio model for valuing a portfolio of up to 30 properties. This is a "roll-up" model, meaning you will need to model your unlevered (before financing) property-level cash flows in a separate…
, , , ,

Self Storage Acquisition Model (Updated Aug 2022)

I've spent the past few weekends working on a purpose-built Self Storage Acquisition Model, and I'm now happy to share the result of that work with you. This is a model that's been requested by quite a few A.CRE readers over the past few years.…
Confidentiality Agreement Signing
, , , , ,

Real Estate Confidentiality Agreement

In this article and video, we are going to walk through a real estate Confidentiality Agreement that is suitable for a listing broker to distribute to a potential purchaser of a commercial multi-family property.  We’ll cover who the parties…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Jul 2022)

We've shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions (e.g. All-in-One, Apartment Valuation Model), but none was built for the express purpose of modeling value-add apartment…
, , ,

The Advanced Mortgage Amortization Module (Updated Jul 2022)

In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…
, , , ,

Retail Real Estate Development Model

I'm excited to share my Retail Development Model in Excel. This pro forma analysis tool comes as I've continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model…
, , , ,

Office Real Estate Development Model (Updated Jul 2022)

I'm excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I've continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model…
, , , ,

Industrial Real Estate Development Model (Updated Jul 2022)

Allow me to share my Industrial Development Model in Excel. Over the past year, I've been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the…
, , , ,

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Jun 2022)

A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn't mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall.…