Real Estate Financial Modeling

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

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Dec 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…
, , , , , ,

The Definitive Guide to Microsoft Excel for Real Estate (Updated Dec 2021)

Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition.…
, , , ,

A.CRE Apartment Development Model (Updated Dec 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…
, , , , ,

Land Development Model – Multi-Scenario (Updated Dec 2021)

Over the years, we've shared eight development-focused real estate financial models and numerous development-specific tools to the A.CRE Library of Excel Models. Nevertheless, there's been a hole in the development offerings in our library.…
, ,

Excel Pro Forma for Flipping Houses (Updated Dec 2021)

Before moving to the principal side of the business, I began my career as a self-described real estate investment specialist, largely working as a land broker but dabbling in other areas including the popular "single-family flip" space. In all…
, , , , , ,

Pro Forma For Multifamily Renovation (Updated 11.17.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…
, , , ,

A.CRE Self Storage Development Model (Updated Nov 2021)

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

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

Watch Me Solve a REPE Technical Interview Modeling Test (Updated Nov 2021)

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…
, , , ,

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

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…