|
DRAFT- 08/17/18
<br />Louisville Recreation & Senior Center
<br />25-Year Building and Equipment Renewal and Replacement Plant Fund Projections
<br />Assumptions:
<br />Building Renewal and Replacement Reserve Factor (Perkins+Will)
<br />2.00%
<br />Initial Building Replacement Value for Non -Core and Shell (Perkins+Will) Including Soft Co
<br />$ 13,116,687
<br />Annual Building Current Replacement Value Inflation Factor
<br />3.0%
<br />Annual FF&E Replacement Value Inflation Factor
<br />3.0%
<br />Annual Sales Tax Inflation Factor
<br />3.0%
<br />Annual Non -Capital Operating Expense Inflation Factor (Cost of Government)
<br />Annual CIP Allocation Inflation Factor
<br />3.0%
<br />Annual User Fee Cost Recovery Revenue Inflation Factor
<br />1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br />21
<br />22
<br />23
<br />24
<br />25
<br />25 Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Fiscal Year
<br />Reserve/
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />2033
<br />2034
<br />2035
<br />2036
<br />2037
<br />2038
<br />2039
<br />2040
<br />2041
<br />2042
<br />2043
<br />Expenditures
<br />Furniture, Fixtures, and Equipment (FF&E) Replacement:
<br />FF&E Replacement Value with 2 Year Replacement Cycle
<br />$ 123,200
<br />$ 126,896
<br />$ 130,703
<br />$ 134,624
<br />$ 138,663
<br />$ 142,823
<br />$ 147,107
<br />$ 151,520
<br />$ 156,066
<br />$ 160,748
<br />$ 165,570
<br />$ 170,538
<br />$ 175,654
<br />$ 180,923
<br />$ 186,351
<br />$ 191,942
<br />$ 197,700
<br />$ 203,631
<br />$ 209,740
<br />$ 216,032
<br />$ 222,513
<br />$ 229,188
<br />$ 236,064
<br />$ 243,146
<br />$ 250,440
<br />Annual Renewal and Replacement Reserve for FF&E with 2 Year Replacement
<br />2
<br />$ 61,600
<br />$ 63,448
<br />$ 65,351
<br />$ 67,312
<br />$ 69,331
<br />$ 71,411
<br />$ 73,554
<br />$ 75,760
<br />$ 78,033
<br />$ 80,374
<br />$ 82,785
<br />$ 85,269
<br />$ 87,827
<br />$ 90,462
<br />$ 93,176
<br />$ 95,971
<br />$ 98,850
<br />$ 101,815
<br />$ 104,870
<br />$ 108,016
<br />$ 111,256
<br />$ 114,594
<br />$ 118,032
<br />$ 121,573
<br />$ 125,220
<br />$ 2,245,891
<br />FF&E Replacement Value with 3 Year Replacement Cycle
<br />$ 293,002
<br />$ 301,792
<br />$ 310,846
<br />$ 320,171
<br />$ 329,776
<br />$ 339,670
<br />$ 349,860
<br />$ 360,356
<br />$ 371,166
<br />$ 382,301
<br />$ 393,770
<br />$ 405,583
<br />$ 417,751
<br />$ 430,283
<br />$ 443,192
<br />$ 456,488
<br />$ 470,182
<br />$ 484,288
<br />$ 498,816
<br />$ 513,781
<br />$ 529,194
<br />$ 545,070
<br />$ 561,422
<br />$ 578,265
<br />$ 595,613
<br />Annual Renewal and Replacement Reserve for FF&E with 3 Year Replacement
<br />3
<br />$ 97,667
<br />$ 100,597
<br />$ 103,615
<br />$ 106,724
<br />$ 109,925
<br />$ 113,223
<br />$ 116,620
<br />$ 120,119
<br />$ 123,722
<br />$ 127,434
<br />$ 131,257
<br />$ 135,194
<br />$ 139,250
<br />$ 143,428
<br />$ 147,731
<br />$ 152,163
<br />$ 156,727
<br />$ 161,429
<br />$ 166,272
<br />$ 171,260
<br />$ 176,398
<br />$ 181,690
<br />$ 187,141
<br />$ 192,755
<br />$ 198,538
<br />$ 3,560,879
<br />FF&E Replacement Value with 4 Year Replacement Cycle
<br />$ 7,700
<br />$ 7,931
<br />$ 8,169
<br />$ 8,414
<br />$ 8,666
<br />$ 8,926
<br />$ 9,194
<br />$ 9,470
<br />$ 9,754
<br />$ 10,047
<br />$ 10,348
<br />$ 10,659
<br />$ 10,978
<br />$ 11,308
<br />$ 11,647
<br />$ 11,996
<br />$ 12,356
<br />$ 12,727
<br />$ 13,109
<br />$ 13,502
<br />$ 13,907
<br />$ 14,324
<br />$ 14,754
<br />$ 15,197
<br />$ 15,653
<br />Annual Renewal and Replacement Reserve for FF&E with 4 Year Replacement
<br />4
<br />$ 1,925
<br />$ 1,983
<br />$ 2,042
<br />$ 2,103
<br />$ 2,167
<br />$ 2,232
<br />$ 2,299
<br />$ 2,368
<br />$ 2,439
<br />$ 2,512
<br />$ 2,587
<br />$ 2,665
<br />$ 2,745
<br />$ 2,827
<br />$ 2,912
<br />$ 2,999
<br />$ 3,089
<br />$ 3,182
<br />$ 3,277
<br />$ 3,375
<br />$ 3,477
<br />$ 3,581
<br />$ 3,688
<br />$ 3,799
<br />$ 3,913
<br />$ 70,184
<br />FF&E Replacement Value with 5 Year Replacement Cycle
<br />$ 113,006
<br />$ 116,396
<br />$ 119,888
<br />$ 123,485
<br />$ 127,189
<br />$ 131,005
<br />$ 134,935
<br />$ 138,983
<br />$ 143,153
<br />$ 147,447
<br />$ 151,871
<br />$ 156,427
<br />$ 161,120
<br />$ 165,953
<br />$ 170,932
<br />$ 176,060
<br />$ 181,341
<br />$ 186,782
<br />$ 192,385
<br />$ 198,157
<br />$ 204,101
<br />$ 210,224
<br />$ 216,531
<br />$ 223,027
<br />$ 229,718
<br />Annual Renewal and Replacement Reserve for FF&E with 5 Year Replacement
<br />5
<br />$ 22,601
<br />$ 23,279
<br />$ 23,978
<br />$ 24,697
<br />$ 25,438
<br />$ 26,201
<br />$ 26,987
<br />$ 27,797
<br />$ 28,631
<br />$ 29,489
<br />$ 30,374
<br />$ 31,285
<br />$ 32,224
<br />$ 33,191
<br />$ 34,186
<br />$ 35,212
<br />$ 36,268
<br />$ 37,356
<br />$ 38,477
<br />$ 39,631
<br />$ 40,820
<br />$ 42,045
<br />$ 43,306
<br />$ 44,605
<br />$ 45,944
<br />$ 824,023
<br />FF&E Replacement Value with 6 Year Replacement Cycle
<br />$ 8,800
<br />$ 9,064
<br />$ 9,336
<br />$ 9,616
<br />$ 9,904
<br />$ 10,202
<br />$ 10,508
<br />$ 10,823
<br />$ 11,148
<br />$ 11,482
<br />$ 11,826
<br />$ 12,181
<br />$ 12,547
<br />$ 12,923
<br />$ 13,311
<br />$ 13,710
<br />$ 14,121
<br />$ 14,545
<br />$ 14,981
<br />$ 15,431
<br />$ 15,894
<br />$ 16,371
<br />$ 16,862
<br />$ 17,368
<br />$ 17,889
<br />Annual Renewal and Replacement Reserve for FF&E with 6 Year Replacement
<br />6
<br />$ 1,467
<br />$ 1,511
<br />$ 1,556
<br />$ 1,603
<br />$ 1,651
<br />$ 1,700
<br />$ 1,751
<br />$ 1,804
<br />$ 1,858
<br />$ 1,914
<br />$ 1,971
<br />$ 2,030
<br />$ 2,091
<br />$ 2,154
<br />$ 2,218
<br />$ 2,285
<br />$ 2,354
<br />$ 2,424
<br />$ 2,497
<br />$ 2,572
<br />$ 2,649
<br />$ 2,728
<br />$ 2,810
<br />$ 2,895
<br />$ 2,981
<br />$ 53,474
<br />FF&E Replacement Value with 7 Vear Replacement Cycle
<br />$ 26,756
<br />$ 27,559
<br />$ 28,385
<br />$ 29,237
<br />$ 30,114
<br />$ 31,018
<br />$ 31,948
<br />$ 32,907
<br />$ 33,894
<br />$ 34,911
<br />$ 35,958
<br />$ 37,037
<br />$ 38,148
<br />$ 39,292
<br />$ 40,471
<br />$ 41,685
<br />$ 42,936
<br />$ 44,224
<br />$ 45,550
<br />$ 46,917
<br />$ 48,324
<br />$ 49,774
<br />$ 51,267
<br />$ 52,805
<br />$ 54,389
<br />Annual Renewal and Replacement Reserve for FF&E with 7 Year Replacement
<br />7
<br />$ 3,822
<br />$ 3,937
<br />$ 4,055
<br />$ 4,177
<br />$ 4,302
<br />$ 4,431
<br />$ 4,564
<br />$ 4,701
<br />$ 4,842
<br />$ 4,987
<br />$ 5,137
<br />$ 5,291
<br />$ 5,450
<br />$ 5,613
<br />$ 5,782
<br />$ 5,955
<br />$ 6,134
<br />$ 6,318
<br />$ 6,507
<br />$ 6,702
<br />$ 6,903
<br />$ 7,111
<br />$ 7,324
<br />$ 7,544
<br />$ 7,770
<br />$ 139,358
<br />FF&E Replacement Value with 8 Year Replacement Cycle
<br />$ 278,259
<br />$ 286,607
<br />$ 295,205
<br />$ 304,061
<br />$ 313,183
<br />$ 322,578
<br />$ 332,256
<br />$ 342,223
<br />$ 352,490
<br />$ 363,065
<br />$ 373,957
<br />$ 385,176
<br />$ 396,731
<br />$ 408,633
<br />$ 420,892
<br />$ 433,518
<br />$ 446,524
<br />$ 459,920
<br />$ 473,717
<br />$ 487,929
<br />$ 502,567
<br />$ 517,644
<br />$ 533,173
<br />$ 549,168
<br />$ 565,643
<br />Annual Renewal and Replacement Reserve for FF&E with 8 Year Replacement
<br />8
<br />$ 34,782
<br />$ 35,826
<br />$ 36,901
<br />$ 38,008
<br />$ 39,148
<br />$ 40,322
<br />$ 41,532
<br />$ 42,778
<br />$ 44,061
<br />$ 45,383
<br />$ 46,745
<br />$ 48,147
<br />$ 49,591
<br />$ 51,079
<br />$ 52,611
<br />$ 54,190
<br />$ 55,816
<br />$ 57,490
<br />$ 59,215
<br />$ 60,991
<br />$ 62,821
<br />$ 64,705
<br />$ 66,647
<br />$ 68,646
<br />$ 70,705
<br />$ 1,268,140
<br />FF&E Replacement Value with 10 Vear Replacement Cycle
<br />$ 429,941
<br />$ 442,839
<br />$ 456,124
<br />$ 469,808
<br />$ 483,902
<br />$ 498,419
<br />$ 513,372
<br />$ 528,773
<br />$ 544,636
<br />$ 560,975
<br />$ 577,805
<br />$ 595,139
<br />$ 612,993
<br />$ 631,383
<br />$ 650,324
<br />$ 669,834
<br />$ 689,929
<br />$ 710,627
<br />$ 731,946
<br />$ 753,904
<br />$ 776,521
<br />$ 799,817
<br />$ 823,811
<br />$ 848,526
<br />$ 873,982
<br />Annual Renewal and Replacement Reserve for FF&E with 10 Year Replacement
<br />10
<br />$ 42,994
<br />$ 44,284
<br />$ 45,612
<br />$ 46,981
<br />$ 48,390
<br />$ 49,842
<br />$ 51,337
<br />$ 52,877
<br />$ 54,464
<br />$ 56,098
<br />$ 57,780
<br />$ 59,514
<br />$ 61,299
<br />$ 63,138
<br />$ 65,032
<br />$ 66,983
<br />$ 68,993
<br />$ 71,063
<br />$ 73,195
<br />$ 75,390
<br />$ 77,652
<br />$ 79,982
<br />$ 82,381
<br />$ 84,853
<br />$ 87,398
<br />$ 1,567,533
<br />FF&E Replacement Value with 15 Year Replacement Cycle
<br />$ 220,919
<br />$ 227,547
<br />$ 234,373
<br />$ 241,404
<br />$ 248,646
<br />$ 256,106
<br />$ 263,789
<br />$ 271,703
<br />$ 279,854
<br />$ 288,249
<br />$ 296,897
<br />$ 305,804
<br />$ 314,978
<br />$ 324,427
<br />$ 334,160
<br />$ 344,185
<br />$ 354,510
<br />$ 365,145
<br />$ 376,100
<br />$ 387,383
<br />$ 399,004
<br />$ 410,974
<br />$ 423,304
<br />$ 436,003
<br />$ 449,083
<br />Annual Renewal and Replacement Reserve for FF&E with 15 Vear Replacement
<br />15
<br />$ 14,728
<br />$ 15,170
<br />$ 15,625
<br />$ 16,094
<br />$ 16,576
<br />$ 17,074
<br />$ 17,586
<br />$ 18,114
<br />$ 18,657
<br />$ 19,217
<br />$ 19,793
<br />$ 20,387
<br />$ 20,999
<br />$ 21,628
<br />$ 22,277
<br />$ 22,946
<br />$ 23,634
<br />$ 24,343
<br />$ 25,073
<br />$ 25,826
<br />$ 26,600
<br />$ 27,398
<br />$ 28,220
<br />$ 29,067
<br />$ 29,939
<br />$ 536,970
<br />FF&E Replacement Value with 20 Vear Replacement Cycle
<br />$ 52,800
<br />$ 54,384
<br />$ 56,016
<br />$ 57,696
<br />$ 59,427
<br />$ 61,210
<br />$ 63,046
<br />$ 64,937
<br />$ 66,885
<br />$ 68,892
<br />$ 70,959
<br />$ 73,088
<br />$ 75,280
<br />$ 77,539
<br />$ 79,865
<br />$ 82,261
<br />$ 84,728
<br />$ 87,270
<br />$ 89,888
<br />$ 92,585
<br />$ 95,363
<br />$ 98,224
<br />$ 101,170
<br />$ 104,205
<br />$ 107,332
<br />Annual Renewal and Replacement Reserve for FF&E with 20 Year Replacement
<br />20
<br />$ 2,640
<br />$ 2,719
<br />$ 2,801
<br />$ 2,885
<br />$ 2,971
<br />$ 3,060
<br />$ 3,152
<br />$ 3,247
<br />$ 3,344
<br />$ 3,445
<br />$ 3,548
<br />$ 3,654
<br />$ 3,764
<br />$ 3,877
<br />$ 3,993
<br />$ 4,113
<br />$ 4,236
<br />$ 4,364
<br />$ 4,494
<br />$ 4,629
<br />$ 4,768
<br />$ 4,911
<br />$ 5,059
<br />$ 5,210
<br />$ 5,367
<br />$ 96,252
<br />FF&E Replacement Value with 25 Year Replacement Cycle
<br />$ 18,700
<br />$ 19,261
<br />$ 19,839
<br />$ 20,434
<br />$ 21,047
<br />$ 21,678
<br />$ 22,329
<br />$ 22,999
<br />$ 23,689
<br />$ 24,399
<br />$ 25,131
<br />$ 25,885
<br />$ 26,662
<br />$ 27,462
<br />$ 28,285
<br />$ 29,134
<br />$ 30,008
<br />$ 30,908
<br />$ 31,835
<br />$ 32,791
<br />$ 33,774
<br />$ 34,788
<br />$ 35,831
<br />$ 36,906
<br />$ 38,013
<br />Annual Renewal and Replacement Reserve for FF&E with 25 Year Replacement
<br />25
<br />$ 748
<br />$ 770
<br />$ 794
<br />$ 817
<br />$ 842
<br />$ 867
<br />$ 893
<br />$ 920
<br />$ 948
<br />$ 976
<br />$ 1,005
<br />$ 1,035
<br />$ 1,066
<br />$ 1,098
<br />$ 1,131
<br />$ 1,165
<br />$ 1,200
<br />$ 1,236
<br />$ 1,273
<br />$ 1,312
<br />$ 1,351
<br />$ 1,392
<br />$ 1,433
<br />$ 1,476
<br />$ 1,521
<br />$ 27,272
<br />Annual FF&E 2 Vear Expenditures
<br />2
<br />$ 125,048
<br />$ 132,663
<br />$ 140,743
<br />$ 149,314
<br />$ 158,407
<br />$ 168,054
<br />$ 178,289
<br />$ 189,146
<br />$ 200,665
<br />$ 212,886
<br />$ 225,851
<br />$ 239,605
<br />$ 2,120,671
<br />Annual FF&E 3 Year Expenditures
<br />3
<br />$ 301,880
<br />$ 329,872
<br />$ 360,460
<br />$ 393,885
<br />$ 430,409
<br />$ 470,319
<br />$ 513,930
<br />$ 561,586
<br />$ 3,362,342
<br />Annual FF&E 4 Year Expenditures
<br />4
<br />$ 8,053
<br />$ 9,064
<br />$ 10,202
<br />$ 11,482
<br />$ 12,923
<br />$ 14,545
<br />$ 66,271
<br />Annual FF&E 5 Year Expenditures
<br />5
<br />$ 119,993
<br />$ 139,105
<br />$ 161,260
<br />$ 186,945
<br />$ 216,720
<br />$ 824,023
<br />Annual FF&E 6 Year Expenditures
<br />6
<br />$ 9,487
<br />$ 11,328
<br />$ 13,526
<br />$ 16,151
<br />$ 50,492
<br />Annual FF&E 7 Year Expenditures
<br />7
<br />$ 29,288
<br />$ 36,021
<br />$ 44,301
<br />$ 109,610
<br />Annual FF&E 8 Year Expenditures
<br />8
<br />$ 309,297
<br />$ 391,808
<br />$ 496,330
<br />$ 1,197,434
<br />Annual FF&E lO Year Expenditures
<br />10
<br />$ 492,879
<br />$ 662,388
<br />$ 1,155,268
<br />Annual FF&E 15 Year Expenditures
<br />15
<br />$ 273,924
<br />$ 273,924
<br />Annual FF&E 20 Year Expenditures
<br />20
<br />$ 70,938
<br />$ 70,938
<br />Annual FF&E 25 Year Expenditures
<br />25
<br />$ 27,272
<br />$ 27,272
<br />Total Annual FF&E Expenditures
<br />$ -
<br />$ 125,048
<br />$ 301,880
<br />$ 140,717
<br />$ 119,993
<br />$ 480,102
<br />$ 29,288
<br />$ 467,675
<br />$ 360,460
<br />$ 790,391
<br />$ -
<br />$ 583,469
<br />$ -
<br />$ 214,309
<br />$ 865,593
<br />$ 592,436
<br />$ -
<br />$ 684,511
<br />$ -
<br />$ 1,146,080
<br />$ 558,231
<br />$ 225,851
<br />$ -
<br />$ 1,328,217
<br />$ 243,992
<br />$ 9,258,243
<br />Building Renewal and Replacement:
<br />Current Replacement Value of Non -Core and Shell (Entire Building)
<br />$ 13,116,687
<br />$ 13,510,188
<br />$ 13,915,493
<br />$ 14,332,958
<br />$ 14,762,947
<br />$ 15,205,835
<br />$ 15,662,010
<br />$ 16,131,871
<br />$ 16,615,827
<br />$ 17,114,302
<br />$ 17,627,731
<br />$ 18,156,563
<br />$ 18,701,259
<br />$ 19,262,297
<br />$ 19,840,166
<br />$ 20,435,371
<br />$ 21,048,432
<br />$ 21,679,885
<br />$ 22,330,282
<br />$ 23,000,190
<br />$ 23,690,196
<br />$ 24,400,902
<br />$ 25,132,929
<br />$ 25,886,917
<br />$ 26,663,524
<br />Average Building Annual Renewal and Replacement Expense
<br />$ 262,334
<br />$ 270,204
<br />$ 278,310
<br />$ 286,659
<br />$ 295,259
<br />$ 304,117
<br />$ 313,240
<br />$ 322,637
<br />$ 332,317
<br />$ 342,286
<br />$ 352,555
<br />$ 363,131
<br />$ 374,025
<br />$ 385,246
<br />$ 396,803
<br />$ 408,707
<br />$ 420,969
<br />$ 433,598
<br />$ 446,606
<br />$ 460,004
<br />$ 473,804
<br />$ 488,018
<br />$ 502,659
<br />$ 517,738
<br />$ 533,270
<br />$ 9,564,495
<br />Sources and Uses of Renewal and Replacement Funds:
<br />Sources of Funds:
<br />General Admissions, MAC Gym, Rentals, & Other
<br />$ 1,171,920
<br />$ 1,370,890
<br />$ 1,439,435
<br />$ 1,511,406
<br />$ 1,586,977
<br />$ 1,666,325
<br />$ 1,749,642
<br />$ 1,837,124
<br />$ 1,928,980
<br />$ 2,025,429
<br />$ 2,126,700
<br />$ 2,233,035
<br />$ 2,344,687
<br />$ 2,461,921
<br />$ 2,585,018
<br />$ 2,714,268
<br />$ 2,849,982
<br />$ 2,992,481
<br />$ 3,142,105
<br />$ 3,299,210
<br />$ 3,464,171
<br />$ 3,637,379
<br />$ 3,819,248
<br />$ 4,010,211
<br />$ 4,210,721
<br />$ 62,179,265
<br />Youth Activity Fees
<br />$ 505,460
<br />$ 553,730
<br />$ 581,417
<br />$ 610,487
<br />$ 641,012
<br />$ 673,062
<br />$ 706,715
<br />$ 742,051
<br />$ 779,154
<br />$ 818,111
<br />$ 859,017
<br />$ 901,968
<br />$ 947,066
<br />$ 994,420
<br />$ 1,044,140
<br />$ 1,096,348
<br />$ 1,151,165
<br />$ 1,208,723
<br />$ 1,269,159
<br />$ 1,332,617
<br />$ 1,399,248
<br />$ 1,469,211
<br />$ 1,542,671
<br />$ 1,619,805
<br />$ 1,700,795
<br />$ 25,147,552
<br />Adult Activity Fees
<br />$ 275,310
<br />$ 289,060
<br />$ 303,513
<br />$ 318,689
<br />$ 334,623
<br />$ 351,354
<br />$ 368,922
<br />$ 387,368
<br />$ 406,736
<br />$ 427,073
<br />$ 448,427
<br />$ 470,848
<br />$ 494,391
<br />$ 519,110
<br />$ 545,066
<br />$ 572,319
<br />$ 600,935
<br />$ 630,982
<br />$ 662,531
<br />$ 695,657
<br />$ 730,440
<br />$ 766,962
<br />$ 805,310
<br />$ 845,576
<br />$ 887,855
<br />$ 13,139,058
<br />Senior Activity Fees, Grants, & Reimbursements
<br />$ 173,750
<br />$ 183,710
<br />$ 192,896
<br />$ 202,540
<br />$ 212,667
<br />$ 223,301
<br />$ 234,466
<br />$ 246,189
<br />$ 258,498
<br />$ 271,423
<br />$ 284,995
<br />$ 299,244
<br />$ 314,206
<br />$ 329,917
<br />$ 346,413
<br />$ 363,733
<br />$ 381,920
<br />$ 401,016
<br />$ 421,067
<br />$ 442,120
<br />$ 464,226
<br />$ 487,437
<br />$ 511,809
<br />$ 537,400
<br />$ 564,270
<br />$ 8,349,212
<br />Aquatics Fees
<br />$ 208,500
<br />$ 225,000
<br />$ 236,250
<br />$ 248,063
<br />$ 260,466
<br />$ 273,489
<br />$ 287,163
<br />$ 301,522
<br />$ 316,598
<br />$ 332,427
<br />$ 349,049
<br />$ 366,501
<br />$ 384,826
<br />$ 404,068
<br />$ 424,271
<br />$ 445,485
<br />$ 467,759
<br />$ 491,147
<br />$ 515,704
<br />$ 541,489
<br />$ 568,564
<br />$ 596,992
<br />$ 626,842
<br />$ 658,184
<br />$ 691,093
<br />$ 10,221,450
<br />Subtotal- General Admissions & Program Fees
<br />$ 2,334,940
<br />$ 2,622,390
<br />$ 2,753,510
<br />$ 2,891,185
<br />$ 3,035,744
<br />$ 3,187,531
<br />$ 3,346,908
<br />$ 3,514,253
<br />$ 3,689,966
<br />$ 3,874,464
<br />$ 4,068,188
<br />$ 4,271,597
<br />$ 4,485,177
<br />$ 4,709,436
<br />$ 4,944,907
<br />$ 5,192,153
<br />$ 5,451,760
<br />$ 5,724,348
<br />$ 6,010,566
<br />$ 6,311,094
<br />$ 6,626,649
<br />$ 6,957,981
<br />$ 7,305,880
<br />$ 7,671,174
<br />$ 8,054,733
<br />$ 119,036,537
<br />Rec Center Sales and Use Tax Generated Revenue
<br />$ 913,710
<br />$ 965,760
<br />$ 994,733
<br />$ 1,024,575
<br />$ 1,055,312
<br />$ 1,086,971
<br />$ 1,119,581
<br />$ 1,153,168
<br />$ 1,187,763
<br />$ 1,223,396
<br />$ 1,260,098
<br />$ 1,297,901
<br />$ 1,336,838
<br />$ 1,376,943
<br />$ 1,418,251
<br />$ 1,460,799
<br />$ 1,504,623
<br />$ 1,549,761
<br />$ 1,596,254
<br />$ 1,644,142
<br />$ 1,693,466
<br />$ 1,744,270
<br />$ 1,796,598
<br />$ 1,850,496
<br />$ 1,906,011
<br />$ 34,161,418
<br />General Fund Subsidy
<br />Capital Expenditures Funded Through the Capital Projects Fund
<br />$ 335,760
<br />$ 171,000
<br />$ 132,600
<br />$ 136,578
<br />$ 140,675
<br />$ 144,896
<br />$ 149,242
<br />$ 153,720
<br />$ 158,331
<br />$ 163,081
<br />$ 167,974
<br />$ 173,013
<br />$ 178,203
<br />$ 183,549
<br />$ 189,056
<br />$ 194,728
<br />$ 200,569
<br />$ 206,586
<br />$ 212,784
<br />$ 219,168
<br />$ 225,743
<br />$ 232,515
<br />$ 239,490
<br />$ 246,675
<br />$ 254,075
<br />$ 4,810,012
<br />Total Sources of Funds
<br />$ 3,584,410
<br />$ 3,759,150
<br />$ 3,880,842
<br />$ 4,052,338
<br />$ 4,231,732
<br />$ 4,419,398
<br />$ 4,615,731
<br />$ 4,821,141
<br />$ 5,036,060
<br />$ 5,260,942
<br />$ 5,496,259
<br />$ 5,742,511
<br />$ 6,000,218
<br />$ 6,269,928
<br />$ 6,552,214
<br />$ 6,847,679
<br />$ 7,156,952
<br />$ 7,480,696
<br />$ 7,819,604
<br />$ 8,174,404
<br />$ 8,545,858
<br />$ 8,934,766
<br />$ 9,341,969
<br />$ 9,768,346
<br />$ 10,214,819
<br />$ 158,007,967
<br />Uses of Funds:
<br />Recreation Center Building Maintenance
<br />$ 656,720
<br />$ 692,710
<br />$ 727,346
<br />$ 763,713
<br />$ 801,898
<br />$ 841,993
<br />$ 884,093
<br />$ 928,298
<br />$ 974,713
<br />$ 1,023,448
<br />$ 1,074,621
<br />$ 1,128,352
<br />$ 1,184,769
<br />$ 1,244,008
<br />$ 1,306,208
<br />$ 1,371,518
<br />$ 1,440,094
<br />$ 1,512,099
<br />$ 1,587,704
<br />$ 1,667,089
<br />$ 1,750,444
<br />$ 1,837,966
<br />$ 1,929,864
<br />$ 2,026,357
<br />$ 2,127,675
<br />$ 31,483,700
<br />Recreation Center Management
<br />$ 718,330
<br />$ 745,980
<br />$ 783,279
<br />$ 822,443
<br />$ 863,565
<br />$ 906,743
<br />$ 952,081
<br />$ 999,685
<br />$ 1,049,669
<br />$ 1,102,152
<br />$ 1,157,260
<br />$ 1,215,123
<br />$ 1,275,879
<br />$ 1,339,673
<br />$ 1,406,657
<br />$ 1,476,989
<br />$ 1,550,839
<br />$ 1,628,381
<br />$ 1,709,800
<br />$ 1,795,290
<br />$ 1,885,054
<br />$ 1,979,307
<br />$ 2,078,272
<br />$ 2,182,186
<br />$ 2,291,295
<br />$ 33,915,931
<br />Recreation Center Aquatics
<br />$ 726,170
<br />$ 751,450
<br />$ 789,023
<br />$ 828,474
<br />$ 869,897
<br />$ 913,392
<br />$ 959,062
<br />$ 1,007,015
<br />$ 1,057,366
<br />$ 1,110,234
<br />$ 1,165,746
<br />$ 1,224,033
<br />$ 1,285,235
<br />$ 1,349,496
<br />$ 1,416,971
<br />$ 1,487,820
<br />$ 1,562,211
<br />$ 1,640,321
<br />$ 1,722,337
<br />$ 1,808,454
<br />$ 1,898,877
<br />$ 1,993,821
<br />$ 2,093,512
<br />$ 2,198,187
<br />$ 2,308,097
<br />$ 34,167,197
<br />Fitness & Wellness
<br />$ 293,060
<br />$ 301,960
<br />$ 317,058
<br />$ 332,911
<br />$ 349,556
<br />$ 367,034
<br />$ 385,386
<br />$ 404,655
<br />$ 424,888
<br />$ 446,132
<br />$ 468,439
<br />$ 491,861
<br />$ 516,454
<br />$ 542,277
<br />$ 569,391
<br />$ 597,860
<br />$ 627,753
<br />$ 659,141
<br />$ 692,098
<br />$ 726,703
<br />$ 763,038
<br />$ 801,190
<br />$ 841,249
<br />$ 883,312
<br />$ 927,477
<br />$ 13,730,884
<br />Youth Activities
<br />$ 413,070
<br />$ 457,340
<br />$ 480,207
<br />$ 504,217
<br />$ 529,428
<br />$ 555,900
<br />$ 583,695
<br />$ 612,879
<br />$ 643,523
<br />$ 675,699
<br />$ 709,484
<br />$ 744,959
<br />$ 782,207
<br />$ 821,317
<br />$ 862,383
<br />$ 905,502
<br />$ 950,777
<br />$ 998,316
<br />$ 1,048,232
<br />$ 1,100,643
<br />$ 1,155,675
<br />$ 1,213,459
<br />$ 1,274,132
<br />$ 1,337,839
<br />$ 1,404,731
<br />$ 20,765,614
<br />Memory Square Pool
<br />$ 158,190
<br />$ 163,050
<br />$ 171,203
<br />$ 179,763
<br />$ 188,751
<br />$ 198,188
<br />$ 208,098
<br />$ 218,503
<br />$ 229,428
<br />$ 240,899
<br />$ 252,944
<br />$ 265,591
<br />$ 278,871
<br />$ 292,814
<br />$ 307,455
<br />$ 322,828
<br />$ 338,969
<br />$ 355,918
<br />$ 373,714
<br />$ 392,399
<br />$ 412,019
<br />$ 432,620
<br />$ 454,251
<br />$ 476,964
<br />$ 500,812
<br />$ 7,414,241
<br />Youth Sports
<br />$ 253,650
<br />$ 257,140
<br />$ 269,997
<br />$ 283,497
<br />$ 297,672
<br />$ 312,555
<br />$ 328,183
<br />$ 344,592
<br />$ 361,822
<br />$ 379,913
<br />$ 398,909
<br />$ 418,854
<br />$ 439,797
<br />$ 461,786
<br />$ 484,876
<br />$ 509,120
<br />$ 534,576
<br />$ 561,304
<br />$ 589,370
<br />$ 618,838
<br />$ 649,780
<br />$ 682,269
<br />$ 716,382
<br />$ 752,202
<br />$ 789,812
<br />$ 11,696,894
<br />Adult Sports
<br />$ 51,580
<br />$ 52,460
<br />$ 55,083
<br />$ 57,837
<br />$ 60,729
<br />$ 63,765
<br />$ 66,954
<br />$ 70,301
<br />$ 73,816
<br />$ 77,507
<br />$ 81,383
<br />$ 85,452
<br />$ 89,724
<br />$ 94,211
<br />$ 98,921
<br />$ 103,867
<br />$ 109,061
<br />$ 114,514
<br />$ 120,239
<br />$ 126,251
<br />$ 132,564
<br />$ 139,192
<br />$ 146,152
<br />$ 153,459
<br />$ 161,132
<br />$ 2,386,155
<br />Seniors
<br />$ 361,760
<br />$ 368,710
<br />$ 387,146
<br />$ 406,503
<br />$ 426,828
<br />$ 448,169
<br />$ 470,578
<br />$ 494,107
<br />$ 518,812
<br />$ 544,753
<br />$ 571,990
<br />$ 600,590
<br />$ 630,619
<br />$ 662,150
<br />$ 695,258
<br />$ 730,021
<br />$ 766,522
<br />$ 804,848
<br />$ 845,090
<br />$ 887,345
<br />$ 931,712
<br />$ 978,297
<br />$ 1,027,212
<br />$ 1,078,573
<br />$ 1,132,502
<br />$ 16,770,092
<br />Senior Meals
<br />$ 176,090
<br />$ 180,250
<br />$ 189,263
<br />$ 198,726
<br />$ 208,662
<br />$ 219,095
<br />$ 230,050
<br />$ 241,552
<br />$ 253,630
<br />$ 266,311
<br />$ 279,627
<br />$ 293,608
<br />$ 308,289
<br />$ 323,703
<br />$ 339,888
<br />$ 356,883
<br />$ 374,727
<br />$ 393,463
<br />$ 413,136
<br />$ 433,793
<br />$ 455,483
<br />$ 478,257
<br />$ 502,170
<br />$ 527,278
<br />$ 553,642
<br />$ 8,197,575
<br />Nite at the Rec
<br />$ 118,020
<br />$ 120,610
<br />$ 126,641
<br />$ 132,973
<br />$ 139,621
<br />$ 146,602
<br />$ 153,932
<br />$ 161,629
<br />$ 169,710
<br />$ 178,196
<br />$ 187,106
<br />$ 196,461
<br />$ 206,284
<br />$ 216,598
<br />$ 227,428
<br />$ 238,800
<br />$ 250,740
<br />$ 263,277
<br />$ 276,440
<br />$ 290,262
<br />$ 304,775
<br />$ 320,014
<br />$ 336,015
<br />$ 352,816
<br />$ 370,456
<br />$ 5,485,406
<br />Memory Square Building Maintenance
<br />$ 45,240
<br />$ 47,480
<br />$ 49,854
<br />$ 52,347
<br />$ 54,964
<br />$ 57,712
<br />$ 60,598
<br />$ 63,628
<br />$ 66,809
<br />$ 70,150
<br />$ 73,657
<br />$ 77,340
<br />$ 81,207
<br />$ 85,267
<br />$ 89,531
<br />$ 94,007
<br />$ 98,708
<br />$ 103,643
<br />$ 108,825
<br />$ 114,266
<br />$ 119,980
<br />$ 125,979
<br />$ 132,278
<br />$ 138,891
<br />$ 145,836
<br />$ 2,158,195
<br />Athletic Field Maintenance
<br />$ 181,810
<br />$ 187,070
<br />$ 196,424
<br />$ 206,245
<br />$ 216,557
<br />$ 227,385
<br />$ 238,754
<br />$ 250,692
<br />$ 263,226
<br />$ 276,388
<br />$ 290,207
<br />$ 304,717
<br />$ 319,953
<br />$ 335,951
<br />$ 352,748
<br />$ 370,386
<br />$ 388,905
<br />$ 408,350
<br />$ 428,768
<br />$ 450,206
<br />$ 472,717
<br />$ 496,352
<br />$ 521,170
<br />$ 547,229
<br />$ 574,590
<br />$ 8,506,799
<br />Subtotal- Operating Expenses
<br />$ 4,153,690
<br />$ 4,326,210
<br />$ 4,542,521
<br />$ 4,769,647
<br />$ 5,008,129
<br />$ 5,258,535
<br />$ 5,521,462
<br />$ 5,797,535
<br />$ 6,087,412
<br />$ 6,391,783
<br />$ 6,711,372
<br />$ 7,046,940
<br />$ 7,399,287
<br />$ 7,769,252
<br />$ 8,157,714
<br />$ 8,565,600
<br />$ 8,993,880
<br />$ 9,443,574
<br />$ 9,915,753
<br />$ 10,411,540
<br />$ 10,932,117
<br />$ 11,478,723
<br />$ 12,052,659
<br />$ 12,655,292
<br />$ 13,288,057
<br />$ 196,678,683
<br />FF&E Expenditures
<br />$ 335,760
<br />$ 171,000
<br />$ 301,880
<br />$ 140,717
<br />$ 119,993
<br />$ 480,102
<br />$ 29,288
<br />$ 467,675
<br />$ 360,460
<br />$ 790,391
<br />$ -
<br />$ 583,469
<br />$ -
<br />$ 214,309
<br />$ 865,593
<br />$ 592,436
<br />$ -
<br />$ 684,511
<br />$ -
<br />$ 1,146,080
<br />$ 558,231
<br />$ 225,851
<br />$ -
<br />$ 1,328,217
<br />$ 243,992
<br />$ 9,639,955
<br />Average Annual Building Renewal and Replacement Expense
<br />$ -
<br />$ -
<br />$ 278,310
<br />$ 286,659
<br />$ 295,259
<br />$ 304,117
<br />$ 313,240
<br />$ 322,637
<br />$ 332,317
<br />$ 342,286
<br />$ 352,555
<br />$ 363,131
<br />$ 374,025
<br />$ 385,246
<br />$ 396,803
<br />$ 408,707
<br />$ 420,969
<br />$ 433,598
<br />$ 446,606
<br />$ 460,004
<br />$ 473,804
<br />$ 488,018
<br />$ 502,659
<br />$ 517,738
<br />$ 533,270
<br />$ 9,031,958
<br />Total Uses of Funds
<br />$ 4,489,450
<br />$ 4,497,210
<br />$ 5,122,710
<br />$ 5,197,023
<br />$ 5,423,381
<br />$ 6,042,754
<br />$ 5,863,990
<br />$ 6,587,847
<br />$ 6,780,189
<br />$ 7,524,459
<br />$ 7,063,926
<br />$ 7,993,540
<br />$ 7,773,312
<br />$ 8,368,807
<br />$ 9,420,110
<br />$ 9,566,744
<br />$ 9,414,849
<br />$ 10,561,682
<br />$ 10,362,358
<br />$ 12,017,624
<br />$ 11,964,152
<br />$ 12,192,592
<br />$ 12,555,318
<br />$ 14,501,248
<br />$ 14,065,319
<br />$ 215,350,595
<br />Annual Net Surplus/(Deficit) of Funds
<br />$ (905,040)
<br />$ (738,060)
<br />$ (1,241,868)
<br />$ (1,144,685)
<br />$ (1,191,649)
<br />$ (1,623,356)
<br />$ (1,248,259)
<br />$ (1,766,706)
<br />$ (1,744,129)
<br />$ (2,263,518)
<br />$ (1,567,667)
<br />$ (2,251,030)
<br />$ (1,773,095)
<br />$ (2,098,879)
<br />$ (2,867,896)
<br />$ (2,719,065)
<br />$ (2,257,896)
<br />$ (3,080,986)
<br />$ (2,542,754)
<br />$ (3,843,221)
<br />$ (3,418,295)
<br />$ (3,257,825)
<br />$ (3,213,349)
<br />$ (4,732,902)
<br />$ (3,850,500)
<br />$ (57,342,628)
<br />Cumulative Net Surplus/(Deficit) of Funds
<br />$ (905,040)
<br />$ (1,643,100)
<br />$ (2,884,968)
<br />$ (4,029,653)
<br />$ (5,221,302)
<br />$ (6,844,657)
<br />$ (8,092,917)
<br />$ (9,859,623)
<br />$ (11,603,752)
<br />$ (13,867,269)
<br />$ (15,434,937)
<br />$ (17,685,966)
<br />$ (19,459,061)
<br />$ (21,557,940)
<br />$ (24,425,835)
<br />$ (27,144,900)
<br />$ (29,402,796)
<br />$ (32,483,782)
<br />$ (35,026,536)
<br />$ (38,869,757)
<br />$ (42,288,052)
<br />$ (45,545,877)
<br />$ (48,759,226)
<br />$ (53,492,128)
<br />$ (57,342,628)
<br />12
<br />
|