HomeMy WebLinkAboutFND-005-02
&
.
CJ~-ilJgton
REPORT
FINANCE DEPARTMENT
Meeting:
GENERAL PURPOSE AND ADMINISTRATION COMMITTEE
,; ',.
.7
.,;-...........
Date:
MONDAY, MARCH 4, 2002
FND-005-02 File #: fK)CH
By-law #:
Report #:
Subject:
CASH ACTIVITY - DECEMBER 2001
Recommendations:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report FND-005-02 be received;
2. THAT in accordance with provision of Chapter M-45, Section 79 (1) of the
Municipal Act, R.S.O. 1990, the Treasurer reports the cash position of the
Municipality of Clarington for the month ended December 31 2001, is as shown
on the attached schedule; and
3. THAT Part "A" of the expenditures for the month of December 2001 be
confirmed.
Submitted by:
Reviewed bYO t~ --=:; (~
Franklin Wu,
Chief Administrative Officer.
NT/LG/hjl
1301
REPORT NO.: FND-005-02
PAGE 2
BACKGROUND AND COMMENT:
The attached schedules indicate the Corporation of the Municipality of Clarington's cash
transactions, the cash investment position, development charges information and statistical
information for the month ended December 31 2001 and the comparative information for the
month ended December 31, 2000.
Attachments:
Attachment A - Analysis of Revenue and Expenditures
Attachment B - Continuity of Taxes Receivable
Attachment C - Statistical Information
Attachment D -Investments Outstanding
Attachment E - Development Charges Information
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
40 TEMPERANCE STREET, BOWMANVILLE, ONTARIO L 1C 3A6 T (905)623-3379 F (905)623-0608
1302
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
Analysis of Revenue and Expenditures
for the Month of December 2001
REVENUE RECEIVED FOR GENERAL OPERATING
AND RESERVE FUND PURPOSES:
TAX PAYMENTS RECEIVED
FEDERAL GOV'T WASTE MGMT STUDY--PORT GRANBY
SALE OF LAND
ORONO ATHLETIC ASSOCIATION.REPAYMENT OF LOAN
BOWMANVILLE HERITAGE BOOK SALES
DEVELOPMENT CHARGES-TOWN
GENERAL
INTEREST
DEVELOPMENT CHARGES.SCHOOL BOARD
DEVELOPMENT CHARGES-REGION/PUC
SE OF FUNDS:
PAYROLL
REGION LEVY
SCHOOL BOARD LEVIES
GENERAL-INCLUDING CAPITAL EXP."
NET CASH PROVIDED (USED)
FINANCIAL POSITION:
GENERAL FUND
RESERVE FUND
MUNICIPAL BOND INVESTMENTS
HOST COMMUNITY FUND IN TRUST
INVESTMENTS (GENERAL + RESERVE FUNDS)
TOTALS
PP8pM~pA DECEMBER
. ":2001 2000
1,392,104
25,000
29,100
25,000
1,293
448,395
248,037
262,131
72,978
654,900
. .- . - , - , - . . , - . - . - - . -. , .
.-.,......-'.
',"-...-",-.',",-.',','.
'-' -."...."
.. . . . . - ' - . - - . . - . . - . . . . .
'." .....-..
'-' .-."......
.j.(j!;S3,2\l5
3,158,938
. .:. . . -. . . -. , ,-.
......-..-..,-.-,.,..-.
. -.........
.-.-.'.-.....
'-',"'-'-'-'-"'-'-.'
'--'-'-"',"
. ..,-.-.-.-,.',..
..-.--...."..
......-...-..,....-.
. '-"""'"
..,....-.-.-.-.-.-,..-.
'-' ,""""
.......-...-..,.,..-.
'- ,."....
,',--.,',",-.-,','.-,-.
'-' ...."..
. . - ". - - - . - ' . . . . . ' - - .
.... .."....
",'-'--""""
.......,.,-..,.,..-.
'- ..".".
..,','.-,','.',-.-.
j:~~*,t!i~
1:~9Pi~t
~;~?"pl~1
3:38'3:~j<a
995,636
1,765,635
5,558,200
2,322,095
....-.-...-.-.-.-.._.,-.
.-.-.-.-....-..
..._.-,-.-.---.-.,
.';;:,:,;;:,:';;:,:::;:,
iK237liilp 10,641,566
.. ...."..
.-.-.-.-....'...
._..._.-.-.-,-,-.-.-.
..-.-..-.-...-.-'..-.
..-....'."..
::",-::,.;-:-,-;,:".:.
4;ilii4,i\2~ 7,482,628
BANK NET CASH
BALANCE PROVIDED
NOV 2001 / USED
8,135,707 (6,540,947)
4,171,898 (931,657)
2,215,389 10,350
10,000,000 0
59,616,372 2,777,830
84,139,366 4,684,425
NOTE A: Difference in comparison between years due to timing difference in receipt of funds.
1303
........B.AN.K..
.. ... .
~~i.ANPP
oac;loi)1
....".".
.-..-..".,
.. .. .. "
....".".
..-----..--.
. .. .. ..
....".,..
..-.- .-.-.-.-.',-.'.
....-..,..
MWr$q
~:~~:~~~
jp:pqp,qpq
6'2:3a4;;l0~
PART "A"
BANK
BALANCE
DEC 2000
3,973,307
207,105
2,099,913
o
44,106,707
...........
....-.-.-.-.-.-..-...
..-.....,..
".". ..".
...........
........".
.-..-.-....-....-...
7$:4~4:if,h 50,387,032
NOTE 1: Tax payments do not tie into Part A due to timing differences since
Part A is on a cash basis (ie. difference due to outstanding deposits)
NOTE 2: For information purposes only. True comparison to prior year not applicable due to changes in the tax legislation.
1304
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
PART Ilell
STATISTICAL INFORMATION
FOR THE MONTH OF DECEMBER 2001
DECEMBER YEAR TO DATE
Tax Certificates 76 1,016
Number of Properties eligible for Tax
ReQistration (see Note 1) 101 .it see Note 2
Accounts Payable Cheques Issued
#52464 TO #52879 416 5,806
Number of Births Reaistered 31 488
Number of Deaths Reoistered 33 505
Note 1: Only includes those properties whose arrears are greater than $10,000.
Note 2: Number of eligible properties for tax registration not applicable for
year-to-date comparison.
1305
CORPORATION OF THE MUNICIPALITY OF ClARINGTON
INVESTMENTS OUTSTANDING
AS AT DECEMBER 30, 2001
PART "0"
FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY
INSTITUTION COST RATE O/S VALUE D
GENERAL FUND BMO 1,993,200.00 2.15% 58 2,000,000.00 Jan. 30102
BNS 1,991,600.00 2.14% 72 2,000,000.00 Feb. 13/02
BNS 1,990,160.00 2.10% 86 2,000,000.00 Feb. 27102
CIBC 1,989,580.00 2.10% 91 2,000,000.00 Mar. 4/02
BMO 894,060.00 2.11% 115 900,000.00 Mar. 28/02
TO 1,996,120.00 2.15% 33 2,000,000.00 Jan. 23/02
TO 1,994,860.00 2.09% 45 2,000,000.00 Feb. 4/02
TD 1,496,280.00 2.21% 41 1,500,000.00 Jan. 10102
TO 1,495,770.00 2.20% 47 1,500,000.00 Jan. 16/02
CIBC 1,990,460.00 2.01% 87 2,000,000.00 Mar. 18/02
TOTAL GENERAL FUND 17:8~20$()J(JQ
RESERVE FUND RBC 182,177.00 6.20% 1,095 218,206.00 Aug 1/0<
RBC 1,425,999.88 5.11% 1913 1,851,467.00 June 1/0E
RBC 1,683,100.32 5.15% 2019 2,221,035.00 Sept.15/0E
WOOD GUNDY 1,855,574.20 5.15% 1913 2,414,000.00 June 1/0E
RBC . 295,000.00 8.50% 3285 295,000.00 May 26/04
RBC 774,999.81 5.25% 1249 922,509.00 Dee 15/02
RBC 287,862.47 5.40% 1319 347,702.00 Feb 23/03
RBC 771,999.33 5.40% 1596 970,580.00 Nov 27/03
RBC 1,566,467.00 5.45% 1826 2,042,463.00 Jan.29/06
RBC . 1,114,680.00 4.90% 730 1,114,680.00 June 26/03
RBC . 500,000.00 6.25% 365 500,000.00 June 21/02
RBC 1,600,000.00 5.05% 365 1,680,800.00 July 12/02
RBC 753,906.65 4.50% 356 787,000.00 Mar. 28/02
RBC . 475,000.00 8.58% 2761 475,000.00 Mar 17/03
RBC . 2,513,000.00 5.00% 365 2,513,000.00 May 9/02
WOOD GUNDY' 250,000.00 6.50% 1839 250,000.00 June 21/03
RBC . 500,000.00 4.25% 365 500,000.00 June 21/02
RBC 601,664.00 5.30% 1461 739,720.00 Feb. 5/05
RBC . 1,482,702.57 5.50% 1825 1,487,000.00 Feb. 13/06
RBC . 1,400,000.00 3.50% 730 1,449,000.00 Nov. 28103
1306
CORPORATION OF THE MUNICIPALITY OF ClARINGTON
INVESTMENTS OUTSTANDING
AS AT DECEMBER 30, 2001
FINANCIAL
INSTITUTION
RESERVE FUND
RBC
RBC
RBC
RBC
RBC'
RBC .
RBC
RBC .
RBC
WOOD GUNDY.
RBC
RBC
RBC
RBC
RBC
WOOD GUNDY.
RBC
RBC
RBC
HSBC
RBC
TO
RBC.
RBC
TOTAL RESERVE FUND
TOTAL INVESTMENTS
PART "0"
INVESTMENT INTERES # OF DAYS MATURITY MATURITY
COST RATE OIS VALUE DATE
1,566,466.88
933,400.00
58,479.40
25,125.57
250,000.00
250,000.00
1,323,000.00
1,058,000.00
20,558.85
638,000.00
945,210.00
43,523.00
1,149,347.43
942,893.00
855,000.00
485,000.00
1,392,611.00
548,000.00
534,978.37
2,555,620.90
118,693.50
8,241,787.00
553,392.00
40,891.57
Mi;eaUWdiJ
.. ......
...."."."....
. . - . -.... . ..- - - .
... . .. ....
...".".".....
.-......"..-...
.. .. ..
...."."."....
. .."."."....
$S!,$944lil1C7Q
. Investment interest paid on a monthly/semi-annual/annual basis
5.30%
5.20%
5.95%
5.95%
4.75%
5.25%
5.00%
5.00%
5.20%
5.40%
5.60%
5.50%
4.60%
6.30%
5.35%
4.35%
4.60%
5.40%
5.20%
2.15%
5.10%
2.00%
3.70%
5.20%
1307
1386
1827
2032
2025
1839
180
365
365
1310
1598
730
1095
329
1825
1832
365
365
1507
1729
90
1976
31
732
482
1,904,519.00
1,202,670.00
80,639.00
34,613.00
250,000.00
250,000.00
1,389,150.00
1,108,800.00
24,645.00
638,000.00
1,054,038.00
51,107.00
1,197,000.00
1,239,904.30
1,065,102.90
485,000.00
1,456,671.11
548,000.00
679,942.00
2,569,169.19
155,297.00
8,255,786.75
553,392.00
43,171.00
Nov. 15/04
Nov 12/02
Dee 15/02
Dee 15/02
June 21/03
Jun 21/04
May 1/02
May 28/02
Jan 9/02
June 1/05
Dec.21/02
Dec.21/03
Jan.31/02
Oet 27/03
Mar 1104
Apr. 1/02
Mar.15/02
Apr 7/03
Dee 1/03
Mar. 3/02
Oet. 15/04
Jan. 21102
Sept. 23/03
Dee 15/02
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
DECEMBER 2001
PART "E"
Town
Storage Depot Inc. 4,536.32 7,450,40 330.75 1,047.04
1632 Baseline Rd., Courtice
40R18331 Part 1 to 7
BP # 01.0819
Green Martin Holdings Inc. .".".".". 62,244.00 80,424.00 1,971.00 6,336.00
40M.2005 pt Lot:42 ,i
B/P # 01.0244, 0247-49, 0251, 01.0276-77;:0280,81'" .
Orchard Park Estates (Bowmanville) Inc. 418,656.00 571,722.00 14,454.00 46,464.00
Swindells St., Bowmanville
40M.2066 Pt Lot:42
B/P # 01.0692, 01.0558-9, 01.0682, 01
759.774,702.713
1138337 Ontario Inc. 6,916.00 9,644.00 219.00 704.00
2 Catherwood Lane, Newcastle
40M-2036 pt Lot:9
B/P # 01.0845
1138337 Ontario Inc. 20,748.00 858.00 657.00 2,112.00
Port of Newcastle Dr., Newcastle
40M-1984 Pt Lot:14
B/P # 01.0974-75,78
1138337 Ontario Inc. 13,832.00 17,164.00 438.00 1,408.00
Beacham Cres., Newcastle
40M-2003 pt Lot:13L
B/P # 01.0976.77
Jeff McKeen 1,158.89 84.50 267,49
2212 Taunton Rd., Darlington
Con:5 Lot: 19
B/P # 01.0594
Marlene Worboy 6,916.00 9,644.00 219.00 704.00
23 Concession St. W., Bowmanville
10R-1056 Part 2
B/P # 01.0781
TSC Stores Ltd. 27,232.98 38,503.00 1,708.54 5,408.61
95 Baseline Rd., Bowmanville
Con: BF Lot 11
B/P # 01.0904
St. Stephen's Estates Inc. 13,832.00 19,288.00 438.00 1,408.00
131 Guildwood Drive, Bowmanville
40M-1977 and 40R.20576 Part 2
B/.P # 01.0646
Dunbury Homes (Newcastle) Ltd. 6,916.00 286.00 219.00 704.00
83 William Jose Ct., Newcastle
40M.2038 Pt Lot:84
B/P # 01.0677
1 308
,
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON PART "E"
DECEMBER 2001
Education Education
Develo ment Char es Town Re ion En Iish Se arate En Iish Public
St. Stephen's Estates Inc. 6,916.00 9,644.00 219.00 704.00
140 Sprucewood Cr., Bowmanville
40M-2048 pt Lot:32
B/P # 01.0950
Daystar Homes 6,916.00 2,114.00 219.00 704.00
46 Venton Ct., Tyrone
40M-2009 Pt Lol:18
B1P # 01.1000
Vintage Homes 6,916.00 9,644.00 219.00 704.00
22 Bradshaw St., Bowmanville
Con: 2 Lot 10
B/P # 01.0967
Orchard Park Eslates (Bowmanville) Inc. 124,488.00 154,476.00 3,942.00 12,872.00
35 Barlow Ct., Bowmanville
40M-2066 pt Lot :77R
B/P # 01.0942-46, 0830-35, 1021-2,
Orchard Park Estates (Bowmanville) Inc. 13,832.00 19,288.00 438.00 1,408.00
24 Redfern Cres., Bowmanville
40M.2066 Pr Lot:37
B/P # 01.0935, 01.0691
Orchard Park Estates (Bowmanville) Inc. 124,48S.00 165,096.00 3,942.00 12,672.00
92 Scottsdale Dr., Bowmanville
40M-2066 pt Lot: 19
B/P # 01.0828, 0714.5, 0696-7, 01
St. Stephen's Estates Inc. 6,916.00 9,644.00 219.00 704.00
213 Sprucewood Cres., Bowmanville
40M.2048 Pt Lot:65
B/P # 01.0959
Storybook Homes 6,916.00 9,644.00 219.00 704.00
17 Osgoode Gate, Courtice
40R.19834 Part: 21
B/P # 01.1004
673666 Ontario Limited 13,832.00 19,288.00 438.00 1,408.00
589 Longworth Ave., Bowmanville
40M-2022 pt Lot: 58
B/P # 01.1009
Prestonvale Heights Limited 34,580.00 48,220.00 1,095.00 3,520.00
72 Huntington Cres., Courtice
40M.1929 pt Lot: 25
B/P # 01.0993.97
Prestonvale Heights Limited 13,832.00 19,288.00 438.00 1,408.00
13 Glen Eagles Dr., Courtice
40M-1929 pt Lot: 71
B/P # 01.0991-92
1309
.
CORPORATION OFTHE
MUNICIPALITY OF ClARINGTON
DECEMBER 2001
Develo ment Char as
Gay Company Ltd.
139 Richfield Sq., Coutice
40M.1994 pt lot:46R
SIP # 01.1038
West Bowmanville Developments Ltd.
87 Aspen Springs Dr., Bowmanville
40M-1881
SIP # 01_0971
Andrew Marston
15 Venton Cr., Tyrone
40M.2009 Pt lot:8
SIP # 01.0952
Dunbury Homes (Newcastle) Ltd.
24 Brookhouse Dr., Newcastle
40M-2038 Pt lot: 2
SIP # 01_1001
Orchard Park Estates
16 Redfern Cres., Bawmanville
40M.2066 pt lot:39
SIP # 01.1 017
West Bowmanville Developments
87 Asen Sprins Dr., Bowmanville
40M-1881
SIP # 01.0971.2
TOTALS
Town
13,832.00
186,018.00
6,916.00
6,916.00
6,916.00
.:.:-:-,.:-,-:-:-,-:-:-:<"
.'..,.,.....-.-......
::.'.:.:.:-,-:-;.:-:--::
.....-......
~$~;~~~:~& 1,163,218.19
PART "E"
R .
Education Education
blic
17,652.38
438.00 1,408.00
13,140.00
2,114.00
219.00
NOTE 1: Development Charge payments may not tie into Part A due to timing differences since Part A is on a cash basis.
(ie. Difference due to outstanding deposits.)
1310
9,644.00
219.00
9,644.00
219.00
334,368.00
1,594,751.78
46,361.79
42,240.00
704.00
704.00
704.00
148,931.14
.
.
CORPORATION OF THE
MUNICIPALITY OF ClARINGTON
DECEMBER 2001
CONTRIBUTIONS. CASH-IN-lIEU OF PARKLAND
Vintage Homes LD217101
D. Downs lD234-236/01
Avery UD2000.218
CONTRIBUTIONS. ENGINEERING AND INSPECTION FEES
Region of Durham S/Sewers
Total Engineering and Inspection Fees Contributions
CONTRIBUTIONS. ROADS
Total Roads Contributions
PART "En
1,500.00
2,409.56
800.00
4,709.56
3,420.00
3,420.00
1311