Investment Banking Modeling Tests: Every Format, How Long Each One Takes, and How to Beat the Clock
5 min read
You've been told there's a "modeling test" in the next round, and nobody will say what that means. Is it a paper LBO in five minutes? A three-hour Excel marathon? A take-home case you get a week for?
It could be any of them. Modeling tests come in a handful of standard formats, and each one has a typical time window. Once you know which one you're facing, you can prepare for it and plan your minutes. Let's walk through all of them.
When You'll Actually See a Modeling Test
First, some perspective. For summer analyst and full-time analyst recruiting, most banks rely on behavioral and technical questions rather than full modeling tests. Some firms, especially certain boutiques and middle-market banks, do add a test, often in a final round.
Modeling tests become much more common in two situations:
- Lateral hires: If you're moving from another bank or a Big 4 valuation or transaction services team, they expect you to prove you can build.
- Private equity recruiting: If you're a banker interviewing for PE, an LBO test is close to guaranteed.
So if you're a student, don't panic. Just don't assume you'll be spared, either.
The 5 Main Formats (and Their Typical Timing)
1. The Paper LBO: 5 to 15 Minutes
What it is: A mental-math LBO, done verbally or with pen and paper. No Excel, no calculator in most cases.
What they're testing: Whether you understand how leverage, growth, debt paydown and exit multiples drive returns, and whether you can do quick math under pressure.
Here's a worked example you can practice:
- Company EBITDA: $100m, bought at 10x = $1,000m purchase price
- Funded with 60% debt ($600m) and 40% equity ($400m)
- EBITDA grows to $150m in year 5
- The company generates enough free cash flow to pay down $300m of debt
- Exit at 10x = $1,500m enterprise value
At exit, debt is $600m minus $300m = $300m. Equity value is $1,500m minus $300m = $1,200m.
MOIC = $1,200m / $400m = 3.0x. Over five years, that's an IRR of roughly 25% (3x over 5 years works out to about 24.6%).
Memorize these shortcuts so you never have to compute IRR from scratch:
- 2x over 5 years ≈ 15% IRR
- 3x over 5 years ≈ 25% IRR
- 2x over 3 years ≈ 26% IRR
Tip: Say your steps out loud. Interviewers care about your logic as much as the final number.
2. The Simple Excel LBO: 30 to 60 Minutes
What it is: A short prompt (often a single page) with an income statement summary, a purchase multiple, a debt structure and an exit assumption. You build a basic LBO from a blank sheet.
What a complete answer includes:
- Sources and uses table
- Simplified income statement down to net income
- Free cash flow and debt paydown schedule
- Exit value, equity value, MOIC and IRR
Tip: You usually don't need a full balance sheet here. If the prompt doesn't ask for it, skip it and spend that time checking your math.
3. The Three-Statement Model: 1 to 3 Hours
What it is: You're handed historical financials and a list of assumptions and asked to project the income statement, balance sheet and cash flow statement. Sometimes it's the backbone of an LBO or DCF on top.
What they're testing: Your understanding of how the statements link, your Excel speed, and whether your balance sheet balances.
Tip: Build the cash flow statement by pulling changes directly from your balance sheet and income statement, not by typing new numbers. That's how you catch errors early instead of chasing an imbalance at minute 110.
4. The Merger Model (Accretion/Dilution): 1 to 2 Hours
What it is: An acquirer buys a target using some mix of cash, debt and stock. You calculate pro forma EPS and whether the deal is accretive or dilutive.
Quick sanity check you can run mentally. Say the buyer has net income of $500m and 100m shares, so EPS is $5.00. It issues 20m new shares to buy a target with $150m of net income, and assume no synergies or other adjustments:
- Pro forma net income: $500m + $150m = $650m
- Pro forma shares: 100m + 20m = 120m
- Pro forma EPS: $650m / 120m ≈ $5.42
That's about 8% accretive. If your Excel output says dilutive with those inputs, you know something broke.
Tip: Know the shortcut for all-stock deals. If the buyer's P/E is higher than the P/E it pays for the target, the deal is accretive (before synergies and adjustments).
5. The Take-Home Case Study: A Few Days to About a Week
What it is: You get a company (sometimes real, sometimes fictional), a data pack, and an open-ended question like "Would you invest in this business?" You build a model and often write a short memo or a few slides.
What they're testing: Judgment. Anyone can build an LBO given enough time. They want to see whether your assumptions make sense and whether you can defend a clear recommendation.
Tip: Don't overbuild just because you have the time. A clean model with well-reasoned assumptions and a sharp one-page recommendation beats a 40-tab monster every single time.
How to Budget Your Time in a Timed Test
Running out of time is the most common way people fail these tests. Here's a sample plan for a 2-hour three-statement model:
- Read and plan (10 minutes): Read the entire prompt before touching Excel. Sketch your tab layout.
- Build the core model (60 to 70 minutes): Income statement, then balance sheet, then cash flow statement.
- Check and fix (20 minutes): Does the balance sheet balance? Does cash on the cash flow statement match the balance sheet?
- Outputs and cleanup (10 to 15 minutes): Summary outputs, formatting, a few lines on key takeaways.
Scale the same proportions up or down for shorter or longer tests. The principle stays the same: finish a working model first, then polish.
Mistakes That Cost People the Offer
- Chasing optional features: A working basic model beats a half-finished complex one.
- Hardcoding inside formulas: Keep assumptions in their own cells, ideally in blue font, so the model is easy to follow and change.
- Never saving: Excel crashes. Save every few minutes.
- Ignoring the question: If they asked for IRR at a 9x exit, make sure that exact number is clearly displayed.
- Skipping the sanity check: A 90% IRR on a sleepy industrial company should make you stop and look for the error.
How to Prepare, Starting This Week
- Practice paper LBOs daily until the math feels automatic.
- Build a three-statement model from a blank sheet at least a few times, timing yourself.
- Learn the Excel shortcuts you'll actually use: navigating, filling formulas, formatting. Mouse-heavy candidates lose minutes.
- Ask your recruiter or contact what format to expect. Many will tell you whether it's timed, how long it is, and whether there's a template.
Know your format, know your time window, and practice under the clock. Do that, and the modeling test stops being the scary part of the process and becomes your chance to stand out.