Скачать или смотреть How to Build an Amortization Table from Scratch (Live Modeling w/ Excel Shortcuts)

In this video, we build a complete loan amortization table from scratch in Excel, step by step. You’ll learn how to model principal and interest payments, track loan balances, and use Excel formulas to create a clean, dynamic schedule used across real estate finance, private equity, and investment banking.

The walkthrough is designed to help you understand how debt amortization works — not just the formulas, but how lenders and analysts use these schedules in underwriting, development models, and acquisition pro formas.

Throughout the session, I highlight Excel shortcuts, formatting best practices, and modeling habits that improve accuracy and speed, mirroring the standards used by institutional analysts.

Key Topics Covered:
-Loan Setup and Key Assumptions
-Principal and Interest Calculation
-Monthly Payment Formula
-Absolute and Relative Cell Referencing
-Running Balances and Payment Schedules
-Interest-Only vs. Amortizing Loans
-Using the PMT function
-Structuring for Auditability and Professional Presentation

By the end of this tutorial, you’ll have a functional amortization table you can plug into any commercial real estate financial model — and a stronger grasp of how debt service affects project cash flow and returns.

This video is ideal for MSRED/MRED students, REPE candidates, and anyone looking to sharpen their Excel modeling skills for real estate or finance interviews.

For 1-on-1 financial modeling tutoring, access to model files, or more real estate finance walkthroughs, visit:
https://www.self-taughtcre.com

Subscribe for more videos on real estate financial modeling, Excel for CRE, and investment case study prep.