Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling
Click to Browse the Library of Excel Models

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated April 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…
, , , ,

Loan Payment Schedule and Balance Tracking Tool (Updated Oct 2022)

A childhood friend called me this week and asked for a favor. He is the lender on a private real estate loan and was wanting a way to personally service the loan. Namely, he needed a tool to issue monthly invoices, track the principal vs interest…
, , , , , ,

A.CRE Hotel Valuation Model in Excel (Updated Sept 2022)

I am excited to introduce our new Hotel Valuation (Acquisition) Model to underwrite both stabilized and value-add hotel opportunities. This hotel pro forma is designed to allow users to do everything from a quick back of the envelope exercise…
, , , ,

Real Estate Portfolio Valuation Model (Updated Aug 2022)

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…
Confidentiality Agreement Signing
, , , , ,

Real Estate Confidentiality Agreement

In this article and video, we are going to walk through a real estate Confidentiality Agreement that is suitable for a listing broker to distribute to a potential purchaser of a commercial multi-family property.  We’ll cover who the parties…
, , ,

The Advanced Mortgage Amortization Module (Updated Jul 2022)

In recent months, I've been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360),…
, , , ,

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Jun 2022)

A few years ago, I recorded my screen as I built a 3-tier real estate equity waterfall model. What I didn't mention in that Watch Me Build video, is that the kind of waterfall I built is colloquially called a European-style equity waterfall.…
a shopping center with robust sales and low occupancy cost
, , , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting (UPDATED JUNE 2022)

When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you're buying are; or in other words,…
, , , , ,

Publicly Traded Tenant Analysis Tool (Updated May 2022)

In this post and corresponding video, I am going to walk you through a revamped tenant health worksheet that I shared a long time ago on the site. I spent some time giving it a makeover and decided to put together a video walkthrough for it. Publicly…
, , , , , , , , ,

Forecasting After-Tax Cash Flow in Real Estate Analysis (Updated May 2022)

When modeling real estate investments, industry practice is generally to stop at before-tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily have…
, , , ,

Scenario Analysis Tool using the Equity Waterfall Model (UPDATED MAY 2022)

I received a question this morning asking how to use scenario (or sensitivity) analysis with our Real Estate Equity Waterfall Model. I started to answer the question via email, decided to build an Excel file to go along with my answer, and ultimately…
, , , ,

Real Estate Debt Module in Excel (Updated May 2022)

I thought I'd share the real estate debt module I built for the ARGUS alternative in Excel that I've been working on over the last few months. Most debt modules I've seen in real estate financial models only include the ability to model…
, , , ,

Real Estate Capital Account Tracking Tool (UPDATED MAY 2022)

I'll be the first to admit that real estate asset management doesn't get the attention it deserves on AdventuresinCRE.com. The real reason for this is that we're not necessarily asset management experts. I spent some time working in asset management…
, , , , , , ,

Physical Occupancy Calculation Model for Real Estate (UPDATED MAY 2022)

As many of you know, I'm in the midst of moving my family from Milwaukee to Dallas, and quite frankly I'm getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel (UPDATED MAY 2022)

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…
, , , , , , , ,

4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022)

Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a 'Watch Me Build' template and companion video…