Loading...
HomeMy WebLinkAboutTR-55-00 . ' THE CORPORATION OF THE MUNICIPALITY OF CLARINGTON REPORT Meeting: General Purpose and Administration File#FltJ c/1 Res#6frr- ,7~{)O , Date: September 5, 2000 Report #: TR-55-00 FILE#: By-law # Subject: CASH ACTIVITY REPORT - MAY 2000 RECOMMENDATIONS: It is respectfully recommended that the General Purpose and Administration Committee recommend to Council the following: 1. THAT Report TR-55-00 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, 2000, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of May 2000, be confirmed. BACKGROUND 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, 2000 and the comparative information for the month ended May 31,1999. RespecttuHy submitted, (Io~ Marie Marano, H.BSc., A.M.CT, C.M.a., Treasurer Reviewed by, d /r~-~ Franklin Wu, Chief Administrative Officer. MM/LG/hjl Attachments bUj CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of May 2000 REVENUE RECEIVED FOR GENERAL OPERATING AND RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED HEADS & BEDS LINEAR PROPERTIES DEVELOPER CONTRIBUTION - CPR UNDERPASS DONATION-BOWMANVILLE BUSINESSES--20 KING STREET SALE OF LAND: MORGANS ROAD SUBSIDIES: HANDI-TRANSIT DEVELOPMENT CHARGES-TOWN GENERAL INTEREST 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 POOLED INVESTMENTS INVESTMENTS (GENERAL + RESERVE FUND) TOTALS ........MA... ~808 ....-......-.. .,.......... ....'....,.....,..-........ .. .....-.-.-.. . ..". ...... .... ....."... .. .. ---.. ",",',"""'-" ...,.,...-...........-. .... ... ...-.'. ... ...--.,.-.... ", " . .. "."....-'..... ..--... ..."'" .. -",. ...... ....., ,,' . """,',",".. ...... . .. "-'," ,""" ....................-,-,. . . .".. ........---_. ...-.-_...... ..--"'-"'-'-' ..-..---_.... .. .-....... .,.....,.__.,..-...-.-... ,,-_......... ..........,.....,..-.-.-. . ,........ ....'..,..,.,..-..,-.-... .,--,........-. .,.-..,.,......,..-.-... ......- ...-.. .,. ..-_... ......... ..""'-"-'" ,. ... --... ;'m~,1~~ . .-...-....-. ... .. ---.. .....................d. .,.......,.... ...,....-._.........-.-... ~~:~~~ <llIJ,3bO BANK BALANCE APR. 30/00 4,772,226 3,226,910 27,866 50,010,241 58,037,243 MAY 1999 3,079.734 o o o o o 237.516 498,959 112,142 420,305 4,348,656 838,075 5,321,002 o 3,353,580 NET CASH PROVIDED / USED . <..... )aANl<.. .. .".--,. Ml.,I\.i\Iq~ ...MAYiWod . -....... (3,502,293) (264,495) 30,620 4,470,930 ....-.....,... .........,.,.-. ......,....-,.,...,... '-- ............ .. ..- ... . .... ....".. .. ....-... ,. .... .."."., .. ,',"""'-,' j;?$~,~~ ?i~g,fflW ...)...$$.,#18.. 4S;5~@H PART IIAII BANK BALANCE MAY 31/99 2,517,219 1,662,607 27,586 39,940,834 ".-- ...... ...........-_. ...._........-............. .......... ..".--.-..... . ......... ...........-.. ...._........-............. ........." .-..-.-....-..... AM$di1ii$ 44,148,246 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. dUb CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of May 2000 PART "B" CURRENT YEAR TAXES 6,148,882 PENALTY AND INTEREST 24.770 55,930 1999 YEAR TAXES 3,290,602 PENALTY AND INTEREST 247,988 40,784 1998 YEAR TAXES 1,528,478 PENALTY AND INTEREST 227,863 19,212 PRIOR TAXES 1,251,276 PENALTY AND INTEREST 461,333 16,057 TOTAL 13,181,190 131,983 6,148,882 80,699 MAY 1999 APRIL 2000 INTEREST TAXES PAYMENTS RECEIVABLE ADDED BILLED BALANCE IADJUSr" 3,290,602 288.772 1 ,528,478 (118,888) 247,075 27,113 1 ,251 ,276 (64,573) 477.389 29,957 0 13,313,173 3,049,962 89,529 ...-"-.-.'..... .... . ..... ..,........... .......,............,....... . .. -........ ...... ... .. .,..,.......... . . . . ' '. -' - . . . . . . . . - . - , . . ". . . .......... .._-_........-..,..-.... .." -..-.-....-.. ... ...... ......-....... ..... ...... ............. ...............-....... 1'~~::~~~ 920,290 108,146 ..'.,.........-...........: ..........,..-.....-..... ........... ........,.....,..-.....-... ............. .....,.....,.....,..-...... ......-.-....... ..... ...... .............. .......".... .....,...,......,..-.-,.,... ......, ,...... . . - . . . - . - ". . . . . , - . . . . , . . . , . . .... ....... .......-_..... ~.~~:~~~ 921,656 402,274 PERCENT OF CURRENT TAXES OUTSTANDING 7,913.103 TOTAL TAXES LEVIED (INCLUDING REGION AND SCHOOL BOARDS) N/A N1A 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) bUI CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C" STATISTICAL INFORMATION FOR THE MONTH OF MAY 2000 MAY YEAR TO DATE Number of Properties eligible for Tax Registration (see Note 1) 111 ** see Note 2 Accounts Payable Cheques Issued #35836 to #36304 469 2,616 Number of Births Registered 43 206 Number of Deaths Registered 53 251 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. duo .. Tax Certificates 153 561 CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT MAY 31,2000 PART "0" I I FINANCIAL INVESTMENT INTERESl # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE GENERAL FUND MTL 3,964,360.00 5.56% 59 4,000,000.00 JUNE 30/00 BNS 1,974,960.00 5.38% 86 2,000,000.00 JUNE 30/00 MTL 1,977,180.00 5.40% 78 2,000,000.00 JUNE 30/00 TD 3,964,560.00 5.35% 61 4,000,000.00 JUNE 20/00 TOTAL GENERAL FUND Jf.aai)oaMo RESERVE FUND RBC 34,731.25 7.20% 1,740 48,337.00 Aug 8/00 RBC 1,001,705.00 6.80% 1828 1,392,611.00 Mar 15/01 RBC 1,343,186.32 5.60% 363 1,418,000.00 Mar 01/01 WOOD GUNDY' 1,787,000.00 6.75% 346 1,787,000.00 Mar 01/01 RBC . 295,000.00 8.50% 3285 295,000.00 May 26/04 WOOD GUNDY 435,075.29 5.20% 777 484,272.00 Aug 18/00 RBC 774,999.81 5.25% 1249 922,509.00 Dee 15/02 RBC 287,862.48 5.40% 1319 347,702.00 Feb 23/03 RBC 771,999.33 5.40% 1596 970,580.00 Nov 27/03 RBC 2,937,000.00 6.00% 1460 3,641,880.00 Jan.26/04 RBC . 514,000.00 7.75% 1825 514,000.00 June 8/00 RBC 999,999.65 8.20% 1825 1,482,799.00 Aug 8/00 RBC 620,220.69 5.15% 1007 711,752.00 Apr 5/01 RBC . 475,000.00 8.58% 2761 475,000.00 Mar 17/03 RBC 138,709.23 6.25% 1,637 182,057.00 Aug 1/00 RBC 99,999.64 7.10% 1,906 143,061.00 May 14/01 RBC . 993,000.00 6.25% 1,095 993,000.00 May 23/03 WOOD GUNDY' 250,000.00 5.00% 2556 250,000.00 June 21/05 RBC 354,000.00 5.10% 368 372,054.00 Feb. 5/01 RBC 1 ,417,032.00 5.10% 366 1,489,300.63 Feb. 7/01 RBC 40,397.70 7.20% 1578 54,562.00 Aug 8/00 RBC 299,628.50 5.30% 1396 365,000.00 Sept 1/00 Ou',! CORPORATION OF THE MUNICIPALITY OF ClARINGTON INVESTMENTS OUTSTANDING AS AT MAY 31,2000 PART "0" FINANCIAL INVESTMENT INTERES # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE RESERVE FUND RBC 180,862.43 5.63% 1549 228,160.00 Feb 1/01 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 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 Dee 1/01 RBC . 250,000.00 5.25% 180 250,000.00 Jun 21/04 RBC 1,109,500.90 5.05% 1213 1,307,911.00 Apr 1/01 RBC 20,558.85 5.20% 1310 24,645.00 Jan 9/02 WOOD GUNDY 648,000.00 6.05% 397 690,641.06 Jan 15/01 RBC 870,460.00 5.00% 365 913,983.00 Dee.21/00 WOOD GUNDY 528,412.46 5.34% 788 590,807.00 Aug 8/00 RBC 898,314.97 5.00% 919 1,037,435.00 Mar. 8/01 RBC 2,160,071.68 5.70% 970 2,503,270.00 May 1/01 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 Dee 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 500,000.00 5.22% 731 526,500.00 Apr 16/00 RBC 1,683,101.00 5.30% 1096 1,683,101.00 Mar 3/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 Hong Kong 2,360,805.35 5.75% 91 2.394,648.95 Aug 8/00 RBC 118,693.50 5.10% 1976 155,297.00 OCT 15/04 TOTAL RESERVE FUND ~,$$a;~$p;$$ ...........,..,.,.-..-. .,......... ,', .. ',' .,.-..,-....,...,.,._,-........,.... . , . . . . . . . ", ',',' . ,..,:.-.-.....-.,...,.,...,...,....'... , ..... ,', . ... . , ' . - . . . . . - . - . . . , . , . . , : - . . . - . - . . . - . , ' . . ' - . . . ,. ... . . ',' ...,..-.-....,-.".,..,..,.,.,.,...',. TOTAL INVESTMENTS 4$,$~!;l;$ibl$$ . Bond investment. Interest paid on a monthly/semi-annual/annual basis diU CORPORATION OF THE MUNICIPALITY OF ClARINGTON MAY 2000 PART "E" I I Development Charges Tot~1 Town Region E. Warden 7,331,00 5,458.00 1,873.00 40M1978 L., 8, C., 6, Darlington B/P #00.0318 Celestial Homes Inc., 7,331.00 5,458.00 1,873.00 40M1978 L., 8. C., 6,Darlington B/P #00.0186 Marianna Developments 30,150.00 28,800.00 1.350.00 40M1970 L., 13, C., 2, Bowmanville B/P #00.0312-317 Eiram Development 25.635.00 - 25,635.00 40M1776 L., 10, C., 3, Bowmanville B/P# 00.0228-230 Ridge Pine Park 5,458.00 5,458.00 B/P#OO.0380 Frank Luscher 7.331.00 5,458.00 1 ,873.00 Res., Dev., #47269 40R-17752, PI., 1 B/P #00.0331 M. Lewicki 7,331.00 5,458.00 1,873.00 L.. 31, C., 3, Darlin9ton B/P #00.0297 P. Hordyk 7,331,00 5,458.00 1,873.00 B/P #00.0213 Bramley 7,331.00 5,458.00 1,873.00 Res. Dev. Form #45653 L., 12, BFC 145 Cedar Crest Beach B/P #00.0182 Kaitlin Group 50,217.36 19,801.36 30,416.00 40M1940 L., 17, C., 1, Bowmanville B/P #00.0214-217 Lucyk 7,331.00 5,458.00 1,873.00 L., 33, C.. 7, Clarke LD 179/98 , b I I CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART IIEII MAY 2000 Development Charges Total Town Region A. Macvarish 7,331.00 5,458.00 1,873.00 40M1978 L., 8. C., 6, Darlington B/P #00.0337 Kaitlin Group 25,108.68 9,900.68 15,208.00 40M1940 L., 17, C., 1. Bowmanvilie B/P #00.0350. 351 Kaitlin Group 88,740.00 28,925.00 59,815.00 40M1944 L., 17, C., 1, Bowmanville B/P #00.0304 - 310 1138337 Ontario Inc., 222,995.00 92,786.00 130,209.00 40M1984 L., 28, BFC. Newcastle B/P #0012-15, 50, 51,83.84,135.136,141, B/P #00.0143,144,149,150.151,152 Prestonvale Heights 28,006.00 10,916.00 17.090.00 40M 1929 L., 34, C., 2, Darlington BIP #00.0362. 363 Ladouceur 5,458.00 5,458.00 LD931008 L.. 2., C.. 2, Newtonvilie BIP #00.0293 Clamew Developments 21,832.00 21,832.00 40M1976 L., 27, C.. 1, Newcastle BIP #00.0372-375 S. Pettrelia 7,331.00 5,458.00 1.873.00 Res., Dev., #47468 L., 7, C.. 9, Darlin9ton BIP #00.0384 963639 Ontario Ltd.. 22,732.00 21,832.00 900.00 40M1954 L., 31, C., 3, Darlington BIP #00.0366,369,407,408 Dunbury Homes 6,667.00 5,458.00 1,209.00 40M1976 L., 27, C., 1. Newcastle BIP #00.0372-375 bit. CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" MAY 2000 I Totall' Development Charges Town Region St. Stephens Estates 201,750.05 81,103.05 120,647.00 40M1977 L., 8, C., 2, Bowmanville IS/P #00.0341,342,280,281,339,340,344, IS/P #00.0346,268,269.278,279,286,287 S. Tracz 7,331.00 5,458.00 1,873.00 Res., Dev., Form #45688 673666 Ontario Ltd., 17,133.00 16.374.00 759.00 40M1910 L.. 12. C., 2, Sowmanville SIP #00.0089,90,169 TOTALS 825,192.09 403,224.09 421,968.00 (ji) . CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" MAY 2000 CONTRIBUTIONS - CASH-IN-L1EU OF PARKLAND 290572 Ontario Ltd., 2,325.00 LD 287/99 - 290/99 Thomas 7,213.47 LD 328/99 - 330/99 Total Cash-in-Lieu of Parkland 9,538.47 CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Re9ion of Durham 1,237.50 Local storm sewer fees Total Engineering and Inspection Fees Contributions 1,237.50 CONTRIBUTIONS - ROADS Thomas 8.613.87 LD 328/99 - 330/99 Total Roads Contributions 8,613.87 - 014