, , ,

Real Estate Financial Modeling Accelerator (Enrollment Open)

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.Over the years, we've covered hundreds of real estate modeling topics in our blog,…
, , , , , , , , , , ,

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

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

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

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

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

4-Tier Equity Multiple Waterfall - Download and Watch Me Build

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a 'Watch Me Build' template and companion video…
, , , , , ,

Watch Me Build a 3-Tier Real Estate Equity Waterfall Model with IRR Hurdles

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

A.CRE 101: Watch Me Build a 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 create…
real estate professional using the income approach, a financial tool to value income producing property
, , , , ,

A.CRE 101: How to Use the Income Capitalization Approach to Value Income-Producing Property

In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes…