Skip to main content

Banking (depository)

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

Workspace demo (screenshots) · Catalog consumption

Industry summary​

Industry code

ISIC Rev.4 6419

27 metrics · 5 data options

NAICS 2022
522110
NACE Rev.2
64.19
GICS 2023
401010

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

Data options (5)​

Accounting Software​

Catalog key banking.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 banking.core.financial_statements

Fields

date
date
statement_type
enum
period_start_date
date
period_end_date
date

HR records​

Catalog key banking.core.hr_records

Fields

date
date
headcount
decimal

Payroll records​

Catalog key banking.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 regulatory and financial summary​

Catalog key banking.depository.regulatory_summary

Fields

date
date
entity_segment
string
net_interest_income
string
average_earning_assets
string
non_performing_loans
string
total_loans
decimal
total_deposits
decimal
operating_expense
string
total_revenue
decimal

Metrics (27)​

Monthly Burn Rate​

  • ID: 1512
  • 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: banking.core.burn_rate

Cash Conversion Cycle​

  • ID: 1510
  • 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: banking.core.ccc

Current Ratio​

  • ID: 1500
  • 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: banking.core.current_ratio

Days Payable Outstanding (DPO)​

  • ID: 1509
  • 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: banking.core.dpo

Days Sales Outstanding (DSO)​

  • ID: 1508
  • 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: banking.core.dso

EBITDA Margin​

  • ID: 1504
  • 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: banking.core.ebitda_margin

Gross Profit Margin​

  • ID: 1502
  • 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: banking.core.gross_margin

Headcount (FTE)​

  • ID: 1514
  • 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: banking.core.headcount

Net Profit Margin​

  • ID: 1505
  • 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: banking.core.net_margin

Operating Cash Flow​

  • ID: 1511
  • 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: banking.core.operating_cash_flow

Operating Margin (EBIT)​

  • ID: 1503
  • 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: banking.core.operating_margin

Quick Ratio (Acid Test)​

  • ID: 1501
  • 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: banking.core.quick_ratio

Revenue Growth Rate​

  • ID: 1506
  • 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: banking.core.revenue_growth

Cash Runway​

  • ID: 1513
  • 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: banking.core.runway

Working Capital​

  • ID: 1507
  • 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: banking.core.working_capital

Cost of Funds​

  • ID: 1554
  • Type: Financial
  • Unit: %
  • Description: Average rate paid on interest-bearing liabilities (aggregated).
  • Methodology: Cost of Funds = Interest Expense on Deposits and Borrowings / Average Interest-Bearing Liabilities × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.cost_of_funds

Efficiency Ratio​

  • ID: 1533
  • Type: Financial
  • Unit: %
  • Description: Non-interest expense relative to revenue (cost-to-income).
  • Inputs: operating_expense, total_revenue
  • Methodology: Efficiency Ratio = (Operating Expense / Total Revenue) × 100
  • Calculation: operating_expense / total_revenue * 100
  • Catalog key: banking.depository.efficiency_ratio

Interest Rate Risk EVE Sensitivity​

  • ID: 1559
  • Type: Financial
  • Unit: %
  • Description: Change in economic value of equity for a defined parallel rate shock (aggregated ALM).
  • Methodology: EVE sensitivity = ΔEVE / Base EVE for standard shock
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.interest_rate_risk_eve_sensitivity

Liquidity Coverage Ratio​

  • ID: 1557
  • Type: Financial
  • Unit: %
  • Description: High-quality liquid assets relative to net cash outflows (LCR).
  • Methodology: LCR = HQLA / Net Cash Outflows over 30 days × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.liquidity_coverage_ratio

Loan-to-Deposit Ratio​

  • ID: 1532
  • Type: Financial
  • Unit: %
  • Description: Lending funded by deposits (liquidity and balance-sheet structure).
  • Inputs: total_loans, total_deposits
  • Methodology: LTD = (Total Loans / Total Deposits) × 100
  • Calculation: total_loans / total_deposits * 100
  • Catalog key: banking.depository.loan_to_deposit_ratio

Net Interest Margin​

  • ID: 1530
  • Type: Financial
  • Unit: %
  • Description: Spread between interest earned and interest paid, relative to earning assets (aggregated regulatory summary).
  • Inputs: net_interest_income, average_earning_assets
  • Methodology: NIM = (Net Interest Income / Average Earning Assets) × 100
  • Calculation: net_interest_income / average_earning_assets * 100
  • Catalog key: banking.depository.net_interest_margin

Net Stable Funding Ratio​

  • ID: 1558
  • Type: Financial
  • Unit: %
  • Description: Available stable funding relative to required stable funding (NSFR).
  • Methodology: NSFR = Available Stable Funding / Required Stable Funding × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.net_stable_funding_ratio

Non-Performing Loan Ratio​

  • ID: 1531
  • Type: Financial
  • Unit: %
  • Description: Share of loans past due or non-accrual (aggregated credit quality).
  • Inputs: non_performing_loans, total_loans
  • Methodology: NPL Ratio = (Non-Performing Loans / Total Loans) × 100
  • Calculation: non_performing_loans / total_loans * 100
  • Catalog key: banking.depository.non_performing_loan_ratio

Operational Risk Loss Ratio​

  • ID: 1567
  • Type: Financial
  • Unit: %
  • Description: Operational losses as a share of gross income (aggregated).
  • Inputs: operational_losses, gross_income
  • Methodology: Op Risk Loss Ratio = Operational Losses / Gross Income × 100
  • Calculation: operational_losses / gross_income * 100
  • Catalog key: banking.depository.operational_risk_loss_ratio

Stable Funding Ratio​

  • ID: 1556
  • Type: Financial
  • Unit: %
  • Description: Share of funding from stable retail and long-term sources (proxy or regulatory).
  • Methodology: Stable Funding Ratio = Stable Funding / Total Funding × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.stable_funding_ratio

Stress Test CET1 Delta​

  • ID: 1568
  • Type: Financial
  • Unit: %
  • Description: Decline in CET1 ratio under supervisory severely adverse scenario (aggregated).
  • Methodology: CET1 Delta = Stressed CET1 − Baseline CET1
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.stress_test_cet1_delta

Tier 1 Capital Ratio​

  • ID: 1534
  • Type: Financial
  • Unit: %
  • Description: Tier 1 capital to risk-weighted assets from aggregated regulatory filing (no account-level detail).
  • Methodology: Tier 1 Ratio = (Tier 1 Capital / Risk-Weighted Assets) × 100
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: banking.depository.tier1_capital_ratio

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.