You are here: / / A.CRE 101 - Basic Concepts in Commercial Real Estate

A.CRE 101 – Basic Concepts in CRE

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

All | Watch Me Build

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated June 2026)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
Analyzing a Financial Model Setup
, ,

8 Considerations When Reviewing a Broker’s Financial Model Setup

Whether you’re an analyst, operating in acquisitions, or working in a different property-related role, it’s essential to have the skills required to qualify an opportunity, which typically includes reviewing a broker’s financial model…
, , ,

The Road To A Stabilized NOI – Underwriting Real Estate Concessions

The incentives offered to the tenants of a real estate property constitute another of the adjustments that real estate professionals must underwrite to achieve a stabilized NOI, but beyond the adjustment, the concessions represent the cost of…
, , , ,

The Road To A Stabilized NOI – Vacancy And Credit Loss In Real Estate Underwriting

Considering the potential vacancy loss as well as tenant default on an income-producing real estate property represents another key underwriting decision that real estate professionals must make when transitioning to a pro forma (Stabilized)…
, , , ,

The Road to Stabilized NOI – Loss to Lease in Multifamily Property Underwriting

The calculation of stabilized Net Operating Income for a property is synonymous with building a stabilized proforma. This modeling process starts by estimating revenues and then the expenses, which means we must adjust the anticipated revenues…
, , , ,

Create Your First AI Tool: Sales Comp Database ChatGPT Plugin

Traditionally in commercial real estate, each organization builds its own proprietary sales comp database and then gives its analysts access to that database in order to perform comp analysis. As AI becomes more and more important, pairing the…
, ,

A.CRE 101: CRE Risk Profiles (Updated May 2023)

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

4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022)

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

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

Watch Me Build – IRR Partitioning in Excel

In this post, I'd like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I've recorded…
, , , ,

The “Secret” to Learning Real Estate Financial Modeling

Just like any skill in life, there are tips and tricks to learning that skill. Some suggestions are more helpful than others, although all contribute in some way. In this episode, we share one of the more valuable tips - what our marketing team…
, , , ,

Watch Me Build – Capital Stack with Mezzanine Debt

One of the more difficult aspects of modeling a real estate development is figuring out how to handle equity and debt cash flows. This becomes all the more difficult when a second tranche of debt is introduced. In this Watch Me Build video,…
, , ,

All You Need to Know About Real Estate Gross-Ups

"Gross-up" clauses have caused confusion, and occasionally consternation, amongst tenants signing commercial leases for the first time. While many tenants are happy to pay for building services they use on a daily basis, many are riled when…
, , , , , , , , ,

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…