Preparation for Certificate in Financial Planning & Analysis (Cert FP&A) Training Courses - | Meirc
Passionately developing careers.

Accounting and Finance

Preparation for Certificate in Financial Planning & Analysis (Cert FP&A)

Why Attend

In today's world, there is more importance given to financial planning and analysis. Professionals are expected by top management to provide proper information and analysis for decision making and to be equipped with the proper tools to do so. Management needs to have confidence in what the financial professionals are presenting in the company’s budgets and forecasts. Now, you have the chance to certify your credentials and expertise in the field of budgeting, forecasting, financial planning and analysis through the Association of Financial Professional (AFP). AFP’s Certified Corporate Financial Planning & Analysis Professional is a designation well worth your time and investment. It’s a two parts exam that are available online. This course provides an overview of the main concepts in Part 1 exam as well as going through the main practitcal side of Part 2 of building models using Excel. Let this course help you so you can pass the exam and stand out from the rest of the crowd.

Course Methodology

The course is designed to tackle the key concepts and most difficult areas covered in the exam with the use of exercises and workshops.

Course Objectives

By the end of the course, participants will be able to:
  • Identify proper sources for gathering information about the company and its industry and apply the basic concepts of macro economics and strategic planning
  • Define main financial and micro economic concepts and identify types of budgets
  • Perform financial analysis and variance analysis and draw conclusions
  • Build financial projections, evaluate capital expenditures and investments and create what-if analysis
  • Utilize advanced spreadsheet functions, e.g. value lookup, pivot tables, macros, etc.

Target Audience

All accounting and finance professionals who are currently working, or seeking to work, in the financial planning, analysis, budgeting and forecasting domain within their organizations.

Target Competencies

  • Applying accounting rules
  • Budgeting
  • Financial planning
  • Analytical skills
  • Communication skills
  • Building financial models
  • Gathering and interpreting information
    • Sources of historical information and historical financial data and corporate structure and functions
    • Sources of information about a company’s business environment (e.g. business models, financial ratios, and industry metrics)
    • Reading and interpreting corporate annual reports
    • Determining peer groups and competitors
    • Basic macro-economic concepts used in financial planning (e.g., consumer price index, gross domestic product, exchange rates, interest rates, inflation rates, economic indicators, etc.)
    • Implications of tax policies on projections
    • Risk factors and risk management concepts
      • Value at risk
      • Hedging
      • Insurance
      • Interest rate risk
      • Diversification
    • Financial and non-financial key performance indicators
    • Strategic planning concepts and frameworks
      • SWOT Analysis
      • Porter’s five forces model
      • Growth share matrix
    • Determining information needs of and gather information from internal/external stakeholders and business partners
    • Tools for information gathering (e.g., templates, surveys, etc.)
  • Understanding financial concepts and communicating/coordinating work with other professionals
    • Finance principles and processes (e.g., financial management concepts, corporate finance activities, etc.)
    • General financial concepts and common financial formulas (e.g., time value, opportunity costs, debt structures and covenants, earnings per share, cost of capital, etc.)
    • Financial accounting concepts, principles, and practices
    • Interactions/interrelationships of common financial statements
    • Basic micro-economics (e.g., marginal costs, pricing, price elasticity of supply and demand, etc.)
    • Managerial accounting/reporting and cost accounting concepts
      • Costs throughout the production process
      • Fixed and variable costs
      • Cost allocation
      • Contribution margins
    • Types of budgets/forecasts (e.g., zero-based budgets, annual budgets, rolling forecasts, etc.) and their applications
    • Financial close process, including the resulting financial reporting activities, and the role of the FP&A function in the close/reporting process
    • General business terminology, practices, and processes (e.g., compensation structures, performance management, stock options, etc.)
    • Defining, coordinating, and communicating project/work flow elements (e.g., deadlines, deliverables, expectations, etc.)
    • Effective communication and presentation techniques (e.g., building alliances, resolving communication issues, determining appropriate presentation techniques, preparing reports, using charts/graphs, etc.)
  • Analyzing information
    • Determining the applicability/acceptability of tools, processes, models, etc.
    • Testing and validating a model (e.g., cross-footing, consistency testing, reasonableness assessment, etc.)
    • Identifying outliers in data and determining the causes
    • Developing assumptions, drawing conclusions, assessing the reasonableness of assumptions/conclusions, and testing conclusions against various scenarios
    • Financial ratio analysis (e.g., debt/equity, accounts receivable days, liquidity ratios, etc.)
    • Variance analysis and reporting (e.g., actuals versus prior periods, actuals versus plan, actuals versus forecast, etc.)
    • Competitive analysis (e.g., benchmarking, peer group analysis, ratios, etc.)
    • Determining and assessing the seasonality of an industry or business
    • Common statistical concepts
  • Building financial projections
    • Financial statement projections (e.g., income statement, cash flow statement, balance sheet, etc.)
    • Capital expenditure/investment analysis
      • Discounted cash flow analysis
      • Return on investment projections
      • Net present value projections
    • Sales volume/revenue projections
    • Expense and head count (staffing) projections
    • Specific customer/deal/product projections
    • “What-if” scenarios, sensitivity analysis and risk analysis
  • Using technology/software
    • Basic and advanced spreadsheet functions
      • Financial functions
      • Pivot tables
      • Value lookups
      • Macros
      • Integration with other common software
    • Common statistical calculations (e.g., standard deviation, expected value, correlation, regression, means, modes, etc.) using a spreadsheet
    • Documenting and maintaining models (e.g., understand documentation concepts, document assumptions, create supporting information and protocols, document functionality and structure, use software/data version control concepts and techniques, etc.)
    • Common database structures, common database functions, and structure/ functions of common financial software/systems
      • Business intelligence software
      • Enterprise resource planning (ERP) systems
      • General ledger systems

Meirc Professional Certificate (MPC)

MPC certified courses by Meirc Training and Consulting are designed for those willing to challenge themselves and go the extra distance. Participants who fully attend an MPC course and successfully complete the test on the last day, will receive a Meirc Professional Certificate (MPC), in addition to the one they receive for attendance. MPC certificates are regionally recognized and can be quite valuable when applying for more senior roles within the organization or outside.


National Association of State Boards of Accountancy (NASBA)

Meirc Training & Consulting 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

Visit Website Check the Courses
Per participant

USD 5,200

Fees + VAT as applicable

Tax Registration Number : 100239834300003

(including coffee breaks and a buffet lunch daily)

2021 - Location & Date

5 Days Course

No Schedules!
Please Contact Us if you have any queries..

Schedule for Me
Meirc reserves the right to alter dates, content, venue and trainer.

This course is currently unscheduled in Virtual Learning.

Request this course as Virtual Learning