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 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:
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]"
1---2name: balance-sheet3description: 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.4---5
6# Balance Sheet
7
8Retrieve detailed balance sheet statement data for public companies using Octagon MCP.
9
10## Prerequisites
11
12Ensure 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.
13
14## Query Format
15
16```
17Retrieve detailed balance sheet statement data for <TICKER>, limited to <N> records and filtered by period <FY|Q>.
18```
19
20**MCP Call:**
21
22```json
23{
24 "server": "octagon-mcp",
25 "toolName": "octagon-agent",
26 "arguments": {
27 "prompt": "Retrieve detailed balance sheet statement data for AAPL, limited to 5 records and filtered by period FY"
28 }
29}
30```
31
32## Output Format
33
34The agent returns a table with absolute financial figures:
35
36| Fiscal Year | Total Assets (USD) | Total Current Assets (USD) | Total Non-Current Assets (USD) | Total Liabilities (USD) | Total Equity (USD) | Net Debt (USD) |
37|-------------|-------------------|---------------------------|-------------------------------|------------------------|-------------------|----------------|
38| 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 |
39| 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 |
40| 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 |
41| 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 |
42| 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 |
43
44**Data Source:** octagon-financials-agent
45
46## Key Observations Pattern
47
48After receiving data, generate observations:
49
501. **Asset base changes**: Track total assets trajectory over time
512. **Asset composition**: Analyze current vs non-current asset mix
523. **Equity trends**: Monitor shareholders' equity changes
534. **Leverage position**: Track net debt levels and direction
545. **Capital structure**: Compare liabilities to equity ratios
55
56## Metrics Reference
57
58| Metric | Definition |
59|--------|------------|
60| Total Assets | All resources owned by the company |
61| Total Current Assets | Assets convertible to cash within 1 year |
62| Total Non-Current Assets | Long-term assets (PP&E, intangibles, investments) |
63| Total Liabilities | All obligations and debts |
64| Total Equity | Net worth (Assets - Liabilities) |
65| Net Debt | Total debt minus cash and equivalents |
66
67## Analysis Tips
68
69### Asset Composition
70- Current Assets: Liquidity and working capital
71- Non-Current Assets: Long-term investments and capacity
72- Shift toward current = more liquid
73- Shift toward non-current = more invested
74
75### Capital Structure Ratios
76Calculate from the data:
77```
78Debt-to-Equity = Total Liabilities / Total Equity
79Equity Ratio = Total Equity / Total Assets
80```
81
82### Net Debt Analysis
83- Declining Net Debt = deleveraging
84- Negative Net Debt = net cash position
85- Compare to EBITDA for leverage context
86
87### Equity Trends
88Rising equity from:
89- Retained earnings (profitable operations)
90- Stock issuance
91- Other comprehensive income
92
93Declining equity from:
94- Net losses
95- Share buybacks
96- Dividends exceeding earnings
97
98### Working Capital
99```
100Working Capital = Current Assets - Current Liabilities
101```
102Positive = can meet short-term obligations
103
104## Follow-up Queries
105
106Based on results, suggest deeper analysis:
107
108- "What factors contributed to the decline in total assets in [YEAR] compared to [PRIOR YEAR]?"
109- "How has [COMPANY]'s capital allocation strategy evolved between [YEAR1] and [YEAR2]?"
110- "What specific components of non-current assets grew between [YEAR1] and [YEAR2]?"
111- "Compare [COMPANY]'s leverage ratios to [PEER1] and [PEER2]"
octagonai