Technical assessment
The Excel & Modelling Test
The Excel and modelling test is a high-pressure technical simulation designed by investment banks and private equity firms to evaluate your practical valuation and accounting skills. This comprehensive guide details the exact structures you will face, breaks down standard corporate grading rubrics, and provides concrete execution strategies to ensure your balance sheet ties and your investment conclusions withstand senior partner scrutiny.
In short
An Excel modelling test is a timed, hands-on technical assessment where you build or complete a financial model - typically a three-statement or leveraged buyout (LBO) architecture - using a spreadsheet or a sheet of paper. Firms deploy this test during investment banking superdays or private equity assessment centres to verify your actual execution capabilities before extending an offer. To pass, you must demonstrate mechanical accuracy, clean formatting, flexible assumption blocks, and realistic return profiles. Success requires moving past theoretical corporate finance to deliver structured, error-free models under extreme time constraints.
The basics
What it is
The financial modelling test represents the ultimate practical hurdle in the recruitment timeline for competitive corporate finance roles. While traditional technical interviews test your conceptual knowledge through verbal questions, this assessment evaluates your real-world ability to execute institutional-grade analysis under operational duress. You are placed directly in front of a spreadsheet, or handed a blank sheet of paper, and tasked with constructing a functioning financial architecture from raw data. This test is a staple of late-stage processes, occurring during investment banking superdays in the US and final-round assessment centres in the UK.
Most institutional tests focus on one of two foundational exercises: an integrated three-statement financial model or a leveraged buyout (LBO) model. In a three-statement assessment, you must link an income statement, balance sheet, and cash flow statement dynamically so that any operational change flows automatically through the entire system. In an LBO test, you evaluate an acquisition by layering debt onto a target business, forecasting debt service schedules, and calculating sponsor equity returns. Whether you are applying for an undergraduate graduate scheme, a spring insight programme, or a lateral associate position, you must demonstrate complete command of these core financial mechanics.
Time pressure is a deliberate, structural element of the examination design. Firms intentionally provide more analytical depth than can comfortably be completed within the allotted window, which ranges from a tight 15-minute paper exercise to a comprehensive three-hour Excel build. Assessors do this to observe how you triage tasks, manage stress, and structure your thoughts under operational strain. They want to ensure you can deliver accurate, professional work when live transaction timelines demand rapid turnarounds. Sloppy execution, broken links, or an inability to complete the core outputs will result in immediate rejection.
Intervyo operates as an entirely independent preparation platform and maintains no affiliation, endorsement, or formal relationship with any investment bank, private equity fund, or proprietary test publisher. All study guides, practice frameworks, and instructional breakdowns provided across our platform are original recreations designed by industry experts to simulate typical candidate experiences. Our resources are developed solely to help you build the practical skills and technical confidence required to navigate these rigorous internal firm-built assessments successfully.
What it measures
The dimensions under test
Three-statement linkage fluency
Assessors evaluate how seamlessly you connect the income statement, balance sheet, and cash flow statement. You must accurately flow net income into retained earnings, reflect working capital changes on the cash statement, and use the final cash balance to reconcile the assets and liabilities without relying on arbitrary plugs.
LBO returns mechanics
The test measures your comprehension of capital structure changes, debt tranches, and cash sweeps. You must accurately compute key performance metrics, specifically the internal rate of return (IRR) and the multiple on invested capital (MOIC), to prove you understand how debt paydown drives equity value expansion.
Valuation core competencies
Firms look for your capacity to execute discounted cash flow (DCF) analyses and trading comparables. You must demonstrate a clean application of weighted average cost of capital, terminal value multiples, and enterprise-to-equity value bridges to prove you can value a real enterprise accurately.
Excel speed and structure
The assessment evaluates your architectural layout and your reliance on keyboard shortcuts. Top candidates construct clean, intuitive models with separated assumption blocks, consistent formula conventions, and a highly professional format that senior team members can instantly audit and interpret without guidance.
Commercial judgement and sanity-checking
Beyond formulas, the test evaluates whether your outputs make logical business sense. You must select defensible operational growth rates, margin assumptions, and exit multiples, while ensuring your final returns profiles look realistic rather than mathematically contrived to match an impossible target.
Stress tolerance and triage
This evaluates your capacity to perform under severe time restrictions. Assessors observe whether you can maintain structural accuracy, avoid critical formula errors, and deliver a functioning core model when you do not have enough time to finish every minor aesthetic detail.
The format
What to expect
See it in action
A worked example
This walkthrough demonstrates how to execute a standard paper-based LBO calculation using illustrative round numbers in both British pounds and US dollars.
- 01
Establish entry enterprise value and funding structure
Assume you acquire a business at a 10.0x EV/EBITDA multiple with an entry EBITDA of GBP 100 million / USD 130 million, yielding an entry enterprise value of GBP 1,000 million / USD 1,300 million. If the transaction is funded with 5.0x EBITDA in senior debt, you raise GBP 500 million / USD 650 million in loans, meaning the sponsor must contribute the remaining GBP 500 million / USD 650 million as equity.
- 02
Project cash generation and debt paydown over the hold period
Over a five-year holding period, assume the business generates a steady GBP 60 million / USD 78 million in annual free cash flow after meeting all interest obligations, taxes, and capital expenditure needs. If you direct 100 percent of this free cash flow toward a cash sweep to pay down the principal, you reduce the total outstanding debt by GBP 300 million / USD 390 million by the end of year five.
- 03
Calculate exit enterprise value and ending equity value
At the end of year five, the outstanding debt balance has dropped to GBP 200 million / USD 260 million. Assuming you exit the investment at the exact same 10.0x EBITDA multiple and EBITDA has remained flat at GBP 100 million / USD 130 million, the exit enterprise value is GBP 1,000 million / USD 1,300 million, leaving an exit equity value of GBP 800 million / USD 1,040 million after subtracting the remaining debt.
- 04
Derive the money multiple and approximate internal rate of return
To find the investment returns, divide the exit equity value by the initial sponsor equity contribution, which yields a multiple on invested capital of 1.6x in both currencies (GBP 800m divided by GBP 500m, or USD 1,040m divided by USD 650m). For a five-year hold, a 1.6x money multiple translates via standard financial rule-of-thumb tables to an approximate internal rate of return of 10 percent.
The takeaway
Mastering this step-by-step mathematical logic allows you to confidently answer complex valuation questions on paper when stripped of Excel formulas.
The scoring
How it is marked
Modelling tests are graded against an absolute internal rubric rather than a relative percentile curve, meaning your submission must satisfy strict institutional benchmarks to pass. Senior assessors reward flawless mechanical integration, clean visual formatting, and realistic financial assumptions while aggressively penalising broken links and hard-coded values.
Top-decile tier
The financial model is completely finished, beautifully formatted with distinct inputs and calculations, and 100 percent accurate. The balance sheet balances naturally without plugs, all formulas are fully dynamic, and the candidate provides a highly articulate verbal justification of their underlying growth and return assumptions.
Solid tier
The core financial model functions correctly, the statements link accurately, and the primary outputs like IRR or cash balances are correct. The layout is clean and readable, though the candidate may have run out of time to complete secondary analysis pages or advanced sensitivity tables.
Borderline tier
The model is mostly complete and the mathematical logic makes sense, but it suffers from visible structural flaws. The layout may appear cluttered, some formula references might be hard-coded to force a balance, or the candidate may have made minor errors in working capital calculations.
Fail tier
The financial model is fundamentally broken, containing severe formula errors, circular references, or a balance sheet that fails to balance. Core investment outputs are either missing or mathematically absurd, indicating the candidate lacks the baseline technical competence required for everyday analytical work.
The variants
Versions you might be sent
The paper LBO
A spreadsheet-free evaluation where you talk through an investment case using simple, rounded integers on a whiteboard or notepad, proving you understand the economic drivers of private equity returns without software.
Full LBO Excel build
A comprehensive corporate finance assessment where you construct an entire leveraged buyout model from raw operational data, requiring an integrated debt schedule, cash sweep mechanics, and detailed sensitivity tables.
Three-statement integration test
A standard test focusing entirely on accounting linkages, requiring you to forecast an income statement, balance sheet, and cash flow statement, ensuring they tie together perfectly over a multi-year forecast horizon.
DCF and trading comps exercise
A valuation-heavy test where you calculate free cash flows to the firm, discount them using a calculated WACC, and cross-reference the resulting valuation against public market trading multiples.
Merger and accretion-dilution model
A corporate development or investment banking test where you combine two corporate entities, adjust for acquisition debt, calculate synergy requirements, and determine the post-transaction impact on earnings per share.
The prep
How to prepare
Memorise accounting and LBO mechanics cold
You must know exactly how a change in depreciation impacts all three statements and how debt paydown alters equity value without needing to think. Practise tracing these flows on paper until the underlying double-entry bookkeeping logic becomes completely second nature to you.
Drill paper LBO structures with round integers
Replicate the whiteboard environment by practicing return calculations using simple numbers. Train yourself to calculate interest expenses, debt reductions, and equity multiples mentally so you can speak through an investment thesis confidently during intense, late-stage superday or assessment centre panels.
Build models against a strict countdown timer
Do not just practise building models comfortably; do it against a noisy 45-minute countdown. Focus on creating a clean layout, separating your input assumptions from your calculation blocks, and using pure keyboard shortcuts to maximise your operating speed.
Develop an intuitive sanity-checking routine
Allocate the final five minutes of every practice session to reviewing your outputs. Check that your balance sheet balances every year, confirm that your margins match historical industry averages, and verify that your final IRR figures align realistically with common private equity investment hurdles.
How not to fail
Common failure modes
The specific ways candidates lose marks on this test. None of these need talent to avoid, only awareness.
- 01An unbalanced balance sheet. Allowing a structural asset-and-liability mismatch to remain in your final file destroys your credibility, signalling to assessors that your core accounting knowledge is flawed.
- 02Hard-coding numbers in calculation blocks. Typing static digits into formula rows to force a model to balance indicates sloppy practice and prevents the spreadsheet from functioning dynamically when assumptions change.
- 03Cluttered and unreadable visual layout. Failing to separate your inputs from your calculations makes your model impossible to audit rapidly, forcing busy assessors to hunt through messy rows to find your conclusions.
- 04Absurd or unchecked financial outputs. Submitting a model that outputs negative cash balances, massive profit margins, or astronomical investment returns proves you failed to look at your results with a critical commercial lens.
- 05Over-engineering minor details while failing to finish. Spending too much time creating complex option clips or aesthetic macro buttons while leaving the core cash flow or debt paydown schedules incomplete guarantees a failing mark.
On the day
What strong candidates do
The habits that separate high scorers, most of them decided before the timer even starts.
Constructing a dedicated assumptions block
Top candidates place all operational and transactional variables into one clearly marked area at the top or start of the file, keeping calculation blocks purely dynamic.
Navigating Excel using keyboard shortcuts exclusively
Working without a mouse demonstrates high professional fluency, allowing you to format blocks, write complex formulas, and navigate sheets at the rapid speed expected of an analyst.
Implementing consistent formula architectures
Applying identical formula structures across every column in a row ensures your sheet remains clean, predictable, and easy for senior team members to review or scale.
Executing a deliberate final sanity check
Spending the last few minutes cross-checking key financial ratios ensures that profit margins, debt-to-EBITDA metrics, and cash flow conversions conform to standard industry realities.
Prioritising a finished core over optional features
Strong candidates ensure the foundational statements and return metrics function perfectly before attempting to build out advanced scenario toggles or complex capitalization tables.
Practise on the real format
Reading about the test is not practising it.
Intervyo recreates Excel & Modelling Test in its real format, timed and scored, with instant feedback so the structure is familiar before it counts. Start free, no card required.
FAQ
Common questions
A paper LBO is a spreadsheet-free interview exercise where you calculate investment returns using a pen, paper, and basic arithmetic. Private equity firms use it to evaluate your core commercial logic, mental math capabilities, and structural understanding of how leverage drives equity returns, without the aid of Excel formulas.
Keep exploring
Keep going
More assessments
Practise on Intervyo
Excel & Modelling Test
Know the test.
Now practise it on the real format.
Intervyo recreates the timed pressure of these assessments and scores every run, so the format is second nature before the real one.
Free to start, no card required
Intervyo is an independent preparation platform. Our practice tests simulate the style and format of In-house assessments and are not affiliated with, or endorsed by, the test publisher.