Study guides / PE: Private Equity Interviews / Modeling tests & case studies
Modeling tests & case studies
PE: Private Equity Interviews · quick review
Most PE processes include a timed LBO modeling test or a take-home case, often with a short investment memo.
The rules
- Formats: a 1–3 hour timed LBO in Excel from a prompt, or a take-home case over a few days with a model and memo, sometimes presented to the team.
- Build a working model end to end first: sources and uses, operating model, debt schedule, returns. Refine only after it runs.
- Debt schedule: mandatory amortization first, then a cash sweep of excess free cash flow. Interest on average balances creates a circular reference; use beginning balances or an iteration switch.
- Sensitivity tables show IRR across entry and exit multiples, leverage or growth, which is how a committee sees the risk.
- The memo: recommendation first, then thesis, returns in base and downside cases, key risks and mitigants, and diligence questions.
Formulas
- Debt repaid in a year: mandatory amortization + sweep of the remaining cash
- Memo structure: recommendation → thesis → returns → risks → diligence
Common traps
- Running out of time with a beautiful but unfinished model.
- Hard-coding numbers inside formulas, which makes errors hard to find.
- A memo that describes the company but never recommends.
How it's tested
The modeling test is often the final hurdle before an offer. Accuracy, speed and a clear recommendation matter most.
Practise it
The full lesson, worked examples and practice questions are in Tickmark, where every answer choice is explained.
Open the full lesson