January 12, 16, 21 & 23

1:00 - 3:00 pm ET
NOT ELIGIBLE FOR CTP, FPAC OR CPE CREDITS

Completion of the FPAC Exam Prep Platform Is Recommended

The FPAC Exam Bootcamp is designed to assist students in preparing for the FP&A Certification through interactive case studies.  In each session, students will work with other students on assigned case studies highlighting skills necessary to pass the FP&A exam. Cases will then be reviewed and explained by the Instructor. Students should have studied the Exam Prep Platform before class, this course serves as a capstone to tie the theory and practical application together.
Non-Members $595 | Members: $495

Purchase

Sample Agenda

Session 1

  • Introduction
  • Exam Tips
  • Warm-up Case
  • Time Value of Money Cases
  • Cash Conversion Cycle Case
  • Breakeven Case
  • Depreciation Case
  • Homework
    • Advanced Cash Conversion Cycle Case
    • Elasticity Case
    • Equivalent Annual Annuity Case

Session 2

  • Review Class 1 Homework
  • Financial Statements Case
  • Delphi Method Case
  • Trend Line Case
  • Smoothing Case
  • Seasonality Case
  • Homework
    • Ratios from Financial Statements Case
    • Practice Excel Cases

Session 3

  • Review Class 2 Homework
  • Revenue Projection Case
  • Returns Case
  • Margin Concept Exercise Case
  • Price-Volume-Mix Case
  • PVM of a Customer Case
  • Homework
    • P&L Scenario Case
    • Lifetime Value of a Customer Case
    • Probability Adjusted NPV Cases

Session 4

  • Review Class 3 Homework
  • Review Discussion Question
  • WACC and CAPM overview
  • Finding Beta Case
  • WACC and CAPM Case
  • Shortcomings of WACC/CAPM
  • Value at Risk (VAR) Case
  • Additional Stats Cases
  • Bonus Topics:
    • Optimization Case
    • Monte Carlo Simulation Case

Instructor

Mike Carpenter joined NWN in 2019 as the VP of Financial Planning and Analysis.  Before NWN, he held finance leadership roles at Sparx Hockey, Cimpress, PAREXEL International, Merck Millipore, Lake Region Medical, the Tampa Bay Rays, and Yum! Brands. 

Mike holds an engineering degree from Cornell University and an MBA from the University of Chicago.  He obtained his FP&A Certification in 2015 and has taught FP&A Exam Prep classes since 2016.  Mike and his wife have one child and live in the suburbs of Boston.