Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling

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…

Real Estate Financial Modeling, Excel Models, Hotel, Apartment, Office, Retail, Industrial, Tutorial, Modules, Land Development, Development, Condo

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…

General, Real Estate Financial Modeling, Excel Models, Retail, Development, Standalone, Condo

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…

Real Estate Financial Modeling, Excel Models, Development, Standalone, Condo

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…

RE Education, Real Estate Financial Modeling, Excel Models, Hotel, Apartment, Office, Retail, Industrial, Modules, Land Development, Development, Condo

Development Draw Schedule – Visually Customize Each Line Item (UPDATED APR 2022)

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows…

RE Education, Real Estate Financial Modeling, Excel Models, Tutorial, Modules, Investment Analysis, Land Development, Development, Debt, Special Topics

Construction Draw Schedule: Accounting For True LTC (Updated Apr 2022)

When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender will agree to lend to the borrower. So, if a project costs $10MM, and a lender loans…

Excel Models, Apartment, Development, Standalone

Tutorials for the A.CRE Apartment Development Model

As promised, I'm following up the release of the A.CRE Apartment Development model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics - a guide to…

RE Education, Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Modules, Development

S-Curve Forecasting in Real Estate Development (Updated Sep 2021)

One of the reasons Michael and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR…

Real Estate Financial Modeling, Excel Models, Apartment, Development, Standalone, Value-Add

Multifamily Redevelopment Model (Updated June 2020)

This is an Excel model I originally built from scratch back in 2015 for quickly assessing multifamily redevelopment opportunities. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times.…

RE Education, Real Estate Financial Modeling, Excel Models, Tutorial, Modules, Development, Watch Me Build

Watch Me Build A Construction Draw Schedule (Updated Jan 2020)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Are you an Accelerator member? See…

Real Estate Financial Modeling, Excel Models, Equity Waterfall, Development, Standalone, Condo

3 Tiered Waterfall Module Added to the Condo Development Model

After receiving a few requests, I've finally gotten around to adding an equity waterfall module to the Condominium Development Model. This module allows you to model partnership splits up to three tiers using either equity multiple hurdles or…

Real Estate Financial Modeling, Excel Tips, Excel Models, Tutorial, Development

How to Use the Construction Draw and Interest Calculation Model

As promised, I've recorded a tutorial on how to use my construction draw and interest calculation model. The 20 minute tutorial walks you through how to use the model to forecast construction cash flows during your development period. The model…

RE Education, Real Estate Financial Modeling, Excel Models, Modules, Development

Real Estate Development ROI Models

From time to time, I'm asked to share more complex development models that I've used professional. Unfortunately, most of the models that I've used professionally were built in partnership with others, and so I'm not at liberty to share those…

Real Estate Financial Modeling, Excel Models, Apartment, Development, Standalone

Multifamily Development Model

This is the first in a series of Excel models on adventuresincre.com Here is a basic multifamily development model that I put together. I didn't build this model from scratch, but rather pieced together several other models to arrive at…