Loading...
HomeMy WebLinkAboutFND-015-01 ...'! , "", Clw:inglOn REPORT FINANCE DEPARTMENT Meeting: GENERAL PURPOSE AND ADMINISTRATION COMMITTEE MONDAY, DECEMBER 3, 2001 Resolution #: 0tA-~(n-D J FND-015-01 File#: Hac/! By-Iaw#: Date: Report #: Subject: CASH ACTIVITY - OCTOBER 2001 Recommendations: It is respectfully recommended that the General Purpose and Administration Committee recommend to Council the following: 1. THAT Report FND-015-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 October 31, 2001, is as shown on the attached schedule; and 3, THAT Part "A" of the expenditures for the month of October 2001 be confirmed Reviewed bYU ~~~ Franklin Wu, Chief Administrative Officer. Submitted by: Nancy aylor, .BA, CA, Director of Finance. NT/LB/hjl 954 REPORT NO.: FND-015-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 October 31, 2001 and the comparative information for the month ended October 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 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 955 CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of October 2001 PART "A" OCTOBER OCTOBER 2001 2000 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED 15,239,436 2,645,740 CANADIAN WASTE-AUGUST ROYALTIES 33,017 0 SALE OF LAND 0 10,670 BUILD COURTICE FUNDRAISING 0 2,170 HUMAN RESOURCES CANADA - JUNIOR FIREFIGHTERS PROGRA~ 0 3,570 BOWMANVILLE HERITAGE BOOK SALES 162 3,730 DEVELOPMENT CHARGES-TOWN 174,108 263,653 GENERAL 1,500,231 567,340 INTEREST 177,859 135,145 DEVELOPMENT CHARGES-SCHOOL BOARD 26,599 17.451 DEVELOPMENT CHARGES-REGION/PUC 170,485 239,824 17,321,897 4,089,293 USE OF FUNDS: PAYROLL 1,016;187 814,643 REGION LEVY 9,876,712 8,118,623 SCHOOL BOARD LEVIES 61,119 0 GENERAL-INCLUDING CAPITAL EXP'" 2,328,879 2,898,390 13,282,897 11,831,656 NET CASH PROVIDED (USED) 4,039,001 (7,742,363) BANK NET CASH BANK BANK BALANCE PROVIDED BAUANCE BALANCE FINANCIAL POSITION: SEPT 2001 I (USED) OCT 2001 OCT 2000 GENERAL FUND 4,125,427 111,220 4,2:}6,647 2,060,304 RESERVE FUND 1,861,101 1,900,934 3,792,035 382,410 MUNICIPAL BOND INVESTMENTS 2,194.753 10,517 2,205,270 2,164,189 HOST COMMUNITY FUND IN TRUST 10,000,000 0 10,000,000 0 INVESTMENTS (GENERAL + RESERVE FUNDS) 55,472,115 2,016,330 57,488.445 50,844,937 TOTALS 73,653,396 4,039,001 770692:$97 55,451,840 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. 956 PART "6" CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of October 2001 SEPTEMBER OCTOBER OCTOBER 2001 INTEREST TAXES PAYMENTS ,2001 2000 RECEIVABLE ADDED BILLED BALANCE IADJUST. ... Note 2 CURRENT YEAR PRE-AUTHORIZED PYMTS (1,986.499) (1 ,~86,499) 1,986,499 0 TAXES (729,911) 20,582,008 19,852,097 (15,566,133) 4,28!ii964 3,469,171 PENALTY AND INTEREST 80,924 50,573 131,497 (29,396) 1Q2i101< 156,345 FIRST PRIOR YEAR TAXES 3,346,911 247,288 3,594.199 (542,648) $,051,$51 2,257,406 PENALTY AND INTEREST 190,880 22,843 213,723 (23,298) 19Qi42!i 235,419 SECOND PRIOR YEAR TAXES 973,712 27,655 1,001,368 (126,942) 874.426 1,085,052 PENALTY AND INTEREST 156,727 11,792 168,519 (21,174) ,147.:145 203,806 THIRD & PRIOR YEARS TAXES 1,161,188 1,161,188 (37,786) 1,12lM02, 980,932 PENALTY AND INTEREST 447,353 14,191 461,544 (19,834) 44~j710, 416,763 ,,' TOTAL 3,641 ,285 0 20,956,350 24,597,635 (14,380,712) 10i216,92~ 8,804,894 ... 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. 957 CORPORATION OF THE MUNICIPALITY OF CLARINGTON STATISTICAL INFORMATION FOR THE MONTH OF OCTOBER 2001 OCTOBER Tax Certificates Number of Properties eligible for Tax Registration (see Note 1) Accounts Payable Cheques Issued #45207 to #45675 Number of Births Registered Number of Deaths Registered 95 105 469 67 37 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. 958 PART "e" YEAR TO DATE 883 .. see Note 2 4,819 421 438 CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT OCTOBER 30, 2001 PART "0" FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY INSTITUTION COST RATE OIS VALUE DATE GENERAL FUND BMO 2,986,110.00 3.03% 56 3,000,000.00 Dec, 14/01 BMO 1,994,120,00 3.08% 35 2,000,000.00 Nov. 23/01 TO 1,997,640.00 2,70% 16 2,000,000,00 Nov, 14/01 TO 2,992,410,00 2,65% 35 3,000,000.00 Dec. 3/0 1 CIBC 2,990,850.00 2.54% 44 3,000,000.00 Dec. 12/01 liTO 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 2Q,1l3Q,500.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. 5/05 RBC . 1,482,702.57 5,50% 1825 1,487,000.00 Feb. 13/06 959 CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT OCTOBER 30, 2001 PART "0" 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 15102 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 9102 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,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 40891.57 5,20% 482 43,171.00 Dec 15102 TOTAL RESERVE FUND 36,557,944.56 TOTAL INVESTMENTS 57,488,444.56 it Investment interest paid on a monthly/semi-annual/annual basis 960 CORPORATION OF THE MUNICIPALITY OF CLARINGTON OCTOBER 2001 PART "E" , Education Education Development Charges fatal Town Region English Separate En9lish Public E. Lukow 32,842.00 13,832,00 17,164,00 438.00 1,408.00 LD153-156/1999 60 Martin Rd BIP #00.0726 - 727 1462060 Ontario Inc 1M$3;OO 6,916,00 9,644,00 219.00 704.00 40M2038 44 Bloom Ave, Newcastle BIP #01.0798 Kim Ravary 9,953:00 6,916.00 2,114.00 219,00 704.00 4890 McCullogh Rd, Clark Township BIP #01.0668 Dunbury Homes 24,513.00 13,832.00 8,835,00 438.00 1,408,00 40M2038 SIP #01.0423 - 424 Mirtren Contractors 5,306.52 4,070.28 296.77 939.47 2151 South Service Rd. BIP #01.0616 Ridge Pine 7,839.00 6,916.00 - 219.00 704.00 84 Wilmont Trail BIP #01.0827 Clearview Development 8,125.00 6,916.00 286.00 219.00 704.00 40M2038 BIP #01.0433 John Rutledge 17,483,00 6,916.00 9,644.00 219.00 704.00 40R 17777 151 Beaver St. Newcastle SIP #01.0800 Prestonvale Heights Limited 17,529.72 6,962.72 9,644,00 219.00 704.00 40M 1929 33 Glen Eagles Dr, Courtice BIP #01.0775 Prestonvale Heights Limited 17,529,72 6,962.72 9,644.00 219.00 704.00 40M1929 29 Glen Eagles Dr, Courtice BIP #01.0806 Prestonvale Heights Limited 17,529.72 6,962,72 9,644.00 219.00 704.00 40M 1929 37 Glen Ea91es Dr, Courtice SIP #01,0805 The Toronto Dominion Bank 17,529,72 6,962.72 9,644.00 219.00 704.00 40M1929 94 Huntington Cr, Courtice SIP #01.0804 961 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "e" OCTOBER 2001 Education Education Development Charges Total Town Region English Separate English Public Sf. Stephens Estates Inc. 17,483.00 6,916,00 9,644.00 219.00 704.00 40M2043 205 Sprucewood Cr, Bowmanville BIP #01,0635 Sf. Stephens Estates Inc, 17,483.00 6,916,00 9,644,00 219.00 704,00 40M2043 209 Sprucewood Cr, Bowmanville BIP #01.0652 BCR Construction 3,037.00 - 2,114.00 219.00 704.00 40M1897 15 Westlake St, Solina BIP #01,0783 Detox Environmental 7,397.21 2,471.94 4,174.48 180.23 570.56 322 Bennett Rd, Bowmanville BIP #98,1006 Detox Environmental 1,659,03 1,045.48 147.29 466.26 322 Bennett Rd, Bowmanville BIP #98.1006 R-line Construction 349,79 349,79 1 ,653 Taunton Rd, Darlin9tion BIP #01.0807 1138337 Ontario Inc, 8,092.00 6,916,00 253.00 219.00 704.00 40M 1984 5 Beacham Cr., Newcastle BIP #00.0158 1138337 Ontario Inc. 8,092.00 6,916.00 253.00 219,00 704,00 40M 1984 7 Beacham Cr., Newcastle BIP #00.0157 1138337 Ontario Inc. 17,483.00 6,916.00 9,644.00 219.00 704.00 40M2036 6 Catherwood LA, Newcastle SIP #01,0846 1138337 Ontario Inc, 17,483.00 6,916.00 9,644.00 219.00 704.00 40M2003 190 Shipway Av, Newcastle SIP #01.0814 1138337 Ontario Inc, 16,421.00 6,916,00 8,582.00 219.00 704,00 40M2003 58 Beacham Cr, Newcastle BIP #01,0813 1138337 Ontario Inc, 16,421.00 6,916,00 8,582.00 219,00 704.00 40M2003 56 Beacham Cr, Newcastle SIP #01.0812 9 2 . ~ CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART liE" OCTOBER 2001 Education Education Development Charges Total Town Region English Separate English Public Bruce McQuarrie 17,483'00 6,916.00 9,644.00 219.00 704.00 40R20599 65 Duke St, Bowmanville BIP #01.0843 Keuning Construction Ltd. 3,037.00 - 2,114.00 219.00 704.00 40M1826 38 Virtue Ct, Enniskillen B/P #01.0792 Dunbury Homes (Newcastle) Ltd. 8,125.00 6,916,00 286.00 219.00 704.00 40M2038 65 Bloom Av, Newcastle BIP #01.0430 Don Organ 17,483.00 6,916.00 9,644.00 219,00 704.00 40R18141 115 Beaver St, Newcastle BIP #01,0847 TOTALS 371,192A3 174,108.37 170,485.48 6,318.29 20,280.29 CONTRIBUTIONS - CASH.IN-LIEU OF PARKLAND Devon Downs 18T-90004 7,700.00 Vanginhoven LD 137/2001 800.00 8,500.00 CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Devon Downs Development Ltd 7,557.57 Region of Durham Storm Sewers 405.00 Green Martin Holdings Ltd. Clarington Corners Subdivision 22,433.87 Prestonvale Heights Ltd. Huntington Subdivision 20,620.67 Total Engineering and Inspection Fees Contributions 51,017.11 CONTRIBUTIONS - ROADS Total Roads Contributions