Skip to main content
Glama

Valuein — SEC EDGAR Fundamentals & Smart-Money Data

Three-statement projection

project_three_statement
Read-onlyIdempotent

Returns a linked income statement, balance sheet and cash flow for each projected year, seeded from the company's latest annual 10-K figures, with a yearly check that the balance sheet balances and the free cash flow stream. Use this when the user wants to see how a company's statements could develop under growth, margin, financing and payout assumptions they choose. Margins and capital spending stay at the latest year's share of revenue unless overridden; interest and tax rates are the user's assumptions.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
yearsNoYears to project, 1 to 15; defaults to 5, e.g. 10.
tickerYesTicker symbol or SEC CIK of the company to project, e.g. AAPL.
tax_rateNoTax rate on positive pretax income, 0 to 1; defaults to 0.21, e.g. 0.25.
as_of_dateNoPoint-in-time cutoff for the reported inputs, YYYY-MM-DD: only filings accepted by this date, e.g. 2024-06-30.
cash_sweep_pctNoShare of each year's free cash flow used to repay debt, 0 to 1; defaults to 0, e.g. 0.5.
dividend_payout_pctNoShare of each year's net income distributed as dividends, 0 to 1; defaults to 0, e.g. 0.3.
new_debt_draw_year1NoNew debt borrowed in the first projected year, in USD; defaults to 0, e.g. 5000000000.
revenue_growth_rateYesYearly revenue growth as a decimal, -0.5 to 1, e.g. 0.08.
interest_rate_on_debtNoInterest rate on debt at the start of each year, 0 to 0.5; defaults to 0.06, e.g. 0.05.
new_equity_draw_year1NoNew equity raised in the first projected year, in USD, added to cash and equity; defaults to 0, e.g. 2000000000.
gross_margin_pct_overrideNoGross margin for every projected year; omit to keep the latest year's, e.g. 0.45.
capex_pct_of_revenue_overrideNoCapital spending as a share of revenue; omit to keep the latest year's, e.g. 0.03.
operating_margin_pct_overrideNoOperating margin for every projected year; omit to keep the latest year's, e.g. 0.3.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
_metaYesProvenance envelope — data lineage for every MCP response
resultYes
tickerYes
seed_period_endYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed28 schema fields changed
    • changedInput schema / properties / as_of_date / description
      Previous value: -"Point-in-time cutoff (YYYY-MM-DD) for the seed period. Omit to use the latest knowable annual period."New value: +"Point-in-time cutoff for the reported inputs, YYYY-MM-DD: only filings accepted by this date, e.g. 2024-06-30."
    • changedInput schema / properties / capex_pct_of_revenue_override / description
      Previous value: -"Override the seed period's capex-as-%-of-revenue ratio. Leave unset to use the historical ratio."New value: +"Capital spending as a share of revenue; omit to keep the latest year's, e.g. 0.03."
    • changedInput schema / properties / cash_sweep_pct / description
      Previous value: -"Fraction (0-1) of each year's free cash flow swept to debt paydown. Default 0 (going-concern; use ~1.0 for an LBO-style paydown)."New value: +"Share of each year's free cash flow used to repay debt, 0 to 1; defaults to 0, e.g. 0.5."
    • changedInput schema / properties / dividend_payout_pct / description
      Previous value: -"Fraction (0-1) of net income paid out as dividends each year. Default 0."New value: +"Share of each year's net income distributed as dividends, 0 to 1; defaults to 0, e.g. 0.3."
    • changedInput schema / properties / gross_margin_pct_override / description
      Previous value: -"Override the seed period's gross margin (held flat across all years). Leave unset to use the historical ratio."New value: +"Gross margin for every projected year; omit to keep the latest year's, e.g. 0.45."
    • changedInput schema / properties / interest_rate_on_debt / description
      Previous value: -"Annual interest rate on beginning-of-period debt. Assumption — default 0.06."New value: +"Interest rate on debt at the start of each year, 0 to 0.5; defaults to 0.06, e.g. 0.05."
    • changedInput schema / properties / new_debt_draw_year1 / description
      Previous value: -"New debt drawn at year 1 only (absolute USD) — e.g. acquisition financing. Default 0."New value: +"New debt borrowed in the first projected year, in USD; defaults to 0, e.g. 5000000000."
    • changedInput schema / properties / new_equity_draw_year1 / description
      Previous value: -"New equity contributed at year 1 only (absolute USD) — hits cash + equity symmetrically. Default 0."New value: +"New equity raised in the first projected year, in USD, added to cash and equity; defaults to 0, e.g. 2000000000."
    • changedInput schema / properties / operating_margin_pct_override / description
      Previous value: -"Override the seed period's operating margin. Leave unset to use the historical ratio."New value: +"Operating margin for every projected year; omit to keep the latest year's, e.g. 0.3."
    • changedInput schema / properties / revenue_growth_rate / description
      Previous value: -"Flat annual revenue growth rate applied every year (e.g. 0.08 = 8%/yr)."New value: +"Yearly revenue growth as a decimal, -0.5 to 1, e.g. 0.08."
    • changedInput schema / properties / tax_rate / description
      Previous value: -"Effective tax rate on positive pretax income. Default 0.21 (US statutory)."New value: +"Tax rate on positive pretax income, 0 to 1; defaults to 0.21, e.g. 0.25."
    • changedInput schema / properties / ticker / description
      Previous value: -"Stock ticker symbol, e.g. AAPL, MSFT, BRK.B."New value: +"Ticker symbol or SEC CIK of the company to project, e.g. AAPL."
    • changedInput schema / properties / years / description
      Previous value: -"Projection horizon in years (1-15). Defaults to 5."New value: +"Years to project, 1 to 15; defaults to 5, e.g. 10."
    • removedOutput schema / properties / _meta / properties / cost_usd
      Removed value: -{
      -  "additionalProperties": false,
      -  "description": "Per-call cost transparency. Omitted for subscription-only tools that have no PAYG-equivalent price.",
      -  "properties": {
      -    "amount_usd": {
      -      "minimum": 0,
      -      "type": "number"
      -    },
      -    "basis": {
      -      "description": "payg_charge = real agent-pay charge. payg_rate_card = indicative price, not billed.",
      -      "enum": [
      -        "payg_charge",
      -        "payg_rate_card"
      -      ],
      -      "type": "string"
      -    },
      -    "billed": {
      -      "description": "true = this amount was actually charged via PAYG for this call. false = indicative PAYG-equivalent value; your plan already covers this call for free.",
      -      "type": "boolean"
      -    }
      -  },
      -  "required": [
      -    "amount_usd",
      -    "billed",
      -    "basis"
      -  ],
      -  "type": "object"
      -}
    • removedOutput schema / properties / _meta / properties / data_plan
      Removed value: -{
      -  "description": "Access plan: sample | sp500 | pro | full",
      -  "type": "string"
      -}
    • changedOutput schema / properties / _meta / properties / fundamentals_as_of / description
      Previous value: -"ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt in bulk. Use THIS — not `last_updated` — when telling a user how current the cross-sectional fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to. It is a floor for a single filer, not a ceiling: a filer with a live partition receives its filing, facts and ratios intraday (minutes after EDGAR dissemination), so an entity-scoped read may carry a filing newer than this; cross-sectional ranks (factor scores, earnings signals) refresh with the weekly bulk export."New value: +"Use THIS — not `last_updated` — when telling a user how current the cross-sectional fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to. It is a floor for a single filer, not a ceiling: a filer with a live partition receives its filing, facts and ratios intraday (minutes after EDGAR dissemination), so an entity-scoped read may carry a filing newer than this; cross-sectional ranks (factor scores, earnings signals) refresh with the weekly bulk export."
    • removedOutput schema / properties / _meta / properties / last_updated
      Removed value: -{
      -  "description": "ISO timestamp when the snapshot was exported",
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / latency_ms
      Removed value: -{
      -  "description": "Wall-clock milliseconds this tool call took, measured server-side around the handler.",
      -  "minimum": 0,
      -  "type": "integer"
      -}
    • removedOutput schema / properties / _meta / properties / limit_warnings
      Removed value: -{
      -  "description": "Soft-warning array for partial fulfillment. Each entry carries a stable subcode + remediation.options[]. AI agents pattern-match on subcode.",
      -  "items": {
      -    "additionalProperties": true,
      -    "properties": {
      -      "code": {
      -        "const": "LIMIT_EXCEEDED",
      -        "type": "string"
      -      },
      -      "current_plan": {
      -        "type": "string"
      -      },
      -      "extensions": {
      -        "additionalProperties": {},
      -        "type": "object"
      -      },
      -      "limit_type": {
      -        "type": "string"
      -      },
      -      "limit_value": {},
      -      "remediation": {
      -        "additionalProperties": true,
      -        "properties": {
      -          "contact_sales": {
      -            "type": "string"
      -          },
      -          "default_action": {
      -            "type": "string"
      -          },
      -          "options": {
      -            "items": {
      -              "additionalProperties": {},
      -              "type": "object"
      -            },
      -            "type": "array"
      -          },
      -          "pricing_page": {
      -            "type": "string"
      -          }
      -        },
      -        "required": [
      -          "options",
      -          "default_action",
      -          "pricing_page",
      -          "contact_sales"
      -        ],
      -        "type": "object"
      -      },
      -      "requested_value": {},
      -      "returned_value": {},
      -      "subcode": {
      -        "type": "string"
      -      }
      -    },
      -    "required": [
      -      "code",
      -      "subcode",
      -      "limit_type",
      -      "current_plan",
      -      "remediation"
      -    ],
      -    "type": "object"
      -  },
      -  "type": "array"
      -}
    • removedOutput schema / properties / _meta / properties / payg_override
      Removed value: -{
      -  "additionalProperties": false,
      -  "description": "Set when this single response was paid for via the agent-pay PAYG flow — the rate-limit / depth-limit checks were bypassed for this call only.",
      -  "properties": {
      -    "amount_cents": {
      -      "type": "number"
      -    },
      -    "entity_scope_hash": {
      -      "type": "string"
      -    },
      -    "meter": {
      -      "type": "string"
      -    },
      -    "quote_id": {
      -      "type": "string"
      -    },
      -    "retry_token_hash": {
      -      "type": "string"
      -    },
      -    "ticker_count": {
      -      "type": "number"
      -    },
      -    "tool": {
      -      "type": "string"
      -    }
      -  },
      -  "required": [
      -    "quote_id",
      -    "tool",
      -    "meter",
      -    "amount_cents",
      -    "ticker_count",
      -    "entity_scope_hash",
      -    "retry_token_hash"
      -  ],
      -  "type": "object"
      -}
    • removedOutput schema / properties / _meta / properties / rate_limit
      Removed value: -{
      -  "additionalProperties": false,
      -  "description": "Caller's remaining budget",
      -  "properties": {
      -    "limit": {
      -      "type": "integer"
      -    },
      -    "remaining": {
      -      "type": "integer"
      -    },
      -    "reset_at": {
      -      "description": "ISO 8601 timestamp when the window resets",
      -      "type": "string"
      -    },
      -    "window": {
      -      "enum": [
      -        "minute",
      -        "hour"
      -      ],
      -      "type": "string"
      -    }
      -  },
      -  "required": [
      -    "limit",
      -    "remaining",
      -    "reset_at",
      -    "window"
      -  ],
      -  "type": "object"
      -}
    • removedOutput schema / properties / _meta / properties / request_id
      Removed value: -{
      -  "description": "Per-request correlation id (8-char)",
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / schema_version
      Removed value: -{
      -  "description": "Parquet schema version from manifest.json",
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / snapshot
      Removed value: -{
      -  "description": "Snapshot directory name (e.g. snapshot_20260420)",
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / truncation / properties / current_plan
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / truncation / properties / upgrade_required_for
      Removed value: -{
      -  "type": "string"
      -}
    • removedOutput schema / properties / _meta / properties / truncation / properties / upgrade_url
      Removed value: -{
      -  "type": "string"
      -}
    • changedOutput schema / properties / _meta / required
      Previous value: -[
      -  "data_plan",
      -  "schema_version",
      -  "snapshot",
      -  "last_updated",
      -  "source",
      -  "pit_safe"
      -]New value: +[
      +  "source",
      +  "pit_safe"
      +]
  2. Changed1 schema field changed
    • changedOutput schema / properties / _meta / properties / fundamentals_as_of / description
      Previous value: -"ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt. Use THIS — not `last_updated` — when telling a user how current the fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to."New value: +"ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt in bulk. Use THIS — not `last_updated` — when telling a user how current the cross-sectional fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to. It is a floor for a single filer, not a ceiling: a filer with a live partition receives its filing, facts and ratios intraday (minutes after EDGAR dissemination), so an entity-scoped read may carry a filing newer than this; cross-sectional ranks (factor scores, earnings signals) refresh with the weekly bulk export."
  3. Changed2 schema fields changed
    • addedOutput schema / properties / _meta / properties / fundamentals_as_of
      Added value: +{
      +  "description": "ISO timestamp when the FINANCIAL STATEMENTS were last rebuilt. Use THIS — not `last_updated` — when telling a user how current the fundamentals are. The snapshot is republished on every weekday price refresh while the statements are carried forward unchanged, so `last_updated` can be far more recent than the numbers it sits next to.",
      +  "type": "string"
      +}
    • addedOutput schema / properties / _meta / properties / price_as_of
      Added value: +{
      +  "description": "ISO timestamp when the price surfaces were last refreshed.",
      +  "type": "string"
      +}
  4. Added

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnly/idempotent/non-destructive, and the description adds real behavioral detail beyond them: figures are seeded from the latest annual 10-K, a yearly balance-sheet check is performed, and margins/capex hold the latest year's share unless overridden while interest and tax rates are user assumptions. It doesn't cover failure modes, such as what happens if no acceptable 10-K exists.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three sentences, front-loaded with the return payload and the seed data source, then usage, then defaulting rules. Dense but every sentence carries relevant information; the first sentence is slightly long.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With an output schema present, return values need no explanation, and all 13 parameters are documented in the schema. The description supplies the usage context and defaulting semantics an agent needs; only edge-case behavior (missing filings, balance-check failure handling) is absent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3; the description goes beyond it by explaining cross-parameter behavior — that gross/operating margin and capex overrides default to the latest year's share of revenue, and that interest and tax rates are treated as user assumptions rather than derived.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource: it returns a linked income statement, balance sheet and cash flow for each projected year, seeded from the latest 10-K. This clearly separates it from siblings like compute_dcf or compare_periods, which produce valuations or historical comparisons rather than projected statements.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly says when to use it: 'when the user wants to see how a company's statements could develop under growth, margin, financing and payout assumptions they choose.' It gives clear context but names no alternatives or when-not-to-use conditions (e.g. versus compute_dcf).

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.