Summary
Keywords
Full Transcript
In this episode of FinPod, host Asim Khan is joined by Duncan McKeen, CFA, FMVA, as they delve into financial planning and analysis and headcount forecasting. This engaging discussion explores essential strategies for forecasting a company's employees and associated costs. Discover how to forecast salaries, bonuses, and benefits while maintaining a comprehensive view of cash flow and income statements. Learn about new Excel features like up and down arrows to quickly spot salary changes and model alerts that enhance model integrity. Duncan shares innovative approaches to employee cost forecasting and the importance of cover pages in communicating critical information upfront. Tune in for valuable insights into headcount forecasting & analysis that every FP&A professional needs to know! Key topics include: - Forecasting external contractors. - Insights into FP&A course structure. - Modeling salaries, benefits, and bonuses. - Headcount forecasting and cost analysis. - Utilizing alerts to safeguard model integrity. Chapters: 00:00 - Introduction to What's New at CFI 00:52 - Headcount Forecasting 02:05 - Salary and Benefits Modeling 03:00 - Bonus Payment Forecasting 03:46 - Up and Down Arrows for Salary Changes 05:07 - Importance of Alerts in FP&A Models 06:07 - Cover Pages and Dashboard Alerts 07:25 - Upcoming Contractor Forecasting Course 08:28 - Conclusion Don't miss out on future episodes of the "What's New at CFI" podcast—subscribe for more insights into FP&A, financial modeling, and best practices in Excel! Enrol in our full FP&A Professional Headcount Forecasting & Analysis course: https://corporatefinanceinstitute.com/course/fpa-professional-headcount-forecasting-analysis/ #FinancialPlanning #FinancialAnalysis #FinancialModeling #CorporateFinance #FinancialEducation
