# Real Estate Financial Modeling

### Real Estate Financial Modeling Accelerator (Updated Jun 2022)

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…

### Supercharge Excel with the WST Macros Add-in

A year ago 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 use in my professional life daily. Well, version 4.4 was recently…

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

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

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

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

### MS Excel Alternative to ARGUS DCF

It is little secret among our readers that I view ARGUS DCF as a necessary evil. On the one hand, it is the industry standard for underwriting real estate. Virtually every broker package for institutional quality deals comes with an ARGUS run,…

### How to Use My Real Estate Equity Waterfall Model

I took a few minutes this weekend, and created a video to help you use my real estate equity waterfall (IRR hurdle technique) model that I built in Excel. Again, keep in mind that the model is not standalone, but can be used with any of the…

### Update to Portfolio Acquisition Model

I've updated my Portfolio Acquisition Model to include the following changes: - Added an "Investor Level Returns" tab to the model, which uses my Real Estate Equity Waterfall Model to calculate the equity returns of the sponsor (GP) and the…

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

### Free ARGUS DCF Training

UPDATE: ARGUS stopped selling ARGUS DCF at the end of 2015 and will stop supporting the software all together in 2017. The company no longer offers public training for DCF. You'll also note that the YouTube video tutorial for DCF has been taken…