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 Feb 2021)

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

Mixed-Use Development Model: Condo and Retail (Updated Feb 2021)

In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and…
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 Feb 2021)

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

A.CRE Apartment Development Model (Updated Feb 2021)

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

Tutorials for the A.CRE Apartment Development Model

As promised, I'm following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics - a guide to…
, , ,

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Feb 2021)

Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It's been downloaded thousands of times and we've received…
, , , ,

Condominium Development Model (Updated Feb 2021)

After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium…
, , ,

Real Estate Equity Waterfall Model – Monthly Periods (Updated Jan 2021)

When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying…
, , ,

Real Estate Acquisition Due Diligence Checklist

Most of the Excel tools we share on Adventures in CRE are real estate financial models, but occasionally we'll venture into building other CRE-related tools. Over the past several months, I've been working on a real estate acquisition checklist…
, , ,

Real Estate Development Due Diligence Checklist

Last year, I shared a Real Estate Acquisition Due Diligence Checklist that was quite popular. Soon after its release, we began getting requests for a similar tool, but for development deals. So allow me to share a Real Estate Development Due…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Jan 2021)

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

Apartment Acquisition Model with Monte Carlo Simulation Module (Updated Jan 2021)

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

Multifamily (Apartment) Acquisition Model (Updated Dec 2020)

Our library of real estate Excel models has a variety of decent apartment models, including our All-in-One model and our Apartment Development Model - both robust models in their own right. However, if you're looking for a straight multifamily…
, , , ,

Single Family Home Construction Pro Forma for Home Builders (Updated Dec 2020)

I'm often asked to share models centered around residential development and home building. This is an area of real estate I'm completely comfortable in, since I spent the first 10 years of my career in new residential development. Not surprisingly,…
, , , , , ,

Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2020)

A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I've made various…
, , , , , ,

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

One of the reasons Michael 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…