LBO modeling test, and how to prepare
An LBO modeling test is a timed private equity exercise where you build a leveraged buyout model in Excel from a prompt or information memorandum, calculate IRR and MOIC, and recommend whether to bid. Wharton's MBA career guide notes that second-round PE cases typically run about 3 hours in the office or over a weekend with a 3-page presentation. For the interview after the test, Soreno, an AI voice interview practice app for consulting, investment banking and other finance candidates, runs private equity interview practice with follow-up questions on how you would explain your model.
Updated
- Mostly private equity. Career offices tell PE candidates to expect one. Banks lean on technical questions.
- Four formats. A paper LBO, a timed LBO in Excel, a case with a bid, or a take-home.
- Minutes to a weekend. Wharton's 2018 guide describes about 3 hours in the office, or a weekend with a 3-page deck.
- Often in round two. MBA on-cycle runs in early fall of year one and can be over in days.
- Practice by rebuilding. Build the same LBO from a blank sheet until it takes under an hour.
A sample LBO modeling test, with timings
Our own practice prompt, built like a short in-office test. Set a 90-minute timer, build it from a blank sheet, then check your answer against the last row. Dollar figures are in millions.
The prompt6 inputs
Everything you need is here. Anything missing, assume and say so.
The company
$500M of revenue, 20% EBITDA margin
So EBITDA is $100.0M today. Revenue grows 5% a year for five years and the margin holds.
The deal
Bought at 10.0x EBITDA
A purchase price of $1,000.0M, funded with 6.0x of debt ($600.0M) at 8% and $400.0M of sponsor equity. Ignore fees.
Cash flow
D&A and capex 3% of revenue each
Net working capital is 10% of the change in revenue. Tax is 25% of pre-tax income.
Debt
All free cash flow repays debt
Charge interest on the opening balance each year, so the model has no circular reference.
The exit
Sold after five years at 10.0x
The same multiple as the entry, so none of the return comes from multiple expansion.
The ask
IRR, multiple of money and a view
Give both return figures, say where the return comes from, and whether you would do the deal at this price.
How to spend the 90 minutes6 blocks
Our suggested split. The point is a returns number with time to check it.
0 to 10 min
Inputs on one tab
Every assumption in one block, typed once, so a reviewer can change any of them.
10 to 25 min
Sources and uses, then the income statement
Price and debt from the multiples, equity as the plug. Then revenue to net income for five years.
25 to 50 min
Cash flow and the debt schedule
Net income plus D&A, less capex and the working capital build. That cash repays debt.
50 to 65 min
Returns
Exit value less the debt left is the sponsor's equity. Divide by the equity in for the multiple, then the IRR.
65 to 80 min
Checks and one sensitivity
Check that sources equal uses and debt never goes negative. Then a small table of IRR against exit multiple.
80 to 90 min
The view
Three lines: the returns, what drives them and the one risk that would change your answer.
The answer to check againstWorked
Rounded to one decimal. Small gaps from rounding are fine.
Year 1
$28.4M of free cash flow
EBITDA of $105.0M less $48.0M of interest, tax, capex and the working capital build. Debt falls to $571.6M.
Year 5
EBITDA of $127.6M, $403.8M of debt left
Free cash flow rises each year as EBITDA grows and interest falls, reaching $51.0M in year 5.
Exit
$872.5M to the sponsor
10.0x × $127.6M = $1,276.3M of value, less $403.8M of debt.
Returns
Where it came from
Growth and debt paydown
$276.3M from EBITDA growth at 10.0x and $196.2M from debt repaid add up to the $472.5M gain. The multiple adds nothing.
The full LBO model, worked
The four formats
Which one you get depends on the firm and the round. Your recruiter or the invitation says which.
Paper LBO
An LBO worked by hand in a few minutes from round numbers to the IRR and multiple of money. Often an early screen before the spreadsheet round.
Timed LBO in Excel
Wharton's MBA career guide describes this second-round format as a simple LBO example where you are given basic assumptions in Excel and asked to model out the returns over a set period, often within about 3 hours in the firm's offices.
Information memorandum investment case
Wharton's guide describes the second format as an investment case built on an information memorandum for a business being marketed for sale. Your task is to recommend whether to submit a bid, at what valuation, and the key diligence areas to investigate.
Weekend take-home presentation
Instead of processing the information memorandum in 3 hours in the office, Wharton notes you may be asked to return over a weekend with your recommendation in a 3-page presentation on the pros and cons of the business and the price you would pay.
From Wharton MBA Career Management (2018) and Yale SOM Career Development (2026).
When the test comes
What career offices tell their students, from MBA on-cycle to the analyst level.
Show the timeline
MBA, year one
On-cycle starts early
Yale SOM's career office says on-cycle PE recruiting for internships starts in early fall or even late summer of the first year, and often lasts only a few days.
Interviews
Technicals, cases or a full test
The same office tells students to be ready for technical interviews, case studies or full modeling tests.
Round two
The case
Wharton's guide says the PE case usually comes in the second round, either in the office in about 3 hours or over a weekend.
Banks
Skills assessments
JPMorganChase says some roles use virtual skills assessments, and technical tests can be online or live with an interviewer.
Penn Career Services recommends its basic LBO practice model and tutorial slide deck for Juniors and Seniors in Investment Banking and Private Equity, and advises completing a technical mock interview first.
9 questions that build the same skills
A test checks whether you can build it. The interview around it checks whether you can explain it. Each has a note on what a strong answer does.
The model, step by step4 questions
The parts every LBO test asks for.
Walk me through the sources and uses in an LBO.
Show what a strong answer does
Start from uses, because the price sets them, and make equity the plug that balances the table.
How much debt can this company support?
Show what a strong answer does
Size it on cash flow and interest cover, not on what the price needs.
Walk me through how the three financial statements and supporting schedules link.
Show what a strong answer does
Follow net income from the income statement building block into cash and equity so the balance sheet balances, while supporting schedules for working capital, depreciation, and voluntary debt paydown feed cash flow and the debt balance.
Take me from revenue to unlevered free cash flow.
Show what a strong answer does
Go line by line and say why each item is added back or taken off.
Returns and judgment5 questions
What the reviewer asks once the model works.
Walk me through a basic LBO.
Show what a strong answer does
Price and funding, cash that repays debt, then exit and returns, in under two minutes.
Where do the returns in an LBO come from?
Show what a strong answer does
Split the gain into EBITDA growth, multiple change and debt paydown, and check that they add up.
What is the difference between IRR and MOIC?
Show what a strong answer does
Time. Show two deals where the two measures disagree.
What makes a good LBO candidate?
Show what a strong answer does
Steady cash flow, low capex needs and a price that leaves room. Tie each point to the model.
What types of debt are used in an LBO?
Show what a strong answer does
Senior to junior, with what each costs and when it is repaid.
Mistakes and prep
Financial modeling best practices and mistakes to avoid
Skipping model validation checks
For financial model validation and error reduction, sources must equal uses and the balance sheet must balance. Build both checks first, so a broken link between schedules and statements shows at once.
Typed-in numbers in formulas
Financial modeling best practices keep every assumption in one dedicated input block. A hard-coded figure in a formula breaks when the reviewer tests a new valuation or deal structure.
A circular reference you can't control
Interest on average debt makes a loop. Use the opening balance, or add a circ switch as included in Penn Career Services' basic model to turn the loop off.
Time on formatting
Get to a returns number first, then tidy. An unfinished model with nice colors still fails.
No view at the end
A case test asks whether you would invest. End with a yes or no, the price and the two risks that matter.
A four-week prep plan
For an LBO test. Adjust if your recruiter names another format.
Week 1
Rebuild one model from a blank sheet
Take a worked LBO, such as the one on our LBO model page, and rebuild it from a blank sheet, checking each line.
Week 2
Do it against the clock
Build it again with new numbers in 90 minutes, then 60. Penn Career Services publishes a basic LBO practice model created by a former Wharton MBA student that includes core interview mechanics plus optional awareness topics like circularity switches and voluntary debt paydowns.
Week 3
Add the investment memo recommendation
Following Wharton's information memorandum format, pair your model with a 3-page recommendation covering whether to submit a bid, at what valuation, and the key diligence areas to investigate.
Week 4
Paper LBOs and deal stories
Do a paper LBO a day and practice explaining your model and deal experience out loud, as Yale SOM's career office recommends for technical interviews, case studies, and full modeling tests.
What career offices and banks say
From each career office's or firm's own published page.
Wharton MBARound two, about 3 hours
Wharton's 2018 guide says the PE case usually comes in the second round. It is either a simple LBO in Excel or a bid on a business from an information memorandum, done in about 3 hours in the office or over a weekend with a short deck.
Wharton: case interviews by industryYale SOMEarly fall of year one
Yale's career office says MBA on-cycle PE recruiting begins in early fall or late summer, often lasts only a few days, and can include full modeling tests.
Yale SOM: exploring private equityChicago BoothSample test training
Booth's Private Equity Group runs a session that walks through a sample model test and how to complete the exam.
Booth PE Group: model test trainingHarvard GSDTimed, real estate PE
Harvard's design school runs a workshop for the real estate PE modeling tests used in full-time recruiting, building a model under time limits.
Harvard GSD: J-TermJPMorganChaseOnline or live
JPMorganChase lists virtual skills assessments among its assessments, and says technical tests can be online or live with an interviewer.
JPMorganChase: how we hire, FAQsThe test gets you in the room, then you explain it
Soreno's AI interviewer asks the LBO and valuation questions that come with a modeling test, follows up on your numbers and scores you.
Questions people ask
What is an LBO modeling test?
A timed test in which you build a leveraged buyout model in Excel from a short prompt, then report the IRR, the multiple of money and whether you would invest. The sample above is one you can time yourself on.
What is a modeling test?
A timed exercise in which you build a financial model, most often an LBO, from a set of assumptions or a company's materials. It shows a firm you can do the analyst or associate work before it hires you.
Do investment banks give modeling tests?
Less often than private equity. Wharton's guide says banking interviews are technical and behavioral questions, without cases. Some banks, such as JPMorganChase, use online skills assessments for some roles.
How long is a modeling test?
From a few minutes for a paper LBO to a weekend for a take-home. Wharton describes about 3 hours in the office for the in-person case. Your invitation gives the time for yours.
Is it open book? Can I use templates?
In-office tests usually give you a blank or partly built Excel file, and JPMorganChase notes that technical assessments may take the form of online tests or technical interviews where you demonstrate your skills live with an interviewer. For a take-home case study, build from your own work for investment committee-style case prep, because the interview that follows will ask you to explain every line.
What do I hand in for a case test?
The model and a short recommendation: whether to invest, at what price, and the main risks. Wharton's example is a three-page presentation.
How is a modeling test different from a paper LBO?
A paper LBO is done by hand in minutes with round numbers. A modeling test is built in Excel and runs each year's cash and debt. Our paper LBO page and LBO model page show one of each.
Should I build a circularity switch for average-debt interest in a timed LBO test?
University of Pennsylvania Career Services notes on its LBO practice model page that topics such as a circularity switch and voluntary debt paydown are included in its basic practice model for awareness but most likely will not come up in an undergraduate interview. As practice advice, follow the prompt's interest rule and use opening debt unless average debt is requested.
When in the recruiting timeline do private equity modeling tests happen?
Yale SOM's Career Development Office notes that MBA on-cycle PE recruiting begins in early fall or late summer of the first year and often lasts only a few days, while off-cycle recruiting runs throughout the year. Wharton's MBA career guide notes that the full LBO or information memorandum case is typically presented in the second round.
How should I pace a 90-minute Excel LBO modeling test?
As practice advice, spend the first 10 minutes placing all inputs in one block, 15 minutes on sources and uses and the income statement, 25 minutes on free cash flow and the debt sweep, 15 minutes on exit equity, MOIC, and IRR, 15 minutes on balance-sheet or debt checks and one sensitivity table, and the final 10 minutes writing your investment recommendation.
Related guides
- Classes for Investment Banking: College Coursework, Modeling Training, and Licensing Exams
- Financial Modeling Interview Preparation: Statements, Metrics, and Reasoning
- Investment Banking Certification: Regulatory Licenses, the CFA Charter, and Modeling Courses
- LBO modeling: how it works and how to explain it in an interview
- LBO vs DCF: How the Two Valuation Models Differ and Work Together
- Walk me through a basic LBO.
- Where do the returns in an LBO come from?