FP&A Interview Questions 2026: 48 Questions with Answers — and Real Data to Practise On
Anyone can read the answer. Interviewers can tell who has done the work.
48 FP&A and financial analyst interview questions, from the three statements to the strategic questions asked of FP&A managers — each with a short answer and a free DATA DARE dataset to practise it on real finance data before the interview.
By findi360 · Updated 18 November 2026 · Sources · Discussion (0)
The short answer
FP&A interviews ask about seven things: the three statements, budgeting and forecasting, variance analysis, cash and working capital, Excel and Power BI, case questions and — for senior roles — how you would run the budget and report to the board. Learn the answers below, then practise each one on a real dataset, so you can talk about work you have done rather than definitions.
This page at a glance
Seven topics, from the three statements to the questions asked of FP&A managers — every question with a short answer and a dataset to practise on.
- 48 questions with answers Grouped the way interviews run: basics first, strategy last.
- 7 topics Statements, forecasting, variance, cash, tools, cases, strategy.
- 19 DATA DARE sets Free finance datasets with graded questions — one linked to every answer.
What FP&A interviewers really test
Most FP&A and financial analyst interviews check three things: judgement (not just formulas), the "so what" after every number, and numbers that tie back to the ledger.
Definitions are easy to look up — and any AI assistant can recite them. What sets a candidate apart is having done the work: built a forecast, explained a variance, reconciled a report to the trial balance. That is why every answer below links to a DATA DARE set where you can do exactly that, on real finance data, before the interview.
Basics and the three statements
What every FP&A, financial analyst and management accountant interview starts with.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 1. Walk me through the three statements and how they link. | Net profit flows into retained earnings and starts the cash flow statement. Non-cash items and working-capital changes bridge profit to cash, and closing cash lands on the balance sheet. | DD-GLT-001 · General ledger & trial balance |
| 2. If depreciation goes up by 10, what happens to the three statements? | Profit falls by 10 × (1 – tax rate). Cash rises by the tax saved, because depreciation is not cash. Fixed assets fall by 10 and equity by the after-tax amount — the balance sheet still balances. | DD-GLT-001 · General ledger & trial balance |
| 3. What is the difference between FP&A and financial accounting? | Financial accounting records what happened, under the rules. FP&A explains why it happened and what happens next — budgets, forecasts and the story behind the numbers. | DD-GLT-001 · General ledger & trial balance |
| 4. Why does a profitable company run out of cash? | Working capital: receivables and stock grow faster than payables. Heavy capital spending or debt repayments can do the same. | DD-WCP-001 · Working capital |
| 5. How do you check a trial balance before you analyse anything? | Debits equal credits in every period, no account is left unmapped, opening plus movement equals closing, and suspense is cleared. | DD-GLT-001 · General ledger & trial balance |
| 6. What is EBITDA, and when is it misleading? | Profit before interest, tax, depreciation and amortisation. It misleads in capital-heavy businesses, and when "adjustments" keep growing. | DD-GLT-003 · Month-end close, four formats |
| 7. Accrual vs cash — give a month-end example. | A December bill received in January is a December cost; the cash leaves in January. Cut-off decides which month carries it. | DD-APY-002 · Payables, cut-off and GRNI |
Budgeting and forecasting
The heart of FP&A: how the plan is built and how it is kept honest.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 8. Top-down vs bottom-up budgeting — which is better? | Top-down sets targets from leadership; bottom-up builds from the cost centres. Most companies meet in the middle and reconcile the two. | DD-BVA-001 · Budget vs actual |
| 9. What is a driver-based forecast? | You forecast the drivers — volume, price, headcount, rates — and let the money follow. Change a driver and the whole P&L moves with it. | DD-HRM-001 · Payroll |
| 10. What is a rolling forecast, and why use it? | A forecast that always looks the same number of months ahead (say 12), updated every month. It removes the year-end cliff and keeps the plan current. | DD-BVA-003 · Budgets and forecasts by cost centre |
| 11. Zero-based budgeting — pros and cons? | Every cost is justified from zero. It finds waste, but it is slow and heavy to repeat every year. | DD-BVA-001 · Budget vs actual |
| 12. How would you forecast revenue for a new product? | Market size × reach × conversion × price, tested against similar launches. Show a range, not one number. | DD-CRM-001 · Quotes, targets and sales |
| 13. How do you forecast payroll? | Headcount by grade × salary, plus the timing of joiners and leavers, overtime, allowances, end-of-service benefits and annual increases. | DD-HRM-001 · Payroll |
| 14. How would you build a 13-week cash flow forecast? | Start from opening cash. Receipts come from the AR ageing and customer patterns; payments from supplier terms and payroll dates, week by week. Compare forecast to actual every week. | DD-CFP-001 · 13-week cash flow |
| 15. How accurate should a forecast be, and how do you measure it? | Track forecast vs actual by line (percentage error or MAPE). Aim first for no bias — misses that are not always on the same side. | DD-CFP-002 · Cash forecast vs actual |
| 16. How do you handle seasonality? | Compare like with like (same month last year), use seasonal indices or same-period averages, and say so in the commentary. | DD-BVA-001 · Budget vs actual |
Variance analysis and performance
Variance analysis is the most-asked FP&A topic — and the one where judgement shows.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 17. What is variance analysis? | Actual against budget, forecast or last year, split into its causes and explained in words someone can act on. | DD-BVA-001 · Budget vs actual |
| 18. Split a revenue variance into price, volume and mix. | Volume = change in quantity × budget price. Price = change in price × actual quantity. Mix = the change in product share, valued at budget margin. | DD-BVA-001 · Budget vs actual |
| 19. Is a favourable variance always good news? | No. Low spending can mean a delayed project or a hiring freeze that will hurt next quarter. | DD-BVA-001 · Budget vs actual |
| 20. Which KPIs would you put on a CFO dashboard? | Revenue vs plan, gross margin, EBITDA, cash and runway, DSO, DPO and DIO, people cost and forecast accuracy. | DD-WCP-001 · Working capital |
| 21. How do you explain a variance to a non-finance manager? | One sentence of cause, one number, one action — no accounting words. | DD-BVA-001 · Budget vs actual |
| 22. YoY vs MoM — when does each mislead? | Month on month is distorted by seasonality and working days; year on year by last year's one-offs. Show both, with notes. | DD-GLT-001 · General ledger & trial balance |
Cash and working capital
Cash questions separate analysts who read reports from analysts who understand the business.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 23. What are DSO, DPO, DIO and the cash conversion cycle? | Days to collect, days to pay and days stock sits. Cash conversion cycle = DSO + DIO – DPO. | DD-WCP-001 · Working capital |
| 24. How would you reduce DSO? | Clean invoicing, enforced terms, follow-up from the ageing, early-payment discounts and credit limits. | DD-ARC-001 · Receivables |
| 25. What does an AR ageing tell you? | Who owes how much, and for how long — the starting point for collections and for the bad-debt provision. | DD-ARC-001 · Receivables |
| 26. How do you estimate expected credit loss on receivables (IFRS 9)? | Loss rates by ageing bucket from history, adjusted for forward-looking conditions — the provision matrix for trade receivables. | DD-ARC-002 · Receivables and remittances |
| 27. How do you catch duplicate supplier payments? | Match supplier, amount, invoice number (allowing for typos) and a date window, and check every change of bank details. | DD-APY-001 · Accounts payable |
| 28. Why might a company pay suppliers early? | When the early-payment discount is worth more than its cost of funds, or to secure supply. | DD-APY-002 · Payables, cut-off and GRNI |
Excel, Power BI, SQL and Python
Tool questions are where a practical test usually comes in.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 29. XLOOKUP or INDEX/MATCH? | Both look values up. XLOOKUP is simpler and searches in either direction; INDEX/MATCH works in every version of Excel. | DD-GLT-001 · General ledger & trial balance |
| 30. How do you keep a large Excel model reliable? | Inputs in one place, no typed numbers inside formulas, a checks row, the same formula across every period, and a version log. | DD-BVA-001 · Budget vs actual |
| 31. In Power BI, what is a star schema and why does it matter? | Facts in the middle, dimensions around them. Filters flow one way, DAX stays simple and reports stay fast. | DD-GLT-003 · Month-end close, four formats |
| 32. Why do you need a date table in Power BI? | Time intelligence — year to date, same period last year — needs a continuous date table marked as the date table. | DD-INV-002 · Stock, counts and transfers |
| 33. Explain CALCULATE in one line. | It evaluates an expression under a changed filter context. | DD-BVA-001 · Budget vs actual |
| 34. Write SQL for revenue by month with last year beside it. | GROUP BY month, then a window function (LAG over 12 months) or a self-join on month minus one year. | DD-GLT-003 · Month-end close, four formats |
| 35. When would you use Python instead of Excel? | When the data is too big or too messy, the work repeats every month, many files must be combined, or the model will not fit in a workbook. | DD-TRF-002 · Data transformation |
| 36. CSV, Excel or Parquet — does the file format matter? | Yes. Formats change speed and data types: a CSV can silently turn account codes into numbers, and Excel stops at 1,048,576 rows. | DD-GLT-003 · Month-end close, four formats |
Case and behavioural questions
The questions that decide close calls between candidates.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 37. Costs are 8% over budget with two weeks to year-end. What do you do? | Find the drivers, separate timing from real overspend, set out options with their cash effect, and recommend one. | DD-BVA-001 · Budget vs actual |
| 38. Two subsidiaries report in different currencies. How do you consolidate? | Translate (P&L at average rates, balance sheet at closing rates), eliminate intercompany balances and profit, and book the translation difference in equity. | DD-CON-002 · Group consolidation |
| 39. Tell me about a time your numbers were wrong. | Own it, explain how you found it, and show the check you added so it cannot happen again. | DD-GLT-001 · General ledger & trial balance |
| 40. What would you do in your first 90 days in our FP&A team? | Learn the close and the model, map the data sources, fix one painful report and earn trust with a quick win. | DD-BVA-001 · Budget vs actual |
Strategic questions for FP&A managers and senior roles
For FP&A manager, senior analyst and head of FP&A interviews: no single right answer — these test how you think and how you run the process.
| Question | What a strong answer covers | Practise on |
|---|---|---|
| 41. A top-line budget is easy. Breaking it down by subsidiary, department, month, unit and staff — then comparing with actuals on time — is not. How would you manage it, and what is the biggest challenge? | A budget calendar with named owners; one driver model (volumes, prices, headcount by grade) instead of typed numbers; templates locked to the same accounts and cost centres as the ledger; phasing rules for seasonality, working days and hiring dates; the bottom-up reconciled back to the top-down target. Use the same mapping for actuals, so budget vs actual comes straight out of the close on a fixed reporting day. The biggest challenge: keeping the budget structure and the ledger in step through re-organisations and new cost centres — and getting managers to own realistic numbers rather than padded ones. | DD-BVA-003 · Budgets and forecasts by cost centre |
| 42. The CEO and board want the numbers one way, the CFO another. You report to the CFO. What do you fix before the report goes up? | One source of truth: the board view must reconcile to the CFO pack, with a bridge for every difference. Move from accounting lines to business drivers — segments, KPIs, cash. Show one-offs, FX and accounting-policy effects (such as IFRS 16) separately so the underlying trend is clear. Keep definitions the same every month. Fewer numbers, more forward-looking: forecast, risks and decisions needed. Agree every adjustment with the CFO first. | DD-CON-002 · Group consolidation |
| 43. At half-year the business is 10% behind its annual target. What do you put in front of the CFO? | A gap bridge (price, volume, mix, cost, timing), run-rate against plan, a reforecast with two or three scenarios, the levers that can still close the gap with their cash effect, and the decisions needed this month. | DD-BVA-001 · Budget vs actual |
| 44. How would you build a forecast process the business actually trusts? | Track and share forecast accuracy, give every line an owner, use drivers people recognise, cut the number of lines, keep a fixed monthly rhythm, and explain misses without blame. | DD-CFP-002 · Cash forecast vs actual |
| 45. Finance and operations disagree on the same number. How do you settle it? | Reconcile the definitions first (period, scope, units), agree one source system and one data owner, write the rule down, and show both numbers with a bridge until the change is in place. | DD-INV-002 · Stock, counts and transfers |
| 46. If you could automate one part of month-end reporting, which part and why? | The most manual, repeated and error-prone step — usually collecting and mapping data from several files or systems. Automate it with Power Query, Python or Power BI so people spend their time explaining, not copying. | DD-TRF-004 · Monthly Parquet files |
| 47. How would you decide whether to invest in a new tool — Power BI, Microsoft Fabric or an FP&A system? | Start from the problem and what today's way costs, check that the data is ready and owned, run a small pilot with a measurable result, plan adoption and training, then scale. | DD-CON-004 · Multi-ERP group close |
| 48. Where will AI help FP&A in the next three years, and where should people stay in charge? | AI helps with first drafts of commentary, spotting anomalies, baseline forecasts, matching and reconciliations, and faster queries. People stay in charge of assumptions, judgement, ownership of the numbers, controls and the conversation with the business. | DD-MFG-005 · 12-million-line ledger |
The practice ladder: one set a week before the interview
DATA DARE sets climb the same ladder as real finance data. Start where you are comfortable and go one level higher.
- L1 One workbook Budget vs actual, receivables, payroll, cash — all tables in one Excel file. Start with DD-BVA-001.
- L2 Several files CSV, JSON and Excel tables to join, with no date table given. Try DD-CON-002 or DD-INV-002.
- L3 Messy formats Parquet journals, nested JSON bank statements, a month-end close. DD-GLT-003.
- L4 Millions of rows A 6.9-million-line group close across several ERPs. DD-CON-004.
- L5 About 12 million lines, three ERPs The mapping is written in a manual, not given as a table. DD-MFG-005.
How to answer an FP&A case question in five steps
- Clarify — ask what decision the number is for, and by when.
- Structure — say how you will break the problem down before you calculate.
- Numbers — work through the drivers, not just the totals.
- Sense-check — compare with last year, the budget and a simple ratio.
- Recommend — one clear action, with its cash effect and the risk.
Download the questions and practise
The question workbook has all 48 questions and answers by topic, the DATA DARE set for each one, and a checklist to track what you have practised. Pick one set a week before the interview — then talk about what you found, not what you read.
Questions people ask
What are the most common FP&A interview questions?
Expect the three statements and how they link, budgeting vs forecasting, variance analysis (price, volume and mix), a 13-week cash flow forecast, working capital (DSO, DIO, DPO), an Excel or Power BI task and at least one case question. This page has 48 of them with answers.
How do I prepare for an FP&A interview?
Revise the seven topics, then practise on real data: build a budget vs actual, a cash forecast and a variance bridge on a free DATA DARE dataset. Prepare three short stories about work you have done, and read the company's latest results.
What is variance analysis in FP&A?
Comparing actual results with budget, forecast or last year, splitting the difference into its causes (such as price, volume and mix) and explaining it in words a manager can act on.
What is the difference between a budget and a forecast?
A budget is the plan agreed before the year starts and usually stays fixed. A forecast is the latest view of where the year will land, updated as actuals come in — often as a rolling 12-month forecast.
What questions are asked in an FP&A manager interview?
Strategic ones: how you would cascade a budget to subsidiaries, departments, months and staff and report against actuals on time; how you would adapt the CFO pack for the CEO and board; how you would build a forecast the business trusts. Eight are answered on this page.
What Excel and Power BI skills do FP&A interviews test?
Lookups (XLOOKUP or INDEX/MATCH), reliable model structure, pivot tables, and in Power BI a star schema, a date table and basic DAX such as CALCULATE. Many interviews include a short practical test on a dataset.
Where can I practise FP&A with real data?
On findi360's DATA DARE: free finance datasets with graded questions — budget vs actual, cash flow, receivables, payroll, consolidation and more — from one Excel workbook at Level 1 to about 12 million ledger lines at Level 5.
Get the data and share the story
Question workbook (Excel) — all 48 questions and answers by topic, the DATA DARE set for each, and a checklist to track your practice.
The questions in 10 slides (PDF) — open to everyone, ready to share.
Downloads need a findi360 account — create one in a minute and the file starts straight away. Already a member? Sign in
Which kind of interview question worries you most?
- Accounting basics 0
- Budgeting and forecasting 0
- Excel and Power BI tests 0
- Case studies 0
- Strategic questions 0
0 members have picked so far. Each member counts once, with their latest pick.
Sign in to add your view and your pick — it takes a minute.
No comments yet — be the first to answer.
Sources
| Figure | Source | Date |
|---|---|---|
| Questions and answers | findi360 editorial team | 18 Nov 2026 |
| Excel: 1,048,576 rows × 16,384 columns per sheet | Microsoft Support — Excel specifications and limits | 2026 |
| Expected credit loss: simplified approach and provision matrix for trade receivables | IFRS Foundation — IFRS 9 Financial Instruments | 2026 |
| Practice datasets | DATA DARE (findi360) | Nov 2026 |
Read before quoting a figure
- The answers are short starting points. Interviewers want your own examples — use the datasets to build them.
- Questions are grouped by topic, not by how often a particular company asks them.
Keep going on findi360
- DATA DARE Start with DD-BVA-001 — budget vs actual One workbook, graded questions: the variance questions on this page, for real.
- GUIDES Budget vs actual in Python The same analysis in pandas, with tested code.
- DATA STORY CSV vs Excel vs JSON vs Parquet Question 36, answered with a test on 1 million ledger lines.
Compiled by findi360 from the public sources listed above. Not investment advice. © findi360 — share freely with attribution. Visit findi360 to learn data and finance.