HomeMy WebLinkAboutFND-007-01
"
.
Clw:ilJgtoH
REPORT
FINANCE DEPARTMENT
Date:
GENERAL PURPOSE AND ADMINISTRATION COMMITTEE
MONDAY, OCTOBER 22,2001 Resolution #t;//l-533-o /
Meeting:
Report #:
FND-007-01
File#:
'-'
I-laC/?-
.
By-law #:
Subject:
CASH ACTIVITY - AUGUST 2001
Recommendations:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report FND-007-01 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 August 31,2001. is as shown on
the attached schedule; and
3. THAT Part "A" of the expenditures for the month of August 2001 be confirmed
Submitted by:
Reviewed t>(' ') rtZ~<..& .-cU~
Franklin Wu.
Chief Administrative Officer.
NT/LB/hjl
920
,
REPORT NO.: FND-007-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 August 31, 2001 and the comparative information for the month
ended August 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 - 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
921
,
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
Analysis of Revenue and Expenditures
for the Month of August 2001
PART "A"
AUGUSTi AUGUST
2001 2000
REVENUE RECEIVED FOR GENERAL OPERATING
AND RESERVE FUND PURPOSES:
TAX PAYMENTS RECEIVED 954,278 1,386,074
LINEAR PROPERTIES 0 0
LAND SOLD TO lESSMAN CREMATORIUM 54,000 0
RUTHERFORD DONATION-SIDNEY B. RUTHERFORD WOODS WAl 0 10,000
VERIDIAN CORP. - PREPAID INTEREST PROMISSORY NOTE 0 936,000
PROVINCIAL GOV'T-MAIN STREET MILLENNiUM PROJECTS 0 33,762
BOWMANVILLE HERITAGE BOOK SALES 482 0
DEVELOPMENT CHARGES-TOWN 307,150 282,536
GENERAL 525,267 617,883
INTEREST 75,489 763,980
DEVELOPMENT CHARGES-SCHOOL BOARD 48,260 9,783
DEVELOPMENT CHARGES-REGION/PUC 279,720 250,948
2.244,646 4,290,966
USE OF FUNDS:
PAYROLL 1,6-14,198 1,465,405
REGION LEVY 0 0
SCHOOL BOARD LEVIES 0 0
GENERAL-INCLUDING CAPITAL EXP:' 3,351,255 2,714,450
4,965,453 4,179,855
NET CASH PROVIDED (USED) (2,720,807 111,111
BANK NET CASH HBI\!\i!Ki BANK
BALANCE PROVIDED !i!~LAl!li$B BALANCE
FINANCIAL POSITION: JULY 2001 /(USED) ;;Ji:tJG!~dO,1 AUG 2000
GENERAL FUND 2,717,964 (1,303,087) 1;414,877 1,494,796
RESERVE FUND 494,041 520,143 1,014,184 2,094,028
MUNICIPAL BOND INVESTMENTS 2,174,133 10,525 2,184,658 2,049,865
HOST COMMUNITY FUND IN TRUST 10.000,000 0 10,000,000 0
INVESTMENTS (GENERAL + RESERVE FUNDS) 47,316,341 (1,948,388) i4i5i367,;g53 48,625,386
TOTALS 62,702,479 (2,720,807) 59;~81 ,8712 ; 54,264,075
NOTE Ai Difference in comparison between years due to timing difference in receipt of funds,
922
CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "8"
Continuity of Taxes Receivable
for the month of August 2001
JULY AUG'IllST AUGUST
2001 INTEREST TAXES PAYMENTS 200'1 2000
RECEIVABLE ADDED BILLED BALANCE / ADJ UST. ... Note2
CURRENT YEAR
PRE-AUTHORIZED PYMT (3,515,513) (457,484) (3,97~;99~~
TAXES 2,051,161 2,051,161 (40,181) 2,010,980, 1,199,624
PENALTY AND INTEREST 78,994 29,199 108,193 (10,844) 97,34$: 122,805
I,
FIRST PRIOR YEAR
TAXES 3,885,825 3,885,825 (200,342) 3,685,483 2,761,711
PENALTY AND INTEREST 189,739 27,587 217,325 (15,810) 201,51$ 252,418
SECOND PRIOR YEAR
TAXES 1,161,956 1,161,956 (79,606) 1 ,082,350 1,375,111
PENALTY AND INTEREST 163,472 13,591 177,064 (13,711) 16!\,3SW 221 ,455
THIRD & PRIOR YEARS
TAXES 1,266,521 1 ,266,521 (31,076) 1 ,235,44i4i 1,071,716
PENALTY AND INTEREST 465,271 15,458 480,729 (21,362) i4i59,367 446,672
TOTAL 9,262,938 85,835 0 9,348,772 (412,932) 4;9~2M4: 7,451,511
... 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 2i For information purposes only. True comparison to prior year not applicable due to changes in the tax legislation.
NOTE 3: 2001 Final Tax Billing sent out. Installments due September and October 2001.
923
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
PART "C"
STATISTICAL INFORMATION
FOR THE MONTH OF AUGUST 2001
AUGUST
YEAR TO DATE
Tax Certificates 77 698
Number of Properties eligible for Tax
Registration (see Note 1) 102 .. see Note 2
Accounts Payable Cheques Issued
#44146 to #44743 598 4,350
Number of Births Registered 45 331
Number of Deaths Registered 50 375
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,
924
'.
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT AUGUST 31,2001
PART "0"
FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY
INSTITUTION COST RATE O/S VALUE DATE
GENERAL FUND
TD 1,983,660.00 4.42% 68 2,000,000.00 Sept. 1 0/01
MTL 989,170.00 4.44% 90 1,000,000.00 Oct. 2/01
MTL 4,931,600.00 4.44% 114 5,000,000.00 Sept.28/0 1
MTL 986,560,00 4.44% 112 1,000,000.00 Sept.261O 1
TOTAL GENERAL FUND 8,890,1190.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.15/06
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
RBC . 500,000.00 6.10% 365 500,000.00 Sept 7/01
925
<,
CORPORATION OF THE MUNICIPALITY OF CLARINGTON
INVESTMENTS OUTSTANDING
AS AT AUGUST 31,2001
PART "D"
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 1/05
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 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 1/03
HSBC 2,514,436,37 4.45% 90 2,542,026.28 Oct. 3/0 1
RBC 118,693.50 5.10% 1976 155,297.00 OCT 15/04
RBC 40891.57 5.20% 482 43,171.00 Dec 15/02
I~OTALRESERVEFUND 36,476,962.65
I~OTALINVESTMENTS 45,367,952.65
. Investment interest paid on a monthly/semi-annual/annual basis
926
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON PART "E"
AUGUST 2001
Develo ment Char es Education Education
Town Re ion En lish Se arate En lish Pub Ii
Tatra Valley Homes 657,00 2,112.00
10M833
B/P#01.0494-496
Ridge Pine P.ark 21,414.00 657.00 2,112,00
Lots 28A,36A,37 A, 111
B/P#01,0585-587
St. Stephen's Estates 55,328.00 77,152.00 1,752.00 5,632.00
40M2048
L.8, C.2, BowmanviUe
B/P#01.0498-503,547-552
St. Stephen's Estates 50,000.00 63,176,00 1 ,752.00 5,632.00
40R20341
L.8, C.2, Bowmanville
BIP#01.0472-477,478-479
Oshawa Ski Club 172.85 3,430,00 210.05 664.93
B/P#01.0510
Ontario Power Generation 736.44 2,331.30
B/P#01,0518
Kaitlin Group 27,664.00 38,576,00 876.00 2,816.00
L.17, C.1, Bowmanville
40M2005
B/P#01,0242,250,270,592
673666 Ontario LId, 13,832.00 572.00 438.00 1,408.00
40M2022
B/P#01,0588-589
963639 Ontario LId. 12,500.00 466.00 438.00 1,408.00
(Simkins Homes)
40M1954
B/P#01,0544-545
Hands In Motion 45.19 3.29 10.43
(P.Slemon)
123 King Street East, Bowmanville
B/P#01,0625
927
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON PART "E"
AUGUST 2001
Develo ment Char es Education Education
Town Re ion En lish Se arate En Iish Public
Clarnew Developments 48,412.00 2,002.00 1,533.00 4,928,00
40M2038
B/P#01.0431-432,530-534
Daystar Homes 6,916,00 2,114,00 219.00 704,00
OM2009
B/P#01,0523
Prestonvale Heights 55,701.76 75,028.00 1,752.00 5,632.00
OM1929
B/P#01.0526,540,562-567
T awncor Dav. 1,332.00 40.00
OM 1954
B/P#01.0544-545
Gay Co. 13,832.00 17,164.00 438.00 1,408.00
OM 1994
IP#01.0627-628
OTALS 307,149.80 279,720.00 11,461,78 36,798.66
928
CORPORATION OF THE
MUNICIPALITY OF CLARINGTON
AUGUST 2001
CONTRiBUTiONS - CASH-iN-LIEU OF PARKLAND
Hillside Sodding
LD2001-33 & LD2001-34
Robert R. Owen Holdings Ltd.
(Roy Nichols Motors)
DEV96-064
L.29, C.2, Darlington
Manheim's Oshawa Dealers Exchange
LD200,.,33
Total Cash-In-Lieu of Parkland Contributions
CONTRiBUTiONS - ENGiNEERING AND INSPECTION FEES
Total Engineering and Inspection Fees Contributions
CONTRIBUTIONS - ROADS
Total Roads Contributions
1,990.00
11,500.00
5,829.20
19,319.20
929
PART "E"