HomeMy WebLinkAboutTR-09-01
.
THE CORPORATION OF THE MUNICIPALITY OF CLARINGTON
REPORT
Date:
February 19, 2001
File # rltJ c/f
Res # C;!ff -/3';-:-0 {
Meeting:
General Purpose and Administration
Report #:
TR-09-01
FILE#:
By-law #
Subject:
CASH ACTIVITY REPORT - DECEMBER 2000
RECOMMENDATIONS:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report TR-09-01 be received;
2. THAT, in accordance with provision of Chapter M-45, Section 79 (1) of the Municipal
Act, RS.O. 1990, the Treasurer reports the cash position of the Municipality of
Clarington for the month ended December 31, 2000, is as shown on the attached
schedule; and
3. THAT Part "A" of the expenditures for the month of December 2000 be confirmed.
BACKGROUND
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, 2000 and the comparative information for the
month ended December 31, 1999.
Reviewed by,
()~~
(b(\
Frankiin Wu,
Chief Administrative Officer.
MM/LG/hjl
Attachments
9r2
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
Analysis of Revenue and Expenditures
for the Month of December 2000
REVENUE RECEIVED FOR GENERAL OPERATING
AND RESERVE FUND PURPOSES:
TAX PAYMENTS RECEIVED
HEADS & BEDS
LINEAR PROPERTIES
FEDERAL MINISTRY - NEWCASTLE BREAKWALL
FEDERAL GOV'T-WASTE MGMT STUDY--PORT GRANBY
PROVo MINISTRY - SAMUEL WILMOT NATURE AREA
ORONO ATHLETIC ASSOCIATION -1ST REPAYMENT OF LOAN
SALE OF LAND
BOWMANVILLE HERITAGE BOOK SALES
VERIDIAN PROMISSORY NOTE INTEREST
SUBSIDIES:
HANDI-TRANSIT
DEVELOPMENT CHARGES-TOWN
GENERAL
INTEREST
DEVELOPMENT CHARGES-SCHOOL BOARD
DEVELOPMENT CHARGES-REGION/PUC
USE OF FUNDS:
PAYROLL
REGION LEVY
SCHOOL BOARD LEVIES
GENERAL-INCLUDING CAPITAL EXP."
NET CASH PROVIDED (USED)
FINANCIAL POSITION:
GENERAL FUND
RESERVE FUND
MUNICIPAL POOLED INVESTMENTS
MUNICIPAL BOND INVESTMENTS
INVESTMENTS (GENERAL + RESERVE FUND)
TOTALS
Ps()s~~sifl DECEMBER
'\~i:i(l 1999
...... ,...
.......".
.-.--.-...',,'.
.-.,-. ,...
...----. .
. ... ..
.......".
.......".
$:1$$ ~$e
.-.... ,...
...... ....
..........
...........
...". ,...
...... ,. .
.......".
,".-,',-.-.", '".-'
.-.". ,...
.-.-.-.'-.-.-........ .
... ... .
.-.,-. ,...
...... ,...
..........
."....".
".-.-,-.-." ."-'
.-.". ,...
.--.--....
..... ..
.......".
. .'. ". ......
.. ... .
.-.". ,...
...... ,...
.......".
........".
ii!i$ $~~
M~p ~:3$
M9~ ~qi:i
jM.a2 095
8,132,877
o
o
10,000
o
22,000
o
o
o
948,000
234,862
731,335
149,786
o
222,667
10,451,527
908,196
4,592,392
5,195,497
2,556,832
13,252,917
2,801,390
BANK NET CASH
BALANCE PROVIDED
NOV.30/00 I USED
2.606,853 1,366,454
166,587 141
91,378 (51,001)
2,089,188 10,725
52,915,654 8,808,947
57,869,661 7,482,628
NOTE A: Difference in comparison between years due to timing difference in receipt of funds.
"
913
W"Ni<'
~~P\N8!$
.OeGc31}QiJ
....."., .
.'".......
.".."."..
.',','.-.",','."'.-'
.",."...
'. .........--..
. . ..
......,."...
'.' ....-.-.
3;.97.3.:3O..Y
. '." ....
............-..
j~$;ti$
4P,~tf
?;%J~,~1 ~
44;10~:7!i7
PART "A"
BANK
BALANCE
DEC.31/99
2,449,406
2,638,446
3,820
o
35,957,234
........'.'..,..-..-.-...
.-.-.....-,......
:<-,-,.:-;-:.,.'.,.....
.,-,-,-,-:-:-;-:-:.".,.:.
.-.........,
sli;sai:~2 41,048,906
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
Continuity of Taxes Receivable
for the month of December 2000
PART "B"
NOVEMBER
2000 INTEREST
RECEIVABLE ADDED
TAXES
BILLED
PAYMENTSffi7~~~~m~
BALANCE IADJUST. ...
DECEMBER
1999
Note 2
PREPAID TAXES
CURRENT YEAR
TAXES 4,293,819 112,096 4,405,915 4,608,600
PENALTY AND INTEREST 156,700 53,782 210,482 245,790
FIRST PRIOR YEAR
TAXES 2,078,119 167,439 2,245,558 1,731,333
PENALTY AND INTEREST 213,307 23,284 236,591 280,146
SECOND PRIOR YEAR
TAXES 966,668 11,697 978,365 657,947
PENALTY AND INTEREST 172,082 11,795 183,877 163,319
THIRD & PRIOR YEARS
TAXES 949,392 949,392 747,599
PENALTY AND INTEREST 409,340 11,880 421,221 451,666
TOTAL 9,239,427 100,742 291 ,233 9,631,401 8,886,400
Includes refunds, write-offs, 496's, etc.
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.
914
.
.
CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C"
STATISTICAL INFORMATION
FOR THE MONTH OF DECEMBER 2000
DECEMBER YEAR TO DATE
Tax Certificates 70 1,329
Number of Properties eligible for Tax
Reqistration (see Note 1) 129 .. see Note 2
Accounts Payable Cheques Issued
#39891 to #40393 503 6,685
Number of Births ReQistered 20 472
Number of Deaths ReQistered 59 510
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.
- 915
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT DECEMBER 31,2000
PART "D"
FINANCIAL INVESTMENTINTERES # OF DAYS MATURITY MATURITY
INSTITUTION COST RATE OIS VALUE DATE
GENERAL FUND MTL 1,992,460.00 5.75% 24 2,000,000.00 JAN.12/01
MTL 1,988,420.00 5.75% 37 2,000,000.00 JAN.25/01
MTL 4,933,750.00 5.70% 86 5,000,000.00 MAR.15/01
TD 996,790.00 5.60% 21 1,000,000.00 JAN.12/01
TOTAL GENERAL FUND ....~,$tt4~OJOO...
RESERVE FUND RBC 182,177.00 6.20% 1,095 218,206.00 Aug 1/03
RBC 1,001,705.00 6.80% 1828 1,392,611.00 Mar 15/01
RBC 1,343,186.32 5.60% 363 1,418,000.00 Mar 01/01
WOOD GUNDY' 1,787,000.00 6.75% 346 1,787,000.00 Mar 01/01
RBC . 295,000.00 8.50% 3285 295,000.00 May 26/04
RBC 774,999.81 5.25% 1249 922,509.00 Dec 15/02
RBC 287,862.48 5.40% 1319 347,702.00 Feb 23/03
RBC 771,999.33 5.40% 1596 970,580.00 Nov 27/03
RBC 2,937,000.00 6.00% 1460 3,641,880.00 Jan.26/04
RBC . 574,000.00 6.25% 1644 574,000.00 Dec.30/04
RBC . 500,000.00 5.75% 1826 500,000.00 June 21/05
RBC 1,584,859.95 5.75% 345 1,671,000.00 July 19/01
RBC 620,220.69 5.15% 1007 711,752.00 Apr 5/01
RBC . 475,000.00 8.58% 2761 475,000.00 Mar 17/03
RBC 99,999.64 7.10% 1906 143,061.00 May 14/01
RBC . 993,000.00 6.25% 1,095 993,000.00 May 23/03
WOOD GUNDY' 250,000.00 6.50% 1839 250,000.00 June 21/03
RBC 354,000.00 5.10% 368 372,054.00 Feb. 5/01
RBC 1,417,032.00 5.10% 366 1,489,300.63 Feb. 7/01
RBC . 500,000.00 6.10% 365 500,000.00 Sept 7/01
916
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT DECEMBER 31,2000
PART "0"
I I FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY
INSTITUTION COST RATE OIS VALUE DATE
RESERVE FUND
RBC 180,862.43 5.63% 1549 228,160.00 Feb 1/01
RBC 933,400.00 5.20% 1827 1,202,670.00 Nov 12/02
RBC 58,479.40 5.95% 2032 80,639.00 Oec 15/02
RBC 25,125.57 5.95% 2025 34.613.00 Dec 15/02
RBC' 250,000.00 4.75% 1839 250,000.00 June 21/03
RBC 427,625.00 5.50% 1628 542,878.00 Dec 1/01
RBC . 250,000.00 5.25% 180 250,000.00 Jun 21/04
RBC 1,109,500.90 5.05% 1213 1,307,911.00 Apr 1/01
RBC 20,558.85 5.20% 1310 24,645.00 Jan 9/02
WOOD GUNDY 648,000.00 6.05% 397 690,641.06 Jan 15/01
RBC 945,210.00 5.60% 730 1,054,038.00 Dec.21/02
RBC 43,523.00 5.50% 1095 51,107.00 Dec.21/03
RBC 898,314.97 5.00% 919 1,037,435.00 Mar. 8/01
RBC 2.160,071.68 5.70% 970 2,503,270.00 May 1/01
RBC 1,233,830.84 5.95% 1002 1,445,952.00 Jun 2/01
RBC 649.589.48 5.95% 1185 783,582.00 Dec 2/01
RBC 942.893.00 6.30% 1825 1,239,904.30 Oct 27/03
RBC 855,000.00 5.35% 1832 1.065,102.90 Mar 1/04
WOOD GUNDY 500,000.00 5.35% 1825 500.000.00 Apr. 16/03
RBC 1.683,101.00 5.30% 1096 1,683.101.00 Mar 3/02
RBC 548,000.00 5.40% 1507 548,000.00 Apr 7/03
RBC 534,978.37 5.20% 1729 679,942.00 Dec 1/03
Hong Kong 2,429,486.17 5.85% 90 2,464,530.68 Feb.5/01
RBC 118,693.50 5.10% 1976 155,297.00 OCT 15/04
TOTAL RESERVE FUND .$4,1$Ma7>~7..,
.,........-.....-.-...-.....-.;.:.
.._-.-..-....., . .
._'...................-.....-..,..,.,.
.,...--..-.........--.
..........._--.
.,.-..-..-.....".,' .
.,..............-.....-..,-,..,.....
.-.--.-..-....., ...
.,'--.-............
..-..-....."._..
TOTAL INVESTMENTS 44.ioMi:l71gt
. Bond investment. Interest paid on a monthly/semi-annual/annual basis
917
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
DECEMBER 2000
Education Education
Development Charges 'tbtill Town Region English Separal< English Public
A. Sragg 8,743.00 5.875.00 1,945.00 219.00 704.00
Res. Dev. Form 47936
L., 3, C., 9. Darlington
SIP #00.0924
.... ,
L. Halminen I. 5,875.00 8.874.00 219.00 704.00
Res. Dev. Form 47752
L., 33. C.. 3, Darlington
SIP #00.0943 .'
Keuning Construction 2,868.00 - 1,945.00 219.00 704.00
40M 1826
34 Virtue Court, Enniskillen
SIP #00.0935
SI. Stephens Estates 31,344.00 11.750.00 17,748.00 438.00 1,408.00
40M1977
SIP #00.0846,847 .:. <.....
Delta Rae Homes 'M 70,500.00 106,488.00 2,628.00 8,448.00
40M2005 '.-
L., 17, C., 1. Darlington
SIP #00.0742,743, 746, 748, 752, 754,
755, 756, 758, 759, 760, 764
Halloway HOldings 8,145.13 1,895.16 5,000.00 300.07 949.90
SIP #00.0919
Greg Powles 656.90 , 219.00 437.90
-
10M815
L., 20, C.. 7, Clarke
B/P #00.0944
Kaitlin Group 423,184,00 184,500.00 232.840.00 6,132.00 19,712.00
40M2005
L.. 17. C., 1, Darlington
SIP #00,0958, 959, 961,962,
965-986, 988
Kaillin Group 250,752.00 94,000,00 141.984.00 3,504.00 11,284.00
40M2005
L., 17, C., 1, Darlington
SIP #00.0738-741. 744, 745. 747,
749-751,753,757,761-763, 765
Fridel Ltd., 29,390.00 11,750,00 15,794.00 438.00 1,408.00
40R19730
Sip #00.0994, 995
,
City Homes 188;084.00 70,500,00 106,488,00 2,628.00 8,448.00
40M2022
L., 12, C., 2, Bowmanville
SIP #00.0949-954, 1014-1019
. . -
.
. .
- CORPORATION OF THE
MUNICIPALITY OF ClARINGTON PART "Eft
DECEMBER 2000
Education Education
Development Charges Total Town Region English Seoarate English Public
Gay Company Limited 29,390.00 11,750.00 15.794.00 438,00 1,408.00
40M1994
l., 30, C.. 2, Darlington
BIP#00.1010, 1011
,... ....,
TOTALS 448,395.16 654,900.00 17,382.07 55,595.80
919