Loading...
HomeMy WebLinkAboutHandoutsN 4.1 N � c � o +� 4- n. N 00 r` Yes, interested in looking at option. � a N Q � Yes, interested in o •� � v Q -0 N looking at option. O = C 00 v m ^ o v Yes, interested in Q looking at option. O Ln 4 CU N Co Yes, interested in 0 'E 0 a, C1. -0 N looking at option. O = C:) v r` 3 No, can be completed with existing debt capacity. No, can be completed with existing debt capacity. Yes, this would require a $6 -8 Yes, we would build a cafetorium, million debt issuance. a secondary building, a science building, media center, Annual Debt Service auditorium / performance hall, and $342K-$456K a field house. Yes, this would require a $8 million debt issuance. Yes, we would build a cafetorium, a secondary building, and field Annual Debt Service house. $456K If enrollment is not increased No, this would require an Yes, provides space in PYP for PE, lunch, and to 1040, then property additional $8 million debt Yes, we would build a cafetorium, 08/13/2012 issuance for a total of $16 a secondary school, a science increased by $0.055. million. ( building, a media center, an g, additional students, but operational costs would Does this meet the TC ' Does this require an Does this fit within our Does this provide Does this provide additional 1040, then property taxes ? direction? increase in property current debt capacity? additional space? p educational programming ? the number of students needed for new increased property taxes rates? to be subsidized. ! Yes, provides space in PYP for PE, lunch, and Yes, this would require a $2 -3 theater arts v -0 No not interested No, can be completed with million debt issuance. Yes, we would build a cafetorium, - - 0 +, in maintaining existing debt capacity. a G12 classroom building, and Secondary, limited, this option does not provide 0 N Status Quo. Annual Debt Service admin space. the number of students needed for new O � $114K - $171K programming and the operating costs would need to be subsidized. N 4.1 N � c � o +� 4- n. N 00 r` Yes, interested in looking at option. � a N Q � Yes, interested in o •� � v Q -0 N looking at option. O = C 00 v m ^ o v Yes, interested in Q looking at option. O Ln 4 CU N Co Yes, interested in 0 'E 0 a, C1. -0 N looking at option. O = C:) v r` 3 No, can be completed with existing debt capacity. No, can be completed with existing debt capacity. Yes, this would require a $6 -8 Yes, we would build a cafetorium, million debt issuance. a secondary building, a science building, media center, Annual Debt Service auditorium / performance hall, and $342K-$456K a field house. Yes, this would require a $8 million debt issuance. Yes, we would build a cafetorium, a secondary building, and field Annual Debt Service house. $456K If enrollment is not increased No, this would require an Yes, provides space in PYP for PE, lunch, and to 1040, then property additional $8 million debt Yes, we would build a cafetorium, taxes would need to be issuance for a total of $16 a secondary school, a science increased by $0.055. million. ( building, a media center, an g, additional students, but operational costs would Annual Debt Service auditorium / performance hall, a If enrollment is increased to $456K from Town, the balance field house, and specialized 1040, then property taxes from enrollment growth or classrooms. would remain unchanged. Secondary, limited, this option does not provide out, see Option 2. the number of students needed for new increased property taxes programming and the operating costs would need No, can be completed with existing debt capacity. I Yes, this would require a $8.5 million debt issuance. Annual Debt Service $485K Yes, we would build a cafetorium, a secondary school, and field house. The field house would be built slightly larger to accommodate future growth; keeps 1,200 student option open. Yes, provides space in PYP for PE, lunch, and theater arts Secondary, limited, this option does not provide the number of students needed for nE!w programming and the operating costs would need to be subsidized. 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. Operating Cost Implications New building operating costs are approximately $85,000 We must fill all 100 seats, and will still have approximately a $300,000 annual shortfall for operating expenses. Depends on the Westlake fill rate for 100 new students, if maxed out, see Option 2. Regardless of whether the Yes, provides space in PYP for PE, lunch, and enrollment reaches 1040 or an theater arts increased property tax covers the additional debt service, the Academy will have a net operating Secondary, limited, this option would provide loss of approximately $300,000; additional students, but operational costs would this will increase if subjects need to be subsidized. are added. Yes, provides space in PYP for PE, lunch, and theater arts '. Depends on the Westlake fill rate for 100 new students, if maxed Secondary, limited, this option does not provide out, see Option 2. the number of students needed for new programming and the operating costs would need to be subsidized. - -- Enrollment Narratives -x Facility Acquisition , --- . ........... _. .... ....._.. - - -- - -- .... .... ............... ... . .... . ........ _ ... _ .... -- ... _... -- 14 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in F - - -- -- -- -- MYP /DP (6 -12). Cost approximately $12 million to build necessary Phase l facilities and will take 28 months from start to finish. Cost of High School Building, Middle expansion (debt service) is covered by the increased student !School Buildin, Media Center, enrollment. This model's revenues exceed expenditures, and the Cafetorium Fund Balance will build to approximately $210,040 over five years, I High School Building but does not meet the 45-Day Reserve Requirement. _ 4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in IF MYP /DP (7 -12). Cost approximately $12 million to build necessary 1 High School Building, Middle facilities and will take 28 months from start to finish. This model's 'School Buildin, Media Center, revenues are less then expenditures. This model's revenues exceed I Cafetorium, Primary School expenditures, and the Fund Balance will be depleted within three i 'Addition years. 5 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in MYP /DP (6 -12). Cost approximately $15 million to build necessary facilities and will take 28 months from start to finish. Cost of expansion (debt service) is covered by the increased student enrollment. This model's revenues exceed expenditures. The Fund Balance will build to approximately $2.1 million over five years I with approximately $812,000 undesignated. _. 5 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in MYP /DP (7 -12). Cost approximately $14 million to build necessary facilities and will take 28 months from start to finish. Cost of expansion (debt service) is covered by the increased student enrollment. This model's revenues exceed expenditures. The Fund Balance will build to approximately $250,000 over five years, but does not meet the 45 -Day Reserve Requirement. High School Building, Middle (School Building, Performance Hall, Cafetorium, Primary School Addition, Media Center i .... .... ...... _ ...... . - - ------ .... - -- - -- -- - High School Building, Middle ,School Buildin, Media Center, I Cafetorium, Primary School Addition 4 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in I MYP /DP (6-12). Cost approximately $12 million to build necessary i Phase l 'facilities and will take 37 months from start to finish. Cost of Middle School Building, Media expansion (debt service) is covered by the increased student j Center, Cafetorium enrollment. This model's revenues exceed expenditures. The Fund Phase 2 Balance will build to approximately $116,572 over five years, but High School Building does not meet the 45 -Day Reserve Requirement. _...... - . ... .._..... . _ ...... _.._ .- - -. -..— — - . -- — - -- —. ...._. -- ..... . _... -- 5 Sections of 20 students in PYP (K -5) & 4 Sections of 25 students in MYP /DP (6 -12). Cost approximately $13 million to build necessary facilities and will take 37 months from start to finish. Cost of j expansion (debt service) is covered by the increased student enrollment. This model's revenues exceed expenditures. The Fund Balance will be depleted within two years. _.._... — ..... ...... ... _ ......... Phase 1 Middle School Building, Media Center, Cafetorium Phase 2 1 High School Building, Primary ,School Addition 3 Sections of 20 students in PYP (K -6) & 3 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and Cafetorium, 6 new portable the Fund Balance will build to approximately $281,016 over the buildings j next five years, but does not meet the 45 -Day Reserve Requirement. 4 Sections of 20 students in PYP (K -6) & 4 Sections of 20 students in MYP /DP (7 -12). This model's revenues are less then expenditures, and the Fund Balance will be depleted within one year due to setup, FFE, and lease costs. i 4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and the Fund Balance will build to approximately $2.8 million over the next five years. 2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in MYP (7 -10), & 4 Sections of 24 students in DP. This model's revenues are less then expenditures, and the Fund Balance will be depleted within two years. Cafetorium, 12 new portable buildings Cafetorium, 12 new portable buildings ... - - -- ........ .. _ .... - .............. ---- ...... - - I Cafetorium, 4 new portable buildings I i 2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in MYP (7 -10), & 5 Sections of 24 students in DP. This model's Cafetorium, 5 new portable revenues are less then expenditures, and the Fund Balance will be buildings I depleted within three years. 2 Section of 20 students in PYP (K -6), 3 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and No additional facilities the Fund Balance will build to approximately $1.5 million over the 1 next five years with approximately $747,000 undesignated. I 4 Sections of 20 students in PYP (K -6) growing into 4 Sections of students in MYP /DP (7 -12) over the next 7 years. This model's Cafetorium, 9 new portable j revenues are less then expenditures, and the Fund Balance will be buildings I depleted within one year due to setup, FFE, and lease costs. ' I This is a combination of Option 6 -B and 7 -B. Will result in 4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in j Cafetorium, 12 new portable MYP /DP (7 -12). This model's revenues exceed expenditures, and n s the Fund Balance will build to approximately $2.1 million over the I 1 ! Cafetorium, g next five years with approximately $980,000 undesignated. 2 Sections of 20 students in PYP (K -6) & 3 Sections of 20 students in MYP /DP (7 -12). This model's revenues are less then expenditures, No additional facilities and the Fund Balance will be depleted within three years without changes to the revenues /expenditures. ! ----- - - -- ..— _......- -- ..__.._..._._..._.._._. _.� .._ _....__.._ _. _. -- .. ............ .... - ......... - i 3 Sections of 20 students in PYP (K -6) & 3 Sections of 20 students in MYP /DP (7 -12). This model's revenues are less then expenditures, Cafetorium, 6 new portable and the Fund Balance will be depleted within one year due to i buildings setup, FFE, and lease costs. ! I 3 Sections of 20 students in PYP (K -6) & 3 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and Cafetorium, 6 new portable the Fund Balance will build to approximately $281,016 over the buildings j next five years, but does not meet the 45 -Day Reserve Requirement. 4 Sections of 20 students in PYP (K -6) & 4 Sections of 20 students in MYP /DP (7 -12). This model's revenues are less then expenditures, and the Fund Balance will be depleted within one year due to setup, FFE, and lease costs. i 4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and the Fund Balance will build to approximately $2.8 million over the next five years. 2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in MYP (7 -10), & 4 Sections of 24 students in DP. This model's revenues are less then expenditures, and the Fund Balance will be depleted within two years. Cafetorium, 12 new portable buildings Cafetorium, 12 new portable buildings ... - - -- ........ .. _ .... - .............. ---- ...... - - I Cafetorium, 4 new portable buildings I i 2 Section of 20 students in PYP (K -6), 3 Sections of 20 students in MYP (7 -10), & 5 Sections of 24 students in DP. This model's Cafetorium, 5 new portable revenues are less then expenditures, and the Fund Balance will be buildings I depleted within three years. 2 Section of 20 students in PYP (K -6), 3 Sections of 25 students in MYP /DP (7 -12). This model's revenues exceed expenditures, and No additional facilities the Fund Balance will build to approximately $1.5 million over the 1 next five years with approximately $747,000 undesignated. I 4 Sections of 20 students in PYP (K -6) growing into 4 Sections of students in MYP /DP (7 -12) over the next 7 years. This model's Cafetorium, 9 new portable j revenues are less then expenditures, and the Fund Balance will be buildings I depleted within one year due to setup, FFE, and lease costs. ' I This is a combination of Option 6 -B and 7 -B. Will result in 4 Sections of 20 students in PYP (K -6) & 4 Sections of 25 students in j Cafetorium, 12 new portable MYP /DP (7 -12). This model's revenues exceed expenditures, and n s the Fund Balance will build to approximately $2.1 million over the I 1 ! Cafetorium, g next five years with approximately $980,000 undesignated. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 16 17 19 20 21 22 23 24 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 45 46 47 48 49 51 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 92 93 94 95 96 97 99 loc 101 104 10E 30E 11( 11: 11: 11z 11` Five Year Financial Forecast - FY 12/13 thru FY 16/17 Audited Adopted Estimate Proposed Projected Projected Projected Projected FY to /17. FY 7.7./12 FY 11/12 FY 12/13 Variance FY 13/14 FY 14/15 FY 15/16 FY 16/17 GENERAL FUND BEG. BALANCE $ 767,934 $ 916,962 $ 916,962 $ 683,309 $ (233,653) $ 691,088 $ 685,865 $ 544,996 $ 331,112 REVENUES Local Revenues WAF Salary Reimbursement 65,003 31,662 31,662 54,594 22,932 55,685.88 55,686 56,800 56,800 Other Local Revenue 28,035 15,000 58,000 28,000 (30,000) 59,740 28,840 61,532 29,705 WAF Blacksmith 524,038 627,000 680,000 720,000 40,000 720,000 720,000 720,000 720,000 WAF Contribution 303,700 300,000 300,000 300,000 300,000 Interest Earned 2,295 1,500 1,278 2,500 1,222 1,367 1,382 1,372 1,090 Food Services 2,000 3,000 3,000 3,000 - 3,090 3,183 3,278 3,377 Donations 3,950 - - - - - - - Athletic Activities 49,198 37,980 35,922 33,500 (2,422) 39,000 39,000 39,000 39,000 Transportation /Parking 7,996 37,840 23,250 35,000 11,750 35,700 36,414 37,142 37,885 Local Grant Revenue 191,691 85,430 405,573 101,640 (255,457) Total Local Revenues 874,206 839,412 1,238,685 1,281,934 (211,974) 1,214,582 1,184,505 1,219,124 1,187,856 Federal Revenue Federal Grant Revenues 157,445 150,844 163,919 69,239 (94,680) State Revenue TEA - FSPFunds 3,744,757 4,281,649 4,133,603 4,260,809 127,206 4,260,809 4,260,809 4,260,809 4,260,809 TRS On- behalf /Medicare Part B 181,301 208,437 234,803 227,452 (7,351) 268,517 273,887 279,365 284,952 State Grant Revenues 19,600 4,500 11,911 - (5,220) Total State Revenues 3,945,658 4,494,586 4,380,317 4,488,261 114,635 4,529,326 4,534,696 4,540,174 4,545,761 TOTAL REVENUES 4,977,309 5,484,842 5,782,921 5,839,434 (192,020) 5,743,908 5,719,201 5,759,298 5,733,617 EXPENDITURES by FUNCTION Function 11- Instructional 2,493,252 2,839,281 2,878,291 3,262,468 384,177 Function 12 - Resources & Media 73,398 90,134 82,929 140,756 57,827 Function 13 - Curriculum & Staff Development 49,351 87,800 30,367 80,600 50,233 Function 21- Instructional Leadership 121,795 131,742 137,013 127,812 (9,202) Function 23 - School Leadership 294,326 333,805 339,111 353,683 14,572 Function 31- Guidance & Counseling 165,245 220,628 233,373 234,011 638 Function 33 - Health Services 53,513 59,700 60,853 58,324 (2,529) Function 35 - Food Services 7,275 9,657 12,363 9,544 (2,819) Function 36 - Co /Extracurricular Activities 94,713 122,726 72,977 156,036 83,059 Function 41- Administrative 283,179 601,746 656,979 314,263 (342,716) Function 51- Maintenance & Operations 525,273 587,169 618,362 607,211 (11,151) Function 53- Data Processing 154,962 159,874 168,251 166,686 (1,565) Function 6l- Community Services 69,739 66,244 79,010 91,890 12,880 Function 71- Debt Service - - - - - Function 81- Facility Acquisition /Construction 132,086 23,940 18,878 23,940 5,062 TOTAL EXPENDITURES 4,518,107 5,334,446 5,388,757 5,627,225 238,467 - - EXPENDITURES by OBJECT Object Code 61XX - Salaries 3,292,938 3,772,080 3,913,390 4,387,525 474,134 4,475,275 4,564,781 4,656,076 4,749,198 Object Code 62XX - Prof. Contracted Services 791,907 962,025 1,056,202 719,490 (336,712) 733,880 748,557 763,529 778,799 Object Code 63XX - Supplies & Materials 221,871 258,447 223,211 240,936 17,725 244,550 248,218 251,942 255,721 Object Code 64XX - Other Operating Costs 211,391 341,894 195,954 279,274 83,320 282,067 284,887 287,736.28 290,614 Object Code 65XX - Debt Service - - - - - - - - - TOTAL EXPENDITURES 4,518,107 5,334,446 5,388,757 5,627,225 238,467 5,735,772 5,846,444 5,959,283 6,074,331 SPECIAL REVENUE FUNDS Federal Grants through TEA Fund 224 - IDEA B 85,134 61,541 72,544 69,239 (3,305) Fund 225 - IDEA B Preschool 175 - - Fund 266 SFSF (ARRA) 72,136 - Fund 287 - Education Jobs 89,303 91,375 - (91,375) Sub -total Federal Grants 157,445 150,844 163,919 69,239 (94,680) State Grants through TEA Fund 397 - Advanced Placement Incentive 4,500 4,500 5,220 - (5,220) Fund 404 - Student Success Initiative 2,200 Fund 410 - Material Allotment Disbursment 3,566 Fund 411- Technology 15,100 - Fund 429 - AP/113 Campus Awards 925 Sub -total State Grants 19,600 4,500 11,911 - (5,220) Local Activities Fund 461- Local Activity 12,617 12,000 31,143 30,000 Sub -total Local Activity 12,617 12,000 31,143 30,000 Hudson Foundation Grants Fund 481- Hudson Foundation 58,527 - - Fund 483 - Hudson Technology 22,500 - Fund 484 - Hudson Teacher Development 35,000 35,000 - (35,000) Fund 485 - Hudson Teacher Grant 200 10,000 10,000 10,000 Fund 486 - Hudson Ron Clark: Teacher Effectiveness 28,430 28,430 10,712 (17,718) Sub -total Hudson Foundation Grants 81,227 73,430 73,430 20,712 (52,718) Westlake Academy Foundation Grants Fund 482 - WAF Fund100 97,847 19,259 - (19,259) Fund 487 - WAF Technology for the Next Generation 100,000 (100,000) Fund 488 - WAF Support Mathematics Teacher 4,235 (4,235) Fund 489 - WAF Rosetta Stone 10,995 (10,995) Fund 490 - WAF Whole School Professional Development 36,980 (36,980) Fund 491- WAF Accept the Best, Nothing Lessl Phase 1 15,167 (15,167) Fund 492 - WAF Accept the Best, Nothing Lessl Phase II 26,742 36,000 9,258 Fund 493 - IB Learns Grant - 35,640 35,640 Fund 494 - WAF Library Fund -an -Item 61,000 - (61,000) Fund 495 - WAF Coop Tables Grant 26,622 Sub -total Foundation WA Grants 97,847 301,000 71,640 (202,738) TOTAL EXPENDITURES - ALLFUNDS 4,884,985 5,575,220 5,947,148 5,818,815 (116,889) 5,735,772 5,846,444 5,959,283 6,074,331 Excess Revenues Over(Under)Expenditures 92,324 (90,378) (164,226) 20,619 (75,131) 8,136 (127,243) (199,985) (340,714) OTHER RESOURCES (USES) Other Resources 659,704 36,967 104,844 44,823 (60,021) 38,460 39,230 40,014 40,014 Other Uses (603,000) (49,807) (49,807) (57,663) (7,856) (51,819) (52,856) (53,913) (53,913) Otheruses - Insurance - - (124,464) - 124,464 Net -Other Resources (Uses) 56,704 (12,840) (69,427) (12,840) 56,587 (13,359) (13,626) (13,898) (13,898) Excess Revenues Over(Under)Expenditures 149,028 (103,218) (233,653) 7,779 (18,544) (5,223) (140,869) (213,884) (354,612) GENERAL FUND ENDING BALANCE 916,962 813,744 683,309 691,088 7,779 685,865 544,996 331,112 (23,500) Assigned - Special Revenue Funds 20,712 Assigned - Technology /FFE Assigned - Uniform /Equipment Replacement 100,000 4,499 - 3,684 - 3,684 - - - (3,684) - 14,838 - 14,838 - 14,838 - 14,838 ENDING FUND BALANCE (Unassigned) 812,463 810,0601 658,913 1 691,088 1 4,095 671,027 530,158 316,274 (38,338) # of Operating Days (365) 66 55 45 45 6 43 33 19 (2) Fund Balance if including Indirect Operating Costs 812,463 810,060 658,913 384,188 77,288 (229,612) (536,512) (843,412) # of Operating Days if Including Indirect Operating Costs (365) 66 55 45 25 (2) 5 (14) (33) (51) Students Enrolled Primary Secondary 296 234 309 301 309 301 300 330 300 330 300 330 300 330 300 330 Total Students Enrolled 530 610 610 650 650 650 650 650