You are here: / / Excel Models

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

Advanced Mortgage Amortization Schedule – 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. One such CRE-specific GPT that we recently built…
, , , , , ,

Multifamily Development Model (Updated April 2024)

Not to be confused with Spencer's masterpiece, The A.CRE Apartment Development Model, I decided to build a second option on our website for multifamily development with a different feel. For us true modeling nerds out there, we know that financial…
Sources and Uses
, , , ,

Construction Draw and Interest Calculation Model (Updated Feb 2024)

I originally uploaded this equity/construction loan draw and interest calculation tool to our library of real estate financial analysis models in 2016. Over the years, I've continued to update it as suggestions, comments, and requests…
, , , , ,

Real Estate Sources and Uses of Capital Module (Updated Feb 2024)

An important component in any acquisition, development, and value-add model is the Sources and Uses of Capital section. Of course, how the sources and uses are modeled and how those cash flows are visualized will vary from one model to the next.…
, , , ,

Real Estate Development Tracker (Updated Feb 2024)

One of the many challenges of both analyzing real estate development deals and managing development projects is understanding and tracking the numerous differing but intertwining work streams. The more a development team takes the time…
, , , ,

Hotel Development Model (Updated February 2024)

Excited to share the new A.CRE Hotel Development Model with everyone. As evidenced by the numerous requests we have gotten for this over the years, this model is long overdue so I'm quite happy to get it out there finally. At the core, the…
, , , , ,

RV Park Development Model (Initial Release)

Created to underwrite one of my projects, RV@Olympic, the RV Park Development Model is something I built and have been working with frequently over the past year. What’s especially unique about this model is that the template you are getting…
, , , , , , ,

Modeling a Property Tax Abatement in Real Estate (Updated Jan 2024)

We often field questions about how to model property tax abatements. It's a concept we cover in our the 'Advanced Modeling - Property and Portfolio' endorsement in our Accelerator real estate financial modeling training program and something…
, , ,

A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jan 2024)

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating…
, , , , ,

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

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

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…