| 20-YEAR MARINA FUND ANALYSIS | |||||||||||||||||||||||||
| FY2001 | FY2001 | ||||||||||||||||||||||||
| to | to | ||||||||||||||||||||||||
| FY 1998 | FY1999 | FY2000 | FY2001 | FY2002 | FY2003 | FY2004 | FY2005 | FY2006 | FY2007 | FY2008 | FY2009 | FY2010 | FY2011 | FY2012 | FY2013 | FY2014 | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 | FY2020 | FY2010 | FY2020 | |
| Actual | Actual | Actual | Actual | Adjusted | Adopted | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | Proposed | TOTAL | TOTAL | |
| Beginning Fund Balance | 1,461,559 | 1,714,388 | 967,161 | 949,016 | 1,490,523 | 1,092,693 | 1,340,699 | 1,688,424 | 1,199,462 | 901,086 | 900,398 | 894,472 | 225,355 | 273,250 | 528,206 | 790,634 | 1,060,752 | 513,784 | 799,135 | 1,092,868 | 1,395,226 | 1,706,462 | 2,026,835 | ||
| Revenues | |||||||||||||||||||||||||
| Berth Rentals | 1,602,607 | 1,667,725 | 1,832,733 | 1,964,564 | 2,075,000 | 2,075,000 | 2,137,250 | 2,226,368 | 2,318,159 | 2,387,703 | 2,459,334 | 2,533,114 | 2,609,108 | 2,687,381 | 2,768,003 | 2,851,043 | 2,936,574 | 3,024,671 | 3,115,411 | 3,208,874 | 3,305,140 | 3,404,294 | 3,506,423 | 22,785,600 | 53,593,412 |
| Lease Payments | 1,114,708 | 1,086,886 | 1,139,993 | 1,236,100 | 1,209,540 | 1,221,635 | 1,233,852 | 1,246,190 | 1,264,883 | 1,283,856 | 1,303,114 | 1,322,661 | 1,342,501 | 1,362,638 | 1,383,078 | 1,403,824 | 1,424,881 | 1,446,255 | 1,467,949 | 1,489,968 | 1,512,317 | 1,535,002 | 1,558,027 | 12,664,333 | 27,248,272 |
| Miscellaneous Fees | 78,519 | 123,942 | 129,610 | 124,400 | 126,400 | 130,192 | 134,098 | 138,121 | 142,264 | 146,532 | 150,928 | 155,456 | 160,120 | 164,923 | 169,871 | 174,967 | 180,216 | 185,623 | 191,191 | 196,927 | 202,835 | 208,920 | 1,378,001 | 3,213,595 | |
| Recreation & Events | 26,123 | 33,644 | 34,134 | 30,080 | 27,810 | 28,644 | 29,504 | 30,389 | 31,300 | 32,239 | 33,207 | 34,203 | 35,229 | 36,286 | 37,374 | 38,496 | 39,650 | 40,840 | 42,065 | 43,327 | 44,627 | 45,966 | 47,345 | 312,605 | 728,580 |
| Interest | 104,995 | 83,299 | 69,988 | 92,578 | 74,526 | 54,635 | 67,035 | 84,421 | 59,973 | 45,054 | 45,020 | 44,724 | 11,268 | 13,663 | 26,410 | 39,532 | 53,038 | 25,689 | 39,957 | 54,643 | 69,761 | 85,323 | 101,342 | 579,234 | 1,088,591 |
| Straw Bale Building | 31,999 | 3,099 | - | - | |||||||||||||||||||||
| Dock of the Bay | 40,000 | 40,600 | 41,209 | 41,827 | 42,455 | 43,091 | 43,738 | 44,394 | 45,060 | 45,736 | 46,422 | 47,118 | 47,825 | 48,542 | 49,270 | 50,009 | 50,759 | 292,920 | 768,054 | ||||||
| Donations (e.g., Benches) | 176 | 6,000 | 4,800 | 20,125 | 4,100 | 4,203 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 42,428 | 62,428 |
| REVENUE TOTAL | 2,880,608 | 2,959,172 | 3,205,590 | 3,473,057 | 3,515,376 | 3,510,517 | 3,639,832 | 3,764,065 | 3,855,645 | 3,934,945 | 4,031,662 | 4,130,721 | 4,199,299 | 4,306,481 | 4,426,848 | 4,550,501 | 4,677,532 | 4,766,789 | 4,900,829 | 5,038,545 | 5,180,043 | 5,325,429 | 5,474,816 | 38,055,120 | 86,702,933 |
| Expenditures | |||||||||||||||||||||||||
| Personnel | 1,489,237 | 1,577,917 | 1,516,402 | 1,542,715 | 1,698,523 | 1,757,971 | 1,819,500 | 1,883,182 | 1,949,094 | 2,007,567 | 2,067,794 | 2,129,827 | 2,193,722 | 2,259,534 | 2,327,320 | 2,397,140 | 2,469,054 | 2,543,125 | 2,619,419 | 2,698,002 | 2,778,942 | 2,862,310 | 2,948,179 | 19,049,896 | 44,952,921 |
| Non-personnel | 955,599 | 1,119,435 | 1,192,816 | 1,052,391 | 1,221,976 | 1,037,201 | 1,057,945 | 1,079,104 | 1,100,686 | 1,122,700 | 1,145,154 | 1,168,057 | 1,191,418 | 1,215,246 | 1,239,551 | 1,264,342 | 1,289,629 | 1,315,422 | 1,341,730 | 1,368,565 | 1,395,936 | 1,423,855 | 1,452,332 | 11,176,631 | 24,483,239 |
| Existing Debt Service (Principal & Interest) | 122,275 | 118,412 | 242,950 | 236,445 | 261,842 | 261,840 | 179,262 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 160,150 | 1,900,289 | 2,861,189 | ||||
| New Debt Service (Principal & Interest) | - | 135,800 | 192,591 | 371,091 | 371,091 | 491,491 | 492,191 | 548,191 | 576,191 | 611,191 | 611,191 | 611,191 | 611,191 | 611,191 | 611,191 | 611,191 | 611,191 | 611,191 | 2,602,446 | 8,679,356 | |||||
| CIP | 51,179 | 200,364 | 21,978 | 95,645 | 727,865 | 202,500 | 96,600 | 85,000 | 570,000 | 271,125 | 170,000 | 160,000 | 883,000 | 670,000 | 255,000 | 180,000 | 200,000 | 1,450,000 | 1,160,000 | 210,000 | 210,000 | 210,000 | 210,000 | 3,261,735 | 8,016,735 |
| Committed Reserve: Marina Fund CIP | - | - | - | - | - | - | - | 650,000 | - | - | - | 500,000 | 200,000 | - | - | - | 825,000 | - | - | - | - | - | - | 1,350,000 | 2,175,000 |
| Committed Reserve: B&W 2% Set Aside | - | - | - | - | 200,000 | - | - | - | 250,000 | - | - | - | - | - | - | - | - | - | - | - | 450,000 | 450,000 | |||
| Grant Matching Funds | - | - | |||||||||||||||||||||||
| Charges from Other Departments | 7,619 | 666,650 | 249,589 | 4,354 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 31,354 | 61,354 |
| Other new expenditures | 1,870 | 23,621 | - | - | |||||||||||||||||||||
| EXPENDITURE TOTAL | 2,627,779 | 3,706,399 | 3,223,735 | 2,931,550 | 3,913,206 | 3,262,512 | 3,292,107 | 4,253,027 | 4,154,021 | 3,935,632 | 4,037,588 | 4,863,225 | 5,179,481 | 4,884,121 | 4,596,212 | 4,615,823 | 5,558,024 | 6,082,888 | 5,895,490 | 4,890,757 | 4,999,069 | 5,110,356 | 5,224,702 | 39,822,350 | 91,679,793 |
| Surplus/Shortfall | 252,829 | (747,227) | (18,145) | 541,507 | (397,830) | 248,005 | 347,725 | (488,962) | (298,376) | (688) | (5,927) | (732,504) | (980,182) | (577,640) | (169,364) | (65,322) | (880,492) | (1,316,099) | (994,661) | 147,788 | 180,974 | 215,073 | 250,113 | ||
| Unadjusted Ending Fund Balance | 1,714,388 | 967,161 | 949,016 | 1,490,523 | 1,092,693 | 1,340,699 | 1,688,424 | 1,199,462 | 901,086 | 900,398 | 894,472 | 161,968 | (754,827) | (304,390) | 358,842 | 725,312 | 180,261 | (802,315) | (195,526) | 1,240,656 | 1,576,200 | 1,921,535 | 2,276,948 | ||
| Marina CIP Set Aside for Committed Reserve | 150,000 | 150,000 | 150,000 | 150,000 | 150,000 | 154,500 | 159,135 | 163,909 | 168,826 | 173,891 | 179,108 | 184,481 | 190,016 | 195,716 | 201,587 | 207,635 | 213,864 | 220,280 | 1,227,544 | 3,162,949 | |||||
| Cummulative Marina CIP Committed Reserve | 224,262 | 374,262 | 524,262 | 24,262 | 174,262 | 324,262 | 478,762 | 137,897 | 101,806 | 270,632 | 444,523 | 623,631 | (16,888) | 173,128 | 368,844 | 570,431 | 778,066 | 991,931 | 1,212,211 | ||||||
| B&W 2% CIP Set Aside for Committed Reserve | 70,210 | 72,797 | 75,281 | 77,113 | 78,699 | 80,633 | 82,614 | 83,986 | 86,130 | 88,537 | 91,010 | 93,551 | 95,336 | 98,017 | 100,771 | 103,601 | 106,509 | 109,496 | 621,334 | 1,594,290 | |||||
| Cummulative B&W 2% CIP Committed Reserve | 70,321 | 143,118 | 18,399 | 95,512 | 174,211 | 254,844 | 87,458 | 171,444 | 257,574 | 346,111 | 437,121 | 530,672 | 626,007 | 724,024 | 824,795 | 928,396 | 1,034,904 | 1,144,401 | |||||||
| Total Committed Reserve Fund Balance | - | - | 224,262 | 444,583 | 667,380 | 42,661 | 269,774 | 498,473 | 733,606 | 225,355 | 273,250 | 528,206 | 790,634 | 1,060,752 | 513,784 | 799,135 | 1,092,868 | 1,395,226 | 1,706,462 | 2,026,835 | 2,356,611 | ||||
| Total Uncommitted Fund Balance | 1,714,388 | 967,161 | 949,016 | 1,490,523 | 868,431 | 896,116 | 1,021,044 | 1,156,801 | 631,312 | 401,926 | 160,866 | - | - | - | - | - | - | - | - | - | - | - | - | ||
| Adjusted Ending Fund Balance | 1,714,388 | 967,161 | 949,016 | 1,490,523 | 1,092,693 | 1,340,699 | 1,688,424 | 1,199,462 | 901,086 | 900,398 | 894,472 | 225,355 | 273,250 | 528,206 | 790,634 | 1,060,752 | 513,784 | 799,135 | 1,092,868 | 1,395,226 | 1,706,462 | 2,026,835 | 2,356,611 | ||
| Revenue Needed | - | - | - | - | - | - | - | - | - | 63,387 | 1,028,077 | 832,596 | 431,792 | 335,440 |