Transcript Bartlett Fire Protection District

Fox River and Countryside Fire/Rescue District
Financial Analysis
For the 8 Month(s) Ended December 31, 2014
Revenue Highlights
67% of Budget Year
• 80% of Total Budget
• Property Taxes
– Collected 100% of Budgeted Property Taxes (1st Installment and
2nd from Kane and DuPage County)
• Ambulance Fees
– Collected $174,326 or 59% of Budget
• Personal Property Replacement Taxes
– Collected $8,502 or 77% of Budget
2
Revenues
Account Description
Total Actual
Total Budget
% of Budget
Last Year
Inc/(Dec)
from Last
Year
Property Taxes
2,345,135
2,351,500
100%
2,287,373
3%
Interest Income
1,880
3,000
63%
2,192
-14%
Personal Property Replacement Tax
8,502
11,000
77%
8,900
-4%
Rental Income
8,876
22,300
40%
14,868
-40%
174,326
297,300
59%
194,266
-10%
Fire Recovery
3,328
7,500
44%
Other Income
12,142
25,100
48%
6,811
-100%
2,554,189
2,717,700
94%
2,514,410
2%
430,000
n/a
875,000
n/a
723,527
970,538
75%
714,786
1%
3,277,715
4,118,238
80%
4,104,196
Ambulance/CPR Fees
Subtotal
Debt Proceeds/Sale of Building
-
Transfers-In
Actual Revenues
Budgeted Revenues
% Diff
4,118,238
80%
-
n/a
20%
3
Revenues
Year-to-Date - Dec
Fire Recovery
0.1%
Interest Income
0.1%
Personal Property
Replacement Tax
0.3%
Rental Income
0.3%
Ambulance/CPR
Fees
6.8%
Property Taxes
91.8%
4
PBS Collections
Month
FY2015
FY2014
May
20,986
20,424
Jun
18,661
20,074
Jul
25,571
21,271
Aug
23,493
14,834
Sept
24,679
28,937
Oct
23,026
32,058
Nov
14,360
26,924
Dec
21,161
28,223
Jan
29,756
Feb
29,630
Mar
21,083
April
27,097
Total
AVG.
Budget
Avg.
171,938
300,312
21,492
25,026
24,583
23,333
Expenditure Highlights
67% of Budget Year
• 71% of Total Budget
• Operating Expenditures
– 72% of Budget
• Fire Services Contract
– 65% of Budget
• Capital Outlay & Debt Service
– 33% of Budget
–
–
–
George Kay & Assoc $23,780
Alexis Fire Equipment $30,981
Zoll Medical Corp $17,560
6
Expenditures
Account Description
OPERATING EXPENDITURES
Personnel
Total Actual
Total Budget
% of
Budget
Total Actual
Inc/(Dec)
from Last
Year
231,279
364,000
64%
261,358
-12%
1,271,567
1,790,883
71%
1,132,784
12%
8,356
9,800
85%
19,830
-58%
16,396
13,950
118%
4,358
276%
2,442
3,000
81%
2,283
7%
Fire Station
151,943
176,750
86%
144,281
5%
Transfers-Out
723,527
970,538
75%
714,786
1%
2,405,508
3,328,921
72%
2,279,681
6%
120,036
489,538
25%
211,224
-43%
77,524
100,750
n/a
1,544,373
-95%
197,560
590,288
33%
1,755,597
-89%
Contractual Services
Office Supplies and Expenses
Property Expenses
Public Training and Education
Actual Expenditures
Budgeted Expenditures
% Diff
DEBT AND CAPITAL EXPENDITURES
Debt Expenditures
Capital Outlay
Actual Expenditures
Budgeted Expenditures
% Diff
3,328,921
72%
590,288
33%
Expenditures
Year-to-Date - Dec
Debt Expenditures
6.4%
Capital Outlay
4.1%
Personnel
12.3%
Fire Station, 8.1%
Property Expenses
0.9%
Office Supplies and
Expenses
0.4%
Contractual Services
67.7%
Revenue, Expenditure & Fund Balance
For the 8 Month Ended December 31, 2014
General
Ambulance
Emergency and
Rescue
Debt Service
Total Actual
TOTAL SURPLUS /
(DEFICIT)
872,207
-
(197,560)
-
674,647
BEGINNING FUND
BALANCE
181,661
-
43,771
-
225,432
-
-
-
-
-
1,053,868
-
(153,789)
-
900,079
Residual Equity Transfer
ENDING FUND BALANCE
9
Investments
Bank
Description
BMO Harris
Public Funds Checking #4887
BMO Harris
Current Rate
Bank Balance
n/a
32,883
Business Prime Money Market #7301
0.35%
39,881
BMO Harris
Public Funds Interest Checking #0403
0.16%
652
West Suburban Bank
Money Market Account #1484
0.45%
796,491
West Suburban Bank
Checking #3185
n/a
14,525
Suburban Bank & Trust
Checking #9767
n/a
52,126
963,557
$
Bank of America
Collateral - Fixed Income Assets
Suburban Bank & BMO Harris Public
Funds Checking
Trust Checking
#4887 n/a
#9767 n/a
3.5%
5.6%
West Suburban
Bank Checking
#3185 n/a
1.6%
n/a
BMO Harris
Business Prime
Money Market
#7301 0.35%
4.3%
1,516,629
BMO Harris Public
Funds Interest
Checking #0403
0.16%
0.1%
West Suburban
Bank Money
Market Account
#1484 0.45%
85.0%
10