background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Certification in Financial Planning & Analysis Modeling (CFPAM™)

You don't have access to this course, but you can purchase it below.
Wall Street Prep Certification Program

Certification in Financial Planning & Analysis Modeling (CFPAM)

  •   8 Courses
  •   28h 3m
  •   13,273 Students

Wall Street Prep's globally recognized certification program prepares trainees with the skills they need to succeed as a Financial Planning and Analysis (FP&A) professional.

Earn a Verified Certification

Shareable on LinkedIn and in resumes

Earn 31 CPE Credits

The CFPAM is a NASBA-registered continuing professional development program

Globally Recognized

Used by by the world's leading companies to train their FP&A Analysts and Managers

Major Skills Covered

The First Rigorous Certification for the FP&A Profession

The CFPAM is a career-focused program designed for:

  • FP&A Analysts and Managers
  • Financial Reporting Groups
  • Controllers and CFOs
  • Accounting Professionals

Bridge the Gap Between Theory and Practice

The CFPAM is focused on equipping learners with actual, practical competencies and best practices in FP&A. Developed by FP&A professionals and used by finance teams from the world’s leading companies, you'll learn how to forecast detailed operating models step-by-step, create long-range plans with built-in scenarios, and craft both short- and long-term projection models and construct data visualizations that bring numbers to life.

Job-Focused Certification Program

Solid financial modeling, data analysis and forecasting know-how is just one part of the FP&A professional’s toolbox. This challenging position also requires interpreting, visualizing and presenting data - often stepping back from modeling and data analysis to work cross-functionally to arrive at answers. The CFPAM fills these knowledge gaps and establishes best practices for FP&A professionals.

The CFPAM is the same program used to train FP&A hires at some of the world's leading Fortune 500 firms

logos

Wall Street Prep trains FP&A professionals and others across the CFO suite at leading global corporations.

"We use WSP’s FP&A program because it's the only cohesive training we've seen that connects the dots of accounting, technical finance and corporate strategy and gets to the heart of the FP&A function."

 VP of Finance,  Fortune 500 Cloud Computing Enterprise Software Firm

Your Path to Certification

This FP&A certification course is career-focused. We begin with an overview of the FP&A career pathway, what the role entails and the systems and concepts you need to know. We move on to build an operating and forecasting model and create a long-range planning model to discuss the use of scenarios and sensitivities in forecasting. Finally, we learn how to use short-term pacing models, dynamic dashboards and data visualization to inform and influence business partners. As a bonus, we explore how to utilize advanced corporate finance principles to guide firm strategy.

Recommended Path

1. An Introduction to FP&A Week 1
2. Building the Operating Model - The Income Statement Week 2
3. Building the Operating Model - The Balance Sheet Week 3
4. Building the Operating Model - The Cash Flow Statement Week 3
5. Pulling Together the Operating Model Week 4
6. Project Management, Long-Range Planning & Analysis Week 5
7. Presentation Best Practices & Building Dashboards Week 6
8. Appendix: Corporate Finance Principles Week 6

Complete in 30 Hours

The CFPAM is a job-focused program that drills down on what FP&A professionals need to know while cutting out the rest. Average completion time (coursework + exam) is 30 hours.

Skills FP&A Employers Look For

  • Forecasting and Budgeting

    Covered
  • Variance Analysis

    Covered
  • Financial and Strategic Planning

    Covered
  • Pacing, Projections, and Dashboards

    Covered
  • Building Presentations

    Covered

Top Jobs the CFPAM Will Prepare You For

  • Position

    1st Year Salary + Bonus *

  • FP&A Analyst

    $70-95,000
  • FP&A Manager

    $85-115,000
  • FP&A Senior Manager

    $130-160,000
  • FP&A Director

    $160-200,000
  • Corporate Finance Manager

    $105-140,000
  • Chief Financial Officer

    $170-350,000+

* Based on glassdoor.com estimates.

What's Included

53 Lessons
8h 7m

An Introduction to FP&A

 53 Lessons  8h 7m

Module 1 of the Certification in FP&A Modeling (CFPAM™) starts with an introduction to the FP&A role and explores the types of responsibilities typical for an FP&A professional, such as recurring reporting and accounting close, forecasting and budgeting, pacing & performance reporting, project analysis, and ad hoc analysis. We then ...

Module 1 of the Certification in FP&A Modeling (CFPAM™) starts with an introduction to the FP&A role and explores the types of responsibilities typical for an FP&A professional, such as re ...

Module 1 of the Certification in FP&A Modeling (CFPAM™) starts with an introduction to the FP ...

1
View Course TOC
35 Lessons
4h 56m

Building the Operating Model - The Income Statement

 35 Lessons  4h 56m

Module 2 of the Certification in FP&A Modeling (CFPAM™). A major responsibility of the FP&A function is to come up with reasonable, defensible, and insightful expectations of future sales, expenses, and headcount requirements. Here we’ll learn the difference between fixed and variable expenses, different approaches to forecasting revenue, a ...

Module 2 of the Certification in FP&A Modeling (CFPAM™). A major responsibility of the FP&A function is to come up with reasonable, defensible, and insightful expectations of future sales, exp ...

Module 2 of the Certification in FP&A Modeling (CFPAM™). A major responsibility of the FP&A ...

2
View Course TOC
17 Lessons
2h 0m

Building the Operating Model - The Balance Sheet

 17 Lessons  2h 0m

Module 3 of the Certification in FP&A Modeling (CFPAM™). To support our future expectations of business performance, investments, research, and projects need to be developed and initiated today. This requires building projections around these items to determine funding requirements and future impacts on the business.

Module 3 of the Certification in FP&A Modeling (CFPAM™). To support our future expectations of business performance, investments, research, and projects need to be developed and initiated today. T ...

Module 3 of the Certification in FP&A Modeling (CFPAM™). To support our future expectations of b ...

3
View Course TOC
5 Lessons
0h 28m

Building the Operating Model – The Cash Flow Statement

 5 Lessons  0h 28m

Module 4 of the Certification in FP&A Modeling (CFPAM™). While projections of revenues, expenses, and capital projects can be incredibly insightful, cash flows are incredibly important for understanding the impact on company liquidity as well as its ability to finance required payments and projects. Understanding how cash flows through the busi ...

Module 4 of the Certification in FP&A Modeling (CFPAM™). While projections of revenues, expenses, and capital projects can be incredibly insightful, cash flows are incredibly important for underst ...

Module 4 of the Certification in FP&A Modeling (CFPAM™). While projections of revenues, expenses ...

4
View Course TOC
22 Lessons
2h 51m

Pulling Together the Operating Model

 22 Lessons  2h 51m

Module 5 of the Certification in FP&A Modeling (CFPAM™). With detailed forecasts of the Income Statement, Balance Sheet, and Cash Flow Statements, we pull all three financial statements together to understand the full impact to the business. These operating models can be tailored to report on things such as fundraising and liquidity needs, prof ...

Module 5 of the Certification in FP&A Modeling (CFPAM™). With detailed forecasts of the Income Statement, Balance Sheet, and Cash Flow Statements, we pull all three financial statements together t ...

Module 5 of the Certification in FP&A Modeling (CFPAM™). With detailed forecasts of the Income S ...

5
View Course TOC
23 Lessons
4h 30m

Project Management, Long-Range Planning & Analysis

 23 Lessons  4h 30m

Module 6 of the Certification in FP&A Modeling (CFPAM™). The beauty of well-built financial models lies not just in being building out detailed projections for the next 12-18 months, but being able to create more dynamic, long-range plans to visualize the impact that changes in these assumptions will have on the expected course of the business. ...

Module 6 of the Certification in FP&A Modeling (CFPAM™). The beauty of well-built financial models lies not just in being building out detailed projections for the next 12-18 months, but being abl ...

Module 6 of the Certification in FP&A Modeling (CFPAM™). The beauty of well-built financial mode ...

6
View Course TOC
25 Lessons
3h 44m

Presentation Best Practices & Building Dashboards

 25 Lessons  3h 44m

Module 7 of the Certification in FP&A Modeling (CFPAM™). One of the most important roles of FP&A is learning how to surface the right data, at the right time, to the right individuals, all in a format that is easy to digest. We’ll also learn how to build data lookups, dynamic charts, and output summaries while we build out a projection mode ...

Module 7 of the Certification in FP&A Modeling (CFPAM™). One of the most important roles of FP&A is learning how to surface the right data, at the right time, to the right individuals, all in ...

Module 7 of the Certification in FP&A Modeling (CFPAM™). One of the most important roles of FP ...

7
View Course TOC
16 Lessons
1h 28m

Appendix: Corporate Finance Principles

 16 Lessons  1h 28m

An Appendix of the Certification in FP&A Modeling (CFPAM™). FP&A professionals must be able to understand corporate finance best practices, in addition to being able to build financial models. Here we’ll discuss corporate finance theory, understanding how companies fund their operations, trade-offs of debt and optimal debt ratios, fundament ...

An Appendix of the Certification in FP&A Modeling (CFPAM™). FP&A professionals must be able to understand corporate finance best practices, in addition to being able to build financial models. ...

An Appendix of the Certification in FP&A Modeling (CFPAM™). FP&A professionals must be able ...

8
View Course TOC

Course Samples

watch video
Course Intro
watch video
Salary Expense Budget Vs Actual Example
watch video
Pivot Charts
watch video
Detailed Revenue Forecast: Transactions
watch video
Accruals and Reserves
watch video
Operating Leverage
watch video
Dashboard Example Overview
watch video
Budget vs. Actual (Excel Sample)
watch video
Long-Range Plan (Excel Sample)

Get the Certification in FP&A Modeling (CFPAM)

FP&A Modeling learners are eligible to earn Wall Street Prep's globally recognized Certification in FP&A Modeling (CFPAM). The certification is earned by successfully completing the final exam from each of the program's individual courses. These online assessments can be taken any time after enrollment in the program.

Earn CPE Credits with WSP Online Courses

Wall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.