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        333,523     1,601,450       1,288,394         154,571        130,262        105,300          79,663       1,091,465       6,384,456
Cummulative Revenue Needed               -                 -                 -                 -                 -                   -                   -                   -                   -            63,387     1,091,465     1,924,061     2,355,853     2,691,293     3,024,816     4,626,267       5,914,660      6,069,231      6,199,493      6,304,793      6,384,456
Capital Projects
Marina Fund CIP
  General CIP          1,600          6,013        56,344
  A-C Restroom (Launch Ramp grant match)      123,000         123,000          123,000
  1.5% Public Art Contribution          3,656
  Corporation Yard Storage Shed          8,612
  Marina Restroom Partitions          6,271        16,127
  Pathway/Cabling/Sewer (PW)??        39,700
  L&M Restroom Repairs        30,000                  -                     -  
  K Dock Repairs        13,000                  -                     -  
  Marina Office Deck Beam        11,600                  -                     -  
  F&G Dock Replacement        13,800      665,000      168,000                  -                     -  
  H&I Dock Replacement        500,000         500,000          500,000
  Concrete Dock Replacement/Maintenance          7,957        90,294               -          19,439      494,340        50,000        50,000          50,000          50,000          50,000          70,000          70,000 70,000          70,000 70,000          80,000          80,000          80,000           80,000          90,000          90,000          90,000          90,000         973,779       1,793,779
  Marina Master Plan        31,595      143,405        75,000                  -                     -  
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
                 -                     -  
 Leasee - H's Lordship's Parking Lot                  -                     -  
1 3% increase in revenue per year beginning in FY2004.  MONDO10.6 (1/9/02)
2 1% increase in revenue per year from FY2002 to FY2005 and 1.5% from 2006 to 2020.
3 Interest is calculated at 5% of the fund balance at the beginning of the year.
4 Personnel costs reflect 3.55% expected COLA in FY2002 and a 3% estimated COLA in subsequent years.
5 2% increase in non-personnel costs per year beginning in FY2004.
6 Debt service (Principal and Interest) computed at $70,000 per $1,000,000 per year.