2017-2018 Final General Fund Budget AWS
Page 1
Page 2
Page 3
2017-2018 Final General Fund Budget LEA : 110141003
Validations
Bald Eagle Area SD
Printed 6/9/2017 7:53:14 AM Val Number 5120
Page - 1 of 1
Description
Justification
Expenditure Detail: Amounts must be entered for both 100 Salaries and 200 Benefits.
Budgeted amount for Employee Tuition Reimbursement. Due to Employees receiving no additional compensation, no salaries are recorded/budgeted within this Function, per PA Office of the Budget's September 1, 2016 Chart of Accounts.
Function 2800, Object 100: $0.00 Function 2800, Object 200: $20,000.00 . Provide a justification.
5320
Expenditure Detail: 100 Salaries amount must be greater than 200 Benefits amount. For an exception, please enter a justification below.
Budgeted amount for Employee Tuition Reimbursement. Due to Employees receiving no additional compensation, no salaries are recorded/budgeted within this Function, per PA Office of the Budget's September 1, 2016 Chart of Accounts.
Function 2800, Object 100: $0.00 Function 2800, Object 200: $20,000.00
5330
Expenditure Detail: 100 Salaries amount must be greater than 200 Benefits amount. For an exception, please enter a justification below.
Employee granted Spousal Coverage for Medical and Dental Insurance; therefore, District cost for Insurance and other employee benefits exceed employees salary.
Function 2900, Object 100: $21,720.00 Function 2900, Object 200: $28,649.00
8060
Ending Fund Balance Entry and Budgetary Reserve: If 5900 Budgetary Reserve is not equal to 0, a justification must be entered below.
Budgetary Reserve for unforeseen emergency expenditure requirements during the fiscal year.
8080
Ending Fund Balance Entry and Budgetary Reserve: If 0850 Estimated Ending Unassigned Fund Balance is not equal to 0, a justification must be entered below.
The Bald Eagle Area School District School Board believes in sound fiscal management, maintaining adequate working capital to be fiscally responsible and advantageous for the District and the District's Taxpayers.
8150
Ending Fund Balance Entry and Budgetary Reserve: If 0830 Committed Fund Balance is not equal to 0, a justification must be entered below.
Estimated Ending Committed Fund Balance consists of funds committed for increases in PSERS Employer Contributions and projected increases in Employer Medical Benefit Contributions.
8160
Ending Fund Balance Entry and Budgetary Reserve: If 0840 Assigned Fund Balance is not equal to 0, a justification must be entered below.
Estimated Ending Assigned Fund Balance consists of funds earmarked for future Capital Purchases, including but not limited to Bus Camera Systems and Athletic Complex Upgrades.
Page 4
Estimated Revenues and Other Financing Sources: Budget Summary
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD Page - 1 of 1
Printed 6/9/2017 7:53:15 AM ITEM
AMOUNTS
Estimated Beginning Unreserved Fund Balance Available for Appropriation and Reserves Scheduled For Liquidation During The Fiscal Year 0810 Nonspendable Fund Balance 0820 Restricted Fund Balance 0830 Committed Fund Balance
3,930,537
0840 Assigned Fund Balance
1,998,519
0850 Unassigned Fund Balance
2,560,673
Total Estimated Beginning Unreserved Fund Balance Available for Appropriation and Reserves Scheduled For Liquidation During The Fiscal Year
$8,489,729
Estimated Revenues And Other Financing Sources 6000 Revenue from Local Sources
15,784,511
7000 Revenue from State Sources
15,195,646
8000 Revenue from Federal Sources
256,000
9000 Other Financing Sources
500
Total Estimated Revenues And Other Financing Sources
$31,236,657
Total Estimated Fund Balance, Revenues, and Other Financing Sources Available for Appropriation
$39,726,386
Page 5
2017-2018 Final General Fund Budget LEA : 110141003
Estimated Revenues and Other Financing Sources: Detail
Bald Eagle Area SD
Printed 6/9/2017 7:53:16 AM
Page - 1 of 2 Amount
REVENUE FROM LOCAL SOURCES 6111 Current Real Estate Taxes
9,258,743
6112 Interim Real Estate Taxes
25,500
6113 Public Utility Realty Taxes
15,800
6114 Payments in Lieu of Current Taxes - State / Local
98,327
6120 Current Per Capita Taxes, Section 679 6130 Current Taxpayer Relief Taxes - Proportional Assessments 6140 Current Act 511 Taxes - Flat Rate Assessments 6150 Current Act 511 Taxes - Proportional Assessments 6400 Delinquencies on Taxes Levied / Assessed by the LEA
37,000 2,507,287 64,015 2,767,479 561,610
6500 Earnings on Investments
50,000
6700 Revenues from LEA Activities
46,000
6800 Revenues from Intermediary Sources / Pass-Through Funds 6910 Rentals
303,100 4,150
6920 Contributions and Donations from Private Sources
10,500
6990 Refunds and Other Miscellaneous Revenue
35,000
REVENUE FROM LOCAL SOURCES
$15,784,511
REVENUE FROM STATE SOURCES 7110 Basic Education Funding
8,103,462
7160 Tuition for Orphans Subsidy
52,000
7220 Vocational Education
50,765
7271 Special Education funds for School-Aged Pupils
1,249,309
7311 Pupil Transportation Subsidy
1,056,462
7312 Nonpublic and Charter School Pupil Transportation Subsidy 7320 Rental and Sinking Fund Payments / Building Reimbursement Subsidy 7330 Health Services (Medical, Dental, Nurse, Act 25)
15,592 941,528 30,000
7340 State Property Tax Reduction Allocation
732,135
7505 Ready to Learn Block Grant
310,813
7810 State Share of Social Security and Medicare Taxes
506,333
7820 State Share of Retirement Contributions REVENUE FROM STATE SOURCES REVENUE FROM FEDERAL SOURCES 8514 NCLB, Title I - Improving the Academic Achievement of the Disadvantaged 8515 NCLB, Title II - Preparing, Training and Recruiting High Quality Teachers and Principals
2,147,247 $15,195,646 190,000 65,000
Page 6
2017-2018 Final General Fund Budget LEA : 110141003
Estimated Revenues and Other Financing Sources: Detail
Bald Eagle Area SD
Printed 6/9/2017 7:53:16 AM
Page - 2 of 2 Amount
REVENUE FROM FEDERAL SOURCES 8820 Medical Assistance Reimbursement for Administrative Claiming (Quarterly) Program REVENUE FROM FEDERAL SOURCES OTHER FINANCING SOURCES 9400 Sale of or Compensation for Loss of Fixed Assets OTHER FINANCING SOURCES TOTAL ESTIMATED REVENUES AND OTHER SOURCES
1,000 $256,000 500 $500 31,236,657
Page 7
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 1 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
Rate
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Centre
Total
a. Assessed Value
$232,889,375
$232,889,375
b. Real Estate Mills
54.6300
2016-17 Data
I. 2017-18 Data c. 2015 STEB Market Value
$694,485,697
$694,485,697
d. Assessed Value
$233,076,615
$233,076,615
$0
$0
$12,722,747
$12,722,747
g. Percent of Total Market Value
100.00000%
100.00000%
h. Rebalanced 2016-17 Tax Levy
$12,722,747
$12,722,747
e. Assessed Value of New Constr/ Renov 2016-17 Calculations f. 2016-17 Tax Levy (a * b) 2017-18 Calculations II.
(f Total * g) i. Base Mills Subject to Index
54.6300
(h / a * 1000) if no reassessment (h / (d-e) * 1000) if reassessment Calculation of Tax Rates and Levies Generated j. Weighted Avg. Collection Percentage k. Tax Levy Needed
93.28948%
93.28948%
$13,164,167
$13,164,167
(Approx. Tax Levy * g)
l. 2017-18 Real Estate Tax Rate
56.4800
(k / d * 1000) III.
m. Tax Levy Generated by Mills
$13,164,167
$13,164,167
(l / 1000 * d) n. Tax Levy minus Tax Relief for Homestead Exclusions
$9,924,745
(m - Amount of Tax Relief for Homestead Exclusions) o. Net Tax Revenue Generated By Mills
$9,258,743
(n * Est. Pct. Collection)
Page 8
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 2 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
Rate
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Total
Centre Index Maximums p. Maximum Mills Based On Index
56.4874
(i * (1 + Index)) q. Mills In Excess of Index
0.0000
(if (l > p), (l - p)) r. Maximum Tax Levy Based On Index IV.
$13,165,892
$13,165,892
(p / 1000 * d) s. Millage Rate within Index?
Yes
(If l > p Then No) t. Tax Levy In Excess of Index
$0
$0
$0
$0
(if (m > r), (m - r)) u.Tax Revenue In Excess of Index (t * Est. Pct. Collection)
Information Related to Property Tax Relief Assessed Value Exclusion per Homestead V.
Number of Homestead/Farmstead Properties
$14,090 4131
4131
Median Assessed Value of Homestead Properties
$35,225
Page 9
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 3 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Rate
Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Total
Centre
Portion of Act 1 EIT Revenue Used for Tax Relief used for: Homestead Exclusions State Property Tax Reduction Allocation used for: Homestead Exclusions Prior Year State Property Tax Reduction Allocation used for: Homestead Exclusions
$2,507,287
Lowering RE Tax Rate
$0
$2,507,287
$732,135
Lowering RE Tax Rate
$0
$732,135
$0
Amount of Tax Relief from State/Local Sources
$0 $3,239,422
Page 10
2017-2018 Final General Fund Budget
Local Education Agency Tax Data
Bald Eagle Area SD
REAL ESTATE, PER CAPITA (SEC. 679), EIT/PIT (ACT 1), LOCAL ENABLING (ACT 511)
LEA : 110141003 Printed 6/9/2017 7:53:17 AM
Page - 1 of 1
CODE 6111 Current Real Estate Taxes County Name Taxable Assessed Value Centre
233,076,615
Totals:
233,076,615
Real Estate Mills
Amount of Tax Relief for Homestead Exclusions
Tax Levy Generated by Mills
56.4800
Tax Levy Minus Homestead Exclusions
13,164,167 13,164,167
Net Tax Revenue Generated By Mills
Percent Collected 93.28948%
-
3,239,422
=
9,924,745 X
93.28948%
Rate 6120
Current Per Capita Taxes, Section 679
6130
Current Taxpayer Relief Taxes – Proportional Assessments
6131
Current Act 1 Earned Income Taxes
6140
Total Current Taxpayer Relief Taxes – Proportional Assessments Current Act 511 Taxes – Flat Rate Assessments
Rate
6141
Current Act 511 Per Capita Taxes
6142
Current Act 511 Occupation Taxes – Flat Rate
6143
=
9,258,743
Estimated Revenue
$5.00
37,000
Rate
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
1.000%
0.000%
2,507,287
2,507,287
2,507,287
2,507,287
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
$5.00
$0.00
37,000
37,000
$0.00
$0.00
0
0
Current Act 511 Local Services Taxes
$5.00
$0.00
27,015
27,015
6144
Current Act 511 Trailer Taxes
$0.00
$0.00
0
0
6145
Current Act 511 Business Privilege Taxes – Flat Rate
$0.00
$0.00
0
0
6146
Current Act 511 Mechanical Device Taxes – Flat Rate
$0.00
$0.00
0
0
6149
Current Act 511 Taxes, Other Flat Rate Assessments
$0.00
$0.00
0
0
Total Current Act 511 Taxes – Flat Rate Assessments Current Act 511 Taxes – Proportional Assessments
64,015
64,015
6150
Rate
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
6151
Current Act 511 Earned Income Taxes
1.050%
0.000%
2,632,704
2,632,704
6152
Current Act 511 Occupation Taxes
0.000
0.000
0
0
6153
Current Act 511 Real Estate Transfer Taxes
0.500%
0.000%
134,775
134,775
6154
Current Act 511 Amusement Taxes
0.000%
0.000%
0
0
6155
Current Act 511 Business Privilege Taxes
6156
Current Act 511 Mechanical Device Taxes – Percentage
6157
Current Act 511 Mercantile Taxes
6159
Current Act 511 Taxes, Other Proportional Assessments
0.000
0.000
0
0
0.000%
0.000%
0
0
0.000
0.000
0
0
0
0
0
0
2,767,479
2,767,479
Total Current Act 511 Taxes – Proportional Assessments
Total Act 511, Current Taxes
2,831,494 Act 511 Tax Limit
-->
694,485,697 X Market Value
Page 11
12
8,333,828
Mills
(511 Limit)
Comparison of Tax Rate Changes to Index
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 1 Tax Rate Charged in:
Tax Functio n 6111
Description
2017-18
Less than or equal to Index
Index
Current Real Estate Taxes Centre
6120
2016-17 (Rebalanced)
Percent Change in Rate
Current Per Capita Taxes, Section 679
Current Taxpayer Relief Taxes – Proportional Assessments 6131 Current Act 1 Earned Income Taxes
54.6300
56.4800
3.39%
Yes
3.4%
$5.00
$5.00
0.00%
Yes
3.4%
1.000%
1.000%
0.00%
Yes
3.4%
Current Act 511 Taxes – Flat Rate Assessments 6141
Current Act 511 Per Capita Taxes
$5.00
$5.00
0.00%
Yes
3.4%
6143
Current Act 511 Local Services Taxes
$5.00
$5.00
0.00%
Yes
3.4%
Current Act 511 Taxes – Proportional Assessments 6151
Current Act 511 Earned Income Taxes
1.050%
1.050%
0.00%
Yes
3.4%
6153
Current Act 511 Real Estate Transfer Taxes
0.500%
0.500%
0.00%
Yes
3.4%
Page 12
Additional Tax Rate Charged in: 2017-18 2016-17 (Rebalanced)
Percent Change in Rate
Less than or equal to Index
Estimated Expenditures and Other Financing Uses: Budget Summary
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 1
Description
Amount
1000 Instruction 1100 1200 1300 1400
Regular Programs - Elementary / Secondary Special Programs - Elementary / Secondary Vocational Education Other Instructional Programs - Elementary / Secondary
11,683,351 3,858,272 2,147,322 406,547
Total Instruction
$18,095,492
2000 Support Services 2100 2200 2300 2400 2500 2600 2700 2800 2900
Support Services - Students Support Services - Instructional Staff Support Services - Administration Support Services - Pupil Health Support Services - Business Operation and Maintenance of Plant Services Student Transportation Services Support Services - Central Other Support Services
1,171,912 2,167,284 1,694,684 352,117 394,618 2,888,985 1,992,000 47,500 52,369
Total Support Services
$10,761,469
3000 Operation of Non-Instructional Services 3200 Student Activities 3300 Community Services
923,864 16,918
Total Operation of Non-Instructional Services
$940,782
5000 Other Expenditures and Financing Uses 5100 Debt Service / Other Expenditures and Financing Uses 5200 Interfund Transfers - Out 5900 Budgetary Reserve
2,343,568 400,000 200,000
Total Other Expenditures and Financing Uses
$2,943,568
Total Estimated Expenditures and Other Financing Uses
$32,741,311
Page 13
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 4
Description
Amount
1000 Instruction 1100 Regular Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 800 Other Objects
6,102,840 4,114,333 362,750 101,045 590,026 397,207 15,150
Total Regular Programs - Elementary / Secondary
$11,683,351
1200 Special Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
1,477,668 1,464,825 392,950 1,000 396,179 118,550 6,000 1,100
Total Special Programs - Elementary / Secondary
$3,858,272
1300 Vocational Education 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
344,175 239,336 500 1,476,011 56,150 25,000 6,150
Total Vocational Education
$2,147,322
1400 Other Instructional Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services 500 Other Purchased Services 600 Supplies
158,132 128,615 3,000 104,400 12,400
Total Other Instructional Programs - Elementary / Secondary
$406,547
Total Instruction
$18,095,492
2000 Support Services 2100 Support Services - Students 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services
Page 14
659,575 444,462 32,200 50 10,350
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 2 of 4
Description
Amount
600 Supplies 800 Other Objects
22,625 2,650
Total Support Services - Students
$1,171,912
2200 Support Services - Instructional Staff 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
639,861 613,423 101,650 11,200 106,335 354,515 338,000 2,300
Total Support Services - Instructional Staff
$2,167,284
2300 Support Services - Administration 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 800 Other Objects
894,304 538,240 99,850 1,500 72,240 47,950 40,600
Total Support Services - Administration
$1,694,684
2400 Support Services - Pupil Health 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
183,599 143,838 6,875 300 3,950 10,005 3,000 550
Total Support Services - Pupil Health
$352,117
2500 Support Services - Business 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
188,205 136,213 5,500 5,350 22,250 27,350 4,000 5,750
Total Support Services - Business 2600 Operation and Maintenance of Plant Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits
$394,618
Page 15
868,189 729,046
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 3 of 4
Description 300 400 500 600 700 800
Amount
Purchased Professional and Technical Services Purchased Property Services Other Purchased Services Supplies Property Other Objects
84,750 666,300 122,500 341,700 65,000 11,500
Total Operation and Maintenance of Plant Services
$2,888,985
2700 Student Transportation Services 300 Purchased Professional and Technical Services 500 Other Purchased Services 600 Supplies
3,000 1,984,500 4,500
Total Student Transportation Services
$1,992,000
2800 Support Services - Central 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 500 Other Purchased Services 800 Other Objects
20,000 17,500 9,500 500
Total Support Services - Central
$47,500
2900 Other Support Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services
21,720 28,649 2,000
Total Other Support Services
$52,369
Total Support Services
$10,761,469
3000 Operation of Non-Instructional Services 3200 Student Activities 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
460,000 190,675 103,000 9,500 50,700 77,893 11,996 20,100
Total Student Activities
$923,864
3300 Community Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services
7,020 2,898 7,000
Total Community Services
$16,918
Total Operation of Non-Instructional Services
$940,782
5000 Other Expenditures and Financing Uses 5100 Debt Service / Other Expenditures and Financing Uses
Page 16
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 4 of 4
Description
Amount
800 Other Objects 900 Other Uses of Funds
923,568 1,420,000
Total Debt Service / Other Expenditures and Financing Uses
$2,343,568
5200 Interfund Transfers - Out 900 Other Uses of Funds
400,000
Total Interfund Transfers - Out
$400,000
5900 Budgetary Reserve 800 Other Objects
200,000
Total Budgetary Reserve
$200,000
Total Other Expenditures and Financing Uses
$2,943,568
TOTAL EXPENDITURES
$32,741,311
Page 17
Schedule Of Cash And Investments (CAIN)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 1 of 2
Cash and Short-Term Investments General Fund
06/30/2017 Estimate
06/30/2018 Projection
8,905,954
8,555,954
2,987,414
2,995,914
126,700
127,250
3,500
4,000
$12,023,568
$11,683,118
06/30/2017 Estimate
06/30/2018 Projection
Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund Permanent Fund Total Cash and Short-Term Investments Long-Term Investments General Fund Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund
Page 18
Schedule Of Cash And Investments (CAIN)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 2 of 2
Long-Term Investments
06/30/2017 Estimate
06/30/2018 Projection
$12,023,568
$11,683,118
Permanent Fund Total Long-Term Investments TOTAL CASH AND INVESTMENTS
Page 19
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 1 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
20,525,000
19,035,000
674,655
709,655
413,837
633,328
General Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total General Fund Public Purpose (Expendable) Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable
Page 20
38,778,525
41,889,450
$60,392,017
$62,267,433
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 2 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
29,750
28,500
0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Capital Reserve Fund - § 1431 Other Capital Projects Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Capital Projects Fund Debt Service Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Debt Service Fund Food Service / Cafeteria Operations Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations
Page 21
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 3 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Food Service / Cafeteria Operations Fund Child Care Operations Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Child Care Operations Fund Other Enterprise Funds 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Enterprise Funds Internal Service Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Internal Service Fund Private Purpose Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Private Purpose Trust Fund
Page 22
1,406,475
1,295,550
$1,436,225
$1,324,050
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 4 of 6
Long-Term Indebtedness
06/30/2017 Estimate
Investment Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Investment Trust Fund Pension Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Pension Trust Fund Activity Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Activity Fund Other Agency Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Agency Fund Permanent Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable
Page 23
06/30/2018 Projection
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 5 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
$61,828,242
$63,591,483
0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Permanent Fund Total Long-Term Indebtedness
Page 24
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 6 of 6
Short-Term Payables General Fund
06/30/2017 Estimate
06/30/2018 Projection
1,420,000
1,490,000
$1,420,000
$1,490,000
$63,248,242
$65,081,483
Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund Permanent Fund Total Short-Term Payables TOTAL INDEBTEDNESS
Page 25
Fund Balance Summary (FBS)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:20 AM
Page - 1 of 1
Account Description
Amounts
0810 Nonspendable Fund Balance 0820 Restricted Fund Balance 0830 Committed Fund Balance
3,937,037
0840 Assigned Fund Balance
639,595
0850 Unassigned Fund Balance
2,408,443
Total Ending Fund Balance - Committed, Assigned, and Unassigned
$6,985,075
5900 Budgetary Reserve
200,000
Total Estimated Ending Committed, Assigned, and Unassigned Fund Balance and Budgetary Reserve
Page 26
$7,185,075
Page 2
Page 3
2017-2018 Final General Fund Budget LEA : 110141003
Validations
Bald Eagle Area SD
Printed 6/9/2017 7:53:14 AM Val Number 5120
Page - 1 of 1
Description
Justification
Expenditure Detail: Amounts must be entered for both 100 Salaries and 200 Benefits.
Budgeted amount for Employee Tuition Reimbursement. Due to Employees receiving no additional compensation, no salaries are recorded/budgeted within this Function, per PA Office of the Budget's September 1, 2016 Chart of Accounts.
Function 2800, Object 100: $0.00 Function 2800, Object 200: $20,000.00 . Provide a justification.
5320
Expenditure Detail: 100 Salaries amount must be greater than 200 Benefits amount. For an exception, please enter a justification below.
Budgeted amount for Employee Tuition Reimbursement. Due to Employees receiving no additional compensation, no salaries are recorded/budgeted within this Function, per PA Office of the Budget's September 1, 2016 Chart of Accounts.
Function 2800, Object 100: $0.00 Function 2800, Object 200: $20,000.00
5330
Expenditure Detail: 100 Salaries amount must be greater than 200 Benefits amount. For an exception, please enter a justification below.
Employee granted Spousal Coverage for Medical and Dental Insurance; therefore, District cost for Insurance and other employee benefits exceed employees salary.
Function 2900, Object 100: $21,720.00 Function 2900, Object 200: $28,649.00
8060
Ending Fund Balance Entry and Budgetary Reserve: If 5900 Budgetary Reserve is not equal to 0, a justification must be entered below.
Budgetary Reserve for unforeseen emergency expenditure requirements during the fiscal year.
8080
Ending Fund Balance Entry and Budgetary Reserve: If 0850 Estimated Ending Unassigned Fund Balance is not equal to 0, a justification must be entered below.
The Bald Eagle Area School District School Board believes in sound fiscal management, maintaining adequate working capital to be fiscally responsible and advantageous for the District and the District's Taxpayers.
8150
Ending Fund Balance Entry and Budgetary Reserve: If 0830 Committed Fund Balance is not equal to 0, a justification must be entered below.
Estimated Ending Committed Fund Balance consists of funds committed for increases in PSERS Employer Contributions and projected increases in Employer Medical Benefit Contributions.
8160
Ending Fund Balance Entry and Budgetary Reserve: If 0840 Assigned Fund Balance is not equal to 0, a justification must be entered below.
Estimated Ending Assigned Fund Balance consists of funds earmarked for future Capital Purchases, including but not limited to Bus Camera Systems and Athletic Complex Upgrades.
Page 4
Estimated Revenues and Other Financing Sources: Budget Summary
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD Page - 1 of 1
Printed 6/9/2017 7:53:15 AM ITEM
AMOUNTS
Estimated Beginning Unreserved Fund Balance Available for Appropriation and Reserves Scheduled For Liquidation During The Fiscal Year 0810 Nonspendable Fund Balance 0820 Restricted Fund Balance 0830 Committed Fund Balance
3,930,537
0840 Assigned Fund Balance
1,998,519
0850 Unassigned Fund Balance
2,560,673
Total Estimated Beginning Unreserved Fund Balance Available for Appropriation and Reserves Scheduled For Liquidation During The Fiscal Year
$8,489,729
Estimated Revenues And Other Financing Sources 6000 Revenue from Local Sources
15,784,511
7000 Revenue from State Sources
15,195,646
8000 Revenue from Federal Sources
256,000
9000 Other Financing Sources
500
Total Estimated Revenues And Other Financing Sources
$31,236,657
Total Estimated Fund Balance, Revenues, and Other Financing Sources Available for Appropriation
$39,726,386
Page 5
2017-2018 Final General Fund Budget LEA : 110141003
Estimated Revenues and Other Financing Sources: Detail
Bald Eagle Area SD
Printed 6/9/2017 7:53:16 AM
Page - 1 of 2 Amount
REVENUE FROM LOCAL SOURCES 6111 Current Real Estate Taxes
9,258,743
6112 Interim Real Estate Taxes
25,500
6113 Public Utility Realty Taxes
15,800
6114 Payments in Lieu of Current Taxes - State / Local
98,327
6120 Current Per Capita Taxes, Section 679 6130 Current Taxpayer Relief Taxes - Proportional Assessments 6140 Current Act 511 Taxes - Flat Rate Assessments 6150 Current Act 511 Taxes - Proportional Assessments 6400 Delinquencies on Taxes Levied / Assessed by the LEA
37,000 2,507,287 64,015 2,767,479 561,610
6500 Earnings on Investments
50,000
6700 Revenues from LEA Activities
46,000
6800 Revenues from Intermediary Sources / Pass-Through Funds 6910 Rentals
303,100 4,150
6920 Contributions and Donations from Private Sources
10,500
6990 Refunds and Other Miscellaneous Revenue
35,000
REVENUE FROM LOCAL SOURCES
$15,784,511
REVENUE FROM STATE SOURCES 7110 Basic Education Funding
8,103,462
7160 Tuition for Orphans Subsidy
52,000
7220 Vocational Education
50,765
7271 Special Education funds for School-Aged Pupils
1,249,309
7311 Pupil Transportation Subsidy
1,056,462
7312 Nonpublic and Charter School Pupil Transportation Subsidy 7320 Rental and Sinking Fund Payments / Building Reimbursement Subsidy 7330 Health Services (Medical, Dental, Nurse, Act 25)
15,592 941,528 30,000
7340 State Property Tax Reduction Allocation
732,135
7505 Ready to Learn Block Grant
310,813
7810 State Share of Social Security and Medicare Taxes
506,333
7820 State Share of Retirement Contributions REVENUE FROM STATE SOURCES REVENUE FROM FEDERAL SOURCES 8514 NCLB, Title I - Improving the Academic Achievement of the Disadvantaged 8515 NCLB, Title II - Preparing, Training and Recruiting High Quality Teachers and Principals
2,147,247 $15,195,646 190,000 65,000
Page 6
2017-2018 Final General Fund Budget LEA : 110141003
Estimated Revenues and Other Financing Sources: Detail
Bald Eagle Area SD
Printed 6/9/2017 7:53:16 AM
Page - 2 of 2 Amount
REVENUE FROM FEDERAL SOURCES 8820 Medical Assistance Reimbursement for Administrative Claiming (Quarterly) Program REVENUE FROM FEDERAL SOURCES OTHER FINANCING SOURCES 9400 Sale of or Compensation for Loss of Fixed Assets OTHER FINANCING SOURCES TOTAL ESTIMATED REVENUES AND OTHER SOURCES
1,000 $256,000 500 $500 31,236,657
Page 7
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 1 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
Rate
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Centre
Total
a. Assessed Value
$232,889,375
$232,889,375
b. Real Estate Mills
54.6300
2016-17 Data
I. 2017-18 Data c. 2015 STEB Market Value
$694,485,697
$694,485,697
d. Assessed Value
$233,076,615
$233,076,615
$0
$0
$12,722,747
$12,722,747
g. Percent of Total Market Value
100.00000%
100.00000%
h. Rebalanced 2016-17 Tax Levy
$12,722,747
$12,722,747
e. Assessed Value of New Constr/ Renov 2016-17 Calculations f. 2016-17 Tax Levy (a * b) 2017-18 Calculations II.
(f Total * g) i. Base Mills Subject to Index
54.6300
(h / a * 1000) if no reassessment (h / (d-e) * 1000) if reassessment Calculation of Tax Rates and Levies Generated j. Weighted Avg. Collection Percentage k. Tax Levy Needed
93.28948%
93.28948%
$13,164,167
$13,164,167
(Approx. Tax Levy * g)
l. 2017-18 Real Estate Tax Rate
56.4800
(k / d * 1000) III.
m. Tax Levy Generated by Mills
$13,164,167
$13,164,167
(l / 1000 * d) n. Tax Levy minus Tax Relief for Homestead Exclusions
$9,924,745
(m - Amount of Tax Relief for Homestead Exclusions) o. Net Tax Revenue Generated By Mills
$9,258,743
(n * Est. Pct. Collection)
Page 8
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 2 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
Rate
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Total
Centre Index Maximums p. Maximum Mills Based On Index
56.4874
(i * (1 + Index)) q. Mills In Excess of Index
0.0000
(if (l > p), (l - p)) r. Maximum Tax Levy Based On Index IV.
$13,165,892
$13,165,892
(p / 1000 * d) s. Millage Rate within Index?
Yes
(If l > p Then No) t. Tax Levy In Excess of Index
$0
$0
$0
$0
(if (m > r), (m - r)) u.Tax Revenue In Excess of Index (t * Est. Pct. Collection)
Information Related to Property Tax Relief Assessed Value Exclusion per Homestead V.
Number of Homestead/Farmstead Properties
$14,090 4131
4131
Median Assessed Value of Homestead Properties
$35,225
Page 9
2017-2018 Final General Fund Budget AUN: 110141003
Real Estate Tax Rate (RETR) Report Multi-County Rebalancing Based on Methodology of Section 672.1 of School Code
Bald Eagle Area SD
Page - 3 of 3
Printed 6/9/2017 7:53:16 AM Act 1 Index (current): 3.4% Rate
Calculation Method:
Approx. Tax Revenue from RE Taxes: Amount of Tax Relief for Homestead Exclusions
$9,258,743 $3,239,422
Total Approx. Tax Revenue:
$12,498,165
Approx. Tax Levy for Tax Rate Calculation:
$13,164,167 Total
Centre
Portion of Act 1 EIT Revenue Used for Tax Relief used for: Homestead Exclusions State Property Tax Reduction Allocation used for: Homestead Exclusions Prior Year State Property Tax Reduction Allocation used for: Homestead Exclusions
$2,507,287
Lowering RE Tax Rate
$0
$2,507,287
$732,135
Lowering RE Tax Rate
$0
$732,135
$0
Amount of Tax Relief from State/Local Sources
$0 $3,239,422
Page 10
2017-2018 Final General Fund Budget
Local Education Agency Tax Data
Bald Eagle Area SD
REAL ESTATE, PER CAPITA (SEC. 679), EIT/PIT (ACT 1), LOCAL ENABLING (ACT 511)
LEA : 110141003 Printed 6/9/2017 7:53:17 AM
Page - 1 of 1
CODE 6111 Current Real Estate Taxes County Name Taxable Assessed Value Centre
233,076,615
Totals:
233,076,615
Real Estate Mills
Amount of Tax Relief for Homestead Exclusions
Tax Levy Generated by Mills
56.4800
Tax Levy Minus Homestead Exclusions
13,164,167 13,164,167
Net Tax Revenue Generated By Mills
Percent Collected 93.28948%
-
3,239,422
=
9,924,745 X
93.28948%
Rate 6120
Current Per Capita Taxes, Section 679
6130
Current Taxpayer Relief Taxes – Proportional Assessments
6131
Current Act 1 Earned Income Taxes
6140
Total Current Taxpayer Relief Taxes – Proportional Assessments Current Act 511 Taxes – Flat Rate Assessments
Rate
6141
Current Act 511 Per Capita Taxes
6142
Current Act 511 Occupation Taxes – Flat Rate
6143
=
9,258,743
Estimated Revenue
$5.00
37,000
Rate
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
1.000%
0.000%
2,507,287
2,507,287
2,507,287
2,507,287
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
$5.00
$0.00
37,000
37,000
$0.00
$0.00
0
0
Current Act 511 Local Services Taxes
$5.00
$0.00
27,015
27,015
6144
Current Act 511 Trailer Taxes
$0.00
$0.00
0
0
6145
Current Act 511 Business Privilege Taxes – Flat Rate
$0.00
$0.00
0
0
6146
Current Act 511 Mechanical Device Taxes – Flat Rate
$0.00
$0.00
0
0
6149
Current Act 511 Taxes, Other Flat Rate Assessments
$0.00
$0.00
0
0
Total Current Act 511 Taxes – Flat Rate Assessments Current Act 511 Taxes – Proportional Assessments
64,015
64,015
6150
Rate
Add'l Rate (if appl.)
Tax Levy
Estimated Revenue
6151
Current Act 511 Earned Income Taxes
1.050%
0.000%
2,632,704
2,632,704
6152
Current Act 511 Occupation Taxes
0.000
0.000
0
0
6153
Current Act 511 Real Estate Transfer Taxes
0.500%
0.000%
134,775
134,775
6154
Current Act 511 Amusement Taxes
0.000%
0.000%
0
0
6155
Current Act 511 Business Privilege Taxes
6156
Current Act 511 Mechanical Device Taxes – Percentage
6157
Current Act 511 Mercantile Taxes
6159
Current Act 511 Taxes, Other Proportional Assessments
0.000
0.000
0
0
0.000%
0.000%
0
0
0.000
0.000
0
0
0
0
0
0
2,767,479
2,767,479
Total Current Act 511 Taxes – Proportional Assessments
Total Act 511, Current Taxes
2,831,494 Act 511 Tax Limit
-->
694,485,697 X Market Value
Page 11
12
8,333,828
Mills
(511 Limit)
Comparison of Tax Rate Changes to Index
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 1 Tax Rate Charged in:
Tax Functio n 6111
Description
2017-18
Less than or equal to Index
Index
Current Real Estate Taxes Centre
6120
2016-17 (Rebalanced)
Percent Change in Rate
Current Per Capita Taxes, Section 679
Current Taxpayer Relief Taxes – Proportional Assessments 6131 Current Act 1 Earned Income Taxes
54.6300
56.4800
3.39%
Yes
3.4%
$5.00
$5.00
0.00%
Yes
3.4%
1.000%
1.000%
0.00%
Yes
3.4%
Current Act 511 Taxes – Flat Rate Assessments 6141
Current Act 511 Per Capita Taxes
$5.00
$5.00
0.00%
Yes
3.4%
6143
Current Act 511 Local Services Taxes
$5.00
$5.00
0.00%
Yes
3.4%
Current Act 511 Taxes – Proportional Assessments 6151
Current Act 511 Earned Income Taxes
1.050%
1.050%
0.00%
Yes
3.4%
6153
Current Act 511 Real Estate Transfer Taxes
0.500%
0.500%
0.00%
Yes
3.4%
Page 12
Additional Tax Rate Charged in: 2017-18 2016-17 (Rebalanced)
Percent Change in Rate
Less than or equal to Index
Estimated Expenditures and Other Financing Uses: Budget Summary
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 1
Description
Amount
1000 Instruction 1100 1200 1300 1400
Regular Programs - Elementary / Secondary Special Programs - Elementary / Secondary Vocational Education Other Instructional Programs - Elementary / Secondary
11,683,351 3,858,272 2,147,322 406,547
Total Instruction
$18,095,492
2000 Support Services 2100 2200 2300 2400 2500 2600 2700 2800 2900
Support Services - Students Support Services - Instructional Staff Support Services - Administration Support Services - Pupil Health Support Services - Business Operation and Maintenance of Plant Services Student Transportation Services Support Services - Central Other Support Services
1,171,912 2,167,284 1,694,684 352,117 394,618 2,888,985 1,992,000 47,500 52,369
Total Support Services
$10,761,469
3000 Operation of Non-Instructional Services 3200 Student Activities 3300 Community Services
923,864 16,918
Total Operation of Non-Instructional Services
$940,782
5000 Other Expenditures and Financing Uses 5100 Debt Service / Other Expenditures and Financing Uses 5200 Interfund Transfers - Out 5900 Budgetary Reserve
2,343,568 400,000 200,000
Total Other Expenditures and Financing Uses
$2,943,568
Total Estimated Expenditures and Other Financing Uses
$32,741,311
Page 13
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 1 of 4
Description
Amount
1000 Instruction 1100 Regular Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 800 Other Objects
6,102,840 4,114,333 362,750 101,045 590,026 397,207 15,150
Total Regular Programs - Elementary / Secondary
$11,683,351
1200 Special Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
1,477,668 1,464,825 392,950 1,000 396,179 118,550 6,000 1,100
Total Special Programs - Elementary / Secondary
$3,858,272
1300 Vocational Education 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
344,175 239,336 500 1,476,011 56,150 25,000 6,150
Total Vocational Education
$2,147,322
1400 Other Instructional Programs - Elementary / Secondary 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services 500 Other Purchased Services 600 Supplies
158,132 128,615 3,000 104,400 12,400
Total Other Instructional Programs - Elementary / Secondary
$406,547
Total Instruction
$18,095,492
2000 Support Services 2100 Support Services - Students 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services
Page 14
659,575 444,462 32,200 50 10,350
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 2 of 4
Description
Amount
600 Supplies 800 Other Objects
22,625 2,650
Total Support Services - Students
$1,171,912
2200 Support Services - Instructional Staff 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
639,861 613,423 101,650 11,200 106,335 354,515 338,000 2,300
Total Support Services - Instructional Staff
$2,167,284
2300 Support Services - Administration 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 800 Other Objects
894,304 538,240 99,850 1,500 72,240 47,950 40,600
Total Support Services - Administration
$1,694,684
2400 Support Services - Pupil Health 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
183,599 143,838 6,875 300 3,950 10,005 3,000 550
Total Support Services - Pupil Health
$352,117
2500 Support Services - Business 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
188,205 136,213 5,500 5,350 22,250 27,350 4,000 5,750
Total Support Services - Business 2600 Operation and Maintenance of Plant Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits
$394,618
Page 15
868,189 729,046
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 3 of 4
Description 300 400 500 600 700 800
Amount
Purchased Professional and Technical Services Purchased Property Services Other Purchased Services Supplies Property Other Objects
84,750 666,300 122,500 341,700 65,000 11,500
Total Operation and Maintenance of Plant Services
$2,888,985
2700 Student Transportation Services 300 Purchased Professional and Technical Services 500 Other Purchased Services 600 Supplies
3,000 1,984,500 4,500
Total Student Transportation Services
$1,992,000
2800 Support Services - Central 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 500 Other Purchased Services 800 Other Objects
20,000 17,500 9,500 500
Total Support Services - Central
$47,500
2900 Other Support Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 400 Purchased Property Services
21,720 28,649 2,000
Total Other Support Services
$52,369
Total Support Services
$10,761,469
3000 Operation of Non-Instructional Services 3200 Student Activities 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services 400 Purchased Property Services 500 Other Purchased Services 600 Supplies 700 Property 800 Other Objects
460,000 190,675 103,000 9,500 50,700 77,893 11,996 20,100
Total Student Activities
$923,864
3300 Community Services 100 Personnel Services - Salaries 200 Personnel Services - Employee Benefits 300 Purchased Professional and Technical Services
7,020 2,898 7,000
Total Community Services
$16,918
Total Operation of Non-Instructional Services
$940,782
5000 Other Expenditures and Financing Uses 5100 Debt Service / Other Expenditures and Financing Uses
Page 16
Estimated Expenditures and Other Financing Uses: Detail
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:18 AM
Page - 4 of 4
Description
Amount
800 Other Objects 900 Other Uses of Funds
923,568 1,420,000
Total Debt Service / Other Expenditures and Financing Uses
$2,343,568
5200 Interfund Transfers - Out 900 Other Uses of Funds
400,000
Total Interfund Transfers - Out
$400,000
5900 Budgetary Reserve 800 Other Objects
200,000
Total Budgetary Reserve
$200,000
Total Other Expenditures and Financing Uses
$2,943,568
TOTAL EXPENDITURES
$32,741,311
Page 17
Schedule Of Cash And Investments (CAIN)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 1 of 2
Cash and Short-Term Investments General Fund
06/30/2017 Estimate
06/30/2018 Projection
8,905,954
8,555,954
2,987,414
2,995,914
126,700
127,250
3,500
4,000
$12,023,568
$11,683,118
06/30/2017 Estimate
06/30/2018 Projection
Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund Permanent Fund Total Cash and Short-Term Investments Long-Term Investments General Fund Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund
Page 18
Schedule Of Cash And Investments (CAIN)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 2 of 2
Long-Term Investments
06/30/2017 Estimate
06/30/2018 Projection
$12,023,568
$11,683,118
Permanent Fund Total Long-Term Investments TOTAL CASH AND INVESTMENTS
Page 19
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 1 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
20,525,000
19,035,000
674,655
709,655
413,837
633,328
General Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total General Fund Public Purpose (Expendable) Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable
Page 20
38,778,525
41,889,450
$60,392,017
$62,267,433
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 2 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
29,750
28,500
0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Capital Reserve Fund - § 1431 Other Capital Projects Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Capital Projects Fund Debt Service Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Debt Service Fund Food Service / Cafeteria Operations Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations
Page 21
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 3 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Food Service / Cafeteria Operations Fund Child Care Operations Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Child Care Operations Fund Other Enterprise Funds 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Enterprise Funds Internal Service Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Internal Service Fund Private Purpose Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Private Purpose Trust Fund
Page 22
1,406,475
1,295,550
$1,436,225
$1,324,050
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 4 of 6
Long-Term Indebtedness
06/30/2017 Estimate
Investment Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Investment Trust Fund Pension Trust Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Pension Trust Fund Activity Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Activity Fund Other Agency Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable 0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Other Agency Fund Permanent Fund 0510 Bonds Payable 0520 Extended-Term Financing Agreements Payable
Page 23
06/30/2018 Projection
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 5 of 6
Long-Term Indebtedness
06/30/2017 Estimate
06/30/2018 Projection
$61,828,242
$63,591,483
0530 Lease-Purchase Obligations 0540 Accumulated Compensated Absences 0550 Authority Lease Obligations 0560 Other Post-Employment Benefits (OPEB) 0599 Other Long-Term Liabilities Total Permanent Fund Total Long-Term Indebtedness
Page 24
Schedule Of Indebtedness (DEBT)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:19 AM
Page - 6 of 6
Short-Term Payables General Fund
06/30/2017 Estimate
06/30/2018 Projection
1,420,000
1,490,000
$1,420,000
$1,490,000
$63,248,242
$65,081,483
Public Purpose (Expendable) Trust Fund Other Comptroller-Approved Special Revenue Funds Athletic / School-Sponsored Extra Curricular Activities Fund Capital Reserve Fund - § 690, §1850 Capital Reserve Fund - § 1431 Other Capital Projects Fund Debt Service Fund Food Service / Cafeteria Operations Fund Child Care Operations Fund Other Enterprise Funds Internal Service Fund Private Purpose Trust Fund Investment Trust Fund Pension Trust Fund Activity Fund Other Agency Fund Permanent Fund Total Short-Term Payables TOTAL INDEBTEDNESS
Page 25
Fund Balance Summary (FBS)
2017-2018 Final General Fund Budget LEA : 110141003
Bald Eagle Area SD
Printed 6/9/2017 7:53:20 AM
Page - 1 of 1
Account Description
Amounts
0810 Nonspendable Fund Balance 0820 Restricted Fund Balance 0830 Committed Fund Balance
3,937,037
0840 Assigned Fund Balance
639,595
0850 Unassigned Fund Balance
2,408,443
Total Ending Fund Balance - Committed, Assigned, and Unassigned
$6,985,075
5900 Budgetary Reserve
200,000
Total Estimated Ending Committed, Assigned, and Unassigned Fund Balance and Budgetary Reserve
Page 26
$7,185,075
