HomeMy WebLinkAboutFND-013-01
"
Clw:illgton
REPORT
FINANCE DEPARTMENT
Meeting:
GENERAL PURPOSE AND ADMINISTRATION COMMITTEE
MONDAY, DECEMBER 3, 2001 Resolution #:0 fA - /dJ<;-o I
Date:
Report #: FND-013-01
File #: F/6C../1
By-law #:
Subject:
CASH ACTIVITY - SEPTEMBER 2001
Recommendations:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report FND-013-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 September 30, 2001, is as shown
on the attached schedule; and
3. THAT Part "A" of the expenditures for the month of September 2001 be
confirmed
Submitted by:
Reviewed bt:.)~-::.~.
Franklin Wu,
Chief Administrative Officer.
NT/LB/hjl
935
.
REPORT NO.: FND-013-01
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 September 30, 2001 and the comparative information for the
month ended September 30, 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
936
CORPORATION OF THE MUNtCIPALlTY OF CLARINGTON
Analysis of Revenue and Expenditures
for the Month of September 2001
PART "A"
SEPTEMSE;f:l SEPTEMBER
2001 2000
REVENUE RECEIVED FOR GENERAL OPERATING
AND RESERVE FUND PURPOSES:
TAX PAYMENTS RECEIVED 18,809,258 14,367,639
LINEAR PROPERTIES 1 ,672,946 0
BUILD COURTICE FUNDRAISING 0 4,879
ONTARIO POWER GENERATION - FAMILY SAFETY DAY DONATION 2,000 0
PITS & QUARRIES - 2000 LICENSE FEES 166,972 151,817
DURHAM REGION -1999 PROVINCIAL OFFENCES 166,000 0
BLUE CIRCLE - COVE ROAD & WESTSIDE CREEK BRIDGE 0 733,739
BOWMANVILLE HERITAGE BOOK SALES 326 0
DEVELOPMENT CHARGES-TOWN 246,460 314,777
GENERAL 1,104,614 690,199
INTEREST 172,212 353,343
DEVELOPMENT CHARGES-SCHOOL BOARD 33,794 13,140
DEVELOPMENT CHARGES-REGION/PUC 188,469 382,335
22,585,051 17,011,868
USE OF FUNDS:
PAYROLL 1,071,019 950,706
REGION LEVY 0 0
SCHOOL BOARD LEVIES 5,581,641 5,361,092
GENERAL-INCLUDING CAPITAL EXP:' 2,260,667 1,769,941
8,913,327 8,081,739
NET CASH PROVIDED (USED) 13,671 ,724 8,930,129
BANK NET CASH Li Lilli<\NK BANK
BALANCE PROVIDED E\{\ILJIJ>j~E BALANCE
FINANCIAL POSITION: AUG 2001 /(USED) LisgPT,?P01 SEPT 2000
GENERAL FUND 1,414,877 2,710,550 4,1'25,4:27 8,565,317
RESERVE FUND 1,014,184 846,917 1 ;861;1 01 1,656,913
MUNICIPAL BOND INVESTMENTS 2,184,658 10,095 2,194,753 2,073,476
HOST COMMUNITY FUND IN TRUST 10,000,000 0 10;099,"00 0
INVESTMENTS (GENERAL + RESERVE FUNDS) 45,367,953 10,104,162 55,472,1.1,5 50,898,497
TOTALS 59,981,672 13,671 ,724 73,f,>sMgp 63,194,203
NOTE A: Difference in comparison between years due to timing difference in receipt of funds.
937
PART "8"
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
Continuity of Taxes Receivable
for the month of September 2001
AUGUST Sl:P'lIIiiiMI'lIiiR SEPTEMBER
2001 INTEREST TAXES PAYMENTS 200,1 2000
RECEIVABLE ADDED BILLED BALANCE IADJUST. :10*"" ~.QI';~L. Note 2
CURRENT YEAR ....
PRE-AUTHORIZED PYMn (3,972,997) (3,972,997) 1,717,395 (2,Z~M02)
TAXES 2,010,980 20,506,272 22,517,252 (23,247,163) '(729,911 ) 5,841,569
PENALTY AND INTEREST 97,349 27,782 125,131 (44,207) 80,924' 132,529
,
FIRST PRIOR YEAR
TAXES 3,685,483 3,685,483 (338,572) 3;346,911 2,314,307
PENALTY AND INTEREST 201,515 26,212 227,727 (36,847) 1,90;880 245,699
SECOND PRIOR YEAR
TAXES 1,082,350 1,082,350 (108,638) ~73,712 1,168,906
PENALTY AND INTEREST 163,353 13,029 176,382 (19,655) 156,1Z1 211,179
THIRD & PRIOR YEARS
TAXES 1 ,235,444 1,235,444 (74,256) 1;i1?1;188 1,019,189
PENALTY AND INTEREST 459,367 15,070 474,436 (27,083) 447,353' 444,627
TOTAL 4,962,844 0 20,588,365 25,551,209 (22,179,027) q,37?,182, 11,378,005
... Includes refunds, write-ofts, 496'5, 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.
NOTE 3: Mortgage companies paid the October 25th, 2001 installment in advance,
938
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
PART lie"
STATISTICAL INFORMATION
FOR THE MONTH OF SEPTEMBER 2001
SEPTEMBER YEAR TO DATE
Tax Certificates gO 788
Number of Properties eligible for Tax
Registration (see Nole 1) 103 .. see Note 2
Accounts Payable Cheques Issued
#44744 to #45206 463 4,350
Number of Births Registered 23 354
Number of Deaths Registered 26 401
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.
939
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT SEPTEMBER 30, 2001
PART "0"
L INVESTMENT INTERES # OF DAYS MATURITY MATURITY
J~ITUTION COST RATE O/S VALUE DATE
GENERAL FUND
TO 5,992,020.00 3.46% 14 6,000,000.00 Oct. 3/01
MTL 989,170.00 4.44% 90 1,000,000.00 Oct. 2/01
~D 997,920,00 3.46% 22 1,000,000.00 Oct.11/01
~D 2,993,280,00 3,42% 24 3,000,000,00 Oct. 15101
TO 2,987,670.00 3.35% 45 3,000,000.00 Nov. 5/01
CIBC 4,981,700,00 3.35% 40 5,000,000.00 Nov. 7/01
TOTAL GENERAL FUND 18,9M,760.00
RESERVE FUND RBC 182,177.00 6,20% 1,095 218,206.00 Aug 1/03
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. 15106
WOOD GUNDY 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 774,999.81 5.25% 1249 922,509.00 Dec 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 . 574,000.00 6.25% 548 574,000.00 Dec.30101
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. 5105
RBC . 1,482,702.57 5.50% 1825 1,487,000.00 Feb. 13/06
940
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT SEPTEMBER 30, 2001
PART "D"
I I FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY
INSTITUTION COST RATE O/S VALUE DATE
RESERVE FUND
RBC 1,566,466.88 5,30% 1386 1,904,519,00 Nov. 15/04
RBC 933,400.00 5.20% 1827 1,202;670.00 Nov 12/02
RBC 58,479.40 5,95% 2032 80,639,00 Dec 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,323,000,00 5.00% 365 1,389,150.00 May 1/02
RBC . 1,056,000.00 5.00% 365 1,108,800.00 May 28/02
RBC 20,558.85 5,20% 1310 24,645.00 Jan 9/02
WOOD GUNDY' 638.000.00 5.40% 1598 638,000.00 June 1105
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.21103
RBC 1,149,347.43 4,60% 329 1,197,000,00 Jan,31/02
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' 485,000,00 4.35% 365 485,000.00 Apr. 1/02
RBC 1,392,611.00 4,60% 365 1,456,671.11 Mar, 15/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 1103
HSBC 2,514,436.37 4.45% 90 2,542,026.28 Oct. 3/01
RBC 118,693.50 5.10% 1976 155,297.00 Oct. 15/04
RBC' 553,392.00 3.70% 732 553,392.00 Sept. 23/03
RBC 40891.57 5.20% 482 43,171.00 Dec 15/02
TOTAL RESERVE FUND ~6 ,S30,~54;6()
TOTAL INVESTMENTS 9()ii4i72,114,65
, Investment interest paid on a monthly/semi-annual/annual basis
941
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
SEPTEMBER 2001
H'I'~llIl Education Education
Development Charges Town Region English Separate English Public
Gallaro Construction 1(\~"."ri 286.00 9,644.00 219.00 704.00
40M-2038 ,".
60 Bloom Ave, Newcastle
BIP #01,0603
St Stephens Estates 34,966.00 13,832,00 19,288.00 438.00 1,408,00
141 & 145 Guildwood, Bowmanville
B/P #01.0614, 615
Ridge Pine Park 47,034.00 41,496.00 - 1,314,00 4,224.00
BIP #01.0719 to 724
..,. ..
Ridge Pine Park 7,839,00 6,916,00 - 219.00 704.00
L.38A
BIP #01,0716
.
Gallaro Construction 6,630.00 6,630,00 - - -
40M-2038
L.64
BIP #01.0603
Clarington Gymnastics Academy 6,320,37 6,320.37 - - -
non-Residential
BIP #01.0633
Clarview Developments 8,12~,00 6,916.00 286.00 219.00 704.00
40M-2038
L16
B/P #01,0425
Steve Devecseri Construction 17,483.00 6,916,00 9,644.00 219.00 704.00
L.35 C.2
15 Townllne Rd. S., Courtice
B/P #01.0624
Ron Forrester 9,953.00 6,916.00 2,114.00 219.00 704.00
40R 14432
38 Water Sf., Kendal
B/P #01,0631
Daystar Homes 9,953.00 6,916,00 2,114,00 219.00 704,00
40M-2009
L.1, 2 Venton Crt, Tyrone
B/P #01.0622
94i
..
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
SEPTEMBER 2001
Education Education
Development Charges Total Town Region English Separate English Public
Joseph Galloro 17,483.00 6,916.00 9,644,00 219.00 704.00
40M-2038
L.102
B/P #01,0643
St Stephens Estates 104:l1$8;PQ 41,496.00 57,864.00 1,314.00 4,224.00
40M20576
L.28,29,30, Bowmanville
B/P #01.0634, 648,651,653
Storage Depot Inc, 14;<l69H8 4,902.06 8,278.84 357.42 1,131.46
CM1223
BIP #01.0608 - 609
Med-Tri Developments 65,664,00 27,664,00 34,328,00 876.00 2,816,00
40R-19533
BIP #01.0656 - 659
Halminon Bldg. Corp. 1M83;00 6,916.00 9,644.00 219.00 704.00
40R19834
L.33C2, 900sgoode Gate Courtice
B/P #0 1, 0673
Prestonvale Heights 32,935.44 13,925.44 17,164.00 438.00 1,408.00
40M-1929
L.34C2
B/P #01.0660, 661
D Wilson 9,953;00 6,916.00 2,114.00 219,00 704.00
1980 Concession Rd 10
BIP #01.0672
Salvatore Ferrara 9,953.00 6,916.00 2,114.00 219.00 704.00
L.18, Con 2 4014 Hwy#2, Clark
BIP #01.0618
Jean Appleby 9,953,00 6,916,00 2,114.00 219.00 704,00
10R329
9400 Grasshopper Park Rd.
BIP #01.0644
P Christensen 9;953.00 6,916.00 2,114.00 219.00 704.00
7700 Carscadden Dr.
BIP #01,0620
943
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
PART "E"
SEPTEMBER 2001
Education Education
Development Charges nt!ffi!1 Town Region English Separate English Public
10
T-D Bank (Gamble) 923:00 - - 219,00 704.00
16Axi Crt
BIP #01.0654
Ridge Pine Park 15,678,00 13,832,00 - 438.00 1,408.00
L.31&179 Willmont Creek
BIP #01.0817 - 818
TOTALS 468,722.59 246,459.87 188,468.84 8,022.42 25,771.46
CONTRIBUTIONS - CASH-IN-LIEU OF PARKLAND
Rogers
SPA-2001-039. Dev 01-057
600.00
Microcell Connexions
SPA-2001-020
1,800.00
Microcell Connexions
SPA-2001-028
1,800,00
4,200.00
CONTRIBUTIONS. ENGINEERING AND INSPECTION FEES
Orchard Park Estates-Refund of overpayment
18T-87057
(2,359,35)
Total Engineering and Inspection Fees Contributions
(2,359,35)
CONTRIBUTIONS - ROADS
Eiram Dav.
Soper Cr. Erosion
2,048.00
2,048.00
4