Real Estate Financial Modeling

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Apr 2020)

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 updating and adding to the Accelerator every week. Since launch,…
,

Excel Tips: Index Match Match

In this post, I'm going to go over Index Match Match, which is a very useful Excel formula that is used in both the Hotel Valuation Model and the Hotel Acquisition Model - The Basic Model.  This formula allows you to hone in on a specific target…
, , ,

Tutorials for the A.CRE Apartment Development Model

As promised, I'm following up the release of the A.CRE Apartment Development 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 - a guide to…
, , , ,

A.CRE Apartment Development Model (Updated Mar 2020)

For several years now, our library of real estate models has been lacking a robust ground-up apartment development model. Sure, our All-in-One (Ai1) model has the capability to model multifamily development deals, but it's more a generalist…
, , , , , ,

Mixed-Use Development Model: Condo and Retail

In this post, I walk you through the A.CRE Mixed Use Development Model for Condo and Retail projects. The model is basically a reworked and expanded version of the Condo Development Model, so if you are familiar with that, this should feel and…
, , , , , , , , ,

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

Ground Lease Valuation Model

The topic of ground leases has come up several times in the past few weeks. Numerous A.CRE readers have emailed to ask for a purpose-built Ground Lease Valuation Model. And I'm in the process of creating an Advanced Concepts Module for our real…
, , , ,

Multifamily (Apartment) Acquisition Model (Updated Mar 2020)

Our library of real estate Excel models has a variety of decent apartment models, including our All-in-One model and our Apartment Development Model - both robust models in their own right. However, if you're looking for a straight multifamily…
, ,

All-in-One (Ai1) Walkthrough #2 - Office, Retail, Industrial Rent Roll Tab

This walkthrough, our second in the series, will detail how to use the office/retail/industrial rent roll (see ORI-RR Tab). The rent roll tab is arguably the most important, and most complex, tab in the All-in-One model. Below we post a video…
, , , , , , , , , , , ,

All-in-One (Ai1) Model for Underwriting Development and Acquisitions (Updated 3.16.20)

As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016…
, , , ,

Industrial Real Estate Development Model (Updated Mar 2020)

Allow me to share my Industrial Development Model in Excel. Over the past year, I've been working to add more specialty real estate models to our library. While our All-in-One model certainly has its place, oftentimes really digging into the…
, , ,

Real Estate Development Due Diligence Checklist

Last year, I shared a Real Estate Acquisition Due Diligence Checklist that was quite popular. Soon after its release, we began getting requests for a similar tool, but for development deals. So allow me to share a Real Estate Development Due…
, , ,

Commercial Mortgage Loan Analysis Model (Updated Feb 2020)

Over the years, I've received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount…
, , , ,

Real Estate Portfolio Valuation Model (Updated 2.22.2020)

I built, and would like to share, a real estate portfolio model for valuing a portfolio of up to 30 properties. This is a "roll-up" model, meaning you will need to model your unlevered (before financing) property-level cash flows in a separate…