Loading...
Exh 9 Part 2CITY OF ATLANTIC BEACH Long Term Financial Plan Financial Projection Summary Gas Tax Fund ' Actual Actual Actual Budget Proj Proj Proj Proj Proj Proj Proj Prof Proj FV-96 FY-99 FY-00 FY-O1 FV-02 FY-03 FY-04 FY-OS FY-O6 FY-07 ~ FY-08 FV-09 FY-10 Cash Balance Forward 646,975 940,b23 1,239,066 1,a09,994 306,194 291,036 289,866 703,627 334,129 372,059 426,483 491,023 560,063 Revenues Local Op0on Gas Taxes 438,661 458,447 481,274 477,216 497,532 506,278 521,467 537,711 553,224 569,821 586,9(5 604,523 622 659 Interest Earnings 38,971 54,079 80,839 70,943 15,3 t0 (4,552 14,493 (5,791 76,706 18,603 21,424 24,557 28 004 Other Revenues Total Revenue 477,632- 612,460 562,113 648,159 506,842 620,830 b35,960 552,302 569,931 588,424 608,340 629,074 650,667 Expenses Operating 0 773,477 301,39( 700,000 - 139,525 235,000 .263,000 ~ 265,000 200,000 460,000 473800' 488,014 502,654 Capital 0 0 5,700 7,480,000 0 0 0 0 0 0 0 0 0 Transfers 85,227 63,940 84,114 71,959 382,475 287,000 259,000 257,000 332,000 .72,000 72,000 72,000 72,000 Total Ecpensec 65,227 237,417 191,205 1,651,959 622,000 522,000 522,000 522,000 532,000 - 532,000 545,800 660,014 674,654 Net Change lh Cash Balance 792,405 275,047 170,908 •1,103,800 -t 5,158 -7,170 13,960 30,302 .37,931 Sfi,424 62,640 69,060 76,008 Net Change In Working Capital 857 23,620 Ending Cash Balanee 940 623 1 279 086 1,409,994 306 194 291,076 289 866 303 827 334 129 372 059 428 483 491,023 b60 083 636 091 Restricted 940,523 1,239,088 1,409,994 306,194 291,036 - 289,866 - 303,827 339,129 372,059 428,483 491 023 560,083 636 091 Designatetl - 870,000 870,000 1,000,000 l/nresfrlc[ed 0 0 0 0 ~ 0 0 0 0 0 0 0 0 0 N Detatl Restricted Restricted for Streets 940,523 1,239,086. 1,409,994 306,194 297,036 289,866 ... 303,827 . 334,129 372,059 428,483 491,023 560,083 636,091 940,623 1,239,086 1,409,994 306,194 291,036 289,666 303,827 334,129 372,059 426,483 497,023 560,083 636,091 a 9 ~ nd x9 ~~ o~ o~ ~~ AGENDA ITEM #9 MARCH 26, 2001 City of Atlantic Beach Gas Tax Fund Total Revenues and Expenditures 2,000 1,500 `~ ~ 1,000 0 0 o 500 0 ~-~~~ ~ ~ ~ ~ ~ ~ N N ~C t0 O O Cfl O O O 00 CO O ~ N O O N N O O W ,, ~, ~ ~ N N O O O O ~ O N O O O N O O V ~ ~ ~ ~ ~ ~ N N N O O O O O ~ 00 CO O -+- Revenues ~ Capital Outlay ~ Personal Services 0 Transfers Out ® Operating Expenses 13 A Cash Balance Forward Revenues Convention Development Taxes Interest Earnings ' ONer Revenues Total Revenue Expenses Operating Transfers Total EZpenaes ' Net Change in Cash Balance Net Change in Working Capital Ending Cash Balance Reslrictetl Designated Unrestricted Detail Restricted Tourism /Recreation CITY OF ATLANTIC BEACH Long Term Financial Plan Financial ProjectionSummary Convention Development Tax Fund AcWai AcWal Actual Budget Proj Proj Praj Proj Proj Prof Proj Proj Proj FY-98 FY-99 FY-00 FY-01 FY-02 FY-07 FY-04 FY-OS FV-O6 FY-07 FY-08 FY-09 FY-10 94 626 141,276 142,016 45 360 96 479 62 037 66,940 72,107 77,550 87,283 89,312 95,682 102,378 62,784 60,060 54,744 67,172 67,784 62,402 63,026 63,656 64,292 64,935 65,585 66,241 66,903 5,709 6,938 4,667 .9,947 4,774 3,702 3,347 3,605 3,877 ~ 4,764 q,4fi6 4,784 5,119 67,893 66,998 69,411 66,119 66,558 65,503 66,173 67,261 68,170 69,099 70,057 77,025 72,022 17,000 ~ 65,626 ! i 000 15 000 0 0 0 0 0 0 0 0 0 4,000 0 159,808 0 100,000 60,600 67,206 67,678 62,436 63,061 63697 64328 64971 21,000 66,626 160 BOB 15,000 700 000 fi0 600 61 206 61 818 62 416 63 061 fit 691 64 328 64 971 46,891 1,172 -101,397 50,119 -33,442 4,901 6,167 6,443 5,734 6,039 6,360 6,696 7,050 -244 -671 4,741 141,276 142,016 45,360 95,479 62,017 66,940 72,107 77,560 63,263 89,322 85,682 102,378 109 429 141,275 142,076 45,360 95,479 62,037 66,940 72,107 77,550 83,283 89,322 .95,682 702,376 109,429 0 0 ' 141,275 142,016 45,360 95,479 62,037 66,940 72,107 77,550 83,283 89,322 95,682 702378 109429 141,276 142,016 45,360 95,479 62,037 66,940 72,107 77,550 83,283 89,322 95,682 102,378 109,429 nl- ~ ~ ill nd xa .. ~~ N O O ~ ~' b CITY OF ATLANTIC BEACH - Long Term Financial Plan Financial Projection Summary Water and Sewer Utility Combined Summary Revised Actual Actual Actual Budget Prof Proj Prof Proj Proj Proj Prof Prof Proj FY-98 FY•99 FY-00 FY-01 FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FV-09 FY-10 ~ Cash Bafance Forward Revenues C a es For Services h rg Assessments Other Revenues To[al Revenue ' Expenses Personal Services I Operating Capital Debt Transfers Total Expenses Net Change in Cash Bafance lde[ Change in Working Caplfal I Entling Cash Balance Restricted Designatetl Unrestricted ] Detail Restricted 7,936,415 8,267,332 7,750,787 6,210,825 5,684,960 5,510,442 5,158,203 4,916,976 4,914,661 4,924,056 4,986,670 5,095,048 6,391,966 _ 4,492,275 4,522,714 4,806,772 4,952,744 5,398,491 5,668,416 5,951,836 6,152,706 6,360,495 6,575,445 6,797,809 7 027 849 7,265,834 207,314 182,389 ~ 155,291 272,250 106,757 106,757 106,757 106,757 106,757 106,757 106,757 106,757 106,757 1,129,125 1 042,977 1,086,004 1,565,141 826,482 805,935 790,317 773,656 766,254 765,617 767,241 771,817 782,720 5,828,714 5,748,080 6,048,067 6,790,135 6,331,730 ~ 6,581,107 6,648,910 7,033,119 7,233,505 ~ 7,447,819 7,671,807 7,906,423 8,156,311 -14% 5.2% 123% -6 e% 39% 4.1% - 2]% 2.9% 30Y. 30% 31% 3.1% 954,581 971,506 1,030,102 1,015,665 1,087,168 1,122,436 1,157,495 1,193,676 1,231,015 1,269,551 1,309,323 1,350,372 1,392,741 2,028,461 2,266,958 2,449,026 2,903,419 2,643,081 2,808,550 2,885,552 2,905,553 3,006,886 3,112,033 3,221,157 3,334,425 3,452,016 256,859 -661,774 1,341,649 1,606,200 971,000 1,185,000 1,215,000 1,095,000 1,129,500 .1,131,000 1,150,000 1,025,000 1,085,000 1,062,016 1,058,785 1,440,181 1,390,716 1,393,000 1,393,000 1,393,000 1,393,000 1,393,000 1 393,000 1,393,000 1,393,000 1,393,000 923,261 1,093,112 424,942 400,000 412,000 424,360 437,091 450,204 463,710 477,621 491,950 506,708 521,909 5 225 176 ~ 6 052 135 6 685,900 7,316,000 6 506,249 6 933 346 7,086,138 7 037 433 7 224 111 7 383 205 7 665 429 7 609 505 7 844 667 15.8% 10.5% e4% -11.1% 6.6% 22% -O]% 2]% - - 22% 25% e6% 3.1% 603,536 -304,055 637,833 525,865 -174,516 -352,238 -239,228 -4,314 9,395 64,614 106,378 296,916 310,644 -274,619 -212,490 502,129 6 267,332 7 750 787 6 210 825 5 664 960 5 510442 5 158 203 4 918 976 4 914 661 4 924 056 4 988 670 5 095 048 5 391 966 5 702 610 2,273,088 0 2,376,983 921,790 2,556,153 0 2,622,808 0 2,580,312 0 2,633,586 0 2 664,784 - 0 2,682,108 0 2;720,153 0 2,759,551 0 2,800,357 0 2 842,626 0 2,886,417 0 5,994,244 5,373,804 3,654,672 3,062,152 2,930,130 2,624,617 2,254,191 2,232,553 2,203,903 2,229,118 2,294,691 2,549,340 2,616,193 Bond Debt Service Reserve 531,008 529,393 720,090 695,358 696,500 696,500 696,500 696,500 696,500 696,500 696,500 696,500 ~ 696,500 Renewal and Replacement 500,000 500,000 500,000 500,000 500,000 500,000 500,000 .500,000 500,000 500,000 500,000 500 000 500,000 Operating Reserve (25%) 1,242,080 4;347,590 - 1,336,06& 1,427,450 -1,383;812 1,437,066 - 1,468,284 - 1,485,608 1,523,653 - - 1,563;051- 1,603,857 - - -0,646,126 1;689,917 - 2,273,088 2,376,983 2,556,153 2,622,606 2,580,312 2,633,586 2,664,784 2,682,108 2,720,153 2,759,551 2,800,357 2,842,626 2,886,417 ~ L) xa a~ N y O rl O ~ r+ ~ CITY OF ATLANTIC BEACH Long Term Financial Plan Financial Projection Summary Water Utility Cash Balance Forward Revenues Charges For Services Assessments Other Revenues Total Revenue Expenses Personal Services Operating Capital Debt Transfers Total Expenses Net Change in Cash Balanea _ Net Change in Working Capital D\ Entling Cash Balance Restflcted Designatetl Unrestricted Detail Restricted Bond Debt Service Reserve Renewal and Replacement Operating Reserve (25%) Actual Actual Actual 0udget Proj Proj Proj Proj Proj Prof Proj Proj Proj FY-96 FY-99 FY-00 FY-01 FY-02 FY•o3 FV-04 FY-05 FY-06 FY-07 FY-08 FY-09 FY-10 3 048 224 3 093 840 2 666 653 t 747 677 1 679 848 1 997 314 2 299 425 2 660 658 3 041,371 3 490 589 3,965,290 4 056 907 3 958,883 1 690,013 1,691,793 1,775,380 1,856,897 2,024,011 2,725,272 2,231,472 .2,320,731 2,413,560 2,510,103 2,670,507 2,714,927 2,823,524 40,033 28,736 27,139 31,757 31,757 31,757 31,757 31,757 - 31,757 31757 31,757 37,757 31,757 569 914 553 936 566' 243 571 636 406 784 409 149 419 045 427 704 441 479 460 589 479,419 489,916 486 688 2,299,960 2,274,465 2,368,762 2,400,284 2,464,653 2,566,117 2,682,275 2,780,192 2,886,796 3,002,449 3,121,683 3,236,600 3,341,969 409,795 424,778 783,940 929,558 101,773 259,940 234,195 245,690 593,663 546,556 2,122,766 2,406,622 177,194 - -132,057 -137,578 X95,130 3,093,840 2,566,663 872,346 909,491 921,790 459,372 998,375 200,000 345,200 144,200 2,147,086 377,466 1,997,314 .909,372 463,925 871,263 626,469 350,867 215,605 2,648;129 •169,367 -665,669 1,747,617 900,849 434,457 1,069,794 474,50( 343,90'e 140,000 2,462,053 -67,769 7,679,846 918,839 473,537 1,106,743 190,000 345,200 148,526 2,264,006 302,111 2,299 426 941,102 488,334 503,fi04 1,724,526 1,083,705 320,000 200,000 345,200 345,200 752,982 157,571 2,431,042 2,289,479 251,233 490,773 2 960,658 3,041,371 950,360 944,970 519,362 t, 720,778 290,000 345,200 162,298 2,437,578 449,278 3,490,589 959,495 535,627 1,159,753 330,000 345,200 167,767 2,637 747 464,702 3,955,290 974,537 552,473 569,739 587,622 1,200,271 1,242,337 1, 286,016 750,000 7 000,000 20,000 845,200 345,200 345,200 172,782 777 348 182 fi66 3,020,067 3,334,623 2,427,606 701,616 -98,023 920,463 4,056,907 3,956,883 4,879 347 990,717 1,006,256 1,022,97fi 2,221,494 735,373 840,769 761,009 1,067,943 -1,358,324 1,600,298 2,096,401 2,531,094 2,980,754 3,066,790 2,952,628 3,856,370 117,098. 122,845 175,434 171,951 872,346 909,491 900,949 918,839 Detail Designations Core City Project 172,600 172,600 172,600 172,600 172,600 772,600 172,600 172,600 772,600 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 466,772 518,502 527,760 522,370 536,895 557 937 567 517 583 656 600 376 909,372 947,702 950,360 944,970 959,495 974,537 990,177 7,006,256 1,022,976 - 927,790 ~ t:] o sz1,7sD o o o o o - o o c - 0 0 o A O x~ ., ~~ o~ o~ ..„ CITY OF ATLANTIC BEACH Long Term Financial Plan Financial Projection Summary Sewer Utility Cash Balance Forwafd Revenues Charges For Services Assessments Other Revenues Total Revenue Expenses Personar5ervices Operating Capital Debt Transfers Total Expenses Net Change in Cash Balance ~, Net Change in Working Capital J Ending Cash Balance Restricted Designated Unrestricted Revised AcWal Actual AcWal Budget Proj Prof Prof - Proj Proj Proj Proj Proj Proj FY58 FY-99 FY410 FY-0i FY-02 FY-03 FY-04 FY-05 FY-06 FY-07 FY-08 FY-09 - FV-iD 4 890 191 5 173 492 5 iB4 134 4 469 208 4 005 172 3 613 127 2 858 778 2 368 318 1 873 291 1 433 467 1,033,379 1,038 141 1 433,083- 2,802,262 2,830,921 3,031 392 3,095,053 3,374,480 3,543,204 3,720,364 3,837,975 ' 3,946,934 4,065,342 4,707,302 4,312,921 4,442,309 167,281 153,fi53 128,152 240,493 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 545,386 546,726 1,244,521 1,337,400 155,086 401834 827,621 813,095 329,599 546,556 3,102,472 3,645,613 426,342 - •171,998 -143,041 182,640 5,173,492 5,184,134 7 400,742 .7,467,492 566,777 1,577,763 715,180 7 089,314 209,337 4,157,771 -078,466 -236,460 4,469,206 1,655,304 587,206 1,834,225 1,137,700 7,046,614 260,000 4,853,947 -064,096 4,005,112 7,703,969 627,856 1,644,706 n1,DOD 1,047,800 2fi7,800 4,359,162 -091,985 3,613,127 1 870,941 648,898 1,701,807 sss,ooo t 047;800 275,834 4,669,339 -654,349 2,858,778 1,692,485 669,162 690,073 1,761,025 1,822,449 895,000 895,000 1,047,800 1 047 800 284,109 292,632 4,657,096 4,747,953 -090,460 -095,027 2,368,378 1,873,297 1,714,424 7,737,138 711,653 1 886,168 839,500 1,047,800 301,411 4,786,532 -039,823 1,433 467 1,760,658 733,924 1 952,280 801,000 1,047,800 310 454 4,845,458 -000,088 1,033,379 1 785,075 756,910 780,633 605,1 t9 2,020,885 2,092,089 2,166,001 400,000 25,000 7,065,000 1,047,800 t 047,800 .7,047,800 319,767 329,360 339,241 4,545,362 4,274,882 5,423,767 4,762 394,941 -609,819 7 038,141 1,433,083 823,264 7, 810,241 1,836,371 1, 863, 440 3,772,750 3,716,642 2,813,904 2,301,143 1,842,167 1,166,293 653,894 136,152 J27,79t -751,635 -772,099 403,288 -1,040;177 Detaif Restricted Bond Debt Service Reserve 413,971 406,548 544,657 523,407 523,900 523,900 523,900 523,900 523,900 523,900 523,900 523,900 523900 Renewal and Replacement 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 Operating Reserve(25%) 736832 8}0945 860648 930562 897041 918585 - 940524 963238 986758 1011115 1036391 1,062,471 1089,540 7,400,742 1,467,492 1,655,304 1,703,969 1,670,941 1,692,485 1,714,424 1,737,139 1,760,658 1,785,075 - 1,810,241 1,836,377 1,863,440 ,~. 41 A d x9 a~ N O O ~ r ~ AGENDA ITEM #9 MARCH 26, 2001 City of Atlantic Beach Water and Sewer Combined Total Revenues anc! Expenditures 9 8 7 6 L ~ 5 ~ o O ~ 4 3 2 1 0 ~ „- ,n ~ -n ~ ~ -c ~ ~ ~ -c -c ~ ~ -n -n ~ ~ ~ ~ ~ ~ ~ ~ ~ ~~ N N N N N Cfl CO O O O O O N N N N N N O O O' O O O ~O tC O O O O O 00 t0 O i N W ~. O O O 0 O j C77 O V 00 ~O O ~ Revenues ®Capital Outlay ~ Personal Services Debt Service ® Operating Expense s 0 Transfers Out la CITY OF ATLANTIC BEACH Long Term Financial Plan Financial Projection Summary Storm Water Utility Actual Actual Actual ~ Budget Proj Proj ~ ProJ Proj Proj Proj Proj Proj Proj FY-98 FY-99 FY-00 FY-01 FV-02 FY-03 FY-04 FY-O6 FY-O6 FY-07 FY-OB FY-09 FY-10 Cash Balance Forward - 264 629 698 620 1118,85!1 824 230 385 011 290 373 329 617 306 508 338 727 368 257 399,223 437,022 472 222 Revenues Charges for Services Storm Water Feas 245,526 248,942 246,975 264 U00 2fi6,640 269,306 271 999 274 719 277,467 280,247 283,044 285,874 288.733 Fees From Rate Increases Tate! Charges for Services 245,526 248,942 246,975 264,000 266,640 269,306 271,999 274,719 277,467 280,241 283,044 285,874 288,733 Gmnl Proceetls 473,450 Interest Earnings 20,443 40,947 ¢3,022 40,000 79,257 14,519 16,487 15,325 76,936 18,473 79.967 21,851 23,611 Transfer In from Other Utilities 221,004 693,172 Transfer In from Gas Tex 310,475 215,000 187,000 185,000 260,000 -. Transfer In from General Funtl 0 600,000 400,000 408,000 416,160 424,483 432,973 441,632 450,465 ~ 459,474 - , ONer Revenues 24,604 550 60,000 Total Revenue 511,677 983,645 299,997 837,450 7,796,766 898,825 683,480 891,205 978,886 731,627 744,677 758,190 771,818 Expenses PersonaLServlces 0 0 0 116,385' 119,751 122,751 725,859 129,081 - 132,425 135 896 139,502 143,252 147,753 Operating 169,957 233,738 4,683 798,427 207,380 213,601 230,009 236,910 244,017 251337 258,877 26fi,644 274,643 Capital 786 33,815 294,403 668,535 670,475 230,000 257,000 200,000 280,000 20,000 15,000 20,000 790,000 Debt 227,003 291,840 294,676 293,322 293,398 293,229 293,721 -292,995 292,975 293,828 293,458 293,095 293,245 Transfers A 0 1015 0 0 0 0 0 0 0 0 0 0 Total Expenses - 791 746 559393 594 777 1,276,6fi9 1 291 004 659,681 90fi,589 858 986 949 75fi 700,6fii 70fi,836 722,997 906,041 r+ Net Change In Cash Balance 119,831 424,162 -294,780 -939,219 -94,fi38 39,244 -23,109 32,219 29,530 30,966 37,799 35,200 -137,223 Net Change In Working Capital -714,266 3,914 -152 Ending Cash Balance 598,620 7,118,858 824,230 365,071 290,373 129,617 306,508 338,727 168,257 199,223 437,012 472,222 316,999 Restricted 208,242 277,315 222;432 298695 301,837 304,010 309,258 311,244 313,797 376,879 319,688 322,295 325,383 Des(gnaletl 400,000 0 Unreslrlcted 490,179 441,544 601,799 Sfi,377 -11,458 25,607 -2,749 27,483 64,460 82,344 717,334 149,927 13,616 Detail Restricted Debt Service Reserve 110,502 745,920 747,336 146,661 746,699 ~ 146,615 146,861 146,498 746,458 746,774 146,729 146,548 746,623 Operating Reserve(25°h) 97,740 731,395 75,094 752,034 755,132 157,395 162,397 169,746 767,339 170,165 172,959 775746 176,760 208,242 277,316 222,432 .298,695 301,831 304,010 309,256 311,244 313,797 316,879 319,686 322,295 325,363 ,Y r~ G7 a ~1 nd xa IJ J L1 ~ O O # ~" ~ AGENDA ITEM #9 MARCH 26, 2001 City of Atlantic Beach Storm Water Utility Fund Total Revenues and Expenditures 1 500 ,. 1 000 , N ~ L c~ 0 0 o 500 0 , -~ ~ N N N N t0 CC 0 0 0 0 N N N 0 0 0 , N 'N N N 0' 0 O O t0 ~O 0 0 0 0 00 Gfl O -~ N W 0 0 0 ~P vt O 0 0 0 -~ ~ O O O ~ Revenues - Ca',pital Outlay ® Personal Services Debt Service ® Operating Expenses ~ Transfers Out zo CITY OF ATLANTIC BEACH Long Term Financial Plan Financial Projection Summary Utility Bond Construction Fund Cash Balance Forward Revenues Interest Earnings Other Revenues Total Revenue Expenses Capital Total Expenses Net Change In Cash Balanee Nat Change In Working Capital Ending Caeh Belanca Restricted Designated Unreslrictetl .N- Detail Restricted Constmction Projects Actual Aetual Actual Budget, Proj Prof Proj Proj Proj Prof Proj Prof Proj FY-98 FY-99 FY-00 FY-O1 FY-02 FY-03 FY-04 FY-OS FY-O6 FK07 FY-OB FY-09 FY-10 8 772 416 8,162,108 7 244,078 6 342 112 5 016 850 513 055 0 0 0 0 0 0 0 486,883 475,962 471,310 300,000 250,842 25,653 0 0 0 0 0 0 0 486,883 475,982 477,370 300,000 250,842 25,653 0 0 0 0 0 D 0 1002,303 1,627,423 1,175,667 1,625,263 4,754637 538,70(1 0 0 0 0 0 0 0 I t 002 303 7 627,423 7 776 667 1 625 263 4 764 637 538 708 0 0 0 0 0 0 0 -615,420 -1,151,441 -704,361 -7,325,263 J,603,794 -573,055 0 0 0 0 0 0 0 -94,888 233,471 -197,616 8,162,108 7,244 078 6 342 112 5 016,850 613 056 0 0 0 0 0 0 0 0 8,162,108 7,244,070 6,342,712 5,016,850 - 573,055 D 0 0 0 0 0 0 0 0 8762,708 7244078 6342772 5016850 513055 0 0 0 0 0 0 0 0 8,162,108 7,244,078 6,342,172 5,016,850 573,055 0 0 0 0 0 0 0 0 ~n 9 tsf no x> ~~ o~ o~ ~. CITY OF ATLANTIC BEACH _ Long Term Financial Plan Financial Projection Summary Sanitation Utility Actual Actual Actual Budget Proj Proj Proj Proj ProjProj Prof Proj Proj FY-98 FY-99 FY-00 FY-0i FY-02 FY-O7 FY-04 FY-05 FY-06. FY-07 FY-OB FV-09 FY-10 Cash Balance Forward 416,887 157,127____ 420,124 474 894 '525 416 552 984 555 136 628 080 bfi7 621 369,164 227 657 37,573 -207,136 Revenues ' Charges for Services Resid/Comm Hand Picked 809,146 033,422 858,425 884,178 970,703 936,024 966,165 995,750 1,025,004 1,055,755 Dumpsters 361,398 372,240 383,407 394,909 406,756 418,959 431,528 444,474 457,008 471,542 Other 6,190 6,252 6,314 6,378 6,441 6,506 6,$71 6 637 6,703 6,770 Charges For Services 7,075,330 1,103,662 1,148,412 1,176,736 7,211,914 1,248,146 7,285,465 1,323,901 1,363,489 7,404,264 1,446,260 1,489,515 1,534,067 Grant Proceeds 5,236 5,948. 19,736 3,028 3,000 2,910 2,823 2,730 2,656 2,576 2,499 2,424 2,351 Interest Earnings 21,606 19,958 rG9, 741 28,000 28,899 30,414 30,532 29,044 25,719 20,304 72,521 2,067 -11 992 Other Revenues Total Revenue 1,702,172 1,129,660 1,197,289 1,207,764 1,243,611 7,287,477 1,318,820 1,355,683 1,391,864 7,427,146 1,461,260 7,494,006 1,525,025 Expenses Personal Services 3,765 3,963 4,108 4,178 4,272 4,403 4,538 4,677 4,821 4,970 5,123 5,281 5,445 OperaBng 866,225 850,156 857,062 949,544 1003,193 tU59907 7,119,936 1,183,476 1,250,733 1,321,928 1997,294 1,477,077 1,561,539 Capital 2,650 2,650 2,700 3,500 2,800 2,828 2,856 2,885 2914 2,943 2,972 3,002 3,032 Debt 0 0 0 0 0 ' 0 0 0 0 0 0 0 0 Transfers 200,000 200 000 228 551 200,000 206,000 272,160 278,545 225,102 231855 238,810 245 975 253,354 260,955 Total Expenses 1 072 640 1 056 769 1 092 427 1 757 222 7 216 265 1 279 318 1 346 876 1 416140 1,490,323 1,668,657 7,651,364 1,738,714 7,870,970 Net Change in Cash Balance 29,512 72,799 104,868 50,542 27,548 2,152 -27,056 --60,457 -98,459 -741,508 -790,084 -244,709 -305,945 Net Change in Working CaplWl -68,292 -9,802 -60,098 - ' Ending Cash-Balance J57 127 420 124 ~ 474 894 525 436 552 984 555 136 528 080 467 623 369 164 227,657 37,573 -207,736 -513,080 Restricted 267,496 263,530 272,430 288,431 303,366 379,123 335,755, ,. 353,314 377852 397,427 412,098 433,928 456,985 Deslgnatetl Unrestricted 89,630 166,594 202,464 237,006 249,617 236,014 192,325 114,309 -2,688 -163,770 -374,525 -641,064 -970,065 Detail Restricted Operating Reserve(25%) 267,498 263530 272430 288431 303,366 319,123 335,755 353,374 377,852 397,427 412,098 433,928 456,985 267,498 261,630 272,430 288,431 303,366 319,123' 335,755 353,314 377,852 391,427 472,098 433,926 456,985 N N ~n nd x~ .. ~~ N y O rl O ~ r+ ~ AGENDA ITEM #9 MARCH 26, 2001 City of Atlantic Beach Sanitation Fund Total Revenues .and Expenditures 2,000 1,500 L ~ i= 0 0 1,000 0 ~ F- 500 0 ~~~~ -~~~~ ., ~ -~ N N Cfl ~O O O ~O C~ O O 0o c~ o N O O N N O O W ~~ ~~ ,, N N O O O O ~ ~ N O 0 O N O 0 -~~~ ~~~ N N N O O O 0 0 00 ~O O °+~ Revenues ~ Capital Outlay - Personal Services ~ Transfers Out ® Operating Expenses 23 AGENDA ITEM #9 MARCH 26, 2001 City of Atlantic Beach Long Term Financial Plan Schedule of Approximate Interfund Transfers ~~ Pension Administration Water Utility $140,000 $30,000 . Debt Service Fund $260,000 General Fund , ~ $148,000 Sewer Utility ~ $72,000 $200,000 $200,000 $400,000 Gas Tax Fund Sanitation Utility $200, 000 Governmental / C.LP. Fund Storm Water Utility $500,000 ~ $60,000 1/2 Cent Sale Convention Tax Fund Development Tax Fund '24