Valuation and returns · in 40 models

Sensitivity tables

Two assumptions at once, without a data table.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: sensitivity tables.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

Part of credit and restructuring models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of healthcare financial models, with the models, labs and guides around it.

Part of technology company financial models, with the models, labs and guides around it.

What it does

A grid that shows an output for every pair of two assumptions: share price against discount rate and growth, or MOIC against entry and exit multiple. Spreadsheets offer a data-table feature for this; the models here write each cell as a formula instead, so that the arithmetic is visible, the grid recalculates on its own, and the centre cell can be checked against the main sheet.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Discounted cash flow model
  • Sensitivity, rows 5–7: WACC increment, Terminal growth increment, Exit multiple increment
  • Sensitivity, rows 10–15: Perpetuity growth rate, Implied value per share, Implied value per share, Implied value per share…
  • Sensitivity, rows 18–25: Terminal EBITDA multiple, FY5E, Implied value per share, Implied value per share, Implied value per share…
Leveraged buyout model
  • Sensitivity, row 5: Multiple increment
  • Sensitivity, rows 8–13: Exit year, MOIC, MOIC, MOIC…
  • Sensitivity, rows 16–21: Exit year, IRR, IRR, IRR…
  • Sensitivity, rows 24–31: Exit multiple, MOIC, MOIC, MOIC…
Merger model: accretion and dilution
  • Sensitivity, rows 5–7: Offer premium increment, Stock consideration increment, Run-rate synergy increment
  • Sensitivity, rows 10–15: Stock consideration, % of total, Accretion / (dilution), Accretion / (dilution), Accretion / (dilution)…
  • Sensitivity, rows 18–25: Run-rate cost synergies, pre-tax ($m), Accretion / (dilution), Accretion / (dilution), Accretion / (dilution)…
Merger arbitrage model: deal spread, break risk and position size
  • Sensitivity, rows 5–6: Probability of completion increment, Months to completion increment
  • Sensitivity, rows 9–15: Target share price, today, Offer value, Higher bid, Break price…
  • Sensitivity, rows 18–23: Months to completion, Expected annualised return, Expected annualised return, Expected annualised return…
  • Sensitivity, row 26: Check: grid centre less the model’s expected annualised return
Private equity fund model: cash flows, J-curve and waterfall
  • Sensitivity, rows 5–8: Holding period increment, Gross multiple increment, Preferred return increment, Carry rate increment
  • Sensitivity, rows 11–16: Gross multiple of invested capital (x), Net IRR to LPs, Net IRR to LPs, Net IRR to LPs…
  • Sensitivity, rows 20–25: Carried interest rate, Carried interest, life of the fund, Carried interest, life of the fund, Carried interest, life of the fund…
  • Sensitivity, row 28: Check: grid centres - model net IRR and carried interest
Private equity secondaries model: pricing an LP stake
  • Sensitivity, rows 5–7: Bid increment, Exit multiple increment, Target IRR increment
  • Sensitivity, rows 10–15: Adjustment to every exit multiple of NAV (x), Buyer IRR, Buyer IRR, Buyer IRR…
  • Sensitivity, rows 19–24: Adjustment to every exit multiple of NAV (x), Maximum bid, % of reference NAV, Maximum bid, % of reference NAV, Maximum bid, % of reference NAV…
  • Sensitivity, row 27: Check: grid centres - model IRR and maximum bid
CLO cash flow and waterfall model
  • Sensitivity, rows 5–6: Default rate increment, Recovery rate increment
  • Sensitivity, rows 9–12: Annual default rate, Equity IRR (annualised), Equity IRR (annualised), Equity IRR (annualised)
  • Sensitivity, rows 16–19: Annual default rate, Interest diverted, total ($m), Interest diverted, total ($m), Interest diverted, total ($m)
  • Sensitivity, row 22: Check: grid centres - model equity IRR and interest diverted
Carve-out and standalone cost model
  • Sensitivity, rows 5–6: Entry multiple increment, Standalone cost overrun increment
  • Sensitivity, rows 9–18: Standalone cost carried per unit of cost factor, Carried forward to exit at the after-tax interest rate, Sum of the carried-forward unit costs, FY5 run-rate standalone cost per unit of cost factor…
  • Sensitivity, rows 21–26: Standalone cost overrun, Sponsor IRR, Sponsor IRR, Sponsor IRR…
  • Sensitivity, rows 30–33: Highest entry multiple in the grid that clears the target IRR, at the model’s overrun, Price at that multiple, Check: grid centre - model IRR
Regulated utility model: electricity network
  • Sensitivity, rows 5–8: Allowed ROE increment, Equity layer increment, Cost of equity increment, Long-run growth increment
  • Sensitivity, rows 11–16: EPS, FY1, Allowed ROE, FY1, Operating costs, lag and write-offs, after tax, FY1, Allowed cost of debt less the interest rate, after tax…
  • Sensitivity, rows 19–24: Equity layer, EPS, FY1 ($), EPS, FY1 ($), EPS, FY1 ($)…
  • Sensitivity, rows 29–34: Long-run rate base growth, Equity value per share ($), Equity value per share ($), Equity value per share ($)…
  • Sensitivity, row 38: Check: grid centres - model EPS and value per share
Renewables project finance model
  • Sensitivity, rows 5–8: PPA price increment, Capacity factor increment, Capex overrun increment, Merchant price increment
  • Sensitivity, rows 11–14: PPA price, O1 ($/MWh), Equity IRR, Equity IRR, Equity IRR
  • Sensitivity, rows 18–23: Merchant price, % of the selected curve, Minimum DSCR, Minimum DSCR, Minimum DSCR…
  • Grid Workings, rows 6–14: CFADS per $1/MWh of PPA price, CFADS from merchant energy and certificates, CFADS from everything else, Discount factor to commercial operation, within the tenor…
  • Grid Workings, rows 17–31: Equity cash flow: capacity factor row 1, PPA price column 1, Equity cash flow: capacity factor row 1, PPA price column 2, Equity cash flow: capacity factor row 1, PPA price column 3, Equity cash flow: capacity factor row 1, PPA price column 4…
  • Grid Workings, rows 34–38: DSCR: merchant price column 1, DSCR: merchant price column 2, DSCR: merchant price column 3, DSCR: merchant price column 4…
Aircraft leasing model
  • Sensitivities, rows 5–8: Lease rate factor increment, Sale value increment, Price paid increment, Interest rate increment
  • Sensitivities, rows 11–14: Lease rate factor, change on every lease (% a month), Equity IRR, Equity IRR, Equity IRR
  • Sensitivities, rows 18–21: Interest rate, change on the loan and refinancing, Equity IRR, Equity IRR, Equity IRR
  • Grid Workings, rows 6–9: Equity cash per 1% a month of lease rate factor, Net sale proceeds, selected case, Net cash from the loan, Loan balance, opening
  • Grid Workings, rows 12–26: Sale value row 1, lease rate factor column 1, Sale value row 1, lease rate factor column 2, Sale value row 1, lease rate factor column 3, Sale value row 1, lease rate factor column 4…
  • Grid Workings, rows 29–43: Price paid row 1, interest rate column 1, Price paid row 1, interest rate column 2, Price paid row 1, interest rate column 3, Price paid row 1, interest rate column 4…
Data centre colocation model
  • Sensitivities, rows 5–7: Rent increment, Exit cap rate increment, Development cost increment
  • Sensitivities, rows 10–13: Exit cap rate, Equity IRR, Equity IRR, Equity IRR
  • Sensitivities, rows 17–22: Rent, Y1 ($ per kW a month), Yield on cost, Yield on cost, Yield on cost…
  • Grid Workings, rows 6–8: CFADS per $1 per kW a month of Y1 rent, In the year after conversion, In the year after the exit
  • Grid Workings, rows 11–15: Opening balance, Amortisation, Repaid at the exit, Closing balance…
  • Grid Workings, rows 18–23: Drawn, Opening balance, Closing balance, Interest and fees…
  • Grid Workings, rows 26–34: Rent row 1: change in Y1 rent, Rent row 1: term loan, Rent row 1: NOI in the year after the exit, Rent row 2: change in Y1 rent…
  • Grid Workings, rows 37–51: Rent row 1, exit cap rate column 1, Rent row 1, exit cap rate column 2, Rent row 1, exit cap rate column 3, Rent row 1, exit cap rate column 4…
Telecom tower model: tenancies per tower
  • Sensitivity, rows 5–6: Colocation gross additions increment, Entry multiple increment
  • Sensitivity, rows 9–14: Tenancy ratio, FY8 (tenants per tower), Equity IRR, Equity IRR, Equity IRR…
  • Sensitivity, row 17: Check: grid centre - model equity IRR
  • Grid Workings, rows 6–20: Share of opening colocation tenancies lost: churn + consolidation, Added colocation tenancies, ground, closing, Added colocation tenancies, ground, average, Added colocation tenancies, rooftop, closing…
  • Grid Workings, rows 23–32: Change in tax, column 1, Equity cash flows, column 1, Change in tax, column 2, Equity cash flows, column 2…
  • Grid Workings, rows 35–59: Entry row 1, column 1, Entry row 1, column 2, Entry row 1, column 3, Entry row 1, column 4…
Upstream oil and gas model: E&P
  • Sensitivity, rows 5–6: WTI increment, Discount rate increment
  • Sensitivity, rows 9–14: Discount rate, NAV per share, NAV per share, NAV per share…
  • Sensitivity, rows 17–24: Field cash flow per $1 on WTI, After-tax cash flow, WTI -2 increments, After-tax cash flow, WTI -1 increment, After-tax cash flow, WTI as the deck…
Mining model: copper-gold mine NAV
  • Sensitivity, rows 5–8: Copper price increment, Discount rate increment, Head grade increment, Strip ratio increment
  • Sensitivity, rows 11–16: Discount rate, real, NAV per share, NAV per share, NAV per share…
  • Sensitivity, rows 19–24: Strip ratio, FY1, All-in sustaining cost per pound, All-in sustaining cost per pound, All-in sustaining cost per pound…
  • Sensitivity, rows 28–33: Ore milled, Strip ratio, Copper head grade, Payable copper…
  • Sensitivity, rows 36–53: Cash flow per $1 on the copper price, Cumulative taxable income, copper -2 increments, Cumulative income taxed, copper -2 increments, After-tax cash flow, copper -2 increments…
Container shipping model: liner company
  • Sensitivity, rows 5–8: Freight rate increment, Load factor increment, Discount rate increment, Multiple increment
  • Sensitivity, rows 11–15: EBIT, Slots available, Average freight rate, Load factor…
  • Sensitivity, rows 18–23: Load factor, FY1, EBIT, FY1, EBIT, FY1, EBIT, FY1…
  • Sensitivity, rows 27–34: Through-the-cycle multiple, Equity value per share ($), Equity value per share ($), Equity value per share ($)…
Healthcare services model: hospital operator
  • Sensitivity, rows 5–7: Commercial share increment, Wage inflation increment, Multiple increment
  • Sensitivity, rows 10–15: Years from FY0 to FY5, Net revenue, EBITDA, Labour cost…
  • Sensitivity, rows 18–23: Wage inflation, EBITDA margin, FY5, EBITDA margin, FY5, EBITDA margin, FY5…
  • Sensitivity, rows 26–33: Exit multiple, Equity IRR, Equity IRR, Equity IRR…
Pharma royalty and licensing model
  • Sensitivity, rows 5–6: Peak sales increment, Price increment
  • Sensitivity, rows 9–16: Price paid, Purchase IRR, Purchase IRR, Purchase IRR…
  • Sensitivity, rows 19–39: Year, Peak net sales, row 1, Net sales, row 1, Royalty earned, row 1…
  • Sensitivity, rows 42–66: Peak row 1, price column 1, Peak row 1, price column 2, Peak row 1, price column 3, Peak row 1, price column 4…
Airline operating and valuation model
  • Valuation, rows 42–49: Revenue from one more point of load factor, Less operating costs that rise with it, Less depreciation of other capital spending, EBIT from one more point of load factor…
  • Valuation, rows 52–56: Fuel cost from $100 a tonne more, Net working capital from it, Free cash flow from it, Present value of the free cash flow…
  • Sensitivity, rows 5–8: Load factor increment, Fuel price increment, Yield increment, CASK ex-fuel increment
  • Sensitivity, rows 11–16: Market fuel price, FY1E ($ per tonne), Value per share, Value per share, Value per share…
  • Sensitivity, rows 19–27: CASK ex-fuel, FY1E (US cents), EBIT margin, EBIT margin, EBIT margin…
Bank operating and valuation model
  • Sensitivity, rows 5–8: Cost of equity increment, Terminal ROTE increment, Loan growth increment, FY1E, Additional cost of risk increment
  • Sensitivity, rows 11–16: Cost of equity, Value per share, Value per share, Value per share…
  • Sensitivity, rows 19–26: Gross loan growth, FY1E, CET1 ratio, CET1 ratio, CET1 ratio…
  • Sensitivity, rows 29–34: Gross loans, Average gross loans, Interest income on loans, Lending and card fees…
Consumer lending model: loan vintages
  • Sensitivity, rows 5–8: Loss rate increment, Portfolio yield increment, Sustainable ROTE increment, Cost of equity increment
  • Sensitivity, rows 11–19: Profit before tax, Average receivables, Charge-offs on the base loss curve, Charge-offs, % of the base loss curve…
  • Sensitivity, rows 22–27: Portfolio yield, Return on equity, FY1E, Return on equity, FY1E, Return on equity, FY1E…
  • Sensitivity, rows 31–38: Cost of equity, Value per share, Value per share, Value per share…
Insurance underwriting and valuation model
  • Sensitivity, rows 5–8: Combined ratio increment, FY1E, Investment yield increment, FY1E, Property catastrophe loss ratio increment, FY1E, Premium growth increment, FY1E
  • Sensitivity, rows 11–17: Reserves retained per point of loss ratio, FY1E, Investment yield, FY1E, Value per share, Value per share…
  • Sensitivity, rows 20–27: Gross written premium growth, FY1E, Solvency ratio, Solvency ratio, Solvency ratio…
  • Sensitivity, rows 30–46: Motor: net written premium, Motor: net earned premium, Motor: claims before property catastrophe, Motor: closing reserves before property catastrophe…
Asset manager AUM and fee economics model
  • Sensitivity, rows 5–7: Net flow increment, Fee compression increment, P/E increment
  • Sensitivity, rows 10–15: Extra fee compression (bp a year), Operating margin, Operating margin, Operating margin…
  • Sensitivity, rows 18–25: Forward P/E, Value per share, Value per share, Value per share…
  • Sensitivity, rows 28–52: Row 1: equities closing AUM, Row 1: fixed income closing AUM, Row 1: multi-asset closing AUM, Row 1: alternatives closing AUM…
Professional services utilisation model
  • Sensitivity, rows 5–8: Firm utilisation increment, Realisation increment, Leverage increment, Non-partner attrition increment
  • Sensitivity, rows 11–16: Realisation, Operating margin, Operating margin, Operating margin…
  • Sensitivity, rows 19–26: Non-partner attrition, Profit per partner, Profit per partner, Profit per partner…
  • Sensitivity, rows 29–43: Standard value of hours billed, Firm utilisation, Staff costs, Occupancy, technology and central costs…
FP&A budget and variance model
  • Forecast, rows 73–74: Revenue in the months not yet closed, Gross margin in the months not yet closed
  • Sensitivities, rows 5–6: Volume increment, Price increment
  • Sensitivities, rows 9–14: Volume, change on the selected case, Full-year EBITDA, Full-year EBITDA, Full-year EBITDA…
Multi-store retail model
  • Sensitivity, rows 5–8: Like-for-like growth increment, Markdown rate increment, Discount rate increment, Terminal growth increment
  • Sensitivity, rows 11–15: Years from FY0 to FY5, Store sales, Net online sales, Gross profit…
  • Sensitivity, rows 18–23: Markdowns, % of full-price value, EBIT margin, FY5, EBIT margin, FY5, EBIT margin, FY5…
  • Sensitivity, rows 26–33: Terminal growth, Value per share (£), Value per share (£), Value per share (£)…
Restaurant franchise roll-out model
  • Sensitivity, rows 5–8: Average unit volume increment, Build cost increment, Royalty rate increment, Discount rate increment
  • Sensitivity, rows 11–16: Build cost ($m), Cash-on-cash return, mature, Cash-on-cash return, mature, Cash-on-cash return, mature…
  • Sensitivity, rows 19–31: Share of a change in EBITDA kept after tax, Company segment EBITDA, FY5, Franchise segment EBITDA, FY5, Corporate costs, FY5…
Payments processing and monetisation model
  • Sensitivity, rows 5–7: Volume growth increment, Net take rate increment, EV / EBITDA increment
  • Sensitivity, rows 10–15: Net transaction take rate, FY3E (bp), EBITDA margin, EBITDA margin, EBITDA margin…
  • Sensitivity, rows 18–25: EV / FY1E EBITDA, Value per share, Value per share, Value per share…
  • Sensitivity, rows 28–39: TPV, TPV growth, a year, FY0A to FY3E, Net transaction take rate, Issuing and foreign exchange revenue…
Telecom operator model: mobile and fibre
  • Sensitivity, rows 5–8: Postpaid churn increment, Postpaid ARPU growth increment, Discount rate increment, Terminal growth increment
  • Sensitivity, rows 11–18: EBITDAaL, Opening postpaid subscribers, Average postpaid subscribers, Postpaid churn…
  • Sensitivity, rows 21–26: Postpaid ARPU growth, FY1, EBITDAaL, FY1, EBITDAaL, FY1, EBITDAaL, FY1…
  • Sensitivity, rows 30–37: Terminal growth rate, Equity value per share (€), Equity value per share (€), Equity value per share (€)…
Semiconductor foundry model
  • Sensitivity, rows 5–8: Utilisation increment, every node, Price per wafer increment, every node, WACC increment, Terminal growth increment
  • Sensitivity, rows 11–16: Price per wafer, change on every node, Gross margin, Gross margin, Gross margin…
  • Sensitivity, rows 20–28: Terminal growth, Value per share, Value per share, Value per share…
  • Sensitivity, rows 31–43: Advanced: capacity, Advanced: utilisation, Advanced: price per wafer, Advanced: variable cost per wafer shipped…
GPU cloud infrastructure model
  • Sensitivity, rows 5–8: GPU useful life increment, Contracted price increment, every cohort, On-demand utilisation increment, Power price increment
  • Sensitivity, rows 11–16: GPU useful life (years), EBIT margin, EBIT margin, EBIT margin…
  • Sensitivity, rows 19–26: Power price, Y1 ($ per MWh), Minimum liquidity, Minimum liquidity, Minimum liquidity…
  • Sensitivity, rows 29–35: Revenue, Contracted GPU-hours, EBITDA, Fit-out depreciation…
  • Sensitivity, rows 38–66: Liquidity before refinancing, selected scenario, On-demand receipts to date, Power for contracted hours to date, Power for on-demand hours to date…
ICG management buyout model
  • Sensitivity, row 5: Multiple increment
  • Sensitivity, rows 8–13: Exit year, Ordinary MOIC, Ordinary MOIC, Ordinary MOIC…
  • Sensitivity, rows 16–21: Exit year, Ordinary IRR, Ordinary IRR, Ordinary IRR…
  • Sensitivity, rows 24–32: Exit year, Preferred MOIC, Preferred MOIC, Preferred MOIC…
Duolingo operating model
  • Sensitivity, rows 5–7: Discount rate increment, Terminal growth increment, Exit multiple increment
  • Sensitivity, rows 10–15: Terminal growth, Value per share, Value per share, Value per share…
  • Sensitivity, rows 18–25: Exit multiple, Value per share, Value per share, Value per share…
Airbnb operating model
  • Sensitivity, rows 5–7: Discount rate increment, Terminal growth increment, Exit multiple increment
  • Sensitivity, rows 10–15: Terminal growth, Value per share, Value per share, Value per share…
  • Sensitivity, rows 18–26: Exit multiple, Value per share, Value per share, Value per share…
Spotify operating model
  • Sensitivity, rows 5–7: Discount rate increment, Terminal growth increment, Exit multiple increment
  • Sensitivity, rows 10–15: Terminal growth, Value per share, Value per share, Value per share…
  • Sensitivity, rows 18–26: Exit multiple, Value per share, Value per share, Value per share…
CoreWeave operating model
  • Sensitivity, rows 5–8: Cash margin increment, Interest rate increment, Useful life increment, Revenue per MW increment
  • Sensitivity, rows 11–16: Interest rate, Coverage, Coverage, Coverage…
  • Sensitivity, rows 19–27: Useful life of technology equipment (years), Operating margin, Operating margin, Operating margin…
Adyen operating model
  • Sensitivity, rows 5–7: Discount rate increment, Terminal growth increment, Exit multiple increment
  • Sensitivity, rows 10–15: Terminal growth, Value per share, Value per share, Value per share…
  • Sensitivity, rows 18–26: Exit multiple, Value per share, Value per share, Value per share…
AerCap operating model
  • Sensitivity, rows 5–6: Cost of equity increment, Terminal growth increment
  • Sensitivity, rows 9–16: Growth after FY2030E, Value per share, Value per share, Value per share…
Independent trading business model
  • Sensitivity, rows 5–8: Sharpe ratio increment, Volatility target increment, Starting capital increment, Fixed costs increment
  • Sensitivity, rows 11–16: Volatility target, annual, Closing own capital, month 36, Closing own capital, month 36, Closing own capital, month 36…
  • Sensitivity, rows 20–25: Fixed costs a month, before the draw ($k), Months of runway, Months of runway, Months of runway…
  • Workings, rows 18–42: Net return a month: Sharpe row 1, volatility column 1, Net return a month: Sharpe row 1, volatility column 2, Net return a month: Sharpe row 1, volatility column 3, Net return a month: Sharpe row 1, volatility column 4…
  • Workings, rows 45–69: Own capital: Sharpe row 1, volatility column 1, Own capital: Sharpe row 1, volatility column 2, Own capital: Sharpe row 1, volatility column 3, Own capital: Sharpe row 1, volatility column 4…
Creator and newsletter model
  • Sensitivity, rows 5–8: Conversion increment, Paid churn increment, Organic growth increment, Sponsorship CPM increment
  • Sensitivity, rows 11–14: Free-to-paid conversion a month, Revenue, month 36, Revenue, month 36, Revenue, month 36
  • Sensitivity, rows 18–23: Growth in organic sign-ups a month, Cash, month 36, Cash, month 36, Cash, month 36…
  • Workings, rows 6–20: Paid: churn row 1, conversion column 1, Paid: churn row 1, conversion column 2, Paid: churn row 1, conversion column 3, Paid: churn row 1, conversion column 4…
  • Workings, rows 23–32: List: growth column 1, Paid: growth column 1, List: growth column 2, Paid: growth column 2…
  • Workings, rows 35–38: Net revenue per average paid subscriber, before any per-subscriber fee, Per-subscriber platform fee on the closing list, Opens sold per subscriber on the closing list, per 1,000, Other revenue less spend that does not move with the list

What a reviewer looks for

  • A data table whose row and column inputs point at the wrong cells.
  • A grid whose centre does not match the model, which means one of the two is stale.
  • Increments so small that every cell shows the same result.

Learn it, then build it

Vocabulary: DCF, IRR.

Other valuation and returns