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

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

Update: 2024-05-14
Share

Description

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. 

Comments 
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

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

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

Corporate Finance Institute