Advance FP&A & Financial Modeling

Validity : 1 Year
Description

Curriculum 

Session 1 

  • FP&A Basics 
  • FP&A Myths
  • FP&A Calendar
  • FP&A & Other departments
  • FP&A Activities
  • FP&A Terminologies
  • Transaction Cycle
  • KPIs and Metrices
  • Planning Process
  • Strategic Plan
  • Annual Operating Plan
  • AOP - Exercise
  • Assignment
     

Session 2 

  • Budgeting
  • Budgeting Techniques
  • Budgeting Approaches
  • Budgeting Process
  • Budget Exercise
  • Assignment


Session 3 

  • Assignment Review
  • Variance Analysis
  • Storytelling with Data
  • Business Acumen & Strategic Thinking
  • Effective Communication of Financial Information
  • FP&A Software and Tools
  • AI in FP&A
  • Data Review
  • Data Reporting
  • Assignment

Session 4 

  • Forecast
  • Forecast Inputs
  • Rolling Forecast
  • Forecast Exercise
  • Assignment

Session 5   

  • Management Reports
  • Budget vs Actual Report
  • Cash Flow Forecasting
  • Flash Reports
  • Other FP&A Reports
  • Common Excel functions
  • Reporting Exercise
  • Assignment

Session 6 

Financial Modeling Part 1

  • Building 3 Statement Model
  • What If Analysis
  • Financial Modeling Exercise
  • Assignment

Session 7 

Financial Modeling Part 2

  • Project Evaluation Tools
  • NPV, IRR and Payback period
  • Discounted Cash Flow
  • Financial Modeling Exercise
  • Assignment

Session 8 

  • CV Feedback - One to one
  • Creating LinkedIn and Naukri Profile
  • Mock Interview and Feedback - One to one
  • Doubt clearance
  • Job Hunting tips

 

 

 

 

 

 

 

 

Advance FP&A - Budgeting, Forecasting, Reporting