FP&A Interview Questions and Answers for Freshers

An FP&A interview can be challenging for a fresher because the role sits between accounting, financial analysis and business decision-making. You may know the basics of accounting from your commerce degree, but the interviewer also wants to see whether you can understand budgets, forecasts, variances and business performance.

The good news is that you do not need years of FP&A experience to prepare well.

For entry-level roles, most FP&A interview questions focus on financial statements, budgeting, forecasting, variance analysis, Excel, business scenarios and your ability to explain numbers clearly.

What Do Interviewers Look for in an FP&A Fresher?

An FP&A team works with financial information to help a business plan, monitor performance and make decisions.

For a fresher, interviewers may look for:

• Accounting fundamentals
• Financial statement knowledge
• Excel skills
• Budgeting knowledge
• Forecasting basics
• Variance analysis
• Financial modelling
• Business understanding
• Analytical thinking
• Communication skills

There is one important distinction to understand.

FP&A is not just about preparing reports. You should be able to explain what changed, why it changed and what the business might need to do next.

Basic Accounting Questions for FP&A Interviews

1. What are the three financial statements?

The three main financial statements are:

• Income Statement: Shows revenue, expenses and profit or loss over a period.
• Balance Sheet: Shows assets, liabilities and shareholders’ equity at a particular point in time.
• Cash Flow Statement: Shows cash inflows and outflows from operating, investing and financing activities.

For FP&A, understanding the connection between these statements is more important than simply memorising their definitions.

2. How are the three financial statements connected?

The income statement shows the company’s financial performance.

Net income affects retained earnings within shareholders’ equity. The cash flow statement explains changes in cash during the period, while the balance sheet shows the company’s financial position at the end of the period.

An interviewer may give you a simple transaction and ask how it affects all three statements.

3. What is working capital?

Working capital is commonly calculated as:

Current Assets − Current Liabilities

Important components include:

• Accounts receivable
• Inventory
• Accounts payable
• Other current assets
• Other current liabilities

Working capital matters in FP&A because changes in operating assets and liabilities can affect cash requirements.

Budgeting Questions Every Fresher Should Know

4. What is a budget?

A budget is a financial plan for a future period.

It may include expectations for:

• Revenue
• Operating expenses
• Headcount
• Capital expenditure
• Cash requirements
• Profitability

FP&A teams often work with different departments to collect assumptions and build or consolidate budgets.

5. What is the difference between a budget and a forecast?

A budget is generally the financial plan established for a future period.

A forecast is an updated estimate of what the company currently expects to happen based on new information.

For example, a company may begin the year with a ₹100 crore revenue budget. After several months, actual sales trends may cause the finance team to revise its expected full-year revenue to ₹95 crore.

The original budget has not changed. The forecast has.

6. What is rolling forecasting?

A rolling forecast continuously updates the company’s outlook as new information becomes available.

Instead of preparing one forecast and leaving it unchanged, the company periodically updates assumptions and extends the forecast period.

This can help management work with a more current view of expected business performance.

Variance Analysis Questions

7. What is variance analysis?

Variance analysis compares actual performance with a budget, forecast or other benchmark.

For example:

Metric	Budget	Actual	Variance
Revenue	₹50 lakh	₹46 lakh	-₹4 lakh
Operating Expenses	₹20 lakh	₹23 lakh	+₹3 lakh

The numbers tell you that revenue was below budget and expenses were above budget.

But that’s only the beginning.

An FP&A analyst needs to investigate why those differences occurred.

8. What would you do if expenses were 15% above budget?

Don’t immediately conclude that the finance team made a mistake.

A good approach is to break the variance down.

You could investigate:

• Which expense category caused the increase?
• Was the increase planned or unexpected?
• Was it a one-time expense?
• Did headcount increase?
• Were prices higher than expected?
• Was spending higher because of increased business activity?
• Does the latest forecast need to be updated?

This is the type of thinking that makes variance analysis useful.

9. What is favourable and unfavourable variance?

A favourable variance generally means actual performance is better than the relevant budget or expectation.

An unfavourable variance generally means actual performance is worse than the relevant expectation.

However, the interpretation depends on the metric.

For example, revenue above budget may generally be favourable, while expenses above budget may generally be unfavourable.

Context still matters.

FP&A Interview Questions on Revenue and Profit

10. Revenue increased by 10%, but profit decreased. Why?

There can be several possible explanations.

You might investigate:

• Higher cost of goods sold
• Lower gross margins
• Higher employee costs
• Increased marketing expenses
• Higher interest expense
• Changes in product mix
• Pricing changes
• One-time costs

A strong answer should show that you would examine the income statement rather than assume one reason.

11. What is the difference between gross profit and operating profit?

Gross profit is generally revenue minus the cost of goods sold.

Operating profit takes operating expenses into account as well.

For example, an illustrative company could have:

• Revenue: ₹100 crore
• Cost of goods sold: ₹60 crore
• Gross profit: ₹40 crore
• Operating expenses: ₹25 crore
• Operating profit: ₹15 crore

The example is illustrative, but it shows why analysing only revenue is not enough.

12. Why is cash flow important in FP&A?

A profitable company can still experience cash pressure.

Cash may be tied up in:

• Receivables
• Inventory
• Capital expenditure
• Debt repayments
• Other working-capital requirements

FP&A teams may therefore need to monitor both profitability and cash requirements.

Excel Questions for FP&A Freshers

Excel is one of the most useful tools to prepare before an FP&A interview.

13. Which Excel functions should an FP&A fresher know?

Depending on the role, you should be comfortable with functions and features such as:

• SUM
• SUMIFS
• COUNTIFS
• IF
• XLOOKUP
• INDEX and MATCH
• PivotTables
• Charts
• Conditional formatting
• Sorting and filtering

You do not need to claim advanced Excel skills if you are still learning.

It is better to demonstrate a solid working knowledge than to describe yourself as an Excel expert and struggle with a basic practical test.

14. How would you analyse a large financial dataset in Excel?

A sensible process would be:

1. Understand what the data represents.
2. Check for missing or inconsistent data.
3. Clean and organise the information.
4. Use formulas or PivotTables to summarise it.
5. Calculate relevant metrics.
6. Identify unusual trends or variances.
7. Present the important findings clearly.

The interviewer may care as much about your approach as the particular Excel formula you use.

Financial Modelling Questions

15. What is financial modelling?

Financial modelling involves building a structured representation of a company’s financial performance using historical information and assumptions about the future.

An FP&A model might include:

• Revenue
• Headcount
• Operating expenses
• Capital expenditure
• Working capital
• Profit
• Cash flow
• Forecast scenarios

The key idea is that assumptions drive the model’s outputs.

16. What is scenario analysis?

Scenario analysis examines how financial results could change when assumptions change.

For example, an illustrative business might create:

Scenario	Revenue Growth
Downside	5%
Base Case	10%
Upside	15%

The analyst can then see how each scenario affects revenue, expenses and profit.

This is particularly useful when future performance is uncertain.

Business Scenario Questions

17. Sales are below forecast. How would you analyse the problem?

Start by breaking the problem into drivers.

You might examine:

• Sales volume
• Pricing
• Product mix
• Customer mix
• Region
• Sales channel
• New customer acquisition
• Customer retention
• Seasonality

Suppose total sales are down 8%.

That number alone does not tell you much.

Perhaps one product line is down 20% while the rest of the business is performing normally. Or perhaps sales volume is stable but pricing has changed.

FP&A analysis should help management identify the driver.

18. Revenue is above budget but profit is below budget. What would you check?

Start with the income statement.

Look at:

Revenue → Gross margin → Operating expenses → Operating profit

Then investigate whether:

• Costs increased faster than revenue.
• Product mix changed.
• Discounts reduced margins.
• Employee expenses increased.
• Marketing spending was higher.
• Unexpected costs occurred.

The objective is to move from the headline number to the underlying business driver.

Management Reporting Questions

19. What is management reporting?

Management reporting provides financial and operational information that helps managers understand business performance.

Reports may include:

• Revenue
• Profitability
• Expenses
• Budget variance
• Forecast
• Cash flow
• Key performance indicators

A good management report should make important information easy to understand.

The goal is not to put every available number onto one spreadsheet.

20. What makes a good financial report?

A useful report should be:

• Accurate
• Relevant
• Easy to understand
• Timely
• Consistent
• Focused on important business drivers

For example, if expenses are 20% above budget, simply highlighting the number may not be enough.

Management may also need to know which expense caused the variance and whether it is likely to continue.

Questions About KPIs

21. What is a KPI?

KPI stands for Key Performance Indicator.

A KPI is a metric used to track an important aspect of business performance.

The right KPIs depend on the business.

For a subscription business, useful measures could include:

• Revenue
• Customer acquisition
• Customer retention
• Recurring revenue
• Churn

For a manufacturing company, relevant KPIs may include:

• Production volume
• Capacity utilisation
• Cost per unit
• Gross margin
• Inventory levels

An FP&A analyst should understand that the most useful metrics depend on the business model.

Behavioural FP&A Interview Questions

22. Tell me about yourself.

Keep your answer relevant to the position.

A useful structure is:

Education → Finance interest → Relevant skills/projects → Why FP&A

For example:

I recently completed my B.Com and developed an interest in financial analysis and business planning. During college, I worked on Excel-based financial analysis and budgeting projects, which helped me understand how financial data can be used to evaluate business performance. I am now looking to start my career in FP&A and build my skills in budgeting, forecasting and financial analysis.

Don’t memorise this exact wording. Adapt it to your actual background.

23. Why do you want to work in FP&A?

Avoid saying only that FP&A has good career growth.

Explain what interests you about the work.

You might be interested in:

• Analysing business performance
• Budgeting
• Forecasting
• Working with financial data
• Understanding business drivers
• Supporting management decisions

The best answer connects your interests with the actual responsibilities of the position.

24. Why should we hire you as a fresher?

You don’t need to pretend that you already have professional FP&A experience.

Instead, explain what you have prepared.

For example:

I have built a foundation in accounting and financial analysis and have used Excel for budgeting and financial projects. I understand the basics of financial statements, variance analysis and forecasting, and I am comfortable learning new tools and processes.

Keep the answer honest and specific.

Questions About Your Finance Projects

Your projects are especially important when you are a fresher.

If your résumé says:

Built a budget versus actual model.

Expect questions such as:

• What assumptions did you use?
• How did you calculate the variance?
• What caused the largest variance?
• Which Excel functions did you use?
• What would you change in the model?
• How would you present the results to management?

Do not add projects simply to make your résumé look stronger.

If you completed the project yourself, you should be able to explain how it works.

What If You Are Asked a Question You Don’t Know?

Don’t guess.

If you know part of the answer, explain what you understand.

You could say:

“I’m not completely sure about that, but I would approach the problem by…”

Then explain your reasoning.

For an entry-level interview, demonstrating a structured thought process can be more useful than pretending to know everything.

Common Mistakes Freshers Make in FP&A Interviews

Memorising definitions

Knowing what variance analysis means is useful.

Being able to investigate a variance is much more relevant to FP&A.

Focusing only on accounting

Accounting is the foundation, but FP&A also involves business analysis, planning and communication.

Ignoring Excel

A candidate may understand finance concepts but still struggle with the practical side of the job if they are uncomfortable with spreadsheets.

Giving vague answers

If an interviewer asks why profit declined, don’t simply say “expenses increased.”

Explain which expenses you would investigate and why.

Overstating technical skills

Only list Excel, Power BI or financial modelling skills that you can demonstrate.

Not understanding the business

FP&A is closely connected to how a company actually makes money.

Before an interview, understand the company’s products, customers and basic business model.

How to Prepare for an FP&A Interview

A simple preparation plan can help.

Area	What to Prepare
Accounting	Three statements, working capital, revenue, expenses
FP&A	Budgeting, forecasting, variance analysis
Excel	Formulas, PivotTables, charts, data analysis
Modelling	Revenue, expenses, scenarios and cash flow
Business	Company, industry and key business drivers
Behavioural	Introduction, projects and motivation for FP&A

Then practise answering questions aloud.

This matters because understanding a concept on paper is different from explaining it clearly during an interview.

What Should You Know About the Company Before the Interview?

At minimum, understand:

• What the company sells
• Who its customers are
• How it generates revenue
• Major cost categories
• Industry
• Main competitors
• Recent business developments

Then think about which financial metrics might matter to that company.

For example, a retail business may care heavily about sales, inventory, margins and store performance.

A software company may focus more on recurring revenue, customer growth, retention and operating costs.

This business context can make your interview answers much stronger.

The Best Way to Prepare for FP&A Interview Questions

Don’t try to memorise 100 answers.

Instead, understand the core chain:

Accounting → Financial Statements → Budgeting → Forecasting → Variance Analysis → Business Drivers → Management Decisions

When you understand how these areas connect, unfamiliar questions become easier to handle.

An FP&A interviewer may change the wording, give you a different scenario or ask a follow-up question. If you understand the underlying concepts, you can work through it.

For freshers, that is more useful than having a perfect answer prepared for every possible question.

Building the Finance Foundation for an FP&A Career

FP&A interviews bring together accounting, financial management, budgeting and business analysis. A strong foundation in these areas can make it easier for commerce students to understand why financial results change and how businesses use financial information for planning.

For students building a long-term finance career, Master Minds India provides a broader commerce and professional education ecosystem. You can also explore its CA and CMA courses as part of a structured finance education pathway.