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

RV Park Acquisition Model (Updated May 2023)

Excited to share my RV Park Acquisition Model with you all. This is a model I developed out over the past few months as I've been getting more involved in the space (the development of an RV Park near Olympic National Park is my most investment…
, , , ,

Using OpenAI’s ChatGPT to Build the ‘Excel 4 CRE’ Add-In

This is another post in our growing series on how to use ChatGPT in commercial real estate. In this post, I show you how I used ChatGPT to build an Excel Add-in. For a bit of back story. A.CRE recently set out to create a free Excel add-in…
, , , ,

Single Family Residential Investment Analysis Model (Updated Apr 2023)

Pre-2008, I bought and sold my fair share of single family homes - both for investment purposes (rental or flips) and to live in. In those days, almost everyone was "investing" in residential real estate - hence the market crash. I personally…
, , , , ,

Single Family Rental Proforma (Updated Apr 2023)

With all the continued and growing interest in single family rentals these past few years, I decided to spend some time these past few days diving into building a single family rental proforma. Prior to getting underway, and what we encourage…
, , , ,

Using OpenAI’s ChatGPT to Create Complex Excel Logic

The fourth blog post in this series on how to use ChatGPT in commercial real estate. As real estate financial modeling professionals, we're often tasked with creating complex logic in Excel. Depending on one's Excel proficiency, that task used…
, , , , ,

Student Housing Acquisition Model (Updated Apr 2023)

I've spent a fair amount of my career analyzing privately-owned student housing investments. Nevertheless, I've yet to share a purpose-built, institutional-quality student housing acquisition model. So, I thought I'd take some time and build…
, , , ,

Condominium Development Model (Updated April 2023)

After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium…
, ,

Best Practices in Real Estate Financial Modeling (Updated Mar 2023)

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…
,

Excel Tip: Copy Worksheets between Identical Models (Updated Mar 2023)

From time to time, I come across modeling situations that Excel does not have built-in functionality to address. One particular situation I come across regularly, involves needing to transfer the contents of a worksheet, including all inputs,…
, , ,

Guide to Using ChatGPT for Commercial Real Estate Professionals

As someone who has worked in the commercial real estate industry going on 22 years, I've come to appreciate how important it is to stay on top of the latest trends and technologies. As I've shared my own personal experience using ChatGPT in…
, , , ,

Using OpenAI’s ChatGPT to Research Real Estate Data

The third blog post in this series on how to use ChatGPT in commercial real estate. The first step in real estate underwriting is the collection and aggregation of data or information. That data or information is then process, analyzed, and…
, , , ,

Using OpenAI’s ChatGPT to Create an Excel Macro for a Real Estate Model

At some point in the past few months, you've undoubtedly heard about ChatGPT. It seems everyone is talking about it. But how useful is the tool actually? And in particular, how useful is it to real estate financial modeling professionals? In…
Multifamily Letter of Intent
, , , , ,

Letter of Intent for Multifamily Real Estate

Today we are going to walk through a common first legal document that is presented to the Seller of a multifamily property, the Letter of Intent (LOI). This article will help you understand exactly what to include to write a better Letter of…
, , , ,

Letter of Intent for Commercial Industrial Purchase

Today we are going to walk through what is usually the first legal document that is presented to the seller of an industrial property, the Letter of Intent. This article will help you understand each of the entries to include, as well as the…
, , ,

Learning Real Estate Financial Modeling in Excel

We're often asked by our readers how we learned to be proficient in real estate financial modeling. The question usually arises because the person wants to know how to model real estate in Excel to either land a job in commercial real estate…