Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling
Click to Browse the Library of Excel Models

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

Mixed-Use Development Model: Condo and Retail (Updated Oct 2023)

In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and…
, , , ,

1031 Exchange – Overview and Analysis Tool

A 1031 Exchange, or Like-kind Exchange, is a strategy in which a real estate investor can defer both capital gains tax and depreciation recapture tax upon the sale of a property and use that money, which has not been taxed, to purchase a like-kind…
, , , ,

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

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

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

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

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

Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases (Updated Nov 2022)

I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good…
, , ,

Linear Mortgage Payment Schedule Tool (Updated Oct 2022)

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