Virtual Course: FP&A Technical Mastery

Virtual Course: FP&A Technical Mastery


FP&A Technical Mastery

     This is a Virtual Instructor - Led Training (VILT)

FP&A professionals require a cross-functional understanding of accounting, finance, corporate strategy, and industry dynamics. This virtual training program is designed to fill the knowledge gaps we’ve seen FP&A and corporate finance professionals, covering the following topics:
• The Power & Art of Business Modeling in FP&A
• Data Visualization & Storytelling
• Outputs & Variance Analysis
• Scenarios & Sensitivities
• Getting to Answers Without Modeling
• Capex & Project Forecasting
• Forecasting & Budgeting
• Strategic Financial Planning & Analysis

Full Agenda

The Power and Art of Business Modeling

  • Modeling best-practices
    • Organizational structure and navigation
    • Coverage of key formulas & functions, ribbons, and functionality
    • Simplification of complex modeling techniques and model hygiene
    • Formula auditing, watch window, formula evaluator
    • Use of dynamic links for linking internally and to external workbooks
  • Model formatting
    • Use of defined names for cells, ranges, tables, data sets, and formulas to simplify references
    • Incorporation of dynamic drop-down lists, toggles, and lookups to improve efficiency
  • Dynamic modeling
    • Creation of dynamic data sets, data ranges, named ranges and formulas using OFFSET to reduce or eliminate manual updates to models and forecasts
    • Use toggles combined with INDIRECT to quickly and efficiently import financials or subsequently-dated data sets
    • Real-life application through exercises and case studies

Data Visualization & Storytelling

  • Best-practices for conveying financial performance in visual form for meetings and presentations
  • How FP&A can serve as a strategic partner to non-financial business functions
  • Creation of deliverables with consideration given to the end-user or a wide array of audiences
    • Sparklines combined with dynamic data ranges
    • Using dynamic data sets to populate pivot charts, pivot tables, and pivot slicers
  • Real-life application through exercises and case studies

Outputs & Variance Analysis

  • Use of data visualization to communicate strategic mapping, key performance indicators (KPIs), and balanced scorecards
  • Approaches for identification and visual display of KPIs
  • Variance analysis and cash flow forecasting
    • Use of conditional formatting to highlight period-over-period variances
    • Consideration of dynamic triggers for flexible conditional formatting
  • Real-life application through exercises and case studies
  • Building and displaying impactful dashboards for meetings and presentations
  • Crafting and management of dynamic charts and graphs
    • Creation of fully-dynamic graphs with automated updating of links to source information
    • Incorporation of fully-flexible date range toggles within dynamic graphs
    • Utilization of form controls in dynamic graphs to enhance user-interface
  • Real-life application through exercises and case studies

Scenarios & Sensitivities

  • Financial consolidations
    • SUM OF WORKSHEETS approach to scenario management, forecasting, and budgeting
  • Introduction to the Developer ribbon and Visual Basic for Applications (VBA)
  • Introduction to Excel’s built-in scenario manager and scenario summary function
  • Enhancement of scenario user-interface with form controls (option buttons, check boxes, combo boxes, spin buttons, scroll bars, group boxes)
  • Differences between simulation and optimization
  • Conduct sensitivity analysis with dynamic 1- and 2-variable data tables combined with conditional formatting

Getting to Answers Without Modeling

  • Conduct ‘what-if’ operational simulations to minimize risk
  • Utilize goal seek to determine pricing and to target profitability
  • Demonstrate how Excel’s Solver can enhance performance while addressing resource constraints
  • Address break-even, profit optimization, and product mix decisions
  • Real-life application through exercises and case studies

Capex & Project Forecasting

  • Net Present Value (NPV), Internal Rate of Return (IRR), Modified IRR (MIRR), XIRR, XNPV
  • Discounted cash flow analysis and the weighted average cost of capital
  • Utilize 1- and 2-variables sensitivity tables to display a range of probable results
  • Real-life application through exercises and case studies

Forecasting & Budgeting

  • Key terms and definitions
  • Forecasting methods
    • Top-down
    • Bottoms-up
  • How risk, uncertainty, and probability affect forecasts
  • How regression aids in forecasting accuracy
  • Real-life application through exercises and case studies

Strategic Financial Planning & Analysis

  • Key accounting and finance terms and definitions
  • Understanding the fundamentals of the financial statements
    • Income Statement
    • Balance Sheet
    • Statement of Cash Flows
    • Common-sizing and period-over-period trend analysis
    • Ratio analysis
  • Comprehensive strategic case study
    • Revenue and cost build by channel
    • Assessment of the macroeconomic and industry environment
    • Peer review
    • Liquidity and working capital management including cash conversion cycle optimization
    • Gap analysis
    • Debt sizing
    • Integrated venture forecast modeling

Program Conclusion

  • What are the characteristics of an effective FP&A function
  • The future of FP&A in large corporations and private companies

This Virtual Course is Instructed by our training partner, Wall Street Prep


  • When

  • Tuesday, October 27, 2020 - Thursday, October 29, 2020
    9:00 AM - 5:00 PM
    Eastern Time

Outlook Outlook
iCal iCal
Google Google
Yahoo! Yahoo!