HomeMy WebLinkAboutDebbie's Five Year Forecast 08.10.10 633am
FY 10-11 FY 11-12 FY 12-13 FY 13-14 FY 14-15
General Fund Beginning Fund Balance 522,937$ 615,056$ 411,401$ 340,295$ 335,160$
REVENUES:
Local Revenue
Westlake Foundation reimbursement for Salary 64,858 64,858 64,858 64,858 64,858
WAF, WAAC, Grants, Scrip, Other Local Rev 12,000 12,000 12,240 12,485 12,734
Blacksmith Apprentice Program (75% FY 11-12 & future) 419,230 361,883 373,748 385,613 385,613
Interest Earned 1,500 1,500 1,530 1,561 1,592
Food Services 3,000 3,000 3,060 3,121 3,184
Athletic Activities 51,953 53,512 55,117 56,771 58,474
Transportation/Parking 32,840 15,900 18,860 18,860 18,860
Total Local Revenue 585,381 512,652 529,413 543,268 545,314
State Revenue
TEA Foundation funds 3,748,836 4,314,698 4,455,990 4,597,450 4,597,450
TRS On-behalf/Medicare Part B (Offset in Salary exp)195,795 199,711 203,705 207,780 211,935
TOTAL REVENUES 4,530,013 5,027,062 5,189,108 5,348,497 5,354,699
EXPENDITURES:
Object Code 61XX - Salaries 3,253,614 3,593,687 3,665,560 3,738,872 3,813,649
Object Code 62XX - Professional & Contracted Services 641,745 985,604 1,005,316 1,025,423 1,045,931
Object Code 63XX - Supplies & Materials 224,298 231,027 235,647 235,647 235,647
Object Code 64XX - Other Operating Costs 305,397 314,559 320,850 320,850 320,850
Object Code 65XX - Debt Service - 93,000 20,000 20,000 -
Object Code 66XX - Capital Assets 133,000
TOTAL EXPEDITURES 4,425,054 5,217,877 5,247,374 5,340,792 5,416,078
OTHER RESOURCES/USES
Other Resources 7,000 7,000 7,000 7,000 7,000
Other Resources (Setting up capital lease for portables)133,000
Transfers Out (19,840) (19,840) (19,840) (19,840) (19,840)
92,118 (203,655) (71,106) (5,134) (74,218)
ENDING FUND BALANCE 615,056 411,401 340,295 335,160 260,942
Assigned - Technology/FFE 100,000 100,000 100,000 100,000 100,000
Assigned - Uniform/Equipment Replacement 14,838 15,283 15,741 - -
ENDING FUND BALANCE (BASED ON 75% BSA donations)500,218$ 296,118$ 224,553$ 235,160$ 160,942$
$$ Per Operating Day 12,123$ 14,296$ 14,376$ 14,632$ 14,839$
# of Operating Days (based on 365) (75% BSA donations)41 21 16 16 11
ENDING FUND BALANCE (BASED ON 75% BSA donations)500,218$ 296,118$ 224,553$ 235,160$ 160,942$
Additional 25% Blacksmith Apprentice donations 120,628 124,583 128,538 128,538
ENDING FUND BALANCE (BASED ON 100% BSA donations)500,218$ 416,745$ 349,136$ 363,698$ 289,480$
# of Operating Days (based on 365) (100% BSA donations)41 29 24 25 20
ENDING FUND BALANCE (BASED ON 75% BSA donations)500,218$ (1,205,215)$ (2,655,643)$ (4,036,223)$ (5,480,310)$
Additional 25% Blacksmith Apprentice donations 120,628 124,583 128,538 128,538
Debt Service Payments 1,503,278 1,499,950 1,500,028 1,498,406 1,499,942
ENDING FUND BALANCE (BASED ON 100% BSA donations)(1,001,560)$ (2,584,537)$ (4,031,089)$ (5,406,092)$ (6,851,714)$
# of Operating Days (based on 365) (100% BSA donations)- - - - -
Key Assumptions:
A State Funding based on current FY 09-10 funding formula for all five years
B FY 11-12 and future years - Blacksmith Apprentice Program budgeted at 75%
C
D FY 11-12 - Added 3 portable buildings
E FY 11-12 - Approximately $325K added for indirect payroll costs of services performed by Town staff
F 3% increase in all other expenditures FY 11/12; 2% increase in all other expenditures FY 12/13, then held flat.
G 2% increase in Salary and Professional & Contracted Services each year.
H Assigned fund balance reflects the portion being held for equipment/uniform replacement as well as FF&E and technology equip.
Excess Revenues Over (Under) Expenditures
Fund Description
FIVE YEAR FORECAST
FY 11-12 - Includes four (5) new Secondary teachers and a third section in G7 - G10; G11 will grown to 3 sections in FY 12-13; G12 will
grow to 3 section in FY 13-14
WESTLAKE ACADEMY - GENERAL FUND