2017-2018 FINAL BUDGET ADOPTION June 13, 2017 Boyertown Area - - PowerPoint PPT Presentation

SLIDE 1

2017-2018 FINAL BUDGET ADOPTION

June 13, 2017 Boyertown Area School District Board of Education

SLIDE 2

Budget Considerations

• The 2017-2018 General Fund Budget has been a challenge
• Construction Projects Ongoing – (BASH, MSW, Elementary HVAC)
• August 2018 BASH servicing grades 9-12, Junior High Schools becoming

middle schools servicing grade 6-8, Elementary Schools provided room for growth serving K-5

• Student and Teacher movement as grades reconfigure
• Curriculum/Program of Studies Revisions
• Complete Final Phase of BASH 1:1 Initiative
• Increasing Mandated Costs – PSERS, Special Education, Charter Tuition
• Federal and State Budget Difficulties
• Future Education Funding Concerns – (Title I, Title II, ACCESS)
• Health Care Expenditures & Governmental Mandates

SLIDE 3

2017-2018 Budget Development

• September 2016 - Budget Packages sent to Building and Department

Administrators

• October 2016 – Building and Department Meetings to discuss budget

assumptions, building needs, and personnel

• November 2016 review of budget submissions and entry into financial system

as requested

• November 29 - Initial Board presentation to review budget items including

revenue projections, Act 1 information, and major mandated expenditures

• December 2016 – Administrative Personnel projections, review of wage &

salary increases, preliminary fringe benefit information

• January 17 – Board adopts resolution to not exceed Act 1 Index of 3.1%
• February 7 – Governor Wolf’s Commonwealth Budget Address, BASD Budget

work session

• Budget Work Sessions – March 7, April 4, May 2, May 30
• May 9 - Final Proposed Budget Adoption – start 30 day review period
• June 13 - Final Adoption of the 2017-2018 Budget Tonight

SLIDE 4

Focus on the Future

The development of the 2017-2018 budget stressed more than a

• ne-year financial plan. With the goal of becoming a high

achieving school district, the School Board and Administration planned to invest in the Boyertown Area students’ education. Important Items Discussed

• How will decisions for 17-18 impact the next 5 years?
• Replacement of One-Time Fund Balances
• Future Impact of Large Expenditure Items like Health Care

Costs, PSERS Pension Contribution Increases, Continued Increase in Special Education Students and Service

• Building Operations & Maintenance Evaluation – Efficient

Utilization of Existing Buildings

• Need for Additional Revenue versus Program & Education

Service reductions.

• Future Tax Increases to Improve District Performance

SLIDE 5

2016 Berks County Schools Real Estate Tax Rate

ANTIETAM 37.79

• B. HEIGHTS

32.30 EXETER 32.21 FLEETWOOD 31.81 WYOMISSING 30.07 KUTZTOWN 29.95 DANIEL BOONE 29.70 MUHLENBERG 28.56 TULPEHOCKEN 27.70

• C. WEISER

27.14

• GOV. MIFFLIN

27.10

• SCH. VALLEY

27.07 TWIN VALLEY 26.77 HAMBURG 26.71 OLEY VALLEY 26.33 WILSON 24.95 BOYERTOWN 24.27 READING* 17.93

* Reading SD taxpayers voted to exchange HIGHER INCOME tax FOR LOWER PROPERTY tax. Compare Reading SD EIT of 1.5% to Boyertown .5%

SLIDE 6

2016 Montgomery County Schools Real Estate Tax Rate

CHELTENHAM 45.09 POTTSTOWN 39.25 JENKINTOWN 38.98 POTTSGROVE 37.72 NORRISTOWN 34.39 LWR MORELAND 33.32 UPPER DUBLIN 32.29 SPRINGFIELD 31.66 PERK VALLEY 31.60 ABINGTON 30.83 UPR MORELAND 29.40 SOUDERTON 28.78 METHACTON 28.74 HATBORO-HORS 27.49 LOWER MERION 27.40 SPRING FORD 26.24

BOYERTOWN 24.27

NORTH PENN 24.19 UPPER PERK 23.64 COLONIAL 20.96 UPPER MERION 18.96 WISSAHICKON 18.79

SLIDE 7

Act 1 Index

Index Calculation for 2017-2018: ECI Index equals 2.5% times: Aid Ratio Allow (.75 + .479) x 1.2229 BASD Index (from PDE) 3.1% County Millage Index Increase Berks 24.27 3.1% .75 Mont. 24.27 3.1% .75

1 Mill = $2.3 Million times .75 = $1,725,000

The School Board adopted a resolution that the District would not increase the tax rate by more than the Act 1 Index

SLIDE 8

General Fund Budget Progress

February 7 May 9 June 13 Projected Revenue $105,347,105 $106,299,617 $106,347,569 Tax Increase of 3.1% $ 1,750,000 $ 1,750,000 Total Projected Revenue $108,049,617 $108,097,569 Projected Expenditures $111,345,876 $109,461,229 $109,439,014 Projected Deficit $ (5,998,771) $ (1,411,612) $ (1,340,445) Use of One-Time Funds PSERS Committed $ 2,000,000 $ 1,411,612 $ 1,340,445 Net Deficit $ (3,998,771) $ 0 $ 0 Current Budget does include Basic Ed and Special Ed revenue increases as proposed in Governor Wolf’s budget proposal

SLIDE 9

Budget Deficit Reduction

• Three Ways to Decrease a Budget Deficit:
• 1. Decrease Expenditures
• 2. Increase Revenue
• 3. Use of Fund Balance

SLIDE 10

Deficit Reduction Expenditures Review

SLIDE 11

New Secondary Personnel Recommendations

Regular Ed/Support

• BASH Administrator
• BASH Clerical
• BASH Counselor
• BASH HPE
• BASH HPE
• BASH Custodians (2)
• BASH Security Monitor
• BASH CAF Monitor (2)
• Secondary Orchestra (.5)

Special Education

• BASH ES Teacher (IDEA)
• BASH .5 Gifted Teacher
• MSE LS Teacher
• MS Gifted Teacher

SLIDE 12

New Elementary Personnel Recommended

• CES Intervention Teacher
• BES .5 Counselor
• EES .5 Counselor
• PFES .5 Counselor
• GES .5 Dean of Students
• NHUF .5 Dean of Students
• GES Playground Aide

SLIDE 13

New District-wide Personnel Recommended

• School Psychologist
• Speech Pathologist
• PT Staff Accountant

SLIDE 14

Personnel Summary Full Time Equivalent Positions

Additions Regular Education 1 BASH Guidance Counselor 1 BASH HPE 1 CES Intervention Teacher .5 Secondary Orchestra Special Education 1 Bash ES Teacher (IDEA) .5 BASH Gifted Teacher 1 MSE LS Teacher 1 School Psychologist Support .5 Staff Accountant Deletions

Regular Education .5 BASH Social Studies .5 JHE Planetarium (Contracted) 3 WES Grade Teachers 1 BES Grade Teacher 1 GES Grade Teacher 1 NHUF Grade Teacher 0 Professional FTE Total .5 FTE Addition General Funded (.5) FTE

SLIDE 15

Special Education Expense (Federal Mandate)

SLIDE 16

Personnel Wages & Benefits

Salaries & Benefits Final Year of BAEA Collective Bargaining Agreement (CBA) No Furloughs – Re-Allocation of Positions through Attrition All Non-BAEA Employees budged at 2.5% increase in wages Benefits PSERS Increase from 30.03% to 32.57% Health Insurance – 0% Increase in Premium Staff Contribution percent increase .5% Premium Holiday – December 2017 Internal Service Fund Balance Reduction

SLIDE 17

Pension Contribution Expense (State Mandate)

SLIDE 18

Cost Reductions

JH Librarian $ 80,000 Counselor $ 98,000 BASH Chem/Bio $ 50,000 Administration $ 175,000 Administrative Clerical $ 25,000 Custodial Support $ 130,000 Recess Aides $ 17,000 Paraprofessional $ 22,000 Budgets Reduction $ 150,000 Bus Runs (3) $ 117,000 Total $ 864,000

SLIDE 19

Deficit Reduction Increase Revenue

SLIDE 20

Proposed Revenue Increases

State Revenue Assume Governor’s Budget will be adopted as proposed with $100 million added to BEF Local Revenue Maximum tax increase of 3.1% (BASD Act 1 Index) Assessment Increases – Montgomery Co. Growth Student Activity Fees increase to $200 per secondary student for unlimited participation BASH student Parking Fee increase to $100 per year Building Rental Custodial Hourly Fee from $34 to $44

SLIDE 21

Use of Fund Balance

SLIDE 22

Fund Balance Usage

➢$1.34 million in Committed Fund Balance for PSERS included in budget ▪ Projected Balance of PSERS Fund on 6/30/18 is $3.5 million ▪ Step down plan to utilize remaining balance over 5-6 years with proposed .1 mill increase each year slowly replacing the reliance of one-time funding

• Capital Projects Fund Transfer of $500,000 for 2017-18

eliminated

• Internal Service Fund Balance Reduction Plan - Premium

Holiday

SLIDE 23

Other Funding Sources

The following funding sources will be added to the General Fund budget for inclusion in the adoption of the Final Proposed Budget on May 9 and the Final Budget on June 13: Local Pottstown Health & Wellness $ 75,000 State Ready to Learn Block Grant $ 928,175 Federal Title I $ 563,931 Title II $ 93,000 IDEA $1,152,225 ACCESS $ 475,000 Total $3,307,331 Each Funding source has equal revenues and expenditures

SLIDE 24

Questions & Discussion

SLIDE 25

6/13/2017

Includes 3.1% Tax Increase Actual Current Proposed Difference

2015-2016 2016-2017 2017-2018 $ % Object Description Budget Budget Budget Difference Difference EXPENDITURES SALARY 110 Administrative Wages 3,716,880 3,704,170 3,715,330 11,160 0.30% 120 Professional Wages 35,777,074 36,535,573 37,171,802 636,229 1.74% 130 Extra Duty Wages 831,459 800,400 858,347 57,947 7.24% 140 Technical Wages 901,646 1,045,236 1,160,541 115,305 11.03% 150 Clerical Wages 2,063,125 2,110,216 2,086,900 (23,316)

• 1.10%

160 Maintenance Wages 471,460 512,000 489,175 (22,825)

• 4.46%

170 Custodial Wages 2,305,633 2,309,566 2,265,411 (44,155)

• 1.91%

180 Community Wages 12,710 20,000 20,000

• 0.00%

190 Para Professional Wages 2,912,840 2,685,262 3,249,669 564,407 21.02% Total Wages 48,992,827 49,722,423 51,017,175 1,294,752 2.60% BENEFITS 271 Health Insurance 8,427,402 8,487,289 8,153,956 (333,333)

• 3.93%

272 Dental Insurance 613,663 541,150 554,643 13,493 2.49% 213 Life Insurance 48,514 48,328 49,634 1,306 2.70% 215 Vision Insurance 61,688 61,744 61,543 (201)

• 0.33%

217 Disability Insurance 29,785 30,600 29,440 (1,160)

• 3.79%

220 FICA & Medicare 3,631,846 3,739,490 3,781,937 42,447 1.14% 230 Retirement 12,668,512 14,660,600 16,072,083 1,411,483 9.63% 240 Tuition Reimbursement 115,831 150,000 150,000

• 0.00%

250 Unemployment 21,520 20,000 20,000

• 0.00%

260 Work Comp 259,007 295,164 247,871 (47,293)

• 16.02%

290 Other Benefits 46,782 45,000 43,750 (1,250)

• 2.78%

25,924,550 28,079,365 29,164,857 1,085,492 3.87%

TOTAL SALARY & BENEFITS

74,917,377 77,801,788 80,182,032 2,380,244 3.06% PROFESSIONAL SERVICES 2,239,054 2,191,344 2,205,971 14,627 0.67% CONTRACTED SERVICES 767,224 781,827 766,821 (15,006)

• 1.92%

PURCHASED SERVICES 12,897,566 13,326,684 13,846,600 519,916 3.90% SUPPLIES & TEXTBOOKS 3,346,844 3,894,023 4,127,636 233,613 6.00% EQUIPMENT 468,287 532,215 158,450 (373,765)

• 70.23%

INTEREST & FEES 3,127,382 3,974,246 3,871,504 (102,742)

• 2.59%

TECHNOLOGY RESERVE TRANSFER 1,135,000 1,270,000 1,510,000 240,000 18.90% CAPITAL PROJECTS TRANSFER 250,000 (250,000)

• 100.00%

DEBT SERVICE, INTERFUND TRANS. 4,050,000 3,643,905 2,770,000 (873,905)

• 23.98%

TOTAL OTHER EXPENDITURES

28,031,357 29,864,244 29,256,982 (607,262)

• 2.17%

TOTAL PROJECTED EXPENDITURES 102,948,734 107,666,032 109,439,014 1,772,982 1.72% REVENUES 6000 LOCAL REVENUE 69,316,764 70,879,501 73,723,082 2,843,581 4.01% 7000 STATE REVENUE 31,921,607 33,190,648 34,267,987 1,077,339 3.25% 8000 FEDERAL REVENUE

• 9000 OTHER REVENUE

104,094 107,500 107,500

• 0.00%

TOTAL PROJECTED REVENUES 101,342,465 104,177,649 108,098,569 3,920,920 3.76% OPERATIONAL SURPLUS/(DEFICIT) (1,606,269) (3,488,383) (1,340,445) COMMITTED PSERS FUND BALANCE 2,000,000 1,340,445 (659,555)

• 32.98%

FUND BALANCE 488,383 (488,383)

• 100.00%

DEBT SERVICE TRANSFER IN 1,000,000 1,000,000 (1,000,000)

• 100.00%

PROJECTED SURPLUS (DEFICIT) (606,269)

• 2016-2017

2017-2018 Tax at Act 1 Index Berks 24.27 3.10% 25.02 0.75 Montgomery 24.27 3.10% 25.02 0.75 Average 24.27 3.10% 25.02 0.75 Proposed Tax Berks 24.27 3.09% 25.02 0.75 Montgomery 24.27 3.09% 25.02 0.75 Average 24.27 3.09% 25.02 0.75

BOYERTOWN AREA SCHOOL DISTRICT BUDGET SUMMARY GENERAL FUND ONLY 2017-2018

BASD Page 1 6/7/2017

SLIDE 26

6/13/2017 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 Description Actual Budget Proposed Projected Projected Projected Projected REVENUE 0.58 0.36 0.75 LOCAL % Tax Increase 2.49% Tax Inc. 1.5% Tax Inc. 3.1% Tax Inc. Additional Tax Revenue 1,725,000 6111 Current Tax 57,965,425 59,389,001 63,767,969 64,405,648.69 65,049,705.18 65,700,202.23 66,357,204.25 Property Tax Relief (1,726,887) (1,700,000) (1,700,000) (1,700,000) (1,700,000) 6112 Interim Tax 458,531 392,500 392,500 400,000 400,000 400,000 400,000 6120-6141 Per Capita Tax 288,173 282,400 282,400 285,000 285,000 285,000 285,000 6151 Earned Income 6,832,550 6,800,000 6,900,000 7,000,000 7,100,000 7,200,000 7,300,000 6153 Transfer Tax 1,242,968 1,120,000 1,250,000 1,250,000 1,250,000 1,250,000 1,250,000 6414-6441 Delinquent Tax 1,684,388 2,148,900 1,898,900 1,900,000 1,900,000 1,900,000 1,900,000 Other Tax 137,444 141,200 150,000 150,000 150,000 150,000 150,000 6510 Interest Earnings 150,553 100,000 150,000 150,000 150,000 150,000 150,000 6700 Student Activity Revenue 141,267 140,000 270,000 270,000 270,000 270,000 270,000 Other Local Revenue 415,465 365,500 388,200 380,000 380,000 380,000 380,000 TOTAL LOCAL REVENUE 69,316,764 70,879,501 73,723,082 74,490,649 75,234,705 75,985,202 76,742,204 % Increase (Decrease) 3.53% 2.25% 4.01% 1.04% 1.00% 1.00% 1.00% STATE 7110 Basic Education 14,376,348 14,499,932 14,953,448 14,953,448 14,953,448 14,953,448 14,953,448 7271 Special Education 3,502,702 3,573,294 3,558,467 3,558,467 3,558,467 3,558,467 3,558,467 7310 Transportation 2,916,163 2,835,000 2,835,000 2,700,000 2,700,000 2,700,000 2,700,000 7320 Rental Subsidy 759,023 1,000,000 1,000,000 1,300,000 1,300,000 1,300,000 1,300,000 7340 Property Tax Relief 1,749,435 1,745,690 1,726,887 1,700,000 1,700,000 1,700,000 1,700,000 7810 Social Security 1,846,154 1,885,645 1,891,573 2,009,926 2,070,201 2,132,284 2,196,230 7820 Retirement 6,505,404 7,400,087 8,038,612 8,980,298 9,614,934 10,020,342 10,450,034 Other State Subsidies 266,378 251,000 264,000 250,000 250,000 250,000 250,000 TOTAL STATE REVENUE 31,921,607 33,190,648 34,267,987 35,452,139 36,147,050 36,614,541 37,108,179 % Increase (Decrease) 4.79% 3.98% 3.25% 3.46% 1.96% 1.29% 1.35% OTHER 9000 Other Revenue 104,094 107,500 107,500 110,000 110,001 110,001 110,001 TOTAL GENERAL FUND REVENUE 101,342,465 104,177,649 108,098,569 110,052,788 111,491,756 112,709,744 113,960,384 % Increase (Decrease) 3.92% 2.80% 3.76% 1.81% 1.31% 1.09% 1.11% EXPENDITURES SALARY 3.0% 3.0% 3.0% 3.0% 3.0% 110 Administrative Wages 3,716,880 3,704,170 3,715,330 3,826,790 3,941,594 4,059,841 4,181,637 120 Professional Wages 35,777,074 36,535,573 37,171,802 38,286,956 39,435,565 40,618,632 41,837,191 130 Extra Duty Wages 831,459 800,400 858,347 884,097 910,620 937,939 966,077 140 Technical Wages 901,646 1,045,236 1,160,541 1,195,357 1,231,218 1,268,154 1,306,199 150 Clerical Wages 2,063,125 2,110,216 2,086,900 2,149,507 2,213,992 2,280,412 2,348,824 160 Maintenance Wages 471,460 512,000 489,175 503,850 518,966 534,535 550,571 170 Custodial Wages 2,305,633 2,309,566 2,265,411 2,333,373 2,403,375 2,475,476 2,549,740 180 Community Wages 12,710 20,000 20,000 20,000 20,000 20,000 20,000 190 Para Professional Wages 2,912,840 2,685,262 3,249,669 3,347,159 3,447,574 3,551,001 3,657,531 Total Wages 48,992,828 49,722,423 51,017,175 52,547,090 54,122,903 55,745,990 57,417,770 % Increase (Decrease) 3.22% 1.49% 2.60% 3.00% 3.00% 3.00% 3.00% BENEFITS 271 Health Insurance - SFSF & EdJobs 8,427,402 8,487,289 8,153,956 8,929,154 9,375,611 9,844,392 10,336,612 272 Dental Insurance 613,663 541,150 554,643 560,189 565,791 571,449 577,164 213 Life Insurance 48,514 48,328 49,634 49,634 49,634 49,634 49,634 215 Vision Insurance 61,688 61,744 61,543 61,543 61,543 61,543 61,543 217 Disability Insurance 29,785 30,600 29,440 29,440 29,440 29,440 29,440 220 FICA & Medicare 3,631,846 3,739,490 3,781,937 4,019,852 4,140,402 4,264,568 4,392,459 230 Retirement 12,668,512 14,660,600 16,072,083 17,960,595 19,229,867 20,040,683 20,900,068 240 Tuition Reimbursement 115,831 150,000 150,000 250,000 250,000 250,000 250,000 250 Unemployment 21,520 20,000 20,000 30,000 30,000 30,000 30,000 260 Work Comp 259,007 295,164 247,871 250,350 252,853 255,382 257,936 290 Other Benefits 46,782 45,000 43,750 43,750 43,750 43,750 43,750 Total Benefits 25,924,549 28,079,365 29,164,857 32,184,508 34,028,893 35,440,842 36,928,606 TOTAL SALARY & BENEFITS 74,917,377 77,801,788 80,182,032 84,731,598 88,151,795 91,186,832 94,346,375 % Increase (Decrease) 6.88% 3.85% 3.06% 5.67% 4.04% 3.44% 3.46% PROFESSIONAL SERVICES 2,239,054 2,191,344 2,205,971 2,200,000 2,200,000 2,200,000 2,200,000 CONTRACTED SERVICES 767,224 781,827 766,821 760,000 760,000 760,000 760,000 PURCHASED SERVICES 12,897,566 13,326,684 13,846,600 14,574,926 15,146,912 15,743,459 16,365,680 SUPPLIES & TEXTBOOKS 3,346,844 3,894,023 4,127,636 4,168,912 4,210,601 4,252,707 4,295,235 EQUIPMENT 468,287 532,215 158,450 160,000 160,000 160,000 160,000 INTEREST & FEES 3,127,382 3,974,246 3,871,504 3,413,608 3,373,868 3,342,218 3,342,218 TECH RESERVE TRANSFER (Technology Leases) 1,135,000 1,270,000 1,510,000 1,510,000 1,510,000 1,510,000 1,510,000 DEBT SERVICE, BUDGET RESERVE 4,050,000 3,643,905 2,770,000 2,860,000 2,940,000 3,015,000 3,015,000 TOTAL OPERATING EXPENDITURES 102,948,734 107,416,032 109,439,014 114,379,045 118,453,177 122,170,216 125,994,508 % Increase (Decrease) 7.59% 4.34% 1.88% 4.51% 3.56% 3.14% 3.13% Operating Surplus/(Deficit) (1,606,269) (3,238,383) (1,340,445) (4,326,257) (6,961,421) (9,460,472) (12,034,124) Proposed Tax Increase at 3% 18-19 1,726,380 1,743,644 1,761,080 1,778,691 Proposed Tax Increase at 3% 19-20 1,778,171 1,795,953 1,813,913 Proposed Tax Increase at 3% 20-21 1,831,517 1,849,832 Proposed Tax Increase at 3% 21-22 1,886,462 Transfer to Capital Projects (250,000) (100,000) (200,000) (300,000) (400,000) Use of Committed (PSERS) Fund Balance 440,433 2,000,000 1,340,445 1,110,445 880,445 650,445 420,445 Use of Debt Service Fund Balance 1,000,000 1,000,000 Use of General Fund Balance 488,383 BUDGET SURPLUS/(DEFICIT) (165,836)

• (1,589,432)

(2,759,160) (3,721,477) (4,684,781) Millage Equivalent 0.07

• 0.64

1.10 1.49 1.87 Transfers Out 1,700,000 $ Unassigned Fund Balance Change (1,700,000) (488,383)

• Unassigned Fund Balance

8,103,022 7,614,639 7,614,639 7,614,639 7,614,639 7,614,639 7,614,639 Committed Fund Balance Change (440,433) (2,000,000) (1,340,445) (1,110,445) (880,445) (650,445) (420,445) Committed Fund Balance 6,759,567 4,759,567 3,419,122 2,308,677 1,428,232 777,787 357,342

BOYERTOWN AREA SCHOOL DISTRICT GENERAL FUND 5 YEAR BUDGET PROJECTION 2017-2018 TO 2021-2022

BASD Page 1 6/7/2017

SLIDE 27

6/7/2017 6/13/2017 3.1% Tax Increase Included 2013-2014 2014-2015 2015-2016 2016-2017 2017-2018 $ %

ASN

ACCOUNT NAME ACTUAL ACTUAL ACTUAL BUDGET PROJECTED Difference Difference Property Tax Relief 1,749,435 1,745,690 1,726,887 (18,803)

• 1.08%

611101 CURR RE TAX BALLY 1,161,249 1,204,787 1,249,397 1,297,970 1,408,589 110,619 8.52% 611102 CURR RE TAX BECHTELSVILLE 702,510 732,219 751,897 786,010 813,281 27,271 3.47% 611103 CURR RE TAX BOYERTOWN 3,504,444 3,644,009 3,720,543 3,907,318 4,015,746 108,428 2.77% 611104 CURR RE TAX COLEBROOKDALE 5,639,928 5,966,356 6,131,314 6,475,502 6,675,702 200,200 3.09% 611105 CURR RE TAX DOUG/BKS 3,715,679 3,923,160 4,150,885 4,411,210 4,614,218 203,008 4.60% 611106 CURR RE TAX EARL 3,394,617 3,567,807 3,679,559 3,854,026 3,974,349 120,323 3.12% 611107 CURR RE TAX WASHINGTON 4,890,684 5,085,168 5,222,376 5,457,546 5,757,325 299,779 5.49% 611108 CURR RE TAX DOUG/MTG 12,334,244 12,616,733 13,080,209 13,840,526 14,474,524 633,998 4.58% 611109 CURR RE TAX NEW HANOVER 14,170,362 14,610,798 15,503,106 16,468,014 17,204,818 736,804 4.47% 611110 CURR RE TAX U FREDERICK 4,295,968 4,369,081 4,477,841 4,636,569 4,829,417 192,848 4.16% TOTAL REAL ESTATE TAX LEVY 53,809,685 55,720,118 56,217,694 59,389,001 62,041,082 2,652,081 4.47% 611201 INT RE TAX BALLY 5,619 557

• 2,000

2,000

• 0.00%

611202 INT RE TAX BECHTELSVILLE

• 207

1,000 1,000

• 0.00%

611203 INT RE TAX BOYERTOWN 11,767 308 15,552 3,500 3,500

• 0.00%

611204 INT RE TAX COLEBRK 16,664 3,670 50,289 14,000 14,000

• 0.00%

611205 INT RE TAX DOUG BKS 30,345 6,223 24,236 20,000 20,000

• 0.00%

611206 INT RE TAX EARL 17,504 9,655 13,952 15,000 15,000

• 0.00%

611207 INT RE TAX WASH 48,311 35,560 29,704 90,000 90,000

• 0.00%

611208 INT RE TAX DOUG MONT 35,301 80,465 108,854 60,000 60,000

• 0.00%

611209 INT RE TAX NEW HAN 139,079 241,494 186,949 180,000 180,000

• 0.00%

611210 INT RE TAX U FRED 9,600 11,706 1,417 7,000 7,000

• 0.00%

611300 PUB UTILITY TAX 75,056 78,175 73,753 75,000 75,000

• 0.00%

611400 IN LIEU OF TAX 199 199 199 200 200

• 0.00%

612001 CURR PC TAX 679 BALL 3,415 3,366 3,357 3,200 3,200

• 0.00%

612002 CURR PC TAX 679 BECH 2,597 2,530 2,559 2,500 2,500

• 0.00%

612003 CURR PC TAX 679 BOY 11,176 10,599 10,510 11,000 11,000

• 0.00%

612004 CURR PC TAX 679 COLE 16,916 16,574 16,713 16,800 16,800

• 0.00%

612005 CURR PC TAX 679 DOUGBK 10,670 10,774 10,901 10,700 10,700

• 0.00%

612006 CURR PC TAX 679 EARL 10,535 10,492 10,655 10,500 10,500

• 0.00%

612007 CURR PC TAX 679 WASH 13,442 13,466 13,469 13,100 13,100

• 0.00%

612008 CURR PC TAX 679 DOUGMON 30,893 30,539 31,343 30,600 30,600

• 0.00%

612009 CURR PC TAX 679 NHAN 32,714 32,915 34,040 32,000 32,000

• 0.00%

612010 CURR PC TAX 679 UFRED 10,907 10,336 10,445 10,800 10,800

• 0.00%

614101 CURR PC TAX 511 BALLY 3,415 3,366 3,351 3,200 3,200

• 0.00%

614102 CURR PC TAX 511 BECH 2,597 2,530 2,564 2,500 2,500

• 0.00%

614103 CURR PC TAX 511 BOY 11,176 10,599 10,510 11,000 11,000

• 0.00%

614104 CURR PC TAX 511 COLE 16,916 16,574 16,713 16,800 16,800

• 0.00%

614105 CURR PC TAX 511 DB 10,670 10,774 10,901 10,700 10,700

• 0.00%

614106 CURR PC TAX 511 EARL 10,535 10,492 10,655 10,500 10,500

• 0.00%

614107 CURR PC TAX 511 WASH 13,442 13,466 13,469 13,100 13,100

• 0.00%

614108 CURR PC TAX 511 DGMNT 30,893 30,539 31,343 30,600 30,600

• 0.00%

614109 CURR PC TAX 511 NEWH 32,714 32,915 34,040 32,000 32,000

• 0.00%

BOYERTOWN AREA SCHOOL DISTRICT GENERAL FUND REVENUE PROJECTIONS 2017-2018

Page 1 of 3

SLIDE 28

6/7/2017 6/13/2017 3.1% Tax Increase Included 2013-2014 2014-2015 2015-2016 2016-2017 2017-2018 $ %

ASN

ACCOUNT NAME ACTUAL ACTUAL ACTUAL BUDGET PROJECTED Difference Difference

BOYERTOWN AREA SCHOOL DISTRICT GENERAL FUND REVENUE PROJECTIONS 2017-2018

614110 CURR PC TAX 511 UFRED 10,907 10,336 10,445 10,800 10,800

• 0.00%

614300 OCC PRIV TAX 54,724 66,845 63,491 66,000 66,000

• 0.00%

615100 EARNED INCOME TAX 6,184,691 6,658,255 6,832,550 6,800,000 6,900,000 100,000 1.47% 615301 RE TRANS TAX BERKS 365,121 231,253 460,592 370,000 450,000 80,000 21.62% 615302 RE TRANS TAX MONTG 558,723 708,023 782,376 750,000 800,000 50,000 6.67% TOTAL OTHER TAX REVENUE 7,839,234 8,415,567 8,932,106 8,736,100 8,966,100 230,000 2.63% 641101 DEL RE TAX BALLY

• #DIV/0!

641102 DEL RE TAX BECH

• #DIV/0!

641103 DEL RE TAX BOYER

• #DIV/0!

641104 DEL RE TAX COLE 2,075

• 35

5,000 5,000

• 0.00%

641105 DEL RE TAX DOUBKS

• 910
• #DIV/0!

641106 DEL RE TAX EARL

• 499
• #DIV/0!

641107 DEL RE TAX WASH 4,483 34,225

• 5,000

5,000

• 0.00%

641108 DEL RET DOUG MONT

• 12,971
• #DIV/0!

641109 DEL RE TAX NHAN 13,124

• 10,000

10,000

• 0.00%

641110 DEL RE TAX UFRED

• #DIV/0!

641400 DEL RE TAX BASD 979,891 1,194,820 958,318 1,200,000 1,000,000 (200,000)

• 16.67%

641401 DEL RE TAX COLLECTED ATTORNEY 789,045 924,285 697,711 900,000 850,000 (50,000)

• 5.56%

642001 DEL PC TAX 679 BALLY 193 242 319 300 300

• 0.00%

642002 DEL PC 679 BECH 294 407 344 400 400

• 0.00%

642003 DEL PC TAX 679 BOY 1,125 1,491 1,298 1,400 1,400

• 0.00%

642004 DEL PC TAX 679 COLE 1,227 1,699 1,517 1,600 1,600

• 0.00%

642005 DEL PC TAX 679 DB 710 790 1,076 1,000 1,000

• 0.00%

642006 DEL PC TAX 679 EARL 434 677 680 750 750

• 0.00%

642007 DEL PC TAX 679 WASH 702 965 990 1,000 1,000

• 0.00%

642008 DEL PCT 679 DOUGMONT 2,699 3,332 2,809 3,500 3,500

• 0.00%

642009 DEL PC TAX 679 NHAN 2,716 3,678 3,070 3,500 3,500

• 0.00%

642010 DEL PC TAX 679 UFRED 873 1,258 1,356 1,000 1,000

• 0.00%

644101 DEL PC TAX 511 BALLY 193 242 319 300 300

• 0.00%

644102 DEL PC TAX 511 BECH 294 407 344 400 400

• 0.00%

644103 DEL PC TAX 511 BOY 1,125 1,630 1,298 1,400 1,400

• 0.00%

644104 DEL PC TAX 511 COLE 1,227 1,699 1,517 1,600 1,600

• 0.00%

644105 DEL PC TAX 511 DB 710 790 1,076 1,000 1,000

• 0.00%

644106 DEL PC TAX 511 EARL 434 677 680 750 750

• 0.00%

644107 DEL PC TAX 511 WASH 702 965 990 1,000 1,000

• 0.00%

644108 DEL PCT 511 DOUG MON 2,699 3,193 2,809 3,500 3,500

• 0.00%

644109 DEL PC TAX 511 NHAN 2,716 3,678 3,070 3,500 3,500

• 0.00%

644110 DEL PC TAX 511 UFRED 873 1,258 1,356 1,000 1,000

• 0.00%

TOTAL DEL TAX REVENUE COLLECTED 1,810,564 2,195,379 1,684,388 2,148,900 1,898,900 (250,000)

• 11.63%

651000 EARN FROM INVESTMTS 120,484 138,836 150,553 100,000 151,000 51,000 51.00% 674000 STUDENT ACTIVITIES REVENUE 121,575 140,430 141,267 140,000 270,000 130,000 92.86% 691000 RENT SCH OTH FACIL 159,603 137,676 128,478 160,000 180,000 20,000 12.50% 692000 DONATIONS 3,847 2,872 10,038 3,000 5,000 2,000 66.67% Page 2 of 3

SLIDE 29

6/7/2017 6/13/2017 3.1% Tax Increase Included 2013-2014 2014-2015 2015-2016 2016-2017 2017-2018 $ %

ASN

ACCOUNT NAME ACTUAL ACTUAL ACTUAL BUDGET PROJECTED Difference Difference

BOYERTOWN AREA SCHOOL DISTRICT GENERAL FUND REVENUE PROJECTIONS 2017-2018

694100 TUITION 400

• 1,266

1,000 1,000

• 0.00%

694200 TUITION SUMMER SCHOOL 1,850 12,260 9,900 12,000 10,000 (2,000)

• 16.67%

694202 SUMMER CAMPS 12,725 12,320 22,885 12,000 22,000 10,000 83.33% 694400 RCPTS OTH LEA SRV 10,449

• 1,078

1,000 1,000

• 0.00%

696100 SRVCS OTH GOVT UNIT 10,953 9,767 10,258 7,000 10,000 3,000 42.86% 696000 SERVICES PROVIDED OTHER LEA

• 10,570

11,037 15,000 11,000 (4,000)

• 26.67%

698000 PLANETERIUM REVENUE 10,237 10,539 10,544 10,500 10,500

• 0.00%

699420 NJROTC GRANT 66,800 50,559 70,567 60,000 70,000 10,000 16.67% 699900 MISC REVENUE 7,600 29,453 40,308 43,000 40,000 (3,000)

• 6.98%

699901 SUMMER MUSIC PROGRAM 10,946 12,171 9,775 12,000 11,000 (1,000)

• 8.33%

699902 TAX CERT FEES 14,385 18,089 16,210 15,000 16,500 1,500 10.00% 699903 TAX COLL ADMIN FEE 8,572 9,000 7,670 9,000 8,000 (1,000)

• 11.11%

TOTAL OTHER LOCAL REVENUE 658,582 619,880 702,310 605,500 817,000 211,500 34.93% TOTAL LOCAL REVENUE 64,118,065 66,950,944 67,536,498 70,879,501 73,723,082 2,843,581 4.01% 711000 BASIC INST SUBSIDY 14,077,055 14,076,794 14,376,348 14,499,932 14,953,448 453,516 3.13% 716000 SEC 1305-06 COMMON 119,531 144,853 132,698 117,000 130,000 13,000 11.11% 727100 SP ED SCH AGE PUPILS 3,249,287 3,373,077 3,502,702 3,573,294 3,558,467 (14,827)

• 0.41%

731000 TRANSPORTATION SUBSIDY 2,558,037 2,457,920 2,518,190 2,625,000 2,625,000

• 0.00%

731001 NON-PUBLIC TRANSPORTATION 210,980 212,905 246,015 210,000 210,000

• 0.00%

732000 RENTAL SUBSIDY 966,691 1,020,465 705,169 1,000,000 1,000,000

• 0.00%

733000 HLTH SRV (MED/DENT/NURSE) 135,211 131,226 133,680 134,000 134,000

• 0.00%

734000 TAX RELIEF FUND ACT 1 1,798,299 1,693,326 1,749,435 1,745,690 1,726,887 (18,803)

• 1.08%

781000 REV SOC SEC PAYMTS 1,698,897 1,776,772 1,641,625 1,889,209 1,891,573 2,364 0.13% 782000 REV RETIREMENT PAYMT 3,946,695 5,575,931 6,505,404 8,038,612 8,038,612

• 0.00%

TOTAL STATE REVENUE 28,760,683 30,463,269 31,511,266 33,832,737 34,267,987 435,250 1.29% 934000 DEBT SERV FUND TRANS 7,686 1,000,000 1,000,000 (1,000,000)

• 100.00%

934050 OPERATING TRANSFER FROM FOOD SERV 102,594 102,594 102,594 102,500 102,500

• 0.00%

940000 SALE RE & SER EQUIP 3,325 200 1,500 5,000 5,000

• 0.00%

TOTAL OTHER REVENUE 113,605 102,794 1,104,094 1,107,500 107,500 (1,000,000)

• 90.29%

TOTAL REVENUE 92,992,353 97,517,007 100,151,858 105,819,738 108,098,569 2,278,831 2.15% Page 3 of 3