The URL can be used to link to this page

Home My WebLink AboutFND-003-01 ..., ""<.. . Cl~mgron REPORT Meeting: GENERAL PURPOSE AND ADMINISTRATION COMMITTS,~ //[/ I 6Pf14TO -0 SEPTEMBER 4, 2001 Date: Report #: FND-003-01 File#~ By-law # Subject: CASH ACTIVITY REPORT - JUNE 2001 Recommendations: 1. THAT Report FND-003-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 June 30, 2001, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of June 2001 be confirmed. 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 // /,/ Submitted bY~ c ancy a or, .8. Director of Finance Reviewed by:6c~~ ., CA Franklin Wu, M.C.I.P. Chief Administrative Officer NT/LG/hjl CORPORATION OF THE MUNICIPALITY OF CLARINGTON 40 TEMPERANCE STREET, BOWMANVILLE. ONTARIO L 1C 3A6 T (905) 623-3379 F (905) 623-0608 ~ 957 '. REPORT NO.: FND-003-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 June 30, 2001 and the comparative information for the month ended June 30, 2000. 958 , , CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of June 2001 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED LINEAR PROPERTIES FEDERAL GOV'T-WASTE MGMT STUDY--PORT GRANBY SALE OF LAND: HIGH STREET, BOWMANVILLE CANADIAN WASTE-JAN. TO MAY 2000 ROYALTIES 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 nHHJUNS '...-.-,..........._.,..._. .............. :;lOOt .........,.... ............. '...-..........,...-.....-. .............. .-........................ ............. "--,.,-"-"-" ... ...... .............. ...-.....'"..........._.,. .... ........ ,...,.........,. ..,., .,....... .. . ........ ............. ....,.,...,.,.-.. ... .. ..... ....,.........,. ..., .,'-"-" ... . ........ ............. ,...,.,........,. ..., ,.,...... .... ....... .,.-..,...,....,.,..,..._.,.. .... ..... ...-.-..,.......,.'_.,..._. ........ ..... ............. ............. ............. ..-.,.,......... ..., ,.,..--... .... ....... .-......,.".,.............. ... ........ ......,..,.,.. ..,.,..,'".,',',. .. . . .... .'..,......,.-,-,.,....,.._.,.. . ... ...- .,............,. .,.,..,.,...... .. . ....... ........,..... ~i4, r, 1, ;S,..~~.. .... . ..... ............. .....,...,...... ..,'..,UH,?, ?UO,.. .. ,., .,'-" ..... " ..... /,......,/0 .... .. ..... /,'........,/,..., Q .. .... .... ......"..... ....'..'7..5. ............0... ........".... !~!i!l! ............. .....:a'S.7.S..S.1.... ::<'.::0.:; :'.:::: JUNE 2000 14,201,508 85,772 25,000 193,600 33,221 o 198,852 882,542 180,889 o 181,368 15,982,752 997,713 o 5,361,160 2,216,120 8,574,993 7,407,759 BANK NET CASH BALANCE PROVIDED Ma 2001 / USED 2,343,574 1,750,919 2,152,563 10,000,000 52,362,497 68,609,553 PART "AU ............8."'.....1(.. ....... . Hi.....I'L. HBALANOO .............. J(,jN,~bb~ BANK BALANCE JUN.2000 .............. "............ .............. ............. .............. ........................'... "............ .....................'...... ...,........... ~~(I~~~ ij~tlt~~,.... ~lOOSl~ 1,441,470 1,736,143 o o 54,060,290 .......... ...........". ..".""..... .,........................-. "............ ........".... ..........................-. ......._............',....-. .............. 244,498 ilel~l~f 57,237,903 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. 959 . , CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of June 2001 MAY 2001 INTEREST TAXES RECEIVABLE ADDED BILLED CURRENT YEAR PRE-AUTHORIZED PYMTS (2,606,926) TAXES 2,995,853 PENALTY AND INTEREST 41,240 35,990 FIRST PRIOR YEAR TAXES 3,767,617 PENALTY AND INTEREST 187,381 30,205 SECOND PRIOR YEAR TAXES 1,261,721 PENALTY AND INTEREST 184,831 16,217 THIRD & PRIOR YEARS TAXES 1,351,573 PENALTY AND INTEREST 525,091 17,481 TOTAL 7,708,380 99,893 *** Includes refunds, write-offs, 496's, etc. PAYMENTS BALANCE /ADJUST.*** ....~~,.. ....... . ..i\liMs o 2,995,853 77 ,230 9,785 3,777,402 217,586 1,261,721 201,048 1,351,573 542,571 . . . . . . . . ',' . . . . . . . . - . . - .. -. ',' .,. ............ . . ...,..-..,........',.-.....-..,,'. ......... .... ,. '-"-"-',"--,. ........ ... ,. ................ ..-..-......,'.. ............ . ...,.,...,.........,.-..,..-.. ......... ...... ....-..-.,-.--. ..... .. ...... ................ .............. .....,...,.....,...,....,..-..,. ......... .... . ........... ......... ...... ..(~!9~j;~j't) ~'l~~)~~ ................ ..-..........,....'.....',....-. :.:.:-:.,.:-:.:.:.:-:.:-:.:-:-:. .................-.-....,..-.. ............".. ........-.-,-.'..,'...".. :.:.:.:.:.,-:-:.,.:-:.,.:.:.:-:. .,-:.,.,-:.,.,.:-:.,.,.:.:.,.:-: ........-...............,.,..-. :.:.,-:.,.,-:".,.:-:.:-,-:-:.:. ............".. .-..-...... ............".. (76,348) H H1;~~~,:R?$H 43,668 HHH4il!l903 ..-.....-............-......'. ...,........... ...................'....-.... .,............. :"':':''''-'':''-:''''''-'-.' .....,...,..... :-:,.,;.;,....-.._.".-.._-.-.. 9,785 10,424,984 1,266,119H$,$$1:$:\$. 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) PART "B" JUNE 2000 Note 2 3,211,559 59,029 2,768,096 242,515 1,317,248 219,528 1,130,239 448,414 9,396,628 NOTE 2: For information purposes only. True comparison to prior year not applicable due to changes in the tax legisiation. NOTE 3: 2001 Final Tax Billin not set. Due to Provincial Ie islation chan es for the 2001 Tax Bill. 960 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C" STATISTICAL INFORMATION FOR THE MONTH OF JUNE 2001 JUNE YEAR TO DATE Tax Certificates 103 480 Number of Properties eligible for Tax Reaistration (see Note 1) 118 .. see Note 2 Accounts Payable Cheques Issued #43138 to #43662 525 3,269 Number of Births Reoistered 57 237 Number of Deaths Reaistered 54 271 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. 961 '- CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT JUNE 30, 2001 PART "0" I I FINANCIAL INVESTMENT INTERESl # OF DAYS MATURITY MATURITY INSTITUTION COST RATE 0/8 VALUE DATE GENERAL FUND MTL 990,350.00 4.50% 79 1,000,000.00 July 20/01 MTL 4,931,600.00 4.44% 114 5,000,000.00 Sept.28/01 TO 986,560.00 4.44% 112 1,000,000.00 Sept.26/01 TOTAL GENERAL FUND $,@$;~nj:j:oo 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,584,859.95 5.75% 345 1,671,000.00 July 19/01 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,487,000.00 5.50% 1825 1,487,000.00 Feb. 13/06 RBC . 500,000.00 6.10% 365 500,000.00 Sept 7/01 962 '. CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT JUNE 30, 2001 PART "0" I I FINANCIAL INVESTMENT INTERESl # 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 Hong Kong 2,485,933.27 4.65% 90 2,514,436.37 July 5/01 RBC 118,693.50 5.10% 1976 155,297.00 OCT 15/04 TOTAL RESERVE FUND iSa,$6.-ma.Z7 ...':....,........-.,_..,.'.....-.,...:. ,..,.......-.'.."...,.........,.... ..-..... .,-..... ',' .....,..........,... .......-...... ." ....-.., ..-......-. ;.:-:.:.:::".,.:.,.:.:-:.:.:-:-:.:.:-:. ...., -......,....-.., TOTAL INVESTMENTS 4a.oo$;~a,z7 . Investment interest paid on a monthly/semi-annual/annual basis 963 , CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" JUNE 2001 Develo ment Char as Education Education Town Re ion En IIsh Se arata En Iish Public Woodward, Allen 6,250.00 1,945.00 219.00 704.00 Res. Dev. Form 45876 L., 7, C., 3. Clarke B1P #01.0354 Kumar, Keith 6,250.00 219.00 704.00 Res. Dev. Form 47635 L., 5. C.. 4. Clarke B/P #00.0617 Walters, Kevin 6,250.00 1.945.00 219.00 704.00 Res., Dev. Form 45875 L., 5, C., 7, Newcastle B1P# 01.0303 J. Winters 6,250.00 8,874.00 219.00 704.00 Res., Dev. Form 45879 LD248198 B/P #01.0347 Clarnew Dav., 12,500.00 526.00 438.00 1,408.00 40M1976 L.. 27, C.. 1, Newcastle B/P# 01.0340,341 Jeffery Homes 12,500.00 17,748.00 438.00 1,408.00 40M1779 BlP #01.0362-363 Kaitlin Group 6,250.00 8,874.00 219.00 704.00 40M2005 L.. 17. C., 1 Dartington B/P #01.0271 Prestonvale Heights 25,168.88 33,542.00 876.00 2.816.00 40M 1929 L., 34, C., 2, Darlington B/P#01.0355-358 Ridge Pine Park 6,250.00 219.00 704.00 23 Niagara Trail BlP #01.0392 Ridge Pine Park 6,250.00 219.00 704.00 10 Niagara Trail BlP #01.0391 Konopacki, Mike 1,803.19 4,800.00 285.51 903.81 1700 Baseline Rd.. Courtice B/P #01.0330 673666 Ontario Limited 6,250.00 8,874.00 219.00 704.00 40M2022 L.. 12, C., 2, Bowmanville B/P #01.0258 964 " CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" JUNE 2001 Develo ment Char es Education Education Town Re Ion En IIsh Sa arate En lish Publi Midhaven Homes 12,500.00 17,748.00 438.00 1 ,408.00 40R 19692 1527/29 Nash Road, Courtice B/P #01.0359. 360 Gay Company Ltd., 12,500.00 15,400.38 438.00 1,408.00 40M1994 L., 30, C., 3. Darlington B1P #01.0406. 407 673666 Ontario Ltd., 37,500.00 53.244.00 1,314.00 4,224.00 40M2022 L.. 12, C., 2. Bowmanville B/P #01.0395-398, 400, 401 673666 Ontario Ltd., 6.250.00 8,874.00 219.00 704.00 4OM2022 L., 12. C., 2, Bowmanville B1P #01.0399 Sunrise Homes 49,410.00 69,301.71 1,971.00 6,336.00 40M1994 L., 30. C., 3. Darlington B/P #00,0902, 904 - 911 Leca, Glen 6.250.00 1,945.00 219.00 704.00 940 Maple Grove Road B1P #01.0364 Halloway Holdings 734.40 116.28 368.10 B/P #01.0365 Northcutt Elliott Funeral Home 551.94 87.39 276.65 SIP #01.0206 F. Dennis 0.00 219.00 704.00 10R3660 L., 10, C., 6, Clarke B/P #01.0345 Ontario Hydro One 0.00 43.97 13.89 B1P #01.0215 Keuning Construction 0.00 1,945.00 219.00 704.00 40M 1826 L.,10C.. B/P #01.0211 Keuning Construction 6,250.00 1,945.00 219.00 704.00 Res. Dev. Form #45963 L., 28, C., 8. Darlington B1P #01 .0403 TOTALS 233 918.41 257,531.09 9,293.15 29,722.45 965 . CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" JUNE 2001 CONTRIBUTIONS - CASH-IN-LIEU OF PARKLAND Workoy LD263/200 2.750.00 Total Cash-In-Lieu of Parkland 2,750.00 CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Total Engineering and Inspection Fees Contributions CONTRIBUTIONS - ROADS Workoy LD263/200 700.00 Total Roads Contributions 700.00 966