Stock Price Trends
Stock price trends estimated using linear regression.
Paying user area
Try for free
McKesson Corp. pages available for free this week:
- Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Short-term (Operating) Activity Ratios
- DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
- Common Stock Valuation Ratios
- Enterprise Value to EBITDA (EV/EBITDA)
- Present Value of Free Cash Flow to Equity (FCFE)
- Operating Profit Margin since 2005
- Return on Assets (ROA) since 2005
- Debt to Equity since 2005
- Price to Earnings (P/E) since 2005
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to McKesson Corp. for $22.49.
This is a one-time payment. There is no automatic renewal.
We accept:
Summary
Key facts
- The primary trend is decreasing.
- The decline rate of the primary trend is 15.48% per annum.
- MCK price at the close of October 27, 2016 was $160.50 and was inside the primary price channel.
- The secondary trend is decreasing.
- The decline rate of the secondary trend is 60.74% per annum.
- MCK price at the close of October 27, 2016 was inside the secondary price channel.
Linear Regression Model
Model equation:
Yi = α + β × Xi + εi
Top border of price channel:
Exp(Yi) = Exp(a + b × Xi + 2 × s)
Bottom border of price channel:
Exp(Yi) = Exp(a + b × Xi – 2 × s)
where:
i - observation number
Yi - natural logarithm of MCK price
Xi - time index, 1 day interval
σ - standard deviation of εi
a - estimator of α
b - estimator of β
s - estimator of σ
Exp() - calculates the exponent of e
Primary Trend
Start date:
End date:
a =
b =
s =
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × ) – 1
=
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × ) – 1
=
November 11, 2014 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
October 27, 2016 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
Description
- The primary trend is decreasing.
- The decline rate of the primary trend is 15.48% per annum.
- MCK price at the close of October 27, 2016 was $160.50 and was inside the primary price channel.
Secondary Trend
Start date:
End date:
a =
b =
s =
Annual growth rate:
Exp(365 × b) – 1
= Exp(365 × ) – 1
=
Price channel spread:
Exp(4 × s) – 1
= Exp(4 × ) – 1
=
July 18, 2016 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
October 27, 2016 calculations
Top border of price channel:
Exp(Y)
= Exp(a + b × X + 2 × s)
= Exp(a + b × + 2 × s)
= Exp( + × + 2 × )
= Exp()
= $
Bottom border of price channel:
Exp(Y)
= Exp(a + b × X – 2 × s)
= Exp(a + b × – 2 × s)
= Exp( + × – 2 × )
= Exp()
= $
Description
- The secondary trend is decreasing.
- The decline rate of the secondary trend is 60.74% per annum.
- MCK price at the close of October 27, 2016 was inside the secondary price channel.
Check current MCK price trends.
Visit our new 1,500-company website