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

Watch Me Solve a REPE Technical Interview Modeling Test (Updated May 2024)

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,…
iming of Preferred Return vs Return of Capital
, , , ,

Timing of Preferred Return vs Return of Capital in an Equity Waterfall with IRR Hurdles (Updated May 2024)

Recently, we had an A.CRE reader ask us about the mechanics of Preferred Return distributions in our equity waterfall models with IRR hurdles. Specifically, he questioned the timing of when and how Preferred Return vs Return of Capital were…
, ,

Nuevo Contenido en Español (Actualizado Mayo 2024)

Ver y leer nuevo contenido en español. Este contenido ha sido creado por el equipo A.CRE para profesionales en la inversion inmobiliaria. Tutoriales, modelos financieros, educación, y mucho más.
, , , , , , , , , , ,

Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024)

In this Watch Me Build video I show you how to build a custom rent schedule module for long-term leases. The foundation of the module is a simple INDEX/MATCH combination that takes a rent schedule and models the rent cash flows across the entire…
, , , ,

Real Estate Capital Account Tracking Tool (Updated Apr 2024)

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

List of A.CRE Accelerator Graduates (Updated May 2024)

This certifies that the following individuals have successfully completed the 17-course, A.CRE real estate financial modeling Accelerator. Having shown a proficiency in all aspects of real estate financial modeling and having demonstrated an…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)

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

Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024)

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

Advanced Mortgage Amortization Schedule – Custom GPT by A.CRE

At A.CRE, we've built dozens of custom GPTs for internal and external purposes. Some of the GPTs have general application, while others are custom GPTs specifically for commercial real estate. One such CRE-specific GPT that we recently built…
, , , , ,

The Definitive Guide to Microsoft Excel for Real Estate (Updated Apr 2024)

Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition.…
, , ,

The Advanced Mortgage Amortization Module (Updated Apr 2024)

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

The Conditional Weighted Average – SUMPRODUCT with SUMIF (Updated Apr 2024)

Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you,…
, , , ,

Real Estate Case Studies Creator Assistant – Custom GPT by A.CRE

If you've spent any time following us here at A.CRE you know that AI applications in real estate financial modeling is a topic we are fascinated (and excited) about! As a consequence, we're underway with several initiatives to explore AI in…
, , , , ,

Land Development Model – Multi-Scenario (Updated Apr 2024)

Over the years, we've shared eight development-focused real estate financial models and numerous development-specific tools to the A.CRE Library of Excel Models. Nevertheless, there's been a hole in the development offerings in our library.…