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
code
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:
- •Asset base changes: Track total assets trajectory over time
- •Asset composition: Analyze current vs non-current asset mix
- •Equity trends: Monitor shareholders' equity changes
- •Leverage position: Track net debt levels and direction
- •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:
code
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
code
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]"