Loading...
HomeMy WebLinkAboutFinancial Statements 1999 C en ? i THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Financial Statements December 31, 1999 GRAHAM • SCOTT • ENNS LLP Chartered Accountants 450 Sunset Drive Telephone: (519) 633-0700 St. Thomas, Ontario Facsimile: (519) 633-7009 N5R 5V1 gse@grahamscottenns.com June 1, 2000 The Corporation of the Municipality of Bayham 9344 Plank Road North P.O. Box 160 STRAFFORDVILLE, Ontario NOJ 1Y0 Members of Council: We have completed our audit of the Municipality for the year ended December 31, 1999. Our audit included a review of the accounting systems and internal controls to determine the nature and extent of our audit tests. As a by-product of this process, we have certain observations and comments, which we wish to bring to your attention. Revenues Segregation of duties is necessary for good internal control. Currently one employee is involved in the following areas, the preparation of the tax notices, the mailing of the notices, the collection of tax and other revenues, preparing the deposit slip and the balancing of taxes and other revenues. To improve internal control, one employee can prepare and balance the tax notices but that same person should not be receiving any payments and entering them into the system. Disbursements To enhance the system of internal control two signatures should be on each cheque issued by the municipality. The first signature should come after the invoice has been reviewed in detail and the account distribution checked. The second signature may only involve a spot check of the invoices and a review of the posting report for correct account distribution. The reviewer should initial the invoices and posting report. The signed cheques should not be returned to the person who prepared them. If you should have any questions,please do not hesitate to contact us. Yours very truly, GRAHAM•SCOTT•ENNS tj/ -i -r Jo . Scott, C.A. Pa er JMS:vc THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Financial Statements Year Ended December 31, 1999 INDEX SECTION Consolidated Financial Statements 1 Financial Infoi enation Return 2 Unconsolidated Trust Funds 3 THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Consolidated Financial Statements December 31, 1999 THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Consolidated Financial Statements Year Ended December 31, 1999 Table of Contents PAGE Auditors' Report 1 Balance Sheet ? - 3 Statement of Operations 4 - 5 Notes to the Financial Statements 6 - 10 GRAHAM • SCOTT • ENNS LLP Chartered Accountants 450 Sunset Drive Telephone: (519) 633-0700 St. Thomas, Ontario Facsimile: (519) 633-7009 N5R 5V1 Email: gse@grahamscottenns.com AUDITORS' REPORT To the Members of Council, Inhabitants and Ratepayers of The Corporation of the Municipality of Bayham We have audited the consolidated balance sheet of The Corporation of the Municipality of Bayham as at December 31, 1999 and the consolidated statement of operations for the year then ended. These financial statements are the responsibility of the Municipality's management. Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform an audit to obtain reasonable assurance whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. In our opinion, these consolidated financial statements present fairly, in all material respects, the financial position of the Municipality as at December 31, 1999 and the results of its operations for the year then ended in accordance with the accounting principles disclosed in Note 1 to the financial statements. St. Thomas, Ontario 9,ret4aot Sc n t gGCpa, ZIP March 9, 2000 CHARTERED ACCOUNTANTS - 1 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Consolidated Balance Sheet As At December 31, 1999 1999 1998 S S ASSETS Unrestricted Cash 475,876 622,576 Taxes receivable 321,845 316,992 Accounts receivable 277,369 543,959 Due from reserve funds - 10,687 Other current assets 17,445 11,237 1,092,535 1.505.451 Restricted Cash and short term investments 646,830 669,267 Due from (to) revenue fund 53,561 (10,687) 700,391 658,580 Capital outlay financed by long term liabilities and to be recovered in future years (note I (b)(iv)) 240,090 99,917 TOTAL ASSETS 2,033,016 2,263,948 See accompanying notes to the consolidated financial statements. - 2 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Consolidated Balance Sheet As At December 31, 1999 1999 1998 LIABILITIES CURRENT Due to reserve fund 53,561 - Accounts payable and accrued liabilities 500,862 452,229 Other current liabilities 28,080 25,593 582,503 477,822 NET LONG TERM LIABILITIES (NOTE 7) 240,090 99,917 FUND BALANCES FUND BALANCES AT END OF YEAR To be used to offset (to be recovered from) taxation or user charges (Note 5) 306,995 293,446 Unfinanced capital (Note 5) (581,190) - Reserves (Note 4) 784,227 734,183 Reserve funds (Note 4) 700,391 658,580 1,210,423 1,686.209 TOTAL LIABILITIES AND FUND BALANCES 2.033,016 2.263,948 See accompanying notes to the consolidated financial statements. - 3 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Consolidated Statement of Operations Year Ended December 31, 1999 Actual Actual 1999 1998 S S SOURCES OF FINANCING Taxation and user charges (Note 1) Residential and farm taxation 3,297,357 3,324,216 Commercial, industrial and pipeline 593,314 589,406 Taxation from other governments 32,975 32,792 User charges 345,955 459,791 Deduct: amounts received or receivable for county and school boards (Note 1(a)(iii)) (2,447,280) (2,536,766) Grants Canada - 30,441 Province of Ontario 1,092,683 1,663,333 Other municipalities 266,500 358,389 Other Investment and penalties income 103,181 92,918 Sale of land and property - 62,022 Donations 13,195 6,525 Other 135,261 102,478 Proceeds from the issue of long term liabilities 154,100 - Fund balances at the beginning of the year To be used to offset (to be recovered from) taxation or user charges (Note 5) 293,446 (103,665) Unexpended capital financing (or capital operations not yet financed) - 24,549 TOTAL FINANCING AVAILABLE DURING YEAR 3,880,687 4,106.429 See accompanying notes to the consolidated financial statements. - 4 - THE CORPORATION OF TSE MUNICIPALITY OF BAYHAIVI Consolidated Statement of Operations Year Ended December 31, 1999 Actual Actual 1999 1998 S _ APPLIED TO Current operations General government 587,157 1,089,073 Protection to persons and property 702,729 670,318 Transportation services 795,380 774,943 Environmental services 505,576 548,427 Health services 19,534 16,868 Social and family services 5,800 6,210 Recreation and cultural services 199,232 162,342 Planning and development 115,266 173,496 2,930.674 3,441.677 Capital General government - 15,009 Protection to persons and property 40,322 24,616 Transportation services 314,267 234,392 Environmental services 595,190 - Recreation and cultural services 120,680 4,906 Health services 98,605 - 1,169,064 278,923 Net appropriations to reserves and reserve funds 55,144 92,383 Fund balances at the end of the year To be used to offset (to be recovered from) taxation or user charges (Note 5) 306,995 293,446 Unexpended capital financing (or capital operations not yet financed) (581.190) - TOTAL APPLICATIONS DURING THE YEAR 3,880.687 4.106.429 See accompanying notes to the consolidated financial statements. - 5 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Notes to the Consolidated Financial Statements Year Ended December 31, 1999 1. SIGNIFICANT ACCOUNTING POLICIES The consolidated financial statements of the Municipality are the representation of management prepared in accordance with accounting policies prescribed for Ontario municipalities by the Ministry of Municipal Affairs. Since precise determination of many assets and liabilities is dependent upon future events, the preparation of periodic financial statements necessarily involves the use of estimates and approximations. These have been made using careful judgments. a) Basis of Consolidation (i) Consolidated Balance Sheet This statement reflects the assets and liabilities of the revenue fund, the capital fund and includes the activities of all committees of Council and the following local boards, which are under the control of council: - Various Community Centre Boards - Various Cemetery Boards - Museum Board (ii) Consolidated Statement of Operations This statement reflects the consolidated sources of financing and expenditures of the revenue fund, reserves, and the capital fund of the Municipality and those boards, described in Note 1(a)(i). All interfund sources of financing and expenditures are eliminated with the exception of interest income and expenses arising from loans and advances between the reserve funds and other funds of the Municipality. (iii) Accounting for County School Board Transactions (gross less reduction) The taxation and other revenues with respect to the operations of the school boards, and the County of Elgin are reflected in the Consolidated Statement of Operations but with no effect on the Municipal Fund Balances since the total is shown as a deduction. In addition the expenditures, assets and liabilities with respect to the operations of the school boards, and the County of Elgin are not reflected in these financial statements. (iv) Trust Funds Trust funds and their related operations administered by the Municipality are not consolidated, but are reported separately on the Trust Funds Balance Sheet and Statement of Continuity. -6 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Notes to the Consolidated Financial Statements Year Ended December 31, 1999 b) Basis of Accounting (i) Sources of financing and expenditures are reported on the accrual basis of accounting with the exception of principal and interest charges on long-term liabilities which are charged against operations in the periods in which they are paid. The principal and interest charges are not accrued for the periods from the dates of the latest payments to the end of the financial year. (ii) The accrual basis of accounting recognizes revenues as they become available and measurable, expenditures are recognized as they are incurred and measurable as a result of receipt of goods or services and the creation of a legal obligation to pay. (iii) Fixed Assets The historical cost and accumulated depreciation for fixed assets are not recorded for municipal purposes. Fixed assets are reported as an expenditure on the Consolidated Statement of Operations in the year of acquisition. (iv) Capital Outlay to be Recovered in Future Years "Capital outlay to be recovered in future years", which represents the outstanding principal portion of unmatured long-term liabilities for municipal expenditures or capital funds transferred to other organizations, is reported on the Consolidated Balance Sheet. 2. OPERATIONS OF SCHOOL BOARDS AND COUNTY OF ELGIN Further to Note 1(a)(iii), the taxation, other revenues, and expenditures of the school boards and the County of Elgin are comprised of the following: School County Boards of Elgin Taxation and user charges 1.197.953 1,249,327 3. TRUST FUNDS Trust funds administered by the Municipality amounting to $190,048 (1998 - $183,765) have not been included in the Consolidated Balance Sheet nor have their operations been included in the Consolidated Statement of Operations. -7 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Notes to the Consolidated Financial Statements Year Ended December 31, 1999 4. RESERVES AND RESERVE FUNDS The total balance of reserves and reserve funds consist of the following: 1999 1998 S $ Reserves set aside for specific purposes by Council or acquisition of fixed assets , 323,418 315,225 for working capital ,_U 334,307 334,307 °/d v L;,o for waterworks purposes 57,351 36,851 for other purposes 69,151 47,800 Total reserves 784,227 734,183 Reserve funds set aside for specific purposes by Council: L or construction of sanitary and storm sewers Y S Z G 513,322 488,496 '19°z 3 Ty for water system ' 101,140 96,709 for parks and recreation purposes 24,148 36,492 for parkland purposes 45,161 21,015 for other purposes 16,620 15,868 Total reserve funds 700,391 658,580 Total reserve and reserve funds 1,484,618 1,392,763 Increase (decrease) for the year 91,855 250.064 5. FUND BALANCE AT THE END OF THE YEAR (a) The balance on the Consolidated Statement of Operations of municipal equity of$306,995 (1998 - $293,446) at the end of the year is comprised of the following: 1999 1998 S $ For general reduction (increase) of taxation 255,703 277,700 For benefiting landowners related to special charges and special areas (2,918) (32,846) For cemetery boards and accumulated net revenue 54,210 48,592 306.995 293,446 The unfinanced capital at year-end relates to the sewer project taking place in the Municipality of Bayham. These expenses have been incurred on behalf of the benefiting landowners and will be financed by a combination of government grants and landowner debt financing. -8 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Notes to the Consolidated Financial Statements Year Ended December 31, 1999 6. PENSION AGREEMENTS The Municipality makes contributions to the Ontario Municipal Employees Retirement Fund (OMERS), which is a multi-employer plan, on behalf of 12 members of its staff. The Plan is a defined benefit plan which specifies the amount of the retirement benefit to be received by the employees based on the length of service and rates of pay(per day). The amount contributed to OMERS for 1999 was $ nil (1998 - $12,392) for current service and is included as an expenditure on the Consolidated Statement of Operations. As at August 1, 1998 the provincial government announced a OMERS holiday for both employee and employer contributions, this holiday is expected to last until at least December 31, 2001. 7. NET LONG-TERM LIABILITIES a) The balance of net long-term liabilities reported on the Consolidated Balance Sheet is made up of the following: 1999 1998 $ $ Total long-term liabilities incurred by the municipality and outstanding at the end of the year amount to 240,090 99,917 Of the long-term liabilities shown above, the responsibility for payment of principal and interest charges for tile drainage loans has been assumed by individuals. At the end of the year, the outstanding principal amount of this liability is (84.111) (96,985) Net long-term liabilities at the end of the year 155,979 2,932 b) Of the net long-term liabilities reported in a) of this note, $149,550 in principal payments are payable from 2000 to 2004. All payments are recoverable from benefitting landowners. c) The long-term liabilities in a) issued in the name of the municipality have received approval of the Ontario Municipal Board for those approved on or before December 31, 1992. Those approved after January 1, 1993 have been approved by by-law. The annual principal and interest payments required to service these liabilities are within the annual debt repayment limit prescribed by the Ministry of Municipal Affairs. d) The municipality is contingently liable for long term liabilities with respect to a water main extension loan and tile drainage loans. The total amount outstanding at December 31, 1999 is $84,111 (1998 - $96,985) and is not recorded on the Consolidated Balance Sheet. -9 - THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Notes to the Consolidated Financial Statements Year Ended December 31, 1999 8. PUBLIC SECTOR SALARY DISCLOSURE In 1999, no employees were paid a salary, as defined in the Public Sector Salary Disclosure Act, 1996, of$100,000 or more by The Corporation of the Municipality of Bayham. 9. CHARGES FOR NET LONG-TERM LIABILITIES Total charges for the year for net long-term liabilities which are reported on the Consolidated Statement of Operations are as follows: 1999 1998 S S Principal 13,927 532,286 Interest 8,343 15.476 22,270 547,762 10. CONTRACTUAL OBLIGATION -CITY OF LONDON/ONTARIO CLEAN WATER In accordance with a service agreement entered into by the municipality with the Ontario Clean Water Agency - OCWA, the existing Elgin Area Primary Water Supply System is owned and operated by the Agency. The municipality is obligated to meet its share of the operating costs and deficits and repay its share of the long-term liabilities related to these projects. The municipality's share is based on its water consumption relative to that of the other participating municipalities. As of September 1, 1998, the municipality has authorized the City of London to take over the administrative functions of the Primary Water Supply System including the issuance of debt to pay out the balance of debt and accumulated deficit of the participating municipalities. Charges related to operating costs and debt servicing are recovered through the water rates levied by the Municipality. Information received from the City of London as at December 31, 1999 indicates the following: Outstanding Contractual Accumulated 1999 Debt Long-term Obligation Surplus Charges Liabilities Primary Water Supply System City of London 27,462 11,942 102,939 The operating surplus and long-term liabilities indicated above are not reflected in the accompanying financial statements. -10 - '1999 FINANCIAL INFORMATION RETURN MUNICIPALITY: Bayham M 3401 in the Region,County or District of: Elgin Co N DECLARATION OF THE MUNICIPAL TREASURER Pursuant to the information required by the Province under the Muncipal Affairs Act,the following schedules are attached: Edit Check Completed 1 Analysis of Revenue Fund Revenues 0 Y 2LT-OP Analysis of Taxation-Own Purposes 0 Y 2LT-UP Analysis of Taxation-Upper Tier Purposes 0 Y 2LT-SB Analysis of Taxation-School Board Purposes 0 Y 2UT Analysis of Upper Tier Requisitions and Direct Charges 0 NA 3 Analysis of Current Revenue for Specific Functions 0 Y 4 Analysis of Revenue Fund Expenditures 0 Y 5 Analysis of Capital Operations 0 Y 6 Analysis of Capital Grants and Own Expenditures 0 Y 7 Analysis of Net Long Term Liabilities by Function 0 Y 8 Analysis of Long Term Liabilities and Commitments 0 Y 9LT Continuity of Upper Tier and School Board Levies 0 Y 10 Continuity of Reserves and Reserve Funds 0 Y 11 Analysis of Consolidated Year End Balances 0 Y 12 Statistical Data 0 Y 16 Analysis of User Fees 0 N The schedules have been drawn up in accordance with the instructions provided by the Ministry of Municipal Affairs and Housing. They represent the consolidated financial activities of the municipality,all local boards, including joint boards where applicable and any other local corporate entities set up by the municipality to provide services to ratepayers.The consolidated local boards and entities are: Vienna Community Centre Board Old Port Burwell Baptist Cemetery Board Vienna Museum Smuck Cemetery Board Bayham and Straffordville Community Centre Board Straffordville Cemetery Board Bayham West Cemetery Board Bayham Waterworks Calton Cemetery Board -- Claus Cemetery Board -- Dobbie Cemetery Board -- Eden Cemetery Board -- Edison Pioneer Cemetery Board -- Firby Cemetery Board -- Guysboro Cemetery Board -- Light Cemetery Board — Trust funds administered by the municipality and its local boards,harbour commissions,humane societies, municipal non-profit housing corporations,provincial-municipal housing authorities,sinking funds,retirement or pension plan funds, school boards,conservation authorities,children's aid societies,district health councils, municipal hospitals and gas,telephone and hydro utilities are not consolidated. The schedules have been prepared by: Graham Scott Enns Questions regarding the information contained in them should be addressed to: John Scott at: 519-633-0700 Control Data: s s Total Revenue-S1 L51 Cl 5,880,421 Total Assets-S11 L21 Cl 2,033,016 (Total Expenditure S4 L51 C7 3,419,592 Edit Checks out of balance 0 i7 4 r, \ri 2 (.' '' " ------,....." _____() ., ,,, ,,c,. _,_ _ _,... 1 ,•, ,,,_..,.. _,,,,, ,_• -,,,, Municipal Tre ., i, Dale FIR99V1.0-199311:30 GRAHAM SCOTT • ENNS LLP Chartered Accountants 450 Sunset Drive Telephone: (519) 633-0700 St. Thomas, Ontario Facsimile: (519) 633-7009 N5R 5V1 gse@grahamscottenns.com ACCOUNTANT'S REPORT THE CORPORATION OF THE MUNICIPALITY OF BAYHAIVI To the Ministry of Municipal Affairs Our audit of the consolidated financial statements of the Corporation of the Municipality of Bayham for the year ended December 31, 1999 was made for the purpose of forming an opinion on the consolidated financial statements referred to in our auditor's report to the Members of Council, Inhabitants and Ratepayers, dated March 9, 2000. Schedules 1 to 11 of the 1999 Financial Information Return have not been prepared on the same basis as the consolidated financial statements. For the purposes of this report we have performed, at your request, the following procedures in connection with Schedules 1 to 11 of the Financial Information Return of the Corporation of the Municipality of Bayham for the year ended December 31, 1999: (a) We have compared the amounts disclosed on these schedules to the books and records of the Municipality of Bayham and found them to be in agreement; (b) We have added and cross-added all schedules and found them to be arithmetically correct; and ( c) We have checked the cross-references indicated in the "Cross-References to Other Schedules" section for each of the above-noted schedules, as outlined in the "Instructions for Completing the 1999 Financial Information Return", and found all such cross-references to be in agreement. The above-noted procedures do not constitute an audit of these schedules. Therefore, we do not express an opinion on Schedules 1 to 11 of the 1999 Financial Information Return. St. Thomas, Ontario GRAHAM• SCOTT • ENNS April 25, 2000 Chartered Accountants Munkipairy ANALYSIS OF REVENUE FUND Bayham M 1 REVENUES 3 for the year ended December 31,1999 upper school total tier bored own revenue purpoeee purpose. purposes 1 2 3 4 $ 1 3 $ Taxation Taxation from schedules 2LTxz1 3,890,671 1,191,191 1,249,327 1,450,153 (or requisitions from schedule 2UT) 1 0 0 Direct water billings on ratepayers -awn municipality z 157,642 157,642 -other municipalities 3 0 Sewer surcharge on direct water billings --own municipality 4 136,875 136,875 --other municipalities 5 0 Subtotal 5 4,185,188 1,191,191 1,249,327 1,744,670 Payments in lieu of taxes Canada 7 0 Canada enterprises 8 0 Ontario The Municipal Tax Assistance Act 9 28,773 5,982 22,791 The Municipal Act,section 157 to 0 Othertt 0 Ontario enterprises Ontario Housing Corporation 12 0 Ontario Hydro 13 1,080 131 0 849 Liquor Control Board of Ontario 14 3,122 649 2.473 Other 15 0 Municipal enterprises 1s 0 Other municipalities and enterprises 17 0 Subtotal to 32,975 8,762 0 26,213 Ontario non-specific grants Community Reinvestment Fund 52 899,000 899,000 Special Transition Assistance 53 0 Special Circumstances Fund 64 _ 68,000 88,000 Municipal Restructuring Fund 95 0 _ 61 0 Subtotal 59 967,000 967,000 Revenues for specific functions Ontario specific grants 29 125,683 125,683 Canada specific grants 30 0 0 Other municipalities-grants and fees 31 266,500 266,500 Fees and service charges 32 51,436 51,4381 Subtotal 33 443,821 443,621 Other revenue Trailer revenue and licences 34 300 300 Licences and permits 35 87,590 87,590 Rents,concessions and franchises 39 47,371 47,371 Fines 37 0 _ Penalties and interest on taxes 39 46,834 46,634 Investment income-from own funds 39 0 _ 0 -other 40 56,547 56,547 Donations 70 13,19 13,195 Sale of publications,equipment,etc. 42 Contributions from capital turd 43 Contributions from reserves and reserve funds 44 Contributions from non consolidated entitles 45 _ Provincial Offences Act(POA) 71 49 •• 47 49 Subtotal 5o 251.63 0 0 251,637 Total revenue 51 5,880,421 1,197,953 1,248,327 3,433,141 CONTINUITY OF ACCUMULATED NET REVENUE(DEFICIT) The following is a verification of the continuity of Accumulated Net Revenue(Deficit). Accumulated net revenue(deficit),December 31,1998 (Enter the total of Lines 42 to 55 on Schedule 11 from the 1998 F.I.R.) A 293,44: 1999 Revenues(Schedule 1,Line 51,Column 4) B 3,433,141 1999 Expenditures(Schedule 4,Line 51,Column 7) C 3,419,59, Total-A*B-C D 306,99 Actual Accumulated net revenue(deficit),Dec.31,1999(Schedule 11,Lines 42 to 55) E 306,99 Difference-D minus E ' Normally,the difference should be zero or a relatively small number.Please explain any large difference. Municipality ANALYSIS OF TAXATION-OWN PURPOSES Bayham M 2LT-OP 41 for the year ended December 31,1999 Levy Levy RTC/ RTC/RTQ Tax Taxable Tax Taxes Code Purpose RTQ Description Band Assessment Rate Levied 1 2 3 4 5 7 8 9 Ctrl L Ctrl Q $ / $ (Must be entered) (Must be entered) 0.xxxxxx 1 100 General taxation RT Taxable at the full Residential and Fa/ 0 206,904,405 0.526446 1,089,240 2 100 General taxation I TT Taxable at the full Managed Forests r 0 234,695 0.131611 309 3 100 General taxation MT Taxable at the full Multi-Residential re 0 2,748,000 1.398872 38,441 4 100 General taxation CT Taxable at the full Commercial rate. 0 11,203,455 0.932862 104,513 5 100 General taxation CU Taxable at the"Commercial-Vacant 0 - 338,785 0.653003 2,212 6 100 General taxation CX Taxable at the"Commercial-Vacant 0 291,500 0.653003 1,904 7 100 'General taxation FT Taxable at the full Farmlands rate. 0 71,551,784 0.131611 94,170 8 100 General taxation PT Taxable at the full Pipeline rate. 0 4,094,000 0.661058 27,064 9 100 General taxation IT Taxable at the full Industrial rate. 0 1,256,210 1.753696 22,030 10 100 General taxation IU Taxable at the"Industrial-Vacant uni 0 282,280 1.139913 3,218 11 100 General taxation IX Taxable at the"Industrial-Vacant Ian 0 0 0.000000 0 12 100 General taxation LT Taxable at the full"Large Industrial"e 0 0 0.000000 0 13 100 General taxation LU Taxable at the"Large Industrial-Vac 0 0 0.000000 01 14 100 General taxation R1 Taxable at the"Residential and Farm 0 0 0.000000 0 15 I 0 0 16 3300 Press Ctrl R for more rows Total supplementary taxes 2,798 17 4000 Subtotal levied by tax rate 1,385,899 18 19 2200 Local improvements 40,596 20 2300 Sewer and water service charges 21 2400 Sewer and water connection charges 22 2500 Fire service charges 23 2600 Minimum tax(differential only) 24 2700 Municipal drainage charges 22.270 25 2800 Waste management collection charges 26 2900 Business improvement area 0 27 3400 Railway rights-of-way 1,388 28 3500 Utility transmission and utility corridors 29 3000 -- 30 3600 -- 31 3100 Subtotal special charges on tax bills 64,254 32 3200 Total own purpose taxation 1,450,153 Municipality ANALYSIS OF TAXATION -UPPER TIER PURPOSES Bayham M 2LT-UP 42 for the year ended December 31,1999 Levy Levy RTC! RTC/RTQ Tax Taxable Tax Taxes Code Purpose RTQ Description Band Assessment Rate Levied 1 2 3 4 5 7 8 9 $ % $ o.xxxxxx 1 100 General taxation RT Taxable at the full Residential and Fa' 0 206,904,405 0.452427 936,091 2 100 General taxation TT Taxable at the full Managed Forests r 0 ' 234,695 0.113107 265 3 100 General taxation MT Taxable at the full Multi-Residential ra 0 2,748,000 1.202189 33,036 4 100 General taxation CT Taxable at the full Commercial rate. 0 11,203,455 0.801701 89,818 5 100 General taxation CU _Taxable at the"Commercial-Vacant 0 338,785 0.561191 1,901 6 100 General taxation CX Taxable at the"Commercial-Vacant 0 291,500 0.561191 1,636 7 100 General taxation FT Taxable at the full Farmlands rate. 0 71,551,784 0.113107 80,930 8 100 General taxation PT Taxable at the full Pipeline rate. 0 4,094,000 0.568113 23,259 9 100 General taxation IT Taxable at the full Industrial rate. 0 1,256,210 1.507125 18,933 10 100 General taxation IU Taxable at the"Industrial-Vacant uni 0 282,280 0.979640 2,765 11 100 General taxation IX Taxable at the"Industrial-Vacant Ian 0 0 0.000000 0 12 100 General taxation LT Taxable at the full"Large Industrial"r. 0 0 0.000000 0 13 100 General taxation LU Taxable at the"Large Industrial-Vac 0 0 0.000000 0 14 100 General taxation R1 Taxable at the"Residential and Farm 0 0 0.000000 0 15 0 0 0 0 0 16 3300 Use S2LTop for more rows Total supplementary taxes 2,557 17 4000 Subtotal levied by tax rate 1,191,191 18 19 2200 Local improvements 20 2300 Sewer and water service charges 21 2400 Sewer and water connection charges 22 2500 Fire service charges 25 2800 Waste management charges 27 3400 Railway rights-of-way 28 3500 Utility transmission and utility corridors 29 3000 -- 30 3600 -- 31 3100 Subtotal special charges on tax bills 0 32 3200 Total upper tier purposes 1,191,191 MunldpE1y ANALYSIS OF TAXATION- Bayllatn M 2LT-SB SCHOOL BOARDS 46 Year ended December 31,1999 Distribution by Purpose English French English Frmch Tax Tax Language Language Language Language Coda Band Rate Total Public OSB Public05B Catholic OSB Catholic DSB ---- 1 2 3 d 5 6 7 58 $ 8 f $ 3 Residential/Multi•Resid't/Farmland/Managed Forests o.» Residential and farm-general Iso 1 I 0.460000 856,584 782,406 3.162 69,590 1,426 -farmland pending development-Phas1 200 2 0 0 0 -farmland pending development-Phas1 300 3 0 Multi-residential-general 400 4 j 0.460000 11.377 10,690 0 687 -farmland pending development-Phas1 506 5 ; 0 -farmland pending development-Phas1 600 5 0 Farmland 700 7 - 0.115000 74,056 63,273 277 10,506 Managed forests boo a 0.115000 243 216 27 -- 900 9 I 0 Subtotal Residential/MR/F/MF 1000 10 942,260 856,585 3,439 80,810 1,426 Ctrl 0 Ctrl B Commercial Commercial Taxable-Full 11 0 1.828977 204,909 Commercial Taxable-Vacant Unit/Excess Land 62 0 1.280284 4,337 Commercial Taxable-Vacant Land 13 0 1 1.280284 3,732 14 0 0.000000 0 15 0 0.000000 0 -- 16 0 -- 17 0 -- is 0 1 -- 19 0 20 0 -- 21 0 22 0 -- 23 0 __ 24 0 -- 25 0 __ 26 0 I -- 27 0 -- 28 0 29 0 -_ so 0 31 0 32 0 Please anter the breakdown of Column -- 33 0 I In Columns 4,5.0 and 7 -- 34 Subtotal Commercial 9200 35 212,978 167,0511 9501 43,4841 1,493 Ctrl Cl ED Industrial Industrial Taxable-Full 36 0 3.259944 40,952 • Industrial Taxable-Vacant Unit/Excess Land 37 0 2.118964 5,981 36 0 39 0 -- 40 0 -- 41 0 -- 42 0 43 0 -- 44 0 __ 45 0 -- 46 0 __ 41 0 -- 48 0 Please enter the braakdoWn of Column 3 - 49 0 in Columns 4,3,6 and 7 50 0 Subtotal Industrial 9300 51 46,9331 36,8131 2091 9,5821 329 Pipeline ciao 52 1.296600 53,083 41,636 237 10,838 372 Other 4200 53 0 Supplementary taxes 4300 sa •7,516 -2,715 -40 -4,698 -63 Subtotal levied by tax rate 9400 55 I 1,247,738 1,099,370 4,795 140,016 3,557 Railway rights-of-way 6100 55 I 1,589 1,589 Utility transmission/distribution corridor 5200 57 I 0 -- 5300 58 1 - 0 Subtotal special charges on tax bills 9500 59 1,589 1,589 01 0 01 Total school board purposes 9900 60 1 1,249,3271 1,100,9591 4,7951 140,0161 3,557 Municipat9 ANALYSIS OF CURRENT REVENUE Bayham M 3 FOR SPECIFIC FUNCTIONS for,he year endeu Decemoer 31,1999 other Ontario municipalities- fns prod specMe Canada grants,fns,and service grants grants sande.charges charges 1 2 3 4 s s $ General government + 95,136 12,156 Protection to persons and property Fire 2 970 Police 3 Conservation authority 4 Protective inspection and control s Emergency measures 6 Subtotal 7 0 0 0 970 Transportation services Roadways e 656 266,500 15,405 Winter control 9 Transit 10 Parking Street lighting 12 Air transportation 13 Harbour 14 16,028 1,000 Subtotal 15 16,684 0 266,500 16,405 Environmental services Sanitary sewer system 16 Storm sewer system 1i Waterworks system 16 13.863 12,331 Garbage collection 19 Garbage disposal 20 Pollution control 21 22 Subtotal 23 13,863 0 0 12,331 Health services Public health services 24 i Public health inspections and control 25 Hospitals 26 Ambulance services 27 Cemeteries 26 29 Subtotal 30 0 0 0 0 Social and family services General assistance 31 Assistance to aged persons 32 Assistance to children 33 Day nurseries 34 35 Subtotal 3s 0 0 0 0 Social housing g0 Recreation and cultural services Parks and recreation 37 6,368 Libraries 38 Other cultural 33 3,208 Subtotal 40 0 0 0 9,576 Planning and development Planning and zoning 41 Commercial and industrial 42 Residential development 43 Agriculture and reforestation 44 Tile drainage/shoreline assistance 45 46 Subtotal 47 0 0 0 0 Electricity 48 Gas 49 Telephone so Total s1 125,683 0 266,500 51,438 Mun,cintety Page 1 ANALYSIS OF REVENUE FUND Bayham M 4 EXPENDITURES 8 for the year ended December 31,1999 material., salaries, aarvieaa, wages and rents and transfers Inter• empiaysa net long tarn, financial to own other functional total benefits debt charge. expenses funds transfers transfer. expenditure 1 2 3 4 5 6 7 f 9 f $ $ 9 $ General government 1 245,972 341,184 10,500 1 597,656 I Protection to persons and property Fire 2 92,310 65,376 121,167 278,853 2 Police 3 01 455,182 455,182 3 Conservation authority 4 12,377 12,377 4 Protective inspection and control s 62,801 14,683 8,755 86,239 5 Emergency measures 8 0 6 Subtotal 7 155,111 0 535,241 129,922 12,377 0, 832,651 7 Transportation services Roadways s 204,590 474,430 224,810 903,830 a Winter control a 50,473 50,473 9 Transit 10 0 to Parking 11 0 11 Street lighting 12 30,006 30,006 12 Air transportation 13 0 13 Harbour front 14 35,881 3,000 38,881 14 Subtotal 15 204,590 0 590,790 227,810 0 0 1,023,190 15 Environmental services Sanitary sewer system 1s 20,548 78,004 16,000 114,552 16 Storm sewer system 17 0 17 Waterworks system 18 21,673 126,605 27,500 175,778 18 Garbage collection 19 4,149 4,149 19 Garbage disposal 20 254,597 254,597 20 Pollution control 21 0 21 -- 22 I 0 22 Subtotal 2a 42,2211 0 463,355 43,500 0 0 549,076 23 Health services Public health services 24 6,380 4,605 10,985 24 Public health inspections and control 25 1 0 25 Hospitals 26 I 0 26 Ambulance services 27 0 27 Cemeteries 28 13,154 13,154 28 -- 23 029 Subtotal 30 0 0 19,534 4,605 01 0 24,139 30 Social and family services General assistance 31 5,800 5,800 31 Assistance to aged persons 32 0 32 Assistance to children 33 0 33 Day nurseries 34 0 34 -- 35 0 35 Subtotal 35 0 0 5,800 0 0 0 5,8001 36 1 Social housing 99 0 90 Recreation and cultural services Parks and recreation 37 74,423 46,903 121,326 37 Libraries 38 8,746 8,746 38 Other cultural 39 26,414 89,650 25,678 141,742 39 Subtotal 40 26,414 0 172,819 72,581 0 0 271,814 40 Planning and development Planning and zoning 41 33,269 52,404 85,673 41 Commercial and industrial 42 l 0 62 Residential development 43 0 43 Agriculture and reforestation 44 8,2941 7,323 15,617 44 Tile drainage/shoreline assistance 45 13,9761 1 ,,r 1 13,976 45 _- 46 1 1 0 46 Subtotal 47 33,269 22,270 59,7271 01 0 0 115,266 47 Electricity 4a _-• 0 48 Gas 49 I1 0 49 Telephone s0 0 50 Total 51 707,577 22,270 2,188,450 488,918 12,377 0 3,419,592 51 Municipality - Page 2 Bayham M 4 a Total of column 2 Includes: Payments to Ontario in respect of Down- town Revitalization Program loans e1 Accrued interest(enter an amount only if the change to the accrual basis was made in this reporting year) az Interest portion of transit debt charges included on line 10 63 Total of column 3 includes: Ontario Clean Water Agency Provincial projects service charges •water 52 -sewer 53 Provincial projects frontage and connection charges•water 57 -sewer 56 Joint projects operating charges -water 54 -sewer ss O.P.P.policing 66 Short term interest costs 60 Ontario Property Assessment Corporatior 61 Total of column 5 includes: Grants to charitable and non-profit organizations 62 Grants to universities and colleges 63 Go Transit as Contributions to UNCONSOLIDATED joint local boards Health unit 64 District welfare board es Home for the aged 6e Recreation board(s) 67 Fire area board 65 Suburban roads commission 69 70 71 Line 1 of column 7 includes: Members of council 72 45,208 Line 51 of column 7 includes: Payments in respect of long term commit- ments and liabilities financed from revenue, as approved by the Ontario Municipal Board or Council,as the case may be.Exclude debt charges reported in column 2. 73 Municipality ANALYSIS OF CAPITAL OPERATIONS Bayham M 5 9 for the year ended December 31,1999 1 $ Unfinanced capital outlay(Unexpended capital financing) at the beginning of the year i Sources of financing Contributions from own funds Revenue fund 2 263,418 Reserves and reserve funds 3 170,356 Subtotal 4 433,774 Long term liabilities incurred Central Mortgage and Housing Corporation 5 Ontario Financing Authority 7 Commercial Area Improvement Program 9 Other Ontario housing programs to Ontario Clean Water Agency it Tile drainage and shoreline property assistance programs 12 Serial debentures 13 154,100 Sinking fund debentures 14 Long term bank loans 15 Long term reserve fund loans 16 17 Subtotal* to 154,100 Grants and loan forgiveness Ontario 20 0 Canada 21 0 Other municipalities 22 0 Subtotal 23 0 Other financing Prepaid special charges 24 Proceeds from sale of land and other capital assets 25 Investment income From own funds 26 Other 27 Donations 28 30 31 Subtotal 32 0 Total sources of financing 33 587,874 Applications Own expenditures Short term interest costs 34 Other 35 1,169,064 Subtotal 36 1,169,064 Transfers of proceeds from long term liabilities to: Other municipalities 37 Unconsolidated local boards 38 Individuals 39 Subtotal ao Transfers to reserves,reserve funds and the revenue fund 41 Total applications 42 1,169,06, Unfinanced capital outlay(Unexpended capital financing)at the end of the year 43 581,190 Amount reported in line 43 analysed as follows: • Unapplied capital receipts(negative) 44 To be recovered from: -taxation or user charges within term of council 45 -proceeds from long term liabilities 46 -transfers from reserves and reserve funds 47 -benefitting landowners 48 581,190 Total unfinanced capital outlay(unexpended capital financing) 49 581,190 -amount in line 18 raised on behalf of other municipalities IS Mwecipaby ANALYSIS OF CAPITAL GRANTS Bayham M 6 AND OWN EXPENDITURES 10 for the year ended December 31,1999 CAPITAL GRANTS TOTAL Ontario Cenede Other OWN grant. grants munlelpelldu EXPENDITURES f 2 3 4 f S f S General government Protection to persons and property Fire 2 31,567 Police 3 Conservation authority 4 Protective inspection and control 5 8,755 Emergency measures 6 Subtotal 7 0 0 0 40,322 Transportation services Roadways R 314,267 Winter control 9 Transit 10 Parking 11 Street lighting 12 Air transportation 13 14 Subtotal 15 0 0 0 314,267 Environmental services Sanitary sewer system 1s 588,190 Storm sewer system 17 Waterworks system 1a 7,000 Garbage collection 19 Garbage disposal 20 Pollution control 21 22 Subtotal 23 01 0 0 595,190 Health services Public health services 24 98,605 Public health inspections and contr, 25 Hospitals 26 Ambulance services 27 Cemeteries 28 29 Subtotal 30 0 0 0 98,605 Social and family services General assistance 31 Assistance to aged persons 32 Assistance to children 33 Day nurseries 34 35 Subtotal 36 0 0 0 0 Social housing 90 j Recreation and cultural services Parks and recreation 37 98,902 Libraries 39 Other cultural 39 21,778 Subtotal 40 0 0 120,680 Planning and development Planning and zoning 41 Commercial and industrial 42 Residential development 43 Agriculture and reforestation 44 Tile drainage/shoreline assistance 45 ,",r n 48 Subtotal 47 0 0� 0 0 Electricity 48 Gas 49 Telephone s0 Total 51 0 01 0 1,169,064 Municipairy ANALYSIS OF NET LONG TERM Bayham M 7 LIABILITIES BY FUNCTION aar Oecemuer 11,1999 General government 1 Protection to persons and property Fire 2 Police Conservation authority 4 Protective inspection and control 5 Emergency measures 5 Subtotal 7 0 Transportation services Roadways 5 Winter control 9 Transit 10 Parking 11 Street lighting 12 Air transportation 13 14 Subtotal 15 0 Environmental services Sanitary sewer system 15 Storm sewer system 17 Waterworks system 15 0 Garbage collection 19 Garbage disposal 20 Pollution control 21 22 Subtotal 23 0 Health services Public health services 24 97,000 Public health inspections and control 25 Hospitals 26 Ambulance services 27 Cemeteries 28 29 Subtotal 30 97,000 Social and family services General assistance 31 Assistance to aged persons 32 Assistance to children 33 Day nurseries 34 35 Subtotal 36 0 Social housing 9° Recreation and cultural services Parks and recreation 37 57,100 Libraries 38 Other cultural 39 Subtotal 40 57,100 Planning and development Planning and zoning 41 Commercial and industrial 42 Residential development 43 Agriculture and reforestation 44 1,879 Tile drainage/shoreline assistance 45 84,111 46 Subtotal 47 85,990 Electricity 48 Gas 49 Telephone 5o Total 51 240,090 Municipality ANALYSIS OF LONG TERM Bayham M 8 LIABILITIES AND COMMITMENTS 12 for the year ended December 31.1999 1 1.Calculation of debt burden of the municipality All debt issued by the municipality,predecessor municipalities and consolidated entities :To Ontario and agencies 1 52,681 :To Canada and agencies 2 :To other 3 187,409 Subtotal 4 240,090 Plus:All debt assumed by the municipality from others 5 Less:All debt assumed by others :Ontario 6 :Schoolboards 7 :Other municipalities 8 Subtotal 9 0 Less:Ontario Clean Water Agency debt retirement funds -sewer to -water 11 Own sinking funds(actual balances) -general 12 -enterprises and other 13 Subtotal 14 0 Total 15 240,090 Amount reported in line 15 analyzed as follows: Sinking fund debentures 16 Installment(serial)debentures 17 240,090 Long term bank loans 18 0 Lease purchase agreements 19 Mortgages 20 Ontario Clean Water Agency 22 Long term reserve fund loans 23 24 2.Total debt payable in foreign currencies(net of sinking fund holdings) U.S.dollars-Canadian dollar equivalent included in line 15 above 25 -par value of this amount in U.S.dollars 26 Other -Canadian dollar equivalent included in line 15 above 27 -par value of this amount in Canadian dollars 28 $ 3.Interest earned on sinking funds and debt retirement funds during the year Own funds 29 Ontario Clean Water Agency-sewer 30 -water 31 $ S 5.Long term commitments and contingencies at year end Total liability for accumulated sick pay credits 33 Total liability under OMERS plans - -initial unfunded (payable over yrs.) 0 (no.of employees) 0 34 -actuarial deficiency (payable over yrs.) 0 35 Total liability for own pension funds -initial unfunded (payable over yrs.) 0 (no.of employees) 0 361 -actuarial deficiency (payable over yrs.) 0 37 Outstanding loans guarantee (payable over yrs.) 0 38 Commitments and liabilities financed from revenue,as approved by the Ontario Municipal Board or Council,as the case may be -hospital support 39 -university support 40 -leases and other agreements 41 Other(specify)-- 42 43 44 Total 45 0 6.Ontario Clean Water Agency Provincial Projects accumulated total outstanding debt surplus(deficit) capital obligation charges 1 2 3 S S S Water projects -for this municipality only 46 -share of integrated project(s) 47 27,462 102,939 11,942 Sewer projects-for this municipality only 48 -share of integrated project(s) 49 principal Interest 1 2 7.1999 Debt Charges $ S Recovered from the consolidated revenue fund -general tax rates 50 -special area rates and special charges 51 -benefitting landowners 52 13,9271 8,343 -user rates(consolidated entities) 53 Recovered from reserve funds 54 Recovered from unconsolidated entities -hydro 55 -gas and telephone 57 56 58 59 Total 78 13,927 8,343 Line 78 includes: Financing of one-time real estate purchase 90 Other lump sum(balloon)repayments of long term debt 91 8.Future principal and interest payments on EXISTING net debt recoverable from the recoverable from recoverable from consolidated revenue fund reserve funds unconsolidated entities principal interest principal interest principal Interest 1 2 3 4 I 5 6 $ $ $ $ $ $ 2000 60 44,884 17,068 2001 61 48,033 13,918 2002 62 50,356 10,544 2003 63 51,729 7,007 2004 64 28,682 3,402 I 2005-2009 65 16,406 2,948 2010 onwards 79 Interest to be earned on sinking funds* 69 Downtown revital- ization program 70 Total 71 240,090 54,887 0, 0, 0 0 *includes interest to be earned on Ontario Clean Water Agency debt retirement funds 9.Future principal payments on EXPECTED NEW debt 1 $ 2000 72 2001 73 2002 74 2003 75 j 2004 76 Total 77 0 i 10.Other notes(attach supporting schedule as required) principal interest 1 2 11.Long term debt refinanced: $ $ Repayment of Provincial Special Assistance 92 Other long term debt refinanced 93 Municipality CONTINUITY OF UPPER TIER AND SCHOOL BOARD LEVIES Bayham M 9LT 13 kr the year ended December 31,1999 share of balance at amount share of payments balance beginning amounts supplementary total of levy Provincial In lieu of tole at end of year levied expanded raised grants avec other raised of yew texas ee t UPPER TIER 1 2 3 4 5 a 9 to 12 11 s s $ $ s $ $ s I $ Included in general tax rate for upper tier purposes General levy 1 1,188,634 2,55 1,191,191 1 Special purpose levies Water rate 2 0 2 Transit rate 3 0 3 Sewer rate 4 0 4 Library rate 6 0 5 Road rale 6 I a -- 7 I 7 -- a I a Payments in lieu of taxes 9 6,76. 6,76. 9 Subtotal levied by tax rate—genet. 11 1,195,39• 2,55 1,197,95 1,191,191 6,762 1,197,953 0 It Special purpose levies Water 12 I 12 Transit 13 I 13 Sewer 14 -- — I 14 Library 15 I 15 16 I 16 -- 17 I 17 Subtotal levied by W rate-epactal area 18 I 0 0 18 Special charges 19 I 0 0 19 Direct water billings 20 _ _ I 0 0 20 Sewer surcharge on direct water billings 21 I 0 0 21 Total region or county 22 ' 1,195,396 2,55 1,197,95 1,191,191 0 6,762 0 1,197,953 0 22 pupils' shun of pupils' balance at fees,shook amount of payments raw,shwa balance beginning amounts supplementary of baler total levy inll.0 of of baler total at end ofytar levied Wes licences expended raised taxes licences rained of yew SCHOOL BOARDS 1 2 3 4 5 6 a 9 so 11 9 9 9 s s s $ s $ s English Language Public DSB(specify) Thames Valley 62 1,103,674 -2,715 1,100,959 1,100,959 0 1,100,959 0 62 63 0 0 063 French Language Public DSB(specify) Conseil Scolaire 64 4,835 -40 4,795 4,795 0 4,795 0 64 65 0 0 0 65 English Language Catholic DSB(specify) London District Catholic 93 144,714 -4,698 140,016 140,016 0 140,016 0 93 -- 94 0 0 094 French Language Catholic DSB(specify) French Language Seperale 95 3,620 -63 3,557 3,557 0 3,557 0 95 -- 96 0 0 096 Total school boards 36 0 1,256,843 -7,516 0 1,249,327 1,249,327 0 0 1,249,327 0 as M9914194ly CONTINUITY OF RESERVES Bayham M 10 AND RESERVE FUNDS +5 for the year ended December 3I,1999 7 Balance at the beginning of the year 1,392,763 Revenues Contributions from revenue fund 2 225,500 Contributions from capital fund 3 Development Charges Act 67 Lot levies and subdivider contributions so Recreational land(the Planning Act) 61 4.000 Investment income-from own funds 5 -other 6 32,711 -- 9 10 11 12 Total revenue 13 262,211 Expenditures Transferred to capital fund 14 170,356 Transferred to revenue fund +5 Charges for long term liabilities-principal and interest +6 53 20 21 Total expenditure 22 170,356 Balance at the end of the year for: Reserves 23 784,226 Reserve Funds 24 700,392 Total 25 1,484,618 Analysed as follows: Reserves and discretionary reserve funds: Working funds 26 334,307 Contingencies 27 Ontario Clean Water Agency funds for renewals,etc. -sewer 28 -water 29 Replacement of equipment 30 330,919 Sick leave 31 Insurance 32 15,000 Workers'compensation 33 Capital expenditure-general administration 34 -roads 35 21.000 -sanitary and storm sewers 36 531,322 -parks and recreation 64 -library 65 -other cultural 66 30,048 -water 36 158,491 -transit 39 -housing 40 -industrial development 41 6,468 -other and unspecified 42 11,902 Waterworks current purposes 49 Transit current purposes 50 Library current purposes 51 52 53 54 Obligatory reserve funds: Development Charges Act 66 Lot levies and subdivider contributions 44 Recreational land(the Planning Act) 46 45,161 Parking revenues 45 Debenture repayment 47 Exchange rate stabilization 48 55 56 57 Total 55 1,484,618 sour. ity ANALYSIS OF CONSOLIDATED Bayham M 11 YEAR END BALANCES 16 as at December 31,1999 2 S 9 ASSETS portion of cash not Current assets in chartered banks Cash 1 1,160,455 Accounts receivable Canada 2 57,5881 Ontario 3 112,107 Region or county 4 46,505 Other municipalities 5 5,082 School boards 6 C porton of taxes 'Waterworks 7 47,160 receivable for Other(including unorganized areas) 8 24,739 business pares Taxes receivable Current year's levies 9 205,515,( - Previous year's levies to 71,830 Prior years'levies 11 22,028 Penalties and interest 12 22.472 Less allowance for uncollectibles(negative) 13 Investments (market value ------ ) Canada 14 Provincial 15 Municipal 16 Other 17 Other current assets 18 17,445 porfonorine20 Capital outlay to be recovered in future years 19 240,090 for edeaea Deferred taxes receivable so registration Other long term assets 20 Total 21 2,033,016 LIABILITIES portion or loans not Current liabilities born chartered banks Temporary loans-current purposes 22 -capital-Ontario 23 -Canada 24 -Other 25 Accounts payable and accrued liabilities i Canada 26 Ontario 27 Region or county 26 Other municipalities 29 School boards 30 11,9371 Trade accounts payable 31 554,42 Other 32 16,1431 Other current liabilities 33 Net long term liabilities Recoverable from the Consolidated Revenue Fund -general tax rates 34 154,100 -special area rates and special charges 35 -benefitting landowners 36 85,99C -user rates(consolidated entities) 37 Recoverable from Reserve Funds 38 0 Recoverable from unconsolidated entities 39 Less:Own holdings(negative) 40 Reserves and reserve funds 41 1,484,617 Accumulated net revenue(deficit) General revenue 42 255,703 Special charges and special areas(specify) Benefiting landowners 43 -2.918 44 45 46 Consolidated local boards(specify) Transit operations 47 Water operations 46 Libraries 49 • Cemeteries 50 54,210 Recreation,community centres and arenas 51 52 53 54 55 Region or county 56 School boards 57 Unexpended capital financing/(unfinanced capital outlay) se -581,190 Total 59 2,033,016 Municipality STATISTICAL DATA Bayham M 12 17 for the year ended December 31,1999 1 1. Number of continuous full time employees as at December 31 Administration 1 8 Non-line Departmental Support Staff 2 Fire 3 Police 4 Transit 5 Public Works 6 8 Health Services 7 Homes for the Aged 8 Other Social Services 9 Parks and Recreation 10 Libraries 11 Planning 12 1 Total 13 17 continuous full time employees December 31 other 1 2 2. Total expenditures during the year on: S S Wages and salaries 14 587,884 56,438 Employee benefits 15 104,753 2,038 1 1 $ 3. Reductions of tax roll during the year(lower tier municipalities only) Cash collections:Current year's tax 16 3,685,156 Previous years'tax 17 205,266 Penalties and interest 18 42,030 Subtotal 19 3,932,452 Discounts allowed 20 4,302 Tax adjustments under sections 421,441 and 442 of the Municipal Act -recoverable from general municipal accounts 25 17,189 -recoverable from upper tier 90 12,027 -recoverable from school boards 91 29,309 Transfers to tax sale and tax registration accounts 26 The Municipal Elderly Residents'Assistance Act-reductions 27 -refunds 28 Tax relief to low income seniors and disabled persons under various Acts including section 373 of the Municipal Act -deferrals 92 -cancellations 93 438 -other 94 2 Rebates to eligible charities under section 442.1 of the Municipal Act -recoverable from general municipal accounts 95 -recoverable from upper tier 96 -recoverable from school boards 97 Rebates under section 442.2 of the Municipal Act -commercial properties 98 -industrial properties 99 Bo Total reductions 29 3,995,717 Amounts added to the tax roll for collection purposes only 30 Business taxes written off under subsection 441(1)of the Municipal Act 81 4. Tax due dates for 1999(lower tier municipalities only) 1 Note:Date fields must be numeric,e.g.,March 24 1999 entered as 19990324 not"1999-03-24" Interim billings: Number of installments 31 2 Due date of first installment(YYYYMMDD) 32 19990312 Due date of last installment(YYYYMMDD) 33 19990528 Final billings: Number of installments 34 2 Due date of first installment(YYYYMMDD) 35 19991015 Due date of last installment(YYYYMMDD) 36 19991126 $ Supplementary taxes levied with 2000 due date 37 5. Projected capital expenditures and long term financing requirements as at December 31 long term financing requirements approved by submitted but not forecast not yet gross the O.M.B. yet approved by submitted to the expenditure or Council O.M.B.or Council O.M.B.or Council 1 2 3 4 S $ $ $ Estimated to take place In 2000 58 3,268,154 3,268,154 In 2001 59 In 2002 60 In 2003 61 In 2004 62 Total 63 3,268,154 3,268,154 0 0 balance of fund loans outstanding 1 2 �I $ S 6. Ontario Home Renewal Plan trust fund at year end 821 2,948 2,948 7. Analysis of direct water and sewer billings as at December 31 number of 1999 billings Place cursor in cell in Col 0 and press residential residential all other computer use <Ctrl>M to enter municipal name. units units properties only 1 2 1 3 4 Water $ S In this municipality 39 686 149,3061 8,336 In other municipalities(specify munic'ty) -- 40 • 0 -- 41 0 • -- 42 0 — 43 0 — 64 0 number of 1999 billings Place cursor in cell in Col D and press' residential residential all other computer use <Ctrl>M to enter municipal name. units units properties only i 1 2 3 4 Sewer S $ In this municipality 44 452 130,807 6,068 In other municipalities(specify munic'ty) — 45 0 — 46 0 -- 47 0 -- 48 1 0 — 65 0 water sewer Number of residential units in this municipality receiving municipal water 1 2 and sewer services but which are not on direct billing 66 8. Selected investments of own sinking funds as at December 31 other own municipalities, municipality school boards Province Federal 1 2 3 4 S $ 5 S Own sinking funds 83 9. Borrowing from own reserve funds 1 $ Loans or advances due to reserve funds as at December 31 84 10. Joint boards consolidated by this municipality this municipal- contribution ity's share of for total board from this total municipal computer expenditure municipality contributions use only 1 2 3 4 name of joint boards $ $ 53 54 55 56 57 tile drainage, 11. Applications to the Ontario Municipal Board shoreline assist- or to Council ance,downtown revitalization, other other electricity submitted submitted gas,telephone to O.M.B. to Council total 1 2 4 3 $ $ $ $ App'd but not financed as at Dec 31,1998 67 0 Approved in 1999 68 154,100 154,100 Financed in 1999 69 154,100 154,100 No long term financing necessary 70 0 App'd but not financed as at Dec 31,1999 71 0 0 0 0 Applications submitted but not approved as at December 31,1999 72 0 12. Forecast of total revenue fund expenditures 2000 2001 2002 2003 2004 1 2 3 4 5 $ $ $ $ $ 73 3,600,000 3,625,000 3,650,000 3,675,000 3,700,000 13.Municipal procurement this year number of contracts value 1 2 $ Total construction contracts awarded 85 Construction contracts awarded at$100,000 or greater 86 THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Unconsolidated Trust Funds December 31, 1999 GRAHAM • SCOTT • ENNS LLP Chartered Accountants 450 Sunset Drive Telephone: (519) 633-0700 St. Thomas, Ontario Facsimile: (519) 633-7009 N5R 5V1 Email: gse@grahamscottenns.com AUDITORS' REPORT To the Members of Council, Inhabitants and Ratepayers of The Corporation of the Municipality of Bayham We have audited the trust fund balance sheet of The Corporation of the Municipality of Bayham as at December 31, 1999 and the trust fund statement of continuity for the year then ended. These financial statements are the responsibility of the Municipality's management. Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform an audit to obtain reasonable assurance whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. In our opinion, these financial statements present fairly, in all material respects, the financial position of the trust fund of the Municipality as at December 31, 1999 and the continuity of trust fund for the year then ended in accordance with the accounting principles disclosed in Note 1 to the financial statements. St. Thomas, Ontario 9frzaktot Scant Ste, ZIP March 9, 2000 CHARTERED ACCOUNTANTS THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Trust Funds Balance Sheet As At December 31, 1999 Cemeteries Care and O.H.R.P. Developers' Total Maint Fund Funds Deposits 1999 $ $ $ $ Assets Cash 29,533 973 16,582 47,088 Acounts receivable 2,660 746 - 3,406 Loans receivable - 2,948 - 2,948 Debentures 136,606 - - 136,606 168,799 4,667 16,582 190,048 Liabilities Administration fees & interest payable - 267 - 267 Accounts payable 1,763 1,452 - 3,215 1,763 1,719 - 3,482 Fund Balances Capital balance 167,036 2,948 16,582 186.566 168.799 4,667 16.582 190.048 See accompanying notes to the financial statements THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Trust Funds Statement of Continuity As At December 31, 1999 Cemeteries Care and O.H.R.P. Developers' Total Maint Fund Funds Deposits 1999 $ $ S $ Balance, beginning of year 155,437 4,151 15,925 175,513 Capital receipts From cemetery board 568 - - 568 Sale of plots/monuments 11,031 - - - Interest earned 10,168 516 558 11,242 21,767 516 558 11,810 Expenditures Payments to cemetery board 10,168 - - 10,168 Repayment to Ministry of Housing - 1,452 - 1,452 Administration fees - 76 - 76 Interest transfer - 191 - 191 10,168 1,719 - 11,887 Balance, end of year 167,036 2,948 16,483 186,467 See accompanying notes to the financial statements THE CORPORATION OF THE MUNICIPALITY OF BAYHAM Trust Funds Notes to the Financial Statements As At December 31, 1999 1. SIGNIFICANT ACCOUNTING POLICY Basis of accounting Capital receipts and income are reported on the cash basis of accounting. Expenditures are reported on the cash basis of accounting with the exception of administrative expenses which are reported on the accrual basis of accounting, which recognizes expenditures as they are incurred and measurable as a result of the receipt of goods or services and the creation of a legal obligation to pay. 2. ONTARIO HOME RENEWAL PROGRAM The Ontario Home Renewal Program was established by the Ontario Ministry of Housing in 1973 to provide grants for municipalities to make loans to assist owner occupants to repair, rehabilitate and improve their home to local property standards. Individual loans are limited to $7,500 of which the maximum forgivable portion is $4,000. Ontario Home Renewal Program loans receivable at December 31, 1999 comprise repayable loans of $2,948 (1998 - $4,151) and forgivable loans of $nil (1998 - nil). Loan forgiveness is earned and recorded at a rate of up to $600 per year of continued ownership and occupancy. In the event of the sale or lease of the home or in the event of the homeowner ceasing to occupy the home, the balances of the repayable loan and the unearned forgivable loan immediately become due and payable by the homeowner.