Banking
Pack file: catalog/industries/banking in ambient-core.
Workspace demo (screenshots) · Catalog consumption
Industry summary
Industry code
ISIC Rev.4 6419
63 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 (63)
- Accounts Payable Days
- Accounts Payable Turnover
- Accounts Receivable Days
- Accounts Receivable Turnover
- Monthly Burn Rate
- Cash Days
- Cash Turnover
- Cash Conversion Cycle
- Current Ratio
- Debt to EBITDA
- Debt to Equity
- Debt to Tangible Net Worth
- EBITDA (derived)
- Effective Tax Rate
- Gross Profit (derived)
- Invested Capital
- Net Debt
- Net Operating Profit After Tax (NOPAT)
- Quick Assets (strict)
- Tangible Net Worth
- Days Payable Outstanding (DPO)
- Days Sales Outstanding (DSO)
- EBIT to Interest
- EBITDA Less Capex to Interest
- EBITDA Margin
- EBITDA to Interest (Interest Coverage)
- Effective Interest Rate
- Fixed Charge Coverage
- Gross Profit Margin
- Headcount (FTE)
- Interest Burden
- Inventory Days
- Inventory Turnover (ending balance)
- Net Debt to EBITDA
- Net Profit Margin
- Net Profit Margin (decimal quotient)
- Operating Cash Flow
- Operating Margin (EBIT)
- Operating Profit Margin (EBIT)
- PP&E Turnover
- Quick Ratio (Acid Test)
- Quick Ratio (Quick Assets)
- Return on Assets (ROA)
- Return on Equity (ROE)
- Return on Invested Capital (ROIC)
- Revenue Growth Rate
- Cash Runway
- Tax Burden
- Total Asset Turnover
- Total Assets to Equity (Equity Multiplier)
- Working Capital
- Cost of Funds
- Efficiency Ratio
- Interest Rate Risk EVE Sensitivity
- Liquidity Coverage Ratio
- Loan-to-Deposit Ratio
- Net Interest Margin
- Net Stable Funding Ratio
- Non-Performing Loan Ratio
- Operational Risk Loss Ratio
- Stable Funding Ratio
- Stress Test CET1 Delta
- Tier 1 Capital Ratio
Accounts Payable Days
- ID: 2882
- Type: Financial
- Unit: Days
- Description: Payables expressed as days of COGS; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DPO.
- Inputs:
cogs,accounts_payable - Methodology: Accounts Payable Days
- Calculation:
accounts_payable * 365 / max(cogs, 0) - Catalog key:
banking.core.accounts_payable_days
Accounts Payable Turnover
- ID: 2881
- Type: Financial
- Unit: x
- Description: COGS divided by accounts payable
- Inputs:
cogs,accounts_payable - Methodology: Accounts Payable Turnover
- Calculation:
cogs / max(accounts_payable, 0) - Catalog key:
banking.core.accounts_payable_turnover
Accounts Receivable Days
- ID: 2878
- Type: Financial
- Unit: Days
- Description: Receivable balance in days of revenue; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DSO.
- Inputs:
revenue,accounts_receivable - Methodology: Accounts Receivable Days
- Calculation:
accounts_receivable * 365 / max(revenue, 0) - Catalog key:
banking.core.accounts_receivable_days
Accounts Receivable Turnover
- ID: 2877
- Type: Financial
- Unit: x
- Description: Revenue divided by accounts receivable Not parameterized DSO.
- Inputs:
revenue,accounts_receivable - Methodology: Accounts Receivable Turnover
- Calculation:
revenue / max(accounts_receivable, 0) - Catalog key:
banking.core.accounts_receivable_turnover
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 Days
- ID: 2876
- Type: Financial
- Unit: Days
- Description: Cash balance expressed as days of revenue at a 365-day year (Ambient corporate ratio pack).
- Inputs:
revenue,cash - Methodology: Cash Days
- Calculation:
cash * 365 / max(revenue, 0) - Catalog key:
banking.core.cash_days
Cash Turnover
- ID: 2875
- Type: Financial
- Unit: x
- Description: Revenue divided by cash
- Inputs:
revenue,cash - Methodology: Cash Turnover
- Calculation:
revenue / max(cash, 0) - Catalog key:
banking.core.cash_turnover
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
Debt to EBITDA
- ID: 2886
- Type: Financial
- Unit: x
- Description: Gross interest-bearing debt divided by EBITDA
- Inputs:
interest_bearing_liabilities - Methodology: Debt to EBITDA
- Calculation:
interest_bearing_liabilities / max(ebitda_derived, 0) - Catalog key:
banking.core.debt_to_ebitda
Debt to Equity
- ID: 2884
- Type: Financial
- Unit: x
- Description: Interest-bearing liabilities divided by equity
- Inputs:
interest_bearing_liabilities,total_shareholders_equity - Methodology: Debt to Equity
- Calculation:
interest_bearing_liabilities / max(total_shareholders_equity, 0) - Catalog key:
banking.core.debt_to_equity
Debt to Tangible Net Worth
- ID: 2885
- Type: Financial
- Unit: x
- Description: Interest-bearing debt divided by tangible net worth (Ambient corporate ratio pack).
- Inputs:
interest_bearing_liabilities - Methodology: Debt to Tangible Net Worth
- Calculation:
interest_bearing_liabilities / max(tangible_net_worth, 0) - Catalog key:
banking.core.debt_to_tangible_net_worth
EBITDA (derived)
- ID: 2858
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: EBIT plus depreciation and amortization
- Inputs:
operating_income,depreciation,amortization - Methodology: EBITDA (derived)
- Calculation:
operating_income + depreciation + amortization - Catalog key:
banking.core.derived_ebitda
Effective Tax Rate
- ID: 2859
- Type: Financial
- Unit: %
- Description: Tax expense divided by earnings before tax
- Inputs:
tax_expense,earnings_before_tax - Methodology: Effective Tax Rate = Tax Expense / Earnings Before Tax
- Calculation:
tax_expense / max(earnings_before_tax, 0) - Catalog key:
banking.core.derived_effective_tax_rate
Gross Profit (derived)
- ID: 2857
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Revenue minus COGS; building block for margins
- Inputs:
revenue,cogs - Methodology: Gross Profit (derived)
- Calculation:
revenue - cogs - Catalog key:
banking.core.derived_gross_profit
Invested Capital
- ID: 2862
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Net debt plus total shareholders' equity
- Inputs:
total_shareholders_equity - Methodology: Invested Capital
- Calculation:
net_debt + total_shareholders_equity - Catalog key:
banking.core.derived_invested_capital
Net Debt
- ID: 2861
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Interest-bearing liabilities minus cash
- Inputs:
interest_bearing_liabilities,cash - Methodology: Net Debt
- Calculation:
interest_bearing_liabilities - cash - Catalog key:
banking.core.derived_net_debt
Net Operating Profit After Tax (NOPAT)
- ID: 2860
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: EBIT adjusted for cash taxes using the effective tax rate (Ambient corporate ratio pack).
- Inputs:
operating_income - Methodology: Net Operating Profit After Tax (NOPAT)
- Calculation:
operating_income * (1 - effective_tax_rate) - Catalog key:
banking.core.derived_nopat
Quick Assets (strict)
- ID: 2864
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Cash, marketable securities, and accounts receivable (Ambient corporate ratio pack).
- Inputs:
cash,marketable_securities,accounts_receivable - Methodology: Quick Assets (strict)
- Calculation:
cash + marketable_securities + accounts_receivable - Catalog key:
banking.core.derived_quick_assets
Tangible Net Worth
- ID: 2863
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Shareholders' equity minus intangible assets
- Inputs:
total_shareholders_equity,intangible_assets - Methodology: Tangible Net Worth
- Calculation:
total_shareholders_equity - intangible_assets - Catalog key:
banking.core.derived_tangible_net_worth
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
EBIT to Interest
- ID: 2890
- Type: Financial
- Unit: x
- Description: EBIT divided by gross interest expense
- Inputs:
operating_income,interest_expense - Methodology: EBIT to Interest
- Calculation:
operating_income / max(interest_expense, 0) - Catalog key:
banking.core.ebit_to_interest
EBITDA Less Capex to Interest
- ID: 2891
- Type: Financial
- Unit: x
- Description: Capex-adjusted EBITDA coverage
- Inputs:
capital_expenditures,interest_expense - Methodology: EBITDA Less Capex to Interest
- Calculation:
(ebitda_derived - capital_expenditures) / max(interest_expense, 0) - Catalog key:
banking.core.ebitda_less_capex_to_interest
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
EBITDA to Interest (Interest Coverage)
- ID: 2889
- Type: Financial
- Unit: x
- Description: EBITDA divided by gross interest expense
- Inputs:
interest_expense - Methodology: EBITDA to Interest (Interest Coverage)
- Calculation:
ebitda_derived / max(interest_expense, 0) - Catalog key:
banking.core.ebitda_to_interest
Effective Interest Rate
- ID: 2870
- Type: Financial
- Unit: %
- Description: Gross interest expense divided by interest-bearing liabilities (Ambient corporate ratio pack).
- Inputs:
interest_expense,interest_bearing_liabilities - Methodology: Effective Interest Rate
- Calculation:
interest_expense / max(interest_bearing_liabilities, 0) - Catalog key:
banking.core.effective_interest_rate
Fixed Charge Coverage
- ID: 2892
- Type: Financial
- Unit: x
- Description: Capex-adjusted EBITDA over interest plus current debt maturities (Ambient corporate ratio pack).
- Inputs:
capital_expenditures,interest_expense,current_portion_long_term_debt - Methodology: Fixed Charge Coverage
- Calculation:
(ebitda_derived - capital_expenditures) / max(interest_expense + current_portion_long_term_debt, 0) - Catalog key:
banking.core.fixed_charge_coverage
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
Interest Burden
- ID: 2871
- Type: Financial
- Unit: %
- Description: EBT relative to EBIT; DuPont lever
- Inputs:
earnings_before_tax,operating_income - Methodology: Interest Burden
- Calculation:
earnings_before_tax / max(operating_income, 0) - Catalog key:
banking.core.interest_burden
Inventory Days
- ID: 2880
- Type: Financial
- Unit: Days
- Description: Inventory held in days of COGS; 365-day convention (Ambient corporate ratio pack).
- Inputs:
cogs,inventory - Methodology: Inventory Days
- Calculation:
inventory * 365 / max(cogs, 0) - Catalog key:
banking.core.inventory_days
Inventory Turnover (ending balance)
- ID: 2879
- Type: Financial
- Unit: x
- Description: COGS divided by ending inventory Distinct from average-inventory variants.
- Inputs:
cogs,inventory - Methodology: Inventory Turnover (ending balance)
- Calculation:
cogs / max(inventory, 0) - Catalog key:
banking.core.inventory_turnover
Net Debt to EBITDA
- ID: 2887
- Type: Financial
- Unit: x
- Description: Net debt divided by EBITDA
- Methodology: Net Debt to EBITDA
- Calculation:
net_debt / max(ebitda_derived, 0) - Catalog key:
banking.core.net_debt_to_ebitda
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
Net Profit Margin (decimal quotient)
- ID: 2869
- Type: Financial
- Unit: %
- Description: Net income divided by revenue as a decimal quotient. Alias of net_margin at percent scale; see docs/ratios/corporate-ratios.md.
- Inputs:
net_income,revenue - Methodology: Net Profit Margin = Net Income / Revenue
- Calculation:
net_income / max(revenue, 0) - Catalog key:
banking.core.net_profit_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
Operating Profit Margin (EBIT)
- ID: 2868
- Type: Financial
- Unit: %
- Description: EBIT divided by revenue as a decimal quotient. Alias of operating_margin at percent scale; see docs/ratios/corporate-ratios.md. Alias of operating_margin at percent scale.
- Inputs:
operating_income,revenue - Methodology: Operating Profit Margin = EBIT / Revenue
- Calculation:
operating_income / max(revenue, 0) - Catalog key:
banking.core.operating_profit_margin
PP&E Turnover
- ID: 2874
- Type: Financial
- Unit: x
- Description: Revenue divided by net PP&E
- Inputs:
revenue,ppe_net - Methodology: PP&E Turnover
- Calculation:
revenue / max(ppe_net, 0) - Catalog key:
banking.core.ppe_turnover
Quick Ratio (Acid Test)
- ID: 1501
- Type: Financial
- Unit: Ratio
- Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view. Default formula: current assets minus inventory. See quick_ratio_quick_assets for the alternate convention (cash + marketable securities + receivables).
- 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
Quick Ratio (Quick Assets)
- ID: 2888
- Type: Financial
- Unit: x
- Description: Strict quick assets over current liabilities Formula-box quick_ratio remains default.
- Inputs:
current_liabilities - Methodology: Quick Ratio = (Cash + Marketable Securities + A/R) / Current Liabilities
- Calculation:
quick_assets / max(current_liabilities, 0) - Catalog key:
banking.core.quick_ratio_quick_assets
Return on Assets (ROA)
- ID: 2866
- Type: Financial
- Unit: %
- Description: Net income divided by total assets
- Inputs:
net_income,total_assets - Methodology: ROA = Net Income / Total Assets
- Calculation:
net_income / max(total_assets, 0) - Catalog key:
banking.core.return_on_assets
Return on Equity (ROE)
- ID: 2865
- Type: Financial
- Unit: %
- Description: Net income divided by shareholders' equity
- Inputs:
net_income,total_shareholders_equity - Methodology: ROE = Net Income / Total Shareholders' Equity
- Calculation:
net_income / max(total_shareholders_equity, 0) - Catalog key:
banking.core.return_on_equity
Return on Invested Capital (ROIC)
- ID: 2867
- Type: Financial
- Unit: %
- Description: NOPAT divided by invested capital
- Methodology: ROIC = NOPAT / (Net Debt + Equity)
- Calculation:
nopat / max(invested_capital, 0) - Catalog key:
banking.core.return_on_invested_capital
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
Tax Burden
- ID: 2872
- Type: Financial
- Unit: %
- Description: Net income relative to EBT; DuPont lever
- Inputs:
net_income,earnings_before_tax - Methodology: Tax Burden
- Calculation:
net_income / max(earnings_before_tax, 0) - Catalog key:
banking.core.tax_burden
Total Asset Turnover
- ID: 2873
- Type: Financial
- Unit: x
- Description: Revenue divided by total assets
- Inputs:
revenue,total_assets - Methodology: Total Asset Turnover
- Calculation:
revenue / max(total_assets, 0) - Catalog key:
banking.core.total_asset_turnover
Total Assets to Equity (Equity Multiplier)
- ID: 2883
- Type: Financial
- Unit: x
- Description: Financial leverage lever in DuPont
- Inputs:
total_assets,total_shareholders_equity - Methodology: Total Assets to Equity (Equity Multiplier)
- Calculation:
total_assets / max(total_shareholders_equity, 0) - Catalog key:
banking.core.total_assets_to_equity
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
- Accounting Software — feeds Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin
- Financial statements — feeds Current Ratio, Quick Ratio (Acid Test), Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin, EBITDA Margin, Operating Cash Flow, Revenue Growth Rate, Working Capital, Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), Cash Conversion Cycle, Monthly Burn Rate, Cash Runway
- HR records — feeds Headcount (FTE)
- Payroll records — feeds Net Profit Margin, Operating Margin (EBIT)
- Aggregated regulatory and financial summary — feeds Net Interest Margin, Non-Performing Loan Ratio, Loan-to-Deposit Ratio, Efficiency Ratio, Tier 1 Capital Ratio, Cost of Funds, Stable Funding Ratio, Liquidity Coverage Ratio, Net Stable Funding Ratio, Interest Rate Risk EVE Sensitivity, Operational Risk Loss Ratio, Stress Test CET1 Delta
Further reading: Catalog consumption · Pipeline governance helpers
Generated from ambient-core ref cc3d169 (digest a0e8f2dc8aa708fd). Regenerate: npm run sync:catalog-wiki.