# Annual Capex

> Extract annual Capital Expenditure for one or more public company tickers (comma-separated) by browsing Yahoo Finance in Chrome. Produces two markdown tables per ticker - (1) raw annual CapEx for the past 10 years and (2) YoY growth rate. Use when the user wants annual CapEx data, capital expenditure history, or investment spending trends for a stock.

- **Type:** Skill
- **Install:** `agentstack add skill-kezsmeister-claude-finance-skills-annual-capex`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [kezsmeister](https://agentstack.voostack.com/s/kezsmeister)
- **Installs:** 0
- **Category:** [Content & Media](https://agentstack.voostack.com/c/content-and-media)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [kezsmeister](https://github.com/kezsmeister)
- **Source:** https://github.com/kezsmeister/claude-finance-skills/tree/main/skills/annual-capex

## Install

```sh
agentstack add skill-kezsmeister-claude-finance-skills-annual-capex
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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
3. **If there is only one ticker**, present the subagent's Table 2 (YoY growth rates) directly; skip Table 1 (raw data).
4. **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:

```javascript
() => {
  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](https://github.com/kezsmeister)
- **Source:** [kezsmeister/claude-finance-skills](https://github.com/kezsmeister/claude-finance-skills)
- **License:** MIT

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

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-kezsmeister-claude-finance-skills-annual-capex
- Seller: https://agentstack.voostack.com/s/kezsmeister
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.