Loading plan data...
Revenue — Plan vs. Actual
Sep '25 stub + calendar quarters ($000s)
Plan
Actual
EBITDA — Plan vs. Actual
Sep '25 stub + calendar quarters ($000s)
Plan
Actual (positive)
Actual (negative)
Plan vs. Actual Summary
Key metrics by fiscal year | Fiscal year ends August 31
Loading...
Revenue by Segment
Plan — Annual ($000s) Stacked
Revenue & EBITDA by Period
Actuals — Sep '25 stub + calendar quarters ($000s) vs plan
Gross Margin %
Plan vs. Actual by year
Revenue by Segment Detail
Plan — All Fiscal Years ($000s)
Revenue Assumptions
From DA Investment Committee Model
CFW Contract Start
Year 3 (FY2027)
CFW Annual Revenue
$3.759M/yr
CFW Contract Term
30 Years
FTTH ARPU
$75/mo blended
MDU Retail ARPU
$75/mo
MDU Bulk ARPU
$40/unit/mo
Commercial ARPU
$500/mo/property
EllumNet Baseline
$623K/yr
Homes Passed & MDU Units
Plan — End of Period
Subscriber Growth by Segment
Plan — End of Period (cumulative)
FTTH Penetration Rate
% of homes passed
Subscriber Detail
Plan — All Fiscal Years
Build & Subscriber Assumptions
From Operating Model
FTTH Cost/Home Passed
$1,046 blended
Underground Drop
$25/ft
Aerial Drop
$10/ft
Install + Drop + CPE
$600/sub
FTTH Target Penetration
30%
MDU Cost/Unit
$650
MDU Retail Penetration
50%
MDU Bulk Utilization
80%
Commercial Cost/Property
$15,000
Penetration Ramp
1%/mo
FTTH Total HP Target
21,995 homes
MDU Units Target
35,000 units
P&L Bridge — Current FY Plan
Revenue → EBITDA waterfall ($000s)
Loading...
P&L Bridge — Current FY Actual YTD
From QuickBooks ($000s)
Connect QuickBooks to see actual P&L data.
Revenue vs. OpEx
Plan — how costs scale with revenue
Margin %
Gross & EBITDA by year
Full P&L Statement
Plan — All Fiscal Years ($000s)
CapEx Burn — Plan vs Actual
Sep '25 stub + calendar quarters ($000s) · Construction investment by category
Cash Flow — Inflows & Outflows
Sep '25 stub + calendar quarters ($000s) · Plan vs Actual
Construction Spend by Category
CFW / Backbone project spend to date vs $47.1M total budget
Debt & Equity Structure
Plan — End of Period ($000s)
Debt
Equity Invested
Actual Liabilities (QB)
Capital Expenditures
Plan — Annual ($000s) by Category
Capital & Debt Detail
Plan — All Fiscal Years
Key Model Assumptions
From DA Investment Committee Model
Investment Return Summary
From 20-Year DA IC Model
Target IRR
27.1%
Exit Multiple
20× EBITDA
Exit Year
Year 5
Implied Value at Exit
~$518M
Total Capital Required
$113.3M
DA Ownership
50%
Yr 5 EBITDA (DA model)
$25.9M
Yr 5 Revenue (DA model)
$47.1M
Export Reports
Generate board-quality documents from current dashboard data
PDF Dashboard Report
Full-page PDF of the current dashboard — all charts, tables, and plan vs. actual data.
Good for records and sharing internally.
- All KPI summary cards
- Revenue, EBITDA, Subscriber charts
- P&L detail table
- Capital structure summary
- Timestamped header & footer
Board Presentation (PPTX)
Formatted PowerPoint slide deck suitable for board meetings and investor updates.
Includes DA plan context and current performance.
- Title slide + table of contents
- Executive summary with KPI cards
- Revenue plan vs. actual chart
- Revenue by segment (stacked)
- EBITDA plan vs. actual
- Subscriber growth ramp
- Capital structure & debt schedule
Print / Browser PDF
Use your browser's built-in print dialog to save a PDF directly from this page.
Fastest option — no server required.
- Prints all tabs
- Respects browser print settings
- No network required
Model Context
Business Plan Source: Sprocket Operating Model — Full Business Expansion v.F.xlsx
(CIM / DA Investment Committee model). Fiscal year ends August 31 (Sep 1 – Aug 31).
Year 1 = Sep 2025 – Aug 2026 (DA deal close). Year 2 = Sep 2026 – Aug 2027 (current).
Long-Range Model: Sprocket Data Room Financial Model Update (0124 WG).xlsm — 20-year horizon. Target IRR 27.1% at 20× exit multiple in Year 5 per DA IC model.
Actuals Source: QuickBooks Online — pulled live via Intuit API. Reports use Accrual basis.
Long-Range Model: Sprocket Data Room Financial Model Update (0124 WG).xlsm — 20-year horizon. Target IRR 27.1% at 20× exit multiple in Year 5 per DA IC model.
Actuals Source: QuickBooks Online — pulled live via Intuit API. Reports use Accrual basis.