Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05. CIP Worksheets
Inflation Assumptions 1 Revenue (Non-property tax)0.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 0.00%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50% 3 Expenses 0.00% 4 CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2034 2035 2036 2037 ACTUAL Actual Approved Projected REVENUE 5 Property taxes 217,336 293,791 235,000 125,000 150,000 156,000 162,240 168,730 175,479 182,498 189,798 205,285 213,497 222,037 230,918 6 Intergovernmental - - - - - - - - 7 Capital Improvement Debt Levy - - - - - - - - 8 Special assessments - - - - - - - - - - - 9 Investment Income 3,126 2,300 1,500 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10 Refunds and Reimbursements11Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - 13 Miscellaneous Revenue - - - - - - - - - - 14 Total Revenue 220,462 296,091 236,500 126,000 151,000 157,000 163,240 169,730 176,479 183,498 190,798 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 148,059 384,429 168,842 598,000 169,025 195,000 49,633 254,016 100,000 618,083 19 Total Expenses 296,733 148,059 384,429 168,842 598,000 169,025 195,000 49,633 254,016 100,000 618,083 20 Revenue Over / (Under) Expenses (76,271) 148,032 (147,929) (42,842) (447,000) (12,025) (31,760) 120,097 (77,537) 83,498 (427,286) OTHER FINANCING SOURCES / (USES)21 Bond Proceeds 22 Transfers In - 8,000 - - - - - - - - - 23 Transfers Out to Sewer Fund (2,640) 24 Transfers Out-(150,000) 25 Total Other Sources / (Uses)- 5,360 (150,000) - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 564,735 718,127 420,198 377,356 (69,644) (81,669) (113,429) 6,667 (70,870) 12,628 (223,859) 889,045 889,045 889,045 889,045 CITY OF SCANDIA CITY OF SCANDIA Capital Improvement Plan Capital Improvement Plan Capital Improvement Fund 401 Capital Improvement Fund 401 CASH FLOW ANALYSIS Project Multiple 2022 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2034 2035 2036 2037 Capital Project Name Number Year?Year Last Year Costs ACTUAL Actual Approved Projected 29 12,000 30 Broadband Development Grants to MIDCO 2022 319,280 236,700 31 Development Code Update 2022 36,962 5,771 32 Community Center Improvements-Doors & security 2022 20,000 16,609 33 Council Chambers remodel 2022 25,000 5,103 34 Gateway Trail 2025 58,078 30,000 230,000 35 Broadband Development Grants to MIDCO 2023 119,500 12,750 119,500 92,000 300,000 36 Scandia City Center Study 2023 50,000 49,349 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 65,000 16,250 38 Council Chambers remodel 2023 12,309 39 Security Improvements CCTV for Park 2024 14,000 14,000 40 Bliss Additions Stormwater plan 2023 100,000 117,429 135,000 41 new Exhaust removal system for truck bays 2024 53,993 60,000 42 new Warning Sirens 2025 28,122 31,633 43 Arts & Heritage Center Amphitheater 2027 33,746 44 Arts & Heritage Center Sidewalk and Walkways 2027 195,143 45 CC AC Condenser Replacement 2025 33,746 46 Lobbying 2025 100,000 47 Fire/PW Potable Well Pump (2000) Replacement 2026 10,000 12,000 48 2010 Fire Radios Replace 3 unspupported radios 2030 17,548 18,000 49 2010 Homatro Cutter Twin Line R-1(Jaws of Life)2030 40,945 40,945 50 2015 Lucas CPR Device-replacement 2030 17,548 17,548 51 Cold Storage Building 2030 81,890 130,000 31,000 52 Additional Comm Cent Elec Locks 2030 17,548 18,000 24,016 53 Large Hall and Heritage Room Carpeting 2030 58,493 54 2000 Station Bay floor epoxy coating-maintenance 2031 21,900 21,900 55 2010 Washer/Extractor-replacement 2031 9,125 9,125 56 2017 Thermal Imaging Cameras (1of3) find hot spots 2031 9,733 7,000 57 Zoll Monitor/Defib 2031 36,000 36,000 58 Second Fire Station 2032 227,757 337,136 59 Community Center Design & Planning 2032 189,798 280,947 60 Air Containment Unit 2033 10,527 61 Community Center Improvements-Front Office + Equip Room 45,000 62 CIP placeholder - SERVER REPLACEMENT Yes 2035 2036 75,000 7,800 15,000 63 Fire/PW Back-up Generator 2023 2043 73,775 64 Fire/PW Cameras x 11 2020 2035 12,904 63 Fire/PW Door Access 2020 2026 10,046 64 Fire/PW all lighting 2019 2039 18,420 65 Parking lot replacement 2020 2040 57,749 64 Fire HVAC 2020 2040 33,892 65 Fire/PW Roof 2021 2046 119,118 66 Main Fire Station 2000 2025 1,528,727 67 Fire Bay Air Exchanger 2000 2050 68 Washer/extractor 30#55 2020 2035 7,469 69 RamAir Dryer 2020 2035 7,815 70 12 SCBA & thermal imaging cameras 56 2018 2033 106,918 71 Radio Replacement, 7 Truck, 4 Officer Portable, 13 Portables 2021 2036 105,837 72 Thermal Camera FLIR K65, E-2 56 2021 2031 7,000 7,000 73 Thermal Camera FLIR K65, B-1 56 2021 2031 7,000 7,000 74 Thermal Camera FLIR K2, E-1 56 2016 2026 7,000 75 Battery Jaws of Life Set E-2 2019 2034 32,197 76 Fire/PW - 1998 Federal Thunderbeam Siren 2013 2033 7,928 77 Siren Lofton/232 2009 2049 17,208 78 Bliss - 1998 Federal Thunderbeam Siren 2013 2033 7,928 79 Building Exterior Sealing - Fire/PW 2000 2026 80 High volume well casing 2000 2050 81 High volume well Pump 2008 2033 82 Drinking water Well Casing 2000 2050 83 CC Kitchen Floor 2026 25,000$ 84 CC Hall Floor 2027 25,000$ 85 CC Ceiling TIles i 2027 20,000$ 86 CC Hall HVAC Upgrade 2027 50,000$ 87 CC Roof Replacement 2030 100,000$ 88 Warming House Roof Replacement 2030 30,000$ 89 Warming House ADA Upgrade 2031 50,000$ 90 PW/Fire Air Compressor 2027 10,000$ 91 PW/ Fire Vehicle Pressure Washer 2026 10,000$ 92 PW/Fire Salt Storage Expansion 2030 100,000$ 93 Total Capital Projects 2,249,276 296,733 148,059 384,429 168,842 598,000 169,025 195,000 49,633 254,016 100,000 618,083 - - - - PROJECTED NEW DEBT TERMS Updated KHM As of Date:6/27/2023 1 Par Amount (Line 14)- - - - - - - - - - - 2 Number of Years 15 15 15 15 15 15 15 15 15 15 15 3 Interest Rate 0 0 0 0 0 0 0 0 0 0 0 4 New Debt Levy - - - - - - - - - - - Capital Project OutlayCapital Project OutlayProject CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund Inflation Assumptions 4 CIP Inflation Factor 0.00% 2.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed REVENUE 5 Property taxes 20,000 60,000 40,000 40,000 40,000 40,000 41,600 43,264 44,995 46,794 6 Intergovernmental 112,500 7 Charges for services 8 Investment Income 66 66 66 66 66 66 66 66 66 66 9 Sale of capital assets 10 Park Dedication Fees 24,000 24,000 - - - - - - - - 11 Rental and lease income - - - - - - - - - - Transfer from General Fund 150,000 125,000 12 Miscellaneous Revenue 8,068 13 Total Revenue 314,634 209,066 40,066 40,066 40,066 40,066 41,666 43,330 45,060 46,860 EXPENSES 14 Total Current 15 Debt service 16 Total Capital Projects 333,739 335,000 115,000 25,000 16,010 200,000 60,000 128,083 - - 17 Total Expenses 333,739 335,000 115,000 25,000 16,010 200,000 60,000 128,083 - - 18 Revenue Over / (Under) Expenses (19,105) (125,934) (74,934) 15,066 24,055 (159,934) (18,334) (84,754) 45,060 46,860 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 150,000 21 Transfers Out 8,000 22 Transfers Out- 22 Total Other Sources / (Uses) 8,000 150,000 - - - - - - - - 23 Prior Period Adjustments 24 Ending Fund Balance 63,927 87,993 13,058 28,124 52,179 (107,756)(126,090)(210,844)(165,784)(118,924) CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 CASH FLOW ANALYSIS 2021 2016 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year Costs Proposed 25 25 Park Planning 2022 15000 4,500 26 Community Center Park-concrete, grill, table, benches 2022 112500 27 Playground Equipment - Community Center Park 2022 122500 180,319 28 Lilleskogen Park Picnic Shelter 2024 43700 29 Gateway Trail Improvements @ Annex 2024 0 25,000 30 Hay Lake Park - sign 2023 8653 1,500 31 Park signage at Orwell Park (Liten)2023 8653 800 32 Replace rink boards 2024 134984 146,620 33 Lilleskogen Praire/Wetland Restoration Project 2025 12878 34 Nature park trails 2025 42700 35 Playground Equipment - Erickson ballfield 2028 66682 100,000 36 Tennis Court/Pickle Ball - repaint 2024 60533 335,000 115,000 37 Expanded Pleasure Rink 2027 12653 16,010 38 Hay Lake Park Shelter water & doors 2027 101226 128,083 39 Ballfield Infield Reconstruction 2029 60000 60,000 40 Wayne Erickson Pavilion/Storage 2028 100000 100,000 41 CIP Place Holder 2031 50000 42 Total Capital Projects 952,662 - 333,739 335,000 115,000 25,000 16,010 200,000 60,000 128,083 - - PROJECTED NEW DEBT TERMS 43 Par Amount (Line 19) - - - - - - - - - - - 44 Number of Years 10 10 10 10 10 10 10 10 10 10 10 45 Interest Rate 2.50% 3.00% 3.00% 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 46 New Debt Levy 0 0 0 0 0 0 0 0 0 0 0CAPITAL OUTLAYProject CAPITAL OUTLAY Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 REVENUE 5 Property taxes 110,000 125,000 150,000 157,500 165,375 173,644 182,326 191,442 201,014 211,065 221,618 232,699 244,334 256,551 269,378 282,847 6 Debt service levy - 38,997 107,617 104,553 132,403 129,519 157,409 180,914 178,018 175,122 172,226 168,266 133,307 131,602 99,113 97,379 7 Intergovernmental - - - - - - - - - - - - - - - - 8 Sale of capital assets 45,219 - - - - - - - - - - - - - - 9 Investment Income 1,045 1,061 1,077 1,093 1,109 1,126 1,143 1,160 1,177 1,195 1,213 1,231 1,249 1,268 1,287 1,306 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - - - - - - 13 Miscellaneous Revenue 14 Total Revenue 156,264 165,058 258,694 263,146 298,887 304,289 340,878 373,516 380,210 387,382 395,058 402,196 378,890 389,421 369,779 381,532 EXPENSES - Paid in debt service fund 15 Total Current - - - - - - - - - - - - - - - - 16 Debt service - 37,140 102,492 99,574 126,098 123,352 149,913 172,299 169,541 166,783 164,025 160,253 126,959 125,335 94,394 92,742 17 Total Capital Projects 527,721 1,257,516 149,160 400,000 146,912 491,828 605,220 446,657 607,353 - 150,000 700,563 - - 998,616 - 18 Total Expenses 527,721 1,294,656 251,652 499,574 273,010 615,179 755,133 618,956 776,894 166,783 314,025 860,816 126,959 125,335 1,093,010 92,742 19 Revenue Over / (Under) Expenses (371,457) (1,129,598) 7,042 (236,428) 25,876 (310,890) (414,255) (245,440) (396,685) 220,599 81,033 (458,620) 251,931 264,086 (723,231) 288,790 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 340,000 450,000 - 400,000 - 250,000 300,000 - 350,000 21 Transfers In 446,422 22 Transfers Out 23 Transfers Out- 24 Total Other Sources / (Uses)786,422 450,000 - 400,000 - 250,000 300,000 - 350,000 - - - - - - - 25 Prior Period Adjustments 26 Ending Fund Balance 562,586 (117,012)(109,970)53,601 79,478 18,588 (95,668)(341,107)(387,792)(167,193)(86,160)(544,780)(292,849)(28,763)(751,994)(463,204) CITY OF SCANDIA Capital Improvement Plan Equipment Replacement Fund 406 CASH FLOW ANALYSIS 2021 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Capital Project Name First Year Last Year Costs 27 312-08 Asphalt Patching Equipment Trailer (2008) 2025 39,000 25,000$ 28 2000 Engine 1 - 5176 Replacement 2026 650,000 142,789$ 663,828$ 29 2003 Tanker 5178 Tender 2 Replacement 2025 292,000 101,987$ 288,179$ 30 201-14 Mack Single Axle w/Plow (2014)2029 275,000 415,000$ 31 202-17 Western Star Single Axle Truck/Plow (2017) 2028 350,000 400,000$ 32 203-11 Mack Dump Truck/Plow Replacement (2011) 2023 325,000 305,509$ 33 301-98 John Deere Motor Grader (1998)2031 480,000 607,353$ 34 JD-6130M (2021) tractor with/ attachments 2035 275,000 275,000$ 35 New Holland 325 Skid Steer (2024)2040 200,000 60,368$ 200,000$ 36 - 37 101-18 Chev 1/2 ton pickup (2018)2028 44,000 61,912$ 38 102-19 Dodge 3500 SRW w/plow (2019)2029 52,000 76,828$ 39 103-21 Dodge 2500 w/plow (2021)2031 62,000 100,991$ 40 Ford F550 Dump Truck (2024)2034 150,000 100,312$ 150,000$ 41 1995 Utility 1misc purpose truck - replacement 2023 86,500 61,117$ 42 2003 Boat & Trailer - water rescues 2023 38,000 38,192$ 43 303-17 John Deere 1575 Mower w/Broom & Blower (2023) 2030 115,000 115,000$ 44 303-17 John Deere 1575 w/Broom & Blower (2017) 2030 75,000 116,350$ 45 304-21 Kubota UTV (2021)2030 16,000 24,821$ 46 Addition Vehicle (truck for addl FT or PT staff)2025 50,500 60,000$ 47 Equipment Attachments (fit skid, loader, tractor)2024 10,000 22,956$ 48 PJ Skid Trailer 14,000 lbs (2012)2025 17,000 20,000$ 49 Rescue 5179 Replacement 2030 225,000 349,049$ 50 Utility Trailer 3,500 lbs (1998)2025 8,000 10,000$ 51 2012 UTV & Trailer replacement off road rescue 2031 -$ -$ 42,583$ -$ -$ -$ -$ 60,609$ -$ -$ -$ -$ -$ -$ -$ -$ 52 2015 Tender - 1 2035 2015 214,938 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 425,563$ -$ -$ -$ -$ 53 2018-Brush-1 2038 2018 90,740 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 207,978$ -$ 54 2013-Engine-2 2038 2013 344,953 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 790,639$ -$ 55 Officer/Chief Vehicle 2026 60,000 -$ -$ 76,577$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 56 John Deer 234L Loader 2031 175,000 -$ -$ -$ -$ -$ -$ -$ 285,057$ -$ -$ -$ -$ -$ -$ -$ -$ 57 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 58 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 59 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 52 Total Capital Projects 4,720,631 527,721 1,257,516 149,160 400,000 146,912 491,828 605,220 446,657 607,353 - 150,000 700,563 - - 998,616 - PROJECTED NEW DEBT TERMS As of Date:6/27/2023 53 Par Amount (Line 14)340,000 515,510 - 250,000 - 250,000 300,000 350,000 - - - - - - - 54 Number of Years 15 15 10 10 10 10 15 10 20 10 10 10 10 10 10 10 55 Interest Rate 5.00%5.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 56 New Debt Levy 0 38,997 107,617 104,553 132,403 129,519 157,409 180,914 178,018 175,122 172,226 168,266 133,307 131,602 99,113 97,379Capital Equipment OutlayProject CITY OF SCANDIA CAPITAL IMPROVEMENT PLAN LOCAL ROAD IMPROVEMENT FUND 408 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%3.50%3.50%3.50%3.50%3.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%4.00%4.00%4.00%7.50%7.50%7.50%7.00%7.00%7.00%7.00%7.00%7.00%7.00%7.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Actual Projected REVENUE 5 Property taxes 216,860 212,012 375,000 440,000 473,000 508,475 546,611 584,873 625,815 669,622 716,495 766,650 820,315 877,737 939,179 6 Debt levy - 2018 GO Bond - 343,166 340,541 343,009 345,161 341,749 343,429 344,794 340,594 341,086 Debt levy - 2024 GO Bond 112,124 187,828 240,098 307,158 334,258 355,688 357,158 363,458 358,628 358,838 355,950 357,788 7 Special assessments 8 Investment Income 4,655 12,115 5,447 10,000 17,650 13,823 4,759 4,029 3,863 4,308 5,417 5,746 6,081 6,477 6,241 9 Refunds and Reimbursements 10 Intergovermental 17,744 63,082 92,350 11 Rental and lease income - - - - - - - - - - - - - - - 12 Miscellaneous Revenue - - - - - - - - - - - - - - - 13 Total Revenue 239,259 224,127 443,529 542,350 490,650 522,298 551,369 588,903 629,677 673,929 721,912 772,395 826,397 884,215 945,419 EXPENSES 14 Total Current 15 Debt service 16 2018 GO Bond 326,825 324,325 326,675 328,725 325,475 327,075 328,275 324,375 324,844 17 2024 GO Bond 342,750 345,550 342,950 340,150 342,150 338,750 340,150 346,150 341,550 341,750 339,000 18 Total Capital Projects 595,069 815,000 3,840,745 665,000 600,000 600,000 600,000 600,000 600,000 600,000 700,000 750,000 800,000 900,000 1,000,000 19 Total Expenses 595,069 815,000 3,840,745 665,000 600,000 600,000 600,000 600,000 600,000 600,000 700,000 750,000 800,000 900,000 1,000,000 20 Revenue Over / (Under) Expenses (355,810) (590,873) (3,397,216) (122,650) (109,350) (77,702) (48,631) (11,097) 29,677 73,929 21,912 22,395 26,397 (15,785) (54,581) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 3,868,542 - 22 Bond premium 23 Transfers In 24 Transfers Out 25 Transfers Out- 25 Total Other Sources / (Uses)- - 3,868,542 - - - - - - - - - 26 Prior Period Adjustments 27 Ending Fund Balance 896,739 155,620 626,946 504,296 394,946 317,244 268,613 257,516 287,193 361,123 383,034 405,430 431,826 416,041 361,460 CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 CASH FLOW ANALYSIS Project Multiple 2022 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital Project Name Number Year?First Year Last Year Costs Actual Proposed Est. 28 700,000 28 Soil Borings for 2024 & 2025 PW-061 2023 20000 25,000 750,000 29 Soil Borings for 2026 & 2027 PW-062 2025 20000 800,000 30 Soil Borings for 2028 & 2029 PW-069 2027 20000 900,000 31 Engineering Fees PW-070 100000 - - - - - - - - - - - 32 2022 Local Road Improvement Project PW-043 2022 707200 707,200 1,000,000 33 2023 Local Road Improvement Project PW-043 2023 671745 671,745 34 2023 Seal Coat & Crack Filling Project PW-050 2023 168374 168,374 2024 Seal Coat & Crack Filling PW-2024 455,000 35 2024 Local Road Improvement Project PW-056 2024 2755745 3,385,745 36 2025 Local Road Improvement Project PW-053 2025 540000 665,000 37 2025 Seal Coat & Crack Filling PW-052 2025 252000 38 2026 Local Road Improvement Project PW-035 2027 870000 600,000 39 2026 Seal Coat & Crack Filling Project PW-051 2027 335000 40 2027 Local Road Improvement Project PW-057 2028 900000 600,000 41 2027 Seal Coat & Crack Filling PW-060 2028 78000 42 2028 Local Road Improvement Project PW-036 2029 1000000 600,000 43 2029 Local Road Improvement Project PW-060 2030 860000 - 600,000 44 2030 Local Road Improvement Project PW-072 2031 880000 - 600,000 45 2031 Local Road Improvement Project PW-073 2032 1000000 - 600,000 46 Total Capital Projects 11,178,064 - 707,200 865,119 3,840,745 665,000 600,000 600,000 600,000 600,000 600,000 600,000 700,000 750,000 800,000 900,000 1,000,000 PROJECTED NEW DEBT TERMS 47 Par Amount (Line 14)- - - 3,635,000 - - - - - - - - 48 Number of Years 9 15 15 15 15 15 15 15 15 10 15 15 15 15 15 15 49 Interest Rate 2.00%2.50%3.87%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%3.00%3.00%3.00% 50 New Debt Levy 0 0 0 0 340,170 340,170 340,170 340,170 340,170 340,170 340,170 340,170 340,170 340,170 340,170 340,170Local Road Project OutlayProject