Modeling Test: Format, Preparation, and Execution

Introduction

The modeling test is the practical counterpart to the verbal technical questions. While interviews test whether you understand valuation concepts, the modeling test tests whether you can build a working financial model under time pressure. Most bulge bracket and elite boutique banks include a modeling test in their interview process, typically at the superday or final round stage.

30-60 Minute Tests (Most Common for Analysts)

A focused exercise: build a simplified three-statement model or DCF from a provided set of assumptions. The scope is limited (2-3 projection years, simplified balance sheet, basic sensitivity analysis). Speed is the primary differentiator at this level.

1-3 Hour Tests (Associate Level and PE)

A more comprehensive exercise: build a full LBO model or three-statement model with DCF, including debt schedule, returns analysis, and sensitivity tables. The additional time allows for more complexity (multiple debt tranches, working capital detail, accretion/dilution for merger models).

Take-Home Case Studies (4-8 Hours)

Some firms provide a case study to complete at home over a weekend. These test both modeling skill and analytical thinking: the candidate builds the model AND writes a recommendation memo. The scope is broader (industry analysis, competitive positioning, valuation summary) but the time pressure is less intense.

Build 5-10 Practice Models Under Timed Conditions

The single most effective preparation is timed practice. Download practice modeling tests (available from Wall Street Prep, Breaking Into Wall Street, and Wall Street Oasis) and complete them under realistic conditions: closed internet, timer running, no pausing.

Master Excel Shortcuts

Modeling tests are, in part, Excel speed tests. The candidates who complete the most within the time limit are those who rarely touch the mouse. Essential shortcuts:

Modeling Test

A timed Excel exercise used in investment banking and private equity interviews to evaluate a candidate's ability to build a financial model from scratch under time pressure. The candidate receives a prompt (typically a company description with financial data and assumptions), opens a blank Excel workbook, and must produce a working model within the allotted time. The model is evaluated on accuracy (correct formulas, balanced balance sheet), completeness (how much of the prompt was addressed), and presentation (formatting, layout, documentation).

Read the Full Prompt Before Opening Excel

Spend the first 5-10 minutes reading the entire prompt, identifying what is being asked, and planning your approach. Rushing into Excel without understanding the scope leads to rework, which costs more time than the initial planning.

Set Up the Structure Before Entering Formulas

Build the model architecture first: tab structure, row labels, column headers, time periods. This takes 5-10 minutes but saves 20+ minutes of restructuring later.

Build in Stages, Checking as You Go

Build the income statement first, then the balance sheet support schedules, then the cash flow statement, then the valuation analysis. After completing each stage, run a quick check (does the income statement flow correctly? does the balance sheet balance?). Catching errors early is much faster than debugging a fully built model at the end.

Reserve 20-30% of Time for Review

If the test is 2 hours, reserve 30-40 minutes for review, formatting, and sensitivity analysis. The most common failure mode is spending 100% of the time building and submitting a model with unchecked errors. The balance sheet balance check should be verified before submission.

DCF Modeling Test

Priority order: (1) Build a balanced three-statement model (income statement, simplified balance sheet, cash flow statement), (2) extract UFCF and calculate WACC, (3) discount cash flows and terminal value to get implied EV, (4) bridge to equity value per share, (5) build the sensitivity table. If time is short, skip the full balance sheet and build a simplified version that captures working capital and debt but does not attempt to balance every line item.

LBO Modeling Test

Priority order: (1) Build sources and uses (this is the foundation), (2) project EBITDA and calculate free cash flow for debt repayment, (3) build at least one debt tranche (the senior term loan) with amortization and optional prepayment, (4) calculate exit equity and returns (MOIC and IRR), (5) add sensitivity. The circular reference between interest expense and cash flow is the trickiest mechanical element; if you cannot resolve it quickly, use the prior-period balance for interest (slightly less accurate but avoids wasting time debugging).

Circuit Breaker (Modeling Test Context)

A toggle cell that breaks circular references for debugging. In a timed modeling test, the circuit breaker is a practical tool: if your model is producing errors because of the debt schedule circularity, switch the breaker to OFF (setting circular formulas to zero), verify the rest of the model works correctly, then switch it back to ON and enable iterative calculation. This 30-second process can save 10-15 minutes of debugging under time pressure.

Merger Modeling Test

Priority order: (1) Calculate the implied equity value and enterprise value of the deal, (2) build the pro forma income statement combining both companies with synergies and financing adjustments, (3) calculate accretion/dilution in Year 1, (4) build the pro forma balance sheet with PPA (goodwill as the plug), (5) add sensitivity to purchase price and synergy level.

Do not panic. Errors are expected in timed tests. The recovery strategy:

1. If the balance sheet does not balance: Check the cash flow statement first (90% of balance sheet errors originate there). Verify that changes in working capital have the correct sign (increases in assets are cash outflows, negative on the CFS). Verify that D&A is added back exactly once.

2. If the IRR/MOIC looks wrong: Verify the equity check (sources and uses must balance). Verify the exit equity (exit EV minus remaining debt, not exit EV minus original debt). Verify you are using exit year EBITDA, not entry year.

3. If formulas are producing circular reference errors: Enable iterative calculation (File > Options > Formulas) or insert a circuit breaker. If neither works in the moment, use beginning-period balances for interest calculation to break the circularity.