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

Commercial Real Estate Lease Analysis Tool (Updated Jul 2023)

The topic of analyzing commercial real estate leases from the perspective of the landlord and/or tenant has come up several times over the years. And while I generally respond to requests for new models or tools at A.CRE, I've been hesitant…
, , , , , ,

Calculate Residual Land Value in Excel (Updated Jul 2023)

Here's the scenario. You're a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, "Okay, bring me an offer." How much do…
, , , ,

The Circuit Breaker – How to Fix Circular Reference Errors in Excel

If you've spent much time working with elaborate Excel workbooks that rely on iterative calculations to solve formulas with circular logic, you've undoubtedly come across a problem where if you accidently put an erroneous value in an input…
, , , ,

Using ChatGPT to Create Excel Logic #2 – Annual to Monthly Growth

Another post in a growing series on how to use ChatGPT in commercial real estate. In our real estate financial modeling Accelerator program we have a Q&A. Members of the Accelerator ask the A.CRE team questions, and we provide answers. Depending…
, , , ,

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

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…