Excel Tips

Real Estate Financial Modeling Accelerator (Updated Jan 2023)

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…

Create Printable and PDF Reports in Excel for Real Estate Financial Modeling

A common question we've been getting recently is, how do I create printable reports from a real estate financial model in Excel? In this written and video tutorial, I share the three basic steps for creating printable and PDF reports in any…

Using Excel’s New LAMBDA Feature to Create Custom Functions for Real Estate Financial Modeling

In December 2020, Excel rolled out a new featured called LAMBDA as part of the Office Insiders (i.e. beta) program. This feature allows the user to create custom functions, which can greatly reduce duplicative formulas and reduce errors. Well…

DateDif: The “Secret” Excel Formula (Updated 11.14.2020)

For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…

Watch Me Build – IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…

There are few Excel experiences more frustrating than getting that "this workbook contains links to one or more external sources" alert and not being able to find/break the external links causing it. In this tutorial, I teach you five steps…

Excel Tips: Index Match Match

In this post, I'm going to go over Index Match Match, which is a very useful Excel formula that is used in both the Hotel Valuation Model and the Hotel Acquisition Model - The Basic Model.  This formula allows you to hone in on a specific target…

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…

Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020)

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…

Create Dynamic Sub-Property Type Drop-Down Menus in Excel

A few years ago, I created a tutorial on building smart drop-down menus in Excel using dynamic named ranges and data validation lists. This offered a great way to have drop-down menus in your model that could be easily changed by the user to…

Using VBA to Hide Rows in Excel

Over the next few minutes, I will show you two techniques for automatically hiding and showing rows in Excel using VBA code. These techniques I use regularly in my real estate financial models to make for a more intuitive user experience. In…

Watch Me Build Data Tables For Real Estate Sensitivity Analysis

This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I'll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I'll walk…

Using SUMPRODUCT to Calculate Weighted Average in Real Estate

In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and…

How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel

Creating intuitive, user-friendly, visually appealing models is one aspect of mastering real estate financial modeling. One way to make your models easy for people to use and more attractive in general is to use dynamic, theme-appropriate, in-cell…

Using Conditional Formatting in Real Estate Financial Modeling

Your real estate financial models are only as good as their ability to be used by others. Or in other words, if others can't figure out how to use your model, it isn't worth much! So when building real estate financial model templates, besides…

How to Prepare for the Real Estate Technical Interview

So you've made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They've asked…