The URL can be used to link to this page

Home My WebLink AboutFND-004-02 '1::'" .. CI~ilJglOn REPORT FINANCE DEPARTMENT Date: GENERAL PURPOSE AND ADMINISTRATION COMMITTEE MONDAY, FEBRUARY 18, 2002 Resolution #:hll/-rKe-oA. Meeting: Report #: FND-004-02 ".- '} File#: / /i eil By-law #: Subject: CASH ACTIVITY - NOVEMBER 2001 Recommendations: It is respectfully recommended that the General Purpose and Administration Committee recommend to Council the following: 1. THAT Report FND-004-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 November 30 2001, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of November 2001 be confirmed O~ Reviewed by: ~ Franklin Wu, Chief Administrative Officer. NT/LG/hjl 1309 --' . REPORT NO.: FND-004-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 November 30, 2001 and the comparative information for the month ended November 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 1310 " CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of November 2001 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED LINEAR PROPERTIES DEBENTURE PROCEEDS-LIBRARY/MAC EXPANSION BOWMANVILLE HERITAGE BOOK SALES 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 BOND INVESTMENTS HOST COMMUNITY FUND IN TRUST . INVESTMENTS (GENERAL + RESERVE FUNDS) TOTALS NOVEMBER 2000 4,688,391 o o o 72,023 753,043 132,965 28,189 102,033 5,776,644 1,069,299 o o 2,289,525 3,358,824 2,417,820 BANK NET CASH BALANCE PROVIDED OCT 2001 / USED 4,236,647 3,899,060 3,762,035 409,863 2,205,270 10,119 10,000,000 0 57,488,445 2,127,927 77,692,397 6,446,969 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. 1311 .'.:.:. B. A.. N.'.K . . . . li\+~~~p$ NOV200j . .. ... ...-....-....-.-. ....."..-.. .--.---..... ...... . ... ........-... .-.".-.-,',".-,',".-,"." .....-...--.. .---_.. ... M:l$!7q! 4:i7j:~~~ @g!~:?W jp,qqp:qpp $MJ$:>72 PART "A" BANK BALANC NOV 200 2,606,853 166,587 2,180,566 o 52,915,654 . . . .. . .......". .-,".-."-',-.",".-.",','. .-',-.-.-.-.-.-,-.-.-.'. .-.--..--. . .. .. .. ,.......... Mi39i366 57,869,660 PART "B" CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of November 2001 OCTOBER 2001 INTEREST RECEIVABLE ADDED TAXES BILLED f\ll)'i!"E;r~i1I'l pI PAYMENTS:i!ooi BALANCE /ADJUST.... NOVEMBER 2000 Note 2 CURRENT YEAR TAXES 4,285,964 2,583,880 6,869,844 4,293,819 PENALTY AND INTEREST 102,101 73,854 0 175,955 156,700 FIRST PRIOR YEAR TAXES 3,051,551 2,578,676 5,630,227 2,078,119 PENALTY AND INTEREST 190,425 22,169 0 212,594 213,307 SECOND PRIOR YEAR TAXES 874,426 1,737,552 2,611,978 966,668 PENAL TV AND INTEREST 147,345 10,688 0 158,033 172,082 THIRD & PRIOR YEARS TAXES 1,123,402 1,123,402 949,392 PENALTY AND INTEREST 441,710 13,742 0 455,452 409,340 TOTAL 10,216,923 120,454 6,900,108 17,237,485 9,239,427 Includes refunds, write-ofts, 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. 1312 '.' CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C" STATISTICAL INFORMATION FOR THE MONTH OF NOVEMBER 2001 NOVEMBER YEAR TO DATE Tax Certificates 57 940 Number of Properties eligible for Tax ReQistration (see Note 1) 101 .. see Note 2 Accounts Payable Cheques Issued #45676 to #46135 and #52352 to #52463 (Note 3) 571 5,390 Number of Births Reoistered 36 457 Number of Deaths Reoistered 34 472 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. Note 3: New Number Series for Accounts Payable Cheques. 1313 . CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT NOVEMBER 30, 2001 PART "D" FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE GENERAL FUND BMO 2,986,110.00 3.03% 56 3,000,000.00 Dec. 14/01 BMO 997,770.00 2.63% 31 1,000,000.00 Dec. 6/01 TD 2,992,590.00 2.58% 35 3,000,000.00 Dec. 10/01 . TO 2,992,410.00 2.65% 35 3,000,000.00 Dec. 3/01 CIBC 2,990,850.00 2.54% 44 3,000,000.00 Dec. 12/01 TO 2,990,550.00 2.51% 46 3,000,000.00 Dec. 21/01 TO 1,496,280.00 2.21% 41 1,500,000.00 Jan. 1 0/02 TD 1,495,770.00 2.20% 47 1,500,000.00 Jan. 16/02 TO 3,793,312.00 2.30% 28 3,800,000.00 Dec. 21/01 TOTAL GENERAL FUND ti;7~5i;~i'OQ 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 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 . 574,000.00 6.25% 548 574,000.00 Dec.30/01 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. 28/03 1314 " CORPORATION OF THE MUNICIPALITY OF ClARINGTON INVESTMENTS OUTSTANDING PART "D" AS AT NOVEMBER 30,2001 FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY INSTITUTION COST RATE OIS 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 Dee 15/02 RBC 25,125.57 5.95% 2025 34,613.00 Dee 15102 RBC' 250,000.00 4.75% 1839 250,000.00 June 21/03 RBC . 250,000.00 5.25% 180 250,000.00 Jun 21104 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 942,893.00 6,30% 1825 1,239,904.30 Oct 27103 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 Dee 1/03 HSBC 2,542,026.28 3.20% 61 2,555,620.90 Dec. 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 40,891.57 5.20% 482 43,171.00 Dec 15/02 TOTAL RESERVE FUND ~1j.8e(j;1'~il!oa ,.".....-,--- "",",-,--'-"'-" """','--,---" "'-,",-, ',", "-'-' ..... . ..-- ',',' , . , , - , . - . ',' . - . "-'-'.-,",',",", ... ", ,",.,'-'-' ,.".' . " .- TOTAL INVESTMENTS t;~,eij;,@boa . Investment Interest paid on a monthly/semi-annual/annual basis 1315 '! CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" NOVEMBER 2001 Education Education Develo ment Char es Town Re ion En IIsh Se arate En IIsh Public 1441660 Ontario Inc. 6,916.00 8,582.00 219.00 704.00 40M.1945 pt Lot:10L 81 Cecil Found Cr., Courtice BIP #01.0675 1441660 Ontario Inc. 6,916.00 8,582.00 219.00 704.00 40M-1945 Pt Lot:1 0 79 Cecil Found Cr., Courtice BIP #01.0674 Ridge Pine Park Inc. 6,916.00 219.00 704.00 93 A Wilmot TL Wilmont Creek Con: BF Lot 1 pt Lot:248A BIP # 01.0888 673666 Ontario Limited 6,916.00 286.00 219.00 704.00 40M-2022 pt Lot:48 609 Longworth Ave., Bowmanville BIP #0.0866 673666 Ontario Limited 6,916.00 286.00 219.00 704.00 40M-2022 pt Lot:49 609 Longworth Ave., Bowmanville BIP #0.0867 Barry Westerman 6,916.00 2,114.00 219.00 704.00 40R-20456 Part: 3 2098 Nash Rd Darlington, Courtice BIP #01.0902 Storybook Homes 6,916.00 9,644.00 219.00 704.00 40R.19834 Part: 13 27 Old Kingston Rd., Couritce BIP #01.0924 Dunbury Homes (Newcastle) Ltd. 6,916.00 286.00 219.00 704.00 40M-2038 pt Lot:36 160 Brookhouse Dr., Newcastle BIP #01.0626 Dunbury Homes (Newcastle) Ltd. 6,916.00 286.00 219.00 704.00 40M.2038 Pt Lot:46 196 Brookhouse Dr., Newcastle BIP #01.0913 Dunbury Homes (Newcastle) Ltd. 6,916.00 9,644.00 219.00 704.00 40M-2038 pt Lot: 119 125 Brookhouse Dr., Newcastle BIP #01.0912 Luigi lam marino 6,916.00 9,644.00 219.00 704.00 Con: 3 Lot 35 1434 Nash Rd., Courtice BIP #01.0779 131 6 , CORPORA nON OF THE MUNICIPALITY OF CLARINGTON PART "E" NOVEMBER 2001 Develo ment Char as Town Re ion Iish Public Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M.2064 pt Lot:6l B/P #01.0878 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 pt Lot:5R BIP #01.0877 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 Pt Lot:5L B/P #01.0876 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 pt lot:4R B/P #01.0875 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M.2064 Pt Lot:4L B/P #01 .0874 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 pt Lot:3R B/P #01.0873 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M.2064 Pt Lot:3L B/P #01.0872 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 pt Lot:9R B/P #01.0885 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M.2064 Pt Lot:9l B/P #01.0884 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 PI Lot:8R B/P #01.08S3 Fridel Limited 6,918.00 8,582.00 219.00 704.00 40M-2064 pt Lot:8L B/P #01.0882 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M-2064 Pt Lot:7R B/P #01.0881 Fridel Limited 6,916.00 8,582.00 219.00 704.00 40M.2064 Pt Lot:7L B/P #01.0880 TOTALS 255,892.00 278,464.38 8,103.00 26,048.00 1318 , . CORPORATION OFTHE MUNICIPALITY OF ClARINGTON PART "E" NOVEMBER 2001 CONTRIBUTIONS. CASH-iN-liEU OF PARKLAND TSC REALTY 7,000.00 7,000.00 CONTRIBUTIONS - ENGINEERiNG AND INSPECTION FEES Total Engineering and Inspecllon Fees Contributions . CONTRIBUTIONS - ROADS CLARINGTON IND. SERVo DEV. 98.070 14S,000.00 Total Roads Contrlbullons 148,000.00 1319