Annual Capex

Annual Capital Expenditure Table Builder

Extract and display annual Capital Expenditure for $0 covering the past 10 fiscal years by browsing Yahoo Finance in Chrome.

Multi-Ticker Support

The argument $0 may contain multiple tickers separated by commas (e.g., AAPL,MSFT,GOOG).

1. Parse $0 by splitting on commas and trimming whitespace to get a list of tickers.
2. Always use the Task tool to launch one subagent per ticker in parallel (all Task calls in a single message). Each subagent should:

• Receive the full instructions from Step 1 onward, with $0 replaced by its single ticker
• Be of type general-purpose
• Work independently to extract data and build the tables

1. If there is only one ticker, present the subagent's Table 2 (YoY growth rates) directly; skip Table 1 (raw data).
2. If there are multiple tickers, combine all results into a single summary table with fiscal years as rows and paired columns per ticker (value + YoY):

| FY | TICKER1 | YoY | TICKER2 | YoY | |----|---------|-----|---------|-----| | 2025 | $X.XXB | +X.X% | $X.XXB | +X.X% | | 2024 | $X.XXB | -X.X% | $X.XXB | +X.X% | | ... | ... | ... | ... | ... | | 2016 | $X.XXB | – | $X.XXB | – |

Replace TICKER1, TICKER2, etc. with actual ticker symbols. Use – for the earliest year's YoY (no prior year data). Do not present separate tables per ticker.

Step 1: Navigate to Yahoo Finance Cash Flow Statement

1. List pages and select an existing Yahoo Finance page (or any available page).
2. Navigate to https://finance.yahoo.com/quote/$0/cash-flow/
3. Wait for the page to load.

Step 2: Ensure Annual View is Selected

1. Take a snapshot of the page.
2. The default view should be "Annual". Verify by checking the snapshot. If the "Quarterly" tab is currently selected, save the snapshot to a file, use Grep to find the "Annual" tab element, and click it.

Step 3: Extract Column Headers and Capital Expenditure Data

Use evaluate_script to extract the table headers and Capital Expenditure row in one call:

() => {
  const rows = document.querySelectorAll('div.tableBody div.row');
  const result = {};

  // Get column headers
  const headerRow = document.querySelector('div.tableHeader div.row');
  const headers = [];
  if (headerRow) {
    headerRow.querySelectorAll('div.column').forEach(col => {
      headers.push(col.textContent.trim());
    });
  }

  // Find Capital Expenditure row
  rows.forEach(row => {
    const label = row.querySelector('div.column div.rowTitle');
    if (label && label.textContent.trim() === 'Capital Expenditure') {
      const columns = row.querySelectorAll('div.column');
      const values = [];
      columns.forEach(col => {
        values.push(col.textContent.trim());
      });
      result.label = 'Capital Expenditure';
      result.values = values;
    }
  });

  result.headers = headers;
  return result;
}

This returns:

• headers: Array starting with ["Breakdown", "TTM", "MM/DD/YYYY", ...] — fiscal year-end dates
• values: Array starting with ["Capital Expenditure", "", "", ...]

Step 4: Parse and Organize Data

1. Skip the first header ("Breakdown") and first value ("Capital Expenditure").
2. Skip the TTM column (second header / second value) if present.
3. Pair each remaining header (date string like "12/31/2024") with its corresponding CapEx value.
4. Parse each date to extract the fiscal year-end date and the year.
5. Filter to the past 10 fiscal years only. If the current year is incomplete or shows "--", still include it and mark as "N/A".
6. CapEx values of "--" should be treated as missing/N/A.
7. CapEx values from Yahoo Finance are displayed in thousands and are typically negative (e.g., "-6,345,000" means -$6.345B in spending). Parse by removing commas and converting to numbers. For display, show as positive values (absolute value) since CapEx is understood to be an outflow. Format in millions (divide absolute value by 1,000) with one decimal place and an M suffix, or in billions (divide absolute value by 1,000,000) with two decimal places and a B suffix — choose whichever is more readable for the company's scale.

Step 5: Build Table 1 — Annual Capital Expenditure

Present a markdown table with this format:

| Fiscal Year End | Capital Expenditure | YoY Change |
|-----------------|---------------------|------------|
| 12/31/2024      | $X.XXB              |            |
| 12/31/2023      | $X.XXB              |            |
| ...             | ...                 |            |

• Show dollar signs on all values.
• Bold the year values.
• Order rows from most recent year at top to oldest at bottom.

Step 6: Build Table 2 — YoY CapEx Growth

Calculate YoY growth as: (Current Year CapEx - Prior Year CapEx) / Prior Year CapEx * 100 (using absolute values)

Present a markdown table:

| Fiscal Year End | Capital Expenditure | YoY Growth |
|-----------------|---------------------|------------|
| 12/31/2024      | $X.XXB              | +X.X%      |
| 12/31/2023      | $X.XXB              | -X.X%      |
| ...             | ...                 | ...        |

• Prefix positive values with +, negative values naturally show -.
• The earliest year in the table will have no prior year to compare, so show "N/A" for that growth cell.
• If either the current or prior year CapEx is missing/zero, show "N/A" for that growth cell.

Step 7: Add Notes

Below the tables, include a Notes section mentioning:

• That all CapEx values are as reported per Yahoo Finance (in thousands on the source, converted for display; shown as positive values representing cash outflows).
• The company's fiscal year-end date (e.g., "Fiscal year ends December 31" or "Fiscal year ends March 31").
• Any notable spikes or drops and likely causes if obvious (e.g., major facility builds, acquisitions of PP&E, expansion phases, cost-cutting periods).
• The data source: Yahoo Finance $0 Cash Flow Statement (Annual, Capital Expenditure).

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: kezsmeister
• Source: kezsmeister/claude-finance-skills
• License: MIT

Install and usage instructions live in the source repository linked above.