Excel Tips

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

real estate financial modeling courses

, , ,

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

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

How to Run Monte Carlo Simulations in Excel

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
, , , , , ,

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated August 2019)

As I've mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other's methods, the more adept a real estate…
, , , , ,

Tutorials For The Hotel Valuation Model (Updated 07.23.19)

Welcome to the A.CRE Hotel Valuation Model's Tutorial Page. On this page you will find all the tutorials for the A.CRE Hotel Valuation model in Excel. There is a lot to learn within this model and over time, I'd like to show you both how to…
, , , ,

Using the Floating Summary Box in Real Estate Modeling

Over the next few minutes, I'll share a great modeling tip for efficiently visualizing the more salient metrics in your real estate models. Now I should mention, this is a tip I shared a few years ago. But given the complexity of many of the…
, , , , , , , ,

Watch Me Build a Dynamic Mortgage Amortization Table in Excel

There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you…
, , , ,

Using the OFFSET Function in Real Estate Financial Modeling

In a previous post, I showed you how to use the OFFSET function to create dynamic lists in Excel. As you become more comfortable using this function in real estate financial modeling, you'll find that it has almost infinite applications when…
, ,

A.CRE 101 – Create Smart Drop-Down Menus in Real Estate Modeling

One Excel feature real estate financial modeling professionals use often is the data validation list. Where data validation is a method of limiting the possible inputs of a cell, the data validation list limits those inputs to a pre-defined…
, , ,

Create a Dynamic Real Estate Chart in Excel

Most of the real estate financial models we've shared over the years are dynamic to analysis period. Meaning, we've included an input to adjust the length of the analysis period, and the model will adjust the results accordingly. This is…
,

A Few Indispensable Keyboard Shortcuts for Moving Quickly Around Excel

The more time you spend modeling real estate in Excel, the more important keyboard shortcuts become. It's partly about speed - using keyboard shortcuts is much faster than using the mouse. But it's also about impressing your peers; whether you…
,

Excel Speed Tip – Insert or Delete a Row or Column Without a Mouse

Using keyboard shortcuts is essential to improving the speed and efficiency at which you model real estate in Excel. One thing you'll learn early in your CRE career, the more proficient you become in using your keyboard without a mouse to navigate…
, , , , ,

Deep Dive: The IRR and XIRR – Fully and Simply Explained (Part 2)

Part 2: The XIRR (Click here for Part 1 where we cover the IRR) This is Part 2 of our A.CRE Deep Dive - 2-part mini-series on the IRR and XIRR return metrics and functions in Excel. As stated in Part 1, these are some of the most commonly…
, , , , ,

Deep Dive: The IRR and XIRR – Fully and Simply Explained

For my next post, I thought I would bring it back to some fundamentals and review the IRR and XIRR return metrics and functions in Excel. These are some of the most commonly used functions and return metrics in commercial real estate and they…
, , , ,

A.CRE 101: How To Use The Discounted Cash Flow (DCF) Method To Value Income Producing Property

The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used…