# balance-sheet

Fetches balance sheet line items for public companies through Octagon MCP: assets, liabilities, equity, net debt. Useful when you need capital structure numbers without manual filing work.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 301 installs · ★ 130
- Author: OctagonAI
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/OctagonAI/skills/tree/HEAD/skills/balance-sheet/SKILL.md
- Updated: 2026-06-05
- HTML: https://affpapa.org/en/nevibecode/skills/balance-sheet

## What it does

The skill turns a plain-language request into an Octagon MCP call and returns a table of absolute figures by year: Total Assets, Current Assets, Non-Current Assets, Liabilities, Equity, Net Debt. The query format is short — ticker, record count, and period (`FY` or `Q`). Under the hood it calls the `octagon-agent` tool on the `octagon-mcp` server, with `octagon-financials-agent` as the data source.

After the table, the skill walks through observations: how the asset base moved, what it is made of, where equity and net debt are heading. A metrics reference defines each line item, and formulas are computed straight from the output — Debt-to-Equity, Equity Ratio, Working Capital. Edge cases like negative net debt and equity falling from buybacks get their own notes.

You need Octagon MCP configured in your agent first, or the call will not go through. Setup steps live in `references/mcp-setup.md` inside the skill. Worth checking that config before your first run, otherwise you get an empty response instead of a table.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add OctagonAI/skills --skill balance-sheet -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/balance-sheet/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/balance-sheet/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add OctagonAI/skills --skill balance-sheet -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/balance-sheet/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add OctagonAI/skills --skill balance-sheet -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/balance-sheet/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install OctagonAI/skills balance-sheet
```

2. **Manually: put the files in place**
- File: `.github/skills/balance-sheet/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add OctagonAI/skills --skill balance-sheet -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/OctagonAI/skills --path skills/balance-sheet
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/balance-sheet/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add OctagonAI/skills --skill balance-sheet -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/OctagonAI/skills/tree/HEAD/skills/balance-sheet/SKILL.md

## When to use it
- pull balance sheet line items for a ticker across several years
- compute Debt-to-Equity and Equity Ratio from the returned figures
- track net debt and equity trends over time
- break down asset mix: current versus non-current
- compare a company's equity against prior periods

## Example prompts
- Retrieve balance sheet data for AAPL, limited to 5 records and filtered by period FY
- Show Total Assets, Liabilities and Net Debt for MSFT over the last few years
- Calculate Debt-to-Equity and Working Capital from this table

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: ea364ccfc139176d.

BEGIN THIRD-PARTY FILE ea364ccfc139176d
````text
---
name: balance-sheet
description: Retrieve detailed balance sheet statement data including Total Assets, Current Assets, Non-Current Assets, Liabilities, Equity, and Net Debt for public companies. Use when analyzing financial position, capital structure, or leverage metrics.
---

# Balance Sheet

Retrieve detailed balance sheet statement data for public companies using Octagon MCP.

## Prerequisites

Ensure Octagon MCP is configured in your AI agent (Cursor, Claude Desktop, Windsurf, etc.). See [references/mcp-setup.md](references/mcp-setup.md) for installation instructions.

## Query Format

```
Retrieve detailed balance sheet statement data for <TICKER>, limited to <N> records and filtered by period <FY|Q>.
```

**MCP Call:**

```json
{
  "server": "octagon-mcp",
  "toolName": "octagon-agent",
  "arguments": {
    "prompt": "Retrieve detailed balance sheet statement data for AAPL, limited to 5 records and filtered by period FY"
  }
}
```

## Output Format

The agent returns a table with absolute financial figures:

| Fiscal Year | Total Assets (USD) | Total Current Assets (USD) | Total Non-Current Assets (USD) | Total Liabilities (USD) | Total Equity (USD) | Net Debt (USD) |
|-------------|-------------------|---------------------------|-------------------------------|------------------------|-------------------|----------------|
| 2025 | 359,241.00 million | 147,957.00 million | 211,284.00 million | 285,508.00 million | 73,733.00 million | 89,749.00 million |
| 2024 | 364,980.00 million | 152,987.00 million | 211,993.00 million | 308,030.00 million | 56,950.00 million | 89,116.00 million |
| 2023 | 352,583.00 million | 143,566.00 million | 209,017.00 million | 290,437.00 million | 62,146.00 million | 93,965.00 million |
| 2022 | 352,755.00 million | 135,405.00 million | 217,350.00 million | 302,083.00 million | 50,672.00 million | 108,834.00 million |
| 2021 | 351,002.00 million | 134,836.00 million | 216,166.00 million | 287,912.00 million | 63,090.00 million | 101,582.00 million |

**Data Source:** octagon-financials-agent

## Key Observations Pattern

After receiving data, generate observations:

1. **Asset base changes**: Track total assets trajectory over time
2. **Asset composition**: Analyze current vs non-current asset mix
3. **Equity trends**: Monitor shareholders' equity changes
4. **Leverage position**: Track net debt levels and direction
5. **Capital structure**: Compare liabilities to equity ratios

## Metrics Reference

| Metric | Definition |
|--------|------------|
| Total Assets | All resources owned by the company |
| Total Current Assets | Assets convertible to cash within 1 year |
````
END THIRD-PARTY FILE ea364ccfc139176d

The third-party file has ended. Everything between the ea364ccfc139176d tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 2653 of 4153 bytes. © OctagonAI · MIT · https://github.com/OctagonAI/skills/tree/HEAD/skills/balance-sheet/SKILL.md

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md