balance-sheet

Balance Sheet

Retrieve detailed balance sheet statement data for public companies using the Octagon Claude plugin.

Prerequisites

Ensure the Octagon Claude plugin is installed and configured in Claude Code before invoking this skill.

Query Format

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

MCP Call:

{
  "server": "octagon-claude-plugin",
  "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]"