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 (Enrollment Open)

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

A.CRE Apartment Development Model (Updated 5.25.2019)

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

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

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

Actual + Forecast Construction Draw Schedule with S-Curve

Several times in the last month, I've been asked to tackle an interesting real estate financial modeling challenge - pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw…
, , , ,

Using the OFFSET Function in Real Estate Financial Modeling

In a previous post, I showed you how to use the OFFSET function to create dynamic lists in Excel. As you become more comfortable using this function in real estate financial modeling, you'll find that it has almost infinite applications when…
, , , ,

A.CRE Self Storage Development Model (Updated 5.8.2019)

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 Equity Waterfall Model - Monthly Periods (Updated 5.6.2019)

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

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

A few years back, on a sleep 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…
, , , , ,

Tutorials for A.CRE Value-Add Apartment Acquisition Model

As promised, I'm following up the release of the A.CRE Value-Add Apartment Acquisition 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.CRE Value-Add Apartment Acquisition Model (Updated 4.28.19)

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

Modeling a Property Tax Abatement in Real Estate

We often field questions around how to model property tax abatements. This is a concept we've addressed in our All-in-One forum and a question around valuing property tax abatements came up recently in our A.CRE Accelerator Advanced Concepts…
, , ,

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

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

Create a Dynamic Real Estate Chart in Excel

Most of the real estate financial models we've shared over the years are dynamic to analysis period. Meaning, we've included an input to adjust the length of the analysis period, and the model will adjust the results accordingly.This is…
, , , ,

Multifamily (Apartment) Acquisition Model

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

3-Tiered Acquisition Debt Module

This is a 3-tiered debt module that will allow the user to add one to three tiers of debt to his or her real estate DCF model. Includes the option to layer in senior debt, secondary debt, and mezzanine debt; calculate interest on either…
, , , , , , ,

Hold-Sell Analysis in Real Estate

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end…