L3VLUP
Healthcare schedules · in 1 model

Clinical probability and stage gating

The chance of reaching the market, and what it weights.

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

On this subject: clinical probability and stage gating.Updated 30 September 2026

What it does

The probability that turns a pipeline into a valuation. Each stage has a chance of passing; the chance of reaching the market from where a programme stands is the product of the stages still ahead. The schedule applies a weight of one to cash flows inside the current stage, because that money is being spent regardless, and the probability to everything after it, revenue and later-stage costs alike.

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.

Biotech rNPV and sum-of-the-parts model
  • Assumptions, rows 19–22: Phase 1 to Phase 2, Phase 2 to Phase 3, Phase 3 to filing, Filing to approval
  • Programmes, rows 6–9: Current stage (1, 2 or 3), Last year of the current stage, Launch year, Loss of exclusivity: first year of generic competition
  • Programme A, rows 6–8: Probability of reaching the market from here (product of the remaining stages), Year, Risk weight: 1 inside the current stage, the probability after it
  • Programme B, rows 6–8: Probability of reaching the market from here (product of the remaining stages), Year, Risk weight: 1 inside the current stage, the probability after it
  • Programme C, rows 6–8: Probability of reaching the market from here (product of the remaining stages), Year, Risk weight: 1 inside the current stage, the probability after it

What a reviewer looks for

  • Risk-adjusting revenue but not the later trials.
  • Using the probability of the next stage alone as if it were the probability of approval.
  • Stage risk carried in the discount rate as well as the probability.

Learn it, then build it

Vocabulary: Probability of Technical and Regulatory Success (PTRS), rNPV (Risk-Adjusted Net Present Value).

Other healthcare schedules