Stock Price Trends

Procter & Gamble Company (PG)

The Procter & Gamble Company (P&G) is an American multinational consumer goods corporation headquartered in Cincinnati, Ohio, founded in 1837 by William Procter and James Gamble. It specializes in a wide range of personal health, consumer health, personal care, and hygiene products; these products are organized into several segments including Beauty; Grooming; Health Care; Fabric & Home Care; and Baby, Feminine, & Family Care. Before the sale of Pringles to Kellogg's, its product portfolio also included food, snacks, and beverages.

Stock Price Trends

Stock price trends estimated using linear regression.

Key facts

  • The primary trend is increasing.
  • The growth rate of the primary trend is 23.92% per annum.
  • PG price at the close of July 26, 2024 was $169.11 and was inside the primary price channel.
  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 5.84% per annum.
  • PG price at the close of July 26, 2024 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 PG 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: September 27, 2023
End date: July 26, 2024

a = 4.0591

b = 0.0006

s = 0.0211

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0006) – 1
= 23.92%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0211) – 1
= 8.81%

September 27, 2023 calculations

Top border of price channel:

Exp(Y1,049)
= Exp(a + b × X1,049 + 2 × s)
= Exp(a + b × 1,521 + 2 × s)
= Exp(4.0591 + 0.0006 × 1,521 + 2 × 0.0211)
= Exp(4.9950)
= $147.67

Bottom border of price channel:

Exp(Y1,049)
= Exp(a + b × X1,049 – 2 × s)
= Exp(a + b × 1,521 – 2 × s)
= Exp(4.0591 + 0.0006 × 1,521 – 2 × 0.0211)
= Exp(4.9105)
= $135.71

July 26, 2024 calculations

Top border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 + 2 × s)
= Exp(a + b × 1,824 + 2 × s)
= Exp(4.0591 + 0.0006 × 1,824 + 2 × 0.0211)
= Exp(5.1730)
= $176.44

Bottom border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 – 2 × s)
= Exp(a + b × 1,824 – 2 × s)
= Exp(4.0591 + 0.0006 × 1,824 – 2 × 0.0211)
= Exp(5.0886)
= $162.16

Description

  • The primary trend is increasing.
  • The growth rate of the primary trend is 23.92% per annum.
  • PG price at the close of July 26, 2024 was $169.11 and was inside the primary price channel.

Secondary Trend

Start date: May 2, 2024
End date: July 26, 2024

a = 4.8313

b = 0.0002

s = 0.0105

Annual growth rate:

Exp(365 × b) – 1
= Exp(365 × 0.0002) – 1
= 5.84%

Price channel spread:

Exp(4 × s) – 1
= Exp(4 × 0.0105) – 1
= 4.27%

May 2, 2024 calculations

Top border of price channel:

Exp(Y1,199)
= Exp(a + b × X1,199 + 2 × s)
= Exp(a + b × 1,739 + 2 × s)
= Exp(4.8313 + 0.0002 × 1,739 + 2 × 0.0105)
= Exp(5.1226)
= $167.78

Bottom border of price channel:

Exp(Y1,199)
= Exp(a + b × X1,199 – 2 × s)
= Exp(a + b × 1,739 – 2 × s)
= Exp(4.8313 + 0.0002 × 1,739 – 2 × 0.0105)
= Exp(5.0808)
= $160.90

July 26, 2024 calculations

Top border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 + 2 × s)
= Exp(a + b × 1,824 + 2 × s)
= Exp(4.8313 + 0.0002 × 1,824 + 2 × 0.0105)
= Exp(5.1359)
= $170.01

Bottom border of price channel:

Exp(Y1,257)
= Exp(a + b × X1,257 – 2 × s)
= Exp(a + b × 1,824 – 2 × s)
= Exp(4.8313 + 0.0002 × 1,824 – 2 × 0.0105)
= Exp(5.0940)
= $163.05

Description

  • The secondary trend is increasing.
  • The growth rate of the secondary trend is 5.84% per annum.
  • PG price at the close of July 26, 2024 was inside the secondary price channel.