FinPod

In this episode of FinPod, host Asim Khan is joined by Duncan McKeen, CFA, FMVA, as they delve into the world of headcount forecasting and analysis. 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.

In this episode of FinPod, host Asim Khan is joined by Duncan McKeen, CFA, FMVA, to discuss FP&A model design, revenue forecasting, and the power of proper formatting. Duncan shares insights on creating visually appealing and easy-to-follow models using the latest Excel features, such as binary switches and conditional formatting.Discover how to enhance your models with up and down arrows to highlight changes and leverage binary switches for efficient data management. Learn how these techniques contribute to telling the story behind the numbers, helping you make informed financial decisions. Elevate your FP&A revenue forecasting skills with this quick, high-impact conversation.

In this episode of FinPod, host Asim Khan is joined by Duncan McKeen, CFA, FMVA, to discuss Financial Planning & Analysis (FP&A). Duncan shares insights into the importance of model design in finance, emphasizing the significance of careful planning and structuring for effective decision-making. Learn how to efficiently gather inputs using modern tools like Power Query and how keyboard shortcuts can significantly improve productivity.Duncan and Asim discuss practical tips such as designing models backward, starting with the dashboard, and working in reverse to ensure a seamless flow. Tune in for expert advice on mastering financial modeling and how the FP&A courses can help you excel in your finance career.