A.CRE 101 – Basic Concepts in CRE

All | A.CRE 101Graduate Education | Special Topics Book Reviews | CRE Terms | Find a Job

All | Watch Me Build

real estate financial modeling courses

, , ,

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

A.CRE 101 - Using Dynamic Data Validation Lists 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…
, , , , , , ,

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,…
real estate modeling
, , ,

Learning Real Estate Financial Modeling in Excel

We're often asked by our readers how we learned to be proficient in real estate financial modeling. The question usually arises because the person wants to know how to model real estate in Excel to either land a job in commercial real estate…
, , , , , ,

Deep Dive - Land Acquisition and Assemblage

This is a topic I'm all too familiar with. You see I cut my teeth in real estate, largely sourcing and negotiating residential and mixed-use land acquisition opportunities.  I've put land deals together both as a fiduciary and as a principal,…
, ,

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

Deep Dive - Sources of Capital: Real Estate Private Equity

Capital for commercial real estate investments is generally sourced from one or more of the following buckets: public equity, public debt, private equity, or private debt. In my experience, few people fully understand these four buckets of capital,…
, , , ,

All About Cap Ex

In this post, we are going to take a deeper look into capital expenditures. What it is and how we account for it in cre underwriting.Capital expenditures, commonly referred to as Cap Ex, are expenses that occur outside of normal operating…
, ,

A.CRE 101: CRE Risk Profiles

In this post we will go into detail about the four CRE risk profiles commonly ascribed to commercial real estate opportunities. In order of least risky to most risky, they are as follows:Core Core Plus Value Add OpportunisticThis…
, , , , , ,

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

Keyboard Shortcuts I Use Constantly When Modeling in Excel (Formatting)

The more you model real estate in Microsoft Excel, the faster and more accurate you become - and hopefully as a consequence the more valuable you become to real estate employers and investors. Part of the process of mastering real estate financial…
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…
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis

I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer,…
, , , , , , , ,

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…