Architecting the BEAD Pro Forma Financial Model

A project-specific pro forma is a mandatory, heavily scrutinized component of the BEAD subgrantee evaluation process. The NTIA and Wisconsin PSC require prospective subgrantees to submit comprehensive business plans and pro forma analyses that substantiate the long-term sustainability of the proposed network well beyond the construction phase. The required financial templates—often formatted as interconnected Microsoft Excel workbooks—must contain an Income Statement, Balance Sheet, Statement of Cash Flows, and a Net Present Value (NPV) and Internal Rate of Return (IRR) analysis covering the construction period and subsequent operating years.

The financial model acts as the mathematical engine of the business plan. It relies heavily on a series of macro- and micro-economic assumptions. These assumptions act as the levers that govern the projected financial health of the deployment, dictating whether the project will survive the high-risk "valley of death" between initial capital outlay and eventual steady-state cash flow.

Capital Expenditure (CapEx) Assumptions and Unit Economics

Broadband deployment is exceptionally capital-intensive. The initial investment required to build the outside plant (OSP) network infrastructure constitutes the vast majority of the lifetime project costs. For Wisconsin BEAD projects, accurate CapEx forecasting is vital, particularly given the inflationary pressures impacting the telecommunications supply chain and the strict mandates of the Build America, Buy America Act (BABA).

Based on 2024 and 2025 benchmark data from the Fiber Broadband Association and Cartesian, fiber deployment costs vary dramatically based on the engineering methodology and the region's topography.

Underground fiber deployments, while highly resilient to the severe winter weather common in Wisconsin, are the most expensive routing option. The median cost for underground builds in recent benchmarks reached $18 per foot, with a typical range extending from $10 to $27 per foot. When translated to a per-mile basis, underground builds require an investment of between $52,800 and $142,560 per mile. The specific underground methodology alters this significantly; plowing is generally the most cost-effective at roughly $14.50 per foot, while deep trenching or directional boring in rocky terrain can exceed $26.50 per foot.

Conversely, aerial deployments utilize existing utility poles and offer a more cost-effective avenue, provided the poles are accessible and structurally sound. The median cost for aerial builds is approximately $8 per foot, with an overall range of $5 to $14 per foot ($26,400 to $73,920 per mile). A critical variable in aerial modeling is pole ownership. Firms that own their poles report median costs of $4.90 per foot, while those renting face costs closer to $7.00 per foot, not including the escalating "make-ready" costs and attachment fees.

Labor remains the overriding driver of these expenses, consistently accounting for 60% to 80% of total deployment costs. The median labor cost alone for an underground deployment is approximately $13 per foot, compared to $4 per foot for aerial builds. The data indicates that self-performing ISPs utilizing internal labor can cut these specific line items in half compared to outsourced contracting.

Owned by Dexter Monroe llc

(EIN -88-2572661)

Licensed Federal Contractor perfected by Control via UCC-1 Filing 10/2025

www.dextermonroe.com