Loading...
HomeMy WebLinkAboutFND-002-01 Cl~-!llglon REPORT Date: GENERAL PURPOSE AND ADMINISTRATION COMMITTEECf"/1-f'17-o / SEPTEMBER 4, 2001 Meeting: Report #: FND-002-01 File#f!CC;r By-law # Subject: CASH ACTIVITY REPORT - MAY 2001 Recommendations: 1. THAT Report FND-002-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 May 31,2001, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of May 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: Reviewed by: U f/\-~--G.:54 ancy a or, . A, CA Franklin Wu, M.C.I.P. Direct r of Finance 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 948 .~ REPORT NO.: FND-002-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 May 31, 2001 and the comparative information for the month ended May 31, 2000. 949 CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of May 2001 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED LINEAR PROPERTIES FEDERAL GOV'T - WASTE MGMT STUDY. PORT GRANBY CANADIAN WASTE - MARCH TO DECEMBER 2001 RENT CANADIAN WASTE - MARCH & APRIL 2001 ROYALTIES BOWMANVILLE HERITAGE BOOK SALES DEVELOPER CONTRIBUTION - CPR UNDERPASS DONATION-BOWMANVILLE BUSINESSES-20 KING STREET SALE OF LAND: MORGANS ROAD 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 .................MAX ..............2001 ............... .............. ....,..-..-.,... ... ...... ... .....,.......-....,.,...'..... .. ..... ..... ..'.....-......,.,.....,-... ......."... ..,.........,.,-..,..-..... ."......,..... .,..-,..., .... . ...... ..... .............. ..-.,...,.,..,.... ..... . .... ........'.............. ."....".".. ............,............-... ..."."...... .,.,........-,.,-.....-...-. ."........... ".-.-,.",.,... . ... .. ..... ,...."...... .-.-,.".,--.-.. ..... ...... . - . . . . . - . . " . . . . . . . . . . . - . . - . . ..... ......... .............. ..-..,......... .... ......... ............... .........."..-.....-..,..-.'. .... ......... ............... ..-.....-.... ............... .............. .-.....-.,'.....-.'-......... ............... ,......-...........-......... $;~$$iQ7$ .....................0.. .............-..........,.,.. ........... . illiililliilii .............. .......----.. ........... . ......................0. ,.--,..._-..-,. ......................0,. ..-..,'.-.....-,.....,-,'.-.. ........".". >>.............0 .".,......... ..,.,' .,...,,,.,,. ."...".,....,...... ~~~:~f~ M~,~t~ ~~~:~~~ PART "A" MAY 2000 1,580,147 o o o o 300,000 16,200 60,300 403,224 487,690 125,203 o 421,968 ............... :.:.:-:,:.:-:,:.:.:.:.:.:-:. .....,...-.,...-.,...-....... ............... .......,...-................ .............. ,;,!;iob,sia 3,394,732 ............... .........-................... .....-.,...-.,......',....,., .......... . ..-..-..---.. .............. ............... .-.........,., ........... ... .............. ..,..-....,..,. ... ...... . . ........................'.... ..........,.".. . ',.,.....,', .,. . .... .... ..,......"... .. .......... ........."." ',.,",.._-,'.,',". . .... ... .,....,.,'.-......',.,...',.,-.,. . .... . .. ...,....-......,.,.....,.... .'..,............'.'...... ........."... .,.,'.......-......,........ ."...."..... .,.._--,.,.,.,', .. .... .... ............. .,..,....,'.,-... i,p~$;~~g ~'~~~'~~~ .........,............-...... ~;4$~;~$~.. 947,279 7,187,110 o 3,467,441 ............... .............. ....-.'...-.'...-.'.......... ....."........ ......-.',....'...-...... .:.:-:.:.,.:".:-:,:.:-:,:: ....-.....;.....-..-.....-... 11:65~:j74 11,601,830 ......".".-,. ............. . ..-.......... .............. .............. ........-...... ............-,. ............. . ............. _18,207,098 BANK NET CASHMN~ BALANCE PROVIDED M@'N~$ APR.2001 / (USED .. MAYI~01 4,944,797 1,256,844 2,141,917 10,000,000 57,018,591 BANK BALANCE MAY.2000 ....'.....-.'........_.,.... .............. .:.:.:.:.:.:.:.,.:.:.:.:.:.: ,::"""::",::,,:,,,:,:,,: (2,601,223)M#M7'i. 494,075 "ji7$~,~~~ 1 0,646*;1~*,~$ (4,656,0~' ~'~.~~ 1,269,933 3,020,901 o o 45,539,311 ~j~:n~:~ :~:~1~i: ::: :::U::: 75,362,149 16,752,596 68 009 &>$ 49,830,145 0~'l ; - NOTE A: Difference in comparison between years due to timing difference in receipt of funds. '. CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of May 2001 CURRENT YEAR PRE-AUTHORIZED PYMTS TAXES PENALTY AND INTEREST FIRST PRIOR YEAR TAXES PENALTY AND INTEREST SECOND PRIOR YEAR TAXES PENALTY AND INTEREST THIRD & PRIOR YEARS TAXES PENALTY AND INTEREST ~OTAL ... APRIL 2001 INTEREST TAXES PAYMENTS RECEIVABLE ADDED BILLED BALANCE /ADJUST.... (2,156,847) 5,961,985 14,774 ,. (450,079) (2,966,132) (43,180' 69,646 5,961,985 84,420 4,144,516 134,554 4,279,070 (511,453) 189,196 33,533 222,729 (35,348' 1,490,141 49,699 1,539,840 (278,119) 199,711 17,737 217,447 . (32,616' 1 ,548,260 1,548,260 (196,687) 545,220 19,263 564,483 . (39,392 11,936,956 140,179 184,253 14,418,234 (4,553,008 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) MAl( 200i ...-....,.,................. ........,...... ......-.. ..... ...............,.,...,..... ':':';':-:':':':',:':':-:':-: ......-.. ....,. ...-.-..,....,...,........ ........,...., ..-..,..-..,....,........... ........ ".,. .-...-.._.......,........... ........,..... ---'-'," ....,. ..... ...... . .............. ..-.....,....,. -...-,.. ... . (?I~p~,~i .~,~~~:~ A1:g;jQH ',- . . . . . . . . . . . . . . .,....,.,..........,......... ..,.,-..,.......,............. ............... .,....,...........,........... ....".......". ....,..-,..............._...... ...., ...-.............._...... .;.,.,.;.,.,.,.,-,,,.,.,.,.>,. ....-.....-........_.........,. ,.:.;.:.,.,.:-:.:.:::.:.:.:.:-: c,.....-.._....._..,........... ........ ..... ,... '3. .'7."1.. 'e. .'.7.... ... . .,.... ,. . .........'j~i'a~j ......,...,..... :':':-:-:';';':':';'.'>:-:'>: . . . . , . . . . ',' . . . . .,.,...,...................... .....,.......-.. ....,....-........_............ ............... ............-.._............... ................ -:.;.:.,.,.,.:.:.:.:.:.:.:.:.:. ................ .........-........_............ .-............. ............-.........._....... ............... ~,~~!,!~f, ,.,J84,Sat. ..'............................ ..."......-.... .,-..,.,......... .'. ,','. ,...........,......... '.,.......-. ...-. .. ...-.. ...... "."........... .............-.. ..................-............. ...,.......-.... ......-.-......_............... ................ .........-..-.....-............. ...........-.." ............-.._.............,.. ".".......... .......-.-.._................... . - . . . . . . ',' . . . . . . .......1.3'.1".573.... ...." . '5~5'wi ...,......--.... ................ .....,...,.......-.............. .........-....... ......,.,........ .............. ......,..-.........._.........,. ............-... ........-................_...... .'..7' '.7. .0..S. '380. ... ,. :>>::i:,.:..i. .::: PART "BN MAY 2000 Note 2 3,061,841 43,438 3,097,537 243,110 1,409,590 219,962 1,186,703 447,432 9,709,613 NOTE 2: For information purposes only. True comoarison to orior year not aoolicable due to chanQes in the tax leaislation. 951 '. CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C" STATISTICAL INFORMATION FOR THE MONTH OF MAY 2001 MAY YEAR TO DATE Tax Certificates 161 377 Number of Properties eligible for Tax Reaistration (see Note 1) 118 ** see Note 2 Accounts Payable Cheques Issued #42616 to #43137 522 2,744 Number of Births Reaistered 24 180 Number of Deaths Reaistered 43 217 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. 952 " CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT MAY 31, 2001 PART "D" FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE GENERAL FUND MTL 990,350.00 4.50% 79 1,000,000.00 July 20/01 MTL 2,475,500.00 4.63% 78 2,500,000.00 June 29/01 MTL 1,982,740.00 4.54% 70 2,000,000.00 June 29/01 TD 991,410.00 4.52% 70 1,000,000.00 June 29/01 TD 3,968,880.00 4.54% 63 4,000,000.00 June 29/01 MTL 4,942,050.00 4.81% 89 5,000,000.00 June 6/01 TO 995,690.00 4.65% 34 1,000,000.00 June 5/01 TOTAL GENERAL FUND J$,M$;~Q.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 . 500,000.00 5.75% 365 500,000.00 June 21/01 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 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 953 CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT MAY 31,2001 PART "0" 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 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 1,233,830.84 5.95% 1002 1,445,952.00 Jun 2/01 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 3G 01S 87iH ' . ::",';. ).:.:.;. ..:.~'.:;!. :./ ............,.......,..-...........'... . . . . . . . . - ',' . . . . ',' . , . . . . - . . . . . . . : . . . '. ,'. - . - . . - . . , . ' , . . . ....... ,.,.-....-. '," ..........,.........-.........,... .....,....,..,...,.......,....:.....-. . . . .. ,',' - . . . . .. .. TOTAL INVESTMENTS $~,$2.4iii.n * Investment interest paid on a monthly/semi-annual/annual basis 954 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" MAY 2001 Develo ment Char es Education Education Town Re ion En Iish Sa arate En Iish Public Dunbury Homes 25,000.00 18,274.00 876.00 2,816.00 40M2038 L., 27, C., 1, Newcastle SIP #01.0218, 219, 1000. 1001 Celestial Homes Inc., 6,250.00 1,945.00 219.00 704.00 40M2009 Res., Dev.. Form #47660 BlP #01.0879 Gay Company Ltd., 25,000.00 30,800.76 876.00 2,816.00 40M1994 L., 30, C.. 3. Darlington SIP #01.0238 - 241 Simkins Homes 25,000.00 932.00 876.00 2.816.00 40M1954 L., 31, C., 3, Darlington SIP #01.0152, 153. 233. 234 Kaitlin Group 43,750.00 58,210.00 1,533.00 4,928.00 40M2005 L., 17, C., 1, Darlington BIP #00.0987, 01.0246, 273-275, 278-279 Ridge Pine Park 6,250.00 219.00 704.00 27 Niagara Trail L., 36A BlP #01.0351 Kaittin Group 25.000.00 35,496.00 876.00 2,816.00 40M2005 L., 17,C., 1, Darlington SIP #01.0262,282.316.317 Alan Mathurch 0.00 219.00 704.00 S/P#01.0216 Celestial Homes 12,500.00 17,748.00 438.00 1,408.00 LD., 245, 246/2000 L., 33, C., 2, Darlington SIP #01.0005, 6 673666 Ontari Ltd" 37,500.00 53.244.00 1,314.00 4,224.00 40M2022 L., 12. C., 2, Sowmanville SIP #01.0253 - 257 S. King 0.00 885.80 L.. 20, C.. 5, Clarke BlP #01.0236 TOTALS 206 250.00 216 649.76 8,331.80 23,936.00 955 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" MAY 2001 CONTRIBUTIONS - CASH-IN-L1EU OF PARKLAND Total Cash-in-Lieu of Parkland CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Region of Durham Storm Sewers 2.205.00 Total Engineering and Inspection Fees Contributions 2,205.00 CONTRIBUTIONS - ROADS Total Roads Contributions 956