Spreadsheet Data
Audit the saved peer set and the method inputs behind the blended fair value.
Review the saved peer set across price, scale, operating metrics, and raw valuation multiples.
| Peer | Price | Market Cap | Enterprise Value | Revenue | EBITDA |
|---|
| Net Income |
|---|
| P/E |
|---|
| P/S |
|---|
| EV/EBITDA |
|---|
PF PFE PFIZER INC FY ended Feb 19, 2026 | $27.96 | $159.36B | $176.96B | $62.58B | $15.48B | $7.77B | 20.56x | 2.55x | 9.71x |
MR MRK Merck & Co., Inc. FY ended Jan 31, 2026 | $148.35 | $366.00B | $392.48B | $65.01B | $28.05B | $18.25B | 20.38x | 5.63x | 13.37x |
JN JNJ JOHNSON & JOHNSON FY ended Feb 06, 2026 | $268.04 | $645.95B | $703.36B | $94.19B | $37.95B | $26.80B | 24.30x | 6.86x | 17.67x |
LL LLY ELI LILLY & Co FY ended Feb 09, 2026 | $1,174.61 | $1.11T | $1.16T | $65.18B | $28.02B | $20.64B | 51.18x | 16.96x | 40.66x |
See which peer averages feed the weighted fair value and which methods are excluded.
| Method | Type | Avg. Multiple | Coverage | Implied Equity Value | Fair Value / Share | Status |
|---|---|---|---|---|---|---|
EV / EBITDA EVActive | Enterprise Multiple | 19.54x | 4/4 | $70.42B | $170.41 | Included in the active peer mix. |
Price / Sales PSActive | Equity Multiple | 8.00x | 4/4 | $75.73B | $183.27 | Included in the active peer mix. |
Price / Earnings PEActive | Equity Multiple | 29.10x | 4/4 | $77.80B | $188.27 | Included in the active peer mix. |
Open the saved peer table used to audit the fair value view.
| Peer | Price | Market Cap | Enterprise Value | Revenue | EBITDA | Net Income | P/E | P/S | EV/EBITDA |
|---|---|---|---|---|---|---|---|---|---|
PF PFE PFIZER INC FY ended Feb 19, 2026 | $27.96 | $159.36B | $176.96B | $62.58B | $15.48B | $7.77B | 20.56x | 2.55x | 9.71x |
MR MRK Merck & Co., Inc. FY ended Jan 31, 2026 | $148.35 | $366.00B | $392.48B | $65.01B | $28.05B | $18.25B | 20.38x | 5.63x | 13.37x |
JN JNJ JOHNSON & JOHNSON FY ended Feb 06, 2026 | $268.04 | $645.95B | $703.36B | $94.19B | $37.95B | $26.80B | 24.30x | 6.86x | 17.67x |
LL LLY ELI LILLY & Co FY ended Feb 09, 2026 | $1,174.61 | $1.11T | $1.16T | $65.18B | $28.02B | $20.64B | 51.18x | 16.96x | 40.66x |
Open the peer-average inputs behind the weighted result.
| Method | Type | Avg. Multiple | Coverage | Implied Equity Value | Fair Value / Share | Status |
|---|---|---|---|---|---|---|
EV / EBITDA EVActive | Enterprise Multiple | 19.54x | 4/4 | $70.42B | $170.41 | Included in the active peer mix. |
Price / Sales PSActive | Equity Multiple | 8.00x | 4/4 | $75.73B | $183.27 | Included in the active peer mix. |
Price / Earnings PEActive | Equity Multiple | 29.10x | 4/4 | $77.80B | $188.27 | Included in the active peer mix. |