|
DRAFT -11/27/18
<br />Louisville Recreation & Senior Center and Memory Square Pool
<br />25-Year Building and Equipment Renewal and Replacement Projections
<br />Source & Uses Statement for Recreation Fund
<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)
<br />13,116,687
<br />(Includes Soft Costs)
<br />Annual Building Current Replacement Value Inflation Factor
<br />3.00%
<br />Annual FF&E Replacement Value Inflation Factor
<br />3.00%
<br />Annual Sales Tax Inflation Factor
<br />3.00%
<br />Annual Intergovernmental Revenue and Charges for Services Fee Inflator
<br />3.00%
<br />Annual Non -Capital Operating Expense Inflation Factor (Cost of Government)
<br />3.00%
<br />Annual CIP Allocation Inflation Factor
<br />3.00%
<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 Year 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 Year 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 Year 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 Year 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 Year 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 10 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 - Recreation Center Fund:
<br />Sources of Funds:
<br />905,820
<br />55,000
<br />2,384,210
<br />957,610
<br />60,000
<br />2,532,230
<br />952,370
<br />60,000
<br />2,653,280
<br />935,890
<br />55,000
<br />2,780,600
<br />1,008,750
<br />60,000
<br />2,913,640
<br />1,024,340
<br />61,980
<br />3,053,210
<br />1,055,070
<br />63,839
<br />3,144,806
<br />1,086,722
<br />65,755
<br />3,239,150
<br />1,119,324
<br />67,727
<br />3,336,325
<br />1,152,904
<br />69,759
<br />3,436,415
<br />1,187,491
<br />71,852
<br />3,539,507
<br />1,223,116
<br />74,007
<br />3,645,692
<br />1,259,809
<br />76,228
<br />3,755,063
<br />1,297,603
<br />78,514
<br />3,867,715
<br />1,336,531
<br />80,870
<br />3,983,747
<br />1,376,627
<br />83,296
<br />4,103,259
<br />1,417,926
<br />85,795
<br />4,226,357
<br />1,460,464
<br />88,369
<br />4,353,147
<br />1,504,278
<br />91,020
<br />4,483,742
<br />1,549,406
<br />93,750
<br />4,618,254
<br />1,595,888
<br />96,563
<br />4,756,802
<br />1,643,765
<br />99,460
<br />4,899,506
<br />1,693,078
<br />102,443
<br />5,046,491
<br />1,743,870
<br />105,517
<br />5,197,886
<br />1,796,186
<br />108,682
<br />5,353,822
<br />32,284,839
<br />1,955,426
<br />95,304,856
<br />Taxes
<br />Intergovernmental Revenue
<br />Charges for Services
<br />Subtotal - Fund Operating Revenue
<br />3,345,030 3,549,840 3,665,650 3,771,490 3,982,390 4,139,530 4,263,716 4,391,627 4,523,376 4,659,077 4,798,850 4,942,815 5,091,100 5,243,833 5,401,148 5,563,182 5,730,078 5,901,980 6,079,039 6,261,411 6,449,253 6,642,730 6,842,012 7,047,273 7,258,691 129,545,121
<br />1,735,360 1,093,530 1,131,800 1,171,410 1,209,480 1,248,790 1,286,254 1,324,841 1,364,587 1,405,524 1,447,690 1,491,121 1,535,854 1,581,930 1,629,388 1,678,269 1,728,617 1,780,476 1,833,890 1,888,907 1,945,574 2,003,941 2,064,060 2,125,981 2,189,761 39,897,035
<br />125,000 129,690 134,230 138,930 143,450 148,110 152,553 157,130 161,844 166,699 171,700 176,851 182,157 187,621 193,250 199,047 205,019 211,169 217,505 224,030 230,751 237,673 244,803 252,147 259,712 4,651,071
<br />General Fund Operating Subsidy
<br />Capital Projects Fund Capital Subsidy
<br />Total Sources of Funds
<br />5,205,390 4,773,060 4,931,680 5,081,830 5,335,320 5,536,430 5,702,523 5,873,599 6,049,807 6,231,301 6,418,240 6,610,787 6,809,111 7,013,384 7,223,785 7,440,499 7,663,714 7,893,625 8,130,434 8,374,347 8,625,578 8,884,345 9,150,875 9,425,401 9,708,164 174,093,227
<br />728,940 767,070 791,890 816,850 842,660 869,340 895,420 922,283 949,951 978,450 1,007,803 1,038,037 1,069,179 1,101,254 1,134,292 1,168,320 1,203,370 1,239,471 1,276,655 1,314,955 1,354,403 1,395,035 1,436,887 1,479,993 1,524,393 27,306,901
<br />536,340 553,790 570,960 588,520 606,710 625,440 644,203 663,529 683,435 703,938 725,056 746,808 769,212 792,289 816,057 840,539 865,755 891,728 918,480 946,034 974,415 1,003,648 1,033,757 1,064,770 1,096,713 19,662,127
<br />765,790 789,860 823,490 848,840 875,010 902,010 929,070 956,942 985,651 1,015,220 1,045,677 1,077,047 1,109,359 1,142,639 1,176,918 1,212,226 1,248,593 1,286,051 1,324,632 1,364,371 1,405,302 1,447,461 1,490,885 1,535,612 1,581,680 28,340,336
<br />373,380 385,420 401,880 414,370 427,270 440,570 453,787 467,401 481,423 495,865 510,741 526,064 541,846 558,101 574,844 592,089 609,852 628,147 646,992 666,402 686,394 706,986 728,195 750,041 772,542 13,840,601
<br />372,110 410,080 425,900 439,260 453,060 467,340 481,360 495,801 510,675 525,995 541,775 558,028 574,769 592,012 609,773 628,066 646,908 666,315 686,305 706,894 728,100 749,944 772,442 795,615 819,484 14,658,011
<br />172,010 176,520 183,700 189,550 195,610 201,850 207,906 214,143 220,567 227,184 233,999 241,019 248,250 255,698 263,368 271,270 279,408 287,790 296,424 305,316 314,476 323,910 333,627 343,636 353,945 6,341,175
<br />226,450 227,310 234,740 242,170 249,830 257,750 265,483 273,447 281,650 290,100 298,803 307,767 317,000 326,510 336,305 346,394 356,786 367,490 378,515 389,870 401,566 413,613 426,021 438,802 451,966 8,106,339
<br />44,370 44,520 46,010 47,450 48,950 50,470 51,984 53,544 55,150 56,804 58,509 60,264 62,072 63,934 65,852 67,827 69,862 71,958 74,117 76,340 78,631 80,990 83,419 85,922 88,499 1,587,448
<br />461,160 469,430 485,600 501,150 517,220 533,840 549,855 566,351 583,341 600,842 618,867 637,433 656,556 676,253 696,540 717,436 738,959 761,128 783,962 807,481 831,705 856,656 882,356 908,827 936,092 16,779,041
<br />171,060 173,650 179,620 185,280 191,150 197,190 203,106 209,199 215,475 221,939 228,597 235,455 242,519 249,794 257,288 265,007 272,957 281,146 289,580 298,268 307,216 316,432 325,925 335,703 345,774 6,199,329
<br />106,170 107,650 111,370 115,020 118,820 122,750 126,433 130,225 134,132 138,156 142,301 146,570 150,967 155,496 160,161 164,966 169,915 175,012 180,263 185,670 191,241 196,978 202,887 208,974 215,243 3,857,368
<br />45,240 47,400 49,050 50,730 52,490 54,290 55,919 57,596 59,324 61,104 62,937 64,825 66,770 68,773 70,836 72,961 75,150 77,405 79,727 82,118 84,582 87,120 89,733 92,425 95,198 1,703,703
<br />175,910 178,520 182,240 188,440 194,850 201,520 207,566 213,793 220,206 226,813 233,617 240,625 247,844 255,280 262,938 270,826 278,951 287,319 295,939 304,817 313,962 323,380 333,082 343,074 353,367 6,334,878
<br />Uses of Funds:
<br />Recreation Center Building Maintenance
<br />Recreation Center Management
<br />Recreation Center Aquatics
<br />Fitness & Wellness
<br />Youth Activities
<br />Memory Square Pool
<br />Youth Sports
<br />Adult Sports
<br />Seniors
<br />Senior Meals
<br />Nite at the Rec
<br />Memory Square Building Maintenance
<br />Athletic Field Maintenance
<br />Subtotal - Fund Operating Expenditures
<br />4,178,930 4,331,220 4,486,450 4,627,630 4,773,630 4,924,360 5,072,091 5,224,254 5,380,981 5,542,411 5,708,683 5,879,943 6,056,342 6,238,032 6,425,173 6,617,928 6,816,466 7,020,960 7,231,589 7,448,536 7,671,992 7,902,152 8,139,217 8,383,393 8,634,895 154,717,257
<br />400,760 171,000 70,000 233,000 70,000 70,000 - - - - - - - - - - - - - - - - - - - 1,014,760
<br />- - - - - - 29,288 467,675 360,460 790,391 - 583,469 - 214,309 865,593 592,436 - 684,511 - 1,146,080 558,231 225,851 - 1,328,217 243,992 8,090,503
<br />- - - - - - 313,240 322,637 332,317 342,286 352,555 363,131 374,025 385,246 396,803 408,707 420,969 433,598 446,606 460,004 473,804 488,018 502,659 517,738 533,270 7,867,613
<br />Actual/Estimated Capital Expenditures from Budget and LTFP
<br />FF&E Expenditures (from preceding schedule)
<br />Average Annual Building R&R Expense (from preceding schedule)
<br />Total Uses of Funds
<br />4,579,690 4,502,220 4,556,450 4,860,630 4,843,630 4,994,360 5,414,619 6,014,566 6,073,758 6,675,087 6,061,237 6,826,543 6,430,367 6,837,587 7,687,569 7,619,072 7,237,435 8,139,068 7,678,194 9,054,621 8,704,028 8,616,021 8,641,875 10,229,349 9,412,157 171,690,134
<br />625,700 270,840 375,230 221,200 491,690 542,070 287,904 (140,967) (23,952) (443,787) 357,002 (215,756) 378,744 175,797 (463,783) (178,573) 426,279 (245,443) 452,240 (680,273) (78,450) 268,324 509,000 (803,947) 296,006 2,403,094
<br />Annual Net Surplus/(Deficit) of Funds
<br />Cumulative Net Surplus/(Deficit) of Funds
<br />625,700 896,540 1,271,770 1,492,970 1,984,660 2,526,730 2,814,634 2,673,667 2,649,715 2,205,928 2,562,931 2,347,174 2,725,918 2,901,715 2,437,931 2,259,359 2,685,638 2,440,195 2,892,435 2,212,161 2,133,711 2,402,035 2,911,035 2,107,088 2,403,094
<br />- 625,700 896,540 1,271,770 1,492,970 1,984,660 2,526,730 2,814,634 2,673,667 2,649,715 2,205,928 2,562,931 2,347,174 2,725,918 2,901,715 2,437,931 2,259,359 2,685,638 2,440,195 2,892,435 2,212,161 2,133,711 2,402,035 2,911,035 2,107,088
<br />625,700 270,840 375,230 221,200 491,690 542,070 287,904 (140,967) (23,952) (443,787) 357,002 (215,756) 378,744 175,797 (463,783) (178,573) 426,279 (245,443) 452,240 (680,273) (78,450) 268,324 509,000 (803,947) 296,006
<br />Beginning Fund Balance - Recreation Fund
<br />Net of Fund Operating Revenue and Operating Expenditures
<br />Ending Fund Balance - Recreation Fund
<br />625,700 896,540 1,271,770 1,492,970 1,984,660 2,526,730 2,814,634 2,673,667 2,649,715 2,205,928 2,562,931 2,347,174 2,725,918 2,901,715 2,437,931 2,259,359 2,685,638 2,440,195 2,892,435 2,212,161 2,133,711 2,402,035 2,911,035 2,107,088 2,403,094
<br />(138,426) 85,825 596,015 790,391 1,135,643 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862 1,849,862
<br />Calculation of Renewal & Replacement Reserve
<br />From Budget & Long -Term Financial Plan
<br />Calculated in Worksheet Using Assumptions Shown Above
<br />17
<br />
|