Fin Maverick
Foundations VocabularyAccounting & ReportingEconomics & MacroQuant Methods & ProgrammingBusiness & Company AnalysisCorporate Finance & ValuationBehavioural Finance
Banking & Market InfrastructureFixed Income & RatesDerivatives & Structured ProductsPublic EquitiesTransactions & DealsPortfolio ConstructionFunds & AMCs
Private Markets & AlternativesRisk, Treasury & ControlAI & Digital FinanceStochastic Calculus & PricingWealth & Personal FinanceIndian Markets & RegulationProfessional Practice
CalculatorComparison
Frameworks
Explore Bootcamps
Equity ResearchPortfolio ManagementMutual Fund MasteryInvestment Banking Analyst
Private Equity AnalystQuant & Hedge Fund AnalystBreaking Into VCFinancial Analyst Program
Risk Management ProgramPrivate Wealth ManagementDebt Capital MarketsDerivatives Foundation
Explore Free Courses

Equity Research6

Writing an Investment ThesisBuilding a Discounted Cash FlowReading an Annual Report FastReading a Sector Before a CompanySpotting Quality of Earnings Red FlagsBuilding a Revenue Forecast From Drivers

Portfolio Management3

Rebalancing: When, Why and What It CostsStrategic and Tactical Asset AllocationMeasuring Risk in a Portfolio

Mutual Fund Mastery3

Comparing Funds Without Being FooledHow a NAV Is Struck and Which Day You GetReading a Fund Factsheet Properly

Derivatives Unlocked4

Hedging a Real ExposureThe Greeks, PracticallyFutures, the Basis and What Moves ItReading an Option Payoff

AI For Finance2

Retrieval and Grounding for FinanceDocument Extraction in Finance

Breaking Into Quants4

Backtesting a StrategyHypothesis TestingCleaning Financial DataRegression for Finance

Breaking Into VC3

Sizing a MarketReading a Term Sheet as a FounderHow a Venture Round Actually Works

Financial Analyst Program4

Common Size and Trend AnalysisReading a Cash Flow StatementRatio Analysis That Says SomethingBuilding a Working Capital Schedule

Risk Management Program2

Credit Exposure and How It Is ReducedValue at Risk and What It Hides

Investment Banking Analyst3

Precedent Transactions and Why They DifferReading a Term Sheet StructurallyBuilding a Comparable Companies Table

Private Wealth Management3

Tax Aware Portfolio DecisionsBuilding a Client Risk ProfileGoal Based Planning Arithmetic

Debt Capital Markets3

Analysing an Issuer's CreditDuration and What It Does Not Tell YouBond Pricing and Yield Mechanics

Private Equity Analyst2

Fund Waterfalls and CarryThe LBO in Structure

Hedge Funds Analyst2

Short Selling MechanicsLong Short Mechanics
QuarksCourses
Explore Interview Preparation
Investment BankingEquity ResearchVenture CapitalistPrivate EquityHedge Funds
QuantFinancial AnalysisPrivate Wealth ManagementDebt Capital MarketsRisk Management
Derivatives FoundationPortfolio ManagementMutual Fund Mastery
PartnershipsShowdown
Log inSign up
Interview tracksAll
1Investment Banking
Question bankPuzzlesCase studies
2Equity Research
Question bankPuzzlesCase studies
3Venture Capital
Question bankPuzzlesCase studies
4Private Equity
Question bankPuzzlesCase studies
5Hedge Funds
Question bankPuzzlesCase studies
6Quant
Question bankPuzzlesCase studies
7Financial Analysis
Question bankPuzzlesCase studies
8Private Wealth Management
Question bankPuzzlesCase studies
9Debt Capital Markets
Question bankPuzzlesCase studies
10Risk Management
Question bankPuzzlesCase studies
11Derivatives Foundation
Question bankPuzzlesCase studies
12Portfolio Management
Question bankPuzzlesCase studies
13Mutual Fund Mastery
Question bankPuzzlesCase studies
095

Case 095LBO modelling testsCore

Model debrief: your model shows about 31% IRR on Rs 300 crore of revenue, margin rising from 30% to 40%, entry at 20x EBITDA with 6x debt and exit at 18x in year 5. Which three assumptions drive the IRR, and what is it if the margin stays at 30%?

Vista Equity PartnersAustin · 2024

1The situation

You built the model for Orvel Software, a vertical software company, in the three-hour test. Revenue Rs 300 crore growing 18% a year; EBITDA margin 30% today rising in a straight line to 40% by year 5; entry at 20x EBITDA of Rs 90 crore, Rs 1,800 crore, with 6x debt at 9%; depreciation and capex Rs 10 crore each; tax 25%; all cash repays debt; exit at 18x in year 5. The model prints an IRR of about 31%.

In the debrief the interviewer asks which three assumptions the return rests on, in order, and what the IRR is if the margin never moves.

2Your task

Rank the drivers, give the IRR with a flat 30% margin, and say what the ranking means for diligence.

Quick check

Entry is 20x and exit 18x. Does the multiple contraction stop this deal from working?

Worked solution

Try it on paper, then open one step at a time.

30-second answerThe answer to give first

Margin first, exit multiple second, growth third; with a flat 30% margin the IRR drops from about 31% to about 23%. Moving margin between 30% and 45% swings IRR from 23% to 35%; the exit multiple between 14x and 22x swings it from 25% to 37%; growth between 10% and 26% swings it from 21% to 41%. Ten points of margin on Rs 686 crore of year 5 revenue is Rs 69 crore of EBITDA at 18x, and that is most of the return.

Step 1How do you find out which assumption carries the answer?

Move each one alone and watch the IRR, the way you would test which tap is leaking by closing them one at a time. Hold two of the three at base, swing the third across a plausible range, and the width of each swing is that assumption's weight. The base case has EBITDA rising from Rs 90 crore to about Rs 275 crore, exit value of about Rs 4,942 crore and debt down to about Rs 17 crore, so Rs 1,260 crore of equity becomes about Rs 4,924 crore, 3.91x. The debrief is not asking you to recite the model; it is asking whether you know which cell you would check first if the deal went wrong.

Which assumption carries the 31% IRR: swing in IRR when each one moves aloneExit margin 30% to 45%base 40%23%35%Exit multiple 14x to 22xbase 18x25%37%Revenue growth 10% to 26%base 18%21%41%base 31%Hold the margin at 30% and the IRR is 23%: the model's return is a margin story first, a multiple story second.Red: the low case. Green: the high case. Each bar moves one input and holds the other two at base.
Around the 31% base case, the exit margin is the widest bar, swinging IRR from 23% at 30% to 35% at 45%; the exit multiple is second and revenue growth third, so the model's return is a margin story before it is a growth story.
Step 2What happens if the margin never moves?

Year 5 revenue is about Rs 686 crore either way. At 40% that is Rs 275 crore of EBITDA; at 30% it is Rs 206 crore, Rs 69 crore less, which at 18x is Rs 1,235 crore of exit value gone; the IRR falls to about 23%. Less cash is generated along the way too, so debt at exit is about Rs 153 crore instead of Rs 17 crore. The return does not vanish, because 18% growth at 18x still works, but it goes from a top-quartile deal to an ordinary one on a single assumption, and that is the sentence the interviewer is waiting for.

CaseYear 5 EBITDAExit equityMOICIRR
Base: 18% growth, 40% margin, 18x2754,9243.91x31.3%
Margin stays at 30%2063,5532.82x23.0%
Exit at 14x2753,8263.04x24.9%
Growth 10%1933,3042.62x21.3%
Margin 45%3095,6104.45x34.8%
Rs crore. Holding the margin at 30% costs about 8 points of IRR, more than a four-turn fall in the exit multiple or an eight-point fall in growth, which is the ranking the debrief wants stated and then defended.
Step 3What does the ranking mean for diligence and for the memo?

That the margin plan is the deal. Ten points of margin on a software company means cutting sales and marketing as a share of revenue, raising prices, or pushing gross margin up by moving customers to cloud; each is a different plan with different evidence, and the memo should say which one and show the cost lines that move. The exit multiple is second: a 18x exit on a business that has just finished expanding margin assumes a buyer who still sees growth, so the model should show 14x as a downside, not a stress. Growth is third, which is unusual for software and is a direct result of entering at 20x, where the price already pays for the growth. Say the limit: the tornado moves one input at a time, and in a real downturn margin, multiple and growth fall together.

Where candidates lose it

The usual loss is naming growth first because it is the headline of every software deck. In this model the entry multiple has already paid for the growth, and the margin walk from 30% to 40% is where the equity gain comes from.

The second is answering the flat margin question with a guess. The interviewer has the model open; say the number, say why it moved, and say what debt does in that case.

What the interviewer asks next

  • Margin reaches 40% but only in year 5, flat at 30% until year 4. What is the IRR?
  • The lender caps leverage at 5x. Does that change which assumption matters most?
  • Build the two-way table of IRR against exit margin and exit multiple. Where does the deal clear 25%?

Asked at Vista Equity Partners, Technology, Media and Telecom (TMT), Austin, 2024 (Wall Street Oasis): Coffee chat with the recruiter, followed by CCAT, model test, model debrief, then 4 1:1 interviews

← Case 094Paper LBO with fees and a rollover: EBITDA Rs 60 crore at 9x, fees of 3% of EV, 4.5x debt, management rolls Rs 30 crore. EBITDA reaches Rs 90 crore in year 5, debt falls to Rs 150 crore, exit at 9x. What is the sponsor's MOIC and IRR, and what did the fees cost?Case 096 →Seasonality case: 60% of a stationery maker's revenue comes in two back-to-school months and inventory peaks at Rs 120 crore. How much working capital funding does it need, and what does that mean for debt sizing?

Company names and figures are illustrative.

Fin Maverick Free CoursesExplore Free Courses
Fin Maverick BootcampsExplore Bootcamps
Fin Maverick

Finance education that ends in a job, not a certificate that gathers dust. Built for young India.

LEARN
CalculatorsFrameworksComparisonsInterview RoadmapsShowdown
RESOURCES
All CoursesFree CoursesBootcampsInternships
COMPANY
AboutJob openingPartnership
LEGAL
Privacy PolicyTerms & ConditionsContent LicenseReturn & Refund Policy
© 2026 FIN MAVERICK / BUILT FOR INDIA.DO FINANCE, DO NOT JUST READ ABOUT IT.