You are here: / Real Estate Financial Modeling

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 June 2026)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. 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…
,

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

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

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

Ask a Pro: How to Hire Your Next CRE Attorney

If you are investing in real estate, it's only a question of when and not if you will need a lawyer. However, many clients do not always have significant experience in the past. As a commercial real estate attorney, I'm going to walk through…
, ,

From College to a Job Amidst the COVID-19 Recession

Many A.CRE readers are young professionals and college students trying to navigate the job market in a recession. Finding a job in commercial real estate amidst the craziness of the COVID-19 pandemic can be challenging, especially for those…
, , , ,

Watch Me Build – Capital Stack with Mezzanine Debt

One of the more difficult aspects of modeling a real estate development is figuring out how to handle equity and debt cash flows. This becomes all the more difficult when a second tranche of debt is introduced. In this Watch Me Build video,…
, ,

Multifamily Metrics and Strategies in a Post-COVID World

Commercial real estate is the business of building, leasing, managing and selling space. And the demand for and how that space is used is largely a function of human psychology and behavior. With the human-psyche turned on its head due to COVID-19,…
,

Real Estate Financial Modeling Using Google Sheets

Virtually every real estate firm in the world uses Microsoft Excel to analyze real estate. It's the industry standard and if you work in real estate you better know how to model real estate in Excel. So regardless of whether you love Excel or…
,

Permanently Remove “Update Links” Alert in Real Estate Excel Models

There are few Excel experiences more frustrating than getting that "this workbook contains links to one or more external sources" alert and not being able to find/break the external links causing it. In this tutorial, I teach you five steps…