Financial Modeling Tutorials by CFI - How to Create a Debt Schedule in Excel with PMT, IPMT & IF Functions

Learn how to create a dynamic debt schedule in Excel using financial functions like PMT, IPMT, and IF statements. This step-by-step tutorial guides you through building a loan amortization schedule, calculating total payments, interest, and principal breakdowns, and ensuring a clean, error-free financial model. Learn how to: - Format and optimize your Excel financial model. - Use the PMT function to calculate total payments. - Set up loan assumptions (amount, term, interest rate). - Automate balance calculations for accurate projections. - Implement IF statements to create a dynamic, error-free model. - Break down interest and principal payments with IPMT function. This tutorial is ideal for finance professionals, students, and analysts who want to enhance their Excel financial modeling skills. Chapters: 00:00 - Introduction 00:30 - Debt Assumptions 02:02 - Debt Schedule You can learn more about debt schedules at https://corporatefinanceinstitute.com/resources/knowledge/modeling/debt-schedule And you can also learn more about the PMT Excel function at https://corporatefinanceinstitute.com/resources/excel/functions/pmt-function Now that you've built a debt schedule, the next step is integrating it into a complete financial model. Watch https://youtu.be/usasgnZxYto to see how debt flows through the income statement, balance sheet, and cash flow statement. #Debt #Excel #PMT #IPMT #IFFunction