Valuein — SEC EDGAR Fundamentals & Smart-Money Data

Leveraged buyout returns

compute_lbo

Read-onlyIdempotent

Returns the sponsor's multiple of invested capital and internal rate of return for a leveraged buyout, with entry and exit enterprise value, debt, equity and a yearly projection, on an opening balance sheet built from the deal terms and the company's latest annual 10-K operating figures. Use this when the user asks what a buyout could return under stated purchase and exit multiples, leverage and hold period. EBITDA is approximated by operating income unless an entry figure is given, and a null rate means no rate fits the cash flows.

Input Schema

TableJSON Schema

Name	Required	Description
`ticker`	Yes	Ticker symbol or SEC CIK of the buyout target, e.g. AAPL.
`tax_rate`	No	Tax rate on positive pretax income, 0 to 1; defaults to 0.21, e.g. 0.25.
`as_of_date`	No	Point-in-time cutoff for the reported inputs, YYYY-MM-DD: only filings accepted by this date, e.g. 2024-06-30.
`minimum_cash`	No	Cash left on the opening balance sheet, in USD; defaults to 0, e.g. 1000000000.
`exit_multiple`	No	Sale price as a multiple of the final year's EBITDA; defaults to entry_multiple, e.g. 12.
`cash_sweep_pct`	No	Share of each year's free cash flow used to repay debt, 0 to 1; defaults to 1, e.g. 0.75.
`entry_multiple`	Yes	Purchase price as a multiple of EBITDA, above zero, e.g. 10.
`hold_period_years`	No	Years from purchase to sale, 1 to 10; defaults to 5, e.g. 7.
`leverage_multiple`	Yes	Debt raised at entry as a multiple of EBITDA, zero or more, e.g. 5.
`dividend_payout_pct`	No	Share of each year's net income distributed to the sponsor, 0 to 1; defaults to 0, e.g. 0.2.
`revenue_growth_rate`	Yes	Yearly revenue growth over the hold as a decimal, -0.5 to 1, e.g. 0.05.
`entry_ebitda_override`	No	EBITDA in USD that sets the entry price and debt instead of operating income, e.g. 130000000000.
`interest_rate_on_debt`	No	Interest rate on buyout debt at the start of each year, 0 to 0.5; defaults to 0.08, e.g. 0.09.

Output Schema

TableJSON Schema

Name	Required	Description
`_meta`	Yes	Provenance envelope — data lineage for every MCP response
`result`	Yes
`ticker`	Yes
`seed_period_end`	Yes

Schema Changelog

Changes observed during successful MCP inspections.

Changed28 schema fields changedSep 29, 2026

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 / cash_sweep_pct / description

Previous value: -"Fraction (0-1) of each year's FCF swept to debt paydown. Default 1.0 (standard LBO — 100% sweep)."New value: +"Share of each year's free cash flow used to repay debt, 0 to 1; defaults to 1, e.g. 0.75."

changedInput schema / properties / dividend_payout_pct / description

Previous value: -"Fraction (0-1) of net income distributed to the sponsor each year (dividend recap style). Default 0 — most LBOs return capital only at exit."New value: +"Share of each year's net income distributed to the sponsor, 0 to 1; defaults to 0, e.g. 0.2."

changedInput schema / properties / entry_ebitda_override / description

Previous value: -"Override the EBITDA figure used for both entry and exit multiples. Without this, EBITDA is proxied by operating income."New value: +"EBITDA in USD that sets the entry price and debt instead of operating income, e.g. 130000000000."

changedInput schema / properties / entry_multiple / description

Previous value: -"EV/EBITDA multiple paid at entry (e.g. 10 = 10x)."New value: +"Purchase price as a multiple of EBITDA, above zero, e.g. 10."

changedInput schema / properties / exit_multiple / description

Previous value: -"EV/EBITDA multiple assumed at exit. Defaults to entry_multiple (no multiple expansion/contraction) when omitted."New value: +"Sale price as a multiple of the final year's EBITDA; defaults to entry_multiple, e.g. 12."

changedInput schema / properties / hold_period_years / description

Previous value: -"Hold period in years (1-10). Defaults to 5."New value: +"Years from purchase to sale, 1 to 10; defaults to 5, e.g. 7."

changedInput schema / properties / interest_rate_on_debt / description

Previous value: -"Annual interest rate on beginning-of-period LBO debt. Default 0.08 (leveraged debt typically prices above IG)."New value: +"Interest rate on buyout debt at the start of each year, 0 to 0.5; defaults to 0.08, e.g. 0.09."

changedInput schema / properties / leverage_multiple / description

Previous value: -"Debt/EBITDA raised at entry (e.g. 5 = 5x leverage)."New value: +"Debt raised at entry as a multiple of EBITDA, zero or more, e.g. 5."

changedInput schema / properties / minimum_cash / description

Previous value: -"Minimum operating cash left on the pro-forma opening balance sheet. Default 0."New value: +"Cash left on the opening balance sheet, in USD; defaults to 0, e.g. 1000000000."

changedInput schema / properties / revenue_growth_rate / description

Previous value: -"Flat annual revenue growth rate applied every year of the hold (e.g. 0.05 = 5%/yr)."New value: +"Yearly revenue growth over the hold as a decimal, -0.5 to 1, e.g. 0.05."

changedInput schema / properties / tax_rate / description

Previous value: -"Effective tax rate on positive pretax income. Default 0.21."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 of the LBO target, e.g. AAPL."New value: +"Ticker symbol or SEC CIK of the buyout target, e.g. AAPL."

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"
+]

Changed1 schema field changedSep 18, 2026

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."

Changed2 schema fields changedJul 25, 2026

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"
+}

AddedJul 9, 2026

TDQS

A4.3/5.0

Behavior4/5

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

Annotations already declare readOnlyHint/idempotent/non-destructive, so safety is covered. The description adds real modeling behavior beyond that: EBITDA is approximated by operating income unless an override is given, and a null rate means no rate fits the cash flows. It does not mention runtime cost, but for a read-only computation this is solid added context.

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?

The output is front-loaded (what the tool returns first, then when to use it, then modeling caveats). It is a dense single long sentence, but every clause carries information and none is wasted.

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?

For a 13-parameter computational tool with an output schema and full annotation coverage, the description supplies the essential modeling conventions an agent needs. It is largely complete, though the relationships among the many leverage/cash-flow parameters are left to the schema.

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, but the description adds meaning on top: it explains the EBITDA proxy rule tied to entry_ebitda_override and what a null result rate implies. It does not clarify the interaction between cash_sweep_pct and dividend_payout_pct, so it stops short of a 5.

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 (returns sponsor's MOIC and IRR for an LBO) plus the concrete outputs and inputs (entry/exit EV, debt, equity, yearly projection, 10-K opening balance sheet). This clearly distinguishes it from sibling compute tools like compute_dcf and compute_accretion_dilution.

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?

Gives an explicit trigger: 'Use this when the user asks what a buyout could return under stated purchase and exit multiples, leverage and hold period.' That is clear usage context, but it does not name alternatives (e.g. compute_dcf for a plain DCF) or state when not to use it.

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

All Valuein — SEC EDGAR Fundamentals & Smart-Money Data tools Inspect

Try in Browser

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Glama MCP Gateway

Add one secure layer between your agents and this server.