Skip to main content

Funds

Pack file: catalog/industries/funds in ambient-core.

Workspace demo (screenshots) · Catalog consumption

Industry summary

Industry code

ISIC Rev.4 6630

43 metrics · 7 data options

NAICS 2022
523940
NACE Rev.2
66.30
GICS 2023
402030

Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.

Data options (7)

Accounting Software

Catalog key funds.core.accounting_software

Fields

date
date
period_start_date
date
period_end_date
date
revenue
decimal
cogs
decimal
cost_of_goods
decimal
operating_expenses
decimal
net_income
decimal
produce_revenue
decimal
total_production_cost
decimal
total_operational_cost
decimal

Financial statements

Catalog key funds.core.financial_statements

Fields

date
date
statement_type
enum
period_start_date
date
period_end_date
date

HR records

Catalog key funds.core.hr_records

Fields

date
date
headcount
decimal

Payroll records

Catalog key funds.core.payroll_records

Fields

date
date
period_start_date
date
period_end_date
date
headcount
decimal
gross_pay
decimal
net_pay
decimal
employer_taxes
decimal
labor_cost
decimal
revenue
decimal
net_income
decimal
total_labor_costs
decimal
total_harvested_kg
decimal
total_production_cost
decimal
total_operational_cost
decimal
drivers_left
decimal
total_drivers
decimal
total_maintenance_costs
decimal
total_miles
decimal

Aggregated fund performance summary

Catalog key funds.fund.fund_performance_summary

Fields

date
date
fund_vehicle_id
id
fund_irr
string
distributions
string
nav
string
paid_in_capital
string
called_capital
string
committed_capital
string
performance_fees
string
total_fund_revenue
decimal
liquidity_gate_frequency
string
strategy_return_volatility
decimal

Aggregated fund summary

Catalog key funds.fund.fund_summary

Fields

date
date
fund_vehicle_id
id
book_type
enum
assets_under_management
string
inflows
string
outflows
string
beginning_aum
string
management_fees
string
average_aum
string
custody_fees
string
average_auc
string
failed_settlements
string
total_settlement_instructions
decimal

Aggregated investment program summary

Catalog key funds.operations.investment_program_summary

Fields

date
date
reporting_entity_id
id
closed_investments
string
qualified_opportunities
string
deployed_capital
string
new_investments
string
follow_on_investments
string
eligible_portfolio_companies
string
impaired_carrying_value
string
portfolio_cost_basis
decimal
deals_with_co_investors
string
total_closed_deals
decimal
committed_capital
string
fundraising_target
string
management_fees
string
operating_expenses
string
program_investments
string
program_participants
string
inbound_qualified_opportunities
string
total_qualified_opportunities
decimal
active_portfolio_company_count
decimal
new_investments_count
decimal
qualified_opportunities_count
decimal

Metrics (43)

Monthly Burn Rate

  • ID: 1982
  • Type: Financial
  • Unit: Currency/month
  • Description: Net cash consumed per month (negative net operating cash flow).
  • Inputs: cash_out, cash_in
  • Methodology: Net Burn = Cash Out − Cash In (per month)
  • Calculation: cash_out - cash_in
  • Catalog key: funds.core.burn_rate

Cash Conversion Cycle

  • ID: 1980
  • Type: Financial
  • Unit: Days
  • Description: Days to convert investments in inventory and receivables back into cash.
  • Inputs: days_inventory_outstanding
  • Methodology: CCC = DSO + Days Inventory Outstanding − DPO
  • Calculation: dso + days_inventory_outstanding - dpo
  • Catalog key: funds.core.ccc

Current Ratio

  • ID: 1970
  • Type: Financial
  • Unit: Ratio
  • Description: Short-term liquidity: ability to cover current liabilities with current assets.
  • Inputs: current_assets, current_liabilities
  • Methodology: Current Ratio = Current Assets / Current Liabilities
  • Calculation: current_assets / current_liabilities
  • Catalog key: funds.core.current_ratio

Days Payable Outstanding (DPO)

  • ID: 1979
  • Type: Financial
  • Unit: Days
  • Description: Average number of days the business takes to pay its suppliers.
  • Inputs: accounts_payable, cogs, days
  • Methodology: DPO = (Accounts Payable / COGS) × Number of Days
  • Calculation: accounts_payable / cogs * days
  • Catalog key: funds.core.dpo

Days Sales Outstanding (DSO)

  • ID: 1978
  • Type: Financial
  • Unit: Days
  • Description: Average number of days to collect cash after a sale.
  • Inputs: accounts_receivable, total_credit_sales, days
  • Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
  • Calculation: accounts_receivable / total_credit_sales * days
  • Catalog key: funds.core.dso

EBITDA Margin

  • ID: 1974
  • Type: Financial
  • Unit: %
  • Description: Core operating cash profitability before interest, tax, depreciation and amortization.
  • Inputs: ebitda, revenue
  • Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
  • Calculation: ebitda / revenue * 100
  • Catalog key: funds.core.ebitda_margin

Gross Profit Margin

  • ID: 1972
  • Type: Financial
  • Unit: %
  • Description: Share of revenue retained after the direct cost of goods sold.
  • Inputs: revenue, cogs
  • Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
  • Calculation: (revenue - cogs) / revenue * 100
  • Catalog key: funds.core.gross_margin

Headcount (FTE)

  • ID: 1984
  • Type: Operational
  • Unit: Count
  • Description: Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.
  • Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.core.headcount

Net Profit Margin

  • ID: 1975
  • Type: Financial
  • Unit: %
  • Description: Bottom-line profitability after all costs, interest and tax.
  • Inputs: net_income, revenue
  • Methodology: Net Profit Margin = (Net Income / Revenue) × 100
  • Calculation: net_income / revenue * 100
  • Catalog key: funds.core.net_margin

Operating Cash Flow

  • ID: 1981
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Cash generated by core operations during the period.
  • Inputs: net_income, non_cash_charges, increase_in_working_capital
  • Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
  • Calculation: net_income + non_cash_charges - increase_in_working_capital
  • Catalog key: funds.core.operating_cash_flow

Operating Margin (EBIT)

  • ID: 1973
  • Type: Financial
  • Unit: %
  • Description: Operating profitability after operating expenses (EBIT margin).
  • Inputs: operating_income, revenue
  • Methodology: Operating Margin = (Operating Income / Revenue) × 100
  • Calculation: operating_income / revenue * 100
  • Catalog key: funds.core.operating_margin

Quick Ratio (Acid Test)

  • ID: 1971
  • Type: Financial
  • Unit: Ratio
  • Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view.
  • Inputs: current_assets, inventory, current_liabilities
  • Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
  • Calculation: (current_assets - inventory) / current_liabilities
  • Catalog key: funds.core.quick_ratio

Revenue Growth Rate

  • ID: 1976
  • Type: Financial
  • Unit: %
  • Description: Period-over-period revenue growth rate.
  • Inputs: revenue, revenue_prior
  • Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
  • Calculation: (revenue - revenue_prior) / revenue_prior * 100
  • Catalog key: funds.core.revenue_growth

Cash Runway

  • ID: 1983
  • Type: Financial
  • Unit: Months
  • Description: Number of months of cash remaining at the current net burn rate.
  • Inputs: current_cash_balance
  • Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
  • Calculation: current_cash_balance / burn_rate
  • Catalog key: funds.core.runway

Working Capital

  • ID: 1977
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Operating liquidity available to fund day-to-day operations.
  • Inputs: current_assets, current_liabilities
  • Methodology: Working Capital = Current Assets − Current Liabilities
  • Calculation: current_assets - current_liabilities
  • Catalog key: funds.core.working_capital

Assets Under Custody

  • ID: 1911
  • Type: Financial
  • Unit: Currency
  • Description: Fund and client assets held in custody (aggregated).
  • Methodology: Directly measured AUC at reporting date
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.assets_under_custody

Assets Under Management

  • ID: 1900
  • Type: Financial
  • Unit: Currency
  • Description: Total fund assets at period end across open-end, advised, and institutional books (aggregated).
  • Methodology: Directly measured AUM at reporting date.
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.assets_under_management

Capital Deployment Rate

  • ID: 1907
  • Type: Financial
  • Unit: %
  • Description: Called capital relative to commitments (deployment pace).
  • Inputs: called_capital, committed_capital
  • Methodology: Deployment Rate = (Called Capital / Committed Capital) × 100
  • Calculation: called_capital / committed_capital * 100
  • Catalog key: funds.fund.capital_deployment_rate

Custody Fee Yield

  • ID: 1912
  • Type: Financial
  • Unit: %
  • Description: Custody and safekeeping fees relative to average AUC.
  • Inputs: custody_fees, average_auc
  • Methodology: Custody Fee Yield = Custody Fees / Average AUC × 100
  • Calculation: custody_fees / average_auc * 100
  • Catalog key: funds.fund.custody_fee_yield

DPI

  • ID: 1906
  • Type: Financial
  • Unit: Ratio
  • Description: Distributions to paid-in capital (cash returned).
  • Inputs: distributions, paid_in_capital
  • Methodology: DPI = Distributions / Paid-In Capital
  • Calculation: distributions / paid_in_capital
  • Catalog key: funds.fund.dpi

Fund IRR

  • ID: 1904
  • Type: Financial
  • Unit: %
  • Description: Internal rate of return for a fund vintage (aggregated, no LP identifiers).
  • Methodology: IRR from aggregated cash flows and NAV (directly reported).
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.fund_irr

Fund Leverage Ratio

  • ID: 1908
  • Type: Financial
  • Unit: Ratio
  • Description: Fund-level leverage relative to net asset value (aggregated).
  • Methodology: Leverage Ratio = Total Fund Debt / NAV
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.fund_leverage_ratio

Liquidity Gate Frequency

  • ID: 1909
  • Type: Operational
  • Unit: %
  • Description: Share of funds with active liquidity gates or suspensions in period.
  • Methodology: Gate Frequency = Gated Funds / Total Funds × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.liquidity_gate_frequency

Management Fee Yield

  • ID: 1902
  • Type: Financial
  • Unit: %
  • Description: Management and advisory fees relative to average AUM.
  • Inputs: management_fees, average_aum
  • Methodology: Fee Yield = (Management Fees / Average AUM) × 100
  • Calculation: management_fees / average_aum * 100
  • Catalog key: funds.fund.management_fee_yield

Net Flow Rate

  • ID: 1901
  • Type: Financial
  • Unit: %
  • Description: Net fund flows as a percentage of beginning AUM.
  • Inputs: inflows, outflows, beginning_aum
  • Methodology: Net Flow Rate = ((Inflows − Outflows) / Beginning AUM) × 100
  • Calculation: (inflows - outflows) / beginning_aum * 100
  • Catalog key: funds.fund.net_flow_rate

Performance Fee Share

  • ID: 1903
  • Type: Financial
  • Unit: %
  • Description: Carried interest and performance fees as a share of total fund revenue (aggregated).
  • Inputs: performance_fees, total_fund_revenue
  • Methodology: Performance Fee Share = (Performance Fees / Total Fund Revenue) × 100
  • Calculation: performance_fees / total_fund_revenue * 100
  • Catalog key: funds.fund.performance_fee_share

RVPI

  • ID: 1922
  • Type: Financial
  • Unit: Ratio
  • Description: Residual value to paid-in capital (unrealized NAV relative to contributed capital).
  • Inputs: nav, paid_in_capital
  • Methodology: RVPI = NAV / Paid-In Capital
  • Calculation: nav / paid_in_capital
  • Catalog key: funds.fund.rvpi

Safekeeping Asset Growth

  • ID: 1914
  • Type: Operational
  • Unit: %
  • Description: Year-over-year growth in safekeeping and custody assets.
  • Methodology: Growth = ((Current AUC − Prior) / Prior) × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.safekeeping_asset_growth

Settlement Fail Rate

  • ID: 1913
  • Type: Operational
  • Unit: %
  • Description: Failed settlements as a share of total settlement instructions.
  • Inputs: failed_settlements, total_settlement_instructions
  • Methodology: Fail Rate = Failed Settlements / Total Instructions × 100
  • Calculation: failed_settlements / total_settlement_instructions * 100
  • Catalog key: funds.fund.settlement_fail_rate

Strategy Return Volatility

  • ID: 1910
  • Type: Financial
  • Unit: %
  • Description: Annualized volatility of fund or strategy returns (aggregated sleeve).
  • Methodology: Standard deviation of periodic returns annualized
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.fund.strategy_return_volatility

TVPI

  • ID: 1905
  • Type: Financial
  • Unit: Ratio
  • Description: Total value to paid-in capital (distributions plus NAV).
  • Inputs: distributions, nav, paid_in_capital
  • Methodology: TVPI = (Distributions + NAV) / Paid-In Capital
  • Calculation: (distributions + nav) / paid_in_capital
  • Catalog key: funds.fund.tvpi

Active Portfolio Company Count

  • ID: 1927
  • Type: Operational
  • Unit: Count
  • Description: Count of active portfolio companies at period end (aggregated).
  • Methodology: Directly measured count at reporting date.
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.operations.active_portfolio_company_count

Average Investment Size

  • ID: 1924
  • Type: Financial
  • Unit: Currency
  • Description: Average capital deployed per new investment in the period (aggregated).
  • Inputs: deployed_capital, new_investments
  • Methodology: Average Size = Deployed Capital / New Investments
  • Calculation: deployed_capital / new_investments
  • Catalog key: funds.operations.average_investment_size

Co-Investment Participation Rate

  • ID: 1930
  • Type: Operational
  • Unit: %
  • Description: Share of closed deals that included external co-investors or syndicate participants.
  • Inputs: deals_with_co_investors, total_closed_deals
  • Methodology: Co-Investment Rate = (Deals with Co-Investors / Total Closed Deals) × 100
  • Calculation: deals_with_co_investors / total_closed_deals * 100
  • Catalog key: funds.operations.co_investment_participation_rate

Follow-On Investment Rate

  • ID: 1928
  • Type: Operational
  • Unit: %
  • Description: Share of eligible portfolio companies that received follow-on capital in the period.
  • Inputs: follow_on_investments, eligible_portfolio_companies
  • Methodology: Follow-On Rate = (Follow-On Investments / Eligible Portfolio Companies) × 100
  • Calculation: follow_on_investments / eligible_portfolio_companies * 100
  • Catalog key: funds.operations.follow_on_investment_rate

Fundraising Commitment Progress

  • ID: 1931
  • Type: Financial
  • Unit: %
  • Description: Committed capital relative to fundraising target for a vintage (aggregated).
  • Inputs: committed_capital, fundraising_target
  • Methodology: Progress = (Committed Capital / Fundraising Target) × 100
  • Calculation: committed_capital / fundraising_target * 100
  • Catalog key: funds.operations.fundraising_commitment_progress

Inbound Attributed Pipeline Share

  • ID: 1934
  • Type: Operational
  • Unit: %
  • Description: Share of qualified opportunities attributed to inbound channels in the period.
  • Inputs: inbound_qualified_opportunities, total_qualified_opportunities
  • Methodology: Inbound Share = (Inbound Qualified Opportunities / Total Qualified Opportunities) × 100
  • Calculation: inbound_qualified_opportunities / total_qualified_opportunities * 100
  • Catalog key: funds.operations.inbound_attributed_pipeline_share

Investment Close Rate

  • ID: 1923
  • Type: Operational
  • Unit: %
  • Description: Share of qualified opportunities that closed as new investments in the period (aggregated).
  • Inputs: closed_investments, qualified_opportunities
  • Methodology: Close Rate = (Closed Investments / Qualified Opportunities) × 100
  • Calculation: closed_investments / qualified_opportunities * 100
  • Catalog key: funds.operations.investment_close_rate

Management Fee Operating Coverage

  • ID: 1932
  • Type: Financial
  • Unit: Ratio
  • Description: Management fees relative to operating expenses at the manager level (aggregated).
  • Inputs: management_fees, operating_expenses
  • Methodology: Coverage = Management Fees / Operating Expenses
  • Calculation: management_fees / operating_expenses
  • Catalog key: funds.operations.management_fee_operating_coverage

New Investments Count

  • ID: 1925
  • Type: Operational
  • Unit: Count
  • Description: Count of new investments closed in the period (aggregated).
  • Methodology: Directly measured count at reporting date.
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.operations.new_investments_count

Portfolio Write-Down Rate

  • ID: 1929
  • Type: Financial
  • Unit: %
  • Description: Impaired or written-down carrying value as a share of portfolio cost basis.
  • Inputs: impaired_carrying_value, portfolio_cost_basis
  • Methodology: Write-Down Rate = (Impaired Carrying Value / Portfolio Cost Basis) × 100
  • Calculation: impaired_carrying_value / portfolio_cost_basis * 100
  • Catalog key: funds.operations.portfolio_write_down_rate

Program Investment Conversion Rate

  • ID: 1933
  • Type: Operational
  • Unit: %
  • Description: Share of program or cohort participants that became portfolio investments in the period.
  • Inputs: program_investments, program_participants
  • Methodology: Conversion Rate = (Program Investments / Program Participants) × 100
  • Calculation: program_investments / program_participants * 100
  • Catalog key: funds.operations.program_investment_conversion_rate

Qualified Opportunities Count

  • ID: 1926
  • Type: Operational
  • Unit: Count
  • Description: Count of opportunities that passed initial screening in the period (aggregated).
  • Methodology: Directly measured count at reporting date.
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: funds.operations.qualified_opportunities_count

Data engineering pipeline

Ambient Core ships the catalog (typed data options and metrics) and ambient_pipeline helpers. Lakehouse jobs and schedules live in the application repository that pins a core tag.

Canonical order: map columns → coerce types → unpivot → stamp lineage → (optional Silver validate) → contract assert → write. Gold vertical products evaluate catalog formulas with ambient_calc after Silver.

How this pack feeds the pipeline

Further reading: Catalog consumption · Pipeline governance helpers


Generated from ambient-core ref 22b6089 (digest f5bca892574e3e28). Regenerate: npm run sync:catalog-wiki.