DCF Analysis of Bristol Myers Squibb Equity Valuation
This paper presents a discounted cash flow (DCF) analysis of equity at Bristol Myers Squibb, using historical equity data from 2007 to 2011 as a baseline for projecting equity levels and return on equity (ROE) over the subsequent five-year period (2012–2016). The analysis incorporates mean equity growth, mean ROE, and their respective standard deviations to produce base-case, optimistic, and pessimistic projection scenarios. A three percent annual inflation rate is applied as a discount rate throughout. The result is a comprehensive, multi-scenario valuation that estimates both year-by-year and cumulative expected equity returns in current and future dollars.
- Overview of the DCF Approach: Introduces the DCF methodology and discount rate assumptions
- Projecting Equity Levels at Bristol Myers Squibb: Projects equity using historical mean and inflation discount
- Estimating Return on Equity: Applies mean ROE as multiplier across projected equity values
- Optimistic and Pessimistic Scenario Projections: Builds three scenarios using standard deviation adjustments
✍️ How to write this paper — guide, tools & examples ▾
What makes this paper effective
- The paper applies a consistent methodological framework across all metrics — mean plus/minus one standard deviation — producing directly comparable base, optimistic, and pessimistic scenarios.
- It grounds all projections in a clearly defined historical observation period (2007–2011), lending empirical credibility to the forward-looking estimates.
- The use of both current-dollar and future-dollar reporting adds analytical nuance, demonstrating awareness of the time value of money beyond a basic discounting step.
Key academic technique demonstrated
The paper demonstrates scenario analysis within a DCF framework: rather than presenting a single-point estimate, the author constructs three distinct trajectories by systematically varying inputs by one standard deviation. This technique acknowledges forecast uncertainty without abandoning quantitative rigor, which is a hallmark of applied financial analysis at the undergraduate level.
Structure breakdown
The paper is organized into three tightly sequenced paragraphs. The first establishes the equity projection methodology and baseline assumptions. The second applies those equity projections to estimate ROE using mean observed values as multipliers. The third extends the model into optimistic and pessimistic scenarios using standard deviation adjustments, concluding with a summary of the method's analytical scope.
Overview of the DCF Approach
A discounted cash flow (DCF) analysis of equity at Bristol Myers Squibb requires first predicting how equity values will change from year to year. This is accomplished through a brief analysis of equity levels at the company during a five-year observation period (2007–2011), during which the company recorded an average (mean) equity growth of $1,326.26 million per year, with a standard deviation of $1,005.861 million. An annual inflation rate of three percent is assumed and used to discount the present value of future equity levels throughout the analysis.
Projecting Equity Levels at Bristol Myers Squibb
The observed mean change in equity was used to project equity levels for the next five years (2012–2016), with each year's expected equity level increased by the mean observed change. The three percent discount rate was then applied to convert future equity levels into current-dollar values. This approach allows for the computation of a sum total of expected equity values over the projection period and yields both a future-dollar and a current-dollar figure for the final expected equity amount at the end of 2016, enabling a more detailed, nuanced, and reliable estimation of the company's future value.
Create your account
Always verify citation format against your institution’s current style guide requirements.