The URL can be used to link to this page

Home My WebLink AboutStatement of Financial Information 2017 City of Maple Ridge Statement of Financial Statement of Financial Statement of Financial Statement of Financial InformationInformationInformationInformation 2017 Page 3 of 50 City of Maple Ridge - Statement of Financial Information Compliance with the Financial Information RegulationCompliance with the Financial Information RegulationCompliance with the Financial Information RegulationCompliance with the Financial Information Regulation The Financial Information Act (the Act) identifies organizations that must prepare financial information and make it available to the public within six months of their fiscal year end. The City of Maple Ridge (the City) is one of the organizations identified and therefore the attached Statement of Statement of Statement of Statement of Financial InformationFinancial InformationFinancial InformationFinancial Information has been prepared in order to comply with this legislation. The Financial Information Regulation specifies the required content for these statements and schedules. As such the City’s Statement of Financial Information includes the following: • The 2012012012017777 Consolidated Financial Consolidated Financial Consolidated Financial Consolidated Financial StatementsStatementsStatementsStatements, including a Schedule of Debt (Schedule 4). The statements are prepared in accordance with generally accepted accounting principles and include the accounting policies followed in preparing the financial statements. • The 2012012012017777 Schedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity Agreements includes a list of financial guarantees and indemnity agreements in force at December 31, 2017. The list includes the names of the entities and the amount of money involved. • The 2012012012017777 Schedule of Remuneration and ExpensesSchedule of Remuneration and ExpensesSchedule of Remuneration and ExpensesSchedule of Remuneration and Expenses for elected officials and employees. For elected officials the Schedule includes an alphabetical list of each member of Council, the total amount of remuneration paid, the value of benefits received and the total amount of expenses paid to or on behalf of that Council member during 2017. For employees, the schedule includes an alphabetical list of each employee earning in excess of $75,000, the total amount of remuneration paid and the total amount of expenses paid to or on behalf of that employee during 2017. The total amount of expenses recorded includes only expenses reimbursed with City funds. Expenses reimbursed by other organizations are excluded. In addition, the schedule includes a total paid to all other employees during 2017 where the amounts paid are less than the $75,000 threshold. • The 2017201720172017 Statement of Severance AgreementsStatement of Severance AgreementsStatement of Severance AgreementsStatement of Severance Agreements includes the number of severance agreements made during 2017 by the City in respect of non-union employees and the number of equivalent months’ gross salaries represented by these agreements. • The 2012012012017777 Schedule of Payments for the Provision of Goods or Services Schedule of Payments for the Provision of Goods or Services Schedule of Payments for the Provision of Goods or Services Schedule of Payments for the Provision of Goods or Services includes an alphabetical list of the individuals or corporations where the total amount paid during 2017 exceeds $25,000. In addition, the schedule includes a total of all amounts paid to all other suppliers during 2017 where the amounts paid are less than the $25,000 threshold. Page 4 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge 2012012012017777 Statement of Financial InformationStatement of Financial InformationStatement of Financial InformationStatement of Financial Information Table of ContentsTable of ContentsTable of ContentsTable of Contents Page Audited Financial Statements (including a schedule of debts) 7 Schedule of Guarantee & Indemnity Agreements 40 Schedule of Remuneration & Expenses 41 Statement of Severance Agreements 45 Schedule of Payments for the Provision of Goods & Services 46 Page 5 of 50 City of Maple Ridge - Statement of Financial Information Page 6 of 50 City of Maple Ridge - Statement of Financial Information City of Maple Ridge Financial Statem ents and Auditor’s R eport For the Year Ended December 31, 20 17 Page 7 of 50 City of Maple Ridge - Statement of Financial Information Management’s Responsibility for Financial Reporting The information in this Annual Report is the responsibility of management. The consolidated financial statements have been prepared in accordance with Canadian Public Sector accounting guidelines as outlined under “Significant Accounting Policies”. These include some amounts based on management’s best estimates and careful judgment. Management maintains a system of internal accounting controls to provide reasonable assurance that assets are safeguarded and that transactions are authorized, recorded, and reported properly. Management also administers a program of proper business compliance. BDO Canada LLP, the Municipality’s independent auditors have audited the accompanying financial st atements. Their report accompanies this statement. Council carries out its responsibility for the consolidated financial statements jointly with its Audit and Finance Committee. The Committee meets with management on a scheduled basis and at least semi -annually with BDO Canada LLP to review their activities and to discuss auditing, internal control, accounting policy, and financial reporting matters. BDO Canada LLP has unrestricted access to the Municipality, the Audit and Finance Committee, and Council. Council approves the consolidated financial statements, the Audit and Finance Committee reviews the recommendations of the independent auditors for improvements to controls and as well as the actions of management to implement such recommendations. Paul Gill, BBA, CPA, CGA Trevor Thompson, BBA, CPA, CGA Chief Administrative Officer Chief Financial Officer Page 8 of 50 City of Maple Ridge - Statement of Financial Information Tel: 604 688 5421 Fax: 604 688 5132 vancouver@bdo.ca www.bdo.ca BDO Canada LLP 600 Cathedral Place 925 West Georgia Street Vancouver BC V6C 3L2 Canada BDO Canada LLP, a Canadian limited liability partnership, is a member of BDO International Limited, a UK company limited by guarantee, and forms part of the international BDO network of independent member firms. INDEPENDENT AUDITOR’S REPORT To the Mayor and Council of the City of Maple Ridge We have audited the accompanying consolidated financial statements of the City of Maple Ridge, which comprise the Consolidated Statement of Financial Position as at December 31, 2017, and the Consolidated Statements of Operations, Change in Net Financial Assets and Cash Flow for the year then ended, and a summary of significant accounting policies and other explanatory information. Management's Responsibility for the Consolidated Financial Statements Management is responsible for the preparation and fair presentation of these consolidated financial statements in accordance with Canadian public sector accounting standards, and for such internal control as management determines is necessary to enable the preparation of consolidated financial statements that are free from material misstatement, whether due to fraud or error. Auditor’s Responsibility Our responsibility is to express an opinion on these consolidated financial statements based on our audit. We conducted our audit in accordance with Canadian generally accepted auditing standards. Those standards require that we comply with ethical requirements and plan and perform the audit to obtain reasonable assurance about whether the consolidated financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the consolidated financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the consolidated financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity's preparation and fair presentation of the consolidated financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal control. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of accounting estimates made by management, as well as evaluating the overall presentation of the consolidated financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinion. Opinion In our opinion, the consolidated financial statements present fairly in all material respects, the financial position of the City of Maple Ridge as at December 31, 2017 and its results of operations, changes in net financial assets and cash flows for the year then ended, in accordance with Canadian public sector accounting standards. Chartered Professional Accountants Vancouver, British Columbia May 8, 2018 Page 9 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Consolidated Statement of Financial PositionConsolidated Statement of Financial PositionConsolidated Statement of Financial PositionConsolidated Statement of Financial Position as at December 31, 2017 2017 2017 2017 2017 2016 Financial AssetsFinancial AssetsFinancial AssetsFinancial Assets Cash and cash equivalents (Note 1)$$$$27,631,87727,631,87727,631,87727,631,877 $19,542,094 Portfolio investments (Note 2)187,717,851187,717,851187,717,851187,717,851 158,579,174 Accounts receivable (Note 3)14,663,43314,663,43314,663,43314,663,433 16,981,661 Recoverable local improvements (Note 4)1,126,2471,126,2471,126,2471,126,247 1,211,936 Other assets (Note 5)763,208763,208763,208763,208 779,296 Inventory available for resale 3,579,0943,579,0943,579,0943,579,094 4,304,688 235,481,710235,481,710235,481,710235,481,710 201,398,849 LiabilitiesLiabilitiesLiabilitiesLiabilities Accounts payable and accrued liabilities (Note 6)20,795,75120,795,75120,795,75120,795,751 18,649,403 Deferred revenue (Note 8)14,198,18214,198,18214,198,18214,198,182 11,238,972 Restricted revenue (Note 9)39,633,65439,633,65439,633,65439,633,654 33,401,914 Refundable performance deposits and other 23,403,71323,403,71323,403,71323,403,713 15,853,204 Employee future benefits (Note 10)4,567,3004,567,3004,567,3004,567,300 4,704,700 Debt (Note 11, Schedule 4)28,273,70728,273,70728,273,70728,273,707 31,204,532 130,872,307130,872,307130,872,307130,872,307 115,052,725 Net Financial AssetsNet Financial AssetsNet Financial AssetsNet Financial Assets 104,609,403104,609,403104,609,403104,609,403 86,346,124 Non Financial AssetsNon Financial AssetsNon Financial AssetsNon Financial Assets Tangible capital assets (Note 12, Schedule 5)976,145,224976,145,224976,145,224976,145,224 960,396,101 Undeveloped land bank properties (Note 13)15,526,52915,526,52915,526,52915,526,529 15,526,529 Supplies inventory 363,885363,885363,885363,885 355,162 Prepaid expenses 1,294,6241,294,6241,294,6241,294,624 1,277,835 993,330,262993,330,262993,330,262993,330,262 977,555,627 Accumulated Surplus Accumulated Surplus Accumulated Surplus Accumulated Surplus (Note 14)$$$$1,097,939,6651,097,939,6651,097,939,6651,097,939,665 $1,063,901,751 Paul Gill, BBA, CPA, CGA Trevor Thompson, BBA, CPA, CGA Chief Administrative Officer Chief Financial Officer The accompanying summary of significant accounting policies and notes to the Consolidated Financial Statements are an integral part of this statement. Page 10 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Consolidated Statement of OperationsConsolidated Statement of OperationsConsolidated Statement of OperationsConsolidated Statement of Operations For the year ended December 31, 2017 Actual Actual Actual Actual Budget Actual 2017 2017 2017 2017 2017 (Note 17) 2016 Revenue Revenue Revenue Revenue (Segment Report, Note 20) Taxes for municipal purposes (Note 15)$$$$81,729,00381,729,00381,729,00381,729,003 $81,624,555 $77,452,203 User fees and other revenue 42,409,36142,409,36142,409,36142,409,361 40,289,865 43,211,346 Government transfers (Note 16)3,434,5313,434,5313,434,5313,434,531 7,232,253 2,775,735 Development revenue 8,155,0078,155,0078,155,0078,155,007 40,056,557 17,893,281 Interest and investment income Investment Income 561,683 Interest Income 2,984,982 Less: Restricted amount (363,771) Interest and investment income 3,182,8943,182,8943,182,8943,182,894 1,898,004 2,478,388 Gaming revenues 1,561,0901,561,0901,561,0901,561,090 1,050,000 1,338,678 Refinancing and asset disposal gains (losses) (807,330)(807,330)(807,330)(807,330)1,500,000 (3,833,337) Contributed tangible capital assets (Note 12)16,725,86316,725,86316,725,86316,725,863 20,000,000 39,062,791 156,390,419156,390,419156,390,419156,390,419 193,651,234 180,379,085 Expenses Expenses Expenses Expenses (Segment Report, Note 20) Protective services 38,065,34038,065,34038,065,34038,065,340 40,620,751 35,844,566 Transportation services 19,511,45819,511,45819,511,45819,511,458 21,090,430 15,835,722 Recreation and cultural 19,784,63219,784,63219,784,63219,784,632 21,236,613 21,584,478 Water utility 13,305,30913,305,30913,305,30913,305,309 14,560,540 12,628,882 Sewer utility 10,761,20310,761,20310,761,20310,761,203 10,964,767 10,068,307 General government 15,106,16715,106,16715,106,16715,106,167 17,876,072 14,821,099 Planning, public health and other 5,818,3965,818,3965,818,3965,818,396 6,616,582 5,518,328 122,352,505122,352,505122,352,505122,352,505 132,965,755 116,301,382 Annual SurplusAnnual SurplusAnnual SurplusAnnual Surplus 34,037,91434,037,91434,037,91434,037,914 60,685,479 64,077,703 Accumulated Surplus beginning of yearAccumulated Surplus beginning of yearAccumulated Surplus beginning of yearAccumulated Surplus beginning of year 1,063,901,7511,063,901,7511,063,901,7511,063,901,751 1,063,901,751 999,824,048 Accumulated Surplus end of year Accumulated Surplus end of year Accumulated Surplus end of year Accumulated Surplus end of year (Note 14)$$$$1,097,939,6651,097,939,6651,097,939,6651,097,939,665 $1,124,587,230 $1,063,901,751 The accompanying summary of significant accounting policies and notes to the Consolidated Financial Statements are an integral part of this statement. Page 11 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ________________________________________________________ Consolidated Statement of Change in Net Financial AssetsConsolidated Statement of Change in Net Financial AssetsConsolidated Statement of Change in Net Financial AssetsConsolidated Statement of Change in Net Financial Assets For the year ended December 31, 2017 Actual Actual Actual Actual Budget Actual 2017 2017 2017 2017 2017 (Note 17) 2016 Annual SurplusAnnual SurplusAnnual SurplusAnnual Surplus $$$$34,037,91434,037,91434,037,91434,037,914 $60,685,479 $64,077,703 Add (Less):Add (Less):Add (Less):Add (Less): Change in Tangible Capital AssetsChange in Tangible Capital AssetsChange in Tangible Capital AssetsChange in Tangible Capital Assets Acquisition of tangible capital assets (38,277,439)(38,277,439)(38,277,439)(38,277,439)(132,222,075)(71,729,097) Amortization 20,585,21620,585,21620,585,21620,585,216 19,780,000 18,209,180 Proceeds from disposal of tangible capital assets 278,424278,424278,424278,424 1,500,000 181,645 (Gain) loss on disposal of tangible capital assets 1,664,6761,664,6761,664,6761,664,676 (1,500,000)3,833,337 (15,749,123)(15,749,123)(15,749,123)(15,749,123)(112,442,075)(49,504,935) Change in Other Non Financial AssetsChange in Other Non Financial AssetsChange in Other Non Financial AssetsChange in Other Non Financial Assets Decrease (increase) in supplies inventory (8,723)(8,723)(8,723)(8,723)4 (4,357) Reclassification of undeveloped land bank 4444 4 53,499 Reclassification of tangible capital assets 4444 4 4 Increase in prepaid expenses (16,789)(16,789)(16,789)(16,789)4 (328,910) (25,512)(25,512)(25,512)(25,512)4 (279,768) Increase (decrease) in Net Financial AssetsIncrease (decrease) in Net Financial AssetsIncrease (decrease) in Net Financial AssetsIncrease (decrease) in Net Financial Assets 18,263,27918,263,27918,263,27918,263,279 $(51,756,596)14,293,000 Net Financial Assets beginning of the yearNet Financial Assets beginning of the yearNet Financial Assets beginning of the yearNet Financial Assets beginning of the year 86,346,12486,346,12486,346,12486,346,124 86,346,121 72,053,124 Net Financial Assets end of the yearNet Financial Assets end of the yearNet Financial Assets end of the yearNet Financial Assets end of the year $$$$104,609,403104,609,403104,609,403104,609,403 $34,589,525 $86,346,124 The accompanying summary of significant accounting policies and notes to the Consolidated Financial Statements are an integral part of this statement Page 12 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ________________________________________________________ Consolidated Statement of Cash FlowConsolidated Statement of Cash FlowConsolidated Statement of Cash FlowConsolidated Statement of Cash Flow For the year ended December 31, 2017 ActualActualActualActual Actual 2017201720172017 2016 Operating transactionsOperating transactionsOperating transactionsOperating transactions Annual surplusAnnual surplusAnnual surplusAnnual surplus $34,037,914$34,037,914$34,037,914$34,037,914 $64,077,703 Items not utilizing cashItems not utilizing cashItems not utilizing cashItems not utilizing cash Amortization 20,585,21620,585,21620,585,21620,585,216 18,209,180 Loss on disposal of assets 807,520807,520807,520807,520 3,833,337 Contributed tangible capital assets (16,725,863)(16,725,863)(16,725,863)(16,725,863)(39,062,791) Restricted revenues recognized (7,606,470)(7,606,470)(7,606,470)(7,606,470)(17,026,027) (2,939,597)(2,939,597)(2,939,597)(2,939,597)(34,046,301) Change in non0cash operating itemsChange in non0cash operating itemsChange in non0cash operating itemsChange in non0cash operating items Increase in prepaid expenses (16,789)(16,789)(16,789)(16,789)(328,909) Decrease (increase) in supplies inventory (8,723)(8,723)(8,723)(8,723)(4,357) Decrease (increase) in accounts receivable 2,318,2282,318,2282,318,2282,318,228 1,941,406 Decrease (increase) in recoverable local improvements 85,68985,68985,68985,689 361,160 Decrease (increase) in other assets 16,08816,08816,08816,088 (21,190) Increase (decrease) in accounts payable and accrued liabilities 2,146,3482,146,3482,146,3482,146,348 730,522 Increase (decrease) in deferred revenue 2,959,2112,959,2112,959,2112,959,211 571,194 Increase (decrease) in refundable performance deposits 7,550,5077,550,5077,550,5077,550,507 2,002,979 Increase (decrease) in employee future benefits (137,401)(137,401)(137,401)(137,401)(203,299) 14,913,15814,913,15814,913,15814,913,158 5,049,506 Cash provided by operating transactions 46,011,47546,011,47546,011,47546,011,475 35,080,908 Capital transactionsCapital transactionsCapital transactionsCapital transactions Proceeds on disposal of assets 1,861,1741,861,1741,861,1741,861,174 181,645 Acquisition of tangible capital assets (21,551,576)(21,551,576)(21,551,576)(21,551,576)(32,666,306) Cash applied to capital transactions (19,690,402)(19,690,402)(19,690,402)(19,690,402)(32,484,661) Investing transactionsInvesting transactionsInvesting transactionsInvesting transactions Decrease (increase) in portfolio investments (29,138,677)(29,138,677)(29,138,677)(29,138,677)916,766 (29,138,677)(29,138,677)(29,138,677)(29,138,677)916,766 Financing transactionsFinancing transactionsFinancing transactionsFinancing transactions Debt repayment (2,930,825)(2,930,825)(2,930,825)(2,930,825)(2,859,107) Collection of restricted revenues 13,838,21213,838,21213,838,21213,838,212 8,741,894 Cash applied to financing transactions 10,907,38710,907,38710,907,38710,907,387 5,882,787 Increase (decrease) in cash and cash equivalentsIncrease (decrease) in cash and cash equivalentsIncrease (decrease) in cash and cash equivalentsIncrease (decrease) in cash and cash equivalents 8,089,7838,089,7838,089,7838,089,783 9,395,800 Cash and cash equivalents 0 beginning of year 19,542,09419,542,09419,542,09419,542,094 10,146,294 Cash and cash equivalents 0 end of yearCash and cash equivalents 0 end of yearCash and cash equivalents 0 end of yearCash and cash equivalents 0 end of year $27,631,877$27,631,877$27,631,877$27,631,877 $19,542,094 Supplementary information:Supplementary information:Supplementary information:Supplementary information: Non0cash transactions: Transfer from tangible capital assets to undeveloped land bank $0 $0 Transfer from tangible capital assets to inventory available for sale $0 $0 The accompanying summary of signficant accounting policies and notes to the Consolidated Financial Statements are an integral part of this statement Page 13 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ___________________________________________________ Summary of Significant Accounting Policies Summary of Significant Accounting Policies Summary of Significant Accounting Policies Summary of Significant Accounting Policies For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017 The City of Maple Ridge (the "City") is a municipality in the province of British Columbia and operates under the provisions of the Community Charter. The City provides municipal services such as fire, public works, planning, parks, recreation and other general government services. (a)(a)(a)(a) Reporting Entity and Basis of ConsolidationReporting Entity and Basis of ConsolidationReporting Entity and Basis of ConsolidationReporting Entity and Basis of Consolidation These financial statements have been prepared in accordance with Canadian Public Sector Accounting Standards (PSAS) using guidelines developed by the Public Sector Accounting Board of the Chartered Professional Accountants of Canada. They consolidate the activities of all of the funds of the City and the City's wholly owned subsidiaries C.D.M.R. Developments Ltd. and Maple Ridge Municipal Holdings Ltd. Transactions between the City's funds and wholly owned subsidiaries have been eliminated and only transactions with outside entities are reported. (b)(b)(b)(b) Basis of AccountingBasis of AccountingBasis of AccountingBasis of Accounting The basis of accounting followed in these financial statements is the accrual method and includes revenues in the period in which the transactions or events occurred that gave rise to the revenues and expenses in the period the goods and services were acquired and a liability was incurred. (c)(c)(c)(c) Non4financial AssetsNon4financial AssetsNon4financial AssetsNon4financial Assets Non4financial assets are not available to discharge existing liabilities and are held for use in the provision of services. They have useful lives extending beyond the current year and are not intended for sale in the ordinary course of business. (d)(d)(d)(d) Tangible Capital AssetsTangible Capital AssetsTangible Capital AssetsTangible Capital Assets Tangible capital assets are a special class of non4financial assets and are recorded at cost less accumulated amortization. Cost includes all costs directly attributable to acquisition or construction of the tangible capital asset including transportation and installation costs, design and engineering fees, legal fees and site preparation costs. Amortization is recorded on a straight line basis over the estimated life of the tangible capital asset commencing once the asset is put into use. Assets under construction are not amortized. Contributed tangible capital assets are recorded at fair value at the time of the contribution and are also recorded as revenue. Estimated useful lives of tangible capital assets are as follows: Buildings (including building components)7 to 50 years Transportation network 10 to 75 years Storm sewer system 10 to 75 years Fleet and equipment 8 to 20 years Technology 3 to 25 years Water system 10 to 85 years Sanitary sewer system 30 to 75 years Furniture and fixtures 3 to 20 years Structures 15 to 75 years Page 14 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ___________________________________________________ Tangible capital assets do not include works of art or historical treasures. Costs related to the acquisition of such items are expensed in the year in which they are acquired. (e)(e)(e)(e) Liability for Contaminated SitesLiability for Contaminated SitesLiability for Contaminated SitesLiability for Contaminated Sites Contaminated sites are a result of contamination being introduced into air, soil, water or sediment of a chemical, organic or radioactive material or live organism that exceeds an environmental standard. Liabilities are recorded net of any expected recoveries. A liability for remediation of a contaminated site is recognized when a site is not in productive use and the following criteria are met: i. an environmental standard exists; ii. contamination exceeds the environmental standards; iii. the City is directly responsible or accepts responsibility; iv. it is expected that future economic benefits will be given up; and v. a reasonable estimate of the amount can be made. The liability is recognized as management's best estimate of the cost of post4remediation including operation, maintenance and monitoring that are an integreal part of the remediation strategy for a contaminated site. Management has assessed its potential liabilities for contamination, including sites that are no longer in productive use and sites for which the City accepts responsibility. There were no such sites that had contamination in excess of an environmental standard requiring remediation at this time, therefore no liability was recognized at December 31, 2017 or December 31, 2016. (f)(f)(f)(f) Revenue RecognitionRevenue RecognitionRevenue RecognitionRevenue Recognition TaxationTaxationTaxationTaxation Taxes are recorded at estimated amounts when they meet the definition of an asset, have been authorized and the taxable event occurs. Annual levies for non4optional municipal services and general administrative services are recorded as taxes for municipal services in the year they are levied. Taxes receivable are recognized net of an allowance for anticipated uncollectable amounts. Levies imposed by other taxing authorities are not included as taxes for municipal purposes. Through the British Columbia Assessments' appeal process, taxes may be adjusted by way of supplementary roll adjustments. The effects of these adjustments on taxes are recognized at the time they are awarded. User fees and other revenueUser fees and other revenueUser fees and other revenueUser fees and other revenue Charges for sewer and water usage are recorded as user fees and other revenue. Government transfersGovernment transfersGovernment transfersGovernment transfers Government transfers are recognized as revenue in the financial statements when the transfer is authorized and any eligibility criteria are met, except to the extent that transfer stipulations give rise to an obligation that meets the definition of a liability. Government transfers are recorded as deferred revenue when transfer stipulations give rise to a liability and are recognized in the statement of operations as the stipulated liabilities are settled. Development revenuesDevelopment revenuesDevelopment revenuesDevelopment revenues Receipts that are restricted by the legislation of senior governments or by agreement with external parties are a liability of the municipality and are reported as Restricted Revenues at Page 15 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ___________________________________________________ the time they are received. When qualifying expenditures are incurred Restricted Revenues are brought into revenue as development revenue. Restricted Revenues are comprised of the amounts shown in Note 9. Investment incomeInvestment incomeInvestment incomeInvestment income Investment income is recorded on the accrual basis and recognized when earned. Investment income is allocated to various reserves and operating funds on a proportionate basis. To the extent that financial instruments have no stated rate of return, investment income is recognized as it is received. Contributed tangible capital assetsContributed tangible capital assetsContributed tangible capital assetsContributed tangible capital assets Subdivision developers are required to provide subdivision infrastructure such as streets, lighting, sidewalks, and drainage etc. Upon completion these assets are turned over to the City. Tangible capital assets received as contributions are recorded at their fair value at the date of receipt and are also recorded as revenue. (g)(g)(g)(g) Use of estimates/measurement uncertaintyUse of estimates/measurement uncertaintyUse of estimates/measurement uncertaintyUse of estimates/measurement uncertainty The preparation of financial statements in accordance with Canadian PSAS requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the reporting period. Significant areas requiring use of management estimates relate to the useful lives of tangible capital assets, determination of employee future benefits, the outcome of litigation and claims, and the percentage of completion of buildings and subdivision inspections. Actual results could differ from those estimates. (h)(h)(h)(h) Budget figuresBudget figuresBudget figuresBudget figures The budget figures reported in the Consolidated Financial Statements represent the 2017 component of the Financial Plan Bylaw adopted by Council on May 9, 2017. (i)(i)(i)(i) Financial instrumentsFinancial instrumentsFinancial instrumentsFinancial instruments The City's financial instruments consist of cash and cash equivalents, portfolio investments, accounts receivable, recoverable local improvements, other assets, accounts payable and accrued liabilities, refundable performance deposits and debt. Unless otherwise indicated, it is management's opinion that the City is not exposed to any significant interest, credit or currency risks arising from these financial instruments. (j)(j)(j)(j) Cash and cash equivalentsCash and cash equivalentsCash and cash equivalentsCash and cash equivalents Cash and cash equivalents are comprised of the amounts held in the City's bank accounts and investments with an original maturity date of three months or less. (k)(k)(k)(k) Portfolio InvestmentsPortfolio InvestmentsPortfolio InvestmentsPortfolio Investments Investments with an original maturity date of more than three month are reported as portfolio investments. Investments and pooled investments are reported using the cost method. Provisions for declines in the market value of investments are recorded when they are considered to be other than temporary. Declines in the market values of investments are considered to be other than temporary when the carrying value exceeds market value for more than three years. Page 16 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ___________________________________________________ (l)(l)(l)(l) Basis of segmentation (Segment Report, Note 20)Basis of segmentation (Segment Report, Note 20)Basis of segmentation (Segment Report, Note 20)Basis of segmentation (Segment Report, Note 20) Municipal services have been segmented by grouping services that have similar service objectives (by function). Revenues that are directly related to the costs of the function have been attributed to each segment. Interest expense is allocated to functions based on the purpose of specific borrowings. (m)(m)(m)(m) Employee future benefitsEmployee future benefitsEmployee future benefitsEmployee future benefits The City and its employees make contributions to the Municipal Pension Plan, and the employees accrue benefits under this plan based on service. The City's contributions are expensed as incurred. (Note 19) Sick leave benefits and retirement severance benefits are also available to the City's employees. The costs of these benefits are actuarially determined based on service and best estimates of retirement ages and expected future salary and wage increases. The liabilities under these benefit plans are accrued based on projected benefits prorated as the employees render services necessary to earn the future benefits. (Note 10) Page 17 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Notes to the Consolidated Financial StatementsNotes to the Consolidated Financial StatementsNotes to the Consolidated Financial StatementsNotes to the Consolidated Financial Statements For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017 1.1.1.1. Cash and cash equivalentsCash and cash equivalentsCash and cash equivalentsCash and cash equivalents Cash and cash equivalents as at December 31, 2017 were comprised as follows: Dec 31, 2017Dec 31, 2017Dec 31, 2017Dec 31, 2017 Dec 31, 2016 Cash $$$$20,631,87720,631,87720,631,87720,631,877 $11,443,946 Cash equivalents 7,000,0007,000,0007,000,0007,000,000 8,098,148 $$$$27,631,87727,631,87727,631,87727,631,877 $19,542,094 Cash equivalents are comprised of BC Credit Union term deposits with effective interest rates of 1.5% - 1.9%1.5% - 1.9%1.5% - 1.9%1.5% - 1.9% (1.5% - 1.6% for 2016). Additionally, the City holds cash and cash equivalents of $3,288,086$3,288,086$3,288,086$3,288,086 ($2,633,511 for 2016) and agreements and interest receivable of $215,934$215,934$215,934$215,934 ($187,345 for 2016) for trusts which are not reported elsewhere in the financial statements. They are held for the following trusts: Balance Dec 31, 2016 Interest Earned Receipts Disbursements Balance Dec 31, 2017 Latecomer Fees $40,544 $-$152,478 $108,187 $$$$84,83584,83584,83584,835 Cemetery Perpetual Care 1,090,511 28,976 61,093 28,976 1,151,6041,151,6041,151,6041,151,604 Greater Vancouver Sewer & Drainage District 535,147 -1,362,049 942,091 955,105955,105955,105955,105 Albion Dyking District 1,154,654 585 262,117 104,880 1,312,4761,312,4761,312,4761,312,476 $2,820,856 $29,561 $1,837,737 $1,184,134 $$$$3,504,0203,504,0203,504,0203,504,020 2.2.2.2. Portfolio InvestmentsPortfolio InvestmentsPortfolio InvestmentsPortfolio Investments Portfolio investments include Canadian bank notes and BC Credit Union term deposits with effective interest rates of 1.65% - 2.91%. A portion of the bank notes held have interest payments linked to the performance of a set of equities or a financial index without stated or certain interest rates. For these investments, income is recognized as it is received; in 2017 returns were positive and ranged to 3.64%. Included in interest earnings are gains on investments sold before maturity. In 2017 gains were $71,498 $71,498 $71,498 $71,498 ($0 for 2016). The City does not hold any asset backed commercial paper or hedge funds. The carrying value of securities is based on the cost method whereby the cost of the security is adjusted to reflect investment income that is accruing and any permanent decline in market value. During the term of individual investments there will be fluctuations in market values. Such fluctuations are considered normal, and if held to maturity, market value will be equal to face value. The carrying value of Portfolio Investments at December 31, 2017 was $187,717,851$187,717,851$187,717,851$187,717,851 ($158,579,174 for 2016). The market value at December 31, 2017 was $187,715,380$187,715,380$187,715,380$187,715,380 ($158,703,643 for 2016). 3.3.3.3. Accounts ReceivableAccounts ReceivableAccounts ReceivableAccounts Receivable 2017201720172017 2016 Property Taxes $$$$4,944,5974,944,5974,944,5974,944,597 $5,025,022 Other Governments 2,450,3822,450,3822,450,3822,450,382 4,197,992 General and Accrued Interest 3,856,2763,856,2763,856,2763,856,276 3,920,849 Development Cost Charges 3,472,9353,472,9353,472,9353,472,935 3,877,516 14,724,19014,724,19014,724,19014,724,190 17,021,379 Less: Allowance for Doubtful Accounts (60,757)(60,757)(60,757)(60,757)(39,718) $$$$14,663,43314,663,43314,663,43314,663,433 $16,981,661 Page 18 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 4. 4. 4. 4. Recoverable Local ImprovementsRecoverable Local ImprovementsRecoverable Local ImprovementsRecoverable Local Improvements The City provides interim financing for certain geographically localized capital projects. It recovers these amounts from benefiting property owners. Interest rates are established at the outset of the process and are a function of borrowing rates at the time. Repayment is typically made over fifteen years. 5.5.5.5. Other AssetsOther AssetsOther AssetsOther Assets Debt Reserve Fund: The Municipal Finance Authority of British Columbia (MFA) provides capital financing for regional districts and their member municipalities. The MFA is required to establish a Debt Reserve Fund. Each regional district, through its member municipalities who share in the proceeds of a debt issue, is required to pay into the Debt Reserve Fund certain amounts set out in the debt agreements. The MFA pays into the Debt Reserve Fund these monies from which interest earned thereon less administrative expenses becomes an obligation to the regional districts. It must then use this fund, if at any time there are insufficient funds, to meet payments on its obligations. If this occurs, the regional districts may be called upon to restore the fund. Upon the maturity of a debt issue the unused portion of the Debt Reserve Fund established for that issue will be discharged to the City. The City has estimated that there is only a remote possibility that these funds will not be paid to it and therefore these funds have been included in Other Assets of $763,208$763,208$763,208$763,208 ($779,296 for 2016). 6.6.6.6. Accounts Payable and Accrued LiabilitiesAccounts Payable and Accrued LiabilitiesAccounts Payable and Accrued LiabilitiesAccounts Payable and Accrued Liabilities 2017201720172017 2016 Accounts Payable:Accounts Payable:Accounts Payable:Accounts Payable: General $$$$5,587,7465,587,7465,587,7465,587,746 $8,334,403 Other Governments 12,197,99412,197,99412,197,99412,197,994 7,341,118 Salaries and Wages 1,701,3081,701,3081,701,3081,701,308 1,659,815 19,487,04819,487,04819,487,04819,487,048 17,335,336 Accrued Liabilities:Accrued Liabilities:Accrued Liabilities:Accrued Liabilities: Vacation Pay 401,134401,134401,134401,134 368,785 Other Vested Benefits 907,569907,569907,569907,569 945,282 1,308,7031,308,7031,308,7031,308,703 1,314,067 $$$$ 20,795,75120,795,75120,795,75120,795,751 $ 18,649,403 7.7.7.7. Contingencies, Commitments and Unrecognized Liabilities:Contingencies, Commitments and Unrecognized Liabilities:Contingencies, Commitments and Unrecognized Liabilities:Contingencies, Commitments and Unrecognized Liabilities: (a)(a)(a)(a) Third Party ClaimsThird Party ClaimsThird Party ClaimsThird Party Claims Where losses related to litigation are possible and can be reasonably estimated management accrues its best estimate of loss. For 2017 this estimate is $171,236$171,236$171,236$171,236 ($522,834 for 2016). These amounts are included in accounts payable and accrued liabilities. There are various other claims by and against the City, the outcome of which cannot reasonably be estimated. Any ultimate settlements will be recorded in the year the settlements occur. (b)(b)(b)(b) Contractual ObligationsContractual ObligationsContractual ObligationsContractual Obligations (i) Water The City has entered into a cost share agreement with the Greater Vancouver Water District for the construction of infrastructure. Under this agreement the City expects to incur costs of approximately $400,000$400,000$400,000$400,000 by the time of project completion. The expense is recorded as the related costs are incurred. (ii) Recreation and Cultural Services In 1998 the City entered into an agreement to purchase ice sheet time for five years commencing in 1999, with three five-year renewal options. In 2013, the agreement was renewed for an additional five- year period. The minimum annual payment due for the provision of ice time is $686,225. These payments are recorded as expenses when the ice time is provided. Page 19 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements (c)(c)(c)(c)Unrecognized LiabilityUnrecognized LiabilityUnrecognized LiabilityUnrecognized Liability The City holds shares in a non-profit organization that provides protective services to its members. Should the organization dissolve or management choose to withdraw from the organization the City would be liable for a proportionate share of any debt the organization held at that time. The liability is expected to be discharged over time through payments by the City and others for the provision of these services by the organization. Due to the ongoing operations of the organization the liability could only be quantified if the City chose to withdraw. Consequently no liability has been recognized in these financial statements. 8.8.8.8. Deferred RevenuesDeferred RevenuesDeferred RevenuesDeferred Revenues Deferred revenues held by the City were comprised as follows: PrepaidPrepaidPrepaidPrepaid TaxesTaxesTaxesTaxes ConnectionConnectionConnectionConnection RevenuesRevenuesRevenuesRevenues 2017201720172017 2016 2017201720172017 2016 Beginning balance $$$$6,437,2066,437,2066,437,2066,437,206 $6,118,372 $$$$724,875724,875724,875724,875 $629,820 Deferred during the year 13,645,93713,645,93713,645,93713,645,937 12,673,842 1,026,6521,026,6521,026,6521,026,652 1,042,486 Revenue recognized (13,218,876)(13,218,876)(13,218,876)(13,218,876)(12,355,008)(716,490)(716,490)(716,490)(716,490)(947,431) Ending balance $$$$6,864,2676,864,2676,864,2676,864,267 $6,437,206 $$$$1,035,0371,035,0371,035,0371,035,037 $724,875 OtherOtherOtherOther TotalTotalTotalTotal Deferred RevenuesDeferred RevenuesDeferred RevenuesDeferred Revenues 2017201720172017 2016 2017201720172017 2016 Beginning balance $$$$4,076,8914,076,8914,076,8914,076,891 $3,919,585 $$$$11,238,97211,238,97211,238,97211,238,972 $10,667,777 Deferred during the year 4,068,9024,068,9024,068,9024,068,902 2,262,634 18,741,49118,741,49118,741,49118,741,491 15,978,962 Revenue recognized (1,846,915)(1,846,915)(1,846,915)(1,846,915)(2,105,328)(15,782,281)(15,782,281)(15,782,281)(15,782,281)(15,407,767) Ending balance $$$$6,298,8786,298,8786,298,8786,298,878 $4,076,891 $$$$14,198,18214,198,18214,198,18214,198,182 $11,238,972 9.9.9.9. Restricted RevenuesRestricted RevenuesRestricted RevenuesRestricted Revenues Restricted revenues held by the City were comprised as follows: DevelopmentDevelopmentDevelopmentDevelopment Cost ChargesCost ChargesCost ChargesCost Charges ParklandParklandParklandParkland Acquisition ChargesAcquisition ChargesAcquisition ChargesAcquisition Charges 2017201720172017 2016 2017201720172017 2016 Beginning Balance $$$$26,019,02826,019,02826,019,02826,019,028 $33,971,866 $$$$412,027412,027412,027412,027 $1,203,400 Collections and interest 10,988,85910,988,85910,988,85910,988,859 7,923,252 779,225779,225779,225779,225 209,463 Disbursements - operating (118,685)(118,685)(118,685)(118,685)(406,180)----- Disbursements - capital (7,342,530)(7,342,530)(7,342,530)(7,342,530)(15,469,910)(27,301)(27,301)(27,301)(27,301)(1,000,834) Ending Balance $$$$ 29,546,67229,546,67229,546,67229,546,672 $ 26,019,028 $$$$ 1,163,9511,163,9511,163,9511,163,951 $ 412,029 OtherOtherOtherOther Restricted RevenuesRestricted RevenuesRestricted RevenuesRestricted Revenues TotalTotalTotalTotal Restricted RevenuesRestricted RevenuesRestricted RevenuesRestricted Revenues 2017201720172017 2016 2017201720172017 2016 Beginning Balance $$$$6,970,8576,970,8576,970,8576,970,857 $6,510,781 $$$$33,401,91233,401,91233,401,91233,401,912 $41,686,047 Collections and interest 2,070,1282,070,1282,070,1282,070,128 609,179 13,838,21213,838,21213,838,21213,838,212 8,741,894 Disbursements - operating (54,574)(54,574)(54,574)(54,574)(42,268)(173,259)(173,259)(173,259)(173,259)(448,448) Disbursements - capital (63,380)(63,380)(63,380)(63,380)(106,835)(7,433,211)(7,433,211)(7,433,211)(7,433,211)(16,577,579) Ending Balance $$$$ 8,923,0318,923,0318,923,0318,923,031 $ 6,970,857 $$$$ 39,633,65439,633,65439,633,65439,633,654 $ 33,401,914 Page 20 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 10.10.10.10. Employee Future BenefitsEmployee Future BenefitsEmployee Future BenefitsEmployee Future Benefits The City provides employee future benefits in the form of severance benefits and vested and non-vested sick leave to qualifying employees. These benefits are not separately funded. Severance benefits are cash settlements paid to employees who cease their employment with the City after a specified period of time. Employees hired before February 11, 1999 qualify for five days pay per year of employment, provided they either work a minimum of 20 years with the City or retire as defined by the Public Sector Pension Plan Act. Full time employees hired after February 11, 1999 qualify for 20 days pay provided they work a minimum of 10 years with the City and retire as defined by the Public Sector Pension Plan Act. The City permits regular employees to accumulate up to 18 days per year of service for future illnesses up to a maximum of 250 days. For certain qualifying employees a portion of this benefit vests; for the balance, this benefit does not vest and cannot be converted to any other type of benefit. An actuarial valuation of these benefits was performed to determine the City's liability and accrued benefit obligation as at December 31, 2015 and updated for December 31, 2017. The valuation resulted in an unamortized actuarial loss of $364,900 $364,900 $364,900 $364,900 ($398,200 for 2016) at December 31, 2017. Actuarial gains or losses are amortized over the expected average remaining service life of employees. The benefit liability at December 31, 2017 was $4,567,300$4,567,300$4,567,300$4,567,300 , ($4,704,700 for 2016) comprised as follows: 2017201720172017 2016 Benefit Liability - Beginning of the year $$$$4,704,7004,704,7004,704,7004,704,700 $4,908,000 Add:Current service costs 343,800343,800343,800343,800 374,500 Interest on accrued benefit obligation 148,300148,300148,300148,300 150,200 Less:Amortization of actuarial loss (gain) 33,30033,30033,30033,300 35,600 Benefits paid during the year (662,800)(662,800)(662,800)(662,800)(763,600) Benefit Liability - End of the year 4,567,3004,567,3004,567,3004,567,300 4,704,700 Add (Less):Unamortized actuarial loss 364,900364,900364,900364,900 398,200 Accrued benefit obligation - End of the year 4,932,2004,932,2004,932,2004,932,200 5,102,900 Actuarial assumptions used to determine the City's accrued benefit obligation are as follows: 2017 2017 2017 2017 2016 Discount rate (long-term borrowing rate)2.90 %2.90 %2.90 %2.90 %2.90 % Expected future inflation rate 2.00 %2.00 %2.00 %2.00 %2.00 % Merit and inflationary wage and salary increases averaging 3.04 %3.04 %3.04 %3.04 %3.04 % Estimated average remaining service life of employees (years)13.013.013.013.0 13.0 Page 21 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 11.11.11.11.Debt (Schedule 4)Debt (Schedule 4)Debt (Schedule 4)Debt (Schedule 4) The City obtains debt instruments through the Municipal Finance Authority (MFA), pursuant to security issuing bylaws under authority of the Community Charter, to finance certain capital expenditures. Debt is reported net of Sinking Fund balances and interest expense is reported net of Sinking Fund earnings. The City carries no debt for others. The following debenture debt amounts plus related interest are payable over the next five years and thereafter: Debt Payments 2018 $2,129,744 2019 2,172,036 2020 2,215,521 2021 2,260,235 2022 2,306,211 Thereafter 12,253,117 Sinking Fund Contributions 4,936,843 Debt principal repayments $28,273,707 The City has the following authorized but un-issued long term debt as at December 31, 2017 : L/A Bylaw L/A Amount #6558 $6,000,000 #6560 275,000 #6679 1,100,000 $7,375,000 12. Tangible Capital Assets12. Tangible Capital Assets12. Tangible Capital Assets12. Tangible Capital Assets Net book valueNet book valueNet book valueNet book value 2017201720172017 2016 Land $$$$226,003,706226,003,706226,003,706226,003,706 $215,898,649 Buildings 44,141,16644,141,16644,141,16644,141,166 45,632,627 Transportation network 218,934,481218,934,481218,934,481218,934,481 223,230,279 Storm sewer system 206,751,562206,751,562206,751,562206,751,562 201,919,428 Fleet and equipment 14,680,21414,680,21414,680,21414,680,214 13,625,491 Technology 4,516,4664,516,4664,516,4664,516,466 4,751,490 Water system 116,201,245116,201,245116,201,245116,201,245 113,622,225 Sanitary sewer system 128,186,305128,186,305128,186,305128,186,305 126,551,687 Other 16,730,08116,730,08116,730,08116,730,081 15,164,227 $$$$976,145,224976,145,224976,145,224976,145,224 $960,396,101 For additional information, see the Schedule of Tangible Capital Assets (Schedule 5) During the year there were no write-downs of assets (2016 - $Nil) and no interest was capitalized (2016 - $Nil). In addition, roads and related infrastructure, underground networks and land contributed to the City totaled $16,725,863$16,725,863$16,725,863$16,725,863 ($39,062,791 for 2016) and were capitalized at their fair value at the time of receipt. Works of art, artifacts, cultural and historic assets are not recorded as assets in the financial statements. The City controls various works of art and historical treasures including artifacts, paintings, sculptures and mosaics located at City sites and public display areas. Page 22 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 13. Undeveloped Land Bank13. Undeveloped Land Bank13. Undeveloped Land Bank13. Undeveloped Land Bank The City owns property in various areas identified for future growth in the Official Community Plan. These properties are not currently used in the provision of service to the citizens of Maple Ridge. The properties represent a strategic, non-renewable resource available for the advancement of Council's strategic plan. 14. Accumulated Surplus14. Accumulated Surplus14. Accumulated Surplus14. Accumulated Surplus Accumulated Surplus is comprised of operating surpluses and equity in tangible capital assets held in the general, sewer and water funds as well as reserves. Accumulated surplus for 2017 is $1,097,939,665 $1,097,939,665 $1,097,939,665 $1,097,939,665 ($1,063,091,751 for 2016) and is distributed as follows: 2017201720172017 2016 Operating surplus (Schedule 1)General $$$$10,011,88210,011,88210,011,88210,011,882 $9,285,688 Sewer 8,935,8628,935,8628,935,8628,935,862 8,144,538 Water 12,840,03412,840,03412,840,03412,840,034 11,296,039 31,787,77831,787,77831,787,77831,787,778 28,726,265 Equity in the capital funds (Schedule 2)General 721,401,366721,401,366721,401,366721,401,366 709,048,629 Sewer 129,423,192129,423,192129,423,192129,423,192 127,032,307 Water 117,671,736117,671,736117,671,736117,671,736 114,453,816 968,496,294968,496,294968,496,294968,496,294 950,534,752 Reserves (Schedule 3)Funds 41,639,40341,639,40341,639,40341,639,403 38,755,844 Accounts 56,016,19056,016,19056,016,19056,016,190 45,884,890 97,655,59397,655,59397,655,59397,655,593 84,640,734 Accumulated Surplus $$$$1,097,939,6651,097,939,6651,097,939,6651,097,939,665 $1,063,901,751 15. 15. 15. 15. Property Tax LeviesProperty Tax LeviesProperty Tax LeviesProperty Tax Levies In addition to its own tax levies, the City is required to levy taxes on behalf of various other taxing authorities. These include the provincial government for local school taxes, incorporated dyking districts located within the City and, organizations providing regional services in which the City has become a member. Taxes levied for other agencies are not included in City revenues. Total tax levies were comprised as follows: 2017201720172017 2017 Budget 2016 Municipal Tax LeviesMunicipal Tax LeviesMunicipal Tax LeviesMunicipal Tax Levies $$$$81,729,00381,729,00381,729,00381,729,003 $81,624,555 $77,452,203 Levies for other authoritiesLevies for other authoritiesLevies for other authoritiesLevies for other authorities School taxes 34,552,10434,552,10434,552,10434,552,104 33,447,351 32,805,061 Greater Vancouver Transit Authority 5,622,7115,622,7115,622,7115,622,711 5,538,987 5,397,878 British Columbia Assessment 995,188995,188995,188995,188 949,329 925,179 Greater Vancouver Regional District 958,555958,555958,555958,555 915,066 892,390 Dyking Districts 616,936616,936616,936616,936 523,716 558,943 Municipal Finance Authority 4,3284,3284,3284,328 3,358 3,272 Total Collections for OthersTotal Collections for OthersTotal Collections for OthersTotal Collections for Others 42,749,82242,749,82242,749,82242,749,822 41,377,807 40,582,723 Total Tax LeviesTotal Tax LeviesTotal Tax LeviesTotal Tax Levies $$$$ 124,478,825124,478,825124,478,825124,478,825 $ 123,002,362 $ 118,034,926 Page 23 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 16.16.16.16.Government TransfersGovernment TransfersGovernment TransfersGovernment Transfers Government transfers received during the year were comprised of the following: 2017201720172017 2016 CapitalCapitalCapitalCapital OperatingOperatingOperatingOperating Capital Operating Federal Gov't $$$$136,508136,508136,508136,508 $$$$353,137353,137353,137353,137 $5,141 $289,215 Provincial Gov't 186,465186,465186,465186,465 1,293,9031,293,9031,293,9031,293,903 233,219 1,167,396 TransLink 116,794116,794116,794116,794 1,092,9101,092,9101,092,9101,092,910 371,777 497,800 Other 176,932176,932176,932176,932 77,88277,88277,88277,882 160,802 50,385 Total $$$$616,699616,699616,699616,699 $$$$2,817,8322,817,8322,817,8322,817,832 $770,939 $2,004,796 17. Budget17. Budget17. Budget17. Budget Budget amounts represent the Financial Plan Bylaw adopted by Council on May 9, 2017. The Financial Plan anticipated use of surpluses accumulated in previous years to balance against current year expenditures in excess of current year revenues. The following shows how these amounts were combined: Financial Plan Financial Plan Financial Plan Financial Plan Bylaw Bylaw Bylaw Bylaw Financial Statement Financial Statement Financial Statement Financial Statement Budget Budget Budget Budget RevenueRevenueRevenueRevenue Taxation $81,624,555 $81,624,555 User fees and other revenue 40,289,865 40,289,865 Other 51,736,814 51,736,814 Contributed subdivision infrastructure 20,000,000 20,000,000 Total RevenueTotal RevenueTotal RevenueTotal Revenue 193,651,234 193,651,234 ExpensesExpensesExpensesExpenses Protective services 40,620,751 40,620,751 Transportation services 21,090,430 21,090,430 Recreation and cultural 21,236,613 21,236,613 Water utility 14,560,540 14,560,540 Sewer utility 10,964,767 10,964,767 General Government 17,876,072 17,876,072 Planning, public health and other 6,616,582 6,616,582 Total expensesTotal expensesTotal expensesTotal expenses 132,965,755 132,965,755 Annual SurplusAnnual SurplusAnnual SurplusAnnual Surplus $$$$60,685,47960,685,47960,685,47960,685,479 $$$$60,685,47960,685,47960,685,47960,685,479 Less: Capital expenditures 132,222,075 Debt repayment 3,703,615 Add: Interfund transfers 42,414,113 Amortization 19,780,000 Borrowing proceeds 13,046,098 $- Page 24 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 18. Expenditures and Expenses by Object18. Expenditures and Expenses by Object18. Expenditures and Expenses by Object18. Expenditures and Expenses by Object Operations Capital Acquisitions 2017 Total 2017 Budget 2016 Total Goods and services $57,540,668 $20,669,161 $78,209,829 $179,304,581 $85,967,417 Wages and salaries 42,506,084 882,415 43,388,499 44,097,000 42,941,796 Interest 1,720,537 -1,720,537 2,006,249 1,849,295 Total Expenditures 101,767,289 21,551,576 123,318,865 225,407,830 130,758,508 Amortization expenses 20,585,216 -20,585,216 19,780,000 18,209,180 Contributed tangible capital assets -16,725,863 16,725,863 20,000,000 39,062,791 Total Expenditures and Expenses $122,352,505 $38,277,439 $160,629,944 $265,187,830 $188,030,479 19.19.19.19. Pension PlanPension PlanPension PlanPension Plan The employer and its employees contribute to the Municipal Pension Plan (a jointly trusteed pension plan). The board of trustees, representing plan members and employers, is responsible for administering the plan, including investment of assets and administration of benefits. The plan is a multi-employer defined benefit pension plan. Basic pension benefits are based on a formula. As at December 31. 2016, the plan has about 193,000 active members and approximately 90,000 retired members. Active members include approximately 38,000 contributors from local governments. Every three years, an actuarial valuation is performed to assess the financial position of the plan and adequacy of plan funding. The actuary determines an appropriate combined employer and member contribution rate to fund the plan. The actuary's calculated contribution rate is based on the entry-age normal cost method, which produces the long-term rate of member and employer contributions sufficient to provide benefits for average future entrants to the plan. This rate may be adjusted for the amortization of any actuarial funding surplus and will be adjusted for the amortization of any unfunded actuarial liability. The most recent valuation for the Municipal Pension Plan as of December 31, 2015, indicated a $2,224 million funding surplus for basic pension benefits on a going concern basis. As a result of the 2015 basic account actuarial valuation surplus and pursuant to the joint trustee agreement, $1.927 million was transferred to the rate stabilization account and $297 million of the surplus ensured the required contribution rates remained unchanged. The City of Maple Ridge paid $3,436,295$3,436,295$3,436,295$3,436,295 (2016 $3,440,174) for employer contributions while employees contributed $2,817,284$2,817,284$2,817,284$2,817,284 (2016 $2,778,065) to the plan in fiscal 2017. The next valuation will be as at December 31, 2018, with results available in 2019. Employers participating in the plan record their pension expense as the amount of employer contributions made during the fiscal year (defined contribution plan accounting). This is because the plan records accrued liabilities and accrued assets for the plan in aggregate, resulting in no consistent and reliable basis for allocating the obligation, assets and cost to individual employers participating in the plan. Page 25 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements 20. Segmented Information20. Segmented Information20. Segmented Information20. Segmented Information The City is a diversified municipal government entity in the province of British Columbia that provides a wide range of services to its citizens. Municipal services have been segmented by grouping activities that have similar service objectives (by function) and separately disclosed in the segment report. Where certain activities cannot be attributed to a specific segment they have been reported as unallocated. The segments and the services they provide are as follows: Protective ServicesProtective ServicesProtective ServicesProtective Services Protective Services is comprised of the Ridge Meadows RCMP detachment, the Maple Ridge Fire Department, bylaw enforcement, inspection services and emergency services. Services provided by the segment are focused on protecting the citizens of Maple Ridge. Transportation ServicesTransportation ServicesTransportation ServicesTransportation Services Transportation Services is comprised of Engineering, Operations, Drainage and Roads. Services provided by the segment include the construction and maintenance of transportation related infrastructure. Recreation and CulturalRecreation and CulturalRecreation and CulturalRecreation and Cultural Recreation and cultural services provides library services, access to recreation facilities and maintains and operates City parks. Water UtilityWater UtilityWater UtilityWater Utility The Water Utility, in conjunction with Metro Vancouver, provides safe, clean, reliable water to the residents and businesses of the City of Maple Ridge. Sewer UtilitySewer UtilitySewer UtilitySewer Utility The Sewer Utility collects waste water and transports it to treatment plants operated by Metro Vancouver in addition to maintaining the sanitary sewer infrastructure. General GovernmentGeneral GovernmentGeneral GovernmentGeneral Government General Government provides administrative, legislative and support services for the City. Functions include financial planning and reporting, information technology, economic development and communications. Planning, Public Health and OtherPlanning, Public Health and OtherPlanning, Public Health and OtherPlanning, Public Health and Other This segment is comprised of Planning, Recycling, Cemetery and Social Planning. Activities include land use guidelines, development of the City's official community plan, management of the recycling contract and improving the social well-being of the community. UnallocatedUnallocatedUnallocatedUnallocated Unallocated includes revenues and expenses that cannot be directly attributed to the activities of an identified functional segment. Page 26 of 50 City of Maple Ridge - Statement of Financial Information Intentional Blank Page 27 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Segment ReportSegment ReportSegment ReportSegment Report Consolidated Report of Segmented Revenue and ExpensesConsolidated Report of Segmented Revenue and ExpensesConsolidated Report of Segmented Revenue and ExpensesConsolidated Report of Segmented Revenue and Expenses For the year ended December 31, 2017 Protective Protective Protective Protective ServicesServicesServicesServices TransportationTransportationTransportationTransportation ServicesServicesServicesServices Recreation Recreation Recreation Recreation and Culturaland Culturaland Culturaland Cultural Water UtilityWater UtilityWater UtilityWater Utility Sewer UtilitySewer UtilitySewer UtilitySewer Utility RevenueRevenueRevenueRevenue Tax revenue $)$)$)$130,677 $905,380 Other revenues 5,735,485 758,536 3,363,415 16,589,309 9,868,103 Government transfers 105,727 1,582,340 583,119 )129,778 Development revenue 10,837 2,055,404 2,039,808 2,251,480 1,530,704 Interest and investment income )))))))) Gaming Revenues Refinancing & asset disposal gain(loss)22,617 (1,176,533)(37,975)(176,025)(245,604) Contributed infrastructure )10,484,830 3,060,831 1,246,034 1,893,166 Total RevenueTotal RevenueTotal RevenueTotal Revenue 5,874,666 13,704,577 9,009,198 20,041,475 14,081,527 ExpensesExpensesExpensesExpenses Operating: Goods and services 21,323,878 3,208,702 8,602,356 9,727,741 7,683,698 Labour 15,393,349 5,857,899 8,060,999 1,465,461 570,559 Debt Servicing 12,471 (22,198)863,578 )) Sub total 36,729,698 9,044,403 17,526,933 11,193,202 8,254,257 Amortization 1,335,642 10,467,055 2,257,699 2,112,107 2,506,946 Total ExpensesTotal ExpensesTotal ExpensesTotal Expenses 38,065,340 19,511,458 19,784,632 13,305,309 10,761,203 Excess (deficiency) of revenue overExcess (deficiency) of revenue overExcess (deficiency) of revenue overExcess (deficiency) of revenue over expensesexpensesexpensesexpenses $(32,190,674)$(5,806,881)$(10,775,434)$6,736,166 $3,320,324 Page 28 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements GeneralGeneralGeneralGeneral GovernmentGovernmentGovernmentGovernment CommercialCommercialCommercialCommercial TowerTowerTowerTower PlanningPlanningPlanningPlanning Public HealthPublic HealthPublic HealthPublic Health & Other& Other& Other& Other UnallocatedUnallocatedUnallocatedUnallocated Total Total Total Total 2017 Actual2017 Actual2017 Actual2017 Actual Total BudgetTotal BudgetTotal BudgetTotal Budget Total 2016 Actual $)$)$2,012,967 $78,679,979 $$$$81,729,00381,729,00381,729,00381,729,003 $81,624,555 $77,452,203 1,694,500 1,554,662 2,845,351 ))))42,409,36142,409,36142,409,36142,409,361 40,289,865 43,211,346 970,939 )62,628 ))))3,434,5313,434,5313,434,5313,434,531 7,232,253 2,775,735 251,524 )15,250 ))))8,155,0078,155,0078,155,0078,155,007 40,056,557 17,893,281 )))3,182,894 3,182,8943,182,8943,182,8943,182,894 1,898,004 2,478,388 1,561,090 1,561,0901,561,0901,561,0901,561,090 1,050,000 1,338,678 812,583 )(6,583)190 (807,330)(807,330)(807,330)(807,330)1,500,000 (3,833,337) 41,002 ))))))16,725,86316,725,86316,725,86316,725,863 20,000,000 39,062,791 3,770,548 1,554,662 4,929,613 83,424,153 156,390,419156,390,419156,390,419156,390,419 193,651,234 180,379,085 3,640,736 510,892 2,842,665 )57,540,66857,540,66857,540,66857,540,668 67,082,506 54,224,117 8,459,391 )2,698,426 )42,506,08442,506,08442,506,08442,506,084 44,097,000 42,018,791 267,951 544,011 54,724 )1,720,5371,720,5371,720,5371,720,537 2,006,249 1,849,294 12,368,078 1,054,903 5,595,815 )101,767,289101,767,289101,767,289101,767,289 113,185,755 98,092,202 1,683,186 )222,581 )20,585,21620,585,21620,585,21620,585,216 19,780,000 18,209,180 14,051,264 1,054,903 5,818,396 )122,352,505122,352,505122,352,505122,352,505 132,965,755 116,301,382 $(10,280,716)$499,759 $(888,783)$83,424,153 $$$$34,037,91434,037,91434,037,91434,037,914 $60,685,479 $64,077,703 Page 29 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Schedule 1Schedule 1Schedule 1Schedule 1 Schedule of Change in Operating Accumulated SurplusSchedule of Change in Operating Accumulated SurplusSchedule of Change in Operating Accumulated SurplusSchedule of Change in Operating Accumulated Surplus For the year ended December 31, 2017 Actual Actual Actual Actual 2017 2017 2017 2017 Budget 2017 Actual 2016 RevenueRevenueRevenueRevenue Taxes for municipal purposes $$$$81,729,00381,729,00381,729,00381,729,003 $81,624,555 $77,452,203 User fees and other revenues 42,409,36142,409,36142,409,36142,409,361 40,289,865 43,211,346 Government transfers 2,817,8322,817,8322,817,8322,817,832 2,792,386 2,004,796 Development Revenue 612,917612,917612,917612,917 (4,811,393)1,003,410 Interest and investment income 2,334,2272,334,2272,334,2272,334,227 1,323,004 1,717,684 Gaming revenues 1,561,0901,561,0901,561,0901,561,090 1,050,000 1,338,678 Refinancing and other gains 1,861,3631,861,3631,861,3631,861,363 1,500,000 181,645 133,325,793133,325,793133,325,793133,325,793 123,768,417 126,909,762 ExpensesExpensesExpensesExpenses Protective services 36,729,69836,729,69836,729,69836,729,698 39,270,751 34,523,641 Transportation services 9,044,4039,044,4039,044,4039,044,403 11,130,430 8,362,432 Recreation and cultural 17,526,93317,526,93317,526,93317,526,933 19,026,613 18,630,397 Water utilities 11,193,20211,193,20211,193,20211,193,202 12,540,540 10,453,276 Sewer utilities 8,254,2578,254,2578,254,2578,254,257 8,574,767 7,626,314 General government 13,422,98113,422,98113,422,98113,422,981 16,286,072 13,225,196 Public and environmental health 5,595,8155,595,8155,595,8155,595,815 6,356,582 5,270,947 101,767,289101,767,289101,767,289101,767,289 113,185,755 98,092,203 Annual SurplusAnnual SurplusAnnual SurplusAnnual Surplus 31,558,50431,558,50431,558,50431,558,504 10,582,662 28,817,559 Internal transfersInternal transfersInternal transfersInternal transfers Transfers to capital funds (6,317,213)(6,317,213)(6,317,213)(6,317,213)(12,722,488)(7,851,339) Transfers to reserves (22,179,779)(22,179,779)(22,179,779)(22,179,779)(2,924,522)(16,867,657) Increase (decrease) in operating accumulated surplus 3,061,5133,061,5133,061,5133,061,513 (5,064,348)4,098,563 Operating accumulated surplusbeginning of yearOperating accumulated surplusbeginning of yearOperating accumulated surplusbeginning of yearOperating accumulated surplusbeginning of year 28,726,26528,726,26528,726,26528,726,265 28,726,265 24,627,702 Operating accumulated surplusend of year Operating accumulated surplusend of year Operating accumulated surplusend of year Operating accumulated surplusend of year (Note 14)$$$$31,787,77831,787,77831,787,77831,787,778 $23,661,917 $28,726,265 Page 30 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Schedule 2Schedule 2Schedule 2Schedule 2 Schedule of Change in Capital Funds Schedule of Change in Capital Funds Schedule of Change in Capital Funds Schedule of Change in Capital Funds For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017For the year ended December 31, 2017 ActualActualActualActual Budget Actual 2017 2017 2017 2017 2017 2016 RevenueRevenueRevenueRevenue Subdivision infrastructure contributions $$$$16,725,86316,725,86316,725,86316,725,863 $20,000,000 $39,062,791 Government transfers 616,699616,699616,699616,699 4,439,867 770,939 Development fees 7,412,3717,412,3717,412,3717,412,371 42,789,766 16,470,744 Other capital contributions 129,719129,719129,719129,719 2,078,184 419,127 Disposal of tangible capital assets (2,668,693)(2,668,693)(2,668,693)(2,668,693)-(4,014,982) Total Revenue 22,215,95922,215,95922,215,95922,215,959 69,307,817 52,708,619 ExpensesExpensesExpensesExpenses Amortization 20,585,21620,585,21620,585,21620,585,216 19,780,000 18,209,180 Total Expenses 20,585,21620,585,21620,585,21620,585,216 19,780,000 18,209,180 Annual SurplusAnnual SurplusAnnual SurplusAnnual Surplus 1,630,7431,630,7431,630,7431,630,743 49,527,817 34,499,439 Internal Transfers Internal Transfers Internal Transfers Internal Transfers Transfers and principal payments from revenue funds 6,317,2136,317,2136,317,2136,317,213 12,722,488 7,851,339 Transfers from reserves 10,013,58710,013,58710,013,58710,013,587 46,849,285 10,019,157 Increase in capital fundsIncrease in capital fundsIncrease in capital fundsIncrease in capital funds 17,961,54317,961,54317,961,54317,961,543 109,099,590 52,369,935 Capital funds 2 beginning of the yearCapital funds 2 beginning of the yearCapital funds 2 beginning of the yearCapital funds 2 beginning of the year 950,534,751950,534,751950,534,751950,534,751 950,534,751 898,164,816 Capital funds 2 end of the year Capital funds 2 end of the year Capital funds 2 end of the year Capital funds 2 end of the year (Note 14)$$$$968,496,294968,496,294968,496,294968,496,294 $1,059,634,341 $950,534,751 Page 31 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Schedule 3Schedule 3Schedule 3Schedule 3 Schedule of Change in ReservesSchedule of Change in ReservesSchedule of Change in ReservesSchedule of Change in Reserves For the year ended December 31, 2017 ActualActualActualActual 2017 2017 2017 2017 Budget 2017 Actual 2016 Revenue and TransfersRevenue and TransfersRevenue and TransfersRevenue and Transfers Revenue Interest and investment income $$$$848,667848,667848,667848,667 $575,000 $760,704 Add (less) Internal transfers Transfers from revenue funds 22,179,77922,179,77922,179,77922,179,779 2,924,522 16,867,657 Transfers to capital funds (10,013,587)(10,013,587)(10,013,587)(10,013,587)(46,849,285)(10,019,157) Increase (decrease) in Reserved Accumulated SurplusIncrease (decrease) in Reserved Accumulated SurplusIncrease (decrease) in Reserved Accumulated SurplusIncrease (decrease) in Reserved Accumulated Surplus 13,014,85913,014,85913,014,85913,014,859 (43,349,763)7,609,204 Reserved Accumulated Surplus Beginning of the YearReserved Accumulated Surplus Beginning of the YearReserved Accumulated Surplus Beginning of the YearReserved Accumulated Surplus Beginning of the Year 84,640,73484,640,73484,640,73484,640,734 84,640,734 77,031,531 Reserved Accumulated Surplus End of YearReserved Accumulated Surplus End of YearReserved Accumulated Surplus End of YearReserved Accumulated Surplus End of Year (Note 14)$$$$97,655,59397,655,59397,655,59397,655,593 $41,290,971 $84,640,734 Page 32 of 50 City of Maple Ridge - Statement of Financial Information Intentional Blank Page 33 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Schedule 4Schedule 4Schedule 4Schedule 4 Continuity Schedule of Debenture DebtContinuity Schedule of Debenture DebtContinuity Schedule of Debenture DebtContinuity Schedule of Debenture Debt For the Year Ended December 31, 2017 Date ofDate ofDate ofDate of Issue/MaturityIssue/MaturityIssue/MaturityIssue/Maturity Bylaw/MFABylaw/MFABylaw/MFABylaw/MFA Function/PurposeFunction/PurposeFunction/PurposeFunction/Purpose Interest Interest Interest Interest RateRateRateRate Long Term DebtsLong Term DebtsLong Term DebtsLong Term Debts Apr 2005/2027 6246/93 Recreation/Downtown Civic Properties %%%%5.75.75.75.7 Apr 2005/2027 6246/93 General Government/Downtown Office Complex %%%%5.75.75.75.7 Dec 2006/2026 6246/99 General Government/Downtown Office Complex %%%%5.05.05.05.0 Oct 2012/2017 6562/121 General Government/River Road Drainage %%%%2.12.12.12.1 Oct 2012/2027 6560/121 Protective Services/Animal Shelter %%%%2.92.92.92.9 Oct 2012/2037 6559/121 Public Health/Cemetery Expansion %%%%2.92.92.92.9 Oct 2012/2037 6679/121 Public Health/Cemetery Expansion %%%%2.92.92.92.9 Subtotal LESS:LESS:LESS:LESS: Sinking FundsSinking FundsSinking FundsSinking Funds Dec 2006/2026 6246/99 General Government/Downtown Office Complex %%%%5.05.05.05.0 Oct 2012/2017 6562/121 General Government/River Road Drainage %%%%2.12.12.12.1 Oct 2012/2027 6560/121 Protective Services/Animal Shelter %%%%2.92.92.92.9 Oct 2012/2037 6559/121 Public Health/Cemetery Expansion %%%%2.92.92.92.9 Oct 2012/2037 6679/121 Public Health/Cemetery Expansion %%%%2.92.92.92.9 Subtotal Net AmountNet AmountNet AmountNet Amount Page 34 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Dec 31, 2016Dec 31, 2016Dec 31, 2016Dec 31, 2016 BalanceBalanceBalanceBalance OutstandingOutstandingOutstandingOutstanding New Debt IssuedNew Debt IssuedNew Debt IssuedNew Debt Issued During the yearDuring the yearDuring the yearDuring the year Principal/Principal/Principal/Principal/ Sinking FundSinking FundSinking FundSinking Fund PaymentsPaymentsPaymentsPayments Sinking FundSinking FundSinking FundSinking Fund EarningsEarningsEarningsEarnings 2017201720172017 BalanceBalanceBalanceBalance OutstandingOutstandingOutstandingOutstanding Interest Paid/Interest Paid/Interest Paid/Interest Paid/ EarnedEarnedEarnedEarned For The YearFor The YearFor The YearFor The Year $16,237,127 $:$1,279,312 $:$14,957,815 $863,578 2,251,745 :177,400 :2,074,345 119,751 16,300,000 :::16,300,000 813,370 2,675,000 :::2,675,000 41,466 625,000 :::625,000 18,125 1,520,000 :::1,520,000 44,080 700,000 :::700,000 20,300 40,308,872 :1,456,712 :38,852,160 1,920,670 6,624,512 :547,383 269,359 7,441,254 269,359 2,117,458 :493,878 63,664 2,675,000 63,664 133,824 :31,213 5,654 170,691 5,654 156,482 :36,498 6,611 199,591 6,611 72,064 :16,808 3,045 91,917 3,045 9,104,340 :1,125,780 348,333 10,578,453 348,333 $ 31,204,532 $ :$ 2,582,492 $ 348,333 $ 28,273,707 $ 1,572,337 Page 35 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Schedule 5Schedule 5Schedule 5Schedule 5 Schedule of Tangible Capital AssetsSchedule of Tangible Capital AssetsSchedule of Tangible Capital AssetsSchedule of Tangible Capital Assets For the year ended December 31, 2017 LandLandLandLand 2222 BuildingBuildingBuildingBuilding TransportationTransportationTransportationTransportation NetworkNetworkNetworkNetwork Storm SystemStorm SystemStorm SystemStorm System Historical Cost Historical Cost Historical Cost Historical Cost 1111 Opening cost $215,898,649 $92,096,017 $338,970,711 $260,890,240 Additions 10,105,057 1,202,662 2,881,900 8,888,275 Disposals .(162,261)(3,215,524)(663,274) 226,003,706 93,136,418 338,637,087 269,115,241 Accumulated Accumulated Accumulated Accumulated AmortizationAmortizationAmortizationAmortization Opening balance .46,463,390 115,740,432 58,970,812 Amortization expense .2,683,929 6,363,052 3,596,721 Effect of disposals .(152,067)(2,400,878)(203,854) .48,995,252 119,702,606 62,363,679 Net Book Value as atNet Book Value as atNet Book Value as atNet Book Value as at December 31, 2017December 31, 2017December 31, 2017December 31, 2017 $226,003,706 $44,141,166 $218,934,481 $206,751,562 Net Book Value as at December 31, 2016 $215,898,649 $45,632,627 $223,230,279 $201,919,428 1 Historical cost includes work in progress at December 31, 2017 of $5,004,065$5,004,065$5,004,065$5,004,065 ($13,675,368 for 2016) comprised of: Land $34,081 ($24,177 for 2016); Buildings $771,438 ($2,716,945 for 2016); Transportation network $987,757 ($10,162,075 for 2016); Storm system $1,479 ($46,711for 2016); Fleet and equipment $32,836 ($3,448 for 2016); Technology $27,900 ($3,000 for 2016); Water system $1,355,848 ($440,517 for 2016); Sanitary system $238,912 ($73,575 for 2016); and Other $1,553,814 ($204,919 for 2016). Work in progress is not amortized. 2 Additions to land are net of $.Nil ($.Nil for 2016) of land reclassified to inventory available for sale. 3 "Other" at net book value includes Furniture and Fixtures at $561,343 ($495,795 for 2016) and structures at $16,168,739 ($14,668,431 for 2016) Page 36 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements Fleet andFleet andFleet andFleet and EquipmentEquipmentEquipmentEquipment TechnologyTechnologyTechnologyTechnology Water SystemWater SystemWater SystemWater System Sanitary SystemSanitary SystemSanitary SystemSanitary System OtherOtherOtherOther 3333 TotalTotalTotalTotal $27,642,620 $10,859,758 $146,977,903 $170,811,020 $30,612,410 $1,294,759,326 2,668,476 729,341 4,794,069 4,281,695 2,725,964 38,277,439 (1,087,438)(120,781)(357,264)(375,930)(337,962)(6,320,434) 29,223,658 11,468,318 151,414,708 174,716,785 33,000,412 1,326,716,331 14,017,129 6,108,268 33,355,678 44,259,333 15,448,184 334,363,226 1,441,824 933,380 2,038,242 2,401,473 1,126,595 20,585,216 (915,509)(89,796)(180,457)(130,326)(304,448)(4,377,335) 14,543,444 6,951,852 35,213,463 46,530,480 16,270,331 350,571,107 $14,680,214 $4,516,466 $116,201,245 $128,186,305 $16,730,081 $976,145,224 $13,625,491 $4,751,490 $113,622,225 $126,551,687 $15,164,227 $960,396,101 Page 37 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ________________________________________________________ Schedule 6Schedule 6Schedule 6Schedule 6 Continuity Schedule of ReservesContinuity Schedule of ReservesContinuity Schedule of ReservesContinuity Schedule of Reserves For the year ended December 31, 2017 BalanceBalanceBalanceBalance Dec, 31, 2016 Dec, 31, 2016 Dec, 31, 2016 Dec, 31, 2016 InterestInterestInterestInterest Allocated Allocated Allocated Allocated Reserve FundsReserve FundsReserve FundsReserve Funds Local Improvements $2,565,270 $18,613 Equipment Replacement 15,143,197 210,281 Capital Works 10,727,978 150,866 Fire Department Capital Acquisition 8,404,264 121,204 Sanitary Sewer 1,636,239 21,742 Land 278,896 3,884 Total Reserve FundsTotal Reserve FundsTotal Reserve FundsTotal Reserve Funds 38,755,844 526,590 Reserve AccountsReserve AccountsReserve AccountsReserve Accounts Specific Projects 3 Capital 8,327,760 3 Specific Projects 3 Operating 7,834,360 3 Self Insurance 848,971 11,464 Police Services 7,299,090 96,438 Core Development 1,780,335 25,284 Recycling 2,148,985 27,814 Building Inspections 3,119,544 41,449 Gravel Extraction 762,288 10,511 Community Works (Gas Tax)3 3 Facility Maintenance 2,441,898 38,805 Snow Removal 473,061 3 Cemetery Maintenance 117,606 3 Infrastructure Sustainability (Town Centre Buildings)373,206 3 Infrastructure Sustainability (Road Network)1,673,167 32,443 Infrastructure Sustainability (Drainage)1,311,875 20,900 Drainage Improvements 807,108 14,290 Critical Infrastructure 203,511 2,679 Infrastructure Grants Contribution 3,557 3 Gaming Revenues 1,336,791 3 Self Insurance (sewer utility)141,377 3 Self Insurance (water utility)119,732 3 Specific Projects (sewer utility)2,319,380 3 Specific Projects (water utility)2,441,288 3 Total Reserve AccountsTotal Reserve AccountsTotal Reserve AccountsTotal Reserve Accounts 45,884,890 322,077 Total ReservesTotal ReservesTotal ReservesTotal Reserves $$$$84,640,73484,640,73484,640,73484,640,734 $$$$848,667848,667848,667848,667 Page 38 of 50 City of Maple Ridge - Statement of Financial Information Consolidated Financial Statements ________________________________________________________ TransfersTransfersTransfersTransfers Revenue Funds Revenue Funds Revenue Funds Revenue Funds TransfersTransfersTransfersTransfers Capital FundsCapital FundsCapital FundsCapital Funds Balance Balance Balance Balance Dec 31, 2017Dec 31, 2017Dec 31, 2017Dec 31, 2017 $3 $3 $2,583,883 2,889,903 (2,288,262)15,955,119 1,948,383 (1,540,671)11,286,556 1,534,071 (210,788)9,848,751 3 3 1,657,981 24,333 3 307,113 6,396,690 (4,039,721)41,639,403 4,156,291 (1,553,046)10,931,005 132,480 3 7,966,840 16,115 3 876,550 171,375 (52,093)7,514,810 193,085 (14,802)1,983,902 418,441 (25,000)2,570,240 172,250 3 3,333,243 24,784 3 797,583 283,437 (25,997)257,440 601,471 (198,819)2,883,355 377,000 3 850,061 172,999 (47,119)243,486 112,400 (9,868)475,738 2,849,277 (1,984,509)2,570,378 560,165 (401,926)1,491,014 870,795 (556,970)1,135,223 3 (10,263)195,927 3 3 3,557 798,339 (92,250)2,042,880 6,504 3 147,881 6,504 3 126,236 1,273,598 (513,229)3,079,749 2,585,779 (487,975)4,539,092 15,783,089 (5,973,866)56,016,190 $$$$22,179,77922,179,77922,179,77922,179,779 $$$$(10,013,587)(10,013,587)(10,013,587)(10,013,587)$$$$97,655,59397,655,59397,655,59397,655,593 Page 39 of 50 City of Maple Ridge - Statement of Financial Information "This organization has no guarantees or indemnities under the Guarantees and Indemnities Regulation." City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity AgreementsSchedule of Guarantee and Indemnity Agreements for 2017for 2017for 2017for 2017 Prepared pursuant to the Financial Information Regulation, Schedule 1, Section 1 (1) (d) Page 40 of 50 City of Maple Ridge - Statement of Financial Information 1111 Elected OfficialsElected OfficialsElected OfficialsElected Officials NameNameNameName PositionPositionPositionPosition RemunerationRemunerationRemunerationRemuneration BenefitsBenefitsBenefitsBenefits ExpensesExpensesExpensesExpenses Bell, Corisa Councillor 43,350.11$ 8,096.90$ 2,902.38$ Duncan, Kiersten Councillor 43,210.37 7,290.66 7,174.51 Masse, Robert Councillor 43,227.55 7,291.22 475.00 Read, Nicole Mayor 100,545.12 10,634.34 6,135.29 Robson, Gordy Councillor 43,350.11 5,665.68 1,320.66 Shymkiw, Tyler Councillor 43,210.37 9,036.90 693.44 Speirs, Craig Councillor 43,277.54 1,357.70 7,606.94 Total All Elected Officials 360,171.17$ 49,373.40$ 26,308.22$ 2222 EmployeesEmployeesEmployeesEmployees NameNameNameName Job TitleJob TitleJob TitleJob Title RemunerationRemunerationRemunerationRemuneration ExpensesExpensesExpensesExpenses Andre, Colin Network Analyst * 86,046.24$ 537.60$ Armour, Douglas Assistant Fire Chief Prevention & Operations 130,174.15 3,220.84 Armstrong, Fred Manager of Corporate Communications * 123,381.29 3,691.64 Baird, Kathryn Coordinator Volunteer & Special Events * 79,549.85 757.54 Balatti, Christa Manager of Health & Wellness * 119,363.80 1,870.64 Barrett, Kevin Fire Fighter 119,412.75 908.79 Baski, Michelle Planner 2 * 87,212.38 345.00 Baski, Sebastian Fire Fighter 109,574.57 1,501.08 Bayley, Christopher Fire Captain 134,104.68 20.00 Bean, Joshua Fire Fighter 109,108.12 88.00 Benson, Laura Acting Corporate Officer * 119,108.58 4,687.75 Bevilacqua, Jim Fire Captain 149,351.15 - Bhandari, Anita Manager of Health Safety & Employee Development * 115,185.10 10,043.05 Billard, Aaron Parks Operation Supervisor-Horticulture Arborculture Sports Field * 82,513.75 2,484.75 Bitcon, Stan Supervisor 2 Engineering Operations * 82,491.90 546.87 Blakeman, John Water System Operator * 77,187.89 988.75 Boag, David Director of Parks & Facilities * 152,548.62 547.68 Boehmer, Jeffrey Manager of Construction & Design * 133,208.63 3,429.79 Bonderud, Edward Fire Fighter 98,779.89 - Bonifazi, Marco Fire Fighter 106,422.85 1,201.83 Boyce, Jeffrey B. Field Arborist * 75,484.54 1,430.09 Bruce, Robert Fire Fighter 105,205.70 1,650.00 Brummer, Russell Manager of Business Operations * 79,816.65 2,370.77 Carmichael, Rhys Fire Fighter 100,717.32 527.00 Carter, Christine Director of Planning * 159,038.15 5,764.54 Christensen, Robert Fire Captain 139,771.17 Christiansen, Mark Tradesperson 2 Carpenter * 78,326.15 515.25 Chui, Yvonne Recreation Manager of Arts & Community Connections * 115,269.11 2,581.73 Cillis, Paul Engineering Inspector 3 * 86,216.52 854.22 Clelland, James Fire Fighter 111,335.21 2,690.64 Collard, Shaun Fire Fighter 102,897.36 - Cooke, David Manager of Business Solutions * 109,405.00 5,059.38 Cooper, Wendy A. Senior Planning Technician * 76,878.37 558.86 Cote-Rolvink, Stephen Chief Building Officer * 140,545.38 1,381.15 Cotroneo, Tony Recreation Manager of Youth & Neighbourhood Services * 114,221.80 2,441.06 Cotter, Steve Fire Fighter 103,143.87 - Crabtree, Christina Chief Information Officer * 142,036.71 2,082.99 Cramb, Donald B. Senior Recreation Manager * 148,802.45 1,301.43 Crapo, Ryan Tradesperson 2 Electrical * 94,981.14 3,236.45 Cratty, Jason Equipment Operator 4A * 76,075.45 - Cullen, Patrick Emergency Program Coordinator * 87,221.18 3,541.35 Cummings, Travis Fire Fighter 96,344.55 115.00 Dale, Cindy Executive Assistant * 79,431.70 21.45 Darcus, Laurie Manager of Legislative Services & Emergency Program * 132,272.63 2,909.57 Daunais, Don Electrical Inspector 1 * 85,103.44 630.02 Davis, Craig Fire Fighter 124,602.69 1,150.00 Davis, Jeffery Fire Fighter 91,969.11 875.94 Delmonico, Jordan Fire Fighter 102,494.21 - for 2017for 2017for 2017for 2017 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and Expenses Paid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each Employee Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (e) and Section 6 (2) (a-d), (3) and (6) Page 41 of 50 City of Maple Ridge - Statement of Financial Information for 2017for 2017for 2017for 2017 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and Expenses Paid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each Employee Denton, Darrell Property & Risk Manager * 105,526.37 672.49 Dingwall, William J. Manager of Utility Engineering * 133,308.67 2,779.81 Dipalo, David J. Tradesperson 2 Mechanic * 80,813.05 - Dorrell, Robert Trades Supervisor * 88,541.45 - Dyer, Robert Trades Inspector * 81,972.15 2,783.27 East, Robert Tradesperson 2 Carpenter * 78,809.01 550.39 Elliott, Brent Manager of Community Planning * 132,322.60 2,502.22 Eng, Michael Traffic & Transportation Technician * 92,595.81 1,823.29 Ettinger, Glenn Fire Fighter 123,757.30 60.00 Exner, Howard Fire Chief * 160,126.35 1,356.13 Forsyth, Janice Coordinator Aquatics * 80,644.09 1,293.21 Foster, Mary Fire Fighter 112,560.81 587.16 Franklin, Steven Fire Captain 140,806.27 100.00 Frederick, Petra Coordinator, Leisure Access * 79,278.60 535.75 Friesen, Jesse Fire Fighter 103,092.90 - Gailling, Bruce Electronics Technician * 78,638.00 3,532.10 Gaudette, Christopher Fire Fighter 107,983.07 - Gaunt, Amanda Confidential Secretary * 75,251.61 - Gibson, Timothy Research Technician Recreation * ** 93,436.82 - Gill, Paul Chief Administrative Officer * 246,112.93 2,145.43 Gjaltema, Michael Manager of Electro Mechanical * 100,979.26 1,444.54 Gladue, Gary Equipment Operator 4b * 79,301.50 - Glasgow, Ian Fire Fighter 104,799.40 1,154.46 Goddard, Charles Manager of Development & Environmental Services * 165,092.47 4,561.71 Gordon, Thomas Engineering Technologist 1 * 78,630.71 345.00 Gratzer, Franz Supervisor 3 Engineering Operations * 95,273.59 346.51 Guerra, Maria Senior Project Engineer * 118,758.57 1,605.36 Guy, Ronald Engineering Inspector 3 * 86,281.26 995.65 Hall, Diane Planner 2 * 97,176.97 533.86 Hampton, Warren Fire Fighter 106,927.84 830.24 Hansen, Damon Fire Fighter 97,136.01 897.62 Harcus, David Fire Captain 129,221.24 - Harwood, Kevin Fire Captain 119,612.26 - Haydu, John Fire Fighter 130,685.52 - Hewson, Glen Trades Inspector * 86,271.62 595.45 Hopper, Clinton Fire Fighter 104,451.71 - Howe, Steven Fire Fighter ** 87,849.77 499.00 Irwin, George Supervisor Mapping and Drafting * 81,314.44 - Jonat, Cameron Fire Fighter 110,579.63 838.49 Jones, Cameron Fire Fighter 95,349.20 19.95 Jones, Maureen Senior Manager of Police Services * 111,426.25 514.31 Judd, Stephen Manager of Infrastructure Development * 125,257.66 1,620.43 Juurakko, Timo Assistant Fire Chief, Community & Administrative Services * 147,572.95 2,041.04 Kabanov, Andrey Fire Fighter 98,549.20 - Kelleher, Jonathan T. Fire Fighter 113,626.36 115.00 Kelly, Paul Electrical Inspector 1 * 83,577.80 681.45 King, Frances Director of Human Resources * 164,079.65 5,532.33 Kopystynski, Adrian Planner 2 * 100,473.24 1,080.77 Kovach, Natalie Business Systems Analyst * 84,285.46 5,399.20 Kozlik, Mark Building Inspector 1 * 104,189.01 1,352.36 Lackner, Andrew Engineering Technologist 1 * 80,626.40 775.04 L'Arrivee, Michael Building Inspector 1 * 89,922.72 4,588.88 Laxton, Shannon Accountant 3 * 79,090.71 1,175.62 Lee, Chin-Kuan Assistant Manager of Revenue and Collections * 80,880.42 1,150.00 Lee, Joo Young Business Systems Analyst * 81,978.73 514.42 Livingstone, Bruce Business Retention & Expansion Officer * 83,193.98 2,729.38 Macdonald, Robert Fire Fighter 99,076.50 - MacNair, Robin Manager of Bylaw & Licencing Services * 124,570.08 722.94 Mah, Edwin Building Inspector 1 * 82,259.20 934.80 Marfleet, William Fire Fighter 97,717.95 - Matthewson-Schober, Shawn Social Planning Analyst * 95,004.49 975.41 McAusland, Andrew S. Facilities Operations Supervisor * 83,644.26 2,414.34 McCormick, Wendy Director of Recreation * 152,034.73 746.29 McCurry, Aaron Supervisor 2 Engineering Operations * 85,929.52 1,000.08 McDougall, Malcolm Parks Operation Supervisor-Horticulture Arborculture Sports Field * 81,008.70 3,870.65 McKee, Christopher J. Fire Lieutenant 117,904.74 890.00 Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (e) and Section 6 (2) (a-d), (3) and (6) Page 42 of 50 City of Maple Ridge - Statement of Financial Information for 2017for 2017for 2017for 2017 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and Expenses Paid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each Employee McLeod, Kirk Engineering Inspector 2 * 79,673.98 1,986.34 Messam, Erica Engineering Technologist Projects * 81,127.30 2,025.69 Michaud, Dayne C. Fire Fighter 81,924.40 537.82 Middleton, Christopher Tradesperson 2 Mechanic * 79,295.25 - Mikes, Daniela Manager of Procurement * 119,365.11 1,648.86 Millward, Michael Facilities Operations Manager * 120,319.39 674.03 Moerman, Andrew Electrical Inspector 1 * 88,541.57 315.00 Moore, Kelly Fire Captain 126,892.70 100.00 Myers, Mikaela Marketing & Communications Coordinator * 75,613.19 513.60 Nagra, Dhaminder Human Resources Advisor * 88,665.04 229.52 Nairn, Cale Tradesperson 2 Electrical * 78,931.67 791.66 Narayan, Sureshwar Senior Analyst Programmer * 94,414.57 739.87 Neufeld, Chad Park Planning Technician * 76,935.22 1,003.72 Nikula, Matthew Fire Fighter 99,998.37 - Nolan, Catherine Manager of Accounting * 130,542.19 2,705.86 Ogilvie, Ralph Fire Fighter 100,912.61 - Oleschak, Walter Superintendent Roads and Fleet * 120,898.10 1,189.75 Ollenberger, Rachel M. Engineering Technologist 1 * 77,331.58 1,906.71 Patel, Brian Coordinator, Core Area * 81,338.13 2,152.20 Perkin, Kevin Fire Lieutenant 114,328.04 - Pollock, David Municipal Engineer * 170,574.73 6,971.73 Pope, Danielle Director of Recreation * 120,930.53 1,718.28 Porter, Gary Fire Training Officer 139,874.55 4,662.23 Pym, Mike Environmental Planner 1 * 81,482.48 1,998.85 Quinn, Frank General Manager, Public Works & Development Services * 204,561.60 5,775.23 Ramsay, Devin Fire Fighter 109,327.32 100.00 Ramsay, Robert Fire Captain 136,193.90 - Richmond, Calvin Supervisor 3 Engineering Operations * ** 99,084.70 265.43 Richmond, Valoree Manager of Parks Planning & Operations * 105,442.25 2,730.08 Rutledge, Silvia Manager of Revenue & Collections * ** 120,133.98 415.22 Salsbury, Scott A. Superintendent of Sewerworks * 112,237.86 4,164.94 Schmidt, Kristofer Water Maintenance Worker * 79,078.70 579.25 Schramm, Aaron Supervisor 3 Engineering Operations * 91,968.90 1,402.91 Schurer, Oliver Business Systems Analyst * 93,642.15 581.73 Schwaiger, Harry Building Inspector 1 * 82,363.34 935.19 Serediuk, Sean Manager of Infrastructure and Security Services * 109,337.12 2,695.11 Seward, Adam Fire Lieutenant 131,037.16 110.00 Siracusa, Lino Manager of Economic Development * 129,624.93 12,687.11 Smitton, Mark Assistant Fire Chief, Fire Prevention & Communications * 171,276.31 2,038.60 Snow, Roy Fire Lieutenant 129,352.02 - Speers, David Coordinator Health Wellness * 78,278.20 571.04 Stetin, Velimir Engineering Technologist - Projects * 81,972.15 1,957.09 Stewart, Michael Fire Captain 139,951.43 28.00 Storey, James Director of Engineering Operations * 148,666.48 1,497.17 Stott, Rodney Environmental Planner 2 * 97,168.39 513.78 Stripp, Mitchell Supervisor Electrical Mechanical * 107,057.49 6,419.83 Swabey, Edward Chief Administrative Officer * 270,195.05 7,982.99 Swift, Kelly General Manager, Parks Recreation & Culture * 212,543.81 2,932.85 Szostek, Gail Enviromental Coordinator * 79,555.85 1,176.65 Taylor, Adam Fire Fighter 108,926.42 - Thind, Amandeep Network Support Specialist * 83,490.40 810.35 Thompson, Trevor Interim Director of Finance * 131,154.77 5,500.12 Todd, Thomas Supervisor 3 Engineering Operations * 93,590.96 1,010.10 Ulrich, Cynthia Manager of Compensation * 115,040.56 $2,822.06 Van Der Lee, Caroline H. Network Analyst * 82,385.44 $540.00 Van Dop, Michael J. Deputy Fire Chief * 146,967.73 5,051.19 Vanderjagt, Ryan Fire Fighter 102,661.50 $28.00 Varcoe, Thomas Supervisor 2 Engineering Operations * 77,829.60 $517.39 Veltin, George Tradesperson 2 Mechanic * 83,866.94 $273.78 Vinje, Brock Fire Fighter 115,374.21 $828.04 Vinje, Bryan Assistant Fire Chief, Training & Safety * 133,392.45 $7,303.84 Virs, Nicholas Fire Fighter 99,947.29 $0.00 Walsh, Nichole Purchasing Supervisor * 79,283.67 $1,261.01 Wetherill, Michelle Manager of Human Resources * 120,096.49 $2,966.33 Wicklund, Everett Supervisor 2 Engineering Operations * 77,868.87 $605.60 Wilson, Davin Superintendent of Waterworks * 108,496.64 $6,068.53 Yan, Angela Systems Analyst 2 * 80,525.85 $5,269.90 Zezchuk, Edward Trades Inspector * 82,257.15 $599.50 Zosiak, Lisa Planner 2 * 97,364.97 $2,281.87 Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (e) and Section 6 (2) (a-d), (3) and (6) Page 43 of 50 City of Maple Ridge - Statement of Financial Information for 2017for 2017for 2017for 2017 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and ExpensesSchedule Showing the Remuneration and Expenses Paid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each EmployeePaid to or on Behalf of Each Employee Subtotal 19,663,968.99$ 291,943.85$ Consolidated Total of Employees with remuneration 16,331,966.46 92,887.83 less than $75,000 Total All Employees 35,995,935.45$ 384,831.68$ 3 ReconciliationReconciliationReconciliationReconciliation Total remunerationTotal remunerationTotal remunerationTotal remuneration Elected Officials 360,171.17$ Other Employees 35,995,935.45 Subtotal 36,356,106.62$ Other reconciling Items CPP 1,132,719.42$ Employer portion of: EI 493,308.99 Accruals 124,179.14 WCB 451,648.01 Pension 3,436,295.00 Other employer costs 1,392,549.58 (Medical, Dental, etc.) Wages & Salaries per Consolidated Financial Statements,43,388,499$ Annual Report, Page 53 * Remuneration includes the effect of retroactive settlements. ** Remuneration includes payment of previously accrued amounts. Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (e) and Section 6 (2) (a-d), (3) and (6) Page 44 of 50 City of Maple Ridge - Statement of Financial Information There were no severance agreements under which payment commenced between the City of Maple Ridge and non-unionized employees during the fiscal year 2017 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Statement of Severance Agreements for 2017Statement of Severance Agreements for 2017Statement of Severance Agreements for 2017Statement of Severance Agreements for 2017 Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Prepared under the Financial Information Regulation, Schedule 1, Section 6 (7) (a, b) Page 45 of 50 City of Maple Ridge - Statement of Financial Information 1)1)1)1) Alphabetical list of suppliers who received aggregate payments exceeding $25,000Alphabetical list of suppliers who received aggregate payments exceeding $25,000Alphabetical list of suppliers who received aggregate payments exceeding $25,000Alphabetical list of suppliers who received aggregate payments exceeding $25,000 Supplier NameSupplier NameSupplier NameSupplier Name Aggregate amount paid Aggregate amount paid Aggregate amount paid Aggregate amount paid to supplier to supplier to supplier to supplier 0946235 BC Ltd 123,396.00 A & G Supply Ltd 26,484.02 ABC Pipe Cleaning Services 84,415.03 Absolutely Floored 29,116.50 Action Data Communications 42,986.21 AECOM Canada Ltd 30,399.90 AIPI Investments Ltd 52,155.40 Alouette River Management Society 60,674.26 Andrew Sheret Ltd 60,572.48 AON Hewitt Inc 32,199.98 Aplin & Martin Consultants Ltd 50,748.09 Aptean Inc 188,995.94 Associated Engineering (BC) Ltd 121,697.66 Associated Fire Safety 33,272.85 Auto-Quip 62,748.00 AW Fire Guard & Supplies Ltd 41,689.24 B & B Contracting Ltd 1,580,868.48 BA Blacktop 1,453,791.84 Badger Daylighting Lp 62,266.18 Bartle & Gibson Co Ltd 94,738.89 BC Hydro 1,696,520.68 BC Institute Of Technology 42,123.52 BC SPCA 350,283.96 BDO Canada Llp 67,284.69 Black Press Group Ltd 83,276.91 Bob's A-Z Rentals Ltd 39,901.29 Boileau Electric & Pole Ltd 226,902.66 Braun Geotechnical Ltd 41,681.64 Brett Young 40,723.20 Canada Pipe Company Ltd 46,167.68 Canadian Pacific Railway 309,030.39 Carrier Mausoleums Construction 48,132.00 CBI Health Centre Golden Ears 29,805.54 Cedar Crest Lands (BC) Ltd 921,230.65 Cel-Com Systems Ltd 36,765.20 Chairlines 44,440.48 Chevron Canada Ltd 697,691.14 Christie Lites 27,993.98 Citrix Systems Inc.32,047.28 City Of Pitt Meadows 66,799.66 Cobing Building Solutions 429,428.12 Co-Pilot Industries Ltd 94,487.20 Corix Control Solutions 34,580.64 Corix Water Products 53,058.88 CSDC Systems Inc 96,084.02 D Litchfield & Co Ltd 130,362.75 Dams Ford Lincoln Sales Ltd 25,944.05 Deborah Kulchiski Consulting 26,248.95 Direct Equipment West Ltd 44,559.73 Double M Excavating Ltd 450,577.01 Dougness Holdings Ltd 71,586.46 Drake Excavating 378,137.98 DTM Systems Corporation 26,749.28 Eagle West Crane & Rigging 42,397.52 City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017 Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (f) and Section 7 (1) (a-c) and (2) (b) Page 46 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017 Supplier NameSupplier NameSupplier NameSupplier Name Aggregate amount paid Aggregate amount paid Aggregate amount paid Aggregate amount paid to supplier to supplier to supplier to supplier Ecotainer Sales Inc 74,517.37 EECOL Electric Corporation 34,814.10 Emergency Communications For British Columbia Inc 1,050,829.00 Empire Signworks Inc 29,411.20 ESRI Canada Limited 97,430.90 Eurovia British Columbia Inc 1,874,637.89 Farm Tek Turf Services Inc 62,945.19 FDM Software Ltd 56,093.10 Finning International Inc 66,855.45 First Call Hydrovacing Inc 46,697.27 First Truck Centre Vancouver Inc 847,281.69 Fitness Edge 231,871.41 Fort Fabrication & Welding Ltd 26,269.62 Fortis BC Energy Inc 350,468.17 Fraser City Installations Ltd 209,677.75 Fraser River Pile & Dredge Inc 31,500.00 Fraser Valley Regional Library 2,761,564.39 Frazer Excavation Ltd 79,675.20 Fred Surridge Ltd 247,322.07 Gibson Waterworks Supply Inc 45,408.23 Golden Ears Alarm Systems 63,406.23 Golden Ears Winter Club 56,339.77 Gotraffic Management Inc 448,013.20 Greater Vancouver Sewerage & Drainage District 80,106.80 Greater Vancouver Water District 8,063,983.55 Green Cut Contracting 38,571.81 Green Landscape Experts Ltd 88,595.80 Gregg Distributors 30,366.81 Guild, Yule & Company Llp 273,845.76 Guillevin International Inc 627,455.80 Hallmark Facility Services Inc 332,386.95 Haney Builders Supplies 1971 25,530.66 Hanks Trucking And Bulldozing 39,537.76 Harbour International Trucks 576,105.60 HCMA Architecture & Design 28,914.67 Heavy PDG Equipment Ltd 31,669.05 Hewson, William 26,900.00 Hi Cube Storage Products 55,873.76 Homewood Health Inc 37,998.72 Horizon Landscape Contractors 149,366.63 Hub Cycling 43,150.00 Hub Fire Engines And Equipment 30,412.44 Hub International Insurance Brokers 32,625.00 ICBC - Fleet Insurance 198,275.00 IDRS 42,370.98 Image Painting & Restoration Ltd 219,319.80 Industra Construction Corporation 1,066,726.83 Infinite Roadmarking Ltd 149,052.69 Intelligo Networks Inc 86,367.70 Interprovincial Traffic Services 170,598.96 ISCMV - Invasive Species Council of Metro Vancouver 46,660.73 ISL Engineering & Land Services Ltd 30,222.42 Jack Cewe Ltd 40,013.29 Jacks Automotive & Welding 167,436.40 Jennifer Wilson Consultants 35,309.27 Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (f) and Section 7 (1) (a-c) and (2) (b) Page 47 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017 Supplier NameSupplier NameSupplier NameSupplier Name Aggregate amount paid Aggregate amount paid Aggregate amount paid Aggregate amount paid to supplier to supplier to supplier to supplier Justice Institute Of BC 62,249.54 Kaake, Karen 26,516.00 Kerr Wood Leidal Associates 198,932.17 King Hoe Excavating Ltd 156,868.40 Lafarge Canada Inc 632,914.97 Langley Concrete Group 49,431.04 Linden, Charlene 45,371.00 Lit Aquatic Ltd 76,830.87 Loewen Paving 102,427.50 Lordco Parts Ltd 83,216.48 Mainroad Maintenance Products 70,681.89 Manulife Financial 1,204,035.34 Maple Ridge & PM Arts Council 862,643.42 Maple Ridge Carpet One 163,558.62 Maple Ridge Chrysler 1972 Ltd 207,121.49 Maple Ridge Historical Society 190,527.00 Mar-Tech Underground Services 61,178.77 McElhanney Consulting Services 319,200.98 MDT Technical Services Inc. 38,322.49 Medical Services Plan 359,755.51 Mertin Nissan Ltd 130,625.60 Michelin North America Inc 35,080.99 Microserve 96,602.79 Microsoft Corporation 128,426.19 Mills Printing & Stationery 75,649.94 Motion Canada 28,525.31 Municipal Insurance Association of British Columbia 684,817.05 Municipal Pension Plan 3,560,474.14 Murphy, Amanda 50,918.18 Noble British Columbia 33,231.22 North Of 49 Enterprises Ltd 85,780.71 Nova Pole International Inc 59,257.38 Now Solutions 77,778.40 Nustadia Recreation Inc 272,384.89 N.Wallace & Company Ltd 286,649.85 Ocean Pipe T6045 36,479.47 Open Storage Solutions 238,067.06 Opus International Consultants 276,948.38 Oracle Corporation Canada Inc 48,559.38 Organized Crime Agency Of BC 87,703.73 P & L Speed Print Ltd 38,638.97 Pacific Flow Control Ltd 95,259.15 Pacific Surrey Construction 31,727.08 Panorama Lms 4011 149,536.26 Parkland Refining (BC) Ltd 130,738.55 Paul Bunyan Tree Services 144,560.89 Pika Pump & Compressor Service 29,895.39 Pit Stop Portable Toilets 25,274.35 Pitney Works 58,181.94 Plan Group Inc 33,964.28 Promix Concrete Ltd 58,154.77 PW Trenchless Construction Inc 2,057,376.98 Ranger Construction 47,402.45 Raybern Erectors Ltd 69,907.24 RCMP - Receiver General 12,754,980.85 Receiver General-Payroll Deduction 1,623,605.52 Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (f) and Section 7 (1) (a-c) and (2) (b) Page 48 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017 Supplier NameSupplier NameSupplier NameSupplier Name Aggregate amount paid Aggregate amount paid Aggregate amount paid Aggregate amount paid to supplier to supplier to supplier to supplier RF Binnie & Associates Ltd 265,226.87 RG Arenas (Maple Ridge) Ltd 958,073.52 RGH Pacific Emergency Services 26,139.12 Riches Land Services Ltd 30,700.99 Ricoh Canada Inc 174,064.86 Ridge Meadows Recycling Society 2,494,190.76 Ridge Meadows Seniors Society 211,322.75 Ridge Sign Design 25,442.64 RJ Construction 48,719.00 Rogers 117,842.99 Safe Guard Fence Ltd 38,036.25 Sandpiper Contracting Ltd 44,219.59 Sanscorp Products Ltd 269,984.87 Scottish Line Painting Ltd 38,019.19 SFE Ltd 30,882.87 Shape Architecture Inc 267,358.75 Shaw Cablesystems 56,143.42 SHI Canada ULC 32,181.32 Simon Fraser University 28,182.49 Simson Maxwell 36,960.00 Softchoice LP 59,144.67 Stantec Consulting Ltd 443,827.55 Stewart Mcdannold Stuart 256,147.65 Sudden Impact Branded Apparel 30,542.60 Sunrise Toyota 448,339.37 Surlang Roofing 46,725.00 Surrey Fire Service 97,476.99 SV 232 Street Development LTD 1,101,443.98 T & T Demolition Ltd 64,933.60 Talentmap 43,617.97 Telus 124,756.38 Tempest Development Group 97,336.53 Terra Link Horticulture Inc 33,556.03 Tetra Tech Canada Inc 37,074.18 The Get Go Inc (GGI) 103,039.93 Thrifty Foods 40,560.26 Timbro Contracting 470,925.45 Total Power Ltd 86,689.21 Treen Safety (Worksafe) Inc 27,084.22 Triahn Enterprises 814,234.95 Tundra Plumbing Ltd 58,876.32 Union Of BC Municipalities 34,394.48 Urban Lumberjack Tree Services 37,170.05 Urban Systems 101,373.79 Valley Traffic Systems Inc 103,824.71 Vimar Equipment Ltd 324,007.05 Warrington PCI Management 987,519.30 Waste Connections 34,913.10 Water Street Engineering Ltd 28,092.74 Westcoast Fitness Fixations Inc 30,005.92 Westridge Security Ltd 143,209.74 Westview Sales Ltd 70,512.35 Wolseley Canada Inc 28,973.83 Wordsworth & Associates 25,200.00 Workers Compensation Board 511,106.87 Wu, Lin May 677,368.80 Xylem Canada Company 54,845.25 Young, Anderson - Barristers 46,300.97 Zone West Enterprises Ltd 47,146.54 74,165,942.32$ Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (f) and Section 7 (1) (a-c) and (2) (b) Page 49 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge Financial Information ActFinancial Information ActFinancial Information ActFinancial Information Act Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision Schedule Showing Payments Made for the Provision of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017of Goods or Services for 2017 2)2)2)2) Consolidated total paid to suppliers who received aggregate payments of $25,000 or lessConsolidated total paid to suppliers who received aggregate payments of $25,000 or lessConsolidated total paid to suppliers who received aggregate payments of $25,000 or lessConsolidated total paid to suppliers who received aggregate payments of $25,000 or less 5,366,132.56$ 3)3)3)3) Total payments to suppliers for grants and contributions exceeding $25,000Total payments to suppliers for grants and contributions exceeding $25,000Total payments to suppliers for grants and contributions exceeding $25,000Total payments to suppliers for grants and contributions exceeding $25,000 Consolidated total of grants exceeding $25,000 30,000.00 Consolidated total of contributions exceeding $25,000 - Consolidated total of all grants and contributions exceeding $25,000 30,000.00 4)4)4)4) ReconciliationReconciliationReconciliationReconciliation Total of aggregate payments exceeding $25,000 paid to suppliers 74,165,942.32$ Consolidated total of payments of $25,000 or less paid to suppliers 5,366,132.56$ Consolidated total of all grants and contributions exceeding $25,000 30,000.00 Reconciling items Explanation below Total per Financial Statements, Expenditures & Expenses, Good & Services including Capita 78,209,829.00$ Variance (1,352,245.88)$ Expenditures in the statements are on an accrual basis, whereas amounts paid are on a cash basis. It is important to note that not all payments are expenditures and that not all expenditures are payments. It is not practical to reconcile to those sets of data. Prepared under the Financial Information Regulation, Schedule 1, Section 1 (1) (f) and Section 7 (1) (a-c) and (2) (b) Page 50 of 50 City of Maple Ridge - Statement of Financial Information City of Maple RidgeCity of Maple RidgeCity of Maple RidgeCity of Maple Ridge 11995 Haney Place Maple Ridge, BC V2X 6A9 Canada Tel: 604-463-5221 Fax: 604-467-7329