HomeMy WebLinkAboutFND-005-04
. .
Clw;:#Jgron
REPORT
FINANCE DEPARTMENT
Meeting:
GENERAL PURPOSE AND ADMINISTRATION COMMITTEE
Date:
MONDAY, MARCH 8, 2004
FiO
Resolution #:GPA - Hall-of
Report #: FND-005-04
File#:
By-law #:
Subject:
CASH ACTIVITY - FOURTH QUARTER OF 2003
Recommendations:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report FND-005-04 be received;
2. THAT in accordance with provision of Chapter 25, Section 286 of the Municipal
Act, S.O. 2001, the Treasurer reports the cash position of the Municipality of
Clarington for the fourth quarter of the year 2003, as shown on the attached
schedule; and
3. THAT Part "A" of the expenditures for the fourth quarter of the year be confirmed,
Submitted by:
Reviewed bl'j ~~
Franklin Wu,
Chief Administrative Officer.
NT/LB/hjl
,
ijJ!
REPORT NO.: FND-005-04
PAGE 2
BACKGROUND AND COMMENT:
The attached schedules indicate the Corporation of the Municipality of Clarington's cash
transactions for the fourth quarter of 2003, the cash investment position, the taxes receivable
position, statistical information and transit revenue and expenditure for the month ending
December 31, 2003 and the comparative information for the month ending December 31,2002.
The attached schedules for the development charges information is for the months of October,
November and December, 2003,
Attachments:
Attachment A - Analysis of Revenue and Expenditures - Fourth Quarter of 2003
Attachment B - Continuity of Taxes Receivable - As at Decemberr2003
Attachment C - Statistical Information - As at December 2003
- Transit Revenue and Expenditure - As at December 2003
Attachment D - Investments Outstanding - As at December 2003
Attachment E - Development Charges Information - October 2003
Attachment F - Development Charges Information - November 2003
Attachment G - Development Charges Information - December 2003
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
40 TEMPERANCE STREET, BOWMANVILLE, ONTARIO L 1C 3A6 T (905)623-3379 F (905)623-4169
L':0
CORPORATION OF THE MUNICIPAUTY OF CLARINGTON
Analysis of Revenue and Expenditures
for the Fourth Quarter of the Year 2003
ENUE RECEIVED FOR GENERAL OPERATING
D RESERVE FUND PURPOSES:
GENERAlIT AX PA YMENT$ RECEIVED
DEBENTURE PROCEEDS - REGION DURHAM -$/COURTICE ARENA
CLARINGTON CONCERT BAND
PROVINCIAL GOVERNMENT - COMMUNITY REINVESTMENT FUNDING
CANADIAN WASTE - RENT AND ROYALTIES
BOW MANVILLE HERITAGE BOOK SALES
DEVELOPMENT CHARGES-MUNICIPAL
INTEREST
DEVELOPMENT CHARGES-SCHOOL BOARD
DEVELOPMENT CHARGES-REGION
USE OF FUNDS:
PAYROLL
REGION LEVY
SCHOOL BOARO LEVIES
GENERAL-INCLUDING CAPITAL EXP."
NET CASH PROVIDED (USED)
FINANCIAL POSITION:
BANK
BALANCE
SEP. 30 2003
GENERAL FUND
RESERVE FUND
MUNICIPAl BOND INVESTMENTS
HOST COMMUNITY FUND IN TRUST
INVESTMENTS (GENERAL + RESERVE FUNDS)
OTALS
9,657,963
670,743
2,438,828
10,000,000
59 323 483
82091017
BANK BALANCES AS AT:
OCT. 31 2003
GENERAL FUND
RESERVE FUND
MUNICIPAL BOND INVESTMENTS
10,560,146
760.367
2 448 586
NOTe A: Difference in comparison between years due to timing difference in receipt of funds.
1-, .
Fourth Quarter
2002
15,025,896
11,891,905
12,000
29,000
32,785
126
997,313
957,741
135,333
1 100744
30182843
3,458,467
4,428,827
5,047,036
14838 781
27773111
2 409 732
NET CASH
PROVIDED
I USED
",','aAN~
~AO\I%$
DEC;M2<ifu
...._.........-...-.
......---....
.... ....--
...-...."..
.. .' . .......... - . - . - . . . .
,'.)$-.$rm
).;;1%..' '$<<.
1~.~~.
.. ......-
..,'/5'
OCT. 31 2002
5,820,106
1,882,881
2328746
NOV. 30 2003
9,130,803
2,581,778
2 458 037
PART "A"
BANK
BALANCE
DEC. 31 2002
3,527,755
1,782,568
2,350,131
10,000,000
63 391 350
81 051 804
NOV. 30 2002
3,300,301
2,414,759
2339186
ORPORATlON OF THE MUNICIPALITY OF CLARINGTON PART "B"
'nuity of Taxes Receivable
or the Fourth Quarter of the Year 2003
September 30, 2003 DECEMBER
BEGINNING BALANCE INTEREST TAXES PAYMENTS 2002
RECEIVABLE ADDED BILLED BALANCE IADJUST, .-
PREPAID TAXES 935 605
CURRENT YEAR
TAXES 8,069,004 4,817,605 12,888,609 (9.476,619) 3,928,953
PENALTY AND INTEREST 143854 230 183 37 037 167 370 219250
FIRST PRIOR YEAR
TAXES 2,155,484 141,708 2,297,192 (516.361) 1,660,508
PENALTY AND INTEREST 244151 74595 318746 88061 182 063
SECOND PRIOR YEAR
TAXES 926,650 50,776 !f77,426 (187.552) 719,269
PENALTY AND INTEREST 142 298 32 473 174771 46164 123 409
HIRD & PRIOR YEARS
TAXES 1,070,705 1,070,705 (191,602) 1,008,349
PENALTY AND INTEREST 538 596 36184 0 574 780 90821 521 990
OTAL 13290 741 373435 5,010089 18674265 10764 549 8 363 792
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: Prepayments include preauthorized
1 J , L
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
PART "e"
STATISTICAL INFORMATION
FOR THE MONTH
OF DECEMBER YEAR TO DATE
Tax Certificates 26 905
Number of Properties eligible for Tax
Registration (see Note 1) 73 ** see Note 2
Accounts Payable Cheques Issued
#60287 to #60847 557 6,781
Transit Total Adult Ridership 2,660 29,104
Transit Total Student Ridership 5,432 66,902
Transit Total Sr.lChild Ridership 660 8,708
Transit Total Ridership Across Region 75 390
Transit Total Transfers 505 6,138
Number of Births Registered 1 7
Number of Deaths Registered 70 493
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,
TRANSIT REVENUE AND EXPENDITURE
FOR THE MONTH
OF DECEMBER YEAR TO DATE
REVENUE
TRANSIT REVENUE 15,922 162,313
EXPENSES
MISCELLANEOUS OPERATING 8,451 22,697
TRANSIT CONTRACT 52,387 549,655
OPERATING (LOSS)/GAIN (44,916) (410,039)
CAPITAL EXPENDITURES 0 0
1
~
CORPORATION OF THE MUNICIPAliTY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT DECEMBER 31,2003
PART "0"
FINANCIAL INVESTMENT INTEREST #OFDAYS MATURITY MATURITY
INSTITUTION COST RATE O/S VALUE DATE
GENERAL FUND
TO 2,499.868.40 2.74% 22 2,504,000.00 Jan. 09/04
TOTAL GENERAL FUND 2.4-$$:e$$Ao
RESERVE FUND RBC . 806,000,00 3.50% 1,827 806,000.00 Jul. 09/08
RBC 1,425,999,88 5.11% 1913 1,851,467.00 June 1/06
RBC 1,683,100,32 5,15% 2019 2,221,035.00 Sept. 15/06
RBC 1,855,574.20 5.15% 1913 2,414,000.00 June 1/06
RBC . 295,000,00 8.50% 3285 295,000.00 May 26/04
RBC 495,186,85 4.00% 1171 561,500.00 Jun. 6/06
RBC 1,379,343.53 4.65% 2085 1,787,409.00 Dec. 1/08
RBC . 1,450,000,00 4.00% 366 1,450,000.00 Dec. 1/04
RBC 1,566,467.00 5.45% 1826 2,042,463.00 Jan.29/06
RBC 500,000.00 2.75% 1827 595,239.37 June 21/08
RBC 500.000.00 6.75% 1460 638,699.85 June 21/04
RBC . 400,000.00 3.50% 1887 400,000.00 Aug. 22/08
RBC 481,878.00 4.45% 1827 599,072.41 Mar, 4/08
RBC 868,578.00 4.10% 1098 979,853.00 Apr, 3/06
RBC . 2,600,000,00 4.00% 1841 2,600,000,00 May 20/08
RBC 500,000.00 5.75% 1095 578,782.97 June 21/04
RBC . 1,815,962.00 5.00% 1825 1.815,962,00 Feb. 7/07
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,342,000.00 4.00% 365 1,342,000.00 Feb. 10/04
RBC 208,000.00 4,35% 1769 257,351,00 Mar. 12/08
RBC . 2,465,000.00 4.00% 365 2,465,000.00 Jul. 23/04
RBC . 643,000.00 4.00% 365 643,000.00 Sept. 16/04
RBC 1,566,466.88 5.30% 1386 1,904,519.00 Nav, 15/04
RBC 1,081,662.88 3.24% 635 1,143,286.00 Sept. 15/04
RBC 519,255.00 3.30% 649 550,000.00 Oct. 1/04
RBC 499,999.38 4.00% 1182 567,343,00 Jul. 26/06
RBC 250,000.00 8.00% 2,555 380,076.30 Jun 21/04
TD Waterhouse 1,000,000.00 4,15% 1096 1,129,738.22 Apr. 09/06
TD Waterhouse' 1,500,000.00 5,50% 1694 1,500,000.00 Dec. 20/07
RBC' 638,000,00 5.40% 1598 638,000.00 June 1/05
RBC 534,782.00 3,30% 730 570,660,00 Dec. 23/04
RBC 855,000,00 5.35% 1832 1,065,102.90 Mar 1/04
TD 2,355,003.06 2,73% 34 2,361,000.00 Jan. 12/04
RBC 1,520,617.00 5.35% 1826 1,973,297.00 Mar.15/07
RBC 118,693.50 5.10% 1976 155,297.00 Oct. 15/04
RBC 1,000,000.00 4.45% 1827 1,243,203.49 Aug. 09/07
HSBC 1,545,785,20 2.70% 91 1,556,190.68 Mar. 1/04
TO 5,171,453,00 2.74% 22 5,180,000.00 Jan, 9/04
TO 5,500,132,88 2.59% 56 5,522,000.00 Feb, 12/04
TOTAL RESERVE FUND H5M22ao7,W
ITOTAL INVESTMENTS ......-.-..-.-.-... I
.-...... -.. " ..
...........- "'-' .
,...-.-,-.-,-.-.-......,.".....
.-.-.-.-..,-.-..,....,.,.....
.---......-.-.--.....
......--- ...
.-.-.-.,'.'.........,.
$$)$2:iHtS$:f
. Investment interest paid on a monthly/semi-annuallannual basis
L
'r
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
OCTOBER 2003
L.
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Total Municipal Region English Separate English Public
03,0871 - 03,0874 Ridge Pine Park Inc. 4,120.00 0.00 0.00 1,304.00 2,816.00
Wilmot Creek
Con: SF Lot 3 pt Lot: 933, 921, 964, 952
03.0736 -03.0739, 03.7 !I:larnew Developments Inc. 118,746.00 46,068.00 66,498.00 1,956,00 4,224.00
& 03.0923 Newcastle
Plan: 40-2166 pt Lot: 31 & 1
03.0829 & 03.0830 Grajen Homes 36,056,00 15,374.00 18,622.00 652.00 1,408.00
William Jose Cl., Newcastle
Plan: 40M-2038 pt Lot: 52R & 52L
03.0797 Jeff Kelso 3,841,00 0.00 3,841.00 0.00 0.00
Plan: 10R-3155 Part: 2
03.0781 Kenneth Wayne Coatham 1,030,00 0.00 0.00 326.00 704.00
7015 Mercer Rd Clarke
Plan: 10R-2804 Part: 1
03.0859 Ridge Pine Park Inc. 338,00 0.00 0.00 0.00 338,00
56 Wilmot TI. Wilmot Creek
Con: SF Lot 3 pt Lot: 170
03.0880 Knox Christian School 6,211.63 0.00 0,00 2,277.66 3,933.97
410 5cugog 5t Sowmanville
Con: 2 Lot 14
03.0932 Dan Stever 1,030.00 0,00 0.00 326.00 704,00
32 Millvllle Ave Hampton
Con: 5 Lot 17
03.0784 Joseph McDowell 12,558,00 7,687.00 3,841.00 326.00 704.00
3791 Wilcox Rd, Clarke
Con: 9 Lot 23
..
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
OCTOBER 2003
t
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Total Municipal Region English Separate English Public
03.0868 & 03.0869 Clarnew Developments Inc. 36,056.00 15,374.00 18,622.00 652.00 1,408,00
19 Ravey Sl. Newcastle Village
Plan: 40N-2038 pt Lot: 124L
03.0875 Delta-Rae Homes 19,800.00 7,687.00 11,083.00 326.00 704.00
188 Padfield Dr. Bowmanville
Plan: 40M-2087 PI Lot: 39
03.0800-03.0802,03.08 :673666 Ontario Limited 360,560.00 153,740.00 186,220.00 6,520.00 14,080.00
03,0807,03,0809-03.08 1Goodwin Avenue, Bowmanville
03.0835-03.0844 Plan: 40M-2152 PI Lot 24R,24L - 33R,33L
03.0862 & 03.0863 Clarnew Developments Inc. 39,600.00 15,374.00 22,166.00 652,00 1,408.00
Culler Dr Newcaslle
Plan: 40M-2166 PI Lot: 23 & 11
03.0718, 03.0852, Cleary Homes & Pal Cleary 79,200.00 30,748.00 44,332.00 1,304,00 2,816.00
03.0854, 03,0855 Fenning & Aylesworth, Courtice
Plan: 40M-2113 PI Lot: 6,11,15,58
03.0808 1559688 Ontario Inc. 24,298.00 8,943.24 13,427.52 706.68 1,220.56
2415 Soulh Service Rd Bowmanville
Con BF PI Lot 15; now RP 40R19212 Part2,3
03,0816 BCR Construction 4,871.00 0,00 3,841.00 326.00 704.00
1 Bice Cl Solina
Plan: 40M-1897 pt Lot: 10
03.0701 The Kaitlin Group Lid 319,434.00 128,586.00 153,768.00 11,736.00 25,344.00
94 Aspen Springs Dr Bowmanville
Plan: 40R-21548 Part: Bldo D
03.0850 Richard & Claudette Buller 12,558.00 7,687.00 3,841.00 326,00 704.00
3805 Wilcox Rd Clarke
Con: 9 Lot 22
c'
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
OCTOBER 2003
~,
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Total Municipal Region English Separate English Public
03.0880 - 03.0901, Port of Newcastle Homes Inc. 472,272.00 199,862.00 245,630.00 8,476.00 18,304,00
03,0912 - 03,0915 Various, Newcastle
Plan Number: 40M-2161
03.0818 B. J. Church 12,558.00 7,687.00 3,841.00 326.00 704.00
1355 Solina Rd, Darlington
Con 1 pt Lot 24; now RP 10R3129 Part 2
03.0945 - 03.0952 Marianna Developments 133,141.00 61,496.00 63,405.00 2,608.00 5,632.00
Marchwood Cr Bowmanville
Plan: 40M-2107 pt Lot: 25R,25L - 28R, 28L
03.0778 Margaret Weir 75,254.01 28,242.60 41,108.80 2,164.35 3,738.26
380 Lake Rd, Bowmanville
Plan: 10M-831 pt Lot: Blk 9 Plan: 19R-3564 Part: 1,2
03,0792 Robert Watson 12,558,00 7,687,00 3,841,00 326.00 704.00
8805 Leskard Rd Clarke
Plan: 40R-20170 Part: 1,2
03,0823 George Hale 11,476.02 4,306,07 6,270,00 329.99 569.96
335 Toronto SI. Newcastle
Pan: 40R-20488 Part: 1
03.0698 Aspen Heights II LId 319,434.00 128,586.00 153,768.00 11,736.00 25,344.00
106 Aspen Springs Dr Bowmanville
Plan: 40R-21548 Part: Bldg B .
02.1172,03.0953, H.L. Gay Family Homes Limited 79,200.00 30,748.00 44,332.00 1,304,00 2,816.00
03,0954, 03.0955 Various, Courtice
Plan: 40M-2113 pt Lot: 110,50,111,33
TOTALS 2,196,200.66 905,882.91 1,112,298.32 56,986.68 121,032.75
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "F"
NOVEMBER 2003
'-,
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Total Municipal Reg ion English Separate English Public
03.0962 Pete Keu n ing 12,558.00 7,687.00 3,841,00 326.00 704.00
11 Ormiston 51. Hampton
Plan: 40R-21123 Part: 1-5,7
03,0481 Prestonvale Heights Limited 9,031.79 7,172.79 829,00 326.00 704.00
9 Glen Eagles Dr. Courtice
Plan: 40M-1929 pt Lot: 72
03.0969 - 03.0982 Prestonvale Heights Limited 277 ,200 .00 107,618.00 155,162.00 4,564.00 9,856.00
Huntington Cr. Courtice
Plan: 40M-2148 pt Lot: various
03.0968 Cindy Bonello 13,642.66 6,059.49 6,304.80 468.75 809.62
13393 Hwy35/115 Northbound, Clarke
Con 3 S pt Lot 28
03.1004 1138337 Ontario Inc. 19,800.00 7,687.00 11,083.00 326.00 704.00
261 Baldwin 51. Newcastle
Plan: 40M-2036 pt Lot: 6
03.1002 Clarnew Developments Inc. 19,800.00 7,687.00 11,083.00 326.00 704.00
38 Cutler Dr. Newcastle
Plan: 40M-2166 pt Lot: 10
03.1013 Cleary Homes 19,800.00 7,687.00 11,083.00 326.00 704.00
14 Southfield Ave. Courtice
Plan: 40M-2113 pt Lot: 79
03.1006 Diamond Home Builders Ltd. 19,800.00 7,687.00 11,083.00 326.00 704.00
37 Thornbury SI., Courtice
Plan: 40R-19721 Part: 3, 8
(
CORPORATION OF THE
MUNICIPALITY OF ClARINGTON
PART "F"
NOVEMBER 2003
(.,
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Total Municipal Region English Separate English Public
03,0357 1559354 Ontario Inc. 19,052.00 7,687,00 10,335,00 326,00 704.00
1 Robert Adams Dr., Courtice
Plan: 40R-20102 Part: 8
03.1014-03.1017 H.L. Gay Family Homes Limited 118,800.00 46,122.00 66,498.00 1,956.00 4,224.00
03,1024, 03.1025 Various
Plan; 40M-2113 pt Lot: Various
03,0700 The Kaitlin Group Ltd. 319,434.00 128,586.00 153,768.00 11,736.00 25,344,00
90 Aspen Springs Dr., Bowmanville
Plan: 40R-21548 Part: Bld9 E
03.0740 Kingsway Arms(Clarington) Holdings 124,514.03 99,845,62 2,610.41 8,088.16 13,969.84
65 Clarington Bv., Bowmanville
Con: 1 Lot 15
03,1047 Storybook Homes 19,800.00 7,687.00 11,083.00 326,00 704,00
7 Old Kingston Rd., Courtlce
Plan: 40R-19834 Part: 24
03.1048 Storybook Homes 19,800.00 7,687.00 11,083.00 326.00 704.00
94 Auburn La" Courtice
Plan: 40R-21385 Part: 8, 16
TOTALS I 1,013.032.4811 456,899.90 I 465,846.21 29,746.91 60,539.46
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "G"
DECEMBER 2003
(.,
I'
C
Building Name of Owner/Applicant II Development Charges Education
Permit No. Construction Address Total . . I Region English Separate English Public
03.1146 Port of Newcastle Homes Inc. 19,800.00 7,687.00 11,083.00 326.00 704.00
1 Rosemeadow Cr, Newcastle
Plan: 40M-2161 PI Lot: 1
03.0699 Aspen Heights II Ltd. 319,434.00 128,586.00 153,768.00 11,736.00 25,344.00
102 Aspen Springs Dr., Bowmanville
Plan: 40R-21548 Part: BLDG C
03,1114,03.1118 Grajen Homes 39,600.00 15,374,00 22,166.00 652.00 1,408.00
Harmer Dr., Newcastle
Plan: 40M-2166 pt Lot: 84, 51
03.1141,03.1142 Cleary Homes 39,600.00 15,374.00 22,166.00 652.00 1,408.00
Aylesworth Ave, Courtice
Plan: 40M-2113 PI Lot: 56, 66
03.1157 1331074 Ontario Inc. 18,028.00 7,687.00 9,311.00 326.00 704.00
30 Ratton SI, Newcastle
Plan: 40M-2166 Pt Lot: 91 R
03,1156 1331074 Ontario Inc. 18,028.00 7,687.00 9,311.00 326,00 704,00
26 Ratton St, Newcastle
Plan: 40M-2166 pt Lot: 91L
03,1163 Cleary Homes 19,800.00 7,687.00 11,083.00 326.00 704.00
100 Fenning Dr, Courtice
Plan: 40M-2113 pt Lot: 138
03.1181 Cleary Homes 19,800.00 7,687.00 11,083.00 326.00 704.00
28 Aylesworth Ave, Courtice
Plan: 40M-2113 PI Lot: 54
"
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "G"
DECEMBER 2003
'-'
r",_
Building Name of Owner/Applicant I I Development Charges Education
Permit No. Construction Address Tot". Municipal Region English Separate English Public
03,0956,03,1018,03.11 H.L. Gay Family Homes Limited 99,000.00 38,435,00 55,415,00 1,630,00 3,520,00
03,1150,03,1151 Various
Plan: 40M-2113 pt Lot: Various
03,1172,03,1173 Port of Newcastle Homes Inc. 36,056.00 15,374,00 18,622,00 652,00 1,408.00
Caldwell Cr., Newcastle
Plan 40M-2161 PI Lot: 24 R & L
03,1139,03,1138 Clarnew Developments Inc. 39,600.00 15,374,00 22,166,00 652,00 1,408,00
Newcastle
Plan: 40M-2166 PI Lot: 37 & 9
03,0282 Clarington Toyota 68,398.15 25,665,23 37,369,20 1,966,75 3,396,97
395 Baselind Rd, Sowmanville
Con: SF Lol14
TOTALS 737,144.15 292,617 .23 383,543,20 19,570.75 41,412.97
,
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON PART "G" "
DECEMBER 2003
CONTRIBUTIONS - CASH-IN-L1EU OF PARKLAND
0,00
Total Cash-In-Lieu of Parkland 0.00
CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES
0,00
-
,
'-.'
"" Total Engineering and Inspection Fees Contributions 0.00
"
CONTRIBUTIONS - ROADS
0,00
Total Roads Contributions 0.00