[PPT] - SCHOOL DISTRICT Bob Schafer Financial Officer, 2 0 1 3 - 2 0 1 4 PowerPoint Presentation

SLIDE 1

2 0 1 3 - 2 0 1 4 B U D G E T P R E S E N T A T I O N

KAUKAUNA AREA SCHOOL DISTRICT

Monday, October 28, 2013 5:30 pm Bob Schafer Financial Officer, KASD

SLIDE 2

2013-2014 BUDGET HEARING OVERVIEW

The procedures which common, union high, and unified school districts should

follow in formulating a budget, holding a public hearing, and adopting a budget are set forth in s. 65.90, Wis. Stats. The steps involved in these required procedures are summarized as follows.

The staff and school board create a proposed budget that identifies expected revenues,

expenditures, and fund balances for the budgeted year in addition to the two fiscal years preceding the budgeted fiscal year. Budget detail is based upon the Wisconsin Uniform Financial Reporting Requirements (WUFAR) hierarchy of accounts.

A class 1 notice (one publication) is published which contains a summary of the proposed budget

described above, notice of where the detailed budget may be examined, and notice of the time and place of the public hearing. Common and union high school districts must hold the budget hearing at the time and place of the annual meeting.

The public hearing is held, at which time, residents of the district have an opportunity to comment
n the proposed budget.
The school board shall adopt an original budget at a school board meeting scheduled after the

public hearing and no later than the meeting in which the school board sets the annual tax levy amount.

For KASD the official 2013-2014 budget hearing and tax levy will be set at the

October 28, 2013, Board of Education meeting.

SLIDE 3

FUND 10 – GENERAL OPERATING FUND BUDGET BASICS

Fund 10
Fund 10 encompasses all general education expenditures

for a Wisconsin public school district. Per DPI, the general fund is used to account for all financial transactions relating to the district’s current operations, except for those required to be accounted for in other funds.

Fund 10 will, in the end, cover any budget shortfalls that may

develop in other funds such as special education (Fund 27) or food service (fund 50).

Fund 10 will make up the District’s Fund Balance at the end of

each fiscal year. Other funds may or may not carry a fund balance but the focus of a district’s carryover money is based in Fund 10.

SLIDE 4

FUND 10 – GENERAL OPERATING FUND REVENUE HISTORY AND PROJECTION

Fund 10 Revenue
Below is summary of District revenues in Fund 10 over the

past six years and the expected revenue for 2013-2014

Figures for the 2013-14 budget shown include over expending

the revenue limit by $520,000 through the use of prior year tax levy carryover funds

$39,191,759 $39,895,159 $41,236,862 $42,305,862 $40,658,986 $39,826,311 $41,230,689 $37,000,000 $38,000,000 $39,000,000 $40,000,000 $41,000,000 $42,000,000 $43,000,000 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14

KASD Fund 10 Revenue History

SLIDE 5

FUND 10 – GENERAL OPERATING FUND 2013-2014 PROJECTED REVENUE

General operating revenue by source
DPI utilizes source codes to standardize among school

districts where funds are received from. Minimum source codes are as follows:

100 Operating transfer in (from one fund to another fund)
200 Revenue from local sources (property tax)
300 Revenue from interdistrict sources (other school districts)
500 Revenue from intermediate sources (CESAs)
600 Revenue from state sources (equalized aid, etc)
700 Revenue from federal sources (Title funds, grants)
900 Other revenues (prior year revenues, refunds, adjustments)

SLIDE 6

FUND 10 – GENERAL OPERATING FUND 2013-2014 PROJECTED REVENUE

2013-14 Fund 10 revenues are budgeted at $41.2 million or $1.4 million more than 2012-13 actuals. $520,000 of the $1.4 million is coming from tax levy carryover from previous years that was not used.

2013-14 2012-13 2011-12 2010-11 Original Budget FY Activity FY Activity FY Activity 100 Operating transfer in 34,628.00 $

0.08%

200 Local sources 14,281,501.99 $

34.64%

14,101,946.83 $

35.41%

13,694,973.63 $

33.68%

12,943,674.20 $

30.60%

300 Intermediate sources 517,791.40 $

1.26%

513,498.00 $

1.29%

377,008.16 $

0.93%

419,761.88 $

0.99%

400 Other revenues 20,000.00 $

0.05%

25,511.90 $

0.06%

25,439.71 $

0.06% 0.00%

600 State sources 25,628,599.00 $

62.16%

23,959,824.94 $

60.16%

24,819,435.49 $

61.04%

27,608,550.98 $

65.26%

700 Federal sources 669,190.73 $

1.62%

876,060.27 $

2.20%

1,633,237.06 $

4.02%

1,127,260.25 $

2.66%

800 Other fed sources

0.00% 0.00%

2,100.00 $

0.01%

92,996.30 $

0.22%

900 Other revenues 113,606.03 $

0.28%

349,469.44 $

0.88%

106,792.02 $

0.26%

78,299.94 $

0.19%

Total Revenue 41,230,689.15 $ 39,826,311.38 $ 40,658,986.07 $ 42,305,171.55 $

KASD - FUND 10 REVENUE BY SOURCE

34.64% 1.26% 0.05% 62.16% 1.62% 0.00% 0.28%

2013-2014 General Fund Revenue By Source

Operating transfer in Local sources Intermediate sources Other revenues State sources Federal sources Other fed sources

SLIDE 7

FUND 10 – GENERAL OPERATING FUND 2013-2014 MAJOR REVENUE CHANGES

Significant changes in Fund 10 revenue from 2012-13 to

2013-14 include:

Property tax levy increase of $165,635
State equalization aid increase of $1,677,885
Recently passed tax relief bill increased this figure by $187,957 over

the original estimate

Charter school grant funding (and associated expenditures)

has been removed from the operating budget ($400,000)

Workers’ compensation insurance dividend adjusted to new

guarantees which cut the revenue by $30,000

$275,000 booked into 2012-13 revenue from the closure of a

Village of Little Chute TIF District – final check came in at $363,000 which pushed $88,000 in revenue to the 2013-14

perating budget
Revenues in Fund 10 show an increase of 3.53% from

2012-13 to 2013-14

SLIDE 8

FUND 10 – GENERAL OPERATING FUND GENERAL OPERATING EXPENDITURES

Fund 10 Expenditures
The 2013-14 general education operating expenditures for

KASD are budgeted at $36,446,019, up from $36,340,003 of actual 2012-13 costs. The budget to actual difference is $106,016 or 0.29% increase.

2012-13 expenditures included $1.1 million for the renovation of Park
School. Removing the Park School cost the 2012-13 general

education expenditures would have been $35,240,003.

Eliminating the Park School capital cost the 2012-13 budget to 2013-

14 actual difference is $1,206,016 or a 3.42% increase.

The Fund 10 operating budget also includes a $4.78 million

transfer to Fund 27, special education, to balance that account.

The 2012-13 actual special education transfer from Fund 10 was

$4,543,725. Given current revenue projections it will cost Fund 10 5.3% more for the transfer of funds to balance the special education account for 2013-14 compared to 2012-13.

SLIDE 9

FUND 10 – GENERAL OPERATING FUND EXPENDITURE HISTORY

The 2013-14 Fund 10 expenditure budget is up $106,016 over the

2012-13 costs.

Salary and benefit costs budgeted for 2013-14 account for 66.93% of the Fund 10

budget which is up from 62.88% in 2012-13.

The capital objects budget, by comparison, is down $455,000 from 2012-13 to 2013-14.

This is a direct result of Park School’s renovation costs.

2013-14

% of Fund

2012-13

% of Fund

2011-12

% of Fund

2010-11

% of Fund

2009-10

% of Fund

2008-09

% of Fund

Expense Object Original Budget 10 budget FY Activity

10 budget

FY Activity

10 budget

FY Activity

10 budget

FY Activity

10 budget

FY Activity

10 budget

100 SALARIES 17,577,039.34 $ 48.23% 16,612,066.56 $ 45.71% 16,208,675.51 $ 48.05% 17,346,129.18 $ 46.61% 17,606,901.57 $ 47.05% 18,274,180.08 $ 51.09% 200 EMPLOYEE BENEFITS 6,816,110.44 $ 18.70% 6,239,411.23 $ 17.17% 7,039,165.31 $ 20.87% 9,078,556.34 $ 24.39% 9,178,649.12 $ 24.53% 8,671,025.55 $ 24.24% 300 PURCHASED SERVICES 9,956,006.54 $ 27.32% 9,964,232.87 $ 27.42% 7,792,146.50 $ 23.10% 8,176,160.02 $ 21.97% 7,755,663.92 $ 20.73% 6,240,927.32 $ 17.45% 400 NON-CAPITAL OBJECTS 1,568,730.50 $ 4.30% 2,552,479.00 $ 7.02% 1,649,508.86 $ 4.89% 1,802,952.73 $ 4.84% 1,595,747.47 $ 4.26% 1,395,945.09 $ 3.90% 500 CAPITAL OBJECTS 198,111.93 $ 0.54% 688,681.78 $ 1.90% 293,532.60 $ 0.87% 295,504.95 $ 0.79% 708,809.76 $ 1.89% 531,896.41 $ 1.49% 600 DEBT RETIREMENT 0.00% 0.00% 318,199.14 $ 0.94% 109,696.69 $ 0.29% 169,110.42 $ 0.45% 289,252.00 $ 0.81% 700 INSURANCE & JUDGMENTS 261,427.00 $ 0.72% 221,893.69 $ 0.61% 322,541.90 $ 0.96% 281,927.20 $ 0.76% 316,359.59 $ 0.85% 267,502.08 $ 0.75% 900 OTHER OBJECTS 68,594.06 $ 0.19% 61,238.33 $ 0.17% 108,223.80 $ 0.32% 124,409.05 $ 0.33% 90,320.20 $ 0.24% 98,148.53 $ 0.27% GENERAL OPERATIONS 36,446,019.81 $ 36,340,003.46 $ 33,731,993.62 $ 37,215,336.16 $ 37,421,562.05 $ 35,768,877.06 $ 800 TRANSFER TO FUND 27 - SPEC ED 4,784,669.34 4,543,725.18 4,357,633.77 4,378,446.13 3,805,957.82 4,062,337.92

FUND 10 - GENERAL EDUCATION OPERATING EXPENDITURES

SLIDE 10

FUND 10 – GENERAL OPERATING FUND 2013-14 EXPENDITURE BY OBJECT (%)

48.23% 18.70% 27.32% 4.30% 0.54% 0.00% 0.72% 0.19%

2013-14 Fund 10 Expenditure by Object

SALARIES EMPLOYEE BENEFITS PURCHASED SERVICES NON-CAPITAL OBJECTS CAPITAL OBJECTS DEBT RETIREMENT INSURANCE & JUDGMENTS OTHER OBJECTS

SLIDE 11

FUND 10 – GENERAL OPERATING FUND 2013-2014 MAJOR EXPENDITURE CHANGES

Significant changes in Fund 10 expenditures from 2012-13 to 2013-14

include:

Salaries have increased $965,000 from 2012-13 actual to 2013-14 budget (5.81%)
+$930,000

Additional teaching staff

+$215,000

Additional administration

$40,000

Summer school teaching staff

$50,000

Maintenance department salary (due to substitute 2012-13)

$36,000

Projected substitute teacher cost (charter school grant)

$ 50,000

Extra time for certified staff (charter school grant)

Benefits associated with payroll have increased by $576,000 (9.24%)
+$285,000

FICA/Medicare/Wisconsin Retirement System

+$155,000

HRA payment projection versus first year cost

+$110,000

Health insurance (3% increase for January – June)

+$ 38,000

Health insurance cost increase due to higher participation

Purchased services have remained flat at $9.9 million
$370,000

Personal services reduction due to charter school $, Park Sch

+$200,000

Maintenance services due to Honeywell energy project

+$400,000

Open enrollment out aid transfer

$150,000

Student transportation

$ 40,000

Payment to FVTC for services rendered

SLIDE 12

FUND 10 – GENERAL OPERATING FUND 2013-2014 MAJOR EXPENDITURE CHANGES

Significant changes in Fund 10 expenditures from 2012-13 to 2013-14

include:

Non-capital equipment budget has been reduced by $873,000 (-38%)
$803,000

General supplies (maintenance dept, charter school purchases)

+$ 8,000

Copy paper projected increase

+$10,000

Uniform purchases acceleration at River View

$225,000

Non-capital equipment reduction (Park School)

+$ 66,000

Textbook adoption

Capital equipment budget is down $490,000 from the 2012-13 expenses (-71%)
$420,000

Reduction in new equipment purchased

$ 72,000

Vehicle replacement

Insurance and judgments show an increase of $40,000 (5.3%)
+$40,000

Work comp insurance cost up

Special education transfer from Fund 10 to fund 27 has increased $240,000

SLIDE 13

FUND 27 – SPECIAL EDUCATION EXPENDITURE REVIEW

Historical perspective
KASD spent $6,962,229 on

special education in 2012-13

The projected

expenditure for 2013-14 in Fund 27 is $7,069,976 or $107,747 more than the actual 2012-13 figure (1.55% increase)

A historical perspective of

special education funding is shown to the right:

$6,603,156 $6,644,046 $7,116,103 $7,128,350 $6,962,229 $7,069,968 $6,300,000.00 $6,450,000.00 $6,600,000.00 $6,750,000.00 $6,900,000.00 $7,050,000.00 $7,200,000.00 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14

SPECIAL EDUCATION EXPENDITURE HISTORY

SLIDE 14

FUND 27 – SPECIAL EDUCATION OPERATING REVENUE

Special education revenue
Special education revenue is from three main sources –

state aid based on the previous year expenditures, federal aid, and a transfer from Fund 10 to cover costs

In general both external areas have flat-lined the amount of

money school districts are receiving over the past decade

A summary of KASD’s special education revenues over the past

three years are shown below plus the projected 2013-14 budget

2013-14 2012-13 2011-12 2010-11 Original Budget FY Activity FY Activity FY Activity 100 Operating transfer in 4,784,669.34 $

67.68%

4,543,724.20 $

65.26%

4,357,633.77 $

61.13%

4,328,446.13 $

60.83%

200 Local sources

$

0.00%

$

0.00%

$

0.00%

$

0.00%

300 Interdistrict sources

$

0.00%

17,713.28 $

0.25%

92,383.93 $

1.30%

62,374.88 $

0.88%

500 Intermediate sources

$

0.00%

39,258.12 $

0.56%

$

0.00%

8,634.23 $

0.12%

600 State sources 1,380,899.44 $

19.53%

1,357,642.00 $

19.50%

1,454,235.00 $

20.40%

1,447,929.00 $

20.35%

700 Federal sources 904,398.98 $

12.79%

1,003,891.74 $

14.42%

1,185,334.46 $

16.63%

1,268,718.63 $

17.83%

800 Other fed sources

0.00% 0.00%

$

0.00%

$

0.00%

900 Other revenues

$

0.00%

$

0.00%

38,762.74 $

0.54%

$

0.00%

Total Revenue 7,069,967.76 $ 6,962,229.34 $ 7,128,349.90 $ 7,116,102.87 $

KASD - FUND 27 REVENUE BY SOURCE

SLIDE 15

FUND 27 – SPECIAL EDUCATION 2013-2014 OPERATING REVENUE

Revenue summary
KASD will fund 67% of

total special education costs for 2013-14 from the Fund 10 budget

The transfer amount has

grown dramatically in the past five year – nearly 7%

ver that time
State sources will pay

19.5% of the special education costs for 2013- 14, federal revenues will be 12.8% of the total budget

Both areas have

decreased steadily which forces the higher transfer into Fund 27 from Fund 10

67.68% 0.00% 0.00% 0.00% 19.53% 12.79% 0.00% 0.00%

2013-2014 Special Education Revenue By Source

Operating transfer in Local sources Interdistrict sources Intermediate sources State sources Federal sources Other fed sources Other revenues

SLIDE 16

FUND 27 – SPECIAL EDUCATION OPERATING EXPENSES

Special education expenditures

budgeted at $7.069 million for 2013-14

76% of Fund 27 costs are for salaries and

benefits

Purchased services include CESA contracted

costs

Just 2% of the total operating budget in

special education is used for supplies and materials

2013-14

% of Fund

2012-13

% of Fund

2011-12

% of Fund

2010-11

% of Fund

2009-10

% of Fund

2008-09

% of Fund

Expense Object Original Budget 27 budget FY Activity

27 budget

FY Activity

27 budget

FY Activity

27 budget

FY Activity

27 budget

FY Activity

27 budget

100 SALARIES 3,927,648.36 $ 55.55% 3,551,829.38 $ 51.02% 3,576,944.96 $ 50.18% 3,827,414.05 $ 53.79% 3,736,641.53 $ 56.24% 3,825,309.30 $ 57.93% 200 EMPLOYEE BENEFITS 1,464,059.21 $ 20.71% 1,355,174.02 $ 19.46% 1,394,053.26 $ 19.56% 1,764,589.27 $ 24.80% 1,525,775.81 $ 22.96% 1,481,343.05 $ 22.43% 300 PURCHASED SERVICES 1,532,035.32 $ 21.67% 1,502,402.47 $ 21.58% 1,787,763.98 $ 25.08% 1,161,199.66 $ 16.32% 1,093,189.97 $ 16.45% 1,005,553.24 $ 15.23% 400 NON-CAPITAL OBJECTS 113,224.87 $ 1.60% 423,847.79 $ 6.09% 249,093.41 $ 3.49% 161,407.51 $ 2.27% 94,232.44 $ 1.42% 122,693.22 $ 1.86% 500 CAPITAL OBJECTS 15,000.00 $ 0.21% 90,845.42 $ 1.30% 77,661.44 $ 1.09% 156,609.16 $ 2.20% 101,071.36 $ 1.52% 49,133.45 $ 0.74% 900 OTHER OBJECTS 18,000.00 $ 0.25% 38,130.26 $ 0.55% 42,832.85 $ 0.60% 44,883.22 $ 0.63% 93,135.18 $ 1.40% 119,123.74 $ 1.80% GENERAL OPERATIONS 7,069,967.76 $ 6,962,229.34 $ 7,128,349.90 $ 7,116,102.87 $ 6,644,046.29 $ 6,603,156.00 $

FUND 27 - SPECIAL EDUCATION OPERATING EXPENDITURES

55.55% 20.71% 21.67% 1.60% 0.21% 0.25%

2013-14 SPECIAL EDUCATION EXPENDITURE % BY OBJECT

SALARIES EMPLOYEE BENEFITS PURCHASED SERVICES NON-CAPITAL OBJECTS CAPITAL OBJECTS OTHER OBJECTS

SLIDE 17

FUND 38 – NON-REFERENDUM APPROVED DEBT SERVICE

Fund 38 Debt Service
Non-referendum debt service is generated by Board of Education

action and accounted for in Fund 38

Fund 38 debt service payments are part of the District’s revenue limit

calculation and directly affect the operating budget

Any reduction in Fund 38 debt service will immediately impact the funds

available to spend on general operations

A historical perspective of Fund 38 debt service is shown below

$316,572.50 $397,283.00 $405,687.77 $332,876.00 $345,021.23 $351,191.50 $378,023.83 $- $50,000.00 $100,000.00 $150,000.00 $200,000.00 $250,000.00 $300,000.00 $350,000.00 $400,000.00 $450,000.00 2007-2008 2008-2009 2009-2010 2010-2011 2011-2012 2012-2013 2013-2014 T a x L e v y

Fund 38 Tax Levy History

SLIDE 18

FUND 38 – NON-REFERENDUM APPROVED DEBT SERVICE

Summary of Fund 38 Debt Service
Wisconsin Retirement System
Issued May 1, 2007, to payoff debt owed to WRS – $2,740,000
Maturity date is March, 2020
Principal owed $1,890,000, principal and interest owed $2,323,943
Qualified School Construction Bond
Issued December 9, 2009, to pay for energy efficiency projects in

the District - $500,000

Maturity date is March, 2020
Principal owed is $350,000 – no interest bond from federal gov
Energy Efficiency Exemption
Issued July 1, 2013, to pay for energy efficiency projects through

Honeywell ESG - $2,000,000

Maturity date is March, 2018
Principal owed is $2,000,000, principal and interest owed is $2,106,798

SLIDE 19

FUND 38 – DEBT SERVICE BUDGET

Fund 38 Budget
Expenditures
2013-2014 expenditures in Fund 38, will be $378,024
Payment is a combination of the three debt service issues
Payment is set by the debt service schedules for each issue
2013-2014 revenues for Fund 38, which cover payments made in

March, 2014, as well as September, 2014, will be $514,973

The increase in revenue is due to the addition of the energy

efficiency project bond issue that begins its repayment schedule

Energy cost savings are scheduled to offset the additional debt

service fees incurred

A carry-over of $237,709 will be on the books as of June 30, 2014.

Those dollars will be used to make the debt payment in September, 2014

SLIDE 20

FUND 38 – NON-REFERENDUM APPROVED DEBT SERVICE PAYMENT SCHEDULE

SLIDE 21

FUND 39 – REFERENDUM APPROVED DEBT SERVICE

Kaukauna High School Debt Service
Total debt service outstanding (principal plus interest) on

Kaukauna High School, which is the only referendum approved debt on the books for the District, $10,467,350

Principal only debt service is $9,560,000
The final debt service payment will take place in March, 2017
The final year in which the referendum approved debt service will have

an impact on the tax levy is 2016-2017

$1.6 million of the energy efficiency project borrowing will be due during

the 2017-2018 fiscal year. This figure, combined with the retirement of KHS debt, will produce a $1.0 million tax levy savings in 2017-2018 or a drop of $0.56 per $1,000 of value on the mill rate

Without major change and debt retirement KASD will see a drop in its

mill rate from $9.41 per $1,000 value to $7.90 per $1,000 value in the next five years

A property paying $1,872 in school tax presently ($200,000 value) would then

pay $1,580

SLIDE 22

FUND 39 – REFERENDUM APPROVED DEBT SERVICE PAYMENT SCHEDULE

SLIDE 23

FUND 49 – CAPITAL PROJECTS

Energy Efficiency Project
The funds borrowed and subsequently spent on the Honeywell

ESG energy efficiency project are accounted for using Fund 49, Capital Projects. Per DPI, school districts must utilize Fund 49 for any major project offset by borrowing.

KASD included $1.0 million in its 2013-2014 operating budget to

cover a portion of the $3.7 million Honeywell project. Approximately $700,000 was spent from District funds during the 2012-2013 fiscal year. The $2.0 million borrowing was received 7/1/13 and used to repay the District for invoices paid to Honeywell in June, 2013.

The June 30, 2014, ending balance in Fund 49 will be $0.00. The

$19,984 left in Fund 49 will be used to pay a portion of the next invoice received from Honeywell.

The District will see an immediate surplus in capital improvement

funds for 2014-2015 as the $1.0 million earmarked for Honeywell in 2013-2014 will be completely spent. $500,000 has been set aside in future year budgets for capital projects.

SLIDE 24

FUND 50 – FOOD SERVICE

Fund Balance Perspective
Food Service fought through a trying 2012-2013 fiscal year
Mandated changes to products that could be used were

implemented by the Federal Government at the start of the 2012-2013 school year. Mandates were modified in January to allow for more “user-friendly” products to return to the menu which created more sales

Food service costs spiked in 2012-2013 along with a large jump

in the cost of transportation of products to the District forced an uptick in overall program cost

The fund balance in food service was set-up to be “bought

down” during the 2012-2013 fiscal year in an attempt to have the District further enhance equipment in the program

SLIDE 25

FUND 50 – FOOD SERVICE

Fund Balance Perspective
Fund 50 can carry a fund balance at the end of each fiscal

year but a school district must have a plan for use of the fund balance in the following year

KASD has made large gains in the past six years on equipment

purchased from the food service fund balance

Replaced lunch tables at ALL elementary school sites
New walk-in cooler at River View
New dishwasher at River View
New oven at KHS, Park School (2013)
New mixer and stand at KHS
Upgraded small equipment/cooking utensils/trays at various sites
Upgraded computers and technology at various sites

SLIDE 26

FUND 50 – FOOD SERVICE

Fund Balance History
The fund balance in food service has been strong over the

past four years which has allowed the District to increase spending on needed equipment

2008-2009

$4,513

2009-2010

$52,174

2010-2011

$129,783

2011-2012

$61,614

2012-2013

$16,792

The trend over the past two years was anticipated based
n purchases but the 2012-2013 ending figure was less than

desired due to decreased sales and increased costs

SLIDE 27

FUND 50 – FOOD SERVICE

2013-2014 Budget
Balanced budget is in place for 2013-2014
Expenditures, revenues set at $1,274,448
Maintenance department salaries and benefits account for $65,002
f the total food service expenditures. The figure is based on 10% of

the salary and benefit costs of each individual employed by the District in the maintenance department

The reasoning behind this is to move the amount out from under

the revenue limit formula and “free” up funds in the general

perating budget
Building Services accounts for $33,500 of the total food service

expense budget. This figure is based on actual hours billed by BSG for work done in the kitchen/cafeteria of each building

Fund balance projected to remain flat at $16,000 on June 30,

2014

SLIDE 28

FUND 72 - SCHOLARSHIPS

Fund 72
KASD holds approximately $170,000 in Fund 72 from which

scholarships are awarded on an annual basis

$4,568 was earned in interest during the 2012-2013 school year

in Fund 72

$3,800 was paid out to scholarship recipients at the conclusion
f the 2012-2013 school year
13 separate scholarship accounts make up Fund 72
$138,000 of the $170,000 is located in three of the 13 accounts
Fund 72 does not account for all scholarship funds that are

paid out on an annual basis only for those that have had money turned over to KASD to be managed

SLIDE 29

FUND 73 – EMPLOYEE BENEFIT TRUST FUND (OPEB)

Wisconsin Act 99
Wisconsin State Statute enacted in 2006 allows school

districts to invest funds for the sake of offsetting costs for future post employment benefits (health insurance, dental insurance, and other contractual agreements)

Legislation requires reporting, on an annual basis, the

following information:

Amount held in the trust account or accounts
Investment return earned during the last fiscal year
Total disbursements made during the previous fiscal year
Name of the investment manager if applicable

SLIDE 30

FUND 73 - REVIEW OF 2012-2013

Trust balance
KASD held $1,971,987 in its Fund 73 Trust Account as of June 30, 2013
The projected post employment benefit liability of the Kaukauna Area School

District is $14,943,000 based on the latest actuarial study

KASD has 13.2% of the unfunded liability covered
KASD earned $15,151.66 in interest on investments held in Fund 73

during the 2012-2013 fiscal year

KASD paid $1,035,576 for post employment health, dental, life, and
ther retiree benefits during 2012-2013
Basically this figure is the pay-as-you-go amount for retired employees and

benefits owed to them based on past contracts

The amount listed comes directly out of the District’s operating budget and is

under the umbrella of the revenue limit

KASD transferred $114,424 more to Fund 73 from Fund 10 which essentially

was available due to unspent Fund 10 dollars

Earnings in Fund 73 will offset the cost of the post employment benefit in the

future thus freeing revenue limit funds to be used in other areas

SLIDE 31

FUND 73 – EMPLOYEE BENEFIT TRUST FUND 2013-2014

Trust Fund Advisor
The Kaukauna Area School District will continue to utilize the services of

CESA 6 and their affiliates for its Fund 73 Employee Benefit Trust investments

KASD employees and former employees with a vested interest in its

Employee Benefit Trust Fund program can, at any time, request documentation on the partnership between KASD and CESA 6 as well as any

ther pertinent information regarding investment accounts
Budget
KASD expenditures for post retirement benefits is budgeted at $1.14

million for 2013-2014

A transfer from Fund 10, General Operations, and Fund 27, Special

Education, to Fund 73 will take place cover OPEB costs

KASD revenues for investment income purposes has been set at

$20,000 for 2013-2014

Post retirement benefit costs directly affect the Fund 10 operating budget of

a school district

SLIDE 32

FUND 80 – COMMUNITY SERVICE FUND

Wisconsin Act 20
Does not change the authority of school boards to establish

a Community Service Fund but it does limit the levy to an amount less than or equal to the amount levied for the 2012-2013 school year in Fund 80

KASD levied $79,373 in Fund 80 last year
KASD utilized the levied funds to pay for police liaison services at

both River View School and Kaukauna High School as well as 50% of the administrative assistant salary and benefit cost in the District Activities Department

Other rule changes with Wisconsin Act 20 include:
Districts have to report to DPI on how funds will be spent
DPI has to publish all Fund 80 levy information on their website and

also send the information to the Joint Committee on Finance

Districts must also report how funds will be spent on their website

SLIDE 33

FUND 80 - PROPOSED BUDGET

2013-2014 Revenue
$79,373.11 tax levy requested to offset Fund 80 expenses
Approximate mill rate impact is $0.05 per $1,000 of property value
A $150,000 property would pay an extra $7.50 due to Fund 80
A $300,000 property would pay an extra $15.00 due to Fund 80
2013-2014 Expenditures
$25,996 toward the cost of the River View police liaison officer
This is roughly 45% of the annual cost
$25,996 toward the cost of the Kaukauna High School police liaison officer
This is roughly 45% of the annual cost
$27,925 to cover 50% of the administrative assistant cost in the District

Activities Office

KASD, at one time, earmarked $15,000 to be levied in Fund 80 and donated those

funds to 1000 Islands for services provided. KASD now pays 1000 Islands directly out

f Fund 10 as the donation for services does not meet Fund 80 criteria.
Fund balance
The 2012-2013 ending fund balance of $544.82 will be used to offset 2013-

2014 costs

SLIDE 34

KASD – OVERALL OPERATING BUDGET 2013-2014

Revenues vs. Expenditures
Projected 2013-2014 revenues for KASD total $55,862,026
Projected 2013-2014 expenditures are $53,870,477
The surplus of $1,991,549 is due to the receipt of revenues for the

Energy Efficiency Project on 7/1/2013 while the expenditures tied to those funds took place during the previous fiscal year

The surplus will offset the Fund 49 over expenditure amount of 2012-

2013 and balance Fund 49

The District is operating with a balanced 2013-2014 budget should

the Board of Education decide to use $520,000 of the tax levy carryover amount from 2012-2013

SLIDE 35

2013-2014 PROPERTY TAX LEVY KAUKAUNA AREA SCHOOL DISTRICT

The Board of Education must set the FY 2013-2014

tax levy no later than November 6, 2013

The tax levy must be delivered to the clerk of each

municipality no later than November 10, 2013

School district’s levy taxes for general operations,

debt service, capital expansion, and community service

KASD will levy 2013-2014 taxes for all of the above less

capital expansion

Property values are equalized to reflect market

value rather than local assessed value

SLIDE 36

2013-2014 PROPERTY TAX LEVY KAUKAUNA AREA SCHOOL DISTRICT

All Wisconsin public school districts use the same

formulas in the development of the tax levy

Laws regarding maximum taxation by school districts were

set in 1993

Key components to the tax levy
Pupil count
Equalized aid
Property valuation
Debt service
State imposed revenue limit
Prior year carryover of revenue limit funds

SLIDE 37

2013-2014 PROPERTY TAX LEVY PUPIL COUNT

Pupil count
FTE is shown and includes

school year and summer school combined

District has shown a slow

but steady increase over the past decade in FTE

FTE does not dictate the

number of students being educated by KASD due to

pen enrollment
FTE does include students

being educated by other districts but counted by KASD for aid purposes

KASD Enrollment History Year

% Chg

FTE 1992-93 3069 1993-94

3.71%

3183 1994-95

1.01%

3215 1995-96

3.92%

3341 1996-97

1.50%

3391 1997-98

1.62%

3446 1998-99

0.49%

3463 1999-00

0.09%

3460 2000-01

1.88%

3525 2001-02

3.35%

3643 2002-03

2.28%

3726 2003-04

2.25%

3810 2004-05

0.79%

3840 2005-06

0.78%

3870 2006-07

5.04%

4065 2007-08

1.43%

4123 2008-09

0.34%

4137 2009-10

0.94%

4176 2010-11

1.05%

4220 2011-12

0.69%

4249 2012-13

1.46%

4311 2013-14

0.44%

4386

SLIDE 38

2013-2014 PROPERTY TAX LEVY EQUALIZATION AID

Why the increase?
Operating expenditures
utweighed operating

revenues by $700,000 for 2012-13 which produces an increase in state aid

KASD will qualify for tertiary

(third level) aid for the first time in a few years given the overspending in 2012-13

The State of Wisconsin has

given more funds to schools compared to the 2012-2013 school year

As noted in the chart, major

changes in equalization aid take place annually

Fiscal Year Equalization Aid +/- $ % Chg 2002-2003 20,339,750.00 $ 2003-2004 20,970,103.00 $ 630,353.00 $ 3.10% 2004-2005 21,314,517.00 $ 344,414.00 $ 1.64% 2005-2006 22,731,637.00 $ 1,417,120.00 $ 6.65% 2006-2007 24,831,069.00 $ 2,099,432.00 $ 9.24% 2007-2008 25,783,964.00 $ 952,895.00 $ 3.84% 2008-2009 23,918,199.00 $ (1,865,765.00) $

7.24%

2009-2010 25,290,346.00 $ 1,372,147.00 $ 5.74% 2010-2011 27,220,836.00 $ 1,930,490.00 $ 7.63% 2011-2012 24,503,894.00 $ (2,716,942.00) $

9.98%

2012-2013 23,650,940.00 $ (852,954.00) $

3.48%

2013-2014 25,328,795.00 $ 1,677,855.00 $ 7.09% Equalization Aid History

SLIDE 39

2013-2014 PROPERTY TAX LEVY PROPERTY VALUATION

Equalized valuation is a factor in the tax levy in the

following ways:

Equalized property value sets the final primary, secondary,

and tertiary equalization aid number

Equalized property value is the denominator in figuring out

mill rate (amount taxed per $1,000 of equalized valuation)

For example, KASD taxed $16,690,493 in FY 2012-2013 with and

equalized value of $1,788,398,439

$16,690,493/$1,788,398,439 = 0.00933 per $1.00 of property value or

$9.33 per $1,000

A 1% increase in property valuation ($1,806,282,423) with the same

tax would yield a mill rate of $9.24 per $1,000

SLIDE 40

2013-2014 PROPERTY TAX LEVY PROPERTY VALUATION

County Taxation District Equalized Value % of District

Brown

T. Holland

64,360,647.00 $ 3.60% Calumet

C. Kaukauna

46,500.00 $ 0.00% Calumet

T. Harrison

70,568,519.00 $ 3.95% Calumet

T. Woodville

30,958,530.00 $ 1.73% Calumet

V. Harrison

73,959,046.00 $ 4.14% Calumet

V. Sherwood

212,808,455.00 $ 11.90% Outagamie C. Kaukauna 873,869,600.00 $ 48.86% Outagamie T. Buchanan 108,236,129.00 $ 6.05% Outagamie T. Kaukauna 46,951,709.00 $ 2.63% Outagamie T. Vandenbroek 134,212,600.00 $ 7.50% Outagamie V. Combined Locks 74,720,900.00 $ 4.18% Outagamie V. Little Chute 145,978,751.00 $ 8.16% Total Value 1,836,671,386.00 $ Kaukauna Area School District - Equalized Valuation 2013-2014 3.50% 0.00% 3.84% 1.69% 4.03% 11.59% 47.58% 5.89% 2.56% 7.31% 4.07% 7.95%

Kaukauna Area School District Equalized Valuation by %

T. Holland
C. Kaukauna
T. Harrison
T. Woodville
V. Harrison
V. Sherwood
C. Kaukauna
T. Buchanan
T. Kaukauna
T. Vandenbroek
V. Combined Locks
V. Little Chute

SLIDE 41

2013-2014 PROPERTY TAX LEVY DEBT SERVICE

Fund 38 (non-referendum debt)
2013-2014 tax levy is $514,973
Wisconsin Retirement System = $306,092 (2020)
Energy efficiency project = $158,881 (2018)
Qualified school construction bond = $50,000 (2020)
When debt service is paid off funds will be shifted to the general operating

budget for use as debt is part of the revenue limit

Fund 39 (referendum debt)
2013-2014 tax levy is $2,547,975 or 15.14% of the total levy
Tax levy is for Kaukauna High School; payoff of $9,560,000 principal is slated

for 2017

Fund 39 debt service is a direct tax; upon final payment and without another

referendum KASD will reduce the tax levy by approximately $2.5 million per year

With the end in site regarding Fund 39 debt service the Board of Education

and District leadership will have to be mindful that a drop in the mill rate of approximately $2.50/$1,000 will take place after KHS is paid for and the energy efficiency project leaves the books (2018)

SLIDE 42

2013-2014 PROPERTY TAX LEVY REVENUE LIMIT

History
Wisconsin Act 16 implemented revenue limits beginning with the 1993-94 school
year. A district's revenue limit is the maximum amount of revenue that may be

raised through state general aid and property tax for the General, Non- Referendum Debt (authorized after August 12, 1993), and Capital Expansion Funds, also referred to as Funds 10, 38, and 41 respectively

Key components to the revenue limit
Prior year equalized aid, computer aid, and debt service build a

“base”

Three year rolling pupil average
Current year equalized property value
Allowable per pupil increase
KASD utilizing the “floor” amount of $9,100 per student for 2013-2014
This is an increase to KASD per pupil value of $238.00 over 2012-2013 and is a result of

KASD being an under spending district in the eyes of DPI

Prior year carryover (non-taxed amount from previous year)
One year limitation on taxes but the carryover will continue to the next fiscal year based
n the new carryover amount
Equalization aid

SLIDE 43

2013-2014 PROPERTY TAX LEVY REVENUE LIMIT

Major 2013-2014 revenue

limit changes

KASD utilizing the “floor”

amount set at $9,100 by DPI to calculate the District’s revenue limit

Projected a 26 student

increase – turned out to be 75

verall
Property value has been

increased by $24 million over the previous year based on Department of Revenue figures

Final property values will be set in

early October and released by DPI

Figure shown does not include

untaxed dollars from 2012-2013

District has $1.4 million “on the

table” that could be levied over and above the revenue limit

Every $0.05 increase in the tax levy

will generate an additional $100,000 of revenue limit funds to spend

Fiscal Year Revenue Limit +/- $ % Chg 2002-2003 28,187,010.00 $ 2003-2004 29,617,905.00 $ 1,430,895.00 $ 5.08% 2004-2005 30,939,704.00 $ 1,321,799.00 $ 4.46% 2005-2006 32,598,213.00 $ 1,658,509.00 $ 5.36% 2006-2007 34,496,728.00 $ 1,898,515.00 $ 5.82% 2007-2008 36,529,634.00 $ 2,032,906.00 $ 5.89% 2008-2009 38,126,348.00 $ 1,596,714.00 $ 4.37% 2009-2010 39,398,745.00 $ 1,272,397.00 $ 3.34% 2010-2011 40,087,672.00 $ 688,927.00 $ 1.75% 2011-2012 38,236,467.00 $ (1,851,205.00) $

4.62%

2012-2013 37,782,752.00 $ (453,715.00) $

1.19%

2013-2014 39,266,500.00 $ 1,483,748.00 $ 3.93% Revenue Limit History

SLIDE 44

DISTRICT:

1. 2012-13 Base Revenue (Funds 10, 38, 41)

(from left)

37,782,752

2. Base Sept Membership Avg (10+.4ss, 11+.4ss, 12+.4ss/3)

(from left)

4,260

2012-13 General Aid Certification (12-13 Line 12A, src 621)

+

23,650,910 3. 2012-13 Base Revenue Per Member (Ln 1 / Ln2)

(w ith cents)

8,869.19

2012-13 Computer Aid Received (12-13 Line 17, Src 691)

+

39,221 4. 2013-14 Per Member Change (A+B) 230.81

2012-13 Hi Pov Aid (12-13 Line 12B, src 628)

+

A. Allowed Per Pupil Change (+$0.00/Member)

75.00

2012-13 Fnd 10 Levy Cert (12-13 Line 18, Src 211)

+

13,746,309

B. Low Rev Incr ((9,100 - (3 + 4A))-4C) Not < 0

155.81

2012-13 Fnd 38 Levy Cert (12-13 Line 14B, Src 210)

+

346,312

C. Low Rev Dist in CCDEB (Enter DPI Adjustment)

0.00

2012-13 Fnd 41 Levy Cert (12-13 Line 14C, Src 210)

+

0 5.

2013-14 Maximum Revenue / Memb (Ln 3 + Ln 4)

9,100.00

2012-13 Aid Penalty for Over Levy (12-13 FINAL Rev Limit Worksheet)

0 6.

Current Membership Avg (11+.4ss, 12+.4ss, 13+.4ss/3)

(from left)

4,315

2012-13 Penalty for Unspent Energy Exemption (12-13 FINAL Rev Limit -

0 7.

2013-14 Rev Limit, No Exemptions (Ln7A + Ln 7B)

(rounded)

39,266,500

2012-13 Total Levy for All Levied Non-Recurring Exemptions*

A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6)

39,266,500

NET 2012-13 Base Revenue (LINE 1)

=

37,782,752

B. Hold Harm Non-Recurr Exemption

8. Total Recurring Exemptions (A+B+C+D+E+F)

(rounded)

1,416,334

A. Prior Year Carryover

1,416,334

B. Transfer of Service (if negative, include sign)
C. Transfer of Territory (if negative, include sign)
D. Federal Impact Aid Loss (2011-12 to 2012-13)
E. Recurring Referenda to Exceed (If 2013-14 is first year)

0 <<Enter if not pre-filled Line 2: Base Avg:(10+.4ss)+(11+.4ss)+(12+.4ss) / 3 = 4,260 9.

2013-14 Limit with Recurring Exemptions (Ln 7 + Ln 8)

40,682,834 2010 2011 2012

10. Total 2013-14 Non-Recurring Exemptions (A+B+C+D)

Summer fte:

95 66 81

A. Non-Recurring Referenda to Exceed 2013-14 Limit

0 <<Enter if not pre-filled % (40,40,40) 38 26 32

B. Declining Enrollment Exemption for 2013-14 (from left)

Sept fte: 4,182 4,223 4,278

C. Energy Efficiency Exemption for 2013-14

0 <<Enter if not pre-filled Total fte 4,220 4,249 4,310

D. Adjustment for Refunded or Rescinded Taxes for 2013-14
E. Prior Year Open Enrollment (uncounted pupils)

Line 6: Curr Avg:(11+.4ss)+(12+.4ss)+(13+.4ss) / 3 = 4,315 11. 2013-14 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 40,682,834 2011 2012 2013

12. Total Aid to be Used in Computation (12A + 12B)

25,329,722

Summer fte:

66 81 83

A. 2013-14 - July 1st Estimate of General Aid

25,329,722 % (40,40,40) 26 32 33

B. State Aid to High Poverty Districts (not all dists)

Sept fte: 4,223 4,278 4,353 Total fte 4,249 4,310 4,386

13. Allowable Limited Revenue: (Line 11 - Line 12)

15,353,112

(10, 38, 41 Levies + Src 691. Src 691 is DOR Computer Aid.)

Line 10B: Declining Enrollment Exemption =

14. Total Limited Revenue To Be Used (A+B+C)

Not >line 13 14,456,778 Average FTE Loss (Line 2 - Line 6, if > 0)

Entries Required Below: Amnts Needed by Purpose and Fund:

X 1.00

=

A. Gen Operations: Fnd 10 including Src 211 & Src 691

13,941,805

(Proposed Fund 1 0)

X (Line 5, Maximum 2013-2014 Revenue per Memb) =

B. Non-Referendum Debt (inside limit) Fnd 38 Src 210

514,973

(to Budget Rpt)

Non-Recurring Exemption Amount:

C. Capital Exp, Annual Meeting Approved: Fnd 41 Src 210

(to Budget Rpt)

15. Total Revenue from Other Levies

(A+B+C+D): 2,627,348 Line 17: State Aid for Exempt Computers = 30,786

A. Referendum Apprvd Debt (Non Fund 38 Debt-Src 210)

2,547,975

Line 17 = A X (Line 16 / C) (to 8 decimals)

(Rounds to Dollar)

B. Community Services (Fnd 80 Src 210)

79,373

(to Budget Rpt)

2013 Property Values (estimate until Oct '13 values ar

C. Prior Year Levy Chargeback (Src 212)

(to Budget Rpt)

A. 2013 Exempt Computer Property Valuation

Required

+

3,315,700 D. Other Levy Revenue - Milwaukee & Kenosha Only

(to Budget Rpt)

B. 2013 TIF-Out Tax Apportionment Equalized Valuation

+

1,836,671,386 16. Total Levy + Src 691, "Proposed Levy" (Ln 14 + Ln 15)

1 4,425,992

17,084,126

C. 2013 TIF-Out Value plus Exempt Computers (A + B)

=

1,839,987,086 17. Est Src 691 (Comp Aid) Based on Ln 16 & Values Entered

(to Budget Rpt)

30,786 Computer aid replaces a portion of proposed Fund 10 Levy

18. Fnd 10 Src 211 (Ln 14A-Ln 17), 2013-14 Budget

13,911,019 Line 18 (not 14A) is the Fund 10 Levy certified by the Board.

19. Total Fall, 2014 All Fund Tax Levy (14B + 14C + 15 + 18)

17,053,340 Line 19 is the total levy to be apportioned in the PI-401.

Levy Rate = 0.00928492

20. Fund 30 Src 210 (38 + Non-38) (Ln 14B + Ln 15A)

3,062,948

REMEMBER TO WAIT FOR THE OCT 15th AID CERT BEFORE SETTING THE 2013-14 LEVY

*For 1 2-1 3 Non-Recurring Exemptions Levy Amount, enter actual amount fo r which district levied ; (7B Hold Harmless, Non-Recurring Referenda, Declining Enrollment, Energy Efficiency Exemption, Refunded/Rescinded Taxes)

2013-2014 Revenue Limit Worksheet

Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%.

Line 1 Amount May Not Exceed Line 9 minus Line 7B of Final 12-13 Revenue Limit

September & Summer FTE Membership Averages

DATA AS OF 7/1/2013

SLIDE 45

2013-2014 PROPERTY TAX LEVY PRIOR YEAR CARRYOVER

Carryover
The State of Wisconsin allows school districts to over expend

the revenue limit through the use of prior year carryover funds

Prior year carryover is essentially money left “on the table” by a

school district if that district did not tax to the full amount allowed under the revenue limit the previous year

KASD “under levied” in 2012-2013 by $1.4 million
The “under levy” created a mill rate of $9.33 per $1,000 of value for 2012-

2013

A full levy, meaning adding the $1.4 million to the tax roll, would have

pushed the mill rate to $10.13 per $1,000 of value for 2012-2013

The District taxed a $150,000 property at $1,399.50 in 2012-2013 when it

could have taxed the same property at $1,519.50 or $120 more

As it stands the practice allowing school districts to “chargeback”

for an under levy per the revenue limit is not expected to change

SLIDE 46

2013-2014 PROPERTY TAX LEVY PRIOR YEAR CARRYOVER

KASD Carryover Allocation
The Kaukauna Area School District will use a portion of the

2012-2013 carryover to offset costs in the 2013-2014 operating budget

KASD has carryover of up to $1.4 million to tax and spend during the

2013-2014 school year

KASD is looking to spend $520,000 of the carryover amount on Fund

10 expenditures in the current fiscal year

Any unspent carryover funds will be moved forward to the 2014-

2015 operating budget and used if necessary

Carryover funds used are a direct tax to a school district
For KASD the $520,000 carryover will add $0.29 per $1,000 of

property value to the mill rate

For a $150,000 property the carryover will cost the taxpayer an additional

$42.00 for 2013-2014 over what the base levy would have been

SLIDE 47

2013-2014 PROPERTY TAX LEVY BOARD OF EDUCATION DECISION

Various and unending scenarios
The Board of Education must set a tax levy by the end of October.

Untaxed funds from previous fiscal years has created the potential for many varied scenarios with regards to the total tax levy and mill rate. The chart below summarizes the District’s total tax levy

ver the past 18 years.

$10,386,064 $8,197,384 $9,788,117 $9,805,537 $10,057,678 $10,147,210 $10,115,350 $10,595,734 $11,403,684 $12,380,236 $12,612,833 $12,322,395 $13,498,368 $13,912,548 $15,322,775 $15,524,222 $16,210,408 $16,690,494 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000

Kaukauna Area School District Tax Levy History

SLIDE 48

2013-14 Carryover $ Tax Levy Equalized Value Mill Rate

75,000.00 $ 100,000.00 $ 125,000.00 $ 150,000.00 $ 200,000.00 $ 250,000.00 $ 300,000.00 $ 500,000.00 $ 1,000,000.00 $ 2,000,000.00 $ 3,000,000.00 $ 4,000,000.00 $

2013-14 Remaining 2012-13

16,690,493.96 $ 1,788,398,439.00 $

9.33 $ 699.95 $ 933.26 $ 1,166.58 $ 1,399.90 $ 1,866.53 $ 2,333.16 $ 2,799.79 $ 4,666.32 $ 9,332.65 $ 18,665.30 $ 27,997.95 $ 37,330.59 $ Deficit or Maximum =

Impact on tax levy shown if property value is:

75,000.00 $ 100,000.00 $ 125,000.00 $ 150,000.00 $ 200,000.00 $ 250,000.00 $ 300,000.00 $ 500,000.00 $ 1,000,000.00 $ 2,000,000.00 $ 3,000,000.00 $ 4,000,000.00 $

Surplus 1,416,334 $ 1 16,535,202.00 $ 1,836,671,386.00 $ 9.00 $ (24.74) $ (32.98) $ (41.23) $ (49.48) $ (65.97) $ (82.46) $ (98.95) $ (164.92) $ (329.84) $ (659.68) $ (989.52) $ (1,319.36) $

$
$

2 16,645,202.00 $ 1,836,671,386.00 $ 9.06 $ (20.25) $ (26.99) $ (33.74) $ (40.49) $ (53.99) $ (67.49) $ (80.98) $ (134.97) $ (269.95) $ (539.90) $ (809.85) $ (1,079.79) $ 110,000.00 $ 1,306,334.00 $ 3 16,755,202.00 $ 1,836,671,368.00 $ 9.12 $ (15.75) $ (21.01) $ (26.26) $ (31.51) $ (42.01) $ (52.51) $ (63.02) $ (105.03) $ (210.06) $ (420.11) $ (630.17) $ (840.23) $ 220,000.00 $ 1,196,334.00 $ 4 16,855,202.00 $ 1,836,671,386.00 $ 9.18 $ (11.67) $ (15.56) $ (19.45) $ (23.34) $ (31.12) $ (38.90) $ (46.68) $ (77.81) $ (155.61) $ (311.22) $ (466.83) $ (622.44) $ 320,000.00 $ 1,096,334.00 $ 5 16,955,202.00 $ 1,836,671,368.00 $ 9.23 $ (7.59) $ (10.12) $ (12.65) $ (15.17) $ (20.23) $ (25.29) $ (30.35) $ (50.58) $ (101.16) $ (202.33) $ (303.49) $ (404.66) $ 420,000.00 $ 996,334.00 $ 6 17,054,265.00 $ 1,836,671,386.00 $ 9.29 $ (3.54) $ (4.72) $ (5.90) $ (7.08) $ (9.45) $ (11.81) $ (14.17) $ (23.61) $ (47.23) $ (94.46) $ (141.69) $ (188.91) $ 519,063.00 $ 897,271.00 $ 7 17,154,265.00 $ 1,836,671,368.00 $ 9.34 $ 0.54 $ 0.72 $ 0.90 $ 1.08 $ 1.44 $ 1.80 $ 2.17 $ 3.61 $ 7.22 $ 14.44 $ 21.65 $ 28.87 $ 619,063.00 $ 797,271.00 $ 8 17,254,265.00 $ 1,836,671,386.00 $ 9.39 $ 4.62 $ 6.17 $ 7.71 $ 9.25 $ 12.33 $ 15.42 $ 18.50 $ 30.83 $ 61.66 $ 123.33 $ 184.99 $ 246.66 $ 719,063.00 $ 697,271.00 $ 9 17,354,265.00 $ 1,836,671,368.00 $ 9.45 $ 8.71 $ 11.61 $ 14.51 $ 17.42 $ 23.22 $ 29.03 $ 34.83 $ 58.06 $ 116.11 $ 232.22 $ 348.33 $ 464.44 $ 819,063.00 $ 597,271.00 $ 10 17,454,265.00 $ 1,836,671,386.00 $ 9.50 $ 12.79 $ 17.06 $ 21.32 $ 25.58 $ 34.11 $ 42.64 $ 51.17 $ 85.28 $ 170.56 $ 341.11 $ 511.67 $ 682.23 $ 919,063.00 $ 497,271.00 $ 11 17,554,265.00 $ 1,836,671,368.00 $ 9.56 $ 16.88 $ 22.50 $ 28.13 $ 33.75 $ 45.00 $ 56.25 $ 67.50 $ 112.50 $ 225.00 $ 450.01 $ 675.01 $ 900.01 $ 1,019,063.00 $ 397,271.00 $ 12 17,654,265.00 $ 1,836,671,386.00 $ 9.61 $ 20.96 $ 27.94 $ 34.93 $ 41.92 $ 55.89 $ 69.86 $ 83.83 $ 139.72 $ 279.45 $ 558.90 $ 838.35 $ 1,117.80 $ 1,119,063.00 $ 297,271.00 $ 13 17,754,265.00 $ 1,836,671,386.00 $ 9.67 $ 25.04 $ 33.39 $ 41.74 $ 50.08 $ 66.78 $ 83.47 $ 100.17 $ 166.95 $ 333.90 $ 667.79 $ 1,001.69 $ 1,335.58 $ 1,219,063.00 $ 197,271.00 $ 14 17,854,265.00 $ 1,836,671,386.00 $ 9.72 $ 29.13 $ 38.83 $ 48.54 $ 58.25 $ 77.67 $ 97.09 $ 116.50 $ 194.17 $ 388.34 $ 776.68 $ 1,165.03 $ 1,553.37 $ 1,319,063.00 $ 97,271.00 $ 15 17,951,536.00 $ 1,836,671,386.00 $ 9.77 $ 33.10 $ 44.13 $ 55.16 $ 66.20 $ 88.26 $ 110.33 $ 132.39 $ 220.65 $ 441.30 $ 882.60 $ 1,323.91 $ 1,765.21 $ 1,416,334.00 $

$

Administration request for tax levy amount 2013-2014 Revenue limit tax amount for 2013-14. BoE would Maximum allowed tax levy 2013-14. Amount includes revenue utilize none of the carryover amount if taxing at this limit tax as well as full carryover amount from 2012-13. Property Valuation

Potential Tax Levy Values and Implications To Property Owner

Kaukauna Area School District

SLIDE 49

2013-2014 Budget Hearing Action Items

 The Board of Education for the Kaukauna Area School

District must take action on the 2013-2014 budget and tax levy.

 Action Item #1 – The Kaukauna Area School District sets

the 2013-2014 tax levy at $17,054,265. The levy includes $13,911,944 for general operations, $3,062,948 for debt service, and $79,373 for community service. The tax levy sets the mill rate at $9.29 per $1,000 of property value.

 Action Item # 2 – The Kaukauna Area School District sets

the 2013-2014 operating revenue budget at $55,862,026 and the 2013-2014 operating expenditure budget at $53,870,477.

 Operating expenses and revenues shown include a $4,784,669

transfer from Fund 10 to Fund 27 to cover the cost of special education not funded through state or federal sources.