AFM 2

This Q&A podcast focuses on advanced financial modeling techniques in Excel. The instructor begins by introducing themselves and the FMI Foundations program, a supplementary accreditation program integrated into the course. The session then proceeds with a Q&A addressing student questions on previous material, followed by a detailed explanation of custom number formatting and the `CONCAT` function (and its limitations). The instructor demonstrates how to create a user-friendly scenario management system using Excel's combo box, contrasting it with other methods. Finally, the session concludes with a discussion on building a financial model's "engine" (calculations and financial statements), emphasizing the importance of understanding business operations and communicating effectively through clear model design. A key takeaway is the importance of using price and volume to forecast revenue, rather than relying solely on historical growth rates.