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​

  • Rental income records (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 (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 (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 (Allrealestateds-balance-sheet) — fields: date (date), period_end_date (date), inventory (string)
  • Bank statements (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)…
  • CRM / Sales pipeline (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 (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 (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 (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 (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)…
  • Trial balance (Allrealestateds-trial-balance) — fields: date (date), account_code (id), account_name (decimal), debit_balance (string), credit_balance (string), period (enum)
  • Energy bills (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 (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 (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 (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 (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)…
  • Property valuation reports (jYYkOyU5EQfa40iMf9x8) — fields: date (date), property_id (id), valuation_date (date), valuation_amount (decimal), valuer_name (string), valuation_method (enum), property_location (string)
  • Loan documents (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 (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 (real_estate.core.financial_statements) — fields: date (date), statement_type (enum), period_start_date (date), period_end_date (date)
  • HR records (real_estate.core.hr_records) — fields: date (date), headcount (decimal)
  • Payroll records (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)…
  • REIT supplemental reporting (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)​

  • Catalog key: 1cvcTcHNt1VYX867UUG7
  • ID: 8
  • Type: Financial
  • Unit: Number
  • Segment: financial
  • Methodology: DSCR = Net Operating Income / Annual Debt Service
  • Calculation: noi / annual_debt_service — inputs: annual_debt_service

Ratio of net operating income to annual debt payments.

FP&A workflow: Liquidity & covenant review — lender DSCR tests and monthly board liquidity pack.

Annual Recurring Revenue (ARR)​

  • Catalog key: Allrealestatesaas-arr
  • ID: 1016
  • Type: Financial
  • Unit: Currency/year
  • Segment: subscription
  • Methodology: ARR = MRR × 12
  • Calculation: mrr * 12

Annualized run-rate of recurring subscription revenue.

FP&A workflow: Annual planning & valuation — the headline scale metric for SaaS boards and investors.

Customer Acquisition Cost (CAC)​

  • Catalog key: Allrealestatesaas-cac
  • ID: 1034
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: subscription
  • Methodology: CAC = Total Sales & Marketing Spend / New Customers Acquired
  • Calculation: sales_marketing_spend / new_customers — inputs: sales_marketing_spend, new_customers

Fully-loaded sales & marketing cost to acquire one new customer.

FP&A workflow: Go-to-market efficiency — feeds CAC payback and the marketing budget allocation.

Gross Revenue Churn Rate​

  • Catalog key: Allrealestatesaas-gross-churn
  • ID: 1028
  • Type: Operational
  • Unit: %
  • Segment: subscription
  • Methodology: Gross Churn = (Churned MRR / Starting MRR) × 100
  • Calculation: churned_mrr / starting_mrr * 100 — inputs: churned_mrr, starting_mrr

Percentage of recurring revenue lost to cancellations and downgrades.

FP&A workflow: Retention review — informs the renewal forecast and customer-success investment case.

Customer Lifetime Value (LTV)​

  • Catalog key: Allrealestatesaas-ltv
  • ID: 1040
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: subscription
  • Methodology: LTV = (Average Revenue per Account × Gross Margin %) / Churn Rate
  • Calculation: (avg_revenue_per_account * gross_margin_pct / 100) / churn_rate — inputs: avg_revenue_per_account, gross_margin_pct, churn_rate

Expected gross-margin revenue from a customer over their lifetime.

FP&A workflow: Unit-economics modeling — combined with CAC to gate growth-spend decisions.

LTV : CAC Ratio​

  • Catalog key: Allrealestatesaas-ltv-cac
  • ID: 1046
  • Type: Financial
  • Unit: Ratio
  • Segment: subscription
  • Methodology: LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost
  • Calculation: ltv / cac

Ratio of customer lifetime value to acquisition cost — core SaaS unit economics.

FP&A workflow: Investment efficiency — a board-level guardrail (target ≥ 3:1) for scaling spend.

Monthly Recurring Revenue (MRR)​

  • Catalog key: Allrealestatesaas-mrr
  • ID: 1010
  • Type: Financial
  • Unit: Currency/month
  • Segment: subscription
  • Methodology: MRR = Σ (Active Subscriptions × Monthly Subscription Price)
  • Calculation: active_subscriptions * avg_monthly_price — inputs: active_subscriptions, avg_monthly_price

Normalized recurring subscription revenue billed in a month.

FP&A workflow: Recurring-revenue forecast — the foundation of the SaaS operating model and ARR bridge.

Net Revenue Retention (NRR)​

  • Catalog key: Allrealestatesaas-nrr
  • ID: 1022
  • Type: Financial
  • Unit: %
  • Segment: subscription
  • Methodology: NRR = ((Starting MRR + Expansion − Contraction − Churn) / Starting MRR) × 100
  • Calculation: (starting_mrr + expansion_mrr - contraction_mrr - churned_mrr) / starting_mrr * 100 — inputs: starting_mrr, expansion_mrr, contraction_mrr, churned_mrr

Revenue retained and expanded from existing customers, net of churn and contraction.

FP&A workflow: Expansion & retention modeling — the strongest signal of durable SaaS growth quality.

Rule of 40​

  • Catalog key: Allrealestatesaas-rule-of-40
  • ID: 1052
  • Type: Financial
  • Unit: %
  • Segment: subscription
  • Methodology: Rule of 40 = Revenue Growth % + Profit Margin %
  • Calculation: revenue_growth_pct + profit_margin_pct — inputs: revenue_growth_pct, profit_margin_pct

Balance of growth and profitability for recurring-revenue businesses.

FP&A workflow: Growth-vs-profitability review — a single composite health score for SaaS planning.

Vacancy Rate​

  • Catalog key: EDCn8khPJg44trzt4JTA
  • ID: 9
  • Type: Operational
  • Unit: %
  • Segment: operations
  • Methodology: Vacancy Rate = (Number of Vacant Units / Total Units) * 100
  • Calculation: vacant_units / total_units * 100 — inputs: vacant_units, total_units

Percentage of rental units that are unoccupied.

Loan-to-Value Ratio (LTV)​

  • Catalog key: Ob4nc825yNcKAA91kCua
  • ID: 7
  • Type: Financial
  • Unit: %
  • Segment: financial
  • Methodology: LTV = (Mortgage Amount / Property Appraised Value) * 100
  • Calculation: mortgage_amount / appraised_value * 100 — inputs: mortgage_amount, appraised_value

Ratio of mortgage loan amount to the property's appraised value.

Gross Rent Multiplier (GRM)​

  • Catalog key: VLDD4ijNDixuJ7EDJtw3
  • ID: 6
  • Type: Financial
  • Unit: Number
  • Segment: financial
  • Methodology: GRM = Property Price / Gross Rental Income
  • Calculation: property_price / gross_rental_income — inputs: property_price, gross_rental_income

Property price divided by gross rental income, used for quick valuation.

Net Operating Income (NOI)​

  • Catalog key: YsoV0l2DLsptgTldBESm
  • ID: 2
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: financial
  • Methodology: NOI = Gross Rental Income - Operating Expenses
  • Calculation: gross_rental_income - operating_expenses — inputs: gross_rental_income, operating_expenses

Income generated from a property after deducting operating expenses.

Return on Investment (ROI)​

  • Catalog key: o4HkbNgvPm6RAPEcAzHV
  • ID: 1
  • Type: Financial
  • Unit: Percentage
  • Segment: financial
  • Methodology: ROI = ((Net Profit / Cost of Investment) * 100)
  • Calculation: net_profit / cost_of_investment * 100 — inputs: net_profit, cost_of_investment

Percentage return on investment relative to its cost.

Cash Flow​

  • Catalog key: o5PSXR0Vw3Jy35QyRrJ8
  • ID: 4
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: financial
  • Methodology: Cash Flow = Rental Income - Operating Expenses - Debt Service
  • Calculation: rental_income - operating_expenses - debt_service — inputs: rental_income, operating_expenses, debt_service

Net income from a property after mortgage and operating expenses.

Capitalization Rate (Cap Rate)​

  • Catalog key: rbIvVbYWRuUUr4rzZGRH
  • ID: 3
  • Type: Financial
  • Unit: Percentage
  • Segment: financial
  • Methodology: Cap Rate = (NOI / Property Value) * 100
  • Calculation: noi / property_value * 100 — inputs: property_value

Ratio of NOI to property value, used to estimate potential return.

FP&A workflow: Valuation & lender reporting — yield sensitivity for divestiture and acquisition cases.

Monthly Burn Rate​

  • Catalog key: real_estate.core.burn_rate
  • ID: 998
  • Type: Financial
  • Unit: Currency/month
  • Segment: core
  • Methodology: Net Burn = Cash Out − Cash In (per month)
  • Calculation: cash_out - cash_in — inputs: cash_out, cash_in

Net cash consumed per month (negative net operating cash flow).

FP&A workflow: Runway management — paired with cash balance to govern the spend plan and fundraising timing.

Cash Conversion Cycle​

  • Catalog key: real_estate.core.ccc
  • ID: 986
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: CCC = DSO + Days Inventory Outstanding − DPO
  • Calculation: dso + days_inventory_outstanding - dpo — inputs: days_inventory_outstanding

Days to convert investments in inventory and receivables back into cash.

FP&A workflow: Cash-efficiency program — a north-star working-capital KPI tracked in the treasury review.

Current Ratio​

  • Catalog key: real_estate.core.current_ratio
  • ID: 926
  • Type: Financial
  • Unit: Ratio
  • Segment: core
  • Methodology: Current Ratio = Current Assets / Current Liabilities
  • Calculation: current_assets / current_liabilities — inputs: current_assets, current_liabilities

Short-term liquidity: ability to cover current liabilities with current assets.

FP&A workflow: Liquidity & solvency review — feeds covenant monitoring and the monthly board liquidity pack.

Days Payable Outstanding (DPO)​

  • Catalog key: real_estate.core.dpo
  • ID: 980
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: DPO = (Accounts Payable / COGS) × Number of Days
  • Calculation: accounts_payable / cogs * days — inputs: accounts_payable, cogs, days

Average number of days the business takes to pay its suppliers.

FP&A workflow: Payables optimization — balances supplier terms against the cash-conversion cycle.

Days Sales Outstanding (DSO)​

  • Catalog key: real_estate.core.dso
  • ID: 974
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
  • Calculation: accounts_receivable / total_credit_sales * days — inputs: accounts_receivable, total_credit_sales, days

Average number of days to collect cash after a sale.

FP&A workflow: Receivables & collections review — directly improves the cash-conversion cycle and forecast accuracy.

EBITDA Margin​

  • Catalog key: real_estate.core.ebitda_margin
  • ID: 950
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
  • Calculation: ebitda / revenue * 100 — inputs: ebitda, revenue

Core operating cash profitability before interest, tax, depreciation and amortization.

FP&A workflow: Valuation & lender reporting — primary profitability proxy in models and covenant tests.

Gross Profit Margin​

  • Catalog key: real_estate.core.gross_margin
  • ID: 938
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
  • Calculation: (revenue - cogs) / revenue * 100 — inputs: revenue, cogs

Share of revenue retained after the direct cost of goods sold.

FP&A workflow: Unit-economics and pricing review — anchors contribution-margin and budget-vs-actual analysis.

Headcount (FTE)​

  • Catalog key: real_estate.core.headcount
  • ID: 1082
  • Type: Operational
  • Unit: Count
  • Segment: core
  • 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.

Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.

Net Profit Margin​

  • Catalog key: real_estate.core.net_margin
  • ID: 956
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Net Profit Margin = (Net Income / Revenue) × 100
  • Calculation: net_income / revenue * 100 — inputs: net_income, revenue

Bottom-line profitability after all costs, interest and tax.

FP&A workflow: Board P&L reporting — the headline profitability line for the monthly close pack.

Operating Cash Flow​

  • Catalog key: real_estate.core.operating_cash_flow
  • ID: 992
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: core
  • Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
  • Calculation: net_income + non_cash_charges - increase_in_working_capital — inputs: net_income, non_cash_charges, increase_in_working_capital

Cash generated by core operations during the period.

FP&A workflow: Cash-flow forecasting — the anchor of the direct/indirect cash-flow statement.

Operating Margin (EBIT)​

  • Catalog key: real_estate.core.operating_margin
  • ID: 944
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Operating Margin = (Operating Income / Revenue) × 100
  • Calculation: operating_income / revenue * 100 — inputs: operating_income, revenue

Operating profitability after operating expenses (EBIT margin).

FP&A workflow: Opex efficiency review — drives the monthly variance bridge and cost-control actions.

Quick Ratio (Acid Test)​

  • Catalog key: real_estate.core.quick_ratio
  • ID: 932
  • Type: Financial
  • Unit: Ratio
  • Segment: core
  • Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
  • Calculation: (current_assets - inventory) / current_liabilities — inputs: current_assets, inventory, current_liabilities

Acid-test liquidity excluding inventory — most conservative short-term solvency view.

FP&A workflow: Liquidity stress testing — pairs with cash-flow forecasting for downside scenarios.

Revenue Growth Rate​

  • Catalog key: real_estate.core.revenue_growth
  • ID: 962
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
  • Calculation: (revenue - revenue_prior) / revenue_prior * 100 — inputs: revenue, revenue_prior

Period-over-period revenue growth rate.

FP&A workflow: Growth planning — drives top-line forecast, hiring plan and the rolling re-forecast.

Cash Runway​

  • Catalog key: real_estate.core.runway
  • ID: 1004
  • Type: Financial
  • Unit: Months
  • Segment: core
  • Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
  • Calculation: current_cash_balance / burn_rate — inputs: current_cash_balance

Number of months of cash remaining at the current net burn rate.

FP&A workflow: Board & investor reporting — the survival metric that gates hiring and spend decisions.

Working Capital​

  • Catalog key: real_estate.core.working_capital
  • ID: 968
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: core
  • Methodology: Working Capital = Current Assets − Current Liabilities
  • Calculation: current_assets - current_liabilities — inputs: current_assets, current_liabilities

Operating liquidity available to fund day-to-day operations.

FP&A workflow: Working-capital management — feeds the 13-week cash forecast and treasury planning.

Energy Cost per Square Foot​

  • Catalog key: real_estate.operations.energy_cost_per_sf
  • ID: 1060
  • Type: Operational
  • Unit: Currency
  • Segment: operations
  • Methodology: Energy Cost per SF = Total Energy Cost / Rentable Square Feet
  • Calculation: total_energy_cost / rentable_square_feet — inputs: total_energy_cost, rentable_square_feet

Energy spend per rentable square foot (aggregated portfolio).

FP&A workflow: Sustainability and opex — efficiency programs and capex planning.

Operating Expense Ratio​

  • Catalog key: real_estate.operations.operating_expense_ratio
  • ID: 1059
  • Type: Financial
  • Unit: %
  • Segment: operations
  • Methodology: OER = (Operating Expenses / Effective Gross Income) × 100
  • Calculation: operating_expenses / effective_gross_income * 100 — inputs: operating_expenses, effective_gross_income

Operating expenses relative to effective gross income (property operations).

FP&A workflow: Cost discipline — opex leakage vs revenue.

Same-Store NOI Growth​

  • Catalog key: real_estate.operations.same_store_noi_growth
  • ID: 1058
  • Type: Financial
  • Unit: %
  • Segment: operations
  • Methodology: Same-Store NOI Growth = ((Current NOI − Prior NOI) / Prior NOI) × 100 on comparable set
  • Calculation: No machine-readable calc — directly reported or qualitative.

Year-over-year NOI growth on stabilized comparable properties (property-operator view).

FP&A workflow: Operating performance — excludes acquisition/disposition noise.

FFO Payout Ratio​

  • Catalog key: real_estate.reit.ffo_payout_ratio
  • ID: 1941
  • Type: Financial
  • Unit: %
  • Segment: reit
  • Methodology: FFO Payout = (Distributions / FFO) × 100
  • Calculation: distributions / ffo * 100 — inputs: distributions, ffo

Distributions paid relative to FFO.

FP&A workflow: Distribution safety — retained cash for growth and debt service.

Funds From Operations​

  • Catalog key: real_estate.reit.funds_from_operations
  • ID: 1940
  • Type: Financial
  • Unit: Currency
  • Segment: reit
  • Methodology: FFO per NAREIT or trust reporting definition (directly reported aggregate).
  • Calculation: No machine-readable calc — directly reported or qualitative.

REIT FFO for the period (vehicle reporting, aggregated).

FP&A workflow: Trust earnings — dividend coverage for vehicle investors.

REIT Same-Store NOI Growth​

  • Catalog key: real_estate.reit.same_store_noi_growth
  • ID: 1942
  • Type: Financial
  • Unit: %
  • Segment: reit
  • Methodology: Same-Store NOI Growth = ((Current NOI − Prior NOI) / Prior NOI) × 100
  • Calculation: (current_noi - prior_noi) / prior_noi * 100 — inputs: current_noi, prior_noi

Year-over-year NOI growth on a same-store basis at the trust vehicle level.

FP&A workflow: Vehicle organic performance — excludes acquisition noise (property ops on Real Estate orgs).

Cash-on-Cash Return​

  • Catalog key: wCpkOtGniudQu8pSh22k
  • ID: 5
  • Type: Financial
  • Unit: Percentage
  • Segment: financial
  • Methodology: Cash-on-Cash Return = (Net Cash Flow / Initial Cash Investment) * 100
  • Calculation: net_cash_flow / initial_cash_investment * 100 — inputs: net_cash_flow, initial_cash_investment

Annual return on invested cash.

Generated from ambient-core ref 10fb050 (digest 890f3d2011311128). Regenerate: npm run sync:catalog-wiki.