FREE TOOL · LIVE DATA
CELG-RI DCF Calculator
Run your own discounted cash flow valuation for Bristol-Myers Squibb Company Ce. The calculator is pre-filled with real data — $5.0B free cash flow (FY2018) and the live share price — so you only adjust the assumptions.
SEARCH STOCK
Search to auto-fill real company data
COMPANY DATA
YOUR ASSUMPTIONS
YOUR DCF RESULT
CALCULATED FAIR VALUE
$57.61
MARKET
$0.11
YOUR DCF
$57.61
MARGIN
$57.50
VALUE BREAKDOWN
SENSITIVITY CHECK
Try adjusting growth rate by ±2% and discount rate by ±1% to see how sensitive your fair value is to assumptions.
COMPARE WITH FPI FAIR VALUE
Your DCF reflects your assumptions. As an independent reference, here is Fair Price Index's daily blended fair value for Bristol-Myers Squibb Company Ce — DCF (50%), relative valuation (30%), and analyst consensus (20%):
Frequently Asked Questions
What is CELG-RI's free cash flow?
Bristol-Myers Squibb Company Ce generated $5.0 billion of free cash flow in fiscal year 2018. That figure is pre-filled in the calculator above and refreshed daily.
How do I calculate CELG-RI's fair value with a DCF?
Project Bristol-Myers Squibb Company Ce's free cash flow forward at your assumed growth rate, discount each year back at your required return (WACC), add a terminal value, and divide by shares outstanding. The calculator above does all of this instantly as you adjust the assumptions.
What growth rate should I use for CELG-RI?
Anchor on history and sector reality: look at Bristol-Myers Squibb Company Ce's revenue and cash flow growth over the past five to ten years, then ask what is sustainable going forward. Testing a conservative and an optimistic scenario matters more than any single number.
Is CELG-RI undervalued right now?
That depends on the assumptions you feed the model — that is the point of running your own DCF. For an independent reference, Fair Price Index publishes a daily fair value for Bristol-Myers Squibb Company Ce blending DCF, relative valuation, and analyst consensus.
GET ALERTS
Track CELG-RI's fair value daily
Download Fair Price Index and get notified when Bristol-Myers Squibb Company Ce's valuation shifts.
Trusted by 500+ investors · Free tier available · PRO $2.99/month
RELATED
STOCK
CELG-RI Stock Analysis
Full fair value breakdown, FPI Rating, and fundamentals for Bristol-Myers Squibb Company Ce.
Open →TOOL
DCF Calculator
The general-purpose version — search any of the top 10K stocks.
Open →ARTICLE
DCF Model Explained
How discounted cash flow works, step by step, with worked examples.
Read →This calculator is for educational purposes only and does not constitute investment advice. Pre-filled figures come from the latest reported financials and may differ from other sources. Always verify against the company's filings.