👋 Hi, it’s CJ Gustafson and welcome to Mostly Metrics, my weekly newsletter where I unpack how the world’s best CFOs and business experts use metrics to make better decisions.
My Favorite FP&A Interview Questions
After spending 20,000 hours building FP&A teams, I’ve learned the hard way what separates good from great talent.
I’ve made great hires. I’ve made terrible hires. Some turned into CFOs. Some left under the cover of night, leaving behind mysterious Sumifs in v147 of the planning model that no one dared unravel.
You can learn from my wins and losses.
When it comes to hiring FP&A candidates, I look for a mix of technical prowess, strategic insight, and the ability to communicate effectively (bonus points for taste in GIFs).
Below are my favorite questions to gauge whether a candidate has what it takes. It’s inspired by the wonderful guide wrote on hiring Product Managers.
This guide is helpful for both those HIRING top talent, as well as those preparing to LAND their dream FP&A job.
Favorite question to start with
Tell me about a time you built a financial model. What was its purpose, and what was the most sensitive variable in the model?
Why I love this question: Because every FP&A pro has one model they secretly consider their masterpiece. This question is about pride, pain, and whether they know which lever can break the whole thing in two clicks.
What to look for:
Who was the model built for? It’s a key insight into who they were partnering with (e.g., CMO? CRO?), and the types of problems they were trusted with solving (complete budgeting process? pipeline analysis? headcount forecasting?)
Proper identification of the most sensitive variable cuts through a lot of noise. This will tell you if they truly “get it”
How they structured the model - was there a summary table at the front? Where did the raw data sit?
Flags:
The example they pick is not very important—likely means they haven’t worked on anything meaty
It was built with just one type of data (e.g., ONLY financial data… did not incorporate product or sales data)
Lack of modularity - couldn’t be broken into component parts for different audiences
Favorite question to understand their strategic thinking
What KPIs do you think are the most important for our business, and why?
Why I love this question: I’m looking for how well they understand our company's drivers and whether they can translate that into key performance indicators. It also reveals if they understand how your company actually makes money, or if they just skimmed the website.
What to look for:
A clear understanding for how you monetize (is this a marketplace or a SaaS model? Are you the middle man? How do you distribute your product?)
An understanding as to how deal size and average customer size impact your operations
Ability to tie ownership of metrics back to key people within the org
Flags:
Only relying on financial metrics
Citing compound metrics (like LTV to CAC) without identifying the nuanced levers behind them
If they give cumulative metrics that lack trend and the ability to decrease (like all time downloads, bugs fixed etc.) or vanity metrics (NPS, CSAT)
Favorite question to test communication skills
(Keep reading for questions that test for prioritization skills, owning mistakes, technical skills, and self-awareness)
Pretend I’m a family member at a holiday party who doesn’t have a financial background. I ask you to explain what you do for a living. Give me a breakdown of what FP&A does in the simplest terms.
Why I love this question: FP&A professionals need to communicate financial insights to non-financial stakeholders. Your CTO does not have a finance degree. This question tests their ability to distill complex data into something digestible for different audiences, which is crucial for working with people outside the group.
What to look for:
How they talk about “budgets” and use real-life analogies (e.g., running a lemonade stand)
Whether they can explain concepts like tradeoffs, forecasting, and resourcing using layman-friendly examples
Do they inject a bit of humor or storytelling? That’s a bonus — people who can teach usually understand deeply. In order to use humor, you need to understand a concept to its core.
Flags:
Overreliance on buzzwords and financial jargon
A blank stare or a rambling answer that never lands the plane
Sounding too “robotic” — this should be a relatable moment, not a PowerPoint presentation in disguise… your Aunt Linda doesn’t care about your ARR waterfall.
Favorite question to test their problem-solving ability
Tell me about a time when your forecast was significantly off. How did you handle it, and what did you learn?
Why I love this question: Every operator has lived through a miss. What separates the pros is how quickly they diagnose the issue and get stakeholders aligned on the fix. I don’t just want someone who caught the error — I want someone who rallied the org to do something about it.
Plus, no one trusts a forecaster who’s never been humbled by reality.
What to look for:
Honesty and fallibility — are they willing to own the miss?
Owning it is MOST important to me. Counterintuitively, I want you to admit fault to look good here.
A clear breakdown of the root cause of the variance (e.g., did pipeline conversion crater? Was there a pricing change they didn’t factor in?)
A proactive approach to course-correcting — did they change inputs? Talk to stakeholders? Update their assumptions?
Flags:
Placing blame entirely on another team or macro conditions
Vague answers that don’t identify what was off or why it mattered
Saying “I’ve never had a forecast be wrong” — that’s either untrue or they haven’t done meaningful forecasting
Fixating on a minor miss (e.g., “we were off by 2% in office snacks”) instead of a real business impact. Cool, but I’m not looking for the VP of Pretzels.
Favorite question to test cross-functional collaboration
How do you approach working with non-financial teams (like sales, marketing, or operations) to build financial plans?
Why I love this question: This question reveals their collaboration skills and their ability to balance various teams' needs while coloring within the lines.
Have they ever had to say no to a head of sales? That’s the kind of scar tissue I’m looking for. Someone who can be consultative without being a pushover.
What to look for:
How they collect inputs — do they start with a blank template and ask open-ended questions, or do they show up with assumptions and pressure stakeholders to sign off?
The cadence they recommend — good candidates will talk about check-ins that are monthly (not once a year), and proactively surfacing deltas
How they frame concepts like “budget envelopes” and “max headcount forecasts” in a way that’s empathetic but still firm — do they understand the art of pushing back constructively?
Bonus points if they mention customizing how they engage based on the team — e.g., slack-first for sales, Notion docs for marketing, verbal walk-throughs for ops
Flags:
Not meeting the department (customer) where they want to interact (transact)
Overly rigid templates — if you hear “I just send out a spreadsheet and wait for them to fill it out,” that’s a red flag
Long gaps between check-ins — if they only talk to teams at annual planning time, you’re gonna be in reforecast purgatory all year
Gatekeeper vs. partner vibes
Favorite question to test ownership and impact
Tell me about a time when you used financial data to influence a major business decision.
Why I love this question: This question is designed to reveal the candidate's ability to go beyond reporting numbers. I’m looking for someone who can leverage data to influence key decisions and demonstrate their impact on the business. Because building a model is table stakes—changing a strategy because of it is the job. If you didn’t shape the outcome, you didn’t finish the assignment.
What to look for:
Did they properly frame the question the business was wrestling with? (e.g., “Should we launch in EMEA this year?”, “Do we hire 10 more reps or invest in brand marketing?”). It needs to start with a CLEAR problem statement.
How did they package the insight? Did they turn messy data into a compelling narrative, or at least a clean slide that said, “Here’s what the numbers are telling us”?
Did they actually change the outcome? It’s one thing to run an analysis. It’s another to push an exec team to pivot because of it. What was the change that happened?
Bonus: Did they pre-wire stakeholders or use influence to tee up the conversation ahead of time?
Flags:
Answers that focus only on “what they built” instead of the decision it enabled
No mention of cross-functional stakeholders (this is rarely done in a vacuum)
Can’t tie it back to an actual impact — if your analysis doesn’t drive action, it’s just math homework
Favorite question to test prioritization skills
How do you prioritize when you have multiple deadlines during budgeting or reporting cycles?
Why I love this question: FP&A professionals often have to juggle many priorities, especially during critical periods. This question tests their time management skills and how they make trade-offs when everything seems equally urgent. Because in FP&A, everything is urgent—but not everything is important.
What to look for:
Do they mention creating a triage system (e.g., red/yellow/green tasks or Eisenhower Matrix)? That’s someone who’s done this in the trenches.
Whether they distinguish between urgent vs. important — knowing when a board pack needs to be perfect versus when a budget template can be 80/20
Signs they communicate up — strong candidates keep their manager and cross-functional partners informed of shifting priorities, rather than silently dropping the ball
Bonus: Mention of tools or rituals they use (e.g., morning standups, Monday planning docs, async updates via Slack)
Flags:
“I just work longer hours” — not a strategy, just a burnout plan
Equal priority for all tasks (dead giveaway they haven’t led a cycle before)
Doesn’t mention collaboration or managing expectations — prioritization doesn’t happen in a vacuum
Fails to mention key dependencies or how delays in one area impact others
Favorite question to test technical skills
What tools and technologies do you use for financial analysis, and how do they improve your work?
Why I love this question: Technology plays a big role in FP&A, from Excel to advanced planning tools. I’m looking for candidates who are proficient with the latest technologies and can explain how they leverage these tools for better analysis and reporting.
Extra points if they’ve built a duct-taped system between Salesforce, Netsuite, and Looker — that’s the gritty middle zone where most real-world analysis happens. If they’ve only ever worked with pristine dashboards, they probably haven’t lived through a budget cycle.
What to look for:
Clear differentiation between what tool they use and why they use it — e.g., “I use Excel for quick-and-dirty modeling, but we use Aleph for collaborative planning.”
Evidence they’ve worked in more than just spreadsheets — bonus points for familiarity with ERP systems, BI tools (e.g., Looker, Tableau), or planning platforms like Anaplan, Planful, Pigment, Runway, etc.
How tools improve workflow, not just output — do they talk about version control, real-time collaboration, or integrations with systems like Salesforce or NetSuite?
Flags:
“I mostly use Excel and Google Sheets” — not a dealbreaker, but needs context (have they at least built macros or worked with PowerBI?)
Can’t name the company’s data warehouse — red flag for lack of involvement in upstream data
Mentions flashy tools but can’t explain how they used them
Mention of groups of tools you would never use together (no company uses two HRIS modules)
Potential Follow Up:
If they’ve never had to manually backsolve CAC from marketing spend, HubSpot leads, and a Frankenstein CRM export... they’ve never really lived.
Favorite question to test for self-awareness
What do you think is the most important trait for an FP&A professional to succeed in this role?
Why I love this question: This question gives me insight into the candidate’s values and how they approach their work. It also helps me see if their personal philosophy aligns with the culture and goals of the company.
Let’s be honest: Most of FP&A is unglamorous… late nights, half-baked inputs, and calming execs who just found out their favorite pet project is getting defunded. If a candidate can’t articulate how they mentally weather that, they might not be ready for the role.
What to look for:
Answers that go beyond “detail-oriented” — strong candidates might say curiosity or the ability to zoom in and out (e.g., operate at different “altitudes”)
A personal anecdote to back up their answer — do they explain how they’ve seen that trait play out in their work (or where they had to learn it the hard way)?
Recognition that this role is as much about relationships as it is about reporting
Bonus if they balance hard and soft skills — e.g., “You need to be technically sharp, but what separates great from good is being able to simplify for others”
Flags:
Vague, generic traits without substance (“I’m a hard worker”)
Traits that are table stakes (e.g., “You have to like numbers”) — cool, but we’re past that
Over-indexing on a trait that doesn’t match the role (e.g., “perfectionism” in a fast-moving startup = bottleneck)
No self-reflection — if they can’t describe what matters in this job, they likely haven’t done it at a high level
These questions won’t just help you hire better FP&A talent — they’ll also make you better at the job. Use them. Adapt them. And if you’ve got a favorite I missed, hit reply or drop it in the comments — I’m always on the hunt.
