PLAY PODCASTS
What's New at CFI | Mastering Financial Statement Aggregation and Analysis with CFI
Episode 4

What's New at CFI | Mastering Financial Statement Aggregation and Analysis with CFI

FinPod · Corporate Finance Institute

May 14, 20249m 28s

Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.

Show Notes

In this episode of FinPod, host Asim Khan is joined by Duncan McKeen, CFA, FMVA, as they discuss financial statement aggregation and analysis. Follow along as Duncan walks us through consolidating financial statements using advanced Excel functions. 

Discover the significance of breaking down current and deferred taxes, balancing income statements, and mastering cash flow projections. Learn the benefits of monthly modeling for a comprehensive 24-month forecast period and how to effectively aggregate data by quarter and year. Join Duncan and Asim as they explore common modeling challenges while offering insights on building robust models with features like alerts and up-to-date functionalities. 

Topics

corporate financefinancebankingcapital marketsFP&Arisk managementlearning & developmentfinance careers