Real Estate Financial Modeling

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Oct 2021)

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

Industrial Real Estate Development Model (Updated Oct 2021)

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…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Aug 2021)

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 Apartment Development Model (Updated Oct 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…
, , , , , , , , , , , ,

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

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

Linear Mortgage Payment Schedule Tool

We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…
,

Introducing the New (Beta) Learning Platform for the Accelerator Program

In 2018, Michael and I designed and built the A.CRE Accelerator program. We sought to build the preeminent tool for learning and mastering real estate financial modeling. It was intended to provide a clear path to real estate financial modeling…
, , , , , ,

S-Curve Forecasting in Real Estate Development (Updated Sep 2021)

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…
bite-sized real estate tutorials
, , ,

Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we've started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks…
, , , , ,

A.CRE Value-Add Apartment Acquisition Model (Updated Sep 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…
, , , ,

Self Storage Acquisition Model (Updated Sep 2021)

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

Pro Forma For Multifamily Renovation (Updated 9.7.2021)

I'm excited to share the Pro Forma for Multifamily Renovation model with all of you. This multifamily renovation model is made to analyze value add apartment acquisition opportunities and has a lot of functionality that is meant to provide you…
, , ,

Real Estate Equity Waterfall Model – IRR and Equity Multiple Hurdles (Updated Sep 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…
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 Sep 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…