Real Estate Financial Modeling

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

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,…
adventures in cre real estate modeler creating cash-on-cash return equity waterfall
, , ,

Real Estate Equity Waterfall Model With Cash-on-Cash Return Hurdle (Updated Apr 2021)

Over the years, Michael and I have built and shared numerous real estate equity waterfall models, all multi-tiered and most with internal rate of return (IRR) hurdles. And as our readers have downloaded those models, I've received dozens of…
, , , , , ,

Calculate Residual Land Value in Excel

Here's the scenario. You're a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, "Okay, bring me an offer." How much do…
, , , , ,

Residential Land Development Pro Forma (Updated Apr 2021)

As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash…
, ,

Best Practices in Real Estate Financial Modeling (Updated Mar 2021)

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

Single Family Home Construction Pro Forma for Home Builders (Updated Mar 2021)

I'm often asked to share models centered around residential development and home building. This is an area of real estate I'm completely comfortable in, since I spent the first 10 years of my career in new residential development. Not surprisingly,…
, ,

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

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

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

Refinance Risk Analysis Tool in Excel

Generally speaking, equity real estate investors spend their time modeling the upside while their debt partners spend their time modeling the down side. Equity investors generally focus on an investment's internal rate of return, cash-on-cash…
, , , ,

Self Storage Acquisition Model

I've spent the past few weekends working on a purpose-built Self Storage Acquisition Model, and I'm now happy to share the result of that work with you. This is a model that's been requested by quite a few A.CRE readers over the past few years.…
, , , , , , ,

Using Boolean Logic to Model Multiple Generations of Tenant Improvements

Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas…
, , , , , ,

Mixed-Use Development Model: Condo and Retail (Updated Feb 2021)

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

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

Condominium Development Model (Updated Feb 2021)

After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium…
, , ,

Real Estate Equity Waterfall Model – Monthly Periods (Updated Jan 2021)

When I decided to share my real estate equity waterfall model in Excel, I never imagined it would be as popular as it has. The model has been downloaded thousands times and many of you have written to extend your thanks for sharing. It is gratifying…
,

Create Printable and PDF Reports in Excel for Real Estate Financial Modeling

A common question we've been getting recently is, how do I create printable reports from a real estate financial model in Excel? In this written and video tutorial, I share the three basic steps for creating printable and PDF reports in any…