Data and model for "Valuing Staging Flexibility in Pharmaceutical R&D: A Compound Real-Option Analysis of a Dermatology Asset"

This deposit contains the empirical dataset and the valuation model underlying the MBA thesis Valuing Staging Flexibility in Pharmaceutical R&D: A Compound Real-Option Analysis of a Dermatology Asset (University of St. Gallen, 2026). The data are drawn from a single frozen ClinicalTrials.gov API v2 snapshot for atopic dermatitis (completed studies, retrieved 1 June 2026), provided as the raw response plus the cleaned per-trial and per-phase duration tables used to time the option lattice. The model is an Excel workbook implementing a compound binomial-lattice real-option valuation, passive NPV baselines, moneyness and volatility sweeps, and a decision-tree comparator. Every reported value recomputes by formula from the labelled input cells. Together these files reproduce all quantitative results in the thesis.