Restaurants
Pack file: catalog/industries/restaurants in ambient-core.
Workspace demo (screenshots) · Catalog consumption
Industry summary
Industry code
ISIC Rev.4 5610
64 metrics · 17 data options
- NAICS 2022
722511- NACE Rev.2
56.10- GICS 2023
253010
Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.
Data options (17)
Accounts payable aging
Catalog key Allrestaurantsds-ap-aging
Fields
date- date
supplier_name- string
bill_id- id
bill_date- date
due_date- date
amount_due- decimal
days_outstanding- string
aging_bucket- string
accounts_payable- decimal
cogs- string
days- string
days_inventory_outstanding- string
Accounts receivable aging
Catalog key Allrestaurantsds-ar-aging
Fields
date- date
customer_name- string
invoice_id- id
invoice_date- date
due_date- date
amount_due- decimal
days_outstanding- string
aging_bucket- string
accounts_receivable- decimal
total_credit_sales- decimal
days- string
days_inventory_outstanding- string
Balance sheet
Catalog key Allrestaurantsds-balance-sheet
Fields
date- date
period_end_date- date
inventory- string
Bank statements
Catalog key Allrestaurantsds-bank-statements
Fields
date- date
transaction_date- date
account_id- id
description- string
amount- decimal
direction- string
balance- string
currency- currency
net_income- string
non_cash_charges- string
increase_in_working_capital- string
cash_out- string
cash_in- string
current_cash_balance- string
CRM / Sales pipeline
Catalog key Allrestaurantsds-crm-pipeline
Fields
date- date
opportunity_id- id
account_name- decimal
stage- enum
amount- decimal
close_date- date
owner- string
probability- string
active_subscriptions- string
avg_monthly_price- decimal
sales_marketing_spend- string
new_customers- string
General ledger
Catalog key Allrestaurantsds-general-ledger
Fields
date- date
account_code- id
account_name- decimal
journal_entry_id- id
debit- string
credit- string
period- enum
currency- currency
Marketing spend records
Catalog key Allrestaurantsds-marketing-spend
Fields
date- date
channel- enum
campaign- string
spend- string
leads- string
new_customers- string
currency- currency
sales_marketing_spend- string
Product usage logs
Catalog key Allrestaurantsds-product-usage
Fields
date- date
customer_id- id
active_users- string
sessions- string
feature_adoption- string
usage_minutes- string
starting_mrr- string
expansion_mrr- string
contraction_mrr- string
churned_mrr- string
Subscription billing records
Catalog key Allrestaurantsds-subscription-billing
Fields
date- date
customer_id- id
plan_name- string
mrr- string
billing_period- enum
status- enum
start_date- date
end_date- date
active_subscriptions- string
avg_monthly_price- decimal
starting_mrr- string
expansion_mrr- string
contraction_mrr- string
churned_mrr- string
avg_revenue_per_account- decimal
churn_rate- decimal
Trial balance
Catalog key Allrestaurantsds-trial-balance
Fields
date- date
account_code- id
account_name- decimal
debit_balance- string
credit_balance- string
period- enum
Inventory count export
Catalog key RestInv922CatalogOptionKey02
Fields
date- date
location_id- id
category- string
quantity_on_hand- string
usage_value- string
waste_value- string
spoilage_value- string
Labor scheduling export
Catalog key RestLabor923CatalogOptionKey03
Fields
date- date
location_id- id
role- string
scheduled_hours- decimal
actual_hours- decimal
labor_cost- decimal
POS daily close
Catalog key RestPos921CatalogOptionKey01
Fields
date- date
location_id- id
gross_sales- string
net_sales- string
food_sales- string
covers- string
avg_check_minutes- string
labor_hours- decimal
labor_cost- decimal
food_cogs- string
food_revenue- decimal
total_labor- decimal
total_revenue- decimal
table_turnover- string
current_sss- string
prior_sss- string
Accounting Software
Catalog key restaurants.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 restaurants.core.financial_statements
Fields
date- date
statement_type- enum
period_start_date- date
period_end_date- date
HR records
Catalog key restaurants.core.hr_records
Fields
date- date
headcount- decimal
Payroll records
Catalog key restaurants.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
Metrics (64)
- Annual Recurring Revenue (ARR)
- Customer Acquisition Cost (CAC)
- Gross Revenue Churn Rate
- Customer Lifetime Value (LTV)
- LTV : CAC Ratio
- Monthly Recurring Revenue (MRR)
- Net Revenue Retention (NRR)
- Rule of 40
- Food Cost Percentage
- Labor Cost Percentage
- Same-Store Sales Growth
- Table Turn Time
- Food Waste and Spoilage
- 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
Annual Recurring Revenue (ARR)
- ID: 1021
- Type: Financial
- Unit: Currency/year
- Description: Annualized run-rate of recurring subscription revenue.
- Methodology: ARR = MRR × 12
- Calculation:
mrr * 12 - Catalog key:
Allrestaurantssaas-arr
Customer Acquisition Cost (CAC)
- ID: 1039
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Fully-loaded sales & marketing cost to acquire one new customer.
- Inputs:
sales_marketing_spend,new_customers - Methodology: CAC = Total Sales & Marketing Spend / New Customers Acquired
- Calculation:
sales_marketing_spend / new_customers - Catalog key:
Allrestaurantssaas-cac
Gross Revenue Churn Rate
- ID: 1033
- Type: Operational
- Unit: %
- Description: Percentage of recurring revenue lost to cancellations and downgrades.
- Inputs:
churned_mrr,starting_mrr - Methodology: Gross Churn = (Churned MRR / Starting MRR) × 100
- Calculation:
churned_mrr / starting_mrr * 100 - Catalog key:
Allrestaurantssaas-gross-churn
Customer Lifetime Value (LTV)
- ID: 1045
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Expected gross-margin revenue from a customer over their lifetime.
- Inputs:
avg_revenue_per_account,gross_margin_pct,churn_rate - Methodology: LTV = (Average Revenue per Account × Gross Margin %) / Churn Rate
- Calculation:
(avg_revenue_per_account * gross_margin_pct / 100) / churn_rate - Catalog key:
Allrestaurantssaas-ltv
LTV : CAC Ratio
- ID: 1051
- Type: Financial
- Unit: Ratio
- Description: Ratio of customer lifetime value to acquisition cost — core SaaS unit economics.
- Methodology: LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost
- Calculation:
ltv / cac - Catalog key:
Allrestaurantssaas-ltv-cac
Monthly Recurring Revenue (MRR)
- ID: 1015
- Type: Financial
- Unit: Currency/month
- Description: Normalized recurring subscription revenue billed in a month.
- Inputs:
active_subscriptions,avg_monthly_price - Methodology: MRR = Σ (Active Subscriptions × Monthly Subscription Price)
- Calculation:
active_subscriptions * avg_monthly_price - Catalog key:
Allrestaurantssaas-mrr
Net Revenue Retention (NRR)
- ID: 1027
- Type: Financial
- Unit: %
- Description: Revenue retained and expanded from existing customers, net of churn and contraction.
- Inputs:
starting_mrr,expansion_mrr,contraction_mrr,churned_mrr - Methodology: NRR = ((Starting MRR + Expansion − Contraction − Churn) / Starting MRR) × 100
- Calculation:
(starting_mrr + expansion_mrr - contraction_mrr - churned_mrr) / starting_mrr * 100 - Catalog key:
Allrestaurantssaas-nrr
Rule of 40
- ID: 1057
- Type: Financial
- Unit: %
- Description: Balance of growth and profitability for recurring-revenue businesses.
- Inputs:
revenue_growth_pct,profit_margin_pct - Methodology: Rule of 40 = Revenue Growth % + Profit Margin %
- Calculation:
revenue_growth_pct + profit_margin_pct - Catalog key:
Allrestaurantssaas-rule-of-40
Food Cost Percentage
- ID: 921
- Type: Financial
- Unit: %
- Description: Cost of food sold as a percentage of restaurant revenue.
- Inputs:
food_cogs,food_revenue - Methodology: Food Cost % = Food COGS / Food Revenue × 100
- Calculation:
food_cogs / food_revenue * 100 - Catalog key:
RestFood921CatalogMetricKey01
Labor Cost Percentage
- ID: 922
- Type: Financial
- Unit: %
- Description: Total labor cost as a percentage of revenue for the period.
- Inputs:
total_labor,total_revenue - Methodology: Labor Cost % = Total Labor / Total Revenue × 100
- Calculation:
total_labor / total_revenue * 100 - Catalog key:
RestLabor922CatalogMetricKey02
Same-Store Sales Growth
- ID: 925
- Type: Financial
- Unit: %
- Description: Year-over-year revenue change for locations open in both periods.
- Inputs:
current_sss,prior_sss - Methodology: (Current Period SSS Revenue − Prior Year SSS Revenue) / Prior Year SSS Revenue × 100
- Calculation:
(current_sss - prior_sss) / prior_sss * 100 - Catalog key:
RestSss925CatalogMetricKey05
Table Turn Time
- ID: 923
- Type: Operational
- Unit: Minutes
- Description: Average minutes from seat to payment for dine-in service.
- Methodology: Mean elapsed time per closed check for dine-in dayparts
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
RestTurn923CatalogMetricKey03
Food Waste and Spoilage
- ID: 924
- Type: Operational
- Unit: Currency (e.g., USD)
- Description: Value or weight of inventory written off as waste or spoilage.
- Methodology: Sum of waste/spoilage adjustments from inventory counts
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
RestWaste924CatalogMetricKey04
Accounts Payable Days
- ID: 3350
- 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:
restaurants.core.accounts_payable_days
Accounts Payable Turnover
- ID: 3349
- 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:
restaurants.core.accounts_payable_turnover
Accounts Receivable Days
- ID: 3346
- 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:
restaurants.core.accounts_receivable_days
Accounts Receivable Turnover
- ID: 3345
- 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:
restaurants.core.accounts_receivable_turnover
Monthly Burn Rate
- ID: 1003
- 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:
restaurants.core.burn_rate
Cash Days
- ID: 3344
- 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:
restaurants.core.cash_days
Cash Turnover
- ID: 3343
- Type: Financial
- Unit: x
- Description: Revenue divided by cash
- Inputs:
revenue,cash - Methodology: Cash Turnover
- Calculation:
revenue / max(cash, 0) - Catalog key:
restaurants.core.cash_turnover
Cash Conversion Cycle
- ID: 991
- 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:
restaurants.core.ccc
Current Ratio
- ID: 931
- 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:
restaurants.core.current_ratio
Debt to EBITDA
- ID: 3354
- 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:
restaurants.core.debt_to_ebitda
Debt to Equity
- ID: 3352
- 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:
restaurants.core.debt_to_equity
Debt to Tangible Net Worth
- ID: 3353
- 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:
restaurants.core.debt_to_tangible_net_worth
EBITDA (derived)
- ID: 3326
- 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:
restaurants.core.derived_ebitda
Effective Tax Rate
- ID: 3327
- 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:
restaurants.core.derived_effective_tax_rate
Gross Profit (derived)
- ID: 3325
- 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:
restaurants.core.derived_gross_profit
Invested Capital
- ID: 3330
- 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:
restaurants.core.derived_invested_capital
Net Debt
- ID: 3329
- 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:
restaurants.core.derived_net_debt
Net Operating Profit After Tax (NOPAT)
- ID: 3328
- 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:
restaurants.core.derived_nopat
Quick Assets (strict)
- ID: 3332
- 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:
restaurants.core.derived_quick_assets
Tangible Net Worth
- ID: 3331
- 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:
restaurants.core.derived_tangible_net_worth
Days Payable Outstanding (DPO)
- ID: 985
- 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:
restaurants.core.dpo
Days Sales Outstanding (DSO)
- ID: 979
- 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:
restaurants.core.dso
EBIT to Interest
- ID: 3358
- 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:
restaurants.core.ebit_to_interest
EBITDA Less Capex to Interest
- ID: 3359
- 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:
restaurants.core.ebitda_less_capex_to_interest
EBITDA Margin
- ID: 955
- 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:
restaurants.core.ebitda_margin
EBITDA to Interest (Interest Coverage)
- ID: 3357
- 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:
restaurants.core.ebitda_to_interest
Effective Interest Rate
- ID: 3338
- 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:
restaurants.core.effective_interest_rate
Fixed Charge Coverage
- ID: 3360
- 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:
restaurants.core.fixed_charge_coverage
Gross Profit Margin
- ID: 943
- 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:
restaurants.core.gross_margin
Headcount (FTE)
- ID: 1083
- 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:
restaurants.core.headcount
Interest Burden
- ID: 3339
- 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:
restaurants.core.interest_burden
Inventory Days
- ID: 3348
- 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:
restaurants.core.inventory_days
Inventory Turnover (ending balance)
- ID: 3347
- 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:
restaurants.core.inventory_turnover
Net Debt to EBITDA
- ID: 3355
- Type: Financial
- Unit: x
- Description: Net debt divided by EBITDA
- Methodology: Net Debt to EBITDA
- Calculation:
net_debt / max(ebitda_derived, 0) - Catalog key:
restaurants.core.net_debt_to_ebitda
Net Profit Margin
- ID: 961
- 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:
restaurants.core.net_margin
Net Profit Margin (decimal quotient)
- ID: 3337
- 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:
restaurants.core.net_profit_margin
Operating Cash Flow
- ID: 997
- 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:
restaurants.core.operating_cash_flow
Operating Margin (EBIT)
- ID: 949
- 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:
restaurants.core.operating_margin
Operating Profit Margin (EBIT)
- ID: 3336
- 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:
restaurants.core.operating_profit_margin
PP&E Turnover
- ID: 3342
- 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:
restaurants.core.ppe_turnover
Quick Ratio (Acid Test)
- ID: 937
- 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:
restaurants.core.quick_ratio
Quick Ratio (Quick Assets)
- ID: 3356
- 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:
restaurants.core.quick_ratio_quick_assets
Return on Assets (ROA)
- ID: 3334
- 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:
restaurants.core.return_on_assets
Return on Equity (ROE)
- ID: 3333
- 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:
restaurants.core.return_on_equity
Return on Invested Capital (ROIC)
- ID: 3335
- Type: Financial
- Unit: %
- Description: NOPAT divided by invested capital
- Methodology: ROIC = NOPAT / (Net Debt + Equity)
- Calculation:
nopat / max(invested_capital, 0) - Catalog key:
restaurants.core.return_on_invested_capital
Revenue Growth Rate
- ID: 967
- 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:
restaurants.core.revenue_growth
Cash Runway
- ID: 1009
- 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:
restaurants.core.runway
Tax Burden
- ID: 3340
- 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:
restaurants.core.tax_burden
Total Asset Turnover
- ID: 3341
- 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:
restaurants.core.total_asset_turnover
Total Assets to Equity (Equity Multiplier)
- ID: 3351
- 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:
restaurants.core.total_assets_to_equity
Working Capital
- ID: 973
- 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:
restaurants.core.working_capital
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
- Accounts payable aging — feeds Days Payable Outstanding (DPO), Cash Conversion Cycle
- Accounts receivable aging — feeds Days Sales Outstanding (DSO), Cash Conversion Cycle
- Balance sheet — feeds Current Ratio, Quick Ratio (Acid Test), Working Capital, Cash Conversion Cycle
- Bank statements — feeds Operating Cash Flow, Monthly Burn Rate, Cash Runway
- CRM / Sales pipeline — feeds Monthly Recurring Revenue (MRR), Customer Acquisition Cost (CAC)
- General ledger — feeds Gross Profit Margin, Operating Margin (EBIT), EBITDA Margin, Net Profit Margin, Revenue Growth Rate, Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), Operating Cash Flow, Customer Acquisition Cost (CAC)
- Marketing spend records — feeds Customer Acquisition Cost (CAC), LTV : CAC Ratio
- Product usage logs — feeds Net Revenue Retention (NRR), Gross Revenue Churn Rate
- Subscription billing records — feeds Monthly Recurring Revenue (MRR), Annual Recurring Revenue (ARR), Net Revenue Retention (NRR), Gross Revenue Churn Rate, Customer Lifetime Value (LTV), LTV : CAC Ratio, Rule of 40
- Trial balance — feeds Current Ratio, Quick Ratio (Acid Test), Working Capital
- Inventory count export — feeds Food Cost Percentage, Food Waste and Spoilage
- Labor scheduling export — feeds Labor Cost Percentage
- POS daily close — feeds Food Cost Percentage, Labor Cost Percentage, Table Turn Time, Same-Store Sales Growth
- 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), Labor Cost Percentage
- Payroll records — feeds Net Profit Margin, Operating Margin (EBIT)
Further reading: Catalog consumption · Pipeline governance helpers
Generated from ambient-core ref cc3d169 (digest a0e8f2dc8aa708fd). Regenerate: npm run sync:catalog-wiki.