alphabet pe ratio chart, and price to (FCF = operating cash flow - capex)

I'll help you create a PE ratio chart and a Price to Free Cash Flow (FCF) chart for Alphabet (GOOGL). Let me load the necessary data.

Now let me compute the TTM metrics, FCF, EPS, and the PE and Price/FCF ratios, then merge with daily prices.

Now let me display the charts.

Data MAX
Data MAX

Both charts are displayed. Here's a summary of what was computed:

Methodology - TTM EPS = sum of trailing four quarters of Net Income ÷ current diluted shares outstanding - TTM FCF = sum of trailing four quarters of (Operating Cash Flow − Capex) - FCF per share = TTM FCF ÷ current diluted shares outstanding - P/E Ratio = Daily adjusted close ÷ TTM EPS - Price / FCF = Daily adjusted close ÷ FCF per share

Both ratios use daily adjusted close prices (from 2020-01-02 through 2026-06-17) and step up at each new quarterly earnings release as the TTM window rolls forward.

Key observations - The P/E ratio has historically traded in the 25-35x range, dipping to ~15-18x in late 2022 during the broader tech selloff, and recently sits around 22-25x as earnings have grown faster than the stock. - The Price / FCF ratio has been more volatile given Alphabet's heavy AI-related capex cycle compressing FCF — it spiked higher in 2024 as capex ramped, then has compressed as FCF growth caught up.

Underlying daily data is in DataFrame 430 if you want to inspect specific dates or build additional comparisons.

both on same chart

Data MAX

Both ratios are now displayed on a single chart for direct comparison. A few things stand out:

  • P/E (blue) is generally the more stable of the two, trending in a 20-30x band for most of the period, with a clear compression in 2024-2026 as earnings caught up to the share price.
  • Price / FCF (orange) sits noticeably above P/E for most of the timeline — that's the classic signature of heavy capex compressing FCF below net income. The gap narrowed sharply in late 2022/early 2023 and again recently, but widened materially through 2024 as Alphabet ramped AI infrastructure capex.
New