Excel Tips

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated July 2020)

Since starting A.CRE, Michael and I have fielded email after email requesting a more structured real estate financial modeling training program on the site. Important Note: We're updating and adding to the Accelerator every week. Since launch,…
bite-sized real estate tutorials
, , ,

Bite-Sized CRE Lessons – A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we've started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks…
,

Permanently Remove “Update Links” Alert in Real Estate Excel Models

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

Roll Up Your Monthly Cash Flow Line Items Into Annual Periods Using Only One Formula For The Whole Sheet

While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate…
, , , , , , ,

Watch Me Build a Residential Land Development Model

Over the years, we've created a sizable library of Watch Me Build videos covering Excel models for various real estate investment and property types. However, we've yet to create a Watch Me Build involving for-sale product. So this weekend,…
, ,

Best Practices in Real Estate Financial Modeling

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…