Revenue Comparison Methodology
Data sources, inflation adjustment, index construction, and comparability notes for the commercial revenue comparison presented in Downtown Vitality.
Purpose and Scope
The chart presents a real (inflation-adjusted) index of commercial sales activity for four geographic series from 2019 through 2024, with 2019 as the common baseline year. The goal is to enable meaningful comparison of commercial vitality trajectories across jurisdictions that differ in size, state, and data availability.
Four series are included:
- Niwot Local Improvement District (Niwot, CO) — the primary subject of this analysis
- Steamboat Springs Downtown district (Steamboat Springs, CO) — a Colorado home-rule comparator with dedicated downtown governance
- Fredericksburg, TX — a comparable Main Street tourism economy with municipal self-governance
- Galena, IL — a small Midwest heritage tourism town with statutory city governance
Why a Real Index Rather Than Nominal Revenue
Raw sales tax revenue figures are not directly comparable across jurisdictions for two reasons:
Different tax rates. Each jurisdiction applies a different city tax rate to taxable sales. Fredericksburg collects at 1.5%; Galena at 2.0%; Niwot LID at a special district rate. Nominal revenue totals are incommensurable across these.
Different base sizes. Galena is a town of ~3,200; Fredericksburg ~11,500; Steamboat ~13,000. Absolute revenue totals tell us nothing useful about commercial vitality relative to each jurisdiction's own trajectory.
The index approach solves both problems. By converting each series to a real index — each jurisdiction's own real revenue as a percentage of its own 2019 real baseline — we measure the trajectory of commercial activity relative to each community's starting point, stripping out both tax rate differences and absolute size differences.
Inflation Adjustment
All nominal revenue figures are deflated to 2019 real dollars using the CPI-U (Consumer Price Index for All Urban Consumers, U.S. city average, annual average), published by the U.S. Bureau of Labor Statistics.
Real Revenue (2019$) = Nominal Revenue × (CPI₂₀₁₉ ÷ CPIₜ)
Where CPI₂₀₁₉ = 255.7 (annual average, 2019) and CPIₜ is the annual average for the year in question.
| Year | CPI-U (Annual Avg) | Deflator (2019 base) | Cumulative Inflation vs. 2019 |
|---|---|---|---|
| 2016 | 240.0 | 1.066 | +6.6% in real terms since 2016 |
| 2017 | 245.1 | 1.044 | +4.4% |
| 2018 | 251.1 | 1.018 | +1.8% |
| 2019 | 255.7 | 1.000 | Baseline |
| 2020 | 258.8 | 0.988 | −1.2% |
| 2021 | 271.0 | 0.944 | −5.6% |
| 2022 | 292.7 | 0.874 | −12.6% |
| 2023 | 304.7 | 0.839 | −16.1% |
| 2024 | 314.2 | 0.813 | −18.7% |
Source: U.S. Bureau of Labor Statistics, CPI-U Series CUSR0000SA0. Annual averages.
The deflator column is the multiplier applied to each year's nominal revenue. A deflator above 1.0 means nominal dollars in that year were worth more than 2019 dollars; below 1.0 means they were worth less. The cumulative effect is significant: a dollar of revenue in 2024 was worth only 81 cents in 2019 terms. Ignoring this inflation would make 2021-2024 gains appear larger than they actually were.
Index Construction and Baseline Year
The index is constructed by setting each series' real 2019 revenue equal to 100 and expressing all other years as a percentage of that baseline.
Why 2019?
- Last pre-COVID year. 2020 was severely disrupted across all series. Using 2019 creates a clean pre-disruption baseline that reflects normal operating conditions.
- Post-Wayfair comparability. The Supreme Court's Wayfair decision (June 2018) restructured online sales tax collection. Colorado adopted economic nexus effective June 1, 2019. Using 2019 as the base year means the Wayfair effect is already embedded in every Colorado series' baseline.
- Cross-series availability. 2019 is the earliest year for which all four series have confirmed data.
An index value of 100 means a jurisdiction's real commercial activity exactly matched its 2019 level. An index of 122 means real activity was 22% higher. An index of 98 means it fell 2% below. The index does not measure absolute commercial scale — it measures each community's trajectory relative to its own starting point.
The Wayfair Decision and Online Sales
South Dakota v. Wayfair, Inc. (June 2018) overturned the prior physical-presence rule for sales tax collection, permitting states to impose economic nexus requirements on out-of-state sellers. The practical effect was to bring previously untaxed online purchases into city and state sales tax bases, creating a structural upward shift unrelated to changes in physical commercial activity.
The states represented in this chart adopted economic nexus on different schedules:
| State | Economic Nexus Effective | Series Affected | Wayfair in 2019 Baseline? |
|---|---|---|---|
| Colorado | June 1, 2019 | Niwot, Steamboat | Partial (H2 2019 only) |
| Texas | October 1, 2019 | Fredericksburg | Partial (Q4 2019 only) |
| Illinois | January 1, 2021 | Galena | No — enters in 2021 |
Niwot LID
The Niwot LID collects a special district levy on taxable retail sales within the Niwot Rural Community District. CDOR administers collection and distributes revenue to the LID. Online purchases delivered to Niwot addresses contribute to the LID distribution. Because Colorado's economic nexus began June 1, 2019, the 2019 baseline includes approximately six months of Wayfair-attributable revenue. All subsequent years are fully post-Wayfair. The comparison is clean across 2019-2024.
Steamboat Springs Downtown
Steamboat Springs is a home-rule city that self-collects its sales tax. Revenue is tracked by geographic district. Online sales are allocated by the address of the purchaser. Because the city is a tourism destination, in-person spending dominates downtown receipts. Colorado's June 2019 timing applies. No adjustment was made.
Fredericksburg, TX
Texas adopted economic nexus effective October 1, 2019. The 2019 baseline therefore includes only one quarter of Wayfair revenue. This creates a modest structural step-up between 2019 and 2020. However, Fredericksburg's economy is dominated by tourism hospitality — restaurants, tasting rooms, hotels, and in-person retail — with no large-format retail corridors that generate significant online-sales-tax allocation. No adjustment was made, but the small Wayfair step-up in 2020 should be understood as a minor baseline artifact.
Galena, IL
Illinois adopted economic nexus effective January 1, 2021. This is the most significant Wayfair timing issue in the dataset. Galena's 2021 index of 130 includes both COVID recovery and the initial full-year Wayfair uplift. To assess the magnitude: if online sales represent approximately 5% of Galena's 2021 total collections — a generous assumption for a small in-person tourism town — the Wayfair-attributable increment would be approximately $120,000. Removing that, Galena's 2021 real index falls from 130 to approximately 125. Even under this conservative adjustment, Galena sustained a 25-point real gain over baseline by 2021, a gain that held through 2024. The core finding is robust to Wayfair correction.
COVID-19 and the 2020 Anomaly
All four series show disruption in 2020. The magnitude varies:
| Series | 2020 Real Index | Character of Impact |
|---|---|---|
| Niwot LID | 102 | Minimal decline; neighborhood retail and services held |
| Steamboat Springs | 96 | Modest decline; outdoor tourism recovered quickly |
| Fredericksburg TX | 99 | Minimal; Texas restrictions lighter and shorter-lived |
| Galena IL | 90 | Moderate; Illinois had stricter and longer-lasting closures |
We do not exclude 2020 from the chart. The COVID period is analytically important: it demonstrates each jurisdiction's resilience and recovery trajectory. The post-COVID recovery divergence — where incorporated communities sustained gains while Niwot did not — is the core finding. Excluding 2020 would obscure the setup for that finding.
Galena's 2021 rebound (index 130) should be interpreted partly as COVID catch-up from a deeper trough.
Raw Data by Series
Niwot LID
Source: Boulder County / CDOR annual LID tax distribution records. Figures reflect post-redistribution amounts. One methodological adjustment: $14,000 recorded in 2025 represents a bulk back-payment by a business that had failed to remit sales tax for multiple prior years. This was redistributed as approximately $2,800 per year to 2020-2024 to align revenue with the period in which the underlying sales occurred.
| Year | Nominal Revenue | CPI-U | Deflator | Real 2019$ | Index |
|---|---|---|---|---|---|
| 2016 | $168,337 | 240.0 | 1.066 | $179,428 | 85.6 |
| 2017 | $180,721 | 245.1 | 1.044 | $188,593 | 90.0 |
| 2018 | $186,642 | 251.1 | 1.018 | $189,911 | 90.7 |
| 2019 | $209,466 | 255.7 | 1.000 | $209,466 | 100.0 |
| 2020 | $216,135 | 258.8 | 0.988 | $213,581 | 101.9 |
| 2021 | $272,086 | 271.0 | 0.944 | $256,817 | 122.6 |
| 2022 | $295,031 | 292.7 | 0.874 | $257,777 | 123.0 |
| 2023 | $276,547 | 304.7 | 0.839 | $232,042 | 110.8 |
| 2024 | $252,477 | 314.2 | 0.813 | $205,400 | 98.1 |
Steamboat Springs Downtown
Source: City of Steamboat Springs municipal tax reports. 2024 figures confirmed directly from published district reports. Years 2016-2023 derived by applying the confirmed downtown-to-city-total ratio (16.63%) to published annual city totals.
| Year | Downtown Revenue | CPI-U | Deflator | Real 2019$ | Index |
|---|---|---|---|---|---|
| 2016 | $3,901,458* | 240.0 | 1.066 | $4,157,954 | 88.9 |
| 2017 | $4,047,042* | 245.1 | 1.044 | $4,225,300 | 90.4 |
| 2018 | $4,314,585* | 251.1 | 1.018 | $4,392,247 | 94.0 |
| 2019 | $4,672,300* | 255.7 | 1.000 | $4,672,300 | 100.0 |
| 2020 | $4,628,529* | 258.8 | 0.988 | $4,573,387 | 97.9 |
| 2021 | $5,748,291* | 271.0 | 0.944 | $5,426,387 | 116.1 |
| 2022 | $6,743,535* | 292.7 | 0.874 | $5,894,131 | 126.1 |
| 2023 | $6,872,229* | 304.7 | 0.839 | $5,766,400 | 123.4 |
| 2024 | $7,010,250 | 314.2 | 0.813 | $5,699,333 | 122.1 |
* Years 2016-2023 derived by applying 16.63% ratio to confirmed annual city totals. Direct downtown data confirmed for 2024.
Fredericksburg, TX
Source: Texas Comptroller of Public Accounts, Local Sales Tax Allocation History. City tax rate: 1.5%. City-wide data used; justified by the absence of big-box or highway retail corridors.
| Year | City Sales Tax | CPI-U | Deflator | Real 2019$ | Index |
|---|---|---|---|---|---|
| 2019 | $6,152,318 | 255.7 | 1.000 | $6,152,318 | 100.0 |
| 2020 | $6,207,762 | 258.8 | 0.988 | $6,135,067 | 98.7 |
| 2021 | $7,871,869 | 271.0 | 0.944 | $7,430,804 | 120.2 |
| 2022 | $8,608,171 | 292.7 | 0.874 | $7,523,741 | 121.2 |
| 2023 | $8,914,085 | 304.7 | 0.839 | $7,479,513 | 120.3 |
| 2024 | $9,265,996 | 314.2 | 0.813 | $7,533,354 | 120.9 |
Texas economic nexus effective October 1, 2019. A minor Wayfair step-up between 2019 and 2020 is present.
Galena, IL
Source: City of Galena monthly financial reports. City collects a 2.0% total sales tax. 2024 annual figure estimated from confirmed monthly data plus seasonal projection.
| Year | Annual Collections | CPI-U | Deflator | Real 2019$ | Index |
|---|---|---|---|---|---|
| 2018 | $2,177,489 | 251.1 | 1.018 | $2,216,664 | 99.9 |
| 2019 | $2,218,681 | 255.7 | 1.000 | $2,218,681 | 100.0 |
| 2020 | $2,011,941 | 258.8 | 0.988 | $1,987,798 | 89.6 |
| 2021 | $3,066,034 | 271.0 | 0.944 | $2,893,376 | 130.4 |
| 2022 | $3,208,000 | 292.7 | 0.874 | $2,803,792 | 126.3 |
| 2023 | $3,255,611 | 304.7 | 0.839 | $2,731,458 | 123.1 |
| 2024 | ~$3,340,000 | 314.2 | 0.813 | ~$2,715,420 | ~122.5 |
Illinois economic nexus effective January 1, 2021. Wayfair uplift estimated at ≤$120,000 of the 2021 gain; adjusted index would be approximately 125.3.
Comparability Cautions
Different tax bases. Each jurisdiction defines "taxable sales" according to its own state's rules. Colorado, Texas, and Illinois have different exemptions (notably food and groceries). This creates minor systematic differences in what the index captures.
Geographic definitions. "Downtown" means different things in different places. Niwot's LID boundary, Steamboat's downtown district, Fredericksburg's city limits, and Galena's city limits all represent different geographic scopes. The index measures trajectory within each definition, not comparability of scope.
Steamboat derivation method. For 2016-2023, Steamboat downtown revenue is derived from the 16.63% ratio rather than confirmed district data. If the downtown share of city total shifted significantly in earlier years, the derived figures may be imprecise. We consider this unlikely given Steamboat's stable commercial geography, but flag it for full transparency.
A Note on the Core Argument
The comparison data is illustrative context. The core evidentiary claim — that Niwot's commercial revenues have declined in real terms since 2021 and returned to their pre-pandemic baseline by 2024 — rests entirely on the Niwot LID's own primary-source revenue records, which are not dependent on any comparison methodology. Even absent all comparison series, the trend is documented and verifiable on its own terms.
Sources
- U.S. Bureau of Labor Statistics, CPI-U Series CUSR0000SA0
- Boulder County / CDOR, Niwot LID annual tax distribution records
- City of Steamboat Springs, Municipal Tax reports — steamboatsprings.net
- Texas Comptroller of Public Accounts, Local Sales Tax Allocation History
- City of Galena IL, monthly financial reports — cityofgalena.org
- PLAN-Boulder County, Boulder sales tax data — planboulder.org
- Colorado Department of Revenue, retail sales reports — cdor.colorado.gov