14 Jan 2025
2h 20m

AFM 5

Podcast cover

AFM

This Q&A podcast focuses on financial modeling, specifically addressing common errors and best practices. The instructor begins by discussing a real-world example of a billion-dollar bond deal that failed due to a modeling error related to future capital expenditures (CAPEX), prompting a class discussion on potential causes. The discussion then shifts to practical advice, including tips for building clear and organized models, emphasizing the importance of checking assumptions and calculations meticulously. The instructor demonstrates how easily errors can occur, such as incorrect signs on CAPEX or missing line items in totals, and offers strategies for catching these mistakes. The podcast concludes with a review of the process of building debt and equity schedules, highlighting the importance of using consistent structures and formulas to ensure accuracy.

Outlines

Part 1: Introduction, News Story

Part 2: Analyzing the Model Error

Part 3: Importance of Accurate Modeling

Part 4: Error Checking and Model Building

Part 5: Excel Techniques

Part 6: Debt and Equity Modeling

Part 7: Wrap-up and Exam Prep

Sign in to continue reading, translating and more.

Open full episode in Podwise