IB Interview Technical Questions Template: DCF Walkthrough Cheat Sheet

IB Interview Technical Questions Template: DCF Walkthrough Cheat Sheet

TL;DR

The DCF walkthrough must read like a forensic narrative, not a spreadsheet rehearsal. In a three‑round interview you have at most 30 minutes to convince a senior banker that you can model cash flow under pressure. The judgment: prioritize driver logic, surface assumptions, and a disciplined terminal‑value sanity check over cosmetic polish.

Who This Is For

This guide is for investment‑banking analyst candidates who have cleared the résumé screen and are preparing for the on‑the‑spot valuation segment of a final‑round interview. You likely have 0‑2 years of deal exposure, a GPA above 3.5, and are targeting a base salary of $120‑130k with a $15‑20k signing bonus at a bulge‑bracket firm. Your pain point is translating textbook DCF knowledge into a live, high‑stakes presentation that survives a senior‑partner debrief.

How should I structure a DCF walkthrough in an IB interview?

The structure should follow a three‑act script—Setup, Deep‑Dive, and Verdict—each lasting roughly ten minutes. In a Q2 debrief after a 2024 summer analyst hiring cycle, the hiring manager interrupted a candidate after the first five minutes because the candidate launched straight into a spreadsheet dump without framing the business context. The counter‑intuitive truth is that interviewers are not evaluating spreadsheet speed; they are evaluating whether you can tell a coherent story about cash‑flow drivers. The three‑act script forces you to anchor the model in the company’s operating model, then drill into the three levers—Revenue Growth, Operating Margin, and Working‑Capital Turnover—before you hand the valuation to the senior banker.

Script excerpt:

“Let me start by describing the core business: a mid‑size SaaS firm with a $500 M ARR and a 30% YoY growth trajectory. The DCF hinges on three drivers… First, we assume a 28% CAGR for the next five years based on the company’s 2022‑23 expansion into Europe. Second, operating margin stabilizes at 22% after a scaling‑efficiency curve. Third, we model working‑capital as 5% of revenue, reflecting the subscription model’s low inventory needs.”

The judgment: never begin with line items; always open with a narrative hook that explains why the model exists.

What are the key numbers to highlight when presenting a DCF?

The key numbers are the projected free‑cash‑flow (FCF) runway, the weighted‑average cost of capital (WACC), and the terminal‑value contribution share; those three signals determine whether the valuation is credible. In a senior‑partner interview for a 2023 associate cohort, the candidate spent twelve minutes walking through a perfectly formatted Excel sheet but failed to flag that the terminal value accounted for 78% of the enterprise value—a red flag for any banker. The insight layer is the “Value‑Driver Matrix”: map each forecast line to a strategic hypothesis, then quantify the hypothesis with a sensitivity range.

Script excerpt:

“Our base case yields an enterprise value of $1.02 B, where the terminal value contributes 62% of the total. If we compress the exit multiple from 12× to 9×, the valuation drops to $880 M, underscoring the sensitivity to the exit assumption.”

The judgment: surface the percentage of value that comes from the terminal period, and be ready to justify the exit multiple with market comps, not just a textbook number.

Why do interviewers penalize a perfect‑look DCF template?

Interviewers penalize a perfect‑look template because it signals rigidity, not analytical flexibility. The problem isn’t your spreadsheet aesthetics—it’s your judgment signal. In a 2022 hedge‑fund interview, the candidate presented a color‑coded, macro‑enabled model and the senior associate cut the session short, stating the “template is too polished for a live case.” The counter‑intuitive observation is that a polished template can hide a lack of intuition about driver interactions.

Script excerpt:

“When asked how a 10% increase in churn would affect cash flow, I quickly recalculated on a whiteboard, showing the FCF dip from $45 M to $38 M, which in turn reduces the terminal value by $70 M.”

The judgment: keep the template lean, and be prepared to reconstruct it on the fly; that demonstrates real mastery.

When does the terminal value dominate the valuation, and how to justify it?

The terminal value dominates when the explicit forecast horizon is shorter than the business’s growth horizon, typically beyond five years for high‑growth firms. In a September 2023 summer‑associate interview, the hiring manager challenged a candidate who assumed a five‑year horizon without explaining why the cash flow beyond year five was irrelevant. The framework I call “The Horizon‑Justification Test” forces you to answer three questions: (1) How many years of visible cash flow do you have? (2) What is the growth rate after that horizon? (3) Which comparable transactions support your exit multiple?

Script excerpt:

“We only model five years because our forecast confidence drops sharply after year five—historically, the company’s ARR churn spikes beyond that point. We therefore apply a perpetuity growth rate of 2.5% and an exit multiple of 10× EBITDA, which aligns with recent private‑equity exits in the same niche.”

The judgment: never let the terminal value ride unchecked; always tether it to a justified exit multiple and a realistic growth assumption.

How can I adapt the DCF template to a rapid‑fire case study?

Adaptation requires a “quick‑draw” lattice: pre‑define three reusable driver blocks and a terminal‑value shortcut that can be swapped in under ten minutes. In a 2024 “speed‑round” interview, candidates were given a two‑page teaser and 20 minutes to produce a valuation. The candidate who relied on a full‑scale model faltered, while the one who used a pre‑built driver lattice delivered a coherent story in 12 minutes and impressed the senior banker. The counter‑intuitive truth is that depth beats breadth; a concise model with clear assumptions beats a sprawling spreadsheet that you cannot explain.

Script excerpt:

“I’ll start with a top‑line growth assumption of 20% based on the target’s recent expansion, then apply a 22% operating margin—derived from the industry median—and finally assume a 5% cap‑ex to depreciation ratio. The terminal value uses a 9× EBITDA multiple, which matches the latest comparable deals.”

The judgment: master a modular DCF framework that can be assembled on the whiteboard, not a full Excel file.

Preparation Checklist

• Review the three‑act script and rehearse the opening narrative until it lands in under 30 seconds.
• Build a one‑page “Value‑Driver Matrix” for at least three common IB sectors (technology, industrials, healthcare).
• Practice reconstructing the DCF on a whiteboard within ten minutes, using only a calculator and a blank sheet.
• Memorize the “Horizon‑Justification Test” questions and have a one‑sentence answer ready for each.
• Run a mock debrief with a senior analyst and ask them to interrupt you at the first sign of a template‑overreliance.
• Work through a structured preparation system (the PM Interview Playbook covers the “DCF Storytelling Framework” with real debrief examples, so you can see how interviewers dissect each driver).
• Schedule a 2‑day sprint to simulate the rapid‑fire case study, timing each segment to 12‑minute blocks.

Mistakes to Avoid

BAD: Presenting a fully formatted Excel model on the screen and refusing to switch to a whiteboard when asked. GOOD: Starting with a narrative, then pulling a simplified driver table onto the whiteboard, showing you can think without formulas.

BAD: Saying the terminal value is “just a number” and moving on. GOOD: Quantifying the terminal‑value share, explaining the exit multiple, and linking it to recent comps, which demonstrates strategic awareness.

BAD: Ignoring the sensitivity of churn or cap‑ex on free cash flow. GOOD: Running a quick sensitivity check on the spot and articulating how a 5% increase in churn would compress the valuation by $80 M, proving you understand the levers.

FAQ

What is the minimal set of assumptions I can safely use in a 30‑minute DCF interview?

Use three core assumptions—Revenue CAGR, Operating Margin, and Cap‑Ex to Depreciation ratio—plus a WACC of 8% and an exit multiple of 9× EBITDA; that keeps the model tractable while still allowing you to discuss driver logic.

How do I handle a senior banker who asks for a different exit multiple mid‑presentation?

Acknowledge the request, recalculate the terminal value on the whiteboard, and explain the new multiple’s justification with a comparable transaction; this shows adaptability and market awareness.

Is it ever acceptable to skip the terminal value and rely solely on explicit cash flows?

Only if the explicit forecast covers at least ten years and the business has a clear decline trajectory; otherwise, omitting the terminal value signals a lack of valuation completeness and will be penalized.

The 0→1 PM Interview Playbook (2026 Edition) — view on Amazon →