Wall Street Prep
Financial Planning & Analysis Modeling Certification (FPAMC©)
You don't have access to this course, but you can purchase it below.
Self-Paced FP&A Certification Program

Financial Planning & Analysis Modeling Certification (FPAMC©)

8 Courses
28h 3m
1,977 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 33 CPE Credits

    The FPAMC© 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 FP&A Profession
  • Budgeting
  • Forecasting
  • Operating Model
  • Data Visualization
  • Data Presentation
  • Corporate Finance
  • Market Research
  • Project Management

The First Rigorous Certification for the FP&A Profession

play
The FPAMC© is a career-focused program designed for:
  • FP&A Analysts and Managers
  • Financial Reporting Groups
  • Controllers and CFOs
  • Accounting Professionals
  • Bridging the gap between theory and practice in FP&A The FPAMC© 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 FPAMC© fills these knowledge gaps and establishes best practices for FP&A professionals.

What You'll Learn

Module 1: An Introduction to FP&A
  • Explore where FP&A sits in the organization and what the “typical” FP&A career path looks like
  • Develop good financial modeling practices such as proper color-coding of inputs and calculations, good modeling structure, and how to create dynamic, reusable model templates
  • Learn about the different types of forecasting and budgeting processes that FP&A is involved in, such as the rolling forecast, budget development, and annual and long-range plans
  • Deep dive into spreadsheet and presentation software staples, as well as additional data and analysis systems used in FP&A such as SQL, Python, and Tableau
  • Leverage hands-on examples to enhance understanding of core accounting, time value of money, statistics, and data analysis concepts
  • Explore key corporate finance concepts such as net present value, internal rate of return, and compound annual growth rate (CAGR)
  • Learn how to clean data for analysis, and use pivot tables and pivot charts to quickly analyze and visualize trends and patterns in our data
Module 2: Building the Operating Model - The Income Statement
  • Model a rolling 18-month income statement forecast, including expenses, headcount, and revenues using detailed, bottoms-up metrics
  • Dive deep into the forecasting process and timeline, as well as the different sources of trends and patterns that are used to forecast (historical, internal, and external)
  • Understand the headcount forecasting process and how the different drivers such as revenues, operating metrics, and even other headcount, affect the total headcount forecast
  • Leverage a top-down, market-based approach to estimate the total addressable market, market share, and margins to develop high-level expectations of future revenues
  • Discover how time-series and regression analysis techniques can be used to project revenues
  • Utilize sales funnel to project the full income statement for a hypothetical online travel agent
Module 3: Building the Operating Model - The Balance Sheet
  • Model a fully-integrated balance sheet forecast, including:
  • How to use efficiency ratios to forecast working capital, as well as how working capital management affects the business
  • Accrual and reserve accounts, what they are, how they’re different, and how are they forecasted
  • Balance sheet account rollforwards and how they are used to analyze the key moving pieces of any balance sheet account
  • Capital expenditures, Debt, and Equity accounts, and how these are handled in FP&A forecasts
Module 4: Building the Operating Model - The Cash Flow Statement
  • Model a complete, integrated cash flow statement forecast
  • Dive into how working capital and fixed asset and liability accounts affect cash flows
  • Explore the Indirect vs Direct cash flow statement presentation, and understand the pros and cons of each
Module 5: Pulling Together the Operating Model
  • Build an understanding of ratio analysis, and how these ratios can be used to better understand the nature of the organization
  • Learn about the various types of financial modeling error checks, and how to easily spot issues in our model using conditional formatting
  • Dive into Data pull / lookup tips and tricks by developing a highly reusable, flexible data lookup system using dynamic named ranges, helper columns, and INDEX() and MATCH() to create powerful lookup formulas
  • Learn how to allocate indirect costs, calculate unit economics and profitability, as well as breakeven units of production for one of our forecasted products
Module 6: Project Management, Long-Range Planning & Analysis
  • Explore project management best practices and processes to come in ahead of schedule and under budget on implementation, analysis, and presentation projects
  • Model a 5-year long-range plan, incorporating multiple scenarios to create a flexible, informative plan to explain market and competitor impacts on the organization’s results
  • Learn to sensitize important model inputs using data tables to analyze their impact on key forecast outputs such as growth, profitability, and efficiency
  • Create dynamic, reusable budget versus actual models complete with built in rate-volume analysis to analyze the cause of variances in the forecast
  • Connect the variance and rate-volume analysis outputs to waterfall charts to visually bridge from one value to another, quickly highlighting the main drivers of change
Module 7: Presentation Best Practices & Building Dashboards
  • Explore principles of good design and data visualization, as well as tips to building highly compelling presentations using data
  • Discover how to think like a designer by utilizing visuals, slide organization and alignment, and other design attributes to increase the efficiency and effectiveness of our presentations
  • Create a short-term projection model of product sales volumes using variable lag periods, built-in visuals, and dynamic chart ranges
  • Design and create a realistic financial results dashboard, from start to finish, utilizing combination charts, hidden axes, dynamic chart titles, and data callouts to immediately highlight key takeaways
Module 7: Appendix: Corporate Finance Principles
  • Explore and understand the first principles of corporate finance and how they can be applied to your organization to increase value
  • Learn how to calculate the cost of debt and cost of equity for your organization, including through the use of the Capital Asset Pricing Model (CAPM)
  • Understand how to build up betas to create dynamic cost of capital calculations, and to determine the optimal mix of debt and equity for your firm
  • Analyze, understand, and utilize operating and financial leverage, and discover how each affect financial results and cost of capital calculations
  • Discover and calculate the fundamental drivers of future growth in operating income and earnings per share
  • Discuss the most common strategic analysis frameworks - what they are, what they mean, and how to use them in the context of FP&A
Show More Show Less
The FPAMC© 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

Who is This Program For?

This program is designed by FP&A professionals across various industries and groups to nail down exactly what you need to know to be successful in the following roles:

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

Your Path to the FPAMC©

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

Complete in 30 Hours

The FPAMC 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.

Covering 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 FPAMC 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: the starting point of the range is generally set at the role average, to account for bonuses which are typically not included in glassdoor.com salary estimates for this role, and which are generally in the range of 10-20% of salary. Estimates do not include stock options or Restricted Stock Units, common incentives in some sectors hiring for FP&A roles.

The FPAMC© Includes the Following 8 Modules

1

An Introduction to FP&A

Module 1 of the FP&A Modeling Certification Program (FPAMC©) 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 ...
Module 1 of the FP&A Modeling Certification Program (FPAMC©) starts with an introduction to the FP&A role and explores the types of responsibilities typical for an FP&A professional, such ...
Module 1 of the FP&A Modeling Certification Program (FPAMC©) starts with an introduction to the ...
View Course TOC
2

Building the Operating Model - The Income Statement

Module 2 of the FP&A Modeling Certification Program (FPAMC©). 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 reven ...
Module 2 of the FP&A Modeling Certification Program (FPAMC©). A major responsibility of the FP&A function is to come up with reasonable, defensible, and insightful expectations of future sales ...
Module 2 of the FP&A Modeling Certification Program (FPAMC©). A major responsibility of the FP ...
View Course TOC
3

Building the Operating Model - The Balance Sheet

Module 3 of the FP&A Modeling Certification Program (FPAMC©). 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 FP&A Modeling Certification Program (FPAMC©). To support our future expectations of business performance, investments, research, and projects need to be developed and initiated tod ...
Module 3 of the FP&A Modeling Certification Program (FPAMC©). To support our future expectations ...
View Course TOC
4

Building the Operating Model – The Cash Flow Statement

Module 4 of the FP&A Modeling Certification Program (FPAMC©). 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 ...
Module 4 of the FP&A Modeling Certification Program (FPAMC©). While projections of revenues, expenses, and capital projects can be incredibly insightful, cash flows are incredibly important for un ...
Module 4 of the FP&A Modeling Certification Program (FPAMC©). While projections of revenues, exp ...
View Course TOC
5

Pulling Together the Operating Model

Module 5 of the FP&A Modeling Certification Program (FPAMC©). 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, ...
Module 5 of the FP&A Modeling Certification Program (FPAMC©). With detailed forecasts of the Income Statement, Balance Sheet, and Cash Flow Statements, we pull all three financial statements toget ...
Module 5 of the FP&A Modeling Certification Program (FPAMC©). With detailed forecasts of the Inc ...
View Course TOC
6

Project Management, Long-Range Planning & Analysis

Module 6 of the FP&A Modeling Certification Program (FPAMC©). 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 busi ...
Module 6 of the FP&A Modeling Certification Program (FPAMC©). The beauty of well-built financial models lies not just in being building out detailed projections for the next 12-18 months, but bein ...
Module 6 of the FP&A Modeling Certification Program (FPAMC©). The beauty of well-built financial ...
View Course TOC
7

Presentation Best Practices & Building Dashboards

Module 7 of the FP&A Modeling Certification Program (FPAMC©). 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 ...
Module 7 of the FP&A Modeling Certification Program (FPAMC©). 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, al ...
Module 7 of the FP&A Modeling Certification Program (FPAMC©). One of the most important roles of ...
View Course TOC
8

Appendix: Corporate Finance Principles

An Appendix of the FP&A Modeling Certification Program (FPAMC©). 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, fund ...
An Appendix of the FP&A Modeling Certification Program (FPAMC©). FP&A professionals must be able to understand corporate finance best practices, in addition to being able to build financial mo ...
An Appendix of the FP&A Modeling Certification Program (FPAMC©). FP&A professionals must be ...
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 Excel Logo
Budget vs. Actual (Excel Sample)
watch video Excel Logo
Long-Range Plan (Excel Sample)

Get the FP&A Modeling Certification (FPAMC©)

Trainees are eligible to take the FPAMC© Exam for 24 months from the date of enrollment. Those who complete the exam and score above 70% will receive a the certification. The exam is a challenging online assessment that covers the most difficult concepts taught in the program.

CPE logo

Earn CPE Credits with WSP Online Courses

CPE logo 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.
X

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.