Town of Niwot — Pro Forma Budget & Financial Assumptions

Prepared by the Niwot Incorporation Committee

Version 1.5 — July 1, 2026
All figures shown in nominal dollars ($000s)

Revision history

Version	Date	Summary of Changes
1.0	February 18, 2026	Initial release.
1.1	February 20, 2026	Added Appendix C: Remote/Online Sales Tax Benchmark Analysis.
1.2	February 27, 2026	Updated budget tables to reflect revised Sheriff and debt service figures; renamed Planning Department to Building Department with SAFEbuilt 85/15 fee structure; updated road debt service schedule (begins April 2029, amortizing per Piper Sandler scenario); clarified Sheriff escalation methodology (4% to first full year, 3% thereafter); added LID pre-allocation note for Events; updated sensitivity analysis and Monte Carlo.
1.3	March 5, 2026	Added Business Personal Property (~$13.1M) to assessed value base; updated office space to $27/sf; expanded R7 (SOT) with dual-method vehicle count derivation and fleet-age blending; expanded Appendix C with benchmark selection rationale, updated ACS 2024 income figures, and apples-to-apples methodology note; moved bond repayment to top of Expenses (first-priority obligation); reduced repetitive discretionary-program language; recalculated break-even sensitivity and Monte Carlo to reflect updated baseline.
1.4	May 26, 2026	Added Appendix D: Peer General Fund Benchmark — per-resident GF revenue and net-of-public-safety comparison against four Front Range peer towns (Eaton, Berthoud, Firestone, Lyons), with Niwot's 2029 modeled figures deflated to 2024 dollars using the pro forma's own escalation rates to align with peer fiscal year. Includes chart, data table, methodology notes, and sourced links to each peer's ACFR/budget. Collapsed the revision history for readability.
1.5	July 1, 2026	Two-part restructure. Roads presentation: Consolidated all road-related expenses into a single Roads Expenses section following collaboration with the Niwot Community Association. Reclassified snow removal, street sweeping, and traffic devices from Operating Expenses into Roads Expenses. Renamed “Public Works — Parks, Trees, Landscaping” to “Public Works — Trees, Landscaping” (parks maintenance is expected to remain with Boulder County). Added “Ongoing Maintenance, including reserves for future projects” as an explicit Roads Expenses line. Added road bond proceeds ($16M in 2029) as a distinct revenue line, offset by the $15.725M deferred-repairs capital outlay. Contingency accounting: Applied GFOA-consistent contingency-as-reserve treatment across both operating and roads sections: budgeted contingency (15% of core opex; 15% of snow + signs base) is retained, but only the expected-use portion (~45%) is treated as recurring expenditure. Broke out the previously-embedded 15% roads contingency into its own line for consistency. The unused contingency capacity (~55%) accumulates in fund balance per municipal best practice. Combined effect: 2040 cumulative reserves ~$6.85M (vs. ~$15M under v1.3–v1.4 accounting and ~$4.5M under naive fully-expensed contingency); Monte Carlo stress test rerun against the updated model shows structural durability with ~3.4% probability of dipping into negative reserves under adverse conditions.

This pro forma does not represent a legally binding budget. The actual budget of the Town of Niwot, if incorporated, will be adopted annually by the elected Town Council.

This pro forma reflects a structured feasibility model built using Boulder County data, Colorado Municipal League (CML) benchmarking, comparable municipality analysis, and preliminary service cost estimates. Where exact bids or intergovernmental agreements are not yet available, reasonable planning-level assumptions have been applied and stress-tested through sensitivity analysis.

Note: This version consolidates all road-related expenses into a single Roads Expenses section following a collaborative process with the Niwot Community Association on how best to explain the town’s roads commitment. Ongoing road maintenance now includes an explicit line for reserves for future road projects, rather than accumulating those reserves implicitly in the general fund balance.

Executive Summary

This document is a planning-level feasibility model designed to answer one question: can Niwot’s proposed tax structure support core municipal services and a long-term roads program while remaining fiscally resilient under adverse conditions?

Proposed recurring revenue structure modeled:

The two primary household taxes are the 2.5% sales tax and the 4-mill property tax levy. The full budget model also includes the following additional revenue sources that apply to Colorado municipalities under existing law:

• 4.0 mills municipal property tax
• 2.5% municipal sales tax
• 2.5% municipal use tax
• 3% municipal retail marijuana tax (modeled as one outlet)
• State-shared and formula revenues (HUTF, Specific Ownership Tax, Road & Bridge, and Conservation Trust Fund)

Operating model (lean, contract-first):

• 2028 is modeled as the first full year of operations
• Core services are provided primarily through contracts and intergovernmental agreements, including:
  • Public safety via Boulder County Sheriff (modeled at 2.0 FTE)
  • Road routine maintenance and seasonal snow removal
  • Contracted building department services (net-positive to General Fund under SAFEbuilt 85/15 fee structure)
  • Minimal administrative staffing and required governance functions

Roads capital program modeled:

• A $15 million road capital program financed over ~20 years, with the town netting approximately $16 million in bond proceeds after issuance premium
• Debt service modeled beginning 2029 (partial year, ~$820K) at approximately $1.23 million per year thereafter
• Ongoing road maintenance modeled at approximately $1.25 million in 2029, rising to ~$1.73 million by 2040 — this line explicitly includes reserves for future road capital projects

Baseline results:

• Recurring revenue supports operating expenses, road debt service, and ongoing road maintenance (including future-project reserves) across the projection period, with a small annual surplus in every year of operations.
• Startup surpluses in 2028 (~$2.4M) and 2029 (~$0.7M) establish the general fund reserve; the tightest year is 2030 at a modest ~$12K annual surplus as the full roads commitment ramps up, growing steadily thereafter.
• General fund cumulative reserves reach approximately $6.85 million by year-end 2040, with the minimum at approximately $2.19M in 2028 (post-startup) and monotonic growth thereafter.

Stress-testing and resilience:

• Cumulative reserves stay well above the GFOA-recommended two-month operating minimum throughout the projection period, ranging from approximately 6× to 15× that minimum.
• Break-even thresholds (permanent shifts required to push cumulative reserves negative at any point 2028–2040): sales tax approximately −20%, property tax approximately −47%, operating expenses approximately +24%, ongoing road maintenance approximately +39%.
• Monte Carlo stress testing (100,000 simulations against the updated model) shows median 2040 reserves of ~$6.80M, 5th percentile of ~$1.34M, and approximately 3.4% probability of cumulative reserves dipping below zero at any point across the projection period. See Sensitivity Analysis for methodology.

Break-even margin:

• In the tightest year (2030), the modeled annual contribution to reserves is approximately +$12K — effectively break-even. The 6.75% expected-use operating contingency ($120K in 2030), together with an additional 8.25% of core opex retained as fund balance under GFOA best practice, provides substantial headroom before any actual deficit would materialize.

Budget flexibility:

• Discretionary programs provide flexibility and would be among the first items reduced or deferred in a downside scenario, before core services.

Important limitation:

This pro forma is not a binding budget. Actual revenues and expenditures will depend on economic conditions, reassessment outcomes, negotiated contracts, grant awards, and policy decisions made by a future elected Town Council if incorporation is approved. Voters authorize revenue measures at stated rates (or “up to” limits where applicable); specific staffing levels, service contracts, and program choices would be determined by a future elected Town Council.

---

How to Read This Pro Forma

This pro forma is a feasibility model, not a finalized municipal budget.

It is designed to answer a single question:

Under reasonable and stress-tested assumptions, can the proposed tax structure support core municipal operations and a long-term road capital program?

For purposes of this model, “structural durability” means the ability to fund core operations, modeled road debt service (loan repayment), and ongoing road maintenance (including reserves for future road capital projects) while maintaining adequate general fund reserves under adverse conditions.

It is not intended to:

• Lock in specific staffing or discretionary programs
• Predetermine the policy choices of a future elected Town Council

Where uncertainty exists, conservative planning assumptions and contingency have been applied. The model has also been subjected to adverse economic simulations to test structural durability.

---

The tables below summarize the pro forma budget; detailed assumptions and methodology are provided in Appendix A.

Pro Forma Budget Projections (2027–2040)

Revenue

Expenses

Notes: (a) The 2028 snow removal and signs/lights lines show partial-year values reflecting ramp-up activity; the Roads Expenses section is formally treated as beginning in 2029 (the first full year with debt service and ongoing maintenance responsibility), so these 2028 partial-year costs sit outside the Roads Expenses total and are absorbed within transition arrangements. (b) Cumulative Reserves reflect general-fund fiscal capacity only. The town’s full 15% budgeted contingency is presented as 6.75% expected-use spending (in the tables above) plus 8.25% retained as fund balance (implicitly included in Cumulative Reserves), per GFOA best practice; see T6 for methodology.

---

Notes to the Pro Forma Tables

T1. Dollar format and rounding. All figures are shown in nominal dollars and rounded to the nearest $1,000 (“$000s”). Minor differences may occur due to rounding.

T2. 2027 is a transition / pre-incorporation year. The year 2027 is modeled as a transition year and may include certain organizational and planning costs prior to incorporation. Revenue authority is assumed to begin in 2028. In 2027, recurring municipal revenues are shown as “—” because the Town is not assumed to be operating as a municipality. Where a revenue line item is assumed to be $0 in an operating year (e.g., grants in 2028), the table shows $0.

Transition-year funding. 2027 transition-year costs are assumed to be covered using existing community resources and non-municipal startup support. Niwot’s Local Improvement District (LID) has maintained approximately $400,000 in reserves in recent years that may be available to support eligible transition expenses, subject to legal authority and LID governance. LID reserves are not assumed for ongoing operations and are referenced only as a potential one-time transition support source. No municipal tax revenue is assumed for 2027; any transition-year costs are assumed to be covered through a combination of potentially eligible LID reserves (to the extent legally available) and/or private/donated support.

Cash-flow timing: Because municipal revenues may be received with a timing lag after formation, startup operations may require short-term working capital (e.g., an intergovernmental advance/loan or similar bridge funding mechanism), repaid once revenues are received. CDOR limits new municipal sales/use tax effective dates to January 1 or July 1, with the enacting ordinance/resolution due at least 45 days before the effective date; the pro forma assumes calendar-year operations for modeling simplicity.

T3. 2028 is first full year of operations. The year 2028 is modeled as the first full year of municipal operations and reflects the first year of full recurring revenues and contracted services.

Timing clarification: 2028 reflects a ramp-up year in which certain services may be provided for part of the year through transition arrangements; 2029 is treated as the first full year of contracted municipal service responsibility for planning-level modeling.

During the transition period, certain services may continue to be provided by Boulder County under existing arrangements while the Town establishes contracts and administrative systems.

T4. Revenue totals. “Total Revenue” includes all recurring revenues plus, in 2029 only, road bond proceeds ($16 million) shown as an explicit line. The bond proceeds are offset in the same year by the $15.725 million deferred-repairs capital outlay in the Roads Expenses section; they are shown in gross terms so that both the financing event and the capital use are visible on the face of the pro forma.

T5. Operating expenses definition (excludes roads). “Total Operating Expenses” includes payroll, non-road service contracts (Sheriff, trees/landscaping, building department), administrative costs, other expenses, and a 15% contingency on those items. Road-related costs — capital outlay, debt service, ongoing maintenance (including reserves for future projects), snow removal, and traffic devices — are shown separately in the Roads Expenses section.

T6. Contingency accounting (GFOA-consistent). The pro forma budgets 15% contingency on both core operating expenses and on the road snow-removal + signs/lights base. Consistent with Government Finance Officers Association (GFOA) guidance on fund balance and working capital policy, contingency is treated as capacity against uncertainty rather than as guaranteed expenditure: only the expected-use portion (calibrated to ~45% based on observed municipal experience in comparable Colorado front-range towns) flows into recurring expenses, and the unused ~55% is retained as unallocated fund balance available for genuinely unforeseen events. Expressed against the underlying expense base: expected-use contingency = 6.75% of core opex and 6.75% of snow + signs base (shown as line items in the tables above); the corresponding 8.25% of each base accumulates in Cumulative Reserves. Ongoing road maintenance carries its own internal buffer via the “reserves for future projects” component (see T7) and is not subject to a separate contingency treatment.

Scope note on startup municipal functions. This pro forma reflects a lean, contract-first operating model. Certain functions commonly found in municipal budgets (e.g., payroll processing, HR support, records management, code enforcement coordination, fleet/equipment costs, and miscellaneous intergovernmental charges) are assumed to be covered through a combination of contracted services, materials/operating line items, and the 15% contingency unless otherwise shown as a dedicated line item.

T7. Roads Expenses section. All road-related costs are consolidated into a single Roads Expenses section for transparency. This section includes: (a) the one-time $15.725M deferred-repairs capital outlay in 2029, funded by bond proceeds shown on the Revenue side; (b) roads capital project bond repayment beginning in 2029 (partial year, ~$820K) at approximately $1.23M per year thereafter, based on a Financial Scenario Analysis prepared by Piper Sandler assuming April 2029 issuance; (c) ongoing road maintenance, which includes an internal set-aside for reserves for future road capital projects (the town’s standing roads-reinvestment commitment); (d) snow removal and street sweeping with a 15% contingency embedded in the line; and (e) signs, lights, and striping. The bond issuance timing will be determined by the future elected Town Council and voter authorization; the pro forma models 2029 as a planning assumption.

T8. Net contribution to reserves. “Net Contribution to Reserves” equals Total Revenue minus Combined Operating & Roads Expenses. Values may be positive or negative in a given year; the 2029 partial-year and startup structure produces surpluses in 2028–2029, modest deficits in 2030–2032 (which are absorbed by prior-year reserves), and structural surpluses from 2033 onward.

T9. Cumulative reserves definition (general fund only). “Cumulative Reserves” represents the running total of net contributions to reserves plus retained (unused) contingency capacity, i.e., the town’s general fund fiscal capacity. It reflects the buffer available for economic downturns, discretionary programs, and unforeseen expenses after road debt service and the town’s ongoing roads commitment (which is expensed within the Roads Expenses section, including reserves for future road capital projects) have been funded. This is a change from prior versions: in v1.3–v1.4, reserves for future road capital projects accumulated implicitly within cumulative reserves, producing a 2040 balance of ~$15M; in v1.5, those reserves are expensed each year within Ongoing Road Maintenance, and cumulative reserves reflect general-fund fiscal capacity only, producing a 2040 balance of ~$6.85M. Note: CTF and most grant revenues are restricted to eligible purposes (parks/recreation and specific capital activities, respectively); cumulative reserves should be interpreted as aggregate fiscal capacity across funds, not solely unrestricted General Fund cash. Restricted revenues are not assumed to fund general operating or public safety expenses.

T10. Grants + Conservation Trust Fund are combined in the table. The “Grants, Conservation Trust Fund” line reflects the combined total of grant revenue and Conservation Trust Fund revenue. In 2029, this line includes approximately $270k of modeled grants plus ~$80k from Conservation Trust Fund. CTF is restricted to eligible recreation purposes and is not assumed for general operating costs. Parks & Trails is modeled slightly above expected CTF receipts (planning delta of roughly $18k/yr); final cost depends on how responsibility is allocated between the Town and Boulder County. Grant revenue is not guaranteed and is not relied upon to fund core operating or public safety services.

T11. Building Department is net-positive by design. Building Department Permit Fees revenue reflects projected annual permit revenue of approximately $180,000 (in base-year dollars) using IRC standards. Under the SAFEbuilt proposal, SAFEbuilt retains 85% of permit revenue as its service fee and the Town retains approximately 15% (~$27,000 annually in base-year dollars). Building Department Services expense in the pro forma reflects SAFEbuilt’s 85% share. The net effect is that the Building Department generates a modest surplus for the Town rather than requiring a General Fund subsidy.

T12. Sheriff line item is a contracted service. Public Safety costs are modeled as a contracted service with Boulder County Sheriff’s Office. Final costs will be determined through an intergovernmental agreement.

T13. Roads Expenses line items. The Roads Expenses section presents each cost driver as its own line: (i) one-time capital outlay in 2029, (ii) annual bond repayment, (iii) ongoing routine maintenance (crack seal, patching, chip/slurry seal cycles) with an explicit set-aside for future capital projects, (iv) seasonal snow removal and street sweeping with a 15% contingency embedded in the line, and (v) signs, lights, and striping. This separation makes it clear which portion of the roads commitment is one-time capital, which is standing debt service, and which is ongoing responsibility — and shows that the town’s ongoing roads-reinvestment commitment is being expensed each year rather than deferred.

T14. Events/Beautification and Downtown improvements are discretionary. “Events and Beautification” and “Downtown improvements” represent discretionary quality-of-life and place-making programs that may be adjusted by future elected officials based on budget priorities. Events and Beautification spending is based on current Local Improvement District (LID) expenditure levels (~$180,000/year). No startup cost is modeled for 2027 because the LID pre-allocates these expenses through the end of its term. In a downside revenue scenario, discretionary programs would be the first area subject to reduction or deferral before core services. Downtown improvements could be higher if the Town qualifies to establish an Urban Renewal Authority (URA) and utilize Tax Increment Financing (TIF) under the Colorado Urban Renewal Law (CRS 31-25-101 et seq.). Establishing a URA with TIF requires a statutory blight finding, an impact report to overlapping taxing entities, negotiation of TIF-sharing agreements with affected special districts, and governing body approval. TIF allocation is limited to a maximum of 25 years from plan approval (subject to limited statutory exceptions, e.g., bond default conditions under CRS 31-25-107(9)). Whether to pursue a URA designation would be a future policy decision of the elected Town Council. See Appendix B for detailed statutory requirements.

T15. Incorporation costs are one-time. Incorporation Costs are modeled as a one-time legal and administrative expense and are not recurring.

---

Appendix A — Global Assumptions

A1. Population Assumption

The incorporation area population is assumed to be 4,305 residents.

A2. Assessed Value Base

Property values are based on Boulder County Assessor data for tax year 2025 (June 30, 2024 assessments), including both residential and commercial property within the proposed incorporation boundary.

A3. Escalation Assumptions

• Residential property market value growth is assumed at a 20-year historical compound annual growth rate (CAGR) of 4.4% for the Front Range.
• Commercial property market value growth is assumed at a 20-year historical CAGR of 2.4%.
• All other recurring revenues and expenses are escalated at 3% annually unless otherwise noted (see E3 for public safety escalation methodology).
• An additional up to 5% growth adjustment is applied to property market values in the first two years following incorporation as a planning assumption; actual impacts may be lower or zero depending on market conditions and reassessment outcomes. Sensitivity note: The pro forma remains structurally solvent (able to fund core operations and modeled road debt service without recurring deficits) if this post-incorporation adjustment is 0%, as it is not relied upon to fund core services.

A4. Contingency

Operating expenses include a 15% contingency to account for uncertainty in startup conditions and potential unanticipated costs.

A5. Partial-Year Operations

2028 reflects a ramp-up year in which revenue authority begins and certain services may be provided under transition arrangements. 2029 is treated as the first full year of contracted municipal service responsibility. Some 2028 figures may reflect partial-year startup conditions where applicable.

---

Revenue Footnotes

R1. Property Tax – 4 Mills

Property tax revenue assumes a 4.0 mill municipal levy applied to assessed valuation. The model separately calculates residential and commercial valuation growth using their respective assessment rates and historical growth assumptions before applying the municipal mill levy.

Residential Property

• Residential assessment rate modeled at ~6.7% as a planning assumption. Under current law (HB 24B-1001 and subsequent legislation), the residential local government assessment rate is scenario-based: the statute provides alternate rates depending on whether statewide actual value growth exceeds 5% (e.g., 6.15% vs. 6.25% for tax year 2025; 6.7% vs. 6.8% for tax year 2026). Both scenarios apply the rate after a market value reduction equal to 10% of actual value or $70,000 (inflation-adjusted), whichever is less, as provided in current law. The 6.7% planning assumption reflects a rounded midpoint of the current statutory range for the projection period.
• Market value growth assumed at 4.4% annually.
• Boulder County reassessment occurs every two years; model reflects this cycle.

Commercial Property

• Commercial and agricultural property assessment rate is 25% for tax year 2026 under HB 24B-1001 (down from 27% in prior years). Most other nonresidential property classes are assessed at 26% in 2026, declining to 25% from 2027 onward. The pro forma models commercial property at 25% for simplicity across the projection period.
• Market value growth assumed at 2.4% annually.

All property tax revenue is shown in the year received, based on prior-year market values.

Business Personal Property (BPP). The assessed value base includes approximately $13.1 million in Business Personal Property located in the Niwot Tech Center, which generates approximately $13,000 per year in property tax revenue at 4 mills. BPP is assessed at 25% of actual value (same as commercial real property) and is subject to the same mill levy. BPP values are reported annually by business owners and may fluctuate with equipment purchases and depreciation schedules.

Statutory change risk. Colorado’s residential assessment rate has been modified multiple times in recent years (Gallagher Amendment repeal in 2020, SB 22-238, SB 24-233, HB 24B-1001). Future legislative changes to assessment rates, exemption levels, or the value reduction formula can alter assessed value — and therefore property tax revenue — independently of underlying market value trends. The pro forma does not model future statutory changes; if assessment rates are reduced below the modeled assumption, property tax revenue would decline accordingly. Property tax represents less than 25% of modeled total revenue, limiting the structural impact of any single reassessment-rate change.

R2. Sales Tax – 2.5%

Sales tax revenue assumes a 2.5% municipal rate.

2025 local retail sales are estimated at approximately $25 million annually based on Local Improvement District (LID) receipts at a 1% rate.

Non-local/remote taxable sales (collected under Colorado’s destination-based sales tax rules) are estimated at approximately $55 million annually using per-capita and income-adjusted comparisons with comparable Front Range municipalities. Louisville and Lyons were used as primary benchmarks; Niwot’s modeled per-capita figure falls between the two, modestly below Louisville’s observed level. The model therefore reflects a conservative estimate within the demonstrated regional range. See Appendix C for the full regional benchmark analysis and per-resident derivation.

Adjustments were made for:

• Population
• Household income
• Local tax rate

Total estimated 2025 taxable sales base: ~$80 million.

Inflated at 3% annually to 2028 results in ~$2.185 million in municipal sales tax revenue.

The implied 2028 taxable sales base is approximately $87.4 million (~$20,300 per capita).

This per-capita taxable sales level is consistent with small Front Range municipalities with active neighborhood commercial districts.

Conservatism check. If collections are lower than modeled, the budget provides multiple adjustment levers including capital timing and non-essential program sizing.

Sales tax exposure note: As with all small municipalities, sales tax collections may be influenced by a limited number of larger retailers. The 15% operating contingency and reserve accumulation are designed to buffer short-term volatility in the event of individual business turnover.

Tax administration posture. Sales and use tax is modeled as state-collected (administered by the Colorado Department of Revenue), consistent with the statutory town structure. The sales and use tax base follows state definitions under CRS 39-26-104. If Niwot were to later adopt a home rule charter with self-collection authority, it would likely participate in the state’s Sales and Use Tax System (SUTS) portal for centralized filing and remittance. Many self-collecting home rule jurisdictions participate in SUTS; CDOR maintains a current list of participating jurisdictions.

Remote and destination-sourced sales. Colorado requires remote sellers exceeding $100,000 in annual gross sales into the state to register and collect applicable sales tax (CRS 39-26-102(3), effective post-Wayfair). Once the threshold is exceeded, collection must begin by the first day of the first month commencing at least 90 days after crossing the threshold (or by January 1 of the following year if the threshold was exceeded in the prior calendar year). Marketplace facilitators (e.g., Amazon, Etsy) independently bear collection obligations above this threshold. The Colorado Department of Revenue provides GIS-based address lookup and the SUTS portal to support accurate local rate sourcing under destination-based rules. For a state-collected statutory municipality, remote seller compliance is administered entirely by CDOR — the Town would not need to operate a separate tax administration function. The inclusion of remote taxable sales in the modeled sales tax base reflects this existing state infrastructure.

R3. Use Tax – 2.5%

Use tax revenue is modeled at a 2.5% rate and is based on comparisons with Louisville, adjusted for population, household income, and tax rate.

The estimate excludes building materials use tax.

2025 base estimate: ~$440,000.
Inflated to 2028: ~$481,000.

Collection variability. Use tax collections vary by municipal administration and compliance. The model assumes a moderate, benchmark-based level; if actual collections are lower, the variance would be absorbed through reserves and budget adjustments.

R4. Retail Marijuana Tax – 3%

Retail marijuana tax assumes a 3% municipal rate.

Estimated annual retail sales per outlet: $1.67 million. This is based on observed changes in local LID revenue following store opening and is below the Boulder County average per store ($3.2 million annually).

The model assumes one retail outlet.

Marijuana revenue note: Marijuana-related revenue is treated as a marginal line item and is not relied upon to fund core services. Actual collections may vary and could decline over time depending on regional market conditions.

R5. Highway Users Tax Fund (HUTF)

HUTF distributions are based on a statutory formula weighted 80% by registered vehicles and 20% by center lane miles (per Colorado Municipal League formula description).

Assumptions:

• 25–29 centerline miles of roadway (see road mileage sensitivity note below)
• Approximately 4,500 registered vehicles

Mileage definitions. Road responsibility throughout this document is expressed in centerline miles (the length of the road regardless of number of lanes). Treatment costs in E4 are expressed per lane mile (centerline miles × number of lanes; approximately 2× centerline miles for predominantly two-lane residential roads). HUTF’s statutory formula uses “center lane miles,” a lane-mile measure used in HUTF reporting and distribution calculations.

Registered vehicles are estimated at approximately 4,500. This estimate is derived from:

• 4,305 residents
• Estimated average household size of ~2.3 persons
• Approximate 2.4 vehicles per household, reflecting Niwot’s suburban travel patterns

The resulting estimate is rounded conservatively for planning purposes.

Road mileage sensitivity: Road responsibility is modeled at ~25 centerline miles as a planning assumption. Final mileage may be higher (e.g., ~25–29 miles) depending on intergovernmental allocation of responsibility for certain through roads. HUTF revenues and road-related costs scale with final mileage and responsibility split.

Revenue assumed at approximately $4,000 per centerline mile as a planning estimate, derived from the statutory formula applied to the modeled vehicle count and mileage. This falls within the mid-range of historical HUTF distributions for municipalities of similar size and road mileage.

Estimated 2025 revenue: ~$100,000.
Inflated to 2028: ~$109,000.

R6. Road & Bridge Fund

Revenue equals Niwot’s proportionate share of Boulder County’s 0.167 mill levy for Road & Bridge.

Formula:
(Niwot Assessed Value ÷ Boulder County Total Assessed Value) × County Road & Bridge Revenue.

Estimated 2025 revenue: ~$29,600.
Inflated to 2028: ~$32,300.

R7. Specific Ownership Tax (SOT)

Specific Ownership Tax (SOT) is collected by the State of Colorado at the time of annual vehicle registration. The County Treasurer then distributes those receipts across all local taxing jurisdictions (county, school district, fire district, municipal government, etc.) in proportion to each jurisdiction’s mill levy.

Because SOT depends on (a) how many vehicles are registered to addresses within the proposed town boundary and (b) the value/age mix of those vehicles, this pro forma uses conservative, planning-level assumptions that can be refined if better local data becomes available.

Vehicle Count Assumption (Registered Vehicles)

The proposed town boundary contains approximately ~1,672 residential parcels (households) and ~4,305 residents. To avoid relying on a single method, we estimate vehicle count two ways and use the results as a range.

Method A — Household-based estimate. In suburban and small-town settings with limited transit, it is common to see roughly 2.0–2.6 vehicles per household (commuting and errands are car-dependent; many homes have 2+ drivers). Using a conservative planning point: 1,672 households × 2.4 vehicles/household ≈ 4,013 vehicles. Adding a modest buffer for non-household registrations tied to local addresses (e.g., small-business vehicles, certain contractor vehicles, secondary vehicles) produces a rounded planning assumption of ~4,500 registered vehicles.

Method B — Population cross-check (U.S. registrations per resident). FHWA’s Highway Statistics reports ~284.6 million registered vehicles nationally (2023). U.S. Census “Vintage 2023” estimates report ~334.9 million residents (2023). That implies ~0.85 registered vehicles per resident as a broad national baseline: 4,305 residents × 0.85 ≈ 3,660 vehicles. Small towns and suburban areas often exceed the national baseline because they are more car-dependent than dense metros, so a planning range of ~3,600 to ~4,500 is reasonable.

Planning assumption used in this pro forma: 4,500 registered vehicles.

Note: even if the “true” number were, say, 3,700–4,200 instead of 4,500, the budget impact is modest because SOT is a small line item in the overall revenue stack.

Average SOT per Vehicle (Blended)

SOT varies widely by vehicle value and age. Newer vehicles can generate several hundred dollars per year; older vehicles can be well under $100.

Colorado’s vehicle fleet is not dominated by new vehicles. Colorado’s average vehicle age is approximately 13.1 years (S&P Global Mobility state-level fleet data), which implies a substantial portion of vehicles are in lower-SOT years. National fleet aging is also well documented; S&P Global Mobility reports ~12.8 years average age nationally.

To avoid overstating revenue, this pro forma uses a conservative blended figure of $180 average SOT per vehicle. Individual households with newer vehicles will often see higher SOT than this; households with older vehicles will often see lower.

Mill Levy Allocation (Town Share)

SOT is distributed proportionally based on mill levy share across all overlapping taxing jurisdictions.

• Proposed municipal levy: 4.0 mills
• Approximate composite total levy (all jurisdictions): 102.461 mills (countywide composite estimate)
• Town share: 4 ÷ 102.461 ≈ 3.9%

Revenue Estimate

• Total SOT generated (planning level): 4,500 vehicles × $180 ≈ $810,000
• Town share (3.9%): ≈ $31,600
• Rounded: ~$32,000 (2025 dollars)
• Inflated to 2028: ~$35,000

R8. Grants

Grant revenue is modeled conservatively based on the specific state and federal programs for which a newly incorporated Colorado municipality of Niwot’s size and characteristics would be eligible. Key programs include:

• GOCO Community Impact (Great Outdoors Colorado). Funds planning and construction of parks, trails, and outdoor recreation amenities. Colorado towns are eligible. Awards range from $100,000 to $2,000,000 per project (GOCO program description). GOCO plans to invest approximately $16 million annually through its base grant programs (FY2026).
• CDBG Public Facilities (DOLA/HUD). Community Development Block Grant program for non-entitlement municipalities (population under 50,000). Awards up to $100,000 for design/engineering/environmental clearance (DEEC program); construction grants of up to several hundred thousand dollars per award (program-specific caps vary by funding round). Eligible projects include water/sewer systems, streetscape improvements, and community facilities.
• CDOT Transportation Alternatives Program (TAP). Federal funds for pedestrian and bicycle facilities, safe routes to school, and environmental mitigation. Competitive, with 20% local match. CDOT indicates the next Call-for-Projects timeline (FY2027–2029) will be released in late spring 2026; calls occur on a three-year cycle.
• DOLA Energy/Mineral Impact Assistance Fund (EIAF). Awards up to $200,000 (Tier I) or $200,000–$1,000,000 (Tier II) for public facilities, comprehensive plans, and infrastructure. Multiple application cycles per year. Niwot’s eligibility may be limited as this program prioritizes communities impacted by energy/mineral development.
• CDOT Safe Routes to School. Awards up to $1,000,000 for infrastructure and non-infrastructure pedestrian safety projects near schools.

The model assumes:

• No grants in 2028
• $270,000 beginning in 2029

The $270,000 annual planning estimate reflects a single successful mid-range grant application per year (e.g., one GOCO Community Impact or CDBG award in the $200,000–$400,000 range, annualized). This is conservative relative to the aggregate funding available across these programs and does not assume success in every application cycle.

Grants are not guaranteed. If not awarded, projects would be deferred or funded through alternative means.

Grant revenue is not relied upon to fund core public safety or required operating services.

R9. Conservation Trust Fund (CTF)

CTF is a lottery-funded distribution allocated primarily on a per-capita basis.

2026 statewide pool: ~$82 million.
Colorado population: ~5.9 million.
Implied Niwot share: ~$72,000.

Inflated to ~$80,000 in 2029.

Funds are restricted to recreation-related capital and maintenance.

R10. Utility and Franchise Fees

Assumed at approximately $75,000 annually based on comparable municipalities. May include franchise fees, traffic fines, and minor municipal fees.

R11. Building Department

Building department services are based on a proposal from SAFEbuilt, a Colorado municipal contractor that provides contracted building department services to 71 municipalities in the state. The proposal assumes a full-service building department including Building Official, Inspections, Plan Review, Permit Technician, and building department software (with annual updates).

Projected annual permit revenue for Niwot is approximately $180,000 (base-year dollars) using IRC standards. Under the SAFEbuilt model, SAFEbuilt retains 85% of permit revenue as its service fee and the Town retains approximately 15% (~$27,000 annually). The Building Department is therefore net-positive to the Town’s General Fund by design.

---

Expense Footnotes

E1. Salaries

Salaries are benchmarked using:

• Colorado Municipal League surveys
• Salary databases
• Comparable municipality budgets

E2. Benefits

Benefits assumed at approximately 38% of salary, composed of:

• PERA employer contribution (Local Government Division): 15.80% of salary (January 2026 rate per PERA published schedule; includes 10.00% base rate, 2.70% AED, 2.00% SAED, 1.00% Automatic Adjustment, and 0.10% DC Supplement)
• Medicare (employer share): 1.45% of salary. Most PERA-covered public employment is exempt from Social Security (OASDI); Medicare coverage applies to employees hired after March 31, 1986, or as determined by the employer’s Section 218 agreement status. The pro forma includes only Medicare as a baseline payroll tax obligation.
• Employer health insurance contribution: ~10–12% of salary (varies by plan design and employee demographics)
• Workers’ compensation: ~2–4% of salary (varies by job classification and claims experience)

The 38% composite assumption is intentionally conservative relative to the 30–35% ranges commonly observed in small Colorado municipalities. The conservatism margin (~3–5 percentage points above the sum of the components listed above) provides a buffer for plan design variability, potential Section 218 Social Security obligations if applicable, and any future PERA rate adjustments.

Note: PERA employer contribution rates are subject to change under the Automatic Adjustment Provision (AAP), which can increase (or decrease) member and employer rates by up to 0.5% per year based on funded status. The AAP was not triggered for July 1, 2026. Future AAP adjustments are not modeled but would be absorbed within the 15% contingency.

E3. Sheriff Services

Based on preliminary, non-binding guidance from the Boulder County Sheriff’s Office indicating a blended loaded cost of approximately $200,000 per FTE (2026 dollars).

Current service level estimated at ~0.67 FTE, based on Boulder County’s characterization of existing patrol allocation to the Niwot area.

The model funds 2.0 FTE to ensure adequate coverage. This represents approximately three times the estimated current service level to ensure adequate local visibility and response capacity.

The $450,000 estimate reflects approximately two full-time equivalent (2.0 FTE) deputies at an estimated blended cost of $200,000 per FTE (2026 dollars), escalated at 4% per year (per Sheriff’s Office guidance) to the first full year of service (2029) and including administrative and contractual margin. From 2030 onward, annual growth is modeled at 3%, consistent with the general inflation assumption applied to other expense lines. The first year (2028) reflects partial-year ramp-up. Final costs will be determined through an intergovernmental agreement with Boulder County. If final negotiated costs exceed modeled assumptions, staffing levels or other budget lines would be adjusted accordingly.

E4. Roads Expenses

All road-related costs are grouped in the Roads Expenses section of the budget table. This footnote describes the methodology behind each line.

E4a. Ongoing Maintenance (including reserves for future projects)

Routine maintenance methodology: Routine road maintenance is estimated using treatment-cycle assumptions (e.g., crack seal / patching / surface treatments) applied to an estimated road surface area, with unit pricing informed by contractor guidance and comparable municipal cost experience. This approach converts road condition needs into a per-lane-mile (or surface-area) cost basis. Assumes crack seal / pothole work on ~20% of roads annually at ~$13k per mile, and chip/slurry seal on ~15% annually at ~$82k per mile. Surface area estimate based on road-width assumptions and cul-de-sacs; total road surface modeled at ~740,000 sq ft.

Benchmark calibration. Unit costs are consistent with published per-lane-mile rates from the City of Littleton, Colorado (2016 bid prices): crack sealing ~$5,500/lane mile, surface seal (slurry/chip) ~$35,000/lane mile, mill & overlay ~$320,000/lane mile. Escalated to the pro forma base period at ~3%/year (×1.37), these translate to approximately $7,500, $48,000, and $438,000 per lane mile respectively. Niwot’s modeled treatment cycle (~20% crack seal, ~15% surface seal annually across ~25 miles of predominantly two-lane residential road) produces annual routine maintenance costs within the range implied by these benchmarks. Littleton maintains ~161 centerline miles and publishes its pavement management plan publicly; unit costs are used here for calibration, not as direct comparables to Niwot’s smaller network.

Reserves for future projects. The Ongoing Maintenance line explicitly includes an annual set-aside for future road capital projects — treated as an ongoing operating expense rather than accumulated implicitly in the general fund. This makes the town’s standing roads-reinvestment commitment visible on the face of the pro forma and ensures that the recurring cost of maintaining Niwot’s road network at target condition is fully budgeted year over year.

E4b. Snow Removal & Street Sweeping

Snow removal basis: Snow removal assumptions are informed by preliminary vendor bid pricing and event-based estimating (miles × events). The 15% contingency is embedded directly in this line.

Snow removal estimated using:

• $175 per mile × 25–29 miles × 12 events
• $200 per mile × 5 sidewalk miles × 12 events
• $250 per mile × 25–29 miles × 2 sweeping events

Total rounded to approximately $100,000 before contingency (2028 dollars, first full-year basis); $115,000 in 2029 with 15% contingency embedded. The estimate scales with confirmed road mileage (see R5 road mileage sensitivity note).

E4c. Signs, Lights, and Striping

An annual allowance for road signs, traffic signals, pavement markings, and related traffic devices, modeled at approximately $50,000 in base-year (2026) dollars plus 15% contingency, escalated at 3% annually. This line captures ongoing traffic-safety infrastructure that is distinct from pavement maintenance.

E5. Office Space / Meeting Rentals

Modeled using ~2,000 sq ft at ~$27/sq ft (2026 dollars) plus meeting rentals (e.g., Niwot Hall), escalated at 3% annually.

E6. Insurance

Insurance estimates are based on Colorado Municipal League and CIRSA data for municipalities of similar size and asset profile. Typical range cited $40k–$80k; used $60k midpoint, potentially lower due to minimal employees and no municipal vehicles or buildings.

E7. IT

2027 includes one-time setup ($40k); 2028 and beyond reflect ongoing subscriptions, support, and compliance (~$30k midpoint). Typical range $20k–$40k for municipalities of this size.

E8. Finance Contracting / Auditing

Typical range $20k–$35k for municipalities of this size; modeled $40k due to lean internal staff and reliance on contracted finance/audit services.

Colorado’s Local Government Audit Law (CRS 29-1-603) requires the governing body of each local government to cause an annual audit of its financial statements. Audit exemptions are available only for local governments with revenues and expenditures at or below $1,000,000 (as updated by SB 25-023); Niwot’s projected budget exceeds this threshold from Year 1, so no exemption is available. Audit reports must be filed with the Office of the State Auditor. The $40k line reflects contracted CPA services sufficient to satisfy this statutory obligation in a lean staffing model with no internal finance department.

E9. Materials Costs

Materials costs are modeled at $100,000 to account for deferred infrastructure needs and startup provisioning. This exceeds typical ranges for towns of comparable size and reflects the conservative assumption that a newly incorporated municipality will face higher initial materials requirements during its first several years of operation.

E10. Election Costs

Estimated using DOLA and CML guidance. Assumes periodic elections with costs in the $5,000–$20,000 range per election year.

Election costs are modeled on an annualized basis for simplicity. For planning simplicity we annualize; actual spend occurs in election years (e.g., ~$25k every other year).

E11. Incorporation Costs

One-time legal and administrative expenses estimated at ~$150,000.

E12. Contingency

Operating contingency set at 15% of expenses to address startup risk and uncertainty.

---

Capital & Reserves

C1. Roads Capital Project Bond — Issuance & Repayment

A ~$15 million road capital program financed over approximately 20 years at an assumed municipal borrowing rate in the 4–5% range. The capital program funds repair and reconstruction of roads, bridges, drainage, sidewalks, and related transportation infrastructure — addressing accumulated deferred maintenance across the town’s inherited road network in a single coordinated program rather than piecemeal.

Bond proceeds and capital outlay presentation. The updated pro forma presents both sides of the bond transaction on the face of the budget: bond proceeds of ~$16 million appear as revenue in 2029 (reflecting net proceeds to the Town after issuance premium and underwriter costs, per Piper Sandler’s Financial Scenario Analysis), and the corresponding $15.725 million deferred-repairs capital outlay appears as a Roads Expenses line in the same year. This is a change from prior versions, which netted these one-time items; showing them explicitly makes it clear that the capital program is fully funded by dedicated bond proceeds rather than by operating revenues.

Repayment schedule. The modeled annual repayment of approximately $1.23 million begins in 2029 (partial year, ~$820K) and continues at a level annual amount through 2040. The schedule is based on Piper Sandler’s Financial Scenario Analysis at current market rates plus 50 basis points, using a standard amortization structure with a partial first-year payment. Actual structure (level, wrapped, or sculpted) will be determined at issuance.

Final bond terms subject to market conditions and voter authorization. If interest rates at issuance are higher than modeled, the Town could reduce project scope, extend timing, seek grants, or adjust revenue measures subject to voter authorization.

C2. Roads-Reinvestment Commitment (Ongoing)

Beyond the one-time bond-funded capital program, the pro forma models an ongoing roads-reinvestment commitment as part of the Ongoing Maintenance line. This includes both current-year maintenance activity (crack seal, patching, chip/slurry seal cycles per E4a) and an explicit annual set-aside for future road capital projects. Expensing this commitment year over year — rather than allowing surpluses to accumulate and be reallocated — is the mechanism by which the town honors its standing commitment to keep road infrastructure at target condition after the initial bond-funded repair program is complete.

C3. Net Contribution to Reserves

Equals annual Total Revenue minus Combined Operating & Roads Expenses. Values may be positive or negative in a given year: the model produces surpluses in 2028–2029 (startup ramp-up and partial-year road debt service), modest single-year deficits in 2030–2032 as the full roads commitment ramps up (~$148K, $80K, $39K), and structural surpluses from 2033 onward. Cumulative net contributions never exceed the prior-year reserve balance, so cumulative reserves remain positive throughout the projection period.

C4. Cumulative Reserves (General Fund)

Represents the town’s general fund fiscal capacity: the running total of net contributions to reserves, assuming no withdrawals. Because the ongoing roads-reinvestment commitment is expensed within Roads Expenses (see C2), cumulative reserves reflect general fund capacity after the town’s roads commitment has been funded each year, not before.

For reference, the Government Finance Officers Association (GFOA) recommends that general-purpose governments adopt a formal fund balance policy and maintain, at minimum, a reserve equivalent to approximately two months of regular general fund operating expenditures. Under the modeled assumptions, cumulative reserves exceed this threshold by the first full year of operations and remain approximately 6× to 10× the GFOA minimum throughout the projection period.

Change from prior versions. Under v1.3–v1.4, the pro forma treated the annual road-reinvestment set-aside implicitly as an accumulating reserve rather than an operating expense, producing a 2040 cumulative reserves figure of ~$15 million; and treated contingency as fully expensed each year. Under v1.5, (a) the road-reinvestment set-aside is expensed each year within Ongoing Road Maintenance, and (b) contingency is treated as reserve capacity per GFOA best practice (only ~45% expected use flows through as recurring expense; the ~55% unused capacity accumulates in fund balance). Combined, these treatments produce a general-fund 2040 balance of ~$6.85 million. All three presentations describe the same underlying fiscal position; v1.5 makes the roads commitment more transparent and applies contingency accounting consistent with municipal best practice.

---

Sensitivity Analysis

Baseline Trajectory

Under the updated model, the deterministic baseline produces a small annual surplus in every year of operations. Cumulative general-fund reserves grow monotonically from ~$2.19M at end-of-2028 to ~$6.85M by 2040. The tightest year is 2030 (approximately +$12K annual contribution) as the full ongoing roads commitment ramps up; contributions grow steadily thereafter.

Recurring figures exclude the one-time 2029 bond issuance ($16M revenue) and corresponding deferred-repairs capital outlay ($15.725M expense), which offset each other. Cumulative reserves include the ~$275K net positive from bond issuance premium in 2029 and reflect the contingency-as-reserve accounting described in T6.

Contingency headroom in the tightest year. The 2030 net contribution is approximately +$12K — a small positive surplus. Beyond this modeled surplus, an additional ~$147K of operating contingency capacity is held as unallocated fund balance available if genuinely unforeseen expenses arise (the difference between the 15% budgeted contingency and the 6.75% expected-use portion already flowing through Operating Expenses). Cumulative reserves in 2030 are approximately $2.88M — roughly 9× the GFOA-recommended two-month opex minimum.

Break-Even Sensitivity

The table below shows how large a permanent shift in each variable (applied to all years 2028–2040) would need to be before cumulative reserves fall below zero at any point in the projection period.

Interpretation. No individual revenue or expense line, changing by any amount that could plausibly occur in normal municipal operations, would push cumulative reserves negative under the deterministic model. Sales tax — the most economically sensitive revenue line — would need to fall approximately 20% permanently before general-fund reserves would be exhausted at some point in the projection period. Property tax, use tax, and grants would each need to decline much more dramatically (or eliminate entirely) before triggering a deficit. On the expense side, operating expenses would need to inflate ~24% above modeled levels permanently, and ongoing road maintenance ~39% above modeled levels, to exhaust reserves. These single-variable results are inherently optimistic because real downturns produce correlated shocks in multiple lines simultaneously; the Monte Carlo analysis below tests those correlated scenarios directly.

---

Stochastic Stress Testing (Monte Carlo)

The pro forma was stress-tested using 100,000 Monte Carlo simulations over 2027–2040 to evaluate structural resilience under adverse and volatile economic conditions. The simulation extends the standard framework used in prior versions of this pro forma with several refinements that reflect realistic municipal fiscal behavior.

Model Design

Each simulation year computes:

Contribution _t = Revenue _t − Expense _t

Year-End Cumulative Reserves _t = Σ (Contribution _i) from i = 2027 to t

Shock Framework

Correlated macroeconomic downside (clustered stress years). Common AR(1) macro factor with persistence φ = 0.65, generating persistent bad stretches over multiple years. Revenue lines with high macro sensitivity (sales tax, use tax, retail marijuana tax, building permits) receive a −8% per 1σ shock via lognormal mapping. Revenue lines with moderate sensitivity (property tax, HUTF, Road & Bridge, SOT) receive a −4% or −2% per 1σ shock reflecting their empirically stickier behavior in downturns; property tax additionally lags the macro shock by two years to reflect Boulder County’s biennial reassessment cycle. Lumpy revenue lines (grants, CTF, franchise/utility fees) are not tied to the macro factor. Expenses receive a +4% per 1σ macro shock, reflecting that recessionary periods tend to increase service demand while contracted service costs remain sticky.

Trend error (compounding drift). Revenue and expense levels each incorporate Normal(0, 1.0% per year) drift, compounded through time to reflect long-horizon estimation uncertainty.

Idiosyncratic annual noise. Additional 2% lognormal shocks on revenue and expenses each year, uncorrelated across time and between series.

Reactive council behavior. If end-of-year cumulative reserves fall below twice the GFOA two-month operating minimum, the following year’s discretionary expenses (Events and Beautification, Downtown Improvements, and the future-projects portion of Ongoing Road Maintenance) are reduced by 50%. This models the standard fiscal-management response observed in Colorado municipal governance during downturns. The rule releases automatically when reserves recover above the threshold.

Contingency treatment. Consistent with the deterministic tables (see T6), operating and roads contingency budgets are treated as capacity against uncertainty. Expected use is calibrated to 45% baseline, rising toward 100% under high-stress macro conditions (formula: use rate = min(1.0, 0.4 + 0.4 × max(0, macro factor))). Unused contingency remains as fund balance.

Bond and capital assumptions. The one-time 2029 bond issuance ($16M revenue) and corresponding deferred-repairs capital outlay ($15.725M expense) are held constant across all simulations. Annual road debt service (~$1.23M/year from 2029 onward) is also held constant, reflecting its status as a fixed contractual obligation once bonds are issued.

Results (Year-End Cumulative Reserves in 2040)

Multi-Year Risk Metrics

Interpretation

• The median simulation result closely aligns with the deterministic baseline, indicating the model is well-centered. The slight rightward skew in the mean vs. median reflects lognormal upside asymmetry.
• In approximately 95% of simulated scenarios, year-end 2040 reserves exceed $1.34 million; in approximately 75% of scenarios, they exceed $4.1 million.
• Cumulative reserves dip below zero at some point in the projection in approximately 3.4% of simulations. In the remaining 96.6% of scenarios, the town maintains positive general-fund reserves throughout — even under multi-year adverse macroeconomic conditions.
• The 5th percentile trough of ~$136K represents the practical downside planning case: in extreme stress scenarios, reserves fall to a low positive value before recovering. The corresponding 5th percentile 2040 endpoint of $1.34M indicates that even severe adverse paths generally recover to a modest positive reserve by the end of the projection period.
• Downside outcomes typically require sustained multi-year revenue contraction combined with elevated expense growth — conditions consistent with recessions deeper and longer than any Colorado municipality has experienced since the early 1980s.

The results demonstrate that the proposed tax structure, combined with the operating model described in this pro forma and standard reactive fiscal-management practices, remains structurally durable under a wide range of adverse economic conditions.

---

Limitations

This pro forma is a planning-level feasibility model and is not intended to predict exact future outcomes. Actual revenues and expenditures will vary based on economic conditions, reassessments, negotiated service contracts, grant awards, and policy decisions made by future elected officials.

Downside Sensitivity

The largest structural risk factors in the model are:

• Sales and use tax performance
• Grant revenue variability
• Property valuation growth
• Final negotiated service contract costs
• Borrowing rate at time of bond issuance

The Break-Even Sensitivity analysis above shows that cumulative reserves remain positive under substantial permanent shifts in individual revenue or expense variables (approximately −20% permanent sales tax decline, or +24% permanent operating expense increase, before the general fund reserve would be exhausted). The Monte Carlo analysis above extends this to correlated multi-year stress, showing approximately 3.4% probability of cumulative reserves dipping below zero at any point in the projection period under simulated adverse macroeconomic conditions.

If specific revenue categories (e.g., grants or marijuana tax) underperform expectations, the budget structure provides adjustment capacity through non-essential programs, capital timing, and accumulated reserves (see T14). The ongoing roads-reinvestment set-aside within the Ongoing Road Maintenance line also provides discretionary flexibility: future Town Councils could defer a portion of the annual set-aside in a severe downside scenario, at the cost of extending the reinvestment cycle.

---

Structural Conclusion

Under the modeled tax structure and stress-tested assumptions, the proposed Town of Niwot budget demonstrates structural durability — defined as the ability to fund core operations and modeled road debt service without recurring deficits across a wide range of economic conditions.

Policy decisions, service levels, and capital priorities will ultimately be determined by future elected officials and voters. This document is intended solely to demonstrate fiscal feasibility under conservative planning assumptions.

---

Appendix B — Urban Renewal Authority / Tax Increment Financing Statutory Requirements

This appendix provides the detailed statutory requirements referenced in Table Note T14.

Establishing an Urban Renewal Authority (URA) with Tax Increment Financing (TIF) under the Colorado Urban Renewal Law (CRS 31-25-101 et seq.) requires:

1. A governing body resolution adopting a blight finding based on a minimum of four of eleven statutory factors defined in CRS 31-25-103.
2. Submission of an urban renewal impact report to the board of county commissioners and overlapping taxing entities at least 30 days prior to a public hearing on the plan (CRS 31-25-107(3.5)).
3. Negotiation of TIF-sharing agreements with affected special districts (school, fire, library, etc.), which under 2015–2016 statutory reforms have the right to negotiate directly with the URA before any incremental property tax revenues may be allocated. If no agreement is reached, mediation and related statutory constraints apply.
4. Governing body approval of the urban renewal plan, which must conform to the municipality’s general plan.

TIF allocation of incremental property taxes is limited to a period not to exceed 25 years from plan approval. A limited statutory exception exists (CRS 31-25-107(9)) allowing extension if bonds secured by TIF revenue are in default or other qualifying conditions apply; this exception does not affect the general planning assumption.

---

Appendix C — Remote / Online Sales Tax Benchmark Analysis

Purpose

To validate the pro forma estimate of remote (non-local) taxable sales using comparable Front Range municipalities.

Because modern municipal sales tax systems operate under Colorado’s destination-based tax structure, remote and marketplace-facilitated transactions represent a significant portion of local revenue. The following analysis benchmarks Niwot’s per-capita remote taxable sales assumption against comparable towns.

Benchmark Selection

Louisville was selected as a primary benchmark because it is a Front Range municipality with a largely residential profile and an income level that is materially closer to Niwot than many smaller nearby towns. Since destination-sourced / remote taxable sales are driven heavily by household purchasing power and modern delivery-based consumption (online purchases, delivered goods, and contractor services), income similarity is a relevant benchmarking variable. Lyons was included as a smaller-town anchor. Using both towns brackets Niwot across purchasing power and community scale; the Niwot model is positioned conservatively within that demonstrated band and below the higher observed benchmark.

In the ACS 2024 5-year data, Niwot’s median household income is ~$146K and Louisville’s is ~$147K, while Lyons is ~$123K. Per-capita income shows the same pattern: Niwot ~$85K, Louisville ~$71K, Lyons ~$59K.

Table C-1: Remote Taxable Sales — Regional Comparison

Remote taxable sales per capita were derived from municipal revenue categories explicitly labeled by the respective jurisdictions as destination-sourced or non-local sales (e.g., “outside city” in Louisville and “non-local internet/remote” in Lyons). For each benchmark municipality, we used the jurisdiction’s own reported sales-tax categories that isolate destination-sourced (non-local) taxable sales; Niwot’s modeled figure is aligned to that same concept, not to total taxable sales. These categories are reported within the municipalities’ sales tax reporting framework and do not include motor vehicle use tax. Because reporting conventions still vary between jurisdictions, the benchmark should be interpreted as a directional validation of magnitude rather than a category-identical reconciliation.

Niwot’s modeled remote taxable sales per capita is set at ~87% of Louisville’s observed level.

Data sources. Revenue figures for Louisville and Lyons were obtained directly from the respective municipal governments and are not published online. Underlying reports are available upon request from the Niwot Incorporation Committee. Population figures are based on U.S. Census Bureau estimates; per capita income figures are derived from ACS 2024 5-year estimates.

Observations

1. In primarily residential communities (Louisville, Lyons), remote taxable sales range between approximately $11,700 and $14,700 per resident annually.
2. Niwot’s modeled assumption of $12,777 per resident falls within the observed range for comparable residential municipalities.

Table C-2: Niwot Remote Sales Sensitivity Comparison

Metric	Budgeted Model	Louisville Benchmark Equivalent
Per Capita Remote Sales	$12,777	$14,724
Population	4,305	4,305
Total Remote Taxable Sales	~$55,000,000	~$63,400,000
Revenue @ 2.5%	~$1,375,000	~$1,585,000

Fiscal Positioning

The Niwot model assumes a remote taxable sales figure modestly below Louisville’s observed level, placing it above Lyons, below Louisville, and within the demonstrated regional band. This positioning places Niwot within the observed regional range for predominantly residential municipalities and below the highest comparable benchmark, providing modest conservatism relative to the upper bound of observed performance.

Structural Considerations

• Niwot’s per capita income exceeds that of both benchmark communities. While income alone does not determine remote purchasing behavior, it provides context that the modeled per-capita figure is not inconsistent with observed spending levels in similarly affluent residential municipalities.
• Niwot’s commercial base is predominantly neighborhood-scale, suggesting that destination-sourced transactions represent a structurally meaningful share of total taxable sales.
• Remote sales generate municipal revenue without corresponding retail corridor infrastructure obligations.

Because municipal reporting conventions differ — particularly between state-collected statutory municipalities and self-collecting home-rule jurisdictions — the benchmark analysis is intended to validate that the Niwot assumption falls within a demonstrated regional band rather than to imply exact equivalence in reporting categories.

---

Appendix D — Peer General Fund Benchmark

Purpose

To validate that the pro forma’s modeled General Fund revenue per resident, and the resulting funds available after public safety, fall within the demonstrated range for comparable small Front Range municipalities.

Benchmark Selection

Four peer towns were selected to bracket Niwot across population, commercial profile, and public safety delivery model:

• Lyons (~2,155 residents) — smallest peer; contracts public safety with the Boulder County Sheriff’s Office (the same arrangement modeled for Niwot).
• Eaton (~5,839 residents) — closest in population to Niwot; operates its own police department.
• Berthoud (~12,411 residents) — contracts public safety with the Larimer County Sheriff’s Office; representative of a small-town contract-services model at larger scale.
• Firestone (~19,200 residents) — operates its own police department; representative of a larger statutory-town General Fund profile.

Lafayette and other larger municipalities were excluded as their scale, commercial base, and in-house fire/ambulance services make per-resident comparison structurally non-comparable to a small statutory town.

Chart: General Fund per Resident — Peer Comparison

Peer figures from each town’s most recent published ACFR or budget (Eaton, Firestone: FY2024; Berthoud, Lyons: FY2023). Niwot reflects modeled FY2029 (first full operating year) deflated to 2024 dollars at the pro forma’s escalation rates (3%/year general; 4%/year public safety per Section A3) to align with peer fiscal year.

Table D-1: Per-Resident General Fund Comparison

† Niwot figures are FY2029 modeled (first full operating year), deflated to 2024 dollars using the pro forma’s escalation assumptions: general revenue and expenses at 3%/year (÷ 1.03&sup5; = 1.159); public safety at 4%/year 2026–2029 then 3%/year (÷ 1.04³ × 1.03² = 1.193). Nominal 2029 values: $1,040 GF/resident, $104 PS/resident, $936 net of PS/resident.

Methodology Notes

• General Fund only. Figures reflect General Fund revenue and expenditures only. Enterprise funds (water, sewer), capital project funds, and restricted special revenue funds are excluded from both sides.
• Public safety scope. “Public Safety” reflects the police line within the General Fund (own-department operating expenditures) or the sheriff contract line (for contract-services towns). Fire protection is provided by separate special districts in all five towns (including the proposed Town of Niwot) and is therefore not included in any municipal GF figure. Lafayette, which provides fire/ambulance through its General Fund, was excluded from the peer set on this basis.
• Year alignment. Eaton and Firestone use FY2024 audited actuals. Berthoud and Lyons use FY2023 audited actuals (most recent finalized at the time of analysis; FY2024 figures in their published 2025 budgets are budget/estimate rather than audited). The two-year spread is small relative to the per-resident differentials shown.
• Niwot deflation rationale. The pro forma is anchored in 2026 dollars and escalated forward per Section A3. To align with peer fiscal years, Niwot’s 2029 modeled values are deflated using the pro forma’s own escalation rates. This recovers the underlying calibration assumption (which itself was derived from current-period peer data) and removes the visual distortion that would otherwise overstate Niwot’s position by ~16%.

Observations

1. Niwot’s modeled General Fund revenue per resident ($897 in 2024 dollars) falls within the observed peer range ($823 – $1,562), positioned conservatively in the lower half of the distribution.
2. Niwot’s modeled public safety cost per resident ($88) is the lowest in the peer set, reflecting the sheriff-contract model at 2.0 FTE. The closest peer is Berthoud at $150/resident (also a sheriff contract, at larger population). Both contract-services towns spend materially less per resident on public safety than the towns operating their own departments.
3. After public safety, Niwot’s available General Fund per resident ($810 in 2024 dollars) is within the demonstrated peer range ($459 – $1,345), placing it in line with Firestone ($864) and modestly below Berthoud ($954).
4. The two towns that use the sheriff-contract model (Berthoud, Lyons) retain the largest share of GF revenue after public safety, suggesting the modeled Niwot approach is structurally consistent with peer experience.

Data Sources

• Lyons — 2025 Annual Budget (lyonscolorado.com), incorporating FY2023 actuals.
• Eaton — Town of Eaton 2024 Financial Statements (eatonco.org).
• Berthoud — 2024 Adopted Budget and 2025 Adopted Budget (berthoud.org), incorporating FY2023 actuals.
• Firestone — Town of Firestone 2024 ACFR (Colorado state-published audits).
• Niwot — This pro forma, Sections A1 (population), A3 (escalation), R‐series (revenue), and E3 (Sheriff contract).
• Population figures from U.S. Census Bureau most-recent estimates (Niwot via Boulder County 2024 incorporation-area count).