Loading...
HomeMy WebLinkAboutWestlake Academy additional documentsPROJECTED WESTLAKE ACADEMY STUDENT CENSUS - FY 2012 -2013 Primary Secondary Boundaries Revised 8/2711 Westlake Carroll Keller Northwest Other Siblings Due to School Due to Town VR moved to Westlake Residents by neighborhood Stage- Estates Paige - coach of Mahotea brook Residents ISD ISO ISD Districts on Wait List Employee Employee )ec. Boundar Grade Total No. of % of No. of %of No. of % of No. of %of No. of %of No. of %of No. of % of No. of %of No. of %of Level Students Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Stud. Glenwyck Vaquero Hills Westlake Boone Farms Other K 45 23 51% 11 24% 25 56% 3 7% 6 13% 1 2% 3 7% 0 0% 0 6 6 3 2 0 0 6 G1 38 19 50% 8 21% 21 55% 7 18% 2 5% 3 8% 4 11% 0 0% 0 6 8 1 1 1 0 2 G2 46 16 35% 7 15% 29 63% 5 11% 5 11% 3 7% 3 7% 1 2% 4 4 6 0 4 0 0 2 G3 46 22 48% 11 24% 24 52% 8 17% 3 7% 15 33% 2 4% 1 2% 0 11 5 3 0 2 0 1 G4 52 19 37% 6 12% 33 63% 5 10% 8 15% 8 15% 6 12% 2 4% 2 3 11 0 2 0 0 3 G5 43 13 30% 7 16% 27 63% 5 12% 4 9% 13 30% 7 16% 1 2% 1 5 4 1 1 0 0 2 G6 60 21 35% 11 18% 36 60% 10 17% 3 5% 2 3% 3 5% 0 0% 0 8 8 0 1 1 0 3 G7 60 19 32% 8 13% 41 68% 8 13% 3 5% 10 17% 7 12% 1 2% 2 4 9 1 1 2 0 2 G8 60 19 32% 8 13% 40 67% 9 15% 3 5% 2 3% 1 2% 0 0% 1 4 9 1 1 3 0 1 G9 62 16 26% 10 16% 43 69% 5 8% 4 6% 1 2% 2 3% 1 2% 0 5 7 2 0 2 0 0 G10 56 11 20% 13 23% 39 70% 2 4% 2 4% 1 2% 2 4% 0 0% 0 6 2 0 0 0 0 3 G11 61 10 16% 7 11% 40 66% 9 15% 5 8% 0 0% 2 3% 0 0% 1 2 5 1 1 0 0 1 G12 41 8 20% 5 12% 26 63% 8 20% 2 5% 0 0% 0 0% 0 0% 2 0 4 1 1 1 0 1 Totals 670 216 32% 112 17% 424 63% 84 13% 50 7% 59 9% 42 6% 7 1% 13 64 84 14 15 12 0 27 8/27/2012 Income Statement - Option 2 Hybrid C 3 Sections Whole School (20 Students PYP / 23 Students MYP /DP) Fiscal Year Audited FY 10 /11 Estimated 11/12 Proposed 12/13 2013/14 2014115 2015/16 2016/17 GENERAL FUND BEG. BALANCE $ 767,490 $ 914,660 $ 657,994 $ 686,484 $ 681,210 $ 865,553 $ 1,136,107 REVENUES Local Revenues WAF Salary Reimbursement 65,003 31,662 54,594 55,685 57,356 59,076 60,849 Gifts & Donations - WAF - - - - - - Other Local Revenue 28,035 58,000 28,000 59,740 61,532 63,378 65,280 WAF Blacksmith 524,038 680,000 720,000 720,000 872,966 888,300 898,631 Interest Earned 2,295 1,278 2,500 1,316 1,355 1,396 1,438 Food Services 2,000 3,000 3,000 3,090 3,183 3,278 3,377 Donations 3,950 - 303,700 300,000 300,000 300,000 300,000 Athletic Activities 49,198 35,922 33,500 39.000 40,170 41,375 42,616 Transportation /Parking 7,996 23,250 35,000 35,700 36,771 37,874 39,010 Total Local Revenues 682,515 833,112 1,180,294 1,214,531 1,373,332 1,394,677 1,411,201 State Revenue TEA - FSP Funds 3,744,757 4,133,603 4,260,809 4,260,809 5,132,236 5,379,057 5,441,620 TRS On- behalf/Medicare Part B 181,301 234,803 227,452 268.517 344,743 355,012 365,588 Total State Revenues 3,926,058 4,368,406 4,488,261 4,529,326 5,476,979 5,734,069 5,807,209 TOTAL REVENUES 4,608,573 5,201,518 5,668,555 5,743,857 6,850,311 7,128,746 7,218,409 EXPENDITURES Object Code 61 X - Salaries 3,292,938 3,913,390 4,387,525 4,475,275 5,396,426 5,541,699 5,691,320 Object Code 62XX - Prof. Contracted Services 791,907 1,056,202 719,490 733,880 1,013,501 1,043,906 1,075,224 Object Code 63XX - Supplies & Materials 221,871 223,211 240,936 244,550 251,887 259,443 267,226 Object Code 64XX - Other Operating Costs 211,391 195,954 279,274 282,067 290,529 299,245 308,222 Object Code 65XX - Debt Service - - - - - - Object Code 66XX - Capital Assets - - - - - TOTAL EXPENDITURES 4,518,107 5,388,757 5,627,225 5,735,772 6,952,343 7,1449293 7,341,992 OTHER RESOURCES/USES Other Resources 104,844 44,823 38,460 39,230 40,014 - Other Resources - - - 300,000 300,000 300,000 Other Resources (Water Damage) 659,704 - - - - - - Sub -Total Other Resources 659,704 104,844 44,823 38,460 339,230 340,014 300,000 Extraordinary Item (Water Damage) (603,000) (49,807) Other Uses (124,464) (57,663) (51,819) (52,856) (53,913) - Sub -Total Other Uses (603,000) (174,271) (57,663) (51,819) (52,856) (53,913) Excess Revenues Over (Under) Expenditures 147,170 (256,666) 28,490 (5,274) 184,342 270,554 176,417 GENERAL FUND ENDING BALANCE 914,660 657,994 686,484 681,210 865,553 1,136,107 1,312,524 Assigned - Technology/FFE 100,000 - - - - - - Assigned - Uniform /Equipment Replacement 15,810 3,684 - 14,838 14,838 14,838 14,838 Assigned - Facility Maintenance /FFE - - ENDING FUND BALANCE 798,850 654,310 686,484 666,372 850,715 1,121,269 1,297,686 # of Operating Days (based on 365) 65 44 45 42 45 57 65 Students Enrolled Primary 296 308 334 321 399 399 399 Secondary 222 313 330 338 395 409 418 Total Students Enrolled 518 621 664 659 794 808 817 Teaching Staff' Primary 21.9 21.9 21.23 21.23 32.16 32.16 32.16 Secondary 17.75 20.14 22.7 22.7 22.16 22.16 22.16 Total Teaching Staff 39.65 42.04 43.93 43.93 54.32 54.32 54.32 8/27/2012 Primary Boundary Analysis by Cohort 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Class of 2010 5 6 6 7 8 3 2 Class of 2011 6 10 10 12 15 9 8 7 Class of 2012 5 9 12 11 12 3 2 2 2 Class of 2013 5 7 11 13 11 6 9 8 8 8 Class of 2014 5 10 17 19 18 13 10 10 11 10 Class of 2015 13 16 23 20 16 13 15 14 11 11 Class of 2016 7 18 19 19 12 16 12 12 16 Class of 2017 9 15 20 25 17 18 14 15 19 Class of 2018 29 32 25 15 19 21 19 19 Class of 2019 19 23 20 20 17 17 21 Class of 2020 19 7 10 9 10 13 Class of 2021 10 11 11 12 19 Class of 2022 25 18 19 22 Class of 2023 10 13 16 Class of 2024 15 19 Class of 2025 23 39 74 141 172 191 128 165 153 164 216 PYP 39 68 125 142 145 94 119 100 105 133 MYP 0 6 16 30 46 31 36 44 49 65 DP 0 0 0 0 0 3 10 9 10 18 GK G1 G2 G3 GK Total Attendance 159 G4 G1 154 G5 G2 G3 158 157 G6 G4 G5 148 143 G7 G6 G7 145 110 G8 G8 G9 90 67 G9 G10 50 G10 G11 G12 31 19 G11 G12 1 2 3 4 5 6 7 8 9 10 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 TOWN OF WESTLAKE TEN YEAR FORECAST All Municipal Funds 8/27/12 11:28 AM 8/27/201, 2:45 PN Revision 5 DESCRIPTION ADOPTED I ESTIMATED , , ' 10 FY -111 FY 1 12 FY 13 -14 FY 14-15 FY 15-16 FY 16 -17 FY 17 -18 FY 18-19 FY 19-20 FY 20-21 FY 1 -22 FY 22 -23 GENERAL FUND 00 Sales Tax (ongoing 100% minus one time) 3.0% 4,609,625 2,712,500 3,450,000 3,360,000 3,460,800 3,564,624 3,671,563 3,781,710 3,895,161 4,012,016 4,132,376 4,256,347 4,384,038 4,515,559 Sales Tax (audit /one -time) 0.0% 0 37,500 350,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Sales Tax Allocation to 413 (2,436,973) (687,500) (950,000) (890,000) (915,200) (941,156) (967,891) (995,427) (1,023,790) (1,053,004) (1,083,094) (1,114,087) (1,146,009) (1,178,890) Sales Tax Allocation to ED 3.0% (670,632) 0 (205,000) (180,000) (185,400) (190,962) (196,691) (202,592) (208,669) (214,929) (221,377) (228,019) (234,859) (241,905) Sales Tax Subtotal 1,502,019 2,062,500 2,645,000 2,490,000 2,560,200 2,632,506 2,706,981 2,783,691 2,862,701 2,944,082 3,027,905 3,114,242 3,203,169 3,294,764 Property Tax 2.0% 1,226,689 1,156,842 1,262,053 1,176,011 1,199,531 1,223,522 1,247,992 1,272,952 1,298,411 1,324,379 1,350,867 1,377,884 1,405,442 1,433,551 Property Tax (Fidelity abatement ends) 125,647 125,647 125,647 Property Tax (Deloitte abatement ends 22/23) Property Tax Subtotal 1,226,689 1,156,842 1,262,053 1,176,011 1,199,531 1,223,522 1,247,992 1,272,952 1,298,411 1,324,379 1,350,867 1,503,531 1,531,089 1,559,198 Beverage Tax 2.0% 19,721 17,750 32,750 35,000 35,700 36,414 37,142 37,885 38,643 39,416 40,204 41,008 41,828 42,665 Franchise Fees 2.0% 586,836 582,550 664,925 649,200 662,184 675,428 688,936 702,715 716,769 731,105 745,727 760,641 775,854 791,371 Permits and Fees 2.0% 520,645 480,890 462,350 436,000 444,720 453,614 462,687 471,940 481,379 491,007 500,827 510,843 521,060 531,482 Fines & Forfeitures 2.0% 605,705 536,611 640,000 560,000 571,200 582,624 594,276 606,162 618,285 630,651 643,264 656,129 669,251 682,636 Interest 2.0% 10,408 15,035 13,470 13,595 13,867 14,144 14,427 14,716 15,010 15,310 15,616 15,929 16,247 16,572 Misc Income 2.0% 96,079 52,700 63,929 51,277 52,303 53,349 54,416 55,504 56,614 57,746 58,901 60,079 61,281 62,506 Contributions 0.0% 175,000 304,100 325,000 0 0 0 0 0 0 0 0 0 0 0 Other Sources 0.0% 57,000 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Revenues 2,071,394 1,989,636 2,202,424 1,745,072 1,779,973 1,815,573 1,851,884 1,888,922 1,926,700 1,965,234 2,004,539 2,044,630 2,085,522 2,127,233 Transfer In - OF 500 Impact linked 145,216 30,000 37,500 37,500 38,250 39,015 39,795 40,591 41,403 42,231 43,076 43,937 44,816 45,712 Transfer In - OF (Interfund loan payment on $2M) 500,000 500,000 500,000 500,000 - - - - - - Transfer In - VA 220 Dept 22 3.0% 262 8,350 8,350 9,019 9,290 9,568 9,855 10,151 10,455 10,769 11,092 11,425 11,768 12,121 Transfer In - A &S 411 0.0% 4,515 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer In - LS 418 0.0% 102 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer In - ED 210 0.0% 153 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer in - CP 410 0.0% 139 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer In - 4B 200 0.0% 112 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer In - PTR 260 0.0% 1,357,548 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfers In 1,508,045 38,350 45,850 46,519 547,540 548,583 549,651 550,742 51,859 53,000 54,168 55,362 56,584 57,833 Total Revenues & Transfers In 6,308,147 5,247,328 6,155,327 5,457,602 6,087,244 6,220,184 6,356,508 6,496,307 6,139,671 6,286,696 6,437,478 6,717,765 6,876,364 7,039,028 Payroll Salaries 2.0% (1,832,512) (1,993,764) (1,997,629) (1,956,805) (2,097,941) (2,257,200) (2,302,344) (2,348,391) (2,395,359) (2,443,266) (2,492,131) (2,541,974) (2,592,813) (2,644,669) Payroll Market Increases (Inc. taxes, etc) 2.0% (100,000) (115,000) Payrolllnsurance/Taxes 1.0% (565,657) (633,278) (630,988) (660,928) (667,537) (674,213) (680,955) (687,764) (694,642) (701,588) (708,604) (715,690) (722,847) (730,076) Payroll Transfers In 2.0% 356,026 0 507,033 536,077 546,799 557,735 568,889 580,267 591,872 603,710 615,784 628,100 640,662 653,475 Transfer In - VA 220 Payroll 0.0% 0 254,668 0 0 0 0 0 0 0 0 0 0 0 0 Transfer In - OF 500 Payroll 0.0% 0 252,365 0 0 0 0 0 0 0 0 0 0 0 0 Operating Expenditures 3.0% (1,981,201) (2,182,621) (2,232,505) (2,149,025) (2,213,496) (2,279,901) (2,348,298) (2,418,747) (2,491,309) (2,566,048) (2,643,030) (2,722,321) (2,803,990) (2,888,110) Expenditures (4,023,344) (4,302,630) (4,354,089) (4,330,681) (4,547,176) (4,653,579) (4,762,707) (4,874,635) (4,989,437) (5,107,193) (5,227,981) (5,351,885) (5,478,989) (5,609,380) Transfer Out- ED 210 Ends FY2 0.0% (35,758) (35,758) (35,758) (35,758) (35,758) (35,758) (35,758) 0 0 0 0 0 0 0 Transfer Out - CP 410 0 (2,085,659) 0 (35,000) 0 0 (206,618) 0 0 0 0 0 0 0 0 Transfer Out- DS (Unfunded Road projects $3M (75K /$1M) 0 0 (106,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) Transfer Out - DS (Bldg bond pymt $57K/$1M) $8.5M (242,250) (484,500) (484,500) (484,500) (484,500) (484,500) (484,500) (484,500) (484,500) (484,500) Transfer Out - FM 252 0.0% (1,875) 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer Out - VE 257 0.0% (68,982) 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer Out- GMR 600 fixed (500,000) (530,000) (530,000) (550,000) (550,000) (300,000) (450,000) (150,000) (150,000) (150,000) (150,000) (150,000) (150,000) (150,000) Transfer Out- Academy shortfall 0 0 (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) (300,000) Transfer Out - VA (Debt forA &S Center) linked 0 0 0 (182,424) (182,916) (183,212) (183,312) (183,216) (182,924) (182,436) (181,752) Transfer Out - OF (CO pymt for storage tank) 0 0 0 (2,000,000) - - Transfer Out- DS 300 linked 0 (601,178) (309,371) (419,808) (319,847) (293,463) (265,462) (239,766) (215,999) (182,854) (151,472) (181,825) (149,674) (114,452) Transfers Out (2,692,274) (1,166,936) (910,129) (3,005,566) (1,147,855) (1,620,339) (1,824,144) (1,582,182) (1,558,711) (1,525,666) (1,494,188) (1,524,249) (1,491,610) (1,455,704) Total Expenditures & Transfers Out (6,715,618) (5,469,566) (5,264,218) (7,336,247) (5,695,031) (6,273,918) (6,586,851) (6,456,817) (6,548,149) (6,632,859) (6,722,170) (6,876,134) (6,970,599) (7,065,084) NET R&TI Over(Under) O 1188= i is i Beginning Fund Balance 3,731,332 3,323,861 3,323,861 4,214,970 2,336,324 2,728,537 2,674,803 2,444,459 2,483,949 2,075,471 1,729,308 1,444,617 1,286,247 1,192,013 Ending Fund Balance 3,323,861 3,101,622 4,214,970 2,336,324 2,728,537 2,674,803 2,444,459 2,483,949 2,075,471 1,729,308 1,444,617 1,286,247 1,192,013 1,165,956 Restricted /Committed /Assigned Prog Sun 2.0% 406,464 197,800 262,218 256,345 261,472 266,701 272,035 277,476 283,026 288,686 294,460 300,349 306,356 312,483 Unassigned Ending Balance (projected) 2,917,397 2,903,822 3,952,752 2,079,979 2,467,065 2,408,101 2,172,424 2,206,473 1,792,445 1,440,622 1,150,157 985,898 885,657 853,473 Operating Days 262 215 307 159 175 161 138 139 111 88 69 58 51 49 Cost per operating day 17,688 18,795 19,251 19,719 20,201 20,696 21,205 21,728 22,265 22,818 8/27/201, 2:45 PN l Kindergarten 433 1st Grade 262 2nd Grade 234 3rd Grade 209 4th Grade 193 5th Grade 170 6th Grade 201 7th Grade 125 8th Grade 94 9th Grade 95 10th Grade 69 11th Grade 43 2128 08/27/2012 Does this meet the Town Does this require an increase Does this fit within our current' Does this provide additional Does this provide additional educational ! Operating Cost Implications Council direction? in property tax rates? debt capacity? space? programming? I 0 o No, not interested in No, can be completed with � Q n maintaining status quo. existing debt capacity. O Ln m I I I QJ o Yes, interested in looking at j No, can be completed with CL ) option. existing debt capacity. 00 v N � N Q .2 Yes, interested in looking at a n option. 0 7- 0 �I v No, can be completed with existing debt capacity. If enrollment is not increased o Yes, interested in looking at to 1,040, then property taxes Q o option. would need to be increased by O o $0.055. v I Yes, interested in looking at No, can be completed with CL 5. v, option. existing debt capacity. O = � r` a I Yes, this would require an estimated $2 -3 million debt issuance. Annual Debt Service $114K - $171K Yes, this would require an estimated $6 -8 million debt issuance. Annual Debt Service $324K - $456K Yes, this would require an estimated $8 million debt issuance. Annual Debt Service $456K Does this fit within our curren debt capacity? Yes, this would require an estimated $8.5 million debt issuance. Annual Debt Service $485K Yes, we would build a cafetorium, a G12 classroom building, and administrative space. Yes, provides space in PYP for PE, lunch, and theater arts. Secondary, limited, this option does not provide the number of students needed for new programming and the operating costs would need to be subsidized. Yes, provides space in PYP for PE, lunch, and New building operating costs are approximately $85,000 Yes, we would build a cafetorium, theater arts. a secondary building, science We must fill all 100 seats, and will still I — - - - -- - -- -- -- - - - -- - classrooms, a media center, Secondary, limited, this option does not provide have approximately $450,000 annual auditorium / performance hall, ! the number of students needed for new shortfall for operating expenses. and a field house. programming and the operating costs would need to be subsidized. Yes, provides space in PYP for PE, lunch, and theater arts. Yes, we would build a cafetorium- - - - - -- - -- - -- Depends on the Westlake fill rate for a secondary building, and field ! Secondary, limited, this option does not provide 1 100 new students, if maxed out, see house. the number of students needed for new I Option 2. programming and the operating costs would need to be subsidized. i Yes, we would build a cafetorium, Yes provides space in PYP for PE lunch and Regardless of whether the enrollment a secondary building science theater arts. reaches 1 040 or an increased property classrooms, a media center, an auditorium / performance hall, a field house, and specialized classrooms. Yes, we would build a cafetorium, a secondary building, a field house. The field house would be slightly larger to accommodate future growth; keeps 1,200 student option open. Secondary, limited, this option does not provide j tax covers additional debt service, the the number of students needed for new i Academy will have a net operating loss programming and the operating costs would need of approximately $450,000; this will increase if subjects are added. I to be subsidized. I Yes, provides space in PYP for PE, lunch, and theater arts. - -- - -- - - -- Depends on the Westlake fill rate for 100 new students, if maxed out, see Secondary, limited, this option would provide I Option 2. additional students, but operational costs would need to be subsidized.