Transcript Bartlett Fire Protection District

Fox River and Countryside Fire/Rescue District
Financial Analysis
For the 1 Month(s) Ended May 31, 2014
Revenue Highlights
8% of Budget Year
• 9% of Total Budget
• Property Taxes
– Collected 11% of Budgeted Property Taxes (Partial Installment
from Kane County)
• Ambulance Fees
– Collected $20,986 or 7% of Budget
• Rental Revenues
– Collected $2,057 or 9% of Budget
2
Revenues
Account Description
Total Actual
Total Budget
% of Budget
Last Year
Inc/(Dec)
from Last
Year
Property Taxes
256,125
2,351,500
11%
173,113
48%
Interest Income
47
3,000
2%
212
-78%
Personal Property Replacement Tax
2,515
11,000
23%
2,914
-14%
Rental Income
2,057
22,300
9%
2,012
2%
21,196
297,300
7%
20,424
4%
25,100
0%
925
-100%
2,710,200
10%
199,600
Ambulance/CPR Fees
Other Income
-
Subtotal
Debt Proceeds
281,939
-
Transfers-In
-
n/a
-
n/a
-
n/a
79,020
1,110,538
7%
Actual Revenues
360,959
3,820,738
9%
Budgeted Revenues
3,827,238
% Diff
9%
41%
199,600
81%
3
Revenues
Year-to-Date - May
Rental Income
0,7%
Interest Income
0,0%
Fire Recovery
0,0%
Ambulance/CPR
Fees
7,5%
Other Income
0,0%
Personal Property
Replacement Tax
0,9%
Property Taxes
90,8%
4
PBS Collections
Month
May
FY2015
FY2014
20,986
20,424
Jun
20,074
Jul
21,271
Aug
14,834
Sept
28,937
Oct
32,058
Nov
26,924
Collections
35 000
30 000
25 000
FY2015
20 000
Dec
28,223
FY2014
Jan
29,756
15 000
Feb
29,630
10 000
Mar
21,083
April
27,097
Total
300,312
5 000
AVG.
20,986
25,026
Budget Avg.
24,583
23,333
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Jan
Feb
Mar
April
5
Expenditure Highlights
100% of Budget Year
• 8% of Total Budget
• Operating Expenditures
– 7% of Budget
• Fire Services Contract
– 8% of Budget
• Capital Outlay & Debt Service
– 13% of Budget
–
–
Property Taxes $9,761
George Kay & Assoc $23,780
6
Expenditures
Account Description
OPERATING EXPENDITURES
Total Actual
Personnel
% of
Budget
Total Budget
Total Actual
Inc/(Dec)
from Last
Year
18,230
361,500
5%
32,492
-44%
146,107
1,790,883
8%
131,524
11%
1,559
9,800
16%
2,153
-28%
Property Expenses
77
5,650
1%
247
-69%
Public Training and Education
-
3,000
0%
167
-100%
8,666
181,250
5%
20,106
-57%
79,020
1,110,538
7%
Actual Expenditures
253,660
3,462,621
7%
186,689
36%
Budgeted Expenditures
% Diff
DEBT AND CAPITAL EXPENDITURES
3,462,621
7%
384,538
4%
4,960
219%
n/a
77,063
-55%
13%
82,023
-38%
Contractual Services
Office Supplies and Expenses
Fire Station
Transfers-Out
Debt Expenditures
15,846
Capital Outlay
34,970
Actual Expenditures
50,816
Budgeted Expenditures
384,538
% Diff
13%
384,538
-
n/a
Expenditures
Year-to-Date - May
Capital Outlay
15,5%
Personnel
8,1%
Debt Expenditures
7,0%
Fire Station
3,8%
Office Supplies and
Expenses
0,7%
Property Expenses
0,0%
Contractual Services
64,8%
8
Revenue, Expenditure & Fund Balance
For the 1 Month Ended May 31, 2014
General
Ambulance
Debt Service
Emergency and Rescue
Total Actual
TOTAL SURPLUS / (DEFICIT)
107,299
-
(50,816)
-
56,483
BEGINNING FUND BALANCE
238,287
-
-
-
238,287
-
-
-
-
-
345,586
-
(50,816)
-
294,770
Residual Equity Transfer
ENDING FUND BALANCE
300 000
300 000
250 000
250 000
200 000
200 000
150 000
150 000
100 000
100 000
50 000
50 000
-
-
(50 000)
(50 000)
(100 000)
(100 000)
FY2013
Revenues
FY2014
Expenditures
FY2015
Surplus / Deficit
FY2013
Revenues
FY2014
Expenditures
FY2015
Surplus / Deficit
9
Investments
Bank
Description
Current Rate
Bank Balance
BMO Harris
Public Funds Checking #4887
BMO Harris
Business Prime Money Market #7301
0.35%
97,074
BMO Harris
Public Funds Interest Checking #0403
0.16%
18,933
Suburban Bank & Trust
Checking #9767
n/a
5,000
n/a
$
Bank of America
Collateral - Fixed Income Assets
n/a
59,282
180,289
260,573
BMO Harris Public Funds
Checking #4887 n/a
BMO Harris Business Prime
Money Market #7301 0.35%
BMO Harris Public Funds
Interest Checking #0403
0.16%
Suburban Bank & Trust
Checking #9767 n/a
10