Financial Analyst Case Study Interview Questions & Answers (2026)

I'd build a monthly P&L starting with revenue assumptions. Revenue: average foot traffic 500 people/day, conversion rate 15%, average transaction value $45. Monthly revenue: 500 × 0.15 × $45 × 30 = $101,250. Annual: ~$1.2M. COGS: 40% gross margin for retail → COGS = $60,750/month. Gross profit = $40,500/month. Operating expenses: rent ($12,000/month in a suburban location), staff (3 FTE at $3,500/month = $10,500), utilities/insurance ($2,500), marketing ($3,000), depreciation on buildout ($1,500/month on $90K buildout over 5 years). Total OpEx = $29,500/month. EBITDA = $40,500 - $29,500 = $11,000/month = $132K/year. Initial investment: $90K buildout + $50K inventory + $20K pre-opening = $160K. Payback period: $160K / $132K = ~14.5 months. Sensitivity analysis: the model is most sensitive to foot traffic and conversion rate. If foot traffic drops 20% to 400/day: revenue drops to $81K/month, EBITDA to $2,700/month, payback extends to 59 months — making the investment questionable. Break-even foot traffic: approximately 425 people/day. Recommendation: proceed if the location analysis supports 500+ daily foot traffic with high confidence. The 14.5-month payback is acceptable for retail, but the tight margin at 400 visitors makes location selection critical. I'd also compare this return to the company's WACC to ensure value creation.

I'd evaluate this acquisition across four dimensions. Standalone valuation: Company B has $8M EBITDA. Industry comparable companies trade at 5-7x EBITDA. At 6x, standalone value is $48M. The $50M offer implies a 4% premium — that's low, suggesting either strong negotiation position or that synergies are needed to justify the price. Synergy analysis: revenue synergies (cross-selling to Company B's customer base, estimating $2M incremental revenue by year 2) and cost synergies (eliminating duplicate functions: finance, HR, IT — estimating $1.5M annual savings). Total synergy value at 6x multiple = ($2M + $1.5M) × 6 = $21M. Adjusted value: $48M + $21M = $69M. Paying $50M for $69M of value creates ~$19M in value. Financial impact: if funded with cash on hand, no dilution. If funded with debt at 6% interest = $3M/year interest expense. Company B's $8M EBITDA minus $3M interest = $5M contribution to earnings. EPS impact: accretive if $5M / shares outstanding > current EPS dilution. Risk assessment: integration risk (cultural fit, key employee retention), customer overlap (will B's customers stay post-acquisition?), and synergy realization risk (only 60-70% of projected synergies typically materialize). Recommendation: acquire at $50M if synergy realization confidence is >60%. At conservative estimates (60% synergy realization), adjusted value is $48M + $12.6M = $60.6M, still above the $50M price. However, I'd negotiate for an earnout structure tying $5M to synergy milestones.

Revenue growth with negative cash flow is a classic disconnect between the income statement (accrual basis) and cash flow statement (cash basis). Several factors could explain this. Working capital consumption: fast-growing companies often have cash tied up in working capital. If revenue grew 20% but accounts receivable grew 40% (slower collections), cash is consumed by growth. Similarly, inventory buildup to support future sales ties up cash. I'd check DSO (days sales outstanding) and inventory turnover trends. Capital expenditure: the company may be investing heavily in growth (new facilities, equipment, technology). CapEx appears only on the cash flow statement, not the income statement (except through depreciation). A company spending $5M on a new production line shows a $5M cash outflow but only ~$1M/year depreciation expense on the income statement. Revenue recognition: if the company recognizes revenue on long-term contracts but collects cash over time, revenue can outpace cash collection. This is common in construction, SaaS with annual contracts paid monthly, and professional services. Customer concentration: if a few large customers pay on extended terms (net-90 or longer), receivables balloon. One delayed payment from a major customer can cause negative cash flow despite strong revenue. My investigation: I'd first check the cash flow from operations section, specifically working capital changes. Then check CapEx in the investing section. Then check if the company is servicing debt (financing section). Each tells a different story: working capital issues suggest operational fixes, CapEx suggests intentional investment, and debt service suggests financial structure review.

I'd build a cohort-based MRR model. Starting assumptions: current ARR $5M (Year 0), 2,000 customers, $2,500 average ACV, 90% gross retention, 110% net retention (20% logo churn offset by expansion), 50 new customers/month growing 15% annually, and new customer ACV growing 5% annually. Year 1: Starting MRR: $417K. Existing customer revenue: $5M × 110% NRR = $5.5M. New customer revenue: 50/month × $2,500 ACV × 12 months (half-year revenue recognition for new customers) ≈ $900K. Year 1 ending ARR: ~$6.4M. Year 2: Existing ARR: $6.4M × 110% = $7.04M. New customers: 57.5/month (15% growth) × $2,625 ACV (5% ACV growth) × 12 months ≈ $1.09M. Year 2 ending ARR: ~$8.13M. Year 3: Existing ARR: $8.13M × 110% = $8.94M. New customers: 66/month × $2,756 ACV × 12 months ≈ $1.31M. Year 3 ending ARR: ~$10.25M. Three-year ARR growth: $5M → $10.25M = 105% growth, ~27% CAGR. Key sensitivity drivers: NRR is the single most important variable. At 120% NRR instead of 110%, Year 3 ARR would be ~$12.5M. At 100% NRR, Year 3 drops to ~$8.1M. I'd present the model with a sensitivity table showing NRR × new customer growth scenarios. Sanity check: the Rule of 40 (growth rate + profit margin should exceed 40%) helps validate whether this growth rate is achievable given the company's cost structure.

I'd use a three-method approach for triangulation. Comparable companies analysis: identify 5-8 companies in the same industry with similar size, growth rate, and business model. Calculate key multiples: EV/Revenue, EV/EBITDA, P/E, and P/FCF. Compare the target's multiples to the peer median. If the target trades at 8x EBITDA while peers trade at 12x, it's potentially undervalued — but I need to understand why (lower growth? higher risk? worse margins?). DCF analysis: project free cash flows for 5 years based on revenue growth, margin expansion, and capital needs. Apply a terminal value (using perpetuity growth method or exit multiple). Discount at WACC. If the implied share price exceeds the current market price by >20%, it suggests undervaluation. Key financial health checks: revenue growth trend (accelerating or decelerating?), margin trends (expanding or compressing?), balance sheet strength (debt/equity, interest coverage), cash generation (free cash flow positive? FCF conversion from net income?), and return on invested capital vs WACC (is the company creating value?). Red flags that explain low multiples: declining growth, excessive debt, customer concentration, regulatory risk, or management concerns. These may justify the discount rather than indicating undervaluation. My conclusion would include: 'Based on comparable analysis and DCF, the implied fair value is $X, representing Y% upside from the current price. However, the discount may be partially justified by [specific risk factors]. My confidence in the undervaluation thesis is medium/high.'