Sector Statistics Report

Executive Summary

Total Companies Analyzed

2

COUNT(DISTINCT symbol) WHERE sector = 'Real Estate'

Beat Estimates

0.0%

Percentage of companies exceeding estimates

Average QoQ Revenue Growth

+0.00%

AVG((current_revenue - prev_quarter_revenue) / prev_quarter_revenue * 100)

Average YoY Revenue Growth

+0.00%

AVG((current_revenue - prev_year_revenue) / prev_year_revenue * 100)

Average QoQ EPS Growth

+0.00%

AVG((current_eps - prev_quarter_eps) / ABS(prev_quarter_eps) * 100)

Average YoY EPS Growth

+0.00%

AVG((current_eps - prev_year_eps) / ABS(prev_year_eps) * 100)

Methodology

Data Collection Period

Data collected for fiscal quarters ending within the reporting period. Companies are matched by ticker symbol across time periods.

Growth Calculations

Quarter-over-Quarter (QoQ): Compares current quarter to previous quarter (2-5 months prior for flexibility)
Year-over-Year (YoY): Compares current quarter to same quarter last year (11-14 months prior)
Outlier Handling: Growth rates are capped at -100% to +200% to prevent extreme outliers from skewing averages
Minimum Revenue Threshold: Only companies with >$1M revenue in comparison period are included in growth calculations

Earnings Surprises

Beat: Actual EPS > Estimated EPS
Meet: Actual EPS = Estimated EPS
Miss: Actual EPS < Estimated EPS

Price Reaction

Stock price percentage change following earnings announcement (typically measured as close-to-close or intraday swing).

Detailed Company Data

The following table shows individual company data used in calculations. Total records: 2

Symbol	Company	Report Date	Revenue	Rev Growth %	EPS	EPS Est.	EPS Growth %	Surprise	Reaction %
CDR-PC	Cedar Realty Trust Inc	Aug 29, 2025	$0.01B	N/A	$-0.01	N/A	N/A	N/A	+3.0%
CDR-PB	Cedar Realty Trust Inc	Aug 29, 2025	$0.01B	N/A	$-0.01	N/A	N/A	N/A	+1.4%

SQL Query Reference

Main Statistics Query

SELECT
    e.symbol,
    e.revenue as current_revenue,
    e.eps as current_eps,

    -- Previous quarter (flexible 2-5 month lookback)
    (SELECT revenue FROM earningscalendar
     WHERE symbol = e.symbol
     AND fiscalDateEnding < e.fiscalDateEnding
     AND fiscalDateEnding >= DATE_SUB(e.fiscalDateEnding, INTERVAL 5 MONTH)
     ORDER BY fiscalDateEnding DESC LIMIT 1) as prev_quarter_revenue,

    -- Previous year (11-14 month lookback)
    (SELECT revenue FROM earningscalendar
     WHERE symbol = e.symbol
     AND fiscalDateEnding BETWEEN DATE_SUB(e.fiscalDateEnding, INTERVAL 14 MONTH)
         AND DATE_SUB(e.fiscalDateEnding, INTERVAL 11 MONTH)
     ORDER BY ABS(DATEDIFF(fiscalDateEnding, DATE_SUB(e.fiscalDateEnding, INTERVAL 1 YEAR)))
     LIMIT 1) as prev_year_revenue

FROM earningscalendar e
JOIN ticker t ON e.symbol = t.ticker
WHERE t.sector = 'Real Estate'
AND e.fiscalDateEnding IS NOT NULL
AND e.revenue > 1000000  -- Minimum revenue threshold