10-24-2016 Council Work Session Packet

Home Browse Search

MSA Fund irrent Fund Balance: $0 State MSA Construction Balance= $0 Table B -5a Table B-7 Project 2017 Project 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Annual Expenditures (MSA CIP) $0 $0 $645,195 $339,094 $223,660 $442,406 $467,168 $578,934 $2,215,822 $271,613 $282,528 $293,935 $305,861 $318,332 Annual MSA Maintenance Payment to the City $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 $68,954 Debt Service (interest) -from MSA maintenance account. 1 $39,438 1 $36,288 1 $33,138 1 $29,838 1 $26,388 $22,938 1 $19,188 1 $14,813 1 $10,125 1 $5,250 $288,783 $346,847 $305,152 $313,707 Debt Service (Principal) -from MSA Construction Account $105,000 $105,000 $110,000 $115,000 $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 $0 $0 Total Expenses $213,391 $210,241 $857,286 $552,885 $434,001 $654,297 $680,309 $787,700 $2,424,901 $485,816 $351,481 $362,889 $374,815 $387,285 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 Annual Balance ($360,534) ($1,000,288) ($1,484,387) ($891,049) ($391,338) ($1,205,998) ($757,441) ($995,946) Yearly Allocation - MSA Maintenance $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 Yearly Allocation - MSA Construction $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 Annual Balance $112,193 $115,343 ($531,702) ($227,301) ($108,417) ($328,713) ($354,725) ($462,116) ($2,099,317) ($160,232) ($25,897) ($37,305) ($49,231) ($61,701) Year End Cash Balance $112,193 $227,536 ($304,166) ($531,467) ($639,884) ($968,597) ($1,323,322) ($1,785,438) ($3,884,755) ($4,044,987) ($4,070,884) ($4,108,189) ($4,157,420) ($4,219,122) Pavement Management Fund Current Balance: $0 Table B -5b Table B-7 Project 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Annual Operation and Maintenance (1) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $540,534 $1,180,288 $1,664,387 $1,071,049 $571,338 $1,385,998 $937,441 $1,175,946 $1,274,217 $1,308,288 $1,202,154 $1,122,129 $1,522,223 $1,556,897 Total Expenses $540,534 $1,180,288 $1,664,387 $1,071,049 $571,338 $1,385,998 $937,441 $1,175,946 $1,274,217 $1,308,288 $1,202,154 $1,122,129 $1,522,223 $1,556,897 $720,955 $288,783 $346,847 $305,152 $313,707 Total Expenses $844,447 $928,659 $861,343 $939,012 $897,180 $1,144,860 $946,066 $1,036,812 Revenues(1) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Pavement Management Levy $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 $180,000 Annual Balance ($360,534) ($1,000,288) ($1,484,387) ($891,049) ($391,338) ($1,205,998) ($757,441) ($995,946) ($1,094,217) ($1,128,288) ($1,022,154) ($942,129) ($1,342,223) ($1,376,897) Year End Cash Balance ($360,534) ($1,360,822) ($2,845,209) ($3,736,258) ($4,127,596) ($5,333,594) ($6,091,035) ($7,086,981) ($8,181,198) ($9,309,486) ($10,331,640) ($11,273,769) ($12,615,991) ($13,992,888) Water Fund Current Balance: $1,730,000 $2,265,325 Table B-6 Table B-7 Project 2017 1 2018 1 2019 2020 2021 1 2022 1 2023 1 2024 1 2025 1 2026 1 2027 1 2028 2029 1 2030 Annual Operation and Maintenance (1) $468,447 $480,159 $492,163 $504,467 $517,078 $530,005 $543,255 $556,837 $570,758 $585,027 $599,652 $614,644 $630,010 $645,760 Debt Service $156,000 $160,000 $157,000 $156,000 $155,000 $158,000 $101,500 $100,000 $100,000 $100,500 $104,000 $100,600 $103,000 CIP Expenditures $220,000 $288,500 $212,180 $278,545 $225,102 $456,855 $301,310 $379,975 $433,354 $720,955 $288,783 $346,847 $305,152 $313,707 Total Expenses $844,447 $928,659 $861,343 $939,012 $897,180 $1,144,860 $946,066 $1,036,812 $1,104,112 $1,406,481 $992,436 $1,062,090 $1,038,162 $959,467 $1,968,757 Revenues (1) $736,796 $758,900 $781,667 $805,117 $829,270 $854,148 $879,773 $906,166 $933,351 $961,351 $990,192 $1,019,898 $1,060,694 $1,092,514 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0 $0 Annual Balance ($97,265) ($159,372) ($69,289) ($123,508) ($57,523) ($280,325) ($55,906) ($120,259) ($160,374) ($445,130) ($2,244) ($42,193) $22,532 $133,048 Year End Cash Balance $1,632,735 $1,473,363 $1,404,075 $1,280,566 $1,223,043 $942,718 $886,812 $766,554 $606,180 $161,050 $158,806 $116,614 $139,145 $272,193 Sewer Fund Current Balance: $2,265,325 Table B-7 Project 2017 1 2018 2019 1 2020 2021 1 2022 1 2023 1 2024 1 2025 1 2026 1 2027 1 2028 2029 1 2030 Operation and Maintenance (1) $970,278 $994,535 $1,019,399 $1,044,884 $1,071,006 $1,097,781 $1,125,226 $1,153,356 $1,182,190 $1,211,745 $1,242,038 $1,273,089 $1,304,917 $1,337,540 Debt Service $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 CIP Expenditures $600,710 $468,723 $909,505 $865,685 $572,776 $574,289 $539,237 $554,635 $544,494 $597,828 $577,653 $594,983 1 $612,832 $631,217 Total Expenses $1,680,988 $1,573,259 $2,038,904 $2,020,569 $1,753,781 $1,782,070 $1,664,463 $1,707,991 $1,726,684 $1,809,573 $1,819,692 $1,868,072 $1,917,749 $1,968,757 Revenues (1) $1,308,898 $1,361,254 $1,415,704 $1,472,333 $1,531,226 $1,592,475 $1,656,174 $1,722,421 $1,791,318 $1,862,970 $1,862,970.33 $1,909,545 $1,957,283 $2,006,215 Assessments $35,349 $35,349 $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 $0 $0 Annual Balance ($336,741) ($176,655) ($587,850) ($517,868) ($195,622) ($164,693) $9,280 $31,999 $75,573 $55,397 $43,279 $41,472 $39,534 $37,458 Year End Cash Balance $1,928,584 $1,751,929 $1,164,079 $646,210 $450,589 $285,896 $295,176 $327,175 $402,748 $458,145 $501,423 $542,896 $582,430 $619,888