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

Using an IRR Matrix to Determine Hold Period (Updated Dec 2023)

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
, , , , , , , , , , ,

Actual + Forecast Construction Draw Schedule with S-Curve (Updated Dec 2023)

Several times in the last month, I've been asked to tackle an interesting real estate financial modeling challenge - pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw…
, , , ,

Set Your New Year’s Resolutions Using Our Custom GPT

As we approach the end of the year, it's a time many of us pause to reflect and plan for the future. In my own career, I've always found the transition into a new year to be a prime opportunity for setting ambitious yet achievable goals. This…
, ,

Introducing Weighted Equity Multiple: An Alternative for Dynamic CRE Investments

Across a 22+ year career in the industry, I've encountered a range of complex scenarios that traditional metrics sometimes struggle to accurately capture. A case in point that has been top of mind for me recently is a weakness in the Equity…
, , ,

Refinance Risk Analysis Tool in Excel (Updated Nov 2023)

Generally speaking, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the downside. Equity investors generally focus on an investment's internal rate of return, cash-on-cash…
, , , ,

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

Using ChatGPT as a Real Estate Analyst – Sales Comp Analysis (Updated Aug 2023)

In early 2023, we here at A.CRE began exploring use cases for AI in commercial real estate. Since that time, we have released nine such posts covering topics such as using AI in the real estate job search, using AI to expand on Excel's capabilities,…
, , , , , ,

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

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

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…