Q1
Walk me through how you would build a financial model to forecast revenue for a company over the next three years, including the key assumptions and drivers you would use.
Why they ask this:* This assesses your core modeling skills, understanding of financial statement linkages, and ability to structure complex financial analysis—a fundamental competency for mid-level analysts.
Q2
Explain the difference between accrual accounting and cash flow analysis. How would you reconcile a company's net income to its operating cash flow using a cash flow statement?
Why they ask this:* This tests your grasp of fundamental accounting principles and your ability to analyze financial statements critically—essential for accurate financial analysis and variance investigation.
Q3
Describe your experience with Excel (or other BI/analytics tools). Walk us through a specific analysis you performed using advanced functions like VLOOKUP, pivot tables, or data visualization.
Why they ask this:* Mid-level analysts must demonstrate proficiency with the primary tools used daily; this question evaluates both technical skill level and practical application in real scenarios.
Q4
How do you approach variance analysis when actual results differ significantly from budget? What metrics and root causes would you investigate?