Skip to main content

Real Estate (commercial)

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

Workspace demo (screenshots) · Catalog consumption

Industry summary​

Industry code

ISIC Rev.4 6810

38 metrics · 23 data options

NAICS 2022
531120 (also 531390)
NACE Rev.2
68.10 (also 68.20)
GICS 2023
601020

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

Data options (23)​

Rental income records​

Catalog key 2j9pysT31hgn2DQcejtz

Fields

date
date
property_id
id
rent_collection_date
date
rent_amount
decimal
tenant_name
string
payment_method
enum
payment_status
enum
rental_income
string
operating_expenses
string
debt_service
string
property_price
decimal
gross_rental_income
string

Accounts payable aging​

Catalog key Allrealestateds-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 Allrealestateds-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 Allrealestateds-balance-sheet

Fields

date
date
period_end_date
date
inventory
string

Bank statements​

Catalog key Allrealestateds-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 Allrealestateds-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 Allrealestateds-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 Allrealestateds-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 Allrealestateds-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 Allrealestateds-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 Allrealestateds-trial-balance

Fields

date
date
account_code
id
account_name
decimal
debit_balance
string
credit_balance
string
period
enum

Energy bills​

Catalog key Grtv4vjRFWRmrDSFF8cS

Fields

date
date
property_id
id
bill_date
date
energy_consumed
string
energy_cost
decimal
total_energy_cost
decimal
rentable_square_feet
string
gross_rental_income
string
operating_expenses
string
property_value
string
provider_name
string

Mortgage documents​

Catalog key TPRNcAtqtiY387QTkah7

Fields

date
date
property_id
id
mortgage_lender
string
loan_amount
decimal
interest_rate
decimal
loan_term
string
monthly_payment
string
start_date
date
end_date
date

Property purchase records​

Catalog key UVuuRwg8ksAOiP3WlKKr

Fields

date
date
property_id
id
purchase_date
date
purchase_price
decimal
seller_name
string
property_location
string
property_type
enum
mortgage_details
string

Sale records​

Catalog key bs0gsbE2YDGDHyqRtkx8

Fields

date
date
property_id
id
sale_date
date
sale_price
decimal
buyer_name
string
property_location
string
property_type
enum
agent_details
string

Property management systems​

Catalog key gKEmKLl2XRjSbTQGztuy

Fields

date
date
property_id
id
tenant_name
string
lease_start_date
date
lease_end_date
date
monthly_rent
string
maintenance_records
string
payment_status
enum
same_store_noi_growth
string
operating_expenses
string
effective_gross_income
string
rentable_square_feet
string
gross_rental_income
string
vacant_units
string
total_units
decimal
total_energy_cost
decimal

Property valuation reports​

Catalog key jYYkOyU5EQfa40iMf9x8

Fields

date
date
property_id
id
valuation_date
date
valuation_amount
decimal
valuer_name
string
valuation_method
enum
property_location
string

Loan documents​

Catalog key ohvSqlJVvLde3k1gqYZh

Fields

date
date
property_id
id
lender_name
string
loan_amount
decimal
interest_rate
decimal
loan_term_months
decimal
maturity_date
date
outstanding_balance
decimal
annual_debt_service
string

Accounting Software​

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

Fields

date
date
statement_type
enum
period_start_date
date
period_end_date
date

HR records​

Catalog key real_estate.core.hr_records

Fields

date
date
headcount
decimal

Payroll records​

Catalog key real_estate.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

REIT supplemental reporting​

Catalog key real_estate.reit.reit_supplemental

Fields

date
date
trust_vehicle_id
id
vehicle_type
enum
funds_from_operations
decimal
ffo
string
distributions
string
current_noi
string
prior_noi
string
trust_assets_under_administration
decimal
trustee_fees
string
average_trust_aua
string

Metrics (38)​

Debt Service Coverage Ratio (DSCR)​

  • ID: 8
  • Type: Financial
  • Unit: Number
  • Description: Ratio of net operating income to annual debt payments.
  • Inputs: annual_debt_service
  • Methodology: DSCR = Net Operating Income / Annual Debt Service
  • Calculation: noi / annual_debt_service
  • Catalog key: 1cvcTcHNt1VYX867UUG7

Annual Recurring Revenue (ARR)​

  • ID: 1016
  • Type: Financial
  • Unit: Currency/year
  • Description: Annualized run-rate of recurring subscription revenue.
  • Methodology: ARR = MRR × 12
  • Calculation: mrr * 12
  • Catalog key: Allrealestatesaas-arr

Customer Acquisition Cost (CAC)​

  • ID: 1034
  • 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: Allrealestatesaas-cac

Gross Revenue Churn Rate​

  • ID: 1028
  • 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: Allrealestatesaas-gross-churn

Customer Lifetime Value (LTV)​

  • ID: 1040
  • 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: Allrealestatesaas-ltv

LTV : CAC Ratio​

  • ID: 1046
  • 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: Allrealestatesaas-ltv-cac

Monthly Recurring Revenue (MRR)​

  • ID: 1010
  • 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: Allrealestatesaas-mrr

Net Revenue Retention (NRR)​

  • ID: 1022
  • 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: Allrealestatesaas-nrr

Rule of 40​

  • ID: 1052
  • 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: Allrealestatesaas-rule-of-40

Vacancy Rate​

  • ID: 9
  • Type: Operational
  • Unit: %
  • Description: Percentage of rental units that are unoccupied.
  • Inputs: vacant_units, total_units
  • Methodology: Vacancy Rate = (Number of Vacant Units / Total Units) * 100
  • Calculation: vacant_units / total_units * 100
  • Catalog key: EDCn8khPJg44trzt4JTA

Loan-to-Value Ratio (LTV)​

  • ID: 7
  • Type: Financial
  • Unit: %
  • Description: Ratio of mortgage loan amount to the property's appraised value.
  • Inputs: mortgage_amount, appraised_value
  • Methodology: LTV = (Mortgage Amount / Property Appraised Value) * 100
  • Calculation: mortgage_amount / appraised_value * 100
  • Catalog key: Ob4nc825yNcKAA91kCua

Gross Rent Multiplier (GRM)​

  • ID: 6
  • Type: Financial
  • Unit: Number
  • Description: Property price divided by gross rental income, used for quick valuation.
  • Inputs: property_price, gross_rental_income
  • Methodology: GRM = Property Price / Gross Rental Income
  • Calculation: property_price / gross_rental_income
  • Catalog key: VLDD4ijNDixuJ7EDJtw3

Net Operating Income (NOI)​

  • ID: 2
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Income generated from a property after deducting operating expenses.
  • Inputs: gross_rental_income, operating_expenses
  • Methodology: NOI = Gross Rental Income - Operating Expenses
  • Calculation: gross_rental_income - operating_expenses
  • Catalog key: YsoV0l2DLsptgTldBESm

Return on Investment (ROI)​

  • ID: 1
  • Type: Financial
  • Unit: Percentage
  • Description: Percentage return on investment relative to its cost.
  • Inputs: net_profit, cost_of_investment
  • Methodology: ROI = ((Net Profit / Cost of Investment) * 100)
  • Calculation: net_profit / cost_of_investment * 100
  • Catalog key: o4HkbNgvPm6RAPEcAzHV

Cash Flow​

  • ID: 4
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Net income from a property after mortgage and operating expenses.
  • Inputs: rental_income, operating_expenses, debt_service
  • Methodology: Cash Flow = Rental Income - Operating Expenses - Debt Service
  • Calculation: rental_income - operating_expenses - debt_service
  • Catalog key: o5PSXR0Vw3Jy35QyRrJ8

Capitalization Rate (Cap Rate)​

  • ID: 3
  • Type: Financial
  • Unit: Percentage
  • Description: Ratio of NOI to property value, used to estimate potential return.
  • Inputs: property_value
  • Methodology: Cap Rate = (NOI / Property Value) * 100
  • Calculation: noi / property_value * 100
  • Catalog key: rbIvVbYWRuUUr4rzZGRH

Monthly Burn Rate​

  • ID: 998
  • 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: real_estate.core.burn_rate

Cash Conversion Cycle​

  • ID: 986
  • 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: real_estate.core.ccc

Current Ratio​

  • ID: 926
  • 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: real_estate.core.current_ratio

Days Payable Outstanding (DPO)​

  • ID: 980
  • 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: real_estate.core.dpo

Days Sales Outstanding (DSO)​

  • ID: 974
  • 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: real_estate.core.dso

EBITDA Margin​

  • ID: 950
  • 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: real_estate.core.ebitda_margin

Gross Profit Margin​

  • ID: 938
  • 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: real_estate.core.gross_margin

Headcount (FTE)​

  • ID: 1082
  • 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: real_estate.core.headcount

Net Profit Margin​

  • ID: 956
  • 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: real_estate.core.net_margin

Operating Cash Flow​

  • ID: 992
  • 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: real_estate.core.operating_cash_flow

Operating Margin (EBIT)​

  • ID: 944
  • 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: real_estate.core.operating_margin

Quick Ratio (Acid Test)​

  • ID: 932
  • 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: real_estate.core.quick_ratio

Revenue Growth Rate​

  • ID: 962
  • 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: real_estate.core.revenue_growth

Cash Runway​

  • ID: 1004
  • 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: real_estate.core.runway

Working Capital​

  • ID: 968
  • 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: real_estate.core.working_capital

Energy Cost per Square Foot​

  • ID: 1060
  • Type: Operational
  • Unit: Currency
  • Description: Energy spend per rentable square foot (aggregated portfolio).
  • Inputs: total_energy_cost, rentable_square_feet
  • Methodology: Energy Cost per SF = Total Energy Cost / Rentable Square Feet
  • Calculation: total_energy_cost / rentable_square_feet
  • Catalog key: real_estate.operations.energy_cost_per_sf

Operating Expense Ratio​

  • ID: 1059
  • Type: Financial
  • Unit: %
  • Description: Operating expenses relative to effective gross income (property operations).
  • Inputs: operating_expenses, effective_gross_income
  • Methodology: OER = (Operating Expenses / Effective Gross Income) × 100
  • Calculation: operating_expenses / effective_gross_income * 100
  • Catalog key: real_estate.operations.operating_expense_ratio

Same-Store NOI Growth​

  • ID: 1058
  • Type: Financial
  • Unit: %
  • Description: Year-over-year NOI growth on stabilized comparable properties (property-operator view).
  • Methodology: Same-Store NOI Growth = ((Current NOI − Prior NOI) / Prior NOI) × 100 on comparable set
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: real_estate.operations.same_store_noi_growth

FFO Payout Ratio​

  • ID: 1941
  • Type: Financial
  • Unit: %
  • Description: Distributions paid relative to FFO.
  • Inputs: distributions, ffo
  • Methodology: FFO Payout = (Distributions / FFO) × 100
  • Calculation: distributions / ffo * 100
  • Catalog key: real_estate.reit.ffo_payout_ratio

Funds From Operations​

  • ID: 1940
  • Type: Financial
  • Unit: Currency
  • Description: REIT FFO for the period (vehicle reporting, aggregated).
  • Methodology: FFO per NAREIT or trust reporting definition (directly reported aggregate).
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: real_estate.reit.funds_from_operations

REIT Same-Store NOI Growth​

  • ID: 1942
  • Type: Financial
  • Unit: %
  • Description: Year-over-year NOI growth on a same-store basis at the trust vehicle level.
  • Inputs: current_noi, prior_noi
  • Methodology: Same-Store NOI Growth = ((Current NOI − Prior NOI) / Prior NOI) × 100
  • Calculation: (current_noi - prior_noi) / prior_noi * 100
  • Catalog key: real_estate.reit.same_store_noi_growth

Cash-on-Cash Return​

  • ID: 5
  • Type: Financial
  • Unit: Percentage
  • Description: Annual return on invested cash.
  • Inputs: net_cash_flow, initial_cash_investment
  • Methodology: Cash-on-Cash Return = (Net Cash Flow / Initial Cash Investment) * 100
  • Calculation: net_cash_flow / initial_cash_investment * 100
  • Catalog key: wCpkOtGniudQu8pSh22k

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.