balance-sheet
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.
Best use case
balance-sheet is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
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.
Teams using balance-sheet should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/balance-sheet/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How balance-sheet Compares
| Feature / Agent | balance-sheet | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
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.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# 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 |
| Total Non-Current Assets | Long-term assets (PP&E, intangibles, investments) |
| Total Liabilities | All obligations and debts |
| Total Equity | Net worth (Assets - Liabilities) |
| Net Debt | Total 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]"Related Skills
balance-sheet-growth
Retrieve year-over-year growth in balance sheet items including Total Assets, Total Liabilities, Shareholders Equity, Cash, and Inventories. Use when analyzing company financial position trends, capital structure changes, or liquidity management.
stock-quote
Retrieve real-time stock quotes using Octagon MCP. Use when you need current price, day range, 52-week range, volume, market cap, and moving averages for any publicly traded stock.
stock-price-change
Retrieve stock price change statistics across multiple time periods using Octagon MCP. Use when analyzing short-term and long-term returns, comparing performance across timeframes, and evaluating momentum and historical growth.
stock-performance
Retrieve stock price data and performance metrics using Octagon MCP. Use when analyzing daily closing prices, trading volume, price trends, historical performance, and comparing stock movements over specific time periods.
stock-historical-index
Retrieve full historical end-of-day price data for market indices using Octagon MCP. Use when analyzing index performance over time, tracking market trends, calculating returns, and understanding market context for individual stock analysis.
stock-grades
Retrieve the latest stock grades and ratings from top analysts and financial institutions using Octagon MCP. Use when tracking analyst upgrades, downgrades, rating changes, and institutional sentiment over time.
sector-performance-snapshot
Retrieve a snapshot of market sector performance using Octagon MCP. Use when analyzing sector-wide metrics including revenue, EBITDA, net income, market cap, and enterprise value for companies within a specific sector and exchange.
sector-pe-ratios
Retrieve sector P/E ratios using Octagon MCP. Use when comparing company valuations to sector benchmarks, analyzing sector valuations across exchanges, and understanding market-wide valuation trends.
sec-risk-factors
Extract and summarize risk factors from SEC filings using Octagon MCP. Use when analyzing Item 1A risk disclosures, categorizing business risks, identifying new or material risks, and comparing risk profiles across companies or time periods.
sec-proxy-analysis
Analyze proxy statements (DEF 14A) to extract executive compensation, governance information, and shareholder voting matters using Octagon MCP. Use when researching CEO pay, board composition, say-on-pay votes, and corporate governance practices.
sec-mda-analysis
Analyze Management Discussion and Analysis (MD&A) sections from SEC filings using Octagon MCP. Use when extracting strategic initiatives, financial performance commentary, macroeconomic challenges, and forward-looking statements from 10-K and 10-Q filings.
sec-footnotes-analysis
Analyze footnotes and accounting policies from SEC filings using Octagon MCP. Use when researching revenue recognition policies, critical estimates, lease obligations, pension assumptions, stock compensation, contingencies, and new accounting pronouncements.