Town of Niwot — Pro Forma Budget & Financial Assumptions

Prepared by the Niwot Incorporation Committee

Version 1.3 — March 5, 2026
All figures shown in nominal dollars ($000s)

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.

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.

---

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:

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

Operating model (lean, contract-first):

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

Roads capital program modeled:

• A $15 million road capital program financed over ~20 years
• Debt service modeled beginning 2029 (partial year) at approximately $1.23 million per year thereafter

Baseline results:

• Under the baseline assumptions, annual surpluses are generated after operating expenses and modeled road debt service.
• Cumulative operating surplus (fiscal capacity) reaches approximately $15.0 million by year-end 2040.

Stress-testing and resilience:

• The model was stress-tested using 100,000 Monte Carlo simulations that include multi-year downturns (revenue declines plus cost pressure), compounding trend error, and year-to-year volatility.
• Results at year-end 2040:
  • Median reserves: ~$15.3M
  • 5th percentile (downside planning case): ~$6.5M
  • Probability of negative cumulative reserves: less than 1% (approximately 0.2%)

Break-even margin:

• In the tightest year (2030, first full year with road debt service), sales tax would need to decline 28% before the annual surplus reaches zero. No other individual revenue line can cause a deficit even if eliminated entirely.

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 and the modeled road debt service (loan repayment) while maintaining adequate 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 to the Pro Forma Tables

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

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

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

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

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

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

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

T4. Revenue totals. “Total Revenue” equals the sum of all listed recurring revenues and excludes bond proceeds and other one-time financing sources.

T5. Operating expenses definition. “Total Operating Expenses” includes payroll, contracted services, administrative costs, and contingency, and excludes road debt service (shown separately at the top of the Expenses section).

T6. Contingency definition. Contingency is modeled at 15% of non-contingency operating expenses and is included within Total Operating Expenses to account for uncertainty in startup conditions, price variability, and unanticipated costs.

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

T7. Road debt service modeled beginning in 2029. Road debt service (loan repayment) is shown first in the Expenses section because, once bonds are issued, debt service is the first-priority obligation. Road debt service is modeled beginning in 2029 (partial year, assuming April 2029 issuance) and continues at approximately the modeled annual repayment amount thereafter. The repayment schedule is based on a Financial Scenario Analysis prepared by Piper Sandler. The timing of debt issuance will be determined by the future elected Town Council and voter authorization; the pro forma models repayment beginning in 2029 as a planning assumption.

T8. Contribution to reserves calculation. “Contribution to Reserves Fund” is calculated as Total Revenue (treating cells shown as “—” as $0 for calculation purposes) minus Total Operating Expenses minus road debt service (loan repayment), if applicable.

T9. Cumulative reserves definition (capacity measure). “Cumulative Reserves” represents the cumulative operating surplus generated under modeled assumptions, assuming surpluses are retained and no withdrawals occur. In practice, future Town Councils would likely allocate portions of annual surplus to capital reserves, equipment replacement, emergency stabilization, or discretionary projects. The table therefore reflects fiscal capacity under the modeled tax structure, not a commitment to maintain a static cash balance. Note: CTF and most grant revenues are restricted to eligible purposes (parks/recreation and specific capital activities, respectively). “Contribution to Reserves” should be interpreted as aggregate fiscal capacity across all funds, not solely unrestricted General Fund cash. Restricted revenues are not assumed to fund general operating or public safety expenses.

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

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

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

T13. Road maintenance vs. snow removal. Public Works costs are shown as separate line items for routine road maintenance and seasonal snow removal/street services to reflect different cost drivers and variability.

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

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

---

Appendix A — Global Assumptions

A1. Population Assumption

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

A2. Assessed Value Base

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

A3. Escalation Assumptions

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

A4. Contingency

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

A5. Partial-Year Operations

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

---

Revenue Footnotes

R1. Property Tax – 4 Mills

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

Residential Property

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

Commercial Property

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

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

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

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

R2. Sales Tax – 2.5%

Sales tax revenue assumes a 2.5% municipal rate.

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

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

Adjustments were made for:

• Population
• Household income
• Local tax rate

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

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

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

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

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

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

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

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

R3. Use Tax – 2.5%

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

The estimate excludes building materials use tax.

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

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

R4. Retail Marijuana Tax – 3%

Retail marijuana tax assumes a 3% municipal rate.

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

The model assumes one retail outlet.

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

R5. Highway Users Tax Fund (HUTF)

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

Assumptions:

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

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

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

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

The resulting estimate is rounded conservatively for planning purposes.

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

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

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

R6. Road & Bridge Fund

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

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

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

R7. Specific Ownership Tax (SOT)

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

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

Vehicle Count Assumption (Registered Vehicles)

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

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

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

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

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

Average SOT per Vehicle (Blended)

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

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

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

Mill Levy Allocation (Town Share)

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

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

Revenue Estimate

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

R8. Grants

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

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

The model assumes:

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

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

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

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

R9. Conservation Trust Fund (CTF)

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

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

Inflated to ~$80,000 in 2029.

Funds are restricted to recreation-related capital and maintenance.

R10. Utility and Franchise Fees

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

R11. Building Department

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

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

---

Expense Footnotes

E1. Salaries

Salaries are benchmarked using:

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

E2. Benefits

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

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

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

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

E3. Sheriff Services

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

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

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

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

E4. Road Maintenance & Snow Removal

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.

Snow removal basis: Snow removal assumptions are informed by preliminary vendor bid pricing and event-based estimating (miles × events), plus an allowance for signs, lights, and traffic control devices.

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
• Additional $50,000 allowance for signs, lights, and traffic devices

Total rounded to approximately $140,000. The ~$140k estimate reflects ~25 miles; at ~29 miles, the estimate scales to approximately $150k–$160k depending on event count and vendor pricing. Final costs scale with confirmed road mileage (see R5 road mileage sensitivity note).

E5. Office Space / Meeting Rentals

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

E6. Insurance

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

E7. IT

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

E8. Finance Contracting / Auditing

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

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

E9. Materials Costs

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

E10. Election Costs

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

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

E11. Incorporation Costs

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

E12. Contingency

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

---

Capital & Reserves

C1. Roads Capital Project Loan

The modeled annual payment of approximately $1.23 million corresponds to a ~$15 million capital project financed over approximately 20 years at an assumed municipal borrowing rate in the 4–5% range. The bond repayment schedule is based on a Financial Scenario Analysis prepared by Piper Sandler, which models full issuance of $15 million in April 2029 with repayment at current market rates plus 50 basis points. Under Piper Sandler’s modeled terms, net proceeds to the Town are approximately $16 million after premiums and issuance costs. The modeled payment schedule reflects a standard amortization structure with a partial first-year payment in 2029; 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. Contribution to Reserves

Equals annual operating surplus after expenses and road debt service.

C3. Cumulative Reserves

Represents accumulated annual surpluses assuming no withdrawals. 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 second full year of operations.

---

Sensitivity Analysis

Break-Even Revenue Sensitivity

The following table illustrates how far each major revenue category would need to decline — holding all other revenues and expenses constant — before the annual contribution to reserves reaches zero. The reference year is 2030, selected because it is the first full year of operations with road debt service and produces the smallest annual surplus ($649,000) in the projection period.

Combined downside scenarios:

Interpretation. Only sales tax is individually large enough to drive a deficit within a plausible range of deviation, and even then would require a sustained ~28% shortfall, holding all other revenues and expenses constant. Property tax would require a 72% decline. No other individual revenue line can cause a deficit even if it goes to zero completely. In the most pessimistic combined scenario — all grants eliminated and sales tax simultaneously falling 12% — the budget reaches break-even but does not enter deficit. These single-variable results are inherently optimistic because real downturns produce correlated shocks; the Monte Carlo analysis below tests those correlated scenarios directly.

---

Stochastic Stress Testing (Monte Carlo)

The pro forma was subjected to 100,000 Monte Carlo simulations over the period 2027–2040 to test structural resilience under adverse and volatile economic conditions.

All simulation results reflect the public safety contract escalation assumption used in this pro forma (4% to first full year of service, 3% thereafter).

Model Design

Each simulation year computes:

Contribution _t = Revenue _t − Expense _t − Road Debt Service _t

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

Bond and Shock Assumptions

In the Monte Carlo, annual shocks are applied to total revenues (including property tax) and total operating expenses, using a common macro factor plus drift and idiosyncratic noise. Road debt service is held constant at the modeled annual repayment schedule (beginning with a partial year in 2029, then approximately $1.23 million per year thereafter).

Revenue and Expense Variability

The simulation incorporates the following stochastic elements:

Trend Error (Compounding Drift)

• Revenue drift: Normal(0, 1.0% per year), compounded
• Expense drift: Normal(0, 1.0% per year), compounded

Correlated Macroeconomic Downside (Clustered Stress Years)

• Common AR(1) macro factor (φ = 0.65), generating persistent “bad stretches”
• Revenue impact: approximately −8% per 1σ macro shock (lognormal mapping)
• Expense impact: approximately +4% per 1σ macro shock (lognormal mapping)

Idiosyncratic Annual Noise

• Revenue: 2% lognormal
• Expenses: 2% lognormal

Multiplicative (lognormal) shocks are used to avoid negative revenues/expenses and to reflect that fiscal impacts scale with the size of the budget. The stress model is designed to mimic recession-like periods in which sales and use taxes decline while public safety and contracted service costs do not fall proportionally, producing multi-year budget pressure rather than isolated one-year shocks.

Results (Year-End Cumulative Reserves in 2040)

“Year-end 2040 cumulative reserves” refers to the projected year-end 2040 cumulative reserve balance, assuming annual surpluses are retained and no withdrawals occur.

Tail-risk note. The minimum outcome reflects an extreme outlier path in a 100,000-run simulation and is not an appropriate planning benchmark; the 5th percentile (~$6.5M) is a more suitable downside planning case for policy discussion.

Interpretation

• The median simulation result closely aligns with the deterministic baseline. The slight difference between the mean and median reflects a modest right-tail skew generated by multiplicative revenue shocks.
• In 95% of simulated scenarios, year-end 2040 reserves exceed approximately $6.5 million (the 5th percentile outcome).
• Fewer than 1% of simulations result in negative cumulative reserves.
• Downside outcomes require sustained revenue contraction combined with elevated expense growth over multiple years.

The results demonstrate that the proposed tax structure remains structurally resilient under clustered economic stress and compounding trend error.

The Monte Carlo design includes persistent adverse clustering to reflect multi-year downturn risk.

---

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 Monte Carlo analysis applies adverse multi-year stress to revenues and expenses simultaneously. Even under clustered downturn scenarios, the proposed tax structure remains resilient in the vast majority of simulations. The stress model intentionally includes multi-year downturns consistent with recession-like periods in which sales/use taxes fall while public safety and contract costs do not decline proportionally.

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

---

Structural Conclusion

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

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

---

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

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

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

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

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

---

Appendix C — Remote / Online Sales Tax Benchmark Analysis

Purpose

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

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

Benchmark Selection

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

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

Table C-1: Remote Taxable Sales — Regional Comparison

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

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

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

Observations

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

Table C-2: Niwot Remote Sales Sensitivity Comparison

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

Fiscal Positioning

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

Structural Considerations

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

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