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 Sept 2020)

Since starting A.CRE, Michael and I have 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 topics in our blog,…
Real Estate IRR Partitioning
, , , , , , ,

Watch Me Build – IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…
, , , ,

A.CRE Self Storage Development Model (Updated Sept 2020)

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…
, , , , , ,

S-Curve Forecasting in Real Estate Development (Updated Sept 2020)

One of the reasons Mike and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR…
, , , , ,

Apartment Acquisition Model with Monte Carlo Simulation Module (Updated Sept 2020)

We have a few stochastic modeling tools for real estate on the website, but none as robust as this Apartment Acquisition Model with Monte Carlo Simulation Module. I originally built the model in 2016 by taking my standard apartment acquisition…
, , , , , ,

Real Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020)

I've decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved…
, , , ,

Setting Up a New Real Estate Financial Model – Date and Period Headers Plus Formatting

We've spent a lot of time here discussing and sharing different real estate models, and we've received a ton of feedback from our readers as a result. In some of that feedback we've received, several people have asked what period and date rows…
, , ,

The Advanced Mortgage Amortization Module

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),…
, , , ,

A.CRE Apartment Development Model (Updated Aug 2020)

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…
, , , ,

Watch Me Build – American-Style Real Estate Equity Waterfall

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.…
, , ,

Real Estate Equity Waterfall Model with Catch Up and Clawback (Updated Aug 2020)

A question came up recently in the A.CRE Accelerator's real estate waterfall modeling course regarding how to model GP Catch Up (i.e. Sponsor Catch Up) and LP Clawback provisions. I put together a quick video tutorial in response to that question,…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated July 2020)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016…
, , , ,

Real Estate Portfolio Valuation Model (Updated Jul 2020)

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…
, , , ,

Case Study #5 – The Jefferson Branded Condo Development (Case Only)

This is the fifth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Jefferson Branded Condo Development puts you in the position…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Jul 2020)

Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I've received dozens of…
, , , ,

Case Study #4 – The Stones Hotel – Acquisition (Case Only)

This is the fourth in a series of commercial real estate case studies shared by A.CRE. These case studies are meant to help you practice to master real estate financial modeling. The Stones Hotel puts you in the position of an associate at a…