You are here: / / / Debt

Real Estate Financial Modeling

All | Argus| Excel Models | Excel Tips | Stochastic Modeling

Acquisition | Development | Value-Add | Asset Management | Debt | Equity Waterfall | Excel Add-ins | Modules | Portfolio | Standalone | Tutorial | Apartment | Hotel | Industrial | Land Development | Office | Retail | Single-Family

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated May 2026)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
, , ,

Commercial Mortgage Loan Analysis Model (Updated June 2026)

Over the years, I've received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount…
, , , ,

3-Tiered Acquisition Debt Module (Updated Apr 2026)

This is a 3-tiered debt module that will allow the user to add one to three tiers of debt to his or her real estate DCF model. Includes the option to layer in senior debt, secondary debt, and mezzanine debt; calculate interest on either…
, , ,

Understanding Stabilization Through The Lens Of Operating Expense Ratio

The term “stabilized” is deeply embedded in the language of real estate. It shows up frequently in financial models, offering memoranda, development strategies, and underwriting assumptions. So frequently, in fact, that its meaning is often…
, , , , , ,

30/360, Actual/365, and Actual/360 – How Lenders Calculate Interest on CRE Loans – Some Important Insights (Updated July 2025)

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

Watch Me Build a Dynamic Mortgage Amortization Table in Excel (Updated September 2024)

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

Loan Payment Schedule and Balance Tracking Tool (Updated Aug 2024)

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

Linear Mortgage Payment Schedule Tool (Updated July 2024)

We recently shared a new modeling test to our library of real estate case studies entitled UK Debt Advisory Firm Modeling Test. In that case study, the test asked the real estate professional to analyze the returns of three different debt options.…
, , ,

Advanced Mortgage Amortization Module (Updated May 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),…
, , , , ,

Real Estate Debt Module in Excel (Updated May 2024)

I thought I'd share the real estate debt module I originally built for the ARGUS alternative in Excel. Most debt modules I've seen in real estate financial models only include the ability to model fully amortizing senior debt. Mike challenged…
, , , , , ,

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

Refinance Risk Analysis Tool in Excel (Updated Nov 2023)

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

Construction Draw Schedule: Accounting For True LTC (Updated Apr 2022)

When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender will agree to lend to the borrower. So, if a project costs $10MM, and a lender loans…
, , ,

Dynamic Amortization Schedule (Updated 2.06.2020)

This is a dynamic amortization schedule for debt that gives the user the capability to model a loan with an interest only period up front and an amortizing floating rate debt repayment period once the interest only period is over. This module…