Aviation
Pack file: catalog/industries/aviation in ambient-core.
Workspace demo (screenshots) · Catalog consumption
Industry summary
Industry code
ISIC Rev.4 5110
63 metrics · 7 data options
- NAICS 2022
481111- NACE Rev.2
51.10- GICS 2023
203020
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)
Airport traffic and revenue summary
Catalog key aviation.airport.traffic_revenue_summary
Fields
period_start_date- date
period_end_date- date
enplaned_passengers- string
passengers_enplaned_growth- string
aeronautical_revenue- decimal
commercial_revenue- decimal
total_revenue- decimal
Accounting Software
Catalog key aviation.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 aviation.core.financial_statements
Fields
date- date
statement_type- enum
period_start_date- date
period_end_date- date
HR records
Catalog key aviation.core.hr_records
Fields
date- date
headcount- decimal
Payroll records
Catalog key aviation.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
Airline operational statistics summary
Catalog key aviation.network_carrier.operational_statistics_summary
Fields
period_start_date- date
period_end_date- date
available_seat_kilometers- string
revenue_passenger_kilometers- decimal
revenue_capacity_units- decimal
available_capacity_units- string
total_operating_cost- decimal
total_operating_revenue- decimal
on_time_arrivals- string
total_arrivals- decimal
fuel_expense- string
cargo_tonne_km_carried- string
available_tonne_km- string
cargo_revenue- decimal
Travel distribution booking summary
Catalog key aviation.travel_distribution.booking_summary
Fields
period_start_date- date
period_end_date- date
platform_revenue- decimal
gross_booking_value- string
completed_bookings- string
qualified_sessions- string
Metrics (63)
- Cargo Load Factor
- Cargo Yield per Tonne-Kilometer
- Aeronautical Revenue per Passenger
- Commercial Revenue Share
- Passengers Enplaned Growth
- 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 per Available Seat Kilometer (CASM)
- Fuel Cost Percent of Operating Cost
- Load Factor
- On-Time Performance (OTP)
- Revenue per Available Seat Kilometer (RASM)
- Gross Booking Value Take Rate
- Look-to-Book Conversion
Cargo Load Factor
- ID: 1830
- Type: Operational
- Unit: %
- Description: Cargo tonnage carried relative to available cargo capacity (aggregated).
- Inputs:
cargo_tonne_km_carried,available_tonne_km - Methodology: Cargo Load Factor = (Cargo Tonne-Km Carried / Available Tonne-Km) × 100
- Calculation:
cargo_tonne_km_carried / available_tonne_km * 100 - Catalog key:
aviation.air_cargo.cargo_load_factor
Cargo Yield per Tonne-Kilometer
- ID: 1831
- Type: Financial
- Unit: Currency per tonne-km
- Description: Cargo revenue per tonne-kilometer carried (aggregated).
- Inputs:
cargo_revenue,cargo_tonne_km_carried - Methodology: Yield = Cargo Revenue / Cargo Tonne-Kilometers Carried
- Calculation:
cargo_revenue / cargo_tonne_km_carried - Catalog key:
aviation.air_cargo.cargo_yield_per_tonne_km
Aeronautical Revenue per Passenger
- ID: 1826
- Type: Financial
- Unit: Currency
- Description: Aeronautical charges divided by enplaned passengers (aggregated).
- Inputs:
aeronautical_revenue,enplaned_passengers - Methodology: ARPP = Aeronautical Revenue / Enplaned Passengers
- Calculation:
aeronautical_revenue / enplaned_passengers - Catalog key:
aviation.airport.aeronautical_revenue_per_passenger
Commercial Revenue Share
- ID: 1827
- Type: Financial
- Unit: %
- Description: Non-aeronautical revenue as a share of total airport revenue (aggregated).
- Inputs:
commercial_revenue,total_revenue - Methodology: Share = (Commercial Revenue / Total Revenue) × 100
- Calculation:
commercial_revenue / total_revenue * 100 - Catalog key:
aviation.airport.commercial_revenue_share
Passengers Enplaned Growth
- ID: 1825
- Type: Operational
- Unit: %
- Description: Year-over-year growth in enplaned passengers (aggregated).
- Methodology: Growth = ((Current Enplanements − Prior Enplanements) / Prior Enplanements) × 100
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
aviation.airport.passengers_enplaned_growth
Accounts Payable Days
- ID: 2846
- 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:
aviation.core.accounts_payable_days
Accounts Payable Turnover
- ID: 2845
- 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:
aviation.core.accounts_payable_turnover
Accounts Receivable Days
- ID: 2842
- 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:
aviation.core.accounts_receivable_days
Accounts Receivable Turnover
- ID: 2841
- 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:
aviation.core.accounts_receivable_turnover
Monthly Burn Rate
- ID: 1812
- 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:
aviation.core.burn_rate
Cash Days
- ID: 2840
- 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:
aviation.core.cash_days
Cash Turnover
- ID: 2839
- Type: Financial
- Unit: x
- Description: Revenue divided by cash
- Inputs:
revenue,cash - Methodology: Cash Turnover
- Calculation:
revenue / max(cash, 0) - Catalog key:
aviation.core.cash_turnover
Cash Conversion Cycle
- ID: 1810
- 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:
aviation.core.ccc
Current Ratio
- ID: 1800
- 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:
aviation.core.current_ratio
Debt to EBITDA
- ID: 2850
- 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:
aviation.core.debt_to_ebitda
Debt to Equity
- ID: 2848
- 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:
aviation.core.debt_to_equity
Debt to Tangible Net Worth
- ID: 2849
- 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:
aviation.core.debt_to_tangible_net_worth
EBITDA (derived)
- ID: 2822
- 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:
aviation.core.derived_ebitda
Effective Tax Rate
- ID: 2823
- 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:
aviation.core.derived_effective_tax_rate
Gross Profit (derived)
- ID: 2821
- 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:
aviation.core.derived_gross_profit
Invested Capital
- ID: 2826
- 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:
aviation.core.derived_invested_capital
Net Debt
- ID: 2825
- 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:
aviation.core.derived_net_debt
Net Operating Profit After Tax (NOPAT)
- ID: 2824
- 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:
aviation.core.derived_nopat
Quick Assets (strict)
- ID: 2828
- 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:
aviation.core.derived_quick_assets
Tangible Net Worth
- ID: 2827
- 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:
aviation.core.derived_tangible_net_worth
Days Payable Outstanding (DPO)
- ID: 1809
- 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:
aviation.core.dpo
Days Sales Outstanding (DSO)
- ID: 1808
- 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:
aviation.core.dso
EBIT to Interest
- ID: 2854
- 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:
aviation.core.ebit_to_interest
EBITDA Less Capex to Interest
- ID: 2855
- 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:
aviation.core.ebitda_less_capex_to_interest
EBITDA Margin
- ID: 1804
- 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:
aviation.core.ebitda_margin
EBITDA to Interest (Interest Coverage)
- ID: 2853
- 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:
aviation.core.ebitda_to_interest
Effective Interest Rate
- ID: 2834
- 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:
aviation.core.effective_interest_rate
Fixed Charge Coverage
- ID: 2856
- 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:
aviation.core.fixed_charge_coverage
Gross Profit Margin
- ID: 1802
- 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:
aviation.core.gross_margin
Headcount (FTE)
- ID: 1814
- 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:
aviation.core.headcount
Interest Burden
- ID: 2835
- 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:
aviation.core.interest_burden
Inventory Days
- ID: 2844
- 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:
aviation.core.inventory_days
Inventory Turnover (ending balance)
- ID: 2843
- 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:
aviation.core.inventory_turnover
Net Debt to EBITDA
- ID: 2851
- Type: Financial
- Unit: x
- Description: Net debt divided by EBITDA
- Methodology: Net Debt to EBITDA
- Calculation:
net_debt / max(ebitda_derived, 0) - Catalog key:
aviation.core.net_debt_to_ebitda
Net Profit Margin
- ID: 1805
- 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:
aviation.core.net_margin
Net Profit Margin (decimal quotient)
- ID: 2833
- 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:
aviation.core.net_profit_margin
Operating Cash Flow
- ID: 1811
- 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:
aviation.core.operating_cash_flow
Operating Margin (EBIT)
- ID: 1803
- 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:
aviation.core.operating_margin
Operating Profit Margin (EBIT)
- ID: 2832
- 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:
aviation.core.operating_profit_margin
PP&E Turnover
- ID: 2838
- 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:
aviation.core.ppe_turnover
Quick Ratio (Acid Test)
- ID: 1801
- 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:
aviation.core.quick_ratio
Quick Ratio (Quick Assets)
- ID: 2852
- 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:
aviation.core.quick_ratio_quick_assets
Return on Assets (ROA)
- ID: 2830
- 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:
aviation.core.return_on_assets
Return on Equity (ROE)
- ID: 2829
- 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:
aviation.core.return_on_equity
Return on Invested Capital (ROIC)
- ID: 2831
- Type: Financial
- Unit: %
- Description: NOPAT divided by invested capital
- Methodology: ROIC = NOPAT / (Net Debt + Equity)
- Calculation:
nopat / max(invested_capital, 0) - Catalog key:
aviation.core.return_on_invested_capital
Revenue Growth Rate
- ID: 1806
- 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:
aviation.core.revenue_growth
Cash Runway
- ID: 1813
- 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:
aviation.core.runway
Tax Burden
- ID: 2836
- 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:
aviation.core.tax_burden
Total Asset Turnover
- ID: 2837
- 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:
aviation.core.total_asset_turnover
Total Assets to Equity (Equity Multiplier)
- ID: 2847
- 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:
aviation.core.total_assets_to_equity
Working Capital
- ID: 1807
- 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:
aviation.core.working_capital
Cost per Available Seat Kilometer (CASM)
- ID: 1821
- Type: Financial
- Unit: Currency per ASK
- Description: Operating cost per unit of available seat capacity (aggregated).
- Inputs:
total_operating_cost,available_seat_kilometers - Methodology: CASM = Total Operating Cost / Available Seat Kilometers
- Calculation:
total_operating_cost / available_seat_kilometers - Catalog key:
aviation.network_carrier.casm
Fuel Cost Percent of Operating Cost
- ID: 1824
- Type: Financial
- Unit: %
- Description: Fuel expense as a share of total operating cost (aggregated).
- Inputs:
fuel_expense,total_operating_cost - Methodology: Fuel % = (Fuel Expense / Total Operating Cost) × 100
- Calculation:
fuel_expense / total_operating_cost * 100 - Catalog key:
aviation.network_carrier.fuel_cost_pct_operating
Load Factor
- ID: 1820
- Type: Operational
- Unit: %
- Description: Revenue passenger miles or cargo tonnage carried relative to available capacity (aggregated).
- Inputs:
revenue_capacity_units,available_capacity_units - Methodology: Load Factor = (RPM or RTM / ASM or ATM) × 100
- Calculation:
revenue_capacity_units / available_capacity_units * 100 - Catalog key:
aviation.network_carrier.load_factor
On-Time Performance (OTP)
- ID: 1823
- Type: Operational
- Unit: %
- Description: Share of flights arriving within regulatory on-time threshold (aggregated).
- Inputs:
on_time_arrivals,total_arrivals - Methodology: OTP = (On-Time Arrivals / Total Arrivals) × 100
- Calculation:
on_time_arrivals / total_arrivals * 100 - Catalog key:
aviation.network_carrier.on_time_performance
Revenue per Available Seat Kilometer (RASM)
- ID: 1822
- Type: Financial
- Unit: Currency per ASK
- Description: Operating revenue per unit of available seat capacity (aggregated).
- Inputs:
total_operating_revenue,available_seat_kilometers - Methodology: RASM = Total Operating Revenue / Available Seat Kilometers
- Calculation:
total_operating_revenue / available_seat_kilometers - Catalog key:
aviation.network_carrier.rasm
Gross Booking Value Take Rate
- ID: 1828
- Type: Financial
- Unit: %
- Description: Platform revenue as a share of gross bookings (aggregated).
- Inputs:
platform_revenue,gross_booking_value - Methodology: Take Rate = (Platform Revenue / Gross Booking Value) × 100
- Calculation:
platform_revenue / gross_booking_value * 100 - Catalog key:
aviation.travel_distribution.gbv_take_rate
Look-to-Book Conversion
- ID: 1829
- Type: Operational
- Unit: %
- Description: Share of travel searches or sessions that complete a booking (aggregated).
- Inputs:
completed_bookings,qualified_sessions - Methodology: Conversion = (Completed Bookings / Qualified Sessions) × 100
- Calculation:
completed_bookings / qualified_sessions * 100 - Catalog key:
aviation.travel_distribution.look_to_book_conversion
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
- Airport traffic and revenue summary — feeds Passengers Enplaned Growth, Aeronautical Revenue per Passenger, Commercial Revenue Share
- 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)
- Airline operational statistics summary — feeds Load Factor, Cost per Available Seat Kilometer (CASM), Revenue per Available Seat Kilometer (RASM), On-Time Performance (OTP), Fuel Cost Percent of Operating Cost, Cargo Load Factor, Cargo Yield per Tonne-Kilometer
- Travel distribution booking summary — feeds Gross Booking Value Take Rate, Look-to-Book Conversion
Further reading: Catalog consumption · Pipeline governance helpers
Generated from ambient-core ref cc3d169 (digest a0e8f2dc8aa708fd). Regenerate: npm run sync:catalog-wiki.