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 (Updated June 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 regularly updating and adding to the Accelerator. Since launch,…
, , , , , , , ,

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

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

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