mcpField
B
balance-sheet

balance-sheet

github.com/octagonaiData & databases130301 installsUpdated 21w ago
Repository

About balance-sheet

This skill retrieves detailed balance sheet data for public companies through Octagon MCP. It is intended for financial analysis, with data that can be used to examine asset composition, equity changes, and leverage.

Key features

  1. 01Retrieve balance sheet data
  2. 02Filter by fiscal period
  3. 03Review assets, liabilities, and equity
  4. 04Track net debt changes

Use cases

  1. 01Analyze changes in asset composition
  2. 02Assess capital structure and leverage
  3. 03Track equity and net debt trends

MCP support

It queries balance sheet data through the octagon-agent tool on Octagon MCP.

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/octagonai/skills --skill balance-sheet

After installing, type/balance-sheetin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

marketplace.json
README.md
references/
interpreting-results.md
mcp-setup.md

Details

From the project README

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 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:

{
  "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 YearTotal Assets (USD)Total Current Assets (USD)Total Non-Current Assets (USD)Total Liabilities (USD)Total Equity (USD)Net Debt (USD)
2025359,241.00 million147,957.00 million211,284.00 million285,508.00 million73,733.00 million89,749.00 million
2024364,980.00 million152,987.00 million211,993.00 million308,030.00 million56,950.00 million89,116.00 million
2023352,583.00 million143,566.00 million209,017.00 million290,437.00 million62,146.00 million93,965.00 million
2022352,755.00 million135,405.00 million217,350.00 million302,083.00 million50,672.00 million108,834.00 million
2021351,002.00 million134,836.00 million216,166.00 million287,912.00 million63,090.00 million101,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

MetricDefinition
Total AssetsAll resources owned by the company
Total Current AssetsAssets convertible to cash within 1 year
Total Non-Current AssetsLong-term assets (PP&E, intangibles, investments)
Total LiabilitiesAll obligations and debts
Total EquityNet worth (Assets - Liabilities)
Net DebtTotal debt minus cash and equivalents

Analysis Tips

Asset Composition
  • Current Assets: Liquidity and working capital
  • Non-Current Assets: Long-term investments and capacity
  • Shift toward current = more liquid
  • Shift toward non-current = more invested
Capital Structure Ratios

Calculate from the data:

Debt-to-Equity = Total Liabilities / Total Equity
Equity Ratio = Total Equity / Total Assets
Net Debt Analysis
  • Declining Net Debt = deleveraging
  • Negative Net Debt = net cash position
  • Compare to EBITDA for leverage context
Equity Trends

Rising equity from:

  • Retained earnings (profitable operations)
  • Stock issuance
  • Other comprehensive income

Declining equity from:

  • Net losses
  • Share buybacks
  • Dividends exceeding earnings
Working Capital
Working Capital = Current Assets - Current Liabilities

Positive = can meet short-term obligations

Follow-up Queries

Based on results, suggest deeper analysis:

  • "What factors contributed to the decline in total assets in [YEAR] compared to [PRIOR YEAR]?"
  • "How has [COMPANY]'s capital allocation strategy evolved between [YEAR1] and [YEAR2]?"
  • "What specific components of non-current assets grew between [YEAR1] and [YEAR2]?"
  • "Compare [COMPANY]'s leverage ratios to [PEER1] and [PEER2]"

Comments

Markdown supported