Real Estate Financial Modeling

All | Argus | All-in-One | Excel Models | Excel Tips | Stochastic Modeling

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2024)

Prior to launching the Accelerator program, Michael and I 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…
, , ,

Using Excel’s New LAMBDA Feature to Create Custom Functions for Real Estate Financial Modeling

In December 2020, Excel rolled out a new featured called LAMBDA as part of the Office Insiders (i.e. beta) program. This feature allows the user to create custom functions, which can greatly reduce duplicative formulas and reduce errors. Well…
, , , ,

Multifamily (Apartment) Acquisition Model (Updated Dec 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…
, , , , , ,

Simple Acquisition Model for Office, Retail, Industrial Properties (Updated Dec 2020)

A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I've made various…
,

DateDif: The “Secret” Excel Formula (Updated 11.14.2020)

For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…
, , , , , , ,

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

Announcing the New A.CRE Help Section

At A.CRE, we receive thousands of emails every month from our readers, users of our financial models, and our Accelerator members. The topics of those emails range from career advice, consulting requests, and questions about the Accelerator,…
, , , , , ,

Real Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020)

I've decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved…
, , , ,

Making the Masters in Real Estate Decision

This topic has come up on Adventures in CRE various times over the years. I first blogged about my decision to pursue a Masters in Real Estate over an MBA five years ago. And last year Michael, discussed his thought process around getting dual…
, , , , ,

Multifamily Redevelopment Model (Updated June 2020)

This is an Excel model I originally built from scratch back in 2015 for quickly assessing multifamily redevelopment opportunities. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times.…
, , , ,

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

Ask a Pro: How to Hire Your Next CRE Attorney

If you are investing in real estate, it's only a question of when and not if you will need a lawyer. However, many clients do not always have significant experience in the past. As a commercial real estate attorney, I'm going to walk through…
, ,

From College to a Job Amidst the COVID-19 Recession

Many A.CRE readers are young professionals and college students trying to navigate the job market in a recession. Finding a job in commercial real estate amidst the craziness of the COVID-19 pandemic can be challenging, especially for those…
, , , ,

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

Multifamily Metrics and Strategies in a Post-COVID World

Commercial real estate is the business of building, leasing, managing and selling space. And the demand for and how that space is used is largely a function of human psychology and behavior. With the human-psyche turned on its head due to COVID-19,…
,

Real Estate Financial Modeling Using Google Sheets

Virtually every real estate firm in the world uses Microsoft Excel to analyze real estate. It's the industry standard and if you work in real estate you better know how to model real estate in Excel. So regardless of whether you love Excel or…