Town of Niwot — Pro Forma Budget & Financial Assumptions

Prepared by the Niwot Incorporation Committee

Version 1.8 — September 21, 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.
1.6	September 14–15, 2026	Expense lines named, at no net cost. Materials Costs is reduced from $100K to $18K and restated as a general operating allowance, with an explicit list of what it does not cover because those costs are funded elsewhere. It had carried no unit basis, and its stated rationale — “deferred infrastructure needs and startup provisioning” — did not survive inspection. The reduction funds three functions earlier versions left inside undifferentiated lines: Planning and Zoning Services ($52K), budgeted separately from the Building Department; Codification and Legal Notices ($15K), for code supplements and the statutory publication of ordinances and notices; and IT support, raising IT from $30K to $45K, the prior figure having covered software only. Net change to every total, in every year: $0. Downtown fund consolidated. “Events and Beautification” and “Downtown improvements” are combined into Downtown, Events and Marketing and footnoted at E10a. The two were always the replacement for the Local Improvement District but were split with no stated reason. The line is set at the LID’s adopted 2026 budget of $199,742 plus approximately $50,000 for scope beyond the LID boundary. E10a publishes the LID’s program by category, an illustrative town-wide allocation, and the fact that its administrative coordination is absorbed by Town staff. Combined total unchanged in every year. Sensitivity Analysis corrected. The Downside Sensitivity paragraph carried pre-v1.5 break-even thresholds (−13% sales tax, +15% operating expenses) contradicting the Break-Even table in the same document (−19.8% and +24.3%); the table was correct. The same paragraph described the Monte Carlo rerun as “in progress” after it had been completed and reported. Added a compensation reading of the operating-expense threshold: compensation is approximately 68% of operating expenses, so every compensation line would have to be understated by approximately 33% before reserves would be exhausted. That figure was first published as 35%, which omitted the contingency that scales with operating expenses. SAFEbuilt proposal reconciled. R11 and T11 stated permit revenue of “approximately $180,000” with “~$27,000” retained. Option 1, which this pro forma models, states $171,125 and $25,669; the prose ran 5.2% high. No budget table was affected. R11 now also records the alternative fee schedule, the permit software included at no cost, and that initial code adoption support is priced by negotiation. E3a’s scope claim now cites the proposal’s scope of work directly. Also. E7 described $30K as the “midpoint” of the $20–40K benchmark range; it is the floor. R8 is expanded — the programs an incorporated town would be eligible for, the DRCOG Boulder County Subregional Forum and its municipal-membership requirement, comparable awards, who pursues grants, local match, and how the revenue appears in this pro forma. LID reserves in T2 are updated from approximately $400,000 to approximately $515,000 per the LID treasurer. Published incrementally over September 14–15 and consolidated into a single entry.
1.7	September 21, 2026	The paper now says where its numbers come from. No figure in any budget table moves. R10 rewritten and renamed “Municipal Fees.” The line previously read “Utility and Franchise fees, other fees” and was footnoted only as “approximately $75,000 annually based on comparable municipalities,” naming no comparables and bundling three unrelated revenue sources. The replacement publishes a derived composition, an identified capacity range of $100,000–$143,000 against a modeled $75,000, and how the line would be wrong if the hauling assumption fails. The old label implied a utility franchise fee billed to households; R10 now states explicitly that none is assumed and that the published household cost figures contain none. TABOR emergency reserve disclosed. T9 now records the Art. X § 20(5) reserve requirement — approximately $100,000 on 2030 figures — and that TABOR’s definition of emergency excludes revenue shortfalls, so the reserve is legally unavailable for the scenarios stress-tested here. Monte Carlo parameter set published. Monte Carlo gating defect corrected. The reactive-council rule is gated to 2028 and later; it previously fired off the 2027 transition balance. Residential growth sourcing corrected. A3 described 4.4% as a 20-year Front Range CAGR; the underlying source is the Case-Shiller Denver index, which has compounded at 5.39% since 1989 and 4.55% since 2000. The modeled rate is below both. R1 cross-references A3 and cites the published research behind the post-incorporation growth adjustment, including a study finding the opposite sign. Net contribution corrected. T8 and the Net Contribution footnote described 2030–2032 as single-year deficits; those figures predate the v1.5 restructure and contradicted the Net Contribution row in the same document. Every year from 2028 onward is a surplus as modeled.
1.9	September 29, 2026	Building Department coupling defect corrected; no budget table changes. Building Department Services is 85% of Building Department Permit Fees by contract. Versions 1.8 and earlier applied the general +4%/1σ expense shock to it, so the simulation reduced permit revenue in a downturn and raised the contractor’s fee at the same moment — billing the Town for both sides of a contractually fixed ratio. The Shock Framework now states the carve-out and the model applies it. The probability of cumulative reserves falling below zero at any point moves from 2.58% to 1.93%, and distribution figures are restated accordingly: mean $6,699K, median $6,508K, 5th percentile $1,528K, median trough $2,017K, 5th percentile trough $294K. Every figure moves in the Town’s favour; there is no line in the model where correcting this defect makes the projection worse. The defect was published in the companion stress-testing analysis on September 19 together with a decision not to act on it before the election, on the grounds that the rebuilt model was a reconstruction rather than the published model. Version 1.8 adopted the rebuilt model as the published model two days later, which removed that reason. Residential assessment rate description corrected: versions 1.8 and earlier described the modelled 6.7% as “a rounded midpoint of the current statutory range.” It is the lower of the two rates the statute provides for tax year 2026 — the floor, and the conservative choice for revenue. The rate itself does not change. No revenue, expense or reserve figure in any budget table changes in this version.
1.8	September 21, 2026	Monte Carlo results restated; no budget table changes. The stress test published in version 1.7 and earlier reported a 3.42% probability of cumulative reserves falling below zero at any point in the projection. That simulation’s parameters were not retained, so the figure could not be regenerated, re-run under a scenario, or checked by a reader. The model has been rebuilt from the Shock Framework this document describes, its full parameter set is published in the Sensitivity Analysis, and it reports 2.58%. Distribution figures are restated accordingly: mean $6,741K, median $6,524K, 5th percentile $1,431K, median trough $2,004K. The rebuilt model runs approximately 0.8 percentage points more optimistic in the tail than the figure it replaces. Adopting it was not a close call: a figure that cannot be regenerated cannot be defended, and the same model now produces every scenario in the companion stress-testing analysis. No revenue, expense or reserve figure in any budget table changes in this version.
1.10	September 29, 2026	Business Personal Property sourced to the county roll; no budget table changes. R1’s BPP paragraph asserted "approximately $13.1 million ... which generates approximately $13,000 per year ... at 4 mills" and cited nothing. Those two clauses are consistent only if $13.1 million is an actual value ($13.1M x 25% x 4 mills = $13,100); read as an assessed value it would yield $52,400. The ambiguity had propagated: the committee’s neighborhood road-district worksheet carried $13.1 million as an assessed value, 4x too large, which inflated the townwide district tax base and made a parcel-base cross-check appear to pass. Boulder County’s certified tax year 2025 roll settles it — $11,988,368 actual, $3,217,426 assessed — confirming the actual-value reading and the $13,000 figure. Separately, the modeled base is now known to be low. The Assessor’s address-keyed search omitted four accounts worth $6,488,873, including a $5,132,138 measuring-and-controlling-devices account at 7477 E Dry Creek Parkway; the county’s preliminary 2026 roll for both parks is $20,646,428 actual / $5,368,101 assessed, about $21,500 a year against the $13,000 modeled. The line is not revised upward — the difference is 0.2% of 2028 revenue, the base is volatile, and the underlying accounts depreciate. R1 now states the county figure, the modeled figure, and why they differ. Scope corrected from "Niwot Tech Center" to both commercial parks, and non-park BPP (about $2,450 a year) named as unclaimed.
1.11	October 2, 2026	Lyons benchmark measured on the full 2025 year; no budget table changes. Appendix C’s comparison of the Lyons rate against the Town’s own figures had rested on ten months of 2025 and an annual total that turned out to be the Town’s 2024 figure. On the full year, from the Town’s April 2026 finance update ($2,232,733 in sales tax at 4.0%, 47.2% non-local, weighted month by month), Lyons’ non-local sales are $12,382 per resident, and the $11,768 used here is conservative by 5.0% rather than 4.3%. The figure in the benchmark table is unchanged.
1.12	October 8, 2026	Road & Bridge corrected to the statutory 50% share; budget tables change. R6 computed Niwot’s full proportionate share of the county’s Road & Bridge levy. CRS 43-2-202(2) entitles a municipality to fifty percent of it. The line is restated at 50% of the current 0.176 mill levy (Boulder County Resolution 2025-059; versions 1.11 and earlier used 0.167): $32K → $17K in 2028 and $46K → $24K in 2040. Total revenue falls $15K–$22K a year, and 2040 cumulative reserves fall from $6,849K to $6,613K. 2030, previously the tightest year at +$12K, becomes a −$4K year, so the statement that every year is a surplus is corrected; cumulative reserves remain positive and at least 8.9× the GFOA two-month minimum in every year. Monte Carlo rerun on the corrected tables: probability of reserves below zero at any point 1.93% → 2.15%; median 2040 reserves $6.51M → $6.28M; 5th percentile trough $294K → $262K. Break-even sales tax decline −19.8% → −19.1%. Also corrected: the GFOA multiple was stated as 6× to 15× in the summary and 6× to 10× in C4; it is 9× to 16×. The Monte Carlo fan chart, which still plotted the version 1.7 simulation, is redrawn from the current model. No conclusion of this document changes.

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)
  • Contracted planning and zoning services (zoning administration, development review, Planning Commission support)
  • 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 an annual surplus in every year of operations except 2030, which draws approximately $4K on a $2.8M reserve.
• Startup surpluses in 2028 (~$2.4M) and 2029 (~$0.7M) establish the general fund reserve; the tightest year is 2030, at approximately −$4K — effectively break-even — as the full roads commitment ramps up, with surpluses growing steadily thereafter.
• General fund cumulative reserves reach approximately $6.61 million by year-end 2040, with the minimum at approximately $2.18M in 2028 (post-startup); they are flat across 2029–2030 and grow every year from 2031.

Stress-testing and resilience:

• Cumulative reserves stay well above the GFOA-recommended two-month operating minimum throughout the projection period, ranging from approximately 9× to 16× that minimum.
• Break-even thresholds (permanent shifts required to push cumulative reserves negative at any point 2028–2040): sales tax approximately −19%, property tax approximately −45%, operating expenses approximately +23%, ongoing road maintenance approximately +37%.
• Monte Carlo stress testing (100,000 simulations against the updated model) shows median 2040 reserves of ~$6.28M, 5th percentile of ~$1.44M, and approximately 2.15% 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 −$4K — effectively break-even. Beyond the 6.75% expected-use operating contingency already budgeted ($120K in 2030), a further 8.25% of core opex is retained as fund balance under GFOA best practice; that unspent capacity covers the $4K draw many times over.

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) held approximately $515,000 in reserves as of 2026, per the LID treasurer 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. On why proceeds exceed the $15 million authorization, see issuance premium.

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, 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. As modeled, every year from 2028 onward is a surplus except 2030: the 2029 partial-year and startup structure produces large surpluses in 2028–2029, the net contribution falls to −$4K in 2030 as the full roads commitment comes on line, and surpluses widen again from 2031 onward. Cumulative reserves are positive in every year.

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; from 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.61M as of v1.12. 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.

TABOR emergency reserve. Article X, Section 20(5) of the Colorado Constitution requires the Town to maintain an emergency reserve of 3% or more of fiscal year spending excluding bonded debt service — approximately $100,000 on 2030 figures. TABOR defines “emergency” to exclude economic conditions, revenue shortfalls, and salary or benefit increases, so this reserve is legally unavailable for the adverse scenarios the stress testing below models. It is a first claim on cumulative reserves rather than a buffer within them, and the balances shown in these tables should be read as including it.

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 $171,125 in base-year dollars, per Option 1 of the SAFEbuilt proposal (2024 IRC Appendix AB fee schedule). SAFEbuilt retains 85% of permit revenue as its service fee and the Town retains approximately $25,700 (15%). See R11 for the alternative fee schedule the proposal offers. 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. The Downtown, Events and Marketing line is discretionary. This line represents discretionary quality-of-life, promotional and place-making programs that may be adjusted by future elected officials based on budget priorities. It is set at the Local Improvement District’s adopted 2026 budget of $199,742, which serves the Second Avenue commercial district, plus approximately $50,000 for scope beyond the LID boundary. See E10a for the LID’s current program and an illustrative town-wide allocation. 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 4.4% annually. The S&P CoreLogic Case-Shiller Home Price Index for Denver has compounded at 5.39% annually since August 1989 and 4.55% annually since January 2000, measured to August 2025; the national index returns 4.15% and 4.77% over the same two windows. The modeled 4.4% is below both Denver figures, over windows that each include the 2007–2011 decline.
• 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 is the lower of the two rates the statute provides for tax year 2026, not a midpoint between them. Modelling the lower rate understates property tax revenue relative to the alternative scenario, which is the conservative direction for a feasibility projection. Correction to prior versions: versions 1.8 and earlier described 6.7% as “a rounded midpoint of the current statutory range.” It is the floor of that range.
• Market value growth assumed at 4.4% annually.
• Boulder County reassessment occurs every two years; model reflects this cycle.
• A post-incorporation growth adjustment is also applied; see A3. It is supported by Patrick and Mothorpe (2017), “Demand for new cities: Property value capitalization of municipal incorporation,” Regional Science and Urban Economics 67(C):78–89, which finds that property values inside seven newly incorporated metro Atlanta cities rose 4–5% in the two years following incorporation and 12–13% over the full analysis period, with the effect strongest where values inside the boundary were high relative to the surrounding unincorporated county. The effect is not universal: Hodges and Stephens (2022), Growth and Change 53(1):200–220, find generally negative capitalization across four incorporations in Riverside County, California. This pro forma does not rely on the adjustment; see A3 and the stress testing of the property tax base.

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 of Business Personal Property — the equipment, fixtures and machinery that Colorado businesses declare annually to the County Assessor. That $13.1 million is an actual value, not an assessed one: at the 25% nonresidential assessment rate it contributes roughly $3.3 million of assessed value and approximately $13,000 per year at 4 mills. Businesses whose declarable assets fall below the statutory exemption — $56,000 of actual value — are assessed at zero and pay none of it. BPP is redeclared every year and moves with equipment purchases and depreciation schedules.

The modeled figure is below the county’s current roll, and is deliberately not revised upward. Boulder County’s preliminary tax year 2026 roll records 16 accounts in the Dry Creek Parkway and Monarch Park commercial areas carrying $20,646,428 of actual value and $5,368,101 of assessed value — about $21,500 a year at 4 mills, against the $13,000 modeled here. This pro forma continues to model the lower figure, for three reasons. The difference is approximately $8,400 a year, 0.2% of 2028 revenue, and changes no conclusion in this document. BPP is volatile: a single food-production line installed at one Horizon Lane address accounts for 12% of the 2026 base. And the underlying accounts depreciate — excluding that one addition, the same accounts fell 2.3% year over year. Booking a volatile line at its current peak would not be conservative.

Scope. Versions 1.3 through 1.9 described this line as located in “the Niwot Tech Center.” The accounts span both commercial parks — Dry Creek Parkway and Monarch Park Place / Horizon Lane. Business personal property elsewhere inside the proposed boundary, principally downtown, is not included in the modeled base: the county roll shows about $613,000 of assessed value across the other tax areas covering the community, worth at most $2,450 a year. That is an upper bound, because those tax areas extend past the proposed boundary and BPP accounts carry no parcel number that would allow them to be allocated to it precisely. This pro forma claims none of it.

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

A municipality is entitled by statute to half of what the county’s Road & Bridge levy raises on property inside its boundaries. CRS 43-2-202(2) provides that each municipality “is entitled to receive from the county road and bridge fund of the county wherein it is located an amount equal to fifty percent of the revenue accruing to said fund from extension only of the levy authorized to be made under section 43-2-203 against the valuation for assessment of all taxable property located within its corporate boundaries.” Boulder County’s Road & Bridge levy is 0.176 mills for tax year 2025 (Resolution 2025-059).

Formula:
Niwot Assessed Value × 0.176 mills × 50%.

Estimated 2025 revenue: ~$15,600.
Inflated to 2028: ~$17,000.

Correction: versions 1.11 and earlier computed this line as Niwot’s full proportionate share of the county’s Road & Bridge revenue, at an earlier 0.167 mill levy — ~$29,600 in 2025 and ~$32,300 in 2028 — and did not apply the statute’s 50% apportionment. The Town of Lyons’ adopted budgets record county Road & Bridge receipts above the statutory formula; this pro forma books only the statutory entitlement.

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

This pro forma models a town. Most of the programs below are open to incorporated municipalities and not to unincorporated communities. Grant revenue is therefore not money Niwot is currently declining to pursue; it is money Niwot is not presently eligible to pursue, and which becomes available on incorporation.

Primary channel: DRCOG. The Denver Regional Council of Governments is the metropolitan planning organization that distributes federal transportation funding through a Transportation Improvement Program covering four-year cycles. Allocation within Boulder County runs through the Boulder County Subregional Forum, whose members are Boulder County and the DRCOG-member municipalities within it: Boulder, Erie, Lafayette, Longmont, Louisville, Lyons, Nederland and Superior. Participation requires DRCOG membership, and the forum’s rules provide that only projects approved by local elected officials are eligible. Niwot, having neither municipal status nor an elected body, is not a member and cannot apply.

Subregional funds are allocated to each of the eight county-level subregions in proportion to that subregion’s share of the region’s population, employment and vehicle miles traveled. Amounts available to the Boulder County subregion in recent calls, as published by the Forum: approximately $16.85 million for 2022–2025 against $21.46 million in requests, and approximately $19.1 million for 2024–2027 ($8.33 million air quality and mobility funds, $10.75 million Surface Transportation Block Grant funds).

Timing. Per DRCOG’s adopted 2026–2029 program, calls for projects are held every four years while a new TIP is adopted every two. The most recent call accompanied development of the 2024–2027 program; the current 2026–2029 TIP was adopted without a call, with most prior projects rolling forward. The next call accompanies the 2029–2032 program, policy development for which began in 2026. That is the first cycle for which a town incorporated in 2027 or 2028 could submit projects, and it aligns with the years in which this pro forma begins modeling grant revenue.

Awards to Forum members give the scale of a single project:

Recipient	Approx. population	Award
Nederland	~1,500	$1.5 million — sidewalk and multimodal improvements (2019)
Louisville	~21,000	$2.48 million — Via Appia Way improvements
Boulder County	—	$3.5 million — SH-119 bikeway
Boulder	~108,000	$800,000 — 30th Street improvements

Nederland’s population is roughly a third of Niwot’s, and a single award of that size annualizes to approximately $375,000 per year across a four-year cycle.

Secondary programs. Additional programs for which an incorporated Niwot would be eligible include GOCO Community Impact (parks, trails and outdoor recreation; awards $100,000–$2,000,000), CDBG Public Facilities through DOLA/HUD for non-entitlement municipalities under 50,000 population (water and sewer systems, streetscape improvements, community facilities), CDOT’s Transportation Alternatives Program (pedestrian and bicycle facilities, 20% local match, three-year call cycle), CDOT Safe Routes to School, and DOLA’s Energy/Mineral Impact Assistance Fund (Tier I up to $200,000, Tier II $200,000–$1,000,000), though EIAF prioritizes communities affected by energy and mineral development and Niwot’s eligibility there may be limited. These programs do not fund routine pavement maintenance — crack seal and surface treatment are general-fund and Highway Users Tax Fund work, and are budgeted as such in Roads Expenses.

What grants would actually fund. What these programs do fund is deferred safety and connectivity infrastructure, and Niwot’s backlog of exactly that is both substantial and unusually well documented: the CO 119 and Niwot Road intersection, which CDOT data place at the second-highest bicyclist crash rate in Boulder County and where at least three people have been killed; the absence of a funded connection into the regional bikeway constructed along Niwot’s western edge; the BNSF underpass identified in the 2025 Master Plan as the community’s most pressing connectivity problem; and sidewalk defects on Second Avenue that have gone unrepaired for years. The federal Safe Streets and Roads for All program, which made approximately $993 million available in FY2026, requires applications to be tied to a documented roadway safety problem and is open to political subdivisions of a state — to towns, and not to unincorporated communities applying on their own behalf. The condition that makes this infrastructure a liability today is the same condition that would make it competitive for these programs.

The modeled assumption. No grants in 2028; $270,000 per year beginning in 2029. This represents one successful mid-range application per year, annualized. Two things about that are worth stating plainly. First, actual awards are lumpy and project-based, not annual: a town does not receive a similar sum each year, it receives a larger sum occasionally and nothing in between, and the model smooths that. Second, the figure is assumed in every year of the projection from the first full operating year onward, for a town that will have no grant-making record and will compete within its subregion against Boulder, Longmont and Louisville, which have dedicated staff.

How this revenue appears in the pro forma. The projects described above are not carried as expense lines here. The Roads Expenses section budgets pavement rehabilitation, ongoing maintenance, snow removal and traffic devices; it does not budget a BNSF underpass, a connection into the regional bikeway, or a reconstruction of the CO 119 intersection. Any one of those would be a multi-million-dollar capital project requiring its own funding plan and, depending on structure, its own voter authorization. Grant revenue therefore appears on the revenue side of this pro forma without a matching project expense, and accumulates within cumulative reserves rather than showing as project spending. Cumulative reserves consequently include restricted funds, as noted in T9. A future Town Council that pursued and won such a project would show both the award and the project cost in its adopted budget, and the effect on fund balance would be substantially smaller than the revenue line alone suggests.

Who pursues grants. Grant identification, application and administration are functions of the Town Manager, supported by the Town Attorney where a grant agreement requires review and by contracted planning or engineering services where an application requires technical scope. The $270,000 estimate assumes one successful application per year. No separate grant-writing position is modeled; a town pursuing substantially more than one application annually would need to add that capacity.

Local match. Several of these programs require a local match — CDOT’s Transportation Alternatives Program at 20%, with requirements varying by program and funding round elsewhere. No separate matching-funds line is carried in this pro forma. The assumption is that a match for a capital project would be met from the relevant capital or program line, or from reserves. If a future Town Council pursued match-heavy awards without corresponding capital budget, the effect in the year of award would be to convert grant revenue into a net cost.

If none of it arrives. Grants are not guaranteed, and this pro forma does not depend on them. The Break-Even Sensitivity analysis shows that complete elimination of grant and Conservation Trust Fund revenue would not exhaust reserves: cumulative reserves trough at approximately $1.37 million in 2036 and end 2040 at approximately $1.88 million, remaining above the GFOA two-month operating minimum throughout. Grant revenue is not relied upon to fund core public safety or required operating services, and unawarded projects would be deferred or funded through alternative means.

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. Municipal Fees

Assumed at approximately $75,000 in 2028, escalating with inflation. This line aggregates ordinary fee revenue available to a Colorado statutory town. It does not assume any particular instrument; which instruments a town adopts, and at what rates, are decisions of a future elected Town Council.

Instruments available. A town may franchise solid waste collection, adopt business and liquor licensing, retain fines from municipal ordinance violations, and enter a utility franchise agreement for electric and gas service. Together, at conservative rates, these would support roughly $100,000 to $143,000 annually. This pro forma models $75,000 — about half of the identified capacity.

One mix that produces the modeled figure:

Component	Illustrative	Basis
Solid waste franchise	$43,000	7% of gross receipts under a competitively bid exclusive residential collection contract. Adopted rates elsewhere range from 10% to 17% of gross (New Plymouth, Idaho; RecycLA, Los Angeles; Cutler Bay, Florida). At 7% a hauler retains 8–18% against observed residential collection margins of 15–25%.
Municipal court fines	$20,000	Incidental enforcement — downtown parking, animal and code violations, and citations written in the course of ordinary patrol. Roughly 220 citations annually across all categories. Not modeled as a traffic enforcement program.
Licenses and permits	$12,000	Business and liquor licensing. The Town of Lyons budgets $13,000 and $500 respectively for a population of 2,345.

On utility franchise fees. A franchise fee on electric and gas service is collected by the utility as a separate line on each customer’s bill. It remains available to a future Town Council — at 1% of gross it would yield approximately $54,000 and add approximately $1.63 per month to a household utility bill. It is not assumed in the figure above, and the household cost figures published at niwot.town/topics/cost do not include one.

How this line could be wrong. The hauling component is modeled at 7% of gross receipts, below every adopted rate identified above. If an exclusive residential franchise is not available to a Colorado statutory town, that component is replaced by non-exclusive licensing at a lower yield, and the $75,000 line remains covered by the other components together with the utility franchise capacity this pro forma does not assume. Fines reach the Town only for municipal ordinance violations prosecuted in municipal court, which requires adoption of the Model Traffic Code by reference and an intergovernmental agreement with the Sheriff providing for municipal enforcement. The risk to this line is that it is composed differently, not that it is smaller.

R11. Building Department

Building department services are based on a Statement of Qualifications prepared by SAFEbuilt (February 19, 2026), a Colorado municipal contractor providing contracted building department services to municipalities throughout the state. The scope of work is a full-service building department comprising Building Official services, inspection services (building, electrical, plumbing, mechanical and energy), plan review across construction disciplines, and permit technician services. CommunityCore permit software is included at no cost under a full-service contract.

The proposal presents two fee-schedule scenarios. This pro forma models Option 1, the 2024 IRC Appendix AB fee schedule: projected annual permit revenue of $171,125 in base-year dollars, of which SAFEbuilt retains 85% as its service fee and the Town retains approximately $25,700 (15%). Option 2, benchmarked to the Boulder County fee schedule, projects $198,875 in permit revenue on a 70/30 split, returning approximately $59,700 to the Town — roughly $34,000 per year more. Option 1 is modeled because it is the more conservative of the two. Adopting Option 2 would be a decision of a future Town Council and would improve the General Fund position relative to this model; that difference is unreconciled headroom, not an error.

The Building Department is net-positive to the Town’s General Fund by design under either option.

Initial building code adoption support is offered with pricing to be negotiated and is not modeled here. Future code adoptions are included at no additional cost under a full-service contract.

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.

E3a. Planning and Zoning Services

Planning and zoning is modeled as a contracted function, budgeted separately from the Building Department line. SAFEbuilt’s Statement of Qualifications for Niwot (February 19, 2026) defines its full-service scope of work as four services: Building Official, inspection services, plan review across construction disciplines, and permit technician services. Planning and zoning is not among them. SAFEbuilt does offer Planning and Zoning as a service line and itemizes it separately in its Colorado engagements — Northglenn, Fort Lupton, Carbondale, Dolores and Frisco among them — which establishes that its absence from the Niwot scope is a scope boundary rather than a gap in the write-up. Versions 1.2 through 1.5 renamed the former “Planning Department” line to “Building Department”; this line budgets the planning function explicitly rather than leaving it unnamed.

Basis, and its limits. The figure is constructed, not quoted: approximately 325–370 hours per year of contracted planner time at an assumed $140–$160/hour, producing a range of roughly $46,000–$59,000, modeled at $52,000 in base-year (2026) dollars and escalated at 3% annually. Both inputs are planning assumptions. The hourly range is a market estimate rather than a figure drawn from a quote or a published contract, and the hours are an estimate of effort rather than a projection from application volume — no count of land use applications, variances, or subdivision filings for the Niwot area informs this line. The work it is meant to cover is dominated by recurring fixed duties — zoning interpretations, Planning Commission agendas and staff reports, code amendments, pre-application meetings — rather than by application throughput.

Cost recovery not assumed. Most Colorado municipalities recover a substantial share of development review cost through applicant fees. No planning application fee revenue is modeled here. To the extent a future Town Council adopts a fee schedule, the net cost of this line would be lower than shown.

How this line could be wrong. The scope question is settled — the function is not covered elsewhere — but the amount is still an estimate, and the likelier error is that it is low. Staffing a Planning Commission alone, at a monthly meeting cadence, plausibly consumes a third to a half of the modeled hours before any other duty is performed, which is why the modeled hours allow for it explicitly rather than assuming the balance covers it, particularly in the first years while a zoning code is being adopted. A planning-services quote would replace this construction with a sourced figure, as R11 now does for the Building Department. The error is absorbed within the 15% contingency: doubling this line is approximately 3% of total operating expenses, well inside the thresholds in the Sensitivity Analysis.

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 software subscriptions, IT support, and compliance, modeled at $45k in base-year dollars and escalated at 3% annually.

Correction to prior versions. Versions 1.5 and earlier described $30,000 as the “midpoint” of a $20,000–$40,000 benchmark range for municipalities of this size. It is the floor of that range, not the midpoint. Benchmark towns at that level typically carry inherited county IT support or a pre-existing service relationship; a newly incorporated town has neither.

Basis. The software stack itemizes to approximately $20,600/year: productivity and email at roughly twelve seats with retention capability sufficient to satisfy CORA obligations (three staff, seven elected officials, and spare capacity), website hosting, accounting, payroll, VoIP, endpoint protection, password management, security awareness training, an annual vulnerability assessment, GIS, and records archiving. Building department software is provided within the SAFEbuilt contract (see R11) and is not duplicated here.

The remaining ~$24,400 funds IT support labor — a part-time position or a managed service provider. No prior version of this pro forma budgeted any IT labor. A three-person office carrying statutory records-retention obligations, with no internal technical staff, cannot operate on software alone.

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.

E8a. Codification and Legal Notices

A newly incorporated town must adopt and maintain a municipal code, and must publish ordinances and public notices as required by statute. Neither cost was carried as a distinct line prior to v1.6.

Initial codification of the municipal code is treated as part of the one-time incorporation cost (see E11). This line covers the recurring obligations: annual code supplements and hosting (~$3,000–$5,000), and statutory publication of ordinances, budget hearing notices, election notices, and land use hearing notices in a newspaper of general circulation (~$8,000–$12,000). Modeled at $15,000 in base-year (2026) dollars, escalated at 3% annually.

E9. Materials Costs

Materials is a general operating allowance for the Town’s own office, not a built-up estimate. It is the line that carries the recurring consumables and small equipment of a three-person administration in leased space: paper, toner and general office supplies; postage and general correspondence; a copier and small office equipment; furniture amortized over its life; letterhead, business cards and the town seal; records storage and filing supplies; meeting and recording supplies. Modeled at $18,000 in base-year (2026) dollars, escalated at 3% annually.

What it does not cover. Most costs that might intuitively be called materials are funded elsewhere and are not duplicated here: street signs, lights and striping are in Roads Expenses (E4c); banners, plantings and event materials are in Events, Marketing and Beautification (E10a); software and computer hardware are in IT (E7); ballots and election printing are in Election Costs (E10); publication of ordinances and hearing notices is in Codification and Legal Notices (E8a); and the building department’s own supplies, mileage, copying and courier costs are inside SAFEbuilt’s all-inclusive fee (R11). What remains is genuinely small, which is why this line is.

Change from prior versions. Versions 1.5 and earlier carried this line at $100,000 with the stated rationale of “deferred infrastructure needs and startup provisioning.” Neither rationale holds on inspection. The Town owns no infrastructure: road capital, ongoing maintenance, snow removal and traffic devices are funded separately in the Roads Expenses section, and the Town holds no buildings, fleet or utility assets. Startup provisioning is by definition one-time, but was carried as a recurring line escalating through 2040. The line also carried no unit basis, unlike every other significant line in this pro forma. The reduction is reallocated to Planning and Zoning Services, Codification and Legal Notices, IT support, and Downtown improvements; total operating expenses are unchanged in every year.

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).

E10a. Downtown, Events and Marketing

This line replaces the Local Improvement District. The LID is a county-administered special district funded by a 1% sales tax on businesses within its boundary, and it funds streetscape improvements, marketing, and economic development for the Second Avenue commercial area. On incorporation the 2.5% municipal sales tax replaces the 1% LID tax, and the functions the LID performs become the Town’s to fund.

What the LID funds today. Its adopted 2026 budget is $199,742, of which $182,307 had been approved as of July 31, 2026. LID sales tax receipts were $252,477 in 2024, the most recent full year reported (see the Business Vitality paper’s LID revenue series); the gap between receipts and adopted budget accumulates as reserves, which stood at approximately $515,000 in 2026 per the LID treasurer.

Category	2026 approved	Share
Community events	$63,855	35.0%
Marketing and promotion	$49,996	27.4%
Streetscape, flowers, maintenance	$44,956	24.7%
Administrative coordination	$23,500	12.9%

The LID reimburses programs brought to it by the Niwot Business Association, the Niwot Community Association and the Niwot Cultural Arts Association; it does not run programs itself.

Basis for $250,000. The LID’s program serves the Niwot Rural Community District — the commercial blocks of Second Avenue. A municipal program serves the whole town and all of its residents. This line is therefore set at the LID’s documented 2026 budget of $199,742 plus approximately $50,000 for scope beyond the LID boundary, rounded to $250,000 in 2028 and escalated at 3% annually. Prior versions of this pro forma pegged the line to the LID’s estimated annual receipts rather than to its adopted budget; the budget is the documented figure and is used here.

Illustrative allocation, not an adopted one. At this level a town-wide program would support approximately the following. This is shown to make the line legible, not to bind anyone: allocation would be determined by a future Town Council and, as under the LID today, by a resident-led body.

	LID 2026	Illustrative at $250K
Community events support	$63,900	$78,000
Marketing and promotion	$50,000	$62,000
Streetscape, flowers, maintenance	$45,000	$70,000
Town-wide beautification and small improvements	—	$40,000
Administrative coordination	$23,500	absorbed by Town staff
Total	$199,742	$250,000

Administration is absorbed rather than duplicated. The LID spends approximately 13% of its program on an administrative coordinator, roughly ten hours a week, because it has no staff of its own. A town with a manager, clerk and deputy clerk absorbs that coordination into existing payroll. The practical effect is that a comparable dollar figure supports more program activity than the LID’s does.

Events remain community-run. Funding a dedicated downtown and community fund does not make the Town the event organizer. Rock & Rails, the holiday parade, the Jazz Festival and similar programming are organized today by the Niwot Community Association, the Niwot Business Association, the Niwot Cultural Arts Association and volunteers, and are expected to continue that way. This line supports that activity rather than replacing it.

Discretionary. See T14. Downtown capital work could additionally be supported through an Urban Renewal Authority and Tax Increment Financing, a separate mechanism from this operating line, discussed in T14 and Appendix B.

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. As modeled, every year from 2028 onward is a surplus except 2030: $2,422K and $664K in 2028–2029 (startup ramp-up and partial-year road debt service), then −$4K in 2030 as the full roads commitment comes on line, then $68K, $114K and widening from 2033 onward. Cumulative reserves are positive in every year of the projection. Correction: versions 1.6 and earlier described 2030–2032 as single-year deficits of approximately $148K, $80K and $39K. Those figures predate the v1.5 restructure and contradicted the Net Contribution row in the same document, which was correct throughout.

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 9× to 16× 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.61 million (v1.12). 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 an annual surplus in every year of operations except 2030. Cumulative general-fund reserves rise from ~$2.18M at end-of-2028 to ~$2.84M in 2029, hold there through 2030, and grow every year thereafter to ~$6.61M by 2040. The tightest year is 2030 (approximately −$4K 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 −$4K — a draw of about 0.1% on reserves. Against it, 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.84M — 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 19% 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 ~23% above modeled levels permanently, and ongoing road maintenance ~37% 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.

What the operating-expense threshold means for compensation. Compensation is the largest component of operating expenses. Payroll and benefits, elected stipends, contracted professional services (attorney, prosecutor, contract judge, auditor), and contracted service labor (Sheriff, building department, planning and zoning, trees and landscaping) together account for approximately 68% of total operating expenses — roughly $1.26M of the $1.84M modeled for 2029. Applying the +23.5% operating-expense break-even to that share, and accounting for the operating contingency that scales with it: every compensation line in this pro forma would have to be understated by approximately 33% — simultaneously, permanently, and across all years — before general fund reserves would be exhausted.

Scope of this figure. It covers compensation carried within Operating Expenses. Road crews — snow removal, street sweeping, and ongoing road maintenance — are budgeted in the Roads Expenses section (see T5 and T7) and are governed by the separate thresholds in the table above; ongoing road maintenance would need to run approximately 37.3% above modeled levels.

That tolerance is wide relative to the uncertainty that actually attaches to these lines. Salary benchmarks, negotiated service contracts, and professional-services rates can each differ from modeled levels by normal market margins without approaching it. The figures in this pro forma are planning estimates, and final costs for every contracted line will be set through negotiation by a future elected Town Council; the structure does not depend on any single one of them being exact.

---

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. One carve-out: Building Department Services is 85% of Building Department Permit Fees by contract (see R11), so it tracks that revenue line rather than taking the expense shock independently. Versions 1.8 and earlier applied the +4% shock to it, which raised the contractor’s fee in the same year the permit revenue defining it fell.

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, Marketing 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. The rule is gated to 2028 and later. 2027 is the transition year and carries a −$244K balance by design, funded outside the general fund per T2; allowing it to trigger the rule would apply a discretionary reduction in 2028 in every simulation and flatter every result reported below.

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.

Parameter Set

The full parameter set is published so that the results below can be regenerated from the budget tables in this document by anyone who wishes to check them.

Parameter	Value
Simulations	100,000
Macro factor	AR(1), persistence φ = 0.65, standard normal innovations
High-sensitivity revenue (sales, use, marijuana, building permits)	−8% per 1σ, lognormal mapping
Moderate-sensitivity revenue (HUTF, Road & Bridge, SOT)	−2% per 1σ
Property tax	−4% per 1σ, lagged 2 years
Lumpy revenue (grants/CTF, municipal fees)	not tied to the macro factor
Expenses	+4% per 1σ
Trend error	Normal(0, 1.0%/yr), drawn per year and compounded
Idiosyncratic noise	2% lognormal, annual, uncorrelated
Contingency expected use	45% at baseline, rising linearly to 100% at −2σ
Reactive reduction	50% of discretionary, gated to 2028+
Reserve threshold triggering the reduction	2 × (2/12) × operating expenses

Results (Year-End Cumulative Reserves in 2040)

Multi-Year Risk Metrics

These results replace those published in versions 1.9–1.11, which reported 1.93% before R6 Road & Bridge was corrected to the statutory 50% share; those in version 1.8, which reported 2.58% before the Building Department coupling defect was corrected; and those in versions 1.7 and earlier, which reported 3.42%. The earlier simulation’s parameters were not retained and it could not be regenerated or re-run under any scenario. The model has been rebuilt from the Shock Framework described above, the full parameter set is published with it, and every scenario reported in the companion stress-testing analysis is produced by the same model — the unfavorable results on the same terms as the favorable ones. The rebuilt model runs approximately 0.8 percentage points more optimistic in the tail than the figure it replaces; the difference lies in three places where the earlier methodology was under-specified, each documented with the model.

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.44 million; in approximately 75% of scenarios, they exceed $3.95 million.
• Cumulative reserves dip below zero at some point in the projection in approximately 2.15% of simulations. In the remaining 97.85% of scenarios, the town maintains positive general-fund reserves throughout — even under multi-year adverse macroeconomic conditions.
• The 5th percentile trough of ~$262K 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.44M 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 significant permanent shifts in individual revenue or expense variables: sales tax would need to fall approximately 19.1% permanently, or operating expenses to rise approximately 23.5% permanently, before general fund reserves would be exhausted at any point in the projection period. The Monte Carlo analysis below applies a correlated multi-year shock framework to this model structure and finds approximately a 2.15% probability of reserves dipping below zero at any point across the projection period.

Correction: versions 1.5 and earlier stated these thresholds as approximately −13% and +15% in this paragraph. Those were the pre-v1.5 values and were not updated when the model was restructured; the Break-Even Sensitivity table above carried the current figures throughout. The same paragraph described the Monte Carlo rerun as in progress after it had been completed and reported.

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. Both benchmarks come from documents the municipalities publish themselves. Louisville’s figures are in its Revenue / Sales & Use Tax Report, carried in the Finance Committee packet, which reports an “Outside City” category for vendors with no location in the city. Lyons publishes a monthly local versus non-local split in the Finance Update attached to its Board of Trustees packets, and defines the non-local category as online businesses, mobile vendors and catering, deliveries from out-of-town companies, and utilities. Both are mirrored on this site: Louisville and Lyons (December 2025; April 2026, which completes calendar 2025). Measured against each town’s own published figures, the per-resident rates used above are conservative by 3.8% and 5.0% respectively; see Pro Forma Stress Testing for that comparison and for why Louisville’s rate was not adopted directly. 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).