Loading...
7. Project Financing SpreadsheetExpansion Projects by Year Paid Locations ISP Self Funded Locations All Locations Original Locations Projection ISP Self Funded Estimate ISP Cost Share Other Cost Share Scandia Cost Share Total Cost Total Cost per All Locations Scandia Cost per Paid Location Scandia Share Pct ISP Share Pct Other Share Pct Comment Pre-Expansion Buildout 0 700 700 700 Built out by MidCo prior to 2020 - MidCo cost is unknown Blandin Consulting Grant 0 0 Blandin Foundation to provide consulting services in 2014 FTTP Feasibility Study 4,600 4,750 9,350 51% 0% 49%Blandin Grant for Fiber to Premise Feasibility Study by CTC Pre-Expansion Total 0 700 700 700 4,600 4,750 9,350 51% 0% 49% 2020 DEED 219 23 242 219 107,203 350,274 510,358 160,085 1,127,920 4,661 731 14% 41% 45%First successful DEED Grant Project in Scandia 2020 Other 0 8 8 0 37,288 0 0 0 37,288 4,661 0 0% 100% 0%Mallard Ave 2020 Total 219 31 250 219 144,491 350,274 510,358 160,085 1,165,208 4,661 731 14% 42% 44% 2021 DEED 24 0 24 78 0 190,320 78,824 165,000 434,144 18,089 6,875 38% 44% 18%DEED reduced their grant to 26 addresses 2021 Direct Aid 61 3 64 61 11,163 142,000 0 85,000 238,163 3,721 1,393 36% 64% 0%Community funded project (Quality Trail) 2021 239th 0 10 10 0 37,210 0 0 0 37,210 3,721 0 0% 100% 0%MidCo expanded here based on neighbrhood petition 2021 Paris Ave 0 12 12 12 44,652 0 0 0 44,652 3,721 0 0% 100% 0%MidCo voluntarily expanded here on their own 2021 RDOF 0 58 58 58 215,818 0 0 0 215,818 3,721 0 0% 100% 0%MidCo and LTD RDOF Areas 2021 Total 85 83 168 209 308,843 332,320 78,824 250,000 969,987 5,774 2,941 26% 66% 8% 2022 County 44 0 44 48 0 144,000 100,000 96,524 340,524 7,739 2,194 28% 42% 29%Washington County Grant Project (Oakhill/Parkview) 2022 Direct Aid 54 0 54 61 0 115,736 0 122,476 238,212 4,411 2,268 51% 49% 0%Community funded project (NW & Scandia Trail) 2022 RDOF 0 41 41 41 180,851 0 0 0 180,851 4,411 0 0% 100% 0%Continue MidCo RDOF Buildout 2022 Other 0 4 4 0 17,644 0 0 0 17,644 4,411 0 0% 100% 0%MidCo expanded here for unidentified reasons (3 NW & 1 SE) 2022 Total 98 45 143 150 198,495 259,736 100,000 219,000 777,231 5,435 2,235 28% 59% 13% 2023-24 Big Marine 93 0 93 112 0 280,000 372,500 92,500 745,000 8,011 995 12% 38% 50%Washington County "Big Marine Lake" Grant Project Line Extension Mailer 0 0 350 350 0 100% 0% 0%Line Extension Mailer (printing and postage) Line Extension - Big Marine 0 15 15 19 0 0 106,316 0 106,316 7,088 0 0% 0% 100% Line Extension - Big Marine Line Extension - Meadowbrook 0 5 5 5 0 0 54,000 0 54,000 10,800 0 0% 0% 100% Line Extension - Meadowbrook 2023-24 0 0 0 29,650 29,650 0 100% 0% 0%Amount remaining in 2023 City Budget 2023-24 Total 93 20 113 136 0 280,000 532,816 122,500 935,316 8,277 1,317 13% 30% 57% Expansion Total 495 179 674 714 651,829 1,222,330 1,221,998 751,585 3,847,742 5,709 1,518 20%49%32% Future Years: TBD Long Drive Infill 46 0 46 Potential LE Grant TBD Underserved 24 0 24 Remaining Underserved Addresses TBD Unserved 320 0 320 Remaining Unserved Addresses - Potential LE Grant TBD RDOF 0 4 4 Remaining addresses in the MidCo RDOF Area TBD Vacant 20 0 20 Remaining Vacant Addresses - Potential LE Grant TBD Vacant Infill 23 2 25 Potential LE Grant & 2 RDOF Addresses Future Years Total 433 6 439 Grand Total 928 885 1,813 651,829 1,222,330 1,226,598 756,335 3,857,092 1,813 Parcel Addresses in Scandia as of July 1, 2023 1,374 Parcel Addresses with access to high speed internet 76%Percent of addresses with access to high speed internet Outside Money Scandia Money Year Annual Total Annual Total 2019 4,600 4,600 4,750 4,750 2020 1,005,123 1,009,723 160,085 164,835 2021 719,987 1,729,710 250,000 414,835 2022 558,231 2,287,941 219,000 633,835