The URL can be used to link to this page

Home My WebLink AboutTR-38-01 ~ THE CORPORATION OF THE MUNICIPALITY OF CLARINGTON REPORT Meeting: General Purpose and Administration File # Hoell-- Res #Cllf- j15-o) Date: June 18, 2001 Report #: TR-~8-01 FILE#: By-law # Subject: CASH ACTIVITY REPORT - APRIL 2001 RECOMMENDATIONS: It is respectfully recommended that the General Purpose and Administration Committee recommend to Council the following: 1. THAT Report TR-38-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 April 30, 2001, is as shown on the attached schedule; and 3. THAT Part "A" of the expenditures for the month of April 2001 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 April 30, 2001 and the comparative information for the month ended April 30, 2000. Reviewed by, ()~~C '~~ I arano, H.BSc., A.M.C.T., C.M.O., reasurer. Franklin Wu, Chief Administrative Officer. MM/LG/hjl Attachments 914 CORPORATION OF THE MUNICIPALITY OF CLARINGTON Analysis of Revenue and Expenditures for the Month of April 2001 REVENUE RECEIVED FOR GENERAL OPERATING NO RESERVE FUND PURPOSES: TAX PAYMENTS RECEIVED LINEAR PROPERTIES NATURAL RESOURCES CANADA - HOST COMMUNITY FUND PROVINCE OF ONTARIO - ROAD WATCH PROGRAM 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 POOLED INVESTMENTS MUNICIPAL BOND INVESTMENTS HOST COMMUNITY FUNDS IN TRUST INVESTMENTS (GENERAL + RESERVE FUNDS) TOTALS ""'A..P..R"'L' ........ . ::::-::::,::'. :.:: ': ............. .-.......................... ...............2(0),. ............. .............. ............. .-...........-.._....._..'.. .............. .............. ...."....,,-, ............. ...........". ,.-..-..-...., ...... ....... ............., ,--,,--.-.... ............. .............. .....-....... ..... .. .. ............. ..-.--....... ..... ........ ...........". ..........".. ......,-.,.... .......... ... ...........". ..._-----,,,.. .............. ..........".. .-....-.........'...'... ...........". ',....-....".,' ....._,_... .............. ...-.......". .. ... . .........,.". ..........,... "'-"-"-,"" .......... ... .........,.". ..........-...........,... .......".".. .-.....-.._....._..'...',.'.. ........... .. .........."., ..-----...,'" ........... .. .........,.,.. ij;?~~;$i$ APRIL 2000 12,535,886 o 3,000 615,164 996,888 52,781 o 612,625 14,816,344 874,515 o 22,182 1,274,801 2,171,498 12,644,846 BANK NET CASH BALANCE PROVIDED MAR.2001 / USED ............., ....... ... .....-. . ....... . ...-........... " ~1NK BALANCE: .............. .......,..-.... ,A8Bi2QOM 3,159,394 866,194 46,206 2,131,397 o 49,248,510 ........',.,.............. ;:;::,::,:,:,:,:,:,:,:;:,:,: :,;.;.:.:.,.,.:-:.:.:-:-:.: ".:.:.,.:-:-:-:.;.:.:.,.;.: 1 , 785,4041,~44i'm7 ~~~:~~~)~[~~~~~;~ 10,000,0001000.000.0 7,770,080 $1;~~$)$1 PART "A" BANK BALANC APR.200 4,772,226 3,226,910 27,866 o o 50,010,241 .............. ..................,......... .........,.... .....-.-.-...-..........-... ~ '" >~ ,~, ~,~<< ,~:~. 55,451,701 19,910,448 1$)S!l2J!ii!iH 58,037,243 NOTE A: Difference in comparison between years due to timing difference in receipt of funds. 915 ~- CORPORATION OF THE MUNICIPALITY OF CLARINGTON Continuity of Taxes Receivable for the month of April 2001 MARCH 2001 INTEREST TAXES PAYMENTS RECEIVABLE AODED BILLED BALANCE /ADJUSr" CURRENT YEAR TAXES PENALTY AND INTEREST (2,935,744) 141 FIRST PRIOR YEAR TAXES PENALTY AND INTEREST 4,151,886 182,958 SECOND PRIOR YEAR TAXES PENALTY AND INTEREST 1,560,111 194,221 THIRD & PRIOR YEARS TAXES PENALTY AND INTEREST 1,594,917 541,706 TOTAL 5,289,914 ... Includes refunds, write-offs, 496's, etc. 16,841,531 13,905,786 21,936 21,796 4,151,886 35,969 218,927 1,560,111 19,246 213,467 19,812 1,594,917 561,517 96,963 16,841,531 22,228,407 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) , , , .. ..._,...... ...,.....-..................... ....'................-.-....,.. ,::;::,:,::::::;::::,:::,:::,.; :: ~:~ :::) ::: ::: <:) :~< ':-:':':':':-:"':-:-:-:';':'." <c;:;'::'::::::::::':',::::::: (46,657)1;tio<i~!~ilii 16,297<$4$:~ZO ............... ..........-..........-..-.,.. ............... ....-.._..........'.-_....... ::::::::"'::;::':'::::,'::,::: 1 0,291 ,452H1J~$,Q~ NOTE 2: For information purposes only_ True comparison to prior year not applicable due to changes in the tax legislation. 916 PART "B" APRIL 2000 Note 2 6,148,882 24,770 3,290,602 247,988 1,528,478 227,863 1 ,251 ,276 461,333 13,181,190 CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "C" STATISTICAL INFORMATION FOR THE MONTH OF APRIL 2001 APRIL YEAR TO DATE Tax Certificates 52 216 Number of Properties eligible for Tax Registration (see Note 1) 122 .. see Note 2 Accounts Payable Cheques Issued #42100 to #42615 516 2,222 Number of Births Registered 23 156 Number of Deaths Registered 29 174 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. 917 ~ CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT APRIL 30, 2001 PART "0" I I FINANCIAL INVESTMENT INTERESl # OF DAYS MATURITY MATURITY INSTITUTION COST RATE O/S VALUE DATE GENERAL FUND 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 TO 991,410.00 4.52% 70 1,000,000.00 June 29/01 TO 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 TD 2,978,490.00 4.79% 55 3,000,000.00 May 9/01 TO 3,978,760.00 4.87% 40 4,000,000.00 May 9/01 TOTAL GENERAL FUND ~j,~j7';~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 Dee 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 Dee.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 99,999.64 7.10% 1906 143,061.00 May 14/01 RBC . 993,000.00 6.25% 365 993,000.00 May 23/01 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 918 -- CORPORATION OF THE MUNICIPALITY OF CLARINGTON INVESTMENTS OUTSTANDING AS AT APRIL 30, 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 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,323,812.10 4.65% 13 1,326,000.00 May 1/01 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 Dee.21/02 RBC 43,523.00 5.50% 1095 51,107.00 Dee.21/03 RBC 1,149,347.43 4.60% 329 1,197,000.00 Jan.31/02 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 * 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 Dee 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 U$!l;7:Qd;rnQ,$~ ',- . . ',' . ',', ' . . - . . - . . . -,. ", .-...-... --..-.., ,.'.-....... "-"""", -.......,... '-'-',', - ., -" - '-' - ',', '.. . .. ... .. ,"- . . - ',' ',' '-' . - '-',',' ", - '-' ... . - ... ',.. """"-"'-""""'" "';""-'':';'';::'':':-,.,.:-;.;.:-:.; ""-',"',' ,-._...-.... TOTAL INVESTMENTS !l7:Q1a:~@;t * Investment interest paid on a monthly/semi-annual/annual basis 919 CORPORATION OF THE MUNICIPALITY OF ClARINGTON PART "E" APRil 2001 Develo ment Char es Education Education Town Re ion En IIsh Se arate En Iish Public DuPont Contracting Group Inc., 660.02 104.50 330,82 L., 16, C., 1, Bowmanville B/P #00.0827 Celestial Homes Inc., 6,250.00 8.874,00 219.00 704.00 40M2009 L., 33, C., 2, Darlington B1P #01.0044 1138337 Ontario Inc" 12,500.00 17,748.00 438.00 1 ,408.00 40M1984 L., 28, BFC Newcastle B/P 01.0085, 87 Prestonvale Heights 0.00 8,874.00 40M1929 L., 34, C., 2, Darlington B/P #01.0167 Ives & Pearl Funeral Chapellnc" 5,458.44 8,674.92 537.96 1,702.99 CM1354 L., 32, C., 2, Darlington B1P #00.0931 Storybook Homes 6,250.00 8,874.00 219.00 704.00 LD4412oo0 L., 33, C., 2, Darlington B1P 01.0170 Celestial Homes Inc., 6,250.00 8,874.00 219.00 704.00 40R20102 L., 33, C., 2,Darlington B1P #01.0007 Gay Co., Ltd., 12,500.00 15,006.76 438,00 1,408.00 4OM1994 L., 30, C., 3, Bowmanville B/P #01,0166,168 Ridge Pine Park 6,250.00 219.00 704.00 Niagara Trail BFC Newcastle B1P #01.0213 Keuning Construction Ltd., 0.00 3,890.00 438.00 1,408.00 40M1826 L., 19, C., 8. Clarke B/P #00.0997, 01.0137 Celestial Homes 6,250.00 1 ,945.00 219.00 704.00 40M2009 L., 33, C.. 2, Darlington B/P #00.0878 920 ." CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" APRIL 2001 ment Char es Education Education Town Re ion En Iish Sa arate En Iish Public Westlake Developments 62,500,00 40M1897 L., 25, C" 6, Darlington Mike McDonnell 0.00 219.00 704.00 B/P #00.0675 464367 Ontario LId., 0.00 219.00 704.00 LD562187 L., 7, C., 1,Clarke B/P #01.0057 City Homes 4,687.50 17,748.00 438.00 1 ,408.00 40M2022 L., 12, C., 2, Bowmanville BIP #01.0173,184 Daisey/ield Developments 50,000,00 1,864.00 1,752.00 5,632,00 40M1954 L., 31, C., 3, Darlington B/P #01.0198-205 City Homes 6,250.00 8,874.00 219.00 704.00 40M2022 L., 12, C" 2, Bowmanville B/P 01.0174 1138337 Ontario Inc., 6,250.00 8,874.00 219.00 704.00 40M2036 L., 28. BFC Newcastle B/P #01.0162 Ridge Pine Park 6,250.00 219.00 704.00 L., 32A Niagara Trail BFC Newcastle B/P #01.0269 673666 Ontario Ltd., 6.250.00 8,874.00 219.00 704.00 40M2022 L., 12, C., 2, Bowmanvllle B/P #01.0185 Preston vale Heights 31,481,10 40.462.00 1,095.00 3,520.00 40M1929 L" 34, C., 2, Darlington B/P #01.0192 - 196 Husky Steel 0.00 360.08 1,139.88 B/P #01.0027 TOTALS 236,017.06 169,456.68 8 010.54 25,701.69 -- 921 .,. CORPORATION OF THE MUNICIPALITY OF CLARINGTON PART "E" APRIL 2001 CONTRIBUTIONS - CASH-IN-LIEU OF PARKLAND Rogers Wireless SPA#OO5 600.00 Total Cash-in-Lieu of Parkland 600.00 CONTRIBUTIONS - ENGINEERING AND INSPECTION FEES Total Engineering and Inspection Fees Contributions 0.00 CONTRIBUTIONS - ROADS Total Roads Contributions 0.00 922