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
  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                                                            -                     -  
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