Wall Street Prep

Where strategy and analysis meet

Solid financial modeling and forecasting know-how is just one part of the FP&A professional’s toolbox. This challenging position requires a cross-functional understanding of accounting, finance, corporate strategy and industry dynamics. Advanced Excel proficiency is required to sort through data from a network of disparate sources. In addition to technical skills, “soft skills” such as leadership and presentation acumen are used to answer to the CFO, the CEO and financial sponsors. Wall Street Prep’s FP&A Technical Mastery Program will equip your hires with this full range of skills and provide continuing ed to keep their skills sharp.

Working with FP&A teams from the world’s leading companies since 2004

FP&A Mastery Program Curriculum

This training program is designed to fill the knowledge gaps we’ve seen FP&A and corporate finance professionals exhibit again and again in our years of training at top financial institutions. It will hone the technical skills your team uses most while enforcing across-the-board analysis and forecasting consistency and best practices.

  • Duration: 1/2 Day

    Module 1: Financial Accounting

    • The income statement
    • Operating profit and EBITDA
    • Non-operating income and expenses
    • Stock based compensation and other non-cash expenses
    • Reserves and nonrecurring items
    • The balance sheet
    • The cash flow statement
    • Understanding how the financial statements are connected
  • Duration: 1/2 Day

    Module 2: Financial Statement Analysis

    • Understanding key relationships across the financial statements
    • Best practices for calculating key profitability, liquidity, activity and solvency ratios
    • Impact of typical “Non GAAP” disclosures on profitability and ratios
    • How accrual accounting and GAAP classifications impacts net income
  • Duration: 1 Day

    Module 3: Being More Efficient with Excel

    • Mastering Excel keyboard shortcuts and other tips and tricks
    • Excel formulas and functions
    • Mathematical functions
    • Using text functions to solve data extraction problems
    • Using COLUMN and ROW functions as counters in complex formulas
    • Logical, date & concatenation functions
  • Duration: 1/2 Day

    Module 4: The power of Excel’s lookup & reference

    • Key functions and best practices for working with large data sets
    • HLOOKUP, VLOOKUP, OFFSET, CHOOSE and INDEX are your friends – treat them right
    • Combining reference functions with MATCH to create fully dynamic and rugged formulas
    • Demystifying the INDIRECT function and guidelines around implementation
    • Advanced conditional formatting
  • Duration: 1/2 Day

    Module 5: Excel Modeling Best Practices

    • Best practices around the structural design of spreadsheets
    • Common mistakes around organizing your model’s inputs and outputs
    • Model timing architecture: monthly, quarterly and annual periods
    • Best practices for working with general ledger data from external databases
    • Preferred approaches for pulling division-level data from multiple models
  • Duration: 1 Day

    Module 6: Financial Statement Modeling

    • Maintaining consistent and transparent model assumptions & drivers
    • Income statement historicals & forecasting
    • Segment-based revenue buildup
    • Forecasting working capital, long term assets & liabilities
    • Modeling debt and equity items
    • Modeling cash flows
    • Understanding and handling model plugs & circularity
  • Duration: 1 Day

    Module 7: Analyzing Excel’s Model Outputs and Variance Testing

    • Data tables, pivot tables and presentation best practices
    • Building scenarios and sensitivity analysis
    • Building effective dashboards into analysis and using switches
    • Adding error-proofing and checks into analysis
    • Best practices for variance analysis & testing
  • Duration: 1/2 Day

    Module 8: How the Street Values Us

    • Introduction to valuation
    • The discounted cash flow analysis
    • Comparable company and comparable transaction analysis
    • Understanding value drivers of multiples used to value your company
    • Does net income really matter? Understanding both the impact and limitation of net income on valuation
  • Duration: 1/2 Day

    Module 9: Soft Skills for New Hires

    • The critical role of FP&A within the organization
    • Negotiations and pitching for success
    • Managing a team
    • Presenting to management and sponsors
    • Understanding how management guidance affects the sell-side and vice versa

The Wall Street Prep FP&A Technical Mastery Program is approved for up to 27 FP&A recertification credits by the Association for Financial Professionals at the rate of one credit for each 50 minutes of attendance.

Speak with us about our FP&A programs

To learn more about the Financial Planning & Analysis Technical Mastery Program, including pricing, training engagement schedule and individual FP&A training options, fill out the form below or call us at 617-314-7685.


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.