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.
- 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…
- 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…
- 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)…
- 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
- 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
- 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
- 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
- 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
- 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
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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 ($)…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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 (£)…
- 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…
- 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…
- 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 (€)…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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
Build · Lab · ~15 min
DCF Builder
Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.
Build · Lab · ~3 min
IRR by Eye
Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Read · Guide · 16 min
How to Build a DCF Model: From Operating Assumptions to a Defensible Valuation