Loading...
HomeMy WebLinkAboutResolution 4782 Budget Amendment for Westside Street Improvements Project (Flanders Mill Megabuild) 1 sonz CID. COMMISSION RESOLUTION NO. 4782 A RESOLUTION OF THE CITY COMMISSION OF THE CITY OF BOZEMAN, MONTANA, AMENDING THE CITY'S ANNUAL BUDGET FOR THE STREET IMPACT FEE FUND, ARTERIAL & COLLECTOR DISTRICT FUND, AND THE SPECIAL IMPROVEMENT DISTRICT REVOLVING FUND TO INCREASE APPROPRIATIONS BY A TOTAL OF is $5,311,520 FOR THE FISCAL YEAR ENDING DUNE 30, 2017 TO COMPLETE VARIOUS STREET AND INTERSECTION PROJECTS. WHEREAS,the City Commission did,on the 20"'day of June,2016,after due and proper legal notice, conduct a public hearing and adopt a municipal budget for Fiscal Year 2016-2017 (Fiscal Year 2017); and s WHEREAS,the City Commission did, on the 3`d day of October, 2016, and on the 23rd day of January,2017, after due and proper legal notice,conduct public hearings and amend the municipal budget for Fiscal Year 2016-2017 (Fiscal Year 2017) Street Impact Fee Appropriations; and WHEREAS,the City Commission did,on December 5,2016 approve the Street Impact Fee and A Arterial & Collector District Capital Improvement Plans for Fiscal Years 2018-2022; and WHEREAS, such Capital Improvement Plans contained projects to consider for funding in the Fiscal Year 2018 budget for the construction of SIF046 - Oak Street(New Holland to Ferguson), SIF080 - Ferguson Avenue (Baxter to Oak), SIF074 - Intersection of Davis & Oak Street, and SIF061 - Intersection of Ferguson&Oak Street; and 1. 1 R L WHEREAS,the City's Trails,Open Space,and Parks fund has previously budgeted to construct 1 Flanders Mill Road(Oak to Baxter); and Page 1 of 4 I'' Resolution 478Z Westside Street Improvement Project(Flanders Mill)Budget Amendment WHEREAS, portions of these project costs will be recouped by the City through payback agreements and the creation of a Special Improvement District, and WHEREAS, finding that excess dollars exist in the City's Special Improvement District Revolving Fund, it is in the best interest of the City to utilize a portion of available Special Improvement District Revolving Fund excess dollars to complete the construction of Flanders Mill Road (Sunshine Street to Oak.) Such construction will be reimbursed to the Special Improvement District Revolving Fund by an inter local agreement for payback from School District#7; and WHEREAS,the need has arisen to begin construction of the above described projects in Fiscal year 2017. The project construction and payment period will begin in Fiscal Year 2017 and extend into Fiscal Year 2018; and WHEREAS, the City Commission did, on the 20th day of March, 2017, after due and proper legal notice, conduct a public hearing on proposed amending the municipal budget. NOW, THEREFORE,BE IT RESOLVED by the City Commission of the City of Bozeman, Montana, to wit: Section 1 —Appropriation Changes The City Commission of the City of Bozeman, Montana, does hereby authorize the following changes to expenditures in the following funds: Additions: This project and amount is added to the FYI budget. Street Impact Fee Fund SIF080 -Ferguson Avenue (Baxter to Oak) $357,342.50 SIF046 - Oak Street(New Holland to Ferguson) $704,796.00 SIF061 -Intersection of Ferguson and Oak Street $425,040.00 SIF074 -Intersection of Davis & Oak Street $1,559,826.00 Total Street Impact Fee Fund $3,047,004.50 Arterial & Collector District Fund SIF080 -Ferguson Avenue (Baxter to Oak), advanced to Flanders Mill, LLC $401,390.00 SIF080 -Ferguson Avenue (Baxter to Oak), advanced to Gallatin County $357,342.50 SIF046 - Oak Street(New Holland to Ferguson), advanced to Gallatin County $704,796.00 SIF061 -Intersection of Ferguson and Oak Street $106,260.00 Page 2 of 4 Resolution 4782, Westside Street Improvement Project(Flanders Mill)Budget Amendment SIF074-Intersection of Davis& Oak Street $389,956.00 Total Arterial & Collector Fund $1,959,744.50 Special Improvement District Revolving Fund Flanders Mill Road—advanced to School District#7 $304,771.00 Total Revolving Fund $304.771.00 Grand Total Appropriations Changes: $5,311,520.00 Section 2—Use of Cash on Hand The Arterial& Collector District will require increased assessments in Fiscal Year 2018 in order to have cash available to pay the increased appropriations. The increased appropriation will be funded with cash on hand in the Street Impact Fee Fund, Arterial & Collector District, and Special Improvement District Revolving Fund. Section 3 Pursuant to Section 7-6-4030, M.C.A., this resolution, upon its passage, shall be in full force and effect on July 1,2016. Section 4 That should it be found by any court of competent jurisdiction that any section, clause,portion, sentence, word, or phrase of this resolution is deemed to be contrary to any existing law or regulations, that in this instance, it is the intent of the City Commission of the City of Bozeman, Montana, that all other portions, sections,words,clauses,phrases, or paragraphs of this document shall remain in full force and effect. PASSED AND APPROVED by.the City Commission of the City of Bozeman, Montana, at a regular session thereof held on the 201h day of March, 2017. CARSON TAYLOR Mayor Page 3 of 4 Resolution 4782, Westside Street Improvement Project(Flanders Mill)Budget Amendment ATTEST: ROBIN CROUGH �;� ��'.: • City Clerk _7�A �.z . co• APPROVED AS TO FORM: Jk,p*LLIvV!AN City Attorney Page 4 of 4 Westside,Riorect,:,project Elements CIP i?ro} ct#%', DescrtpEror' SIF080 Ferguson Avenue Improvements SIF049 Oak Street- Ferguson to New Holland SIF061 Intersection-Oak&Ferguson SIF074 Intersection-Oak& Davis TOP Project Flanders Mill Road-Oak to Baxter NONE Flanders Mill Road-Sunstone to Oak Westside Project Financial Exhibits Page 1 of 7 Westside Project-Cost Summary PROJECT Project ID SECTION Source Party Project Name Feb/March 2017 FYI CIP/TOP Amount NONE 1 City Revolving Fund Bozeman School District Flanders Mill(Oak to Sunstone) $ 304,771.00 NONE 2 Cash-Flanders Mill LLC Cash-Flanders Mill LLC Flanders Mill(Oak to Sunstone) $ 304,771.00 3 NONE-Removed SIF046 4 Street Impact Fees City Share Oak Street(New Holland to Ferguson) $ 704,796.00 $ 1,400,000.00 SIF061 5 Arterial&Collector District City Share Intersection Oak&Ferguson $ 106,260.00 $ 269,066.00 SIF061 6 Street Impact Fees City Share Intersection Oak&Ferguson $ 425,040.00 $ 1,076,265.00 SIF080 7 Street Impact Fees City Share Ferguson Avenue(Baxter to Oak) $ 357,342.50 $ 333,333.00 SIF074 8 Street Impact Fees City Share Intersection Oak&Davis $ 1,559,826.00 $ 1,409,206.00 SIF074 9 Arterial &Collector District City Share Intersection Oak&Davis $ 389,956.00 $ 352,302.00 TOP 10 TOP Bond Fund City Share Flanders Mill (Baxter to Oak) $ 513,340,00 $ 481,116.00 SIF080 11 Arterial &Collector District Payback-Flanders Mill LLC Ferguson Avenue(Baxter to Oak) $ 401,390.00 $ 333,333.00 TOP 12 TOP Bond Fund Payback-Flanders Mill LLC Flanders Mill (Baxter to Oak) $ 558,726.00 $ 481,116.00 SIF046 13 JArterial &Collector District SID-Gallatin County Oak Street(New Holland to Ferguson) $ 704,796.00 $ 600,000.00 SIF080 14 JArterial &Collector District SID-Gallatin County Ferguson Avenue(Baxter to Oak) $ 357,342.50 $ 333,333.00 Total Project Cost Estimates $ 6,688,357.00 $ 7,069,070.00 Westside Project Financial Exhibits Page 2 of 7 Westside Project-Costs Per CIP Project Estimated Costs from Project Sheets SPLITS TOTAL Flanders Mill -Sunstone to Oak $ 609,542.00 NONE 1 City Revolving Fund Bozeman School District $ 304,771.00 NONE 2 Cash-Flanders Mill LLC Cash-Flanders Mill LLC $ 304,771.00 Ferguson Ave Improvements $ 1,116,075.00 SIF080 7 Street Impact Fees City Share $ 357,342.50 SIF080 11 Arterial &Collector District Payback-Flanders Mill LLC $ 401,390.00 SIF080 14 Arterial &Collector District SID-Gallatin County $ 357,342.50 Flanders Mill -Oak to Baxter $ 1,072,066.00 TOP 10 TOP Bond Fund City Share $ 513,340.00 TOP 12 TOP Bond Fund Payback-Flanders Mill LLC $ 558,726.00 Oak Street- Ferguson to New Holland *includes Construction Mgmt Sub Totals $ 3,890,674.00 Street $ 1,4c9,592.00 SIF046 4 Street Impact Fees City Share $ 704,796.00 SIF046 13 Arterial &Collector District SID-Gallatin County $ 704,796.00 Oak/Ferg Intersection $ 531,300.00 SIF061 5 Arterial &Collector District City Share $ 106,260.00 SIF061 6 Street Impact Fees City Share $ 425,040.00 Oak/Davis Intersection $ 1,949,782.00 SIF074 8 Street Impact Fees City Share $ 1,559,826.00 SIP074 9 Arterial &Collector District City Share $ 389,956.00 Totals $ 6,688,357.00 $ 6,688,357.00 *Shading=Indicates project cost not requiring a budget amendment. $ 1,376,837.00 Budget Amendment $ 5,311,520.00 Westside Project Financial Exhibits Page 3 of 7 Westside Project- Budget Amendment by Source SID Revolving Fund-Excess NONE 1 City Revolving Fund Bozeman School District Flanders Mill (Oak to Sunstone) $ 304,771.00 TOTAL $ 304,771.00 Street Impact Fees SIF080 7 Street Impact Fees City Share Ferguson Avenue (Baxter to Oak) $ 357,342.50 SIF046 4 Street Impact Fees City Share Oak Street(New Holland to Ferguson) $ 704,796.00 SIF061 6 Street Impact Fees City Share Intersection Oak& Ferguson $ 425,040.00 SIF074 8 Street Impact Fees City Share Intersection Oak&Davis $ 1,559,826.00 TOTAL $ 3,047,004.50 Arterial &Collector District SIF080 11 Arterial &Collector District Payback-Flanders Mill LLC Ferguson Avenue (Baxter to Oak) $ 401,390.00 SIF080 14 Arterial &Collector District SID-Gallatin County Ferguson Avenue (Baxter to Oak) $ 357,342.50 SIF046 13 Arterial &Collector District SID-Gallatin County Oak Street(New Holland to Ferguson) $ 704,796.00 SIF061 5 Arterial &Collector District City Share Intersection Oak& Ferguson $ 106,260.00 SIF074 9 Arterial &Collector District City Share Intersection Oak&Davis $ 389,956.00 TOTAL $ 1,959,744.50 TOTAL BUDGET AMENDMENT $ 5,311,520.00 Westside Project Financial Exhibits Page 4 of 7 Westside Project-Details of Oak Street/Intersection Costs Breakdown by SIME and Sanderson Stewart Costs Oak Street-Ferguson to New Holland *includes Construction Mgmt $ 3,715,674.00 $ 175,000.00 $ 3,890,674.00 Subrotols $ 3,890,674,00 Street SIME Sanderson Stewart Subtotal $1,409,592.00 SIF046 4 Street Impact Fees City Share $ 673,096.00 $ 31,700.00 $ 704,796.00 SIF046 13 Arterial&Collector District SID-Gallatin County $ 673,096.00 $ 31,700.00 $ 704,796.00 Oak/Ferg Intersection $ 531,300.00 SIF061 5 Arterial&Collector District City Share $ 101,480.00 $ 4,780.00 $ 106,260.00 SIF061 6 Street Impact Fees City Share $ 405,920.00 $ 19,120.00 $ 425,040.00 Oak/Davis Intersection $1,949,782.00 SIF074 8 Street Impact Fees City Share $ 1,489,666.00 $ 70,160.00 $ 1,559,826.00 SIF074 9 Arterial&Collector District City Share $ 372,416.00 $ 17,540.00 $ 389,956.00 $ 3,715,674.00 $ 175,000.00 $ 3,890,674.00 Westside Project Financial Exhibits Page 5 of 7 Westside Project-Other Summaries 1.Westside Project-Details of Flanders Mill,LLC Agreement Amount City Pays to Flanders Mill, LLC $ 6,208,586.00 Amount Flanders Mill, LLC Pays Direct to SIME $ 304,771.00 Amount City Pays Direct to Sanderson Stewart $ 175,000.00 Total Project Amount $ 6,688,357.00 2.Westside Project-Gallatin County SID payback to Arterial&Collector District Oak Street-Ferguson to New Holland $ 704,796.00 Ferguson Ave Improvements $ 357,342.50 SID, without ROW purchase $ 1,062,138.50 Add: Estimated incidental SID costs $ 1,000.00 Less: Estimated ROW purchase cost $ (161,605.00) SID, net of ROW purchase $ 901,533.50 3.Westside Project-Amounts Paid Back by Flanders Mill, LLC Ferguson Avenue(Baxter to Oak) $ 401,390.00 Flanders Mill (Baxter to Oak) $ 558,726.00 Payback Due from Flanders Mill, LLC $ 960,116.00 4.Westside Project-Maximum Amounts Paid Back by School District#7 Flanders Mill (Oak to Sunstone) $ 304,771.00 Payback Due from School District#7 $ 304,771.00 S.Westside Project-SID Revolving Fund Impacts Current Balance in Revolving Fund $ 2,788,145.00 Required Balance: 10%of Total SID Debt $ (126,166.00) Beginning Excess in Revolving Fund $ 2,661,979.00 Bozeman School District $ (304,771.00) Required Balance: 10%of Gallatin County SID $ (106,213.85) Ending Excess in Revolving Fund $ 2,250,994.15 Westside Project Financial Exhibits Page 6 of 7 1. Westside Project-SID Project Elements Oak Street-Ferguson to New Holland $1,409,592.00 SIF046 4 Street Impact Fees City Share $ 704,796.00 SIF046 13 Arterial &Collector District SID-Gallatin County $ 704,796.00 Ferguson Ave Improvements $1,116,075.00 SIF080 7 Street Impact Fees City Share $ 357,342.50 SIF080 11 Arterial &Collector District Payback-Flanders Mill LLC $ 401,390.00 SIF080 14 Arterial &Collector District SID-Gallatin County $ 357,342.50 TOTAL SID PROJECT: $2,525,667.00 2. Westside Project-SID Project Breakdown by Source Portion paid by Street Impact Fees-City Share SIF046 4 Street Impact Fees City Share $ 704,796.00 SIF080 7 Street Impact Fees City Share $ 357,342.50 TOTAL STREET IMPACT FEES $1,062,138.50 Portion benefiting Flanders Mill LLC, paid by Flanders Mill LLC agreement SIF080 11 Arterial &Collector District Payback- Flanders Mill LLC $ 401,390.00 TOTAL FLANDERS MILL, LLC AMOUNT $ 401,390.00 Portion benefiting Special Improvement District property, paid by SID 740 SIF046 13 Arterial &Collector District SID-Gallatin County $ 704,796.00 SIF080 14 Arterial &Collector District SID-Gallatin County $ 357,342.50 TOTAL SID AMOUNT, before ROW and incidental costs $1,062,138.50 TOTAL SID PROJECT: $2,525,667.00 Westside Project Financial Exhibits Page 7 of 7 Street Impact Fee Capital Improvement Plan Financial Summary Current Year Projected FY17 FY18 FY19 FY20 FY21 FY22 Unscheduled Projected Beginning Reserve Balance Dedicated to CIP $ 13,172,000 $ 8,548,426 $ (247,873) $ 691,644 $ (2,764,422) $ (1,473,291) Plus: Impact Fee Revenues Dedicated to CIP $ 2,388,901 $ 3,123,750 $ 3,279,938 $ 3,443,934 $ 3,616,131 $ 3,796,938 $ Plus: Urban Funds: Less: Carryover FY16 Capital Projects $ (2,067,000) Less: Scheduled CIP Project Costs $ (4,945,475) $ (11,920,049) $ (2,340,421) $ (6,900,000) $ (2,325,000) $ (1,000,000) $ (36,236,584) Projected Year-End Cash Dedicated to CIP $ 8,548,426 $ (247,873) $ 691,644 $ (2,764,422) $ (1,473,291) $ 1,323,647 $ (36,236,584) Beginning Balance of Payback Improvements: $ - $ (1,436,000) $ (1,436,000) $ (1,436,000) $ (2,436,000 $ Graf Street Project $ (1,436,000) ) (1,436,000) SIF102-Payback District SIF111-Payback District SIF118-Payback District SIF129-Payback District Ending Balance of Payback Improvements: $ (1,436,000) $ (1,436,000) $ (1,436,000) $ (1,436,000) $ (1,436,000) $ (1,436,000) Assumptions Made for Revenue Estimates: Current Year Projected FYI FYIS FY19 FY20 FY21 FY22 Estimated Annual Street Impact Fee Revenues $ 2,388,901 $ 2,975,000 $ 3,123,750 $ 3,279,938 $ 3,443,934 $ 3,616,131 Estimated Annual Increase 0.0% 5% 5% 5% 5% 5% Total Estimated Revenues $ 2,388,901 $ 3,123,750 $ 3,279,938 $ 3,443,934 $ 3,616,131 $ 3,796,938 Current Revenues Dedicated to CIP% 100.0% 100.0% 100.096 100.0% 100.0% 100.0% Plus: Increase Dedicated to Street Capacity Expansion CIP 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total%Dedicated to CIP 100.0% 100.0% 100.096 100.0% 100.0% 100.0% Total Estimated Revenues Dedicated to CIP $ 2,388,901 $ 3,123,750 $ 3,279,938 $ 3,443,934 $ 3,616,131 $ 3,796,938 Street Impact Fee Projects *Note:This schedule no longer contains the portions of project costs that will be paid by other sources,with the exception of Federal 45,000,000 Urban Funds. Seethe"Funding Sources"discussion at the bottom of 40,000,000 each project item sheet 35,000,000 30,000,000 25,000,000 20,000,000 1.5,000,000 10,000,000 CURRENT 5,000,000 0 r� 5� Jc CIP PROJECT FU PROJ. DEPARTMENT PROJECT NAME FY18 FY19 FY20 FY21 FY22 Unscheduled Impact Fees Streets SIF001 STREET IF ANNUAL RIGHT OF WAY ACQUISITION $250,000 $250,000 $250,000 $250,000 $250,000 SIF009 STREET IF KAGY(WILLSON TO 19TH)- $8,000,000 CONSTRUCTION SIF036 STREET IF COTTONWOOD(BABCOCK TO $1,278,000 DURSTON)-CONSTRUCTION SIF039 STREET IF FERGUSON&DURSTON(INTERSECTION)- $1,804,976 CONSTRUCTION SIF046 STREET IF OAK(NEW HOLLAND TO FERGUSON)- $1,400,000 CONSTRUCTION SIF057 STREET IF OAK(FLANDERS MILL TO RYUNSON $1,000,000 WAY)-CONSTRUCTION SIF058 STREET IF OAK&N 27TH(INTERSECTION)- $488,584 CONSTRUCTION SIF061 STREET IF OAK&FERGUSON(INTERSECTION)- $1,076,265 SIGNAL CONSTRUCTION SIF062 STREET IF DURSTON(FOWLER TO FERGUSON)- $757,421 CONSTRUCTION SIF063 STREET IF FOWLER&BABCOCK(INTERSECTION)- $1,600,000 CONSTRUCTION SIF073 STREET IF FOWLER&DURSTON(INTERSECTION)- $1,616,000 SIGNAL CONSTRUCTION SIF074 STREET IF OAK&DAVIS(INTERSECTION)- $1,409,206 ROUNDABOUT CONSTRUCTION SIF076 STREET IF FOWLER CONNECTION(HUFFINE TO $500,000 OAK)-DESIGN(INCLUDES 3 INTERSECTIONS) SIF080 STREET IF FERGUSON(BAXTER TO OAK)- $333,333 CONSTRUCTION SIF086 STREET IF BAXTER&COTTONWOOD $2,000,000 (INTERSECTION)-CONSTRUCTION SIF098 STREET IF OAK&COTTONWOOD(INTERSECTION)- $2,192,000 ROUNDABOUT CONSTRUCTION SIF102 STREET IF S 11TH AVE(KAGY BLVD TO GRAF ST $1,600,000 EXTENSION)-CONSTRUCTION'S CIP PROJECT FU PROJ. DEPARTMENT PROJECT NAME FY18 FY19 FY20 FY21 FY22 Unscheduled SIF104 STREET IF COTTONWOOD&BABCOCK $1,148,269 (INTERSECTION)-SIGNAL CONSTRUCTION SIF105 STREET IF COTTONWOOD(DURSTON TO OAK)- $1,240,000 CONSTRUCTION SIF106 STREET IF TRANSPORTATION DEMAND $50,000 $50,000 MANAGEMENT CONTRACT SIF108 STREET IF S 3RD AND GRAF-SIGNAL CONSTRUCTION $800,000 SIF109 STREET IF OAK(ROUSE THROUGH CANNERY $133,000 DISTRICT)-CONSTRUCTION SIF110 STREET IF MANLEY&GRIFFIN(INTERSECTION)- $1,600,000 CONSTRUCTION SIF111 STREET IF HIGHLAND(MAIN TO KAGY)- $5,000,000 CONSTRUCTION&DESIGN* SIF112 STREET IF HIGHLAND&MAIN INTERSECTION $120,000 IMPROVEMENTS SIF113 STREET IF GRIFFIN(7TH TO ROUSE)-CONSTRUCTION $3,000,000 SIF114 STREET IF FOWLER CONNECTION(HUFFINE TO $3,750,000 OAK)-CONSTRUCTION SIF115 STREET IF COLLEGE(11TH TO 19TH)- $550,000 CONSTRUCTION SIF116 STREET IF BRIDGER DR&STORY MILL RD $800,000 (INTERSECTION)-CONSTRUCTION SIF117 STREET IF STORY MILL(GRIFFIN TO BRIDGER)- $225,000 CONSTRUCTION SIF118 STREET IF BABCOCK(11TH AVE TO 19TH AVE)- $750,000 CONSTRUCTION* SIF118 STREET IF BABCOCK(11TH AVE TO 19TH AVE)- $250,000 DESIGN* SIF121 STREET IF BAXTER&DAVIS(INTERSECTION)- $2,000,000 CONSTRUCTION SIF122 STREET IF BABCOCK&FERGUSON(INTERSECTION)- $800,000 CONSTRUCTION SIF123 STREET IF BRIDGER DR&STORY MILL RD $200,000 (INTERSECTION)-DESIGN* SIF125 STREET IF COLLEGE(11TH TO 19TH)-DESIGN $100,000 SIF127 STREET IF FOWLER RIGHT OF WAY PURCHASE $1,000,000 CIP PROJECT FU PROJ. DEPARTMENT PROJECT NAME FY18 FY19 FY20 FY21 FY22 Unscheduled SIF128 STREET IF IKAGY(WILLSON TO HIGHLAND)-DESIGN $500,000 SIF129 STREET IF IKAGY(WILLSON TO HIGHLAND)- $6,000,000 CO NSTRU CTION" SIF130 STREET IF IKAGY(19TH TO WILLSON)INTERIM $500,000 IMPROVEMENTS SIF131 STREET IF 'S 3RD AND GRAF-SIGNAL DESIGN $150,000 SIF132 STREET IF STORY MILL(GRIFFIN TO BRIDGER)- $50,000 DESIGN SIF133 STREET IF GRIFFIN CORRIDOR DESIGN $250,000 SIF134 STREET IF OAK(COTTONWOOD TO FLANDERS $1,300,000 MILL)-CONSTRUCTION SIF135 STREET IF OAK(FERGUSON TO RYUNSON WAY)- $100,000 CONSTRUCTION Summary for Impact Fees Streets(45 items) FY28 FY19 FY20 FY21 FY22 Unscheduled Totals by year: $11,920,049 $2,340,421 $6,900,000 $2,325,000 $1,000,000 $36,236,584 Arterial&Collector District Fund Capital Improvement Plan Financial Summary Current Year Projected FY17 FY18 FY19 FY20 FY21 FY22 Unscheduled Projected Beginning Reserve Balance Dedicated to CIP $ 1,005,600 $ 1,070,600 $ (783,245) $ 248,444 $ (487,004) $ 895,839 Plus: Assessment Revenues Dedicated to CIP $ 1,095,000 $ 2,080,500 $ 2,122,110 $ 2,164,552 $ 2,207,843 $ 2,252,000 $ Less: Scheduled CIP Project Costs $ (1,030,000) $ (3,934,345) $ (1,090,421) $ (2,900,000) $ (825,000) $ (750,000) $ (13,464,146) Projected Year-End Cash Dedicated to CIP $ 1,070,600 $ (783,245) $ 248,444 $ (487,004) $ 895,839 $ 2,397,840 $ (13,464,146) Beginning Balance of Payback Improvements: $ - $ - $ (2,544,666.00) $ (2,677,666) $ (2,677,666) $ (3,177,666) $ (3,177,666) SIF036-Payback District $ $ (1,278,000) $ SIF046-Gallatin County SID $ (600,000) SIF073-Payback District $ (404,000) SIF076-Payback District $ (500,000) SIF080-Gallatin County SID $ (333,333) SIF080-Payback District $ (333,333) SIF105-Payback District $ (1,240,000) SIF109-Gallatin County Payback/SID $ (133,000) SIF113-Payback District $ (2,OD0,000) SIF127-Payback District $ (225,000) Ending Balance of Payback Improvements: $ $ (2,544,666) $ (2,677,666) $ (2,677,666) $ (3,177,666) $ (3,177,666) $ (4 821666) Assumptions Made for Revenue Estimates: Current Year Projected FYI FY18 FY19 FY20 FY21 FY22 Estimated Annual Assessment Revenues $ 565,000 $ 1,095,000 $ 2,080,500 $ 2122,110 $ 2,164,552 $ 2,207,843 Estimated Annual Increase 95.0% 90% 2% 2% 2% 2% Total Estimated Revenues $ 1,095,000 $ 2080,500 $ 2,122110 $ 2,164,552 $ 2,207,843 $ 2,252,000 Current Revenues Dedicated to CIP% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Plus: Increase Dedicated to GP 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Total%Dedicated to CIP 100.0% 100.0% 100.0% 100.0% 100.096 100.0% Total Estimated Revenues Dedicated to CIP $ 1,095,000 $ 2080,500 $ 2,122,110 $ 2,164,552 $ 2,207,843 $ 2,252,000 Arterial & Collector Projects 14,000,000 9,000,000 — CURRENT 4,000,000 FY18 FY19 FY20 FY21 FY22 Unscheduled CIP PROJECT FU PROJ. DEPARTMENT PROJECT NAME FY18 FY19 FY20 FY21 FY22 Unscheduled Arterial&Collector Streets SIF036 STREET IF COTTONWOOD(BABCOCK TO $1,278,000 DURSTON)-CONSTRUCTION* SIF039 STREET IF FERGUSON&DURSTON(INTERSECTION)- $451,244 CONSTRUCTION SIF046 STREET IF OAK(NEW HOLLAND TO FERGUSON)- $600,000 CONSTRUCTION* SIF057 STREET IF OAK(FLANDERS MILL TO RYUNSON $500,000 WAY)-CONSTRUCTION SIF058 STREET IF OAK&N 27TH(INTERSECTION)- $122,146 CONSTRUCTION SIF061 STREET IF OAK&FERGUSON(INTERSECTION)- $269,066 SIGNAL CONSTRUCTION SIF062 STREET IF DURSTON(FOWLER TO FERGUSON)- $757,421 CONSTRUCTION SIF063 STREET IF FOWLER&BABCOCK(INTERSECTION)- $400,000 CONSTRUCTION SIF073 STREET IF FOWLER&DURSTON(INTERSECTION)- $404,000 SIGNAL CONSTRUCTION* SIF074 STREET IF OAK&DAVIS(INTERSECTION)- $352,302 ROUNDABOUT CONSTRUCTION SIF076 STREET IF FOWLER CONNECTION(HUFFINE TO $500,000 OAK)-DESIGN(INCLUDES 3 INTERSECTIONS)* SIF080 STREET IF FERGUSON(BAXTER TO OAK)- $666,666 CONSTRUCTION* SIF086 STREET IF BAXTER&COTTONWOOD $500,000 (INTERSECTION)-CONSTRUCTION SIF098 STREET IF OAK&COTTONWOOD(INTERSECTION)- $548,000 ROUNDABOUT CONSTRUCTION SIF104 STREET IF COTTONWOOD&BABCOCK $287,067 (INTERSECTION)-SIGNAL CONSTRUCTION SIF105 STREET IF COTTONWOOD(DURSTON TO OAK)- $1,240,000 CONSTRUCTION* SIF108 STREET IF S 3RD AND GRAF-SIGNAL CONSTRUCTION $200,000 CIP PROJECT FU PROJ. DEPARTMENT PROJECT NAME FY18 FY19 FY20 FY21 FY22 Unscheduled SIF109 STREET IF OAK(ROUSE THROUGH CANNERY $133,000 DISTRICT)-CONSTRUCTION* SIF110 STREET IF MANLEY&GRIFFIN(INTERSECTION)- $400,000 CONSTRUCTION SIF111 STREET IF HIGHLAND(MAIN TO KAGY)- $5,000,000 CONSTRUCTION&DESIGN* SIF112 STREET IF HIGHLAND&MAIN INTERSECTION $30,000 IMPROVEMENTS SIF113 STREET IF GRIFFIN(7TH TO ROUSE)- $2,000,000 CONSTRUCTION* SIF114 STREET IF FOWLER CONNECTION(HUFFINE TO $3,750,000 OAK)-CONSTRUCTION* SIF115 STREET IF COLLEGE(11TH TO 19TH)- $550,000 CONSTRUCTION SIF116 STREET IF BRIDGER DR&STORY MILL RD $200,000 (INTERSECTION)-CONSTRUCTION SIF117 STREET IF STORY MILL(GRIFFIN TO BRIDGER)- $225,000 CONSTRUCTION* SIF118 STREET IF BABCOCK(11TH AVE TO 19TH AVE)- $750,000 CONSTRUCTION* SIF121 STREET IF BAXTER&DAVIS(INTERSECTION)- $500,000 CONSTRUCTION SIF125 STREET IF COLLEGE(11TH TO 19TH)-DESIGN $100,000 SIF134 STREET IF OAK(COTTONWOOD TO FLANDERS $250,000 MILL)-CONSTRUCTION Summary for Arterial&Collector Streets(30 items) FYI8 FY19 FY20 FY21 FY22 Unscheduled Totals by year: $3,934,345 $1,090,421 $2,900,000 $825,000 $750,000 $13,464,146