Watch Me Build - Real Estate Financial Modeling Tutorials - A.CRE https://www.adventuresincre.com/re-education/a-cre-101-basic-concepts-in-commercial-real-estate/watch-me-build/ Real Estate: AI, Financial Modeling, Careers, Education Wed, 13 Aug 2025 22:19:04 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.2 https://www.adventuresincre.com/wp-content/uploads/2021/09/green-background-36x36.png Watch Me Build - Real Estate Financial Modeling Tutorials - A.CRE https://www.adventuresincre.com/re-education/a-cre-101-basic-concepts-in-commercial-real-estate/watch-me-build/ 32 32 30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025) https://www.adventuresincre.com/lenders-calcs/ Mon, 21 Jul 2025 12:00:05 +0000 https://www.adventuresincre.com/?p=2650 (Updated August 7, 2019 to include a Watch Me Build video and Downloadable file) Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals should be aware of these methods if they want to understand the real interest rate as well as the total amount of interest […]

The post 30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025) appeared first on Adventures in CRE.

]]> Watch Me Build a Residential Land Development Model (Updated June 2025) https://www.adventuresincre.com/watch-me-build-residential-land-development-model/ Sun, 08 Jun 2025 18:30:54 +0000 https://www.adventuresincre.com/?p=85657 Over the years, we’ve created a sizable library of Watch Me Build videos covering Excel models for various real estate investment and property types. However, we’ve yet to create a Watch Me Build involving for-sale product. So this weekend, I thought I’d sit down and record myself building a residential land development model. The exercise […]

The post Watch Me Build a Residential Land Development Model (Updated June 2025) appeared first on Adventures in CRE.

]]> Watch Me Build a Dynamic Mortgage Amortization Table in Excel (Updated September 2024) https://www.adventuresincre.com/excel-mortgage-amortization-table-model/ Wed, 25 Sep 2024 18:30:42 +0000 http://www.spencerburton.org/blog/?p=218 There are a few basic, yet fundamental, real estate modeling skills you must master before anyone will take you seriously as a real estate professional. Building a mortgage amortization schedule is one of them. Virtually every model you create will require this skill – or some variation of what you do when you build an amortization table. […]

The post Watch Me Build a Dynamic Mortgage Amortization Table in Excel (Updated September 2024) appeared first on Adventures in CRE.

]]> Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated Aug 2024) https://www.adventuresincre.com/watch-build-equity-waterfall/ Tue, 27 Aug 2024 18:00:03 +0000 https://www.adventuresincre.com/?p=8489 As I’ve mentioned in other Watch Me Build posts, one way to become a better real estate financial modeling professional, is to watch other professionals model. Thus, the more exposure you can get to other’s methods, the more adept a real estate professional you will become. This is especially the case with modeling real estate […]

The post Watch Me Build a 3-Tier Real Estate Equity Waterfall Model (Updated Aug 2024) appeared first on Adventures in CRE.

]]> Watch Me Solve a REPE Technical Interview Modeling Test (Updated July 2024) https://www.adventuresincre.com/watch-model-real-estate-technical-interview-test/ Wed, 17 Jul 2024 12:00:01 +0000 https://www.adventuresincre.com/?p=8386 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, I’ve never just grabbed an actual technical interview case study and walked our readers through how I […]

The post Watch Me Solve a REPE Technical Interview Modeling Test (Updated July 2024) appeared first on Adventures in CRE.

]]> Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024) https://www.adventuresincre.com/watch-me-build-custom-rent-schedule-module/ Sun, 05 May 2024 14:00:11 +0000 https://www.adventuresincre.com/irr-partitioning-in-excel-copy/ 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 hold period. I also include an optional file that you can […]

The post Watch Me Build – Modeling a Rent Schedule in Both Excel and Using AI (Updated May 2024) appeared first on Adventures in CRE.

]]> Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024) https://www.adventuresincre.com/watch-me-build-american-style-real-estate-equity-waterfall/ Sun, 28 Apr 2024 12:55:23 +0000 https://www.adventuresincre.com/watch-me-build-pro-forma-multiple-home-building-projects-copy/ 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. And while that type of waterfall is extremely common, both in the […]

The post Watch Me Build – American-Style Real Estate Equity Waterfall (Updated Apr 2024) appeared first on Adventures in CRE.

]]> Watch Me Build – Industrial Offering Memorandum Analyzer Custom GPT https://www.adventuresincre.com/watch-me-build-industrial-offering-memorandum-analyzer-custom-gpt/ Wed, 03 Apr 2024 06:00:05 +0000 https://www.adventuresincre.com/watch-me-build-custom-rent-schedule-module-copy/ In this Watch Me Build session, I’ll walk you through constructing a custom GPT that near-instantly sifts through Industrial Offering Memorandums to pinpoint whether an investment aligns with your criteria. At the heart of this build is a tailored GPT setup that efficiently processes and analyzes complex data sets found in these OMs. Custom GPTs […]

The post Watch Me Build – Industrial Offering Memorandum Analyzer Custom GPT appeared first on Adventures in CRE.

]]> Create Your First AI Tool: Sales Comp Database ChatGPT Plugin https://www.adventuresincre.com/create-your-first-ai-tool-sales-comp-database-chatgpt-plugin/ Wed, 09 Aug 2023 14:00:27 +0000 https://www.adventuresincre.com/?p=728397 Traditionally in commercial real estate, each organization builds its own proprietary sales comp database and then gives its analysts access to that database in order to perform comp analysis. As AI becomes more and more important, pairing the analyst team with AI tools to speed/improve that real estate analysis is essential. Thus, at the individual […]

The post Create Your First AI Tool: Sales Comp Database ChatGPT Plugin appeared first on Adventures in CRE.

]]> 4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022) https://www.adventuresincre.com/equity-multiple-waterfall/ Thu, 28 Apr 2022 13:00:53 +0000 https://www.adventuresincre.com/?p=8507 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 where I walk the user step by step through building it out. Are […]

The post 4-Tier Equity Multiple Waterfall – Download and Watch Me Build (UPDATED APR 2022) appeared first on Adventures in CRE.

]]> Watch Me Build – IRR Partitioning in Excel https://www.adventuresincre.com/irr-partitioning-in-excel/ Wed, 16 Sep 2020 21:25:33 +0000 http://www.adventuresincre.com/?p=1472 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 a short Watch Me Build video tutorial to illustrate the […]

The post Watch Me Build – IRR Partitioning in Excel appeared first on Adventures in CRE.

]]> Watch Me Build – Capital Stack with Mezzanine Debt https://www.adventuresincre.com/watch-me-build-capital-stack-mezz-debt/ Tue, 05 May 2020 00:57:42 +0000 https://www.adventuresincre.com/watch-me-build-capital-stack-mezz-debt-copy/ 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, I turn on my screen recorder and talk through modeling a capital […]

The post Watch Me Build – Capital Stack with Mezzanine Debt appeared first on Adventures in CRE.

]]> Watch Me Build a Tenant Rollover Analysis Model https://www.adventuresincre.com/watch-build-tenant-rollover-analysis-model/ Fri, 27 Mar 2020 11:33:06 +0000 https://www.adventuresincre.com/?p=2936 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 the methodology, keyboard shortcuts, and formulas I use as I build the model. […]

The post Watch Me Build a Tenant Rollover Analysis Model appeared first on Adventures in CRE.

]]> Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020) https://www.adventuresincre.com/watch-build-multifamily-real-estate-model/ Wed, 19 Feb 2020 13:26:51 +0000 http://www.adventuresincre.com/?p=2204 One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better at what I do. I remember sitting with a friend, watching him zip back […]

The post Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020) appeared first on Adventures in CRE.

]]> Watch Me Build Data Tables For Real Estate Sensitivity Analysis https://www.adventuresincre.com/data-tables-sensitivity-analysis/ Mon, 27 Jan 2020 13:42:53 +0000 https://www.adventuresincre.com/?p=127977 This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I’ll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I’ll walk you through how to no longer limit your two-variable sensitivity […]

The post Watch Me Build Data Tables For Real Estate Sensitivity Analysis appeared first on Adventures in CRE.

]]>