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 2021)

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

Watch Me Build A Construction Draw Schedule (Updated Jan 2020)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Basic Construction Financing &…
, ,

Using SUMPRODUCT to Calculate Weighted Average in Real Estate

In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and…
, , , ,

Watch Me Expand the Home Construction Pro Forma

I'm regularly asked to expand my single family home construction pro forma to analyze the construction of more than one home. I've contemplated adding that functionality to the model, but it is such a custom task that no template could really…
, , ,

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

Analyzing a Real Estate Investment from the Perspective of an LP

We received a question from an A.CRE reader this week that I thought warranted a thorough response. The question was, and I paraphrase, "I am an LP looking for models to help vet syndication deals. Do you have any models that can be used…
, , , ,

How to Prepare for the Real Estate Technical Interview

So you've made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They've asked…
, , , , ,

Roll Up Your Monthly Cash Flow Line Items Into Annual Periods Using Only One Formula For The Whole Sheet

While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate…
, , , , , , ,

Watch Me Build a Residential Land Development Model

Over the years, we've created a sizable library of Watch Me Build videos covering Excel models for various real estate investment and property types. However, we've yet to create a Watch Me Build involving for-sale product. So this weekend,…
, , ,

A.CRE Flashcard Series – Sharpen Your Vocabulary (Updated 09.25.19)

As Spencer and I continue to flesh out the Adventures in CRE Glossary of Commercial Real Estate Terms, we thought it would be fun and useful to provide some of our readers who are just starting out in the industry with some practice flashcards.…
, , , , , ,

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

30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file) Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals…
, , , , , , , ,

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…