All tracks

FP&A interview prep

Advanced 40 min 4 exercises

Practice the Excel tasks Financial Planning & Analysis (FP&A) interviews often test: revenue variance, break-even analysis, contribution margin, and year-over-year sales changes.

What you'll learn

  • Decompose period-over-period revenue change into volume and price effects using SUMPRODUCT
  • Calculate break-even units from fixed costs, variable costs, and unit price
  • Compute contribution margin and contribution margin % per product
  • Compare current-month sales against the same month a year ago using SUMIFS with date functions

Functions you'll practice

DATE MONTH SUM SUMIFS SUMPRODUCT YEAR
Start track

Exercises in this track

0 of 4 completed 0%
1

Revenue waterfall decomposition

Intermediate

Break a revenue change into volume and price effects, a core FP&A variance analysis skill.

SUMPRODUCT
Start
2

Break-even units

Intermediate

Calculate how many units need to be sold to break even.

SUM
Start
3

Contribution margin

Intermediate

Calculate contribution margin and contribution margin % for each product.

SUM
Start
4

Year-over-year comparison

Advanced

Calculate % change comparing this month's sales to same month last year.

SUMIFS DATE YEAR MONTH
Start
Start track

Where to go next

Pick another track

Browse all learning tracks to find your next focus area.

Browse all tracks

Build on what you learned

When you're ready for the step after Excel, here's where we'd point you next.

Ready to get certified in finance?

Once you've put the modeling work in, the FMVA from CFI makes it official. It's the credential finance and FP&A teams actually recognize, and it's hands-on, not just theory.

This is an affiliate link. A purchase helps support the site.

Explore the FMVA program(affiliate link)