Real Estate Financial Modeling

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

Real Estate Financial Modeling Accelerator (Updated Nov 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, Development, Standalone

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…

Real Estate Financial Modeling, Excel Models, Equity Waterfall, Development, Standalone, RV Park

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…

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…

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…