The URL can be used to link to this page

Home My WebLink AboutFND-005-01 04._ '- '" CI![#]gron REPORT FINANCE DEPARTMENT Meeting: GENERAL PURPOSE AND ADMINISTRATION COMMITTEE MONDAY, SEPTEMBER 17, 2001 Resolution #:ufl--WJ-O / FND-005-01 File #: HOC/! By-law #: Date: Report #: Subject: CASH ACTIVITY - JULY 2001 Recommendations: It is respectfully recommended that the General Purpose and Administration Committee recommend to Council the following: 1. THAT Report FND-005-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 July 31,2001, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of July 2001 be confirmed S,bm;'.' by, &~., Director of Finance. Reviewed bQ~~ Franklin Wu, Chief Administrative Officer. NT/LG/hjl 911 . -, REPORT NO.: FND-005-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 July 31, 2001 and the comparative information for the month ended July 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 912 '-- CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of July 2001 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED LINEAR PROPERTIES ONTARIO POWER GENERATION - ROAD WATCH PRGM DURHAM REGION - 1998 PROVINCIAL OFFENCES SHARE PROVINCIAL GOV'T-COMMUNITY REINVESTMENT FUNDING 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 BANK BALANCE JUNE 2001 1 ,799,493 1,949.165 2.000 107,204 o 309.994 652,459 41,707 o 192.628 5,054,650 963,514 5,575.860 o 1,600,216 8.139,590 3,084,940 NET CASH PROVIDED I USED JULY 2000 MNk .". ,', .,. . .,',-.,.- .. $A\Aii!9$ JUiLY2Mt 11 ,499,273 1,886,416 2,163.126 10,000,000 43,305,236 ..,-.'.'...'.',.,...... ',":-:.;.:.:.,.:.:.:-:-:. ',--""'--'" ,':::':::::::::::::::'::: (8,781,309J)@:?,$$4L (1 ,392,375)U.ii#~,ci,.ij 11 ,007f:!m~~ o 1M(jQ,PP(j 4.011,105 4'Mj~:a4j PART "A" BANK BALANCE JULY 2000 2,887,146 2,245,907 o o 49,019,911 ..............,.,...,.. .,.:.,.:.:.:.:-:.;.:.:-:. ::,::,::::;::,::;:::::=:: 68,854,051 6, 151.572627{)2:47~ 54.152,964 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. 913 ORPORATION OF THE MUNICIPALITY OF CLARINGTON ontinuity of Taxes Receivable or the month of July 2001 JUNE iJO~Y 2001 INTEREST TAXES PAYMENTS $IM RECEIVABLE ADDED BILLED BALANCE I ADJUSr" Ni:lt~~ CURRENT YEAR PRE-AUTHORIZED PYMT (3,061,417) TAXES 2,713,026 0 2,713,026 PENALTY AND INTEREST 61,809 32,179 93,989 FIRST PRIOR YEAR TAXES 3.554,830 247,288 3.802.119 PENALTY AND INTEREST 189.769 28,335 218.104 SECOND PRIOR YEAR TAXES 1,144,446 27,655 1,172,102 PENALTY AND INTEREST 175,346 14.935 190.282 THIRD & PRIOR YEARS TAXES 1,275,225 1,275.225 PENALTY AND INTEREST 498,903 16,602 515,506 TOTAL 6,551.939 92,052 274,944 9,980,351 1,171,510 Includes refunds, write-efts, 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. 914 PART "8" JULY 2000 Note 2 1.921.129 94,288 2,618.150 245.194 1,260,904 217.707 1,085,357 447,971 7.890.702 "- CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART lie" STATISTICAL INFORMATION FOR THE MONTH OF JULY 2001 JULY YEAR TO DATE Tax Certificates 141 621 Number of Properties eligible for Tax Reqistration (see Note 1) 110 H see Note 2 Accounts Payable Cheques Issued #43663 to #44145 483 3,752 Number of Births Reoistered 49 286 Number of Deaths Reqistered 54 325 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. 915 '- CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT JULY 31,2001 PART "0" I I FINANCIAL INVESTMENT INTERES' # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE GENERAL FUND MTL 1,989,280.00 4.47% 44 2,000,000.00 Aug. 17/01 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/01 MTL 986,560.00 4.44% 112 1,000,000.00 Sent.26/01 TOTAL GENERAL FUND 101@o.@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 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.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 . 500,000.00 6.10% 365 500,000.00 Sept 7/01 916 ~ CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT JULY 31,2001 PART 11011 ~ANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY TITUTION COST RATE O/S VALUE DATE RESERVE FUND RBC RBC RBC RBC RBC' RBC RBC . RBC RBC . RBC WOOD GUNDY' RBC RBC RBC RBC RBC RBC WOOD GUNDY' RBC RBC RBC HSBC RBC TOTAL RESERVE FUND TOTAL INVESTMENTS 1,566,466.88 933,400.00 58,479.40 25,125.57 250,000.00 427,625.00 250,000.00 1.323,000.00 1 ,056,000.00 20,558.85 638,000.00 945,210.00 43,523.00 1,149,347.43 649,589.48 942,893.00 855,000.00 485,000.00 1,392,611.00 548,000.00 534,978.37 2,514,436.37 118,693.50 ....."."......... $w.w:m).O$ ."....."."...... .,--..-.,'"..-.. ., .... . ... ... ..-....."."... .,...-..-....-.',.,'......-... ."....."."...... ..,.,..-....-..,.,..',.,..-....-.-. ..-.....".".. .. . ........"."... 4tSl$:S4J;O$k . Investment interest paid on a monthly/semi-annual/annual basis 5.30% 5.20% 5.95% 5.95% 4.75% 5.50% 5.25% 5.00% 5.00% 5.20% 5.40% 5.60% 5.50% 4.60% 5.95% 6.30% 5.35% 4.35% 4.60% 5.40% 5.20% 4.45% 5.10% 917 1386 1827 2032 2025 1839 1628 180 365 365 1310 1598 730 1095 329 1185 1825 1832 365 365 1507 1729 90 1976 1,904,519.00 1,202,670.00 80,639.00 34,613.00 250,000.00 542,878.00 250,000.00 1,389,150.00 1,108,800.00 24,645.00 638,000.00 1,054,038.00 51,107.00 1,197,000.00 783,582.00 1,239,904.30 1,065,102.90 485,000.00 1 ,456,671.11 548,000.00 679,942.00 2,542,026.28 155,297.00 Nov. 15/04 Nov 12/02 Dec 15/02 Dee 15/02 June 21/03 Dec 1/01 Jun 21/04 May 1/02 May 28/02 Jan 9/02 June 1/05 Dec.21/02 Dec.21/03 Jan.31/02 Dee 2/01 Oct 27/03 Mar 1/04 Apr. 1/02 Mar.15/02 Apr 7/03 Dec 1/03 Oct. 3/01 OCT 15/04 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" JULY 2001 Develo ment Char es Education Education Town Re ion En lish Se arate En lish Public avid B. Thomas 6,250.00 1,945.00 219.00 704.00 OM2009 B/P#01.0323 .Stapleton 96.00 814 Stapleton Road L.2, C.2, Clarke B/P#01.0465 R.Tisnovsky 240.00 617 lakeshore Road L.6. BFC.. Clarke B/P#01.0462 H.E. Witzke 4.370.66 1621 Pebblestone Road B/P#01.0285 Devons Down Dav. 25,000.00 23,691.00 876.00 2,816.00 (Fridel limited) OR19730 IP#01.0457-460 63639 Ontario Ltd. 12,500.00 466.00 438.00 1,408.00 Simkins Homes) OM1954 B/P#01.0450-451 73666 Ontario Ltd. 12,500.00 17,748.00 438.00 1,408.00 OM2022 .12, C.2, Bowmanville IP#01.0447-448 R.Perry 6,250.00 219.00 704.00 108 Manvers Dar!. Townline IP#01.0416 1138337 Ontario Inc. 6.250.00 263.00 219.00 704.00 (Kaitlin Group) OM 1984 l.28, BFC, Clarke B/P#01.0380 1138337 Ontario Inc. 56,916.00 76.728.00 1,971.00 6,336.00 (Kaillin Group) 40M2036/40M2003 l.28. BFC, Clarke B/P#01 .0084,171,388,393.394,454-456, B/P#01.480 918 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" JULY 2001 CONTRIBUTIONS - CASH-iN.LIEU OF PARKLAND A. Robichaud LD2001-064 L.2S, C.2. Clarke 1,250.00 Microceel Conversions L.13, C. 1&2, Clarke 3,600.00 B.McQuarrie LD2001-044 65 Duke Street 2,671.45 Baywood Homes 1ST-S7057 16.750.00 Total Cash-In-Lieu of Parkland Contributions 24,271.45 CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Orchard Park Estates 1ST-S7057 20,433.16 Baywood Homes 1ST-S7057 47,166.S2 Total Engineering and Inspection Fees Contributions 67,599.98 CONTRIBUTIONS - ROADS Total Roads Contributions 920 ~