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

Hold-Sell Analysis in Real Estate (Updated June 2024)

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end…
, ,

Mastering Return Metrics for Strategic Real Estate Investment Decisions

Return metrics are some of the key components for assessing commercial real estate investments. They give professionals an insight into the potential gains and risks associated with various properties. But which return metrics are most useful…
, , , , ,

Underwriting a Tenant with Private Credit (Updated June 2024)

Recently, we had an Accelerator member ask a question about how to accurately determine a credit rating and spec income discount rate for a private tenant in a single tenant net lease deal. While the scenario specifically involved a medical…
, , ,

Using Generative AI to Outperform Humans at Financial Statement Analysis

Researchers at the University of Chicago recently released the results of an important study that evaluated GPT-4's financial analysis capabilities by predicting future earnings from financial statements. By using Chain-of-Thought (CoT) reasoning,…
IRR and XIRR are different
, , , , ,

Why Your IRR and XIRR are Different (Updated June 2024)

This post was inspired by a question on our real estate financial modeling Accelerator forum. Additionally, Spencer and I frequently get emails asking about this very issue, which is 'why the IRR (internal rate of return) and XIRR (extended…
, , , ,

Case Study #5 – The Jefferson Branded Condo Development – Case Only (Updated June 2024)

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

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property (Updated May 2024)

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…
, , , , ,

Quick Thoughts on Evaluating Real Estate Investments Without Opening Excel

In our industry (commercial real estate), the ability to quickly evaluate investment opportunities is crucial for staying competitive. I know I've found in my professional career, that having a clear framework for evaluating - and then either…
after-tax cash flow analysis
, , , , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2024)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow, rather than after-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and…
, , , , ,

Case Study #4 – The Stones Hotel Acquisition – Case Only (Updated May 2024)

This case study on hotel acquisition is the fourth in a series shared by A.CRE, designed to enhance your skills in real estate financial modeling. In this scenario, you take on the role of an associate at a prominent firm specializing in debt…
, , , , ,

Single Tenant Net Lease Valuation Model – Custom GPT by A.CRE

At A.CRE, we've built dozens of custom GPTs for internal and external purposes. Some of the GPTs have general application, while others are custom GPTs specifically for commercial real estate. And among those custom GPTs specifically for CRE,…
, , ,

Advanced Mortgage Amortization Module (Updated May 2024)

In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…
, , ,

What are Custom GPTs? Plus a few examples we’ve built. (Updated May 2024)

In the fast-moving world of generative AI (gen AI), staying up to date on the latest advancements in AI is crucial for professionals in every field, but especially in commercial real estate. At A.CRE, we're committed to sharing what we view…
, , , , ,

Real Estate Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…
iming of Preferred Return vs Return of Capital
, , , ,

Timing of Preferred Return vs Return of Capital in an Equity Waterfall with IRR Hurdles (Updated May 2024)

Recently, we had an A.CRE reader ask us about the mechanics of Preferred Return distributions in our equity waterfall models with IRR hurdles. Specifically, he questioned the timing of when and how Preferred Return vs Return of Capital were…