Real Estate Financial Modeling

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated April 2024)

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

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

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

Using Excel’s New LAMBDA Feature to Create Custom Functions for Real Estate Financial Modeling

In December 2020, Excel rolled out a new featured called LAMBDA as part of the Office Insiders (i.e. beta) program. This feature allows the user to create custom functions, which can greatly reduce duplicative formulas and reduce errors. Well…
, , , ,

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

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

DateDif: The “Secret” Excel Formula (Updated 11.14.2020)

For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…
, , , , , , ,

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

Announcing the New A.CRE Help Section

At A.CRE, we receive thousands of emails every month from our readers, users of our financial models, and our Accelerator members. The topics of those emails range from career advice, consulting requests, and questions about the Accelerator,…
, , , , , ,

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

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

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 mastering real estate financial modeling. The Stones Hotel puts you in the position of an associate at a…
, , , ,

Making the Masters in Real Estate Decision

This topic has come up on Adventures in CRE various times over the years. I first blogged about my decision to pursue a Masters in Real Estate over an MBA five years ago. And last year Michael, discussed his thought process around getting dual…
, , , , ,

Multifamily Redevelopment Model (Updated June 2020)

This is an Excel model I originally built from scratch back in 2015 for quickly assessing multifamily redevelopment opportunities. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times.…
, , , ,

The “Secret” to Learning Real Estate Financial Modeling

Just like any skill in life, there are tips and tricks to learning that skill. Some suggestions are more helpful than others, although all contribute in some way. In this episode, we share one of the more valuable tips - what our marketing team…