Loading...
HomeMy WebLinkAboutCOW 2011-04-11 Item 4 - Exhibits 1A-1B (8.5x14 Color Format) Revenue and Expenditures 20 year Projections TUKWILA POOL Exhibit #1 A Revised with "Bridge" Loan Metropolitan Park District ANNUAL ESTIMATED REVENUE 1% increase per year In fee revenue and 2% for Property Tax revenue 10 -Year 15 -Year 20 -Year 2009 2010 2011 2012 1 2013 1 2014 1 2015 1 2016 1 2017 1 2018 1 2019 1 2020 1 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 1 2031 j 1 PROGRAMS 1 %growth 146,710 I 164,8701 157,000 158,570 1 160,156 1 161,757 1 163,375 1 165,009 1 166,659 1 168,325 1 170,009 1 171,709 1 173,426 175,160 176,912 178,681 180,467 182,272 184,095 185,936 187,795 189,673 I 191,570 2 RENTALS 1 %growth 45,015 I 49,933.011 48,000 48,480 I 48,965 1 49,454 I 49,949 1 50,448 1 50,953 I 51,462 I 51,977 I 52,497 1 53,022 53,552 54,088 54,628 55,175 55,727 56,284 56,847 57,415 57,989 58,569 3 "BRIDGE" LOAN 18 I 592,838 I 309,106 1 I I I I S I I I 5 4 TAX REVENUE 0. ate %growth 442,2391 296,1821 323,169 776,240I 791,765 I 807,6001 823,752 I 840,227I 857,032 1 874,172 1 891,656 1 909,489I 927,679 946,232 965,157 984,460 1,004,149 1,024,232 1,044,717 1,065,611 1,086,923 1,108,662 1.130 5 TOTAL REVENUE 633,964 510,985 528,169 799,888 1,309,991 1,018,812 1,037,076 1,055,684 1,074,643 1,093,960 1,113,641 1,133,694 1,154,126 1,174,944 1,196,156 1,217,769 1,239,791 1,262,231 1,285,095 1,308,394 1,332,134 1,356,324 1 1,34974 6 CARRYOVER and RESERVES Re kedbAttual reawRw .a.. 5,000 492,857 468,359 432,655 384,912 323,708 248,671 351,683 438,895 509,251 561,071 593,773 588,144 578,917 482,763 494,306 480,079 323,062 252,664 I 20,221 2070 a h„neet ANNUAL ESTIMATED EXPENDITURES 4% increase per year 10 Year 15 Year 20 -Year OVERHEAD 2009 2010 2011 1 2012 1 2013 I 2014 1 2015 1 2016 1 2017 I 2018 I 2019 I 2020 1 2021 1 2022 1 2023 1 2024 1 2025 1 2026 1 2027 1 2028 1 2029 I 2030 1 V2i1 7 OVERHEAD 1 1 (5,000) 1 147,830 1 153,305 1 158,999 1 164,921 1 171,080 1 178,033 1 184,694 1 191,622 1 198,827 1 206,3201 214,688 1 222,793 1 231,222 1 239,988 249,1041 259,189 1 269,050 1 279,305 1 289,970 1 301,062 8 "BRIDGE" LOAN (3 %5 years) Total Expenditures- Program and Rental Fees 1 587;838 306,507 192,8411 192,8411 192,8411 192,8411 1 1 1 1 1 1 1 1 1 1 1 9 CIP RESERVE cure pde ReouQnrem 1 1 894,345 I 1 1 1 1 1 1 1 1 1 I 1 1 18,000 1 64,0001 1 1 115,500 1 1 331,500 10 DEMO $300K 4wEnereasenoyears 1 1 1 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,1821 34,182 1 34,182 1 34,182 1 34,182 1 ;4 ,182 11 BOND PAYMENT (see CIP Page) I I 1 773,0001 68,616 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 1 1 1 1 Total Overhead 1,667,345 i 250,628I 256,1031 454,6391 460,561 I 466,7201 473,672I 480,3341 294,4201 301,6251 309,118 317,486 I 325,591 I 352,020I 342,786 415,902 293,371 I 303,231 I 428,9861 324,151 466,743 Revised to Actual 010 ado8ted bndrel 4% increase per year based Qn 2011 odoeted bucfget OPERATIONS 2009 2010 2011 1 2012 1 2013 I 20(4 1 2015 1 2016 1 2017 1 2018 1 2019 1 2020 1 2021 1 2022 1 2023 1 2024 1 2025 1 2026 1 2027 1 2028 1 2029 1 2030 1 2W1 12 SALARIES WAGES 1 328,041 I 261,814I 292,892 1 299,572 1 311,555 1 324,017 1 336,978 1 350,457 1 364,475 1 379,054 1 394,216 1 409,985 1 426,384 1 443,440 1 461,177 1 479,624 1 498,8091 518,7621 539,512 1 561,093 1 583,536 1 606,878 I 631,153 13 PERSONNEL BENEFITS 1 124.259 1 85,732 1 77,985 81,104 1 84,349 1 87,723 1 91,231 1 94,881 1 98,676 1 102,623 1 106,728 1 110,997 1 115,437 1 120,054 1 124,856 1 129,851 1 135,0451 140,4471 146,064 1 151,907 1 157,983 1 164,303 1 170,875 14 SUPPLIES 1 11,124 1 14,694 I 14,468 15,047 1 15,649 1 16,275 1 16,926 1 17,603 1 18,307 1 19,039 1 19,800 1 20,592 1 21,416 1 22,273 1 23,164 1 24,090 1 25,054 1 26,056 1 27,098 1 28,182 1 29,310 1 30,482 1 31,701 15 OTHER SERVICES CHARGES 1 170,540 1 148,745 1 142,824 148,537 1 154,478 1 160,658 1 167,084 1 173,767 1 180,718 1 187,947 1 195,465 1 203,283 1 211,414 1 219,871 1 228,666 1 237,812 1 247,325 1 257,218 1 267,507 1 278,207 1 289,335 1 300,909 1 '312,945 Total Operations 633,964 510,985 1 528,169 544,260 566,030 588,672 612,219 636,707 662,176 688,663 716,209 744,858 774,652 1 805,638 1 837,863 1 871,378 1 906,233 1 942,482 1 5 980,182 1 1,019,389 1 1,060,164 1 1,102,571 1 1,146,674 16 TOTAL EXPENDITURES 633,964 510,985 528,169 I 794,888 822,134 1,043,311 1,072,779 1,103,427 1,135,848 1,168,996 1,010,629 1,046,483 1,083,770 1 1,123,124 I 1,163,454 I 1,223,398 I 1,249,019 I 1,358,385 I 1,273,552 I 1,322,620 I 1,489,151 I 1,426,722 1,613,417 SUMMARY 10 Year 15 Year 20 Year 5 TOTAL REVENUE 633,964 510,985 528,169 I 799,888 1,309,991 1,018,812 1,037,076 1,055,684 1,074,643 1,093,960 1,113,641 1,133,694 1,154,126 1,174,944 1,196,156 1,217,769 1,239,791 1,262,231 1,285,095 1,308,394 1,332,134 1,356,324 1,380,974 16 TOTAL EXPENDITURES 633,964 510,985 528,169 794,888 822,134 1,043,311 1,072,779 1,103,427 1,135,848 1,168,996 1,010,629 1,046,483 1,083,770 1,123,124 I 1,163,454 1,223,398 I 1,249,019 1 1,358,385 1 1,273,552 I 1,322,620 I 1,489,151 I 1,426,722 1 1,613,417 17 YEAR END BALANCE 0 I 5,000 487,858 (24,499) (35,704) (47,743) (61,205) (75,036) 103,012 87,212 70,3561 51,820 1 32,702 1 (5,629)1 (9,227)1 (96,154)1 11,543 1 (14,227)1 (157,017)1 (70,398)1 5 (232,443) W 1Admin6fra9on \CASWIPDIMPD EV 74 1 A COW 4-11 -11 REV 4 -2 -11 Revenue and Expenditures 20 year Projections TUKWILA POOL Exhibit #1 B Revised with "Bridge" Loan and 0% Pool Revenues Metropolitan Park District ANNUAL ESTIMATED REVENUE 1% increase per year in fee revenue and 2% for Property Tax revenue 10 -Year 15 -Year 20 -Year 2009 2010 1 2011 2012 1 2013 1 2014 1 2015 1 2016 1 2017 1 2018 1 2019 I 2020 1 2021 1 2022 2023 2024 2025 1 2026 2027 2028 2029 2030 2031 1 PROGRAMS i %0rowth 146,710 15 164,870 1 157,000 157,000 1 157,000 1 157,000 1 157,000 1 157,000 I 157,000 1 157,000 1 157,000 1 157,000 1 157,0001 157,000 157,000 157,000 157,0001 157,000 157,000 157,000 157,000 157,000 157000 2 RENTALS 1 %growth 45,015 1 5 49,933.0 48,000 48,000 1 48,000 1 48,000 1 48,000 1 48,000 1 48,000 1 48,000 1 48,000 I 48,000 1 48,000 1$ 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 404)00 3 "BRIDGE" LOAN I s I 5 592,838 I 309,106 1 I 1 5 1 5 1 I 1 I I is 4 TAX REVENUE 0.15 at 2% growth 442,239 15 296,182 1 323,169 776,240 1 791,765 I 807,600 1 823,752 I 840,227 1 857,032 I 874,172 1 891,656 I 909,489 1 927,679 1 946,232 965,157 984,460 1,004,149 1 1,024,232 1,044,717 5 1,065,611 1,086,923 1,108,662 )a3Q/B�l 5 TOTAL REVENUE 633,964 510,985 528,169 797,838 1,305,871 1,012,600 1,028,752 1,045,227 1,062,032 1,079,172 1,096,656 1,114,489 1,132,679 I 1,151,232 1,170,157 1,189,460 1,209,1491 f 1,229,232 1,249,717 1,270,611 1,291,923 1,313,662 1,335,835 6 CARRYOVER and RESERVES R" "°a oat ra.n.Rr `Y14 2,950 486,687 455,089 410,175 351,087 276,384 185,672 271,699 339,705 388,613 416,721 423,424 389,486 349,617 220,464 196,629 144,620 (52,608) (165,668) (443,250) mto a,ln03 l ANNUAL ESTIMATED EXPENDITURES 4% increase per year 10 Year 15 -Year 20 Year OVERHEAD 2009 2010 2011 2012 1 2013 1 2014 I 2015 1 2016 I 2017 1 2018 1 2019 1 2020 1 2021 1 2022 1 2023 1 2024 I 2025 1 2026 1 2027 1 2028 1 2029 1 2030 1 71131 7 OVERHEAD 1 1 (5,000) 1 147,830 1 153,305 1 158,999 1 164,921 I 171,080 1 178,033 1 184,694 1 191,622 1 198,827 1 206,3201 214,688 1 222,793 1 231,222 1 239,9881 249,1041 259,189 1 269,050 1_ 279,3 1 289,970 1 301 ,,,OW ar 8 "BRIDGE" LOAN 13%5 Total Expenditures Program and Rental Fees 1 589,8881 308,567 193,7291 193,7291 193,7291 193,7291 1 1 1 1 1 1 1 1 1 1 1 1 9 CIP RESERVE Me-Cycle Replacement 1 1 898,455' I 1 1 1 1 1 1 1 1 I 1 1 18,000 1 1 64,000 1 1 115,5001 I 10 DEMO $300K 4xlnrea :eno 1 1 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 1 34,182 I 34,1821 34,1821 34,182 1 34,182 1 34,182 1 34,182 1 34,18. 11 BOND PAYMENT (see CIP Page) 1 1 773,000 1 68,616 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 68,616 I 68,6161 68,6161 68,6161 68,6161 68,6161 68,6161 1 1 1 1 Total Overhead 1,671,455 j 250,6281 256,1031 455,5261 461,4481 467,6071 474,5601 481,2211 294,4201 301,6251 309,118 317,4861 325,5911 352,0201 342,786 415,902 293,3711 303,231 428,9861 324,151 466,743 Revised la Actual A1nevd 7 911 toto adopted 6"deet 4% inc`Qase per year based on 2011 adopted budget OPERATIONS 2009 2010 2011 I 2012 1 2013 1 2014 1 2015 1 2016 1 2017 1 2018 1 2019 1 2020 1 2021 1 2022 1 2023 1 2024 1 2025 2026 1 2027 1 2028 1 2029 1 2030 1 2031 12 SALARIES WAGES 1 328,041 1 261,8141 292,892 299,572 1 311,555 1 324,017 I 336,978 I 350,457 1 364,475 I 379,054 I 394,216 1 409,985 I 426,3841 443,440 I 461,177 I 479,624 I 498,8091 518,7621 539,512 I 561,093 I 583,536 I 606,878 1 631,153 13 PERSONNEL BENEFITS 1 124,259 1 85,732 77,98511 81,104 1 84,349 1 87,723 1 91,231 1 94,881 1 98,676 I 102,623 I 106,728 1 110,997 1 115,437 1 120,054 1 124,856 1 129,851 I 135,0451 140,4471 146,064 1 151,907 I 157,983 1 164,303 1 170,875 14 SUPPLIES 1 11,124 1 14,694 1 14,468 15,047 1 15,649 I 16,275 I 16,926 1 17,603 I 18,307 1 19,039 1 19,800 I 20,592 1 21,416 1 22,273 I 23,164 I 24,090 1 25,054 1 26,056 1 27,098 1 28,182 I 29,310 1 30,482 1 31.701 15 OTHER SERVICES CHARGES 1 170,540 1 148,745 1 142,824 148,537 1 154,478 1 160,658 1 167,084 1 173,767 1 180,718 1 187,947 1 195,465 1 203,283 1 211,414 1 219,871 1 228,666 1 237,812 1 247,325 1 257,218 1 267,507 1 278,207 1 289,335 1 300,909 1 312,a4S Total Operations 633,964 510,9851 528,169 544,260 566,030 588,672 612,219 636,707 662,176 688,663 716,209 744,858 774,6521 805,638 1 837,863 1 871,378 1 906,2331 942,482 is 980,182 1 1,019,389 1 5 1,060,164 1 1,102,571 1 1,146,6 16 TOTAL EXPENDITURES 633,964 510,985 528,169 1 794,888 822,134 1,044,198 1,073,667 1,104,314 1,136,735 1,169,884 1,010,629 1,046,483 1,083,770 1 1,123,124 1 1,163,454 I 1,223,398 1 1,249,019 I 1,358,385 1 1,273,552 I 1,322,620 1 1,489,151 1 1,;1, 1,613,417 SUMMARY 10 Year 15 Year 20 Year 5 TOTAL REVENUE 5 633,964 5 510,985 528,169 797,838 1,305,871 1,012,600 1,028,752 1,045,227 1,062,032 1,079,172 1,096,656 1,114,489 1,132,679 I 1,151,232 1,170,157 1,189,460 1,209,149 1,229,232 1,249,717 1,270,611 1,291,923 1,313,662 1,335,835 16 TOTAL EXPENDITURES 5 633,964 5 510,985 528,169 794,888 822,134 1,044,198 1,073,667 1,104,314 1,136,735 1,169,884 1,010,629 1,046,483 1,083,770 1,123,124 I 1,163,454 1,223,398 I 1,249,019 I 1,358,385 I 1,273,552 1,322,620 I 1,489,151 I 1,426,722 I 1,613,417 17 YEAR END BALANCE 0 I 2,950 483,737 (31,598) (44,915) (59,087) (74,704) (90,711) 86,026 68,006 48,908 28,108 1 6,703 1 (33,938)1 (39,870)1 5 (129,152)1 (23,836)1 (52,009)1 (197,227)1 (113,061)1 (277,582) W mdneniseatwmCAStMPD\MPD Exh51 8 COW 4 11 11 REV 4 11 4 437 PM