DRAFT - 616123
<br />Recreation & Senior Center and Memory Square Poo
<br />25-Year Building and Equipment Renewal and Replacement Projection
<br />Source & Uses Statement for Recreation Fun(
<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
<br />Costs)
<br />Annual Building Current Replacement Value Inflation Factor
<br />3.000/6
<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 Govemment)
<br />3.00%
<br />Annual CIP Allocation Inflation Factor
<br />3.00%
<br />Annual Tumback Percentage
<br />4.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 />Ex enditurea
<br />Furniture, Fixtures, and Equipment (FF&E) Replacement
<br />152,680 183,33' 194,337 200,167
<br />2 76,340 91,669 97,169 100,084
<br />FF&E Replacement Value with 2 Year Replacement Cycle
<br />204,514
<br />210,650
<br />216,969
<br />223,478
<br />230,183
<br />237,088
<br />244,201
<br />251,527
<br />259,072
<br />266,845
<br />274,850
<br />283,095
<br />291,588
<br />300,336
<br />309,346
<br />318,626
<br />328,185
<br />338,031
<br />348,172
<br />358,617
<br />369,375
<br />Annual Renewal and Replacement Reserve for FF&E with 2 Year Replacement
<br />102,257
<br />105,325
<br />108,485
<br />111,739
<br />115,091
<br />118,544
<br />122,100
<br />125,763
<br />129,536
<br />133,422
<br />137,425
<br />141,548
<br />145,794
<br />150,168
<br />154,673
<br />159,313
<br />164,093
<br />169,015
<br />174,08E
<br />179,308
<br />184,688
<br />3,297,635
<br />FF&E Replacement Value with 3 Year Replacement Cycle
<br />183,304 177,645 189,195 194,870
<br />3 61,101 59,215 63,065 64,957
<br />210,540
<br />216,856
<br />223,362
<br />230,063
<br />236,965
<br />244,074
<br />251,396
<br />258,938
<br />266,706
<br />274,707
<br />282,948
<br />291,437
<br />300,180
<br />309,185
<br />318,461
<br />328,014
<br />337,855
<br />347,991
<br />358,430
<br />369,183
<br />380,269
<br />Annual Renewal and Replacement Reserve for FF&E with 3 Year Replacement
<br />70,180
<br />72,285
<br />74,454
<br />76,688
<br />78,988
<br />81,358
<br />83,799
<br />86,313
<br />88,902
<br />91,569
<br />94,316
<br />97,146
<br />100,060
<br />103,062
<br />106,154
<br />109,338
<br />112,618
<br />115,997
<br />119,477
<br />123,061
<br />126,753
<br />2,260,854
<br />FF&E Replacement Value with 4 Year Replacement Cycle
<br />7,700 - - _
<br />4 1,925 _ _ Ezz::::::
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />Annual Renewal and Replacement Reserve for FF&E with 4 Year Replacement
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />1,925
<br />FF&E Replacement Value with 5 Year Replacement Cycle
<br />107,149 112,209 112,209 115,575
<br />5 21,430 22,442 22,442 23,115
<br />119,042
<br />122,614
<br />126,292
<br />130,081
<br />133,983
<br />138,003
<br />142,143
<br />146,407
<br />150,799
<br />155,323
<br />159,983
<br />164,782
<br />169,726
<br />174,818
<br />180,062
<br />185,464
<br />191,028
<br />196,759
<br />202,662
<br />208,741
<br />215,004
<br />Annual Renewal and Replacement Reserve for FF&E with 5 Year Replacement
<br />23,808
<br />24,523
<br />25,258
<br />26,016
<br />26,797
<br />27,601
<br />28,429
<br />29,281
<br />30,160
<br />31,065
<br />31,997
<br />32,956
<br />33,945
<br />34,964
<br />36,012
<br />37,093
<br />38,206
<br />39,352
<br />40,532
<br />41,748
<br />43,001
<br />772,171
<br />FF&E Replacement Value with 6 Year Replacement Cycle
<br />8,800 - - _
<br />61 1,467 _ _ _
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />Annual Renewal and Replacement Reserve for FF&E with 6 Year Replacement
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />_
<br />1,467
<br />FF&E Replacement Value with 7 Year Replacement Cycle
<br />22,786 30,618 30,618 31,536
<br />7 3,255 4,374 4,374 4,505
<br />38,232
<br />39,379
<br />40,560
<br />41,777
<br />43,030
<br />44,321
<br />45,651
<br />47,020
<br />48,431
<br />49,884
<br />51,380
<br />52,921
<br />54,509
<br />56,144
<br />57,829
<br />59,564
<br />61,350
<br />63,191
<br />65,087
<br />67,039
<br />69,051
<br />Annual Renewal and Replacement Reserve for FF&E with 7 Year Replacement
<br />5,462
<br />5,626
<br />5,794
<br />5,968
<br />6,147
<br />6.332
<br />6,522
<br />6,717
<br />6,919
<br />7,126
<br />7,340
<br />7,560
<br />7,787
<br />8,021
<br />8,261
<br />81509
<br />8,764
<br />9,027
<br />9,298
<br />9,577
<br />9,864
<br />173,129
<br />FF&E Replacement Value with 8 Year Replacement Cycle
<br />234,683 324,610 333,025 343,016
<br />8 29,335 40,576 41,628 42,877
<br />421,110
<br />433,743
<br />446,755
<br />460,158
<br />473,963
<br />488,182
<br />502,827
<br />517,912
<br />533,449
<br />549,453
<br />565,936
<br />582,914
<br />600,402
<br />618,414
<br />636,966
<br />656,075
<br />675,757
<br />696,030
<br />716,911
<br />738,418
<br />760,571
<br />Annual Renewal and Replacement Reserve for FF&E with 8 Year Replacement
<br />52,639
<br />54,218
<br />55,844
<br />57,520
<br />59,245
<br />61,023
<br />62,853
<br />64,739
<br />66,681
<br />68,682
<br />70,742
<br />72,864
<br />75,050
<br />77,302
<br />79,621
<br />82,009
<br />84,470
<br />87,004
<br />89,614
<br />92,302
<br />95,071
<br />1,663,910
<br />FF&E Replacement Value with 10 Year Replacement Cycle
<br />444,241 345,403 345,403 355,765
<br />10 44,424 34,540 34,540 35,577
<br />366,438
<br />377,432
<br />388,754
<br />400,417
<br />412,430
<br />424,802
<br />437,547
<br />450,673
<br />464,193
<br />478,119
<br />492,463
<br />507,236
<br />522,453
<br />538,127
<br />554,271
<br />570,899
<br />588,026
<br />605,667
<br />623,837
<br />642,552
<br />661,828
<br />Annual Renewal and Replacement Reserve for FF&E with 10 Year Replacement
<br />36,644
<br />37,743
<br />38,875
<br />40,042
<br />41,243
<br />42,480
<br />43,755
<br />45,067
<br />46,419
<br />47,812
<br />49,246
<br />50,724
<br />52,245
<br />53,813
<br />55,427
<br />57,090
<br />58,803
<br />60,567
<br />62,384
<br />64,255
<br />66,183
<br />1,199,898
<br />FF&E Replacement Value with 15 Year Replacement Cycle
<br />225:616 225,116 221,616 232,384
<br />15 15041 15,041 15,041 15,492
<br />239,355
<br />246,536
<br />253,932
<br />261,550
<br />269,397
<br />277,479
<br />285,803
<br />294,377
<br />303,208
<br />312,305
<br />321,674
<br />331,324
<br />341,264
<br />351,502
<br />362,047
<br />372,908
<br />384,095
<br />395,618
<br />407,487
<br />419,711
<br />432,303
<br />Annual Renewal and Replacement Reserve for FF&E with 15 Year Replacement
<br />15,957
<br />16,436
<br />16,929
<br />17,437
<br />17,960
<br />18,499
<br />19,054
<br />19,625
<br />20,214
<br />20,820
<br />21,445
<br />22,088
<br />22,751
<br />23,433
<br />24,136
<br />24,861
<br />25,606
<br />26,375
<br />27,166
<br />27,981
<br />28,820
<br />518,207
<br />FF&E Replacement Value with 20 Year Replacement Cycle
<br />52,800 52,800 52,800 54,384
<br />20 2,640 2,640 2,640 2,719
<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 />1 92,585
<br />95,363
<br />1 98,224
<br />101,170
<br />Annual Renewal and Replacement Reserve for FF&E with 20 Year Replacement
<br />2,801
<br />21885
<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 />90,956
<br />FF&E Replacement Value with 25 Year Replacement Cycle
<br />18,700 18,700 18,700 19,261
<br />25 748 748 748 770
<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 />Annual Renewal and Replacement Reserve for FF&E with 25 Year Replacement
<br />794
<br />817
<br />842
<br />1 867
<br />893
<br />1 920
<br />948
<br />1 976
<br />1,005
<br />1 1,035
<br />1,06E
<br />1 1,098
<br />1,131
<br />1 1,165
<br />1,200
<br />1,236
<br />1,273
<br />1,312
<br />1,351
<br />1,392
<br />1 1,433
<br />25,771
<br />Annual Renewal and Replacement Reserve for all FF&I
<br />257,706
<br />271,245
<br />281,647
<br />290,096
<br />310,541
<br />319,857
<br />329,453
<br />339,337
<br />349,517
<br />360,002
<br />370,802
<br />381,926
<br />393,384
<br />405,186
<br />417,341
<br />429,862
<br />442,757
<br />456,040
<br />469,721
<br />483,813
<br />498,327
<br />513,277
<br />528,675
<br />544,536
<br />560,872
<br />10,005,922
<br />Annual FF&E 2 Year Expenditures
<br />2
<br />197,252
<br />207,582
<br />220,224
<br />233,635
<br />247,864
<br />262,959
<br />278,973
<br />295,962
<br />313,986
<br />333,108
<br />353,394
<br />2,944,939
<br />Annual FF&E 3 Year Expenditures
<br />3
<br />198,202
<br />223,427
<br />244,145
<br />266,783
<br />291,521
<br />318,553
<br />348,092
<br />1,890,723
<br />Annual FF&E 4 Year Expenditures
<br />4
<br />Annual FF&E 5 Year Expenditures
<br />5
<br />119,146
<br />138,123
<br />160,123
<br />185,626
<br />603,018
<br />Annual FF&E 6 Year Expenditures
<br />6
<br />Annual FF&E 7 Year Expenditures
<br />7
<br />37,876
<br />48,515
<br />59,668
<br />146,059
<br />Annual FF&E 8 Year Expenditures
<br />8
<br />424,994
<br />558,913
<br />983,907
<br />Annual FF&E 10 Year Expenditures
<br />10
<br />395,966
<br />532,145
<br />928,112
<br />Annual FF&E 15 Year Expenditures
<br />151
<br />279,747
<br />279,747
<br />Annual FF&E 20 Year Expenditures
<br />201
<br />70,938
<br />70,938
<br />Annual FF&E 25 Year Expenditures
<br />25
<br />Total Annual FF&E Expendlturei
<br />197,252
<br />198,202
<br />207,582
<br />119,146
<br />443,651
<br />37,876
<br />658,629
<br />244,145
<br />781,953
<br />529,742
<br />327,488
<br />731,391
<br />854,87E
<br />632,540
<br />1,121,817
<br />407,760
<br />353,394
<br />7,847,443
<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 />847,856 1,019,338 1,095,420 1,141,080 1,207,060 1,249,670 1,290,800 1,339,210 1,385,420 1,426,983 1,469,792 1,513,886 1,559,302 1,606,081 1,654,264 1,703,892 1,755,009 1,807,659 1,861,889 , 5 1,975,278 2,034,536 2,095,572 2,158,439 38,053,137
<br />57,840 161,502 191,675 175,650 145,310 145,310 145,310 145,310 145,310 145,310 149,669 154,159 158,784 163,548 168,454 173,508 178,713 184,074 189,597 195,284 201,143 207,177 213,393 219,794 226,388 4,242,213
<br />2,908,975 1,086,157 2,103,096 2,319,980 2,430,110 2,504,020 2,577,940 2,652,090 2,728,730 2,807,880 2,892,116 2,978,880 3,068,246 3,160,294 3,255,102 3,352,756 3,453,338 3,556,938 3,663,647 3,773,556 3,886,763 4,003,365 4,123,466 4,247,170 4,374,586 77,909,202
<br />94,721 199,881 75,757 101,660 81,980 81,400 89,160 95,730 102,570 109,100 112,373 115,744 119,217 122,793 126,477 130,271 134,179 138,205 142,351 146,621 151,020 155,551 160,217 165,024 169,974 3,121,975
<br />Taxes
<br />Intergovernmental Revenue
<br />Charges for Services
<br />Miscellaneous
<br />Subtotal- Fund Operating Revenue
<br />3,998,493 2,295,396 3,389,865 3,692,710 3,798,480 3,937,790 4,062,080 4,183,930 4,315,820 4,447,710 4,581,141 4,718,576 4,860,133 5,005,937 5,156,115 5,310,798 5,470,122 5,634,226 5,803,253 5,977,350 6,156,671 6,341,371 6,531,612 6,727,560 6,929,387 123,326,527
<br />1,735,360 1,525,120 1,440,150 1,174,090 1,225,750 1,268,650 1,309,880 1,349,180 1,389,660 1,431,350 1,474,291 1,518,519 1,564,075 1,610,997 1,659,327 1,709,107 1,760,380 1,813,191 1,867,587 1,923,615 1,981,323 2,040,763 2,101,986 2,165,045 2,229,997 41,269,392
<br />125,000 127,440 131,950 142,110 148,360 153,550 158,540 163,300 168,200 173,250 178,448 183,801 189,315 194,994 200,844 206,870 213,076 219,468 226,052 232,834 239,819 247,013 254,423 262,056 269,918 4,810,630
<br />General Fund Operating Subsidy
<br />Capital Projects Fund Capital Subsidy
<br />Total Sources of Funds
<br />5,858,853 3,947,956 4,961,965 5,008,910 5,172,590 5,359,990 5,530,500 5,696,410 5,873,680 6,052,310 6,233,879 6,420,896 6,613,523 6,811,928 7,016,286 7,226,775 7,443,578 7,666,885 7,896,892 8,133,799 8,377,812 8,629,147 8,888,021 9,154,662 9,429,302 169,406,548
<br />43,718 62,800 72,801 105,500 105,000 120,750 129,200 138,240 147,920 158,270 163,018 167,909 172,946 178,134 183,478 188,983 194,652 200,492 206,506 212,702 219,083 225,655 232,425 239,398 246,580 4,116,159
<br />840,861 734,708 875,655 885,920 903,800 919,810 957,720 997,060 1,036,660 1,079,370 1,111,751 1,145,104 1,179,457 1,214,840 1,251,286 1,288,824 1,327,489 1,367,314 1,408,333 1,450,583 1,494,101 1,538,924 1,585,091 1,632,644 1,681,623 29,908,927
<br />577,540 404,130 455,210 612,670 684,460 710,330 738,480 767,620 797,920 829,490 854,375 880,006 906,406 933,598 961,606 990,454 1,020,168 1,050,773 1,082,296 1,114,765 1,148,208 1,182,654 1,218,134 1,254,678 1,292,318 22,468,291
<br />820,282 568,596 647,677 830,700 833,050 877,270 925,410 963,840 1,003,450 1,044,770 1,076,113 1,108,396 1,141,648 1,175,898 1,211,175 1,247,510 1,284,935 1,323,483 1,363,188 1,404,084 1,446,206 1,489,592 1,534,280 1,580,308 1,627,718 28,529,580
<br />342,991 299,450 321,055 406,750 422,780 433,880 458,130 477,190 497,080 517,860 533,396 549,398 565,880 582,856 600,342 618,352 636,902 656,010 675,690 695,961 716,839 738,345 760,495 783,310 806,809 14,097,750
<br />347:693 254:506 332:068 352:030 398:460 416:310 434:450 452:730 471:840 491,810 506,564 521,761 537,414 553,536 570,143 587,247 604,864 623,010 641,700 660,952 680,780 701,203 722,240 743,907 766,224 13,373,443
<br />218,579 130,221 181,689 199,230 198,970 210,560 220,530 229,840 239,530 249,660 257,150 264,864 272,810 280,995 289,424 298,107 307,050 316,262 325,750 335,522 345,588 355,955 366,634 377,633 388,962 6,861,516
<br />220,705 189,372 203,279 232,010 256,720 268,470 280,700 292,770 305,410 318,620 328,179 338,024 348,165 358,610 369,368 380,449 391,862 403,618 415,727 428,199 441,045 454,276 467,904 481,941 496,400 8,671,821
<br />41,439 37,855 40,614 43,690 49,780 52,390 54,780 57,160 59,650 62,260 64,128 66,052 68,033 70,074 72,176 74,342 76,572 78,869 81,235 83,672 86,182 88,768 91,431 94,174 96,999 1,692,324
<br />461,616 350,005 291,951 338,190 384,920 409,510 428,190 448,540 466,900 489,070 503,742 518,854 534,420 550,453 566,966 583,975 601,494 619,539 638,125 657,269 676,987 697,297 718,216 739,762 761,955 13,437,948
<br />164:261 287:17 276,197 303,410 311,031 11,320 358,441 371,180 394,161 413,350 421,711 438,123 411,671 461,229 479,116 493,162 508,361 123,619 131,321 555,108 172,173 189,338 617,011 625,229 643,98E 11,141,939
<br />102646 66825 - - - - - - - - - - - - - - - - - - - - - - - 169,472
<br />38,170 18,889 39,564 36,440 50,080 50,830 52,770 54,770 56,840 58,970 60,739 62,561 64,438 66,371 68,362 70,413 72,526 74,701 76,942 79,251 81,628 84,077 86,599 89,197 91,873 1,587,004
<br />216,427 131,479 248,820 1421221170 2970 228870 238,50 2472528262,4 27082 27897 287,3221546 304824 313,0969 323333343,082 3593,375 3,97E 374386,142 6,868,720130 0 0,5 52 ,09000N/A N/A /A 22,98,
<br />00 11262,9,2218,07,5626,368,926301,,42 07E 331735136,893 371,504 6,406,565
<br />0 240,92Less:
<br />Uses of Funds:
<br />Central Fund -Wide Charges
<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 />Projected Turnback
<br />Subtotal- Fund Operating Expenditures
<br />4,436,937 3,536,783 3,986,981 4,285,980 4,575,220 4,771,470 4,995,830 5,210,280 5,429,730 5,663,280 5,894,583 6,071,420 6,253,563 6,441,170 6,634,405 6,833,437 7,038,440 7,249,593 7,467,081 7,691,094 7,921,826 8,159,481 8,404,266 8,656,394 8,916,085 156,525,330
<br />129,031 93,383 16,060 - 2,023 2,024 2,025 2,026 2,027 2,028 - - - - - - - - - - - - - - - 250,627
<br />211,265 30,294 191,342 107,000 1,084,777 1,059,476 213,975 174,574 159,973 159,972 - - - - - - - - - - - - - - - 3,392,638
<br />- - - - - - - - - - 658,629 244,145 781,953 - 529,742 - 327,488 731,391 854,876 - 632.540 - 1,121,817 407,760 353,394 6,643,735
<br />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 6,557,133
<br />Actual/Estimated Capital Expenditures from Budget and LTFP (FF&E)
<br />Actual/Estimated Capital Expenditures from Budget and LTFP (Non-FF&E)
<br />FF&E Expenditures (from preceding schedule)
<br />Average Annual Building R&R Expense (from preceding schedule)
<br />Total Uses of Fundr
<br />4,777,224 3,660,460 4,194,382 4,392,980 5,662,020 5,832,970 5,211,830 5,386,880 5,591,730 5,825,280 6,905,767 6,678,696 7,409,541 6,826,416 7,560,950 7,242,145 7,786,897 8,414,582 8,768,562 8,151,097 9,028,170 8,647,499 10,028,742 9,581,892 9,802,750 173,369,463
<br />1,081,630 287,496 767,583 615,930 (489,430) (472,980) 318,670 309,530 281,950 227,030 (671,887) (257,801) (796,019) 14,488 (544,664) (15,370) (343,319) (747,697) (871,671) 117,299) (650,358) (18,352) (1,140,720) (427,230) (373,449) (3,962,914)
<br />Annual Net Surplus/(Deficit) of Fund,
<br />Cumulative Net Surplus/(Deficit) of Funds
<br />1,081,630 1,369,125 2,136,708 2,752,638 2,263,208 1,790,228 2,108,898 2,418,428 2,700,378 2,927,408 2,255,521 1,997,720 1,201,702 1,187,214 642,550 627,180 283,861 (463,836) (1,335,527) (1,352,806) (2,003,163) (2,021,516) (3,162,236) (3,589,466) (3,962,914)
<br />- 1,081,630 1,369,125 2,136,708 2,752,638 2,263,208 1,790,228 2,108,898 2,418,428 2,700,378 2,927,408 2,255,521 1,997,720 1,201,702 1,187,214 642,550 627,180 283,861 (463'836) (1,335,507) (1,352,806) (2,003,163) (2,021,516) (3,162,236) (3,589,466)
<br />1,081,630 287,496 767,583 615,930 489,430) 472,980 318,670 309,530 281,950 227,030 671,887) 257,801 796,019) (14,488) (544,664) 15,370) 343,319) (747,697 871,671) (17,299) (650,358) 18,352 (1,140,720) (427,230) (373,449
<br />Beginning Fund Balance - Recreation Fund
<br />Net of Fund Operating Revenue and Operating Expenditures
<br />Ending Fund Balance - Recreation Fun(
<br />1,081,630 1,369,125 2,136,708 2,752,638 2,263,208 1,790,228 2,108,898 2,418,428 2,700,378 2,927,408 2,255,521 1,997,720 1,201,702 1,187,214 642,550 627,180 283,861 (463,836) (1,335,507) (1,352,806) (2,003,163) (2,021,516) (3,162,236) (3,589,466) (3,962,914)
<br />Targeted Renewal & Replacement Reservr
<br />391,009 839,074 1,382,971 1,959,726 2,563,503 3,185,453 3,826,121 4,486,069 5,165,876 5,866,136 5,578,309 5,716,091 5,327,522 5,732,708 5,620,307 6,050,169 6,165,438 5,890,087 5,504,933 5,988,746 5,854,534 6,367,811 5,774,669 5,911,445 6,118,922
<br />Actuals
<br />From Budget &Long -Term Financial Plar
<br />(Calculated in Worksheet Using Assumptions Shown Abov I I I I I I
<br />9/75
<br />
|