Pharma Sales At Risk
pharma_sales_at_riskThe patent cliff, in dollars: which of a pharmaceutical company's products lose exclusivity soonest and how much reported revenue each one carries. Ask by ticker or company ("MRK", "Pfizer") for its whole portfolio ranked by expiry year, or by a single drug to place that one product. Joins the filer's own product-level revenue disaggregation from its latest 10-K to FDA exclusivity records — Orange Book listed patent and regulatory-exclusivity expirations for small molecules, Purple Book licensure and biosimilar entry for biologics — and totals revenue at risk per year. Biologics past their BPCIA 12-year floor with no biosimilar licensed (Keytruda, Gardasil) carry no FDA date and are returned separately as exposed_undated_bpcia with their own total, never assigned a year. Revenue is the last reported period, not a forecast; the expiry is the earliest date listed at FDA, before any litigation, settlement, patent-term extension, or pediatric exclusivity moves it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| drug | No | Brand name of a single drug, e.g. "Keytruda". Its marketer is resolved to a filer and that filer's portfolio is screened. Provide this or "company". | |
| company | No | Ticker or company name of the SEC filer, e.g. "MRK", "Merck", "Pfizer". Provide this or "drug". | |
| max_products | No | How many revenue lines to check, taken largest first by last reported sales. Default 12, max 25. Each one costs an FDA exclusivity lookup. | |
| horizon_years | No | How many years ahead to count as at risk. Default 10, max 25. Products expiring later are returned separately under protected_beyond_horizon. |