, , ,

Real Estate Financial Modeling Accelerator (Updated September 2019)

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

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

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

Tutorials for A.CRE Value-Add Apartment Acquisition Model

As promised, I'm following up the release of the A.CRE Value-Add Apartment Acquisition model with a series of walk-throughs and tutorials to help you better understand the various elements of the model. The tutorials start with the basics -…
, , , , , , , ,

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

Watch Me Solve a REPE Technical Interview Modeling Test

What better way to spend some free time over the Thanksgiving holiday, than to record myself completing a real estate private equity technical interview exercise! While I've offered help with the real estate technical interview in the past,…
, , , , , , , , , , ,

Actual + Forecast Construction Draw Schedule with S-Curve

Several times in the last month, I've been asked to tackle an interesting real estate financial modeling challenge - pare actual construction draw cash flows with s-curve cash flow forecasts to create an Actuals + Forecast Construction Draw…
, , , ,

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

Modeling a Property Tax Abatement in Real Estate

We often field questions around how to model property tax abatements. This is a concept we've addressed in our All-in-One forum and a question around valuing property tax abatements came up recently in our A.CRE Accelerator Advanced Concepts…
, , ,

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

Hold-Sell Analysis in Real Estate

In course 3 of our A.CRE Accelerator, we use a case study that revolves around a hold-sell (i.e. hold vs sell) analysis scenario to teach the anatomy of the real estate DCF. In that scenario, the student is an asset manager working for an open-end…
, , , , , , ,

Using Boolean Logic to Model Multiple Generations of Tenant Improvements

Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas…
, , , , , ,

Watch Me Build: Construction Draw Schedule

The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule.Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic…
, , ,

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

Convert Monthly Cash Flows to Quarterly and Annual Cash Flows

Over the past few years, I've been working to build an ARGUS DCF alternative in Excel - or otherwise known here as the A.CRE All-in-One (Ai1) Model. As I've worked on that model, I've been jotting down modeling techniques I use and think would…