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

A Note About The Limitations of Microsoft Excel in Modeling Real Estate

I think its important to point out that my All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition is not a surefire replacement for your non-Excel valuation/underwriting solutions. In fact, it's likely you (or your employer)…
, ,

All-in-One (Ai1) Walkthrough #5 – The Residual Land Value Calculation Module

This walkthrough, our fifth in the series, explains how the Residual Land Value Calculation module works and how to implement this tool into your analysis. You might recall, a few months back we discussed the concept of residual land value…
, ,

All-in-One (Ai1) Walkthrough #4 – The Rate Matrix Module

This walkthrough, our fourth in the series, explains how the Rate Matrix module works and how to implement this tool into your analysis. The rate matrix concept is new to this site, and not commonly used in the industry. Nonetheless, given…
, ,

All-in-One (Ai1) Walkthrough #3 – Modeling a Hypothetical Retail Development Investment

This walkthrough, our third in the series, takes you through the entire process of modeling a simple development investment. I've created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use…

Version Notes: All-in-One Underwriting Model

Version notes for the All-in-One Underwriting Model for Real Estate Development and Acquisition are found here as well as in the 'Version' tab of the Excel model. Download the Model Version 0.3.1 (March 11, 2017) Added version notes…
a gantt chart for real estate built in Excel
,

Bonus Content – Gantt Chart and Weighted Average with Multiple Conditions

I have two updates/improvements to previous posts I thought I'd share with our readers today; call it, bonus content! The first, is a dynamic Gantt Chart tool I recently added to my Construction Draw and Interest Calculation Model. The second,…
,

The Conditional Weighted Average – SUMPRODUCT with SUMIF

Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you,…
, , ,

Supercharge Excel with the WST Macros Add-in

In 2016, I wrote about Wall St. Training and their free Excel modeling resources. In that post, I mentioned the free WST Macros and how it is an indispensable add-in; one that I used in my professional life daily. Unfortunately, as of 2023,…
, , , , , ,

How to Use the Apartment Acquisition Model’s Monte Carlo Simulation Module

You may recall that a couple of weeks ago, I began to explore Stochastic Modeling concepts, or the idea of adding probability into my models, to get a more complete picture of the risk-return metrics of an investment. I became interested in…
, , ,

Waterfall Model For Real Estate Joint Ventures with Catch Up

I've just wrapped up a new JV waterfall model with catch up clause that I am excited to share on the site. This model was built as an addition to my back-of-the envelope retail/industrial/office acquisitions model I posted a few weeks back.…
, , , ,

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

Real Estate Waterfall Model – Equity Multiple Hurdles

I've created a companion to my real estate equity waterfall model to work with equity multiple hurdles, rather than IRR hurdles. It took me longer than I expected to build this, largely because I was over thinking it. I messed around with…
, , ,

Understanding Leases: Office Buildings – Part 2b

Grossing Up Reimbursable Expenses in ARGUS This post and video are a follow up to a post written back in late October discussing grossing up reimbursable expenses. If you haven’t gotten to read that yet, you can do so by clicking here:…
, , , ,

Apartment Valuation Tutorial Using the Real Estate Acquisition Model

I promised a how-to video for my real estate apartment acquisition model, and so I thought I'd use an actual property to do so. I grabbed a property from Loopnet that is currently for sale, and dropped the information from the listing into…
Excel 2016
,

Disable Animations – Excel 2013 (and Presumably in Excel 2016)

If you recently upgraded from Excel 2007 or Excel 2010 to either Excel 2013 or Excel 2016 for Windows, you've probably noticed a change that can be quite distracting (and even annoying!). Microsoft Excel now animates certain actions as you work.…