
Sign up to save your podcasts
Or


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.
By Corporate Finance Institute5
66 ratings
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.

3,365 Listeners

2,174 Listeners

385 Listeners

156 Listeners

194 Listeners

682 Listeners

1,041 Listeners

106 Listeners

168 Listeners

58 Listeners

1,300 Listeners

77 Listeners

791 Listeners

80 Listeners

166 Listeners