Loading...
HomeMy WebLinkAboutFIN 10-13ei, 4 Report to Executive Committee PICKERING Report Number: FIN 10 -13 Date: May 13, 2013 From: Paul Bigioni Director, Corporate Services & City Solicitor Subject: 2012 Pre -Audit Balances of Reserves and Reserve Funds Recommendation: That Report FIN 10 -13 of the Director, Corporate Services & City Solicitor regarding the 2012 pre -audit balances of reserves and reserve funds be received for information. Executive Summary: Based on the preliminary 2012 results, staff are now in a position to report on the pre -audit actual activities within the Reserves and Reserve Funds for 2012. A summary is presented in Appendix A. The purpose for each reserve and reserve fund, as well as the 2012 financial transactions is set out in Appendices B and C respectively. Financial Implications: As at December 31, 2012, reserves and reserve funds totaled $80.2 of which $47.6 million are obligatory. This obligatory category consists of Development Charges, Parkland, Federal Gas Tax and Third Party Contributions Reserve Funds. A further $10 million is restricted as to use. The balance of $22.6 million is primarily made up of the Rate Stabilization Reserve ($15.7 million) with other smaller reserves and reserve funds. Discussion: As in previous years, this report provides specific information on each of the City's reserves and reserve funds, including year -end balances. The 2012 pre -audit reserves and reserve funds balance of $80,217,692 will be mainly used to help finance future year's capital expenditures that in turn will reduce the City's reliance on debt. The 2013 Budget uses $10.8 million in reserves and reserve funds financing to fund the 2013 Capital Budget. Put another way, for every capital dollar spent, 44.6 cents is financed from reserves and reserve funds. With regard to unspent budget commitments for capital projects, staff are continuing the practice of not transferring funding for commitments until the expenditures are incurred. This procedure allows the reserve funds to earn interest income as long as funds are still in the reserve fund's custody and are in compliance with the Public Sector Accounting Board (PSAB) requirements for obligatory reserve funds. The combined unspent budget commitments for all reserve funds are $9,991,809. Report FIN 10 -13 May 13, 2013 Page 2 The Development Charges, Parkland, Third Party /Developer Contributions, Federal Gas Tax and Building Permit Reserve Funds represent funds received for specific purposes, many of which are subject to legislative requirements, with others based on developer agreements or agreements with third parties. These reserve funds, totaling $47,607,024, are obligatory in nature and should be treated as committed. This amount is further reduced to $37,615,214 after taking into account unspent budget commitments of $9.9 million. Of the above mentioned discretionary balance of $22.6 million, approximately $15.7 million is in the Rate Stabilization Reserve which is anticipated to be used over the current and future term of Council as the City progresses towards a sustainable level of budgets. The balance of $6.9 million is primarily reserved for capital works and capital replacements related to vehicles, equipment, telephone, and community facilities. The City established two new reserves this year, namely: New Seniors' Centre Reserve, and Accessibility Initiatives Reserve. The New Seniors' Centre Reserve was established to build up funds for the new Senior Centre. The Accessibility Initiatives Reserve was established to transfer any unspent funds from budgeted accessibility projects. The accumulation of funds is to be used for future accessibility- related projects. Attachment B sets out the 2012 transactions for these two new reserves. Internal borrowings from the Development Charges Reserve Fund commenced in 2001 to assist in funding capital projects. This provided the reserve fund with an attractive rate of interest compared to current market investment rates while at the same time providing a cheaper cost of borrowing for the municipality The outstanding principal balance as at December 31, 2012 is $3,113,545 of which $2,580,000 in principal was related to 2012 new issue. Attachments: 1. Appendix A Summary of Reserves and Reserve Funds 2. Appendix B Description of Reserves 3. Appendix C Description of Reserve Funds Report FIN 10 -13 Prepared By: Caryn Kong, CGA Senior Financial Analyst - Capital & Debt Management CK Recommended for the consideration of Pickering City Council _ Tony Prevedel, P.Eng. Chief Administrative Officer May 13, 2013 Page 3 Approved /Endorsed By: Stan Karwowski, MBA, CMA (Acting) Divis}emy Head, Finance & Treasurer Paul Bigioni Director, Corp :030,203 & City Solicitor I ATTACHMENT #J_T® REPORT# Lj o -1 3 Appendix C Summary of Reserve Funds Appendix A 2011 2010 2009 7501 Third Party /Dev. Contributions' $2,670,168 $2,233,978 $2,185,223 $2,210,924 - CITY OF PICKERING = 1,757,582 - SUMMARY OF;RESERVES AND RESERVE FUNDS 4,977,097 3,526,410 =_ as at December 31, - 116 1,315 2,532,549 Pre Audit Audited Audited Audited Appendix B Summary Reserves 2012 2011 2010 2009 7000 Working Funds $ 400,000 $400,000 $400,000 $400,000 7001,7031 -36 Replacement Capital 1,426,012 852,792 1,090,999 854,338 7011 -7014 Contingencies -OPG, Election, Other 1,514,339 1,447,278 1,277,278 1,471,140 7020 Self- Insurance 2 962,707 962,707 962,707 962,707 7021 Rate Stabilization 15,793,551 16,310,644 16,579,632 16,565,777 7022 Develop. Charges- City's Share 2 3,165,288 4,370,874 3,695,928 1,946,216 7024 Continuing Studies 2 720,472 582,055 406,984 390,315 7040 Vehicle Replacement 197,215 93,722 149,158 237,547 7041 Easement Settlement 17,595 17,595 - 131,279 7042 Library Eastern Branch 2 180,000 155,000 130,000 105,000 7043 Move Ontario 40,883 97,483 14,533 267,033 7045 Economic Stabilization 830,000 830,000 830,000 1,235,000 7046 Capital Maint Mgmt System 0 240,000 165,000 90,000 7047 Land Purchase 99,403 194,403 - - 7048 Seaton Development Review 1,905,948 2,133,752 - - 7049 Financial Systems 314,647 175,000 - - 7050 New Senior Ctr Newt 75,000 - - - 7051 Accessibility Initiatives Newt 13,713 - - - Total Reserves $27,656,773 $28,863,305 $25,702,219 $24,656,352 Appendix C Summary of Reserve Funds 2012 2011 2010 2009 7501 Third Party /Dev. Contributions' $2,670,168 $2,233,978 $2,185,223 $2,210,924 7502 Parkland 11,2 1,433,507 1,818,119 1,757,582 1,914,793 7505 Federal Gas Tax Revenue' 6,017,337 4,977,097 3,526,410 3,032,702 7506 Building Permit Stabilization Fees 1&2 7600 Development Charges 112 7700 Community Facilities 7701 Capital Works 7702 Public Works 7704 Doubles Squash Courts 2 7705 Workers Safety Insurance Brd(WSIB)2 7706 Animal Shelter 7707 Pickering Mens' Slow Pitch 2 7708 Operations Centre 2 Total Reserve Funds Total Reserves & Reserve Funds Notes (Financial Implications) ' Obligatory Reserve Funds 0 - - 37,486,012 34,107,294 29,593,894 27,714,332 151,468 148,547 145,483 215,350 384,306 377,057 369,943 361,338 1,093,391 1,074, 373 1,049, 595 1,224,292 2,088 - 116 1,315 2,532,549 2,374,028 2,021,105 1,658,462 228,883 196,370 173,850 162,553 141,652 138,985 136,359 137,587 419,558 412,365 - - $52,560,919 $47,858,213 $40,959,560 $38,633,648 $80,217,692 $76,721,518 $66,661,779 $63,290,000 2 Restricted Reserves & Reserve Funds Total Obligatory' & Restricted 2 -2012 = Less Budget Committed Projects Total Uncommitted Obligatory & Restricted R & RF Total Reserves & Reserve Funds Less Obligatory, Restricted Reserve & Reserve Funds Net - Discretionary Reserves & Reserve Funds (Includes 7600 & $47,607,024 7502 (Excludes 7600 & 10,055,651 7502) 57,662,675 (9,991,809) $47,670,866 $80,217,692 (57,662,675) $22,555,017 ATTACHMENT# -2 TO REPORT #L 10 -�3 Appendix B Reserve for Working Funds 7000 Actual Balance December 31, 2011 $ 400,000 Transfers into the Reserve - Transfers out of the Reserve Pre -Audit Actual Balance December 31, 2012 $ 400,000 Purpose of this Reserve: The reserve for working funds is used to provide operating cash to assist in avoiding short term interest expenses incurred on operations, typically during the first few months of the year prior to tax billing and at other times when cash inflows and outflows do not match as occurs in any corporation. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: It is recommended as a "rule -of- thumb" that this reserve be 2% to 3% of total City revenues. Based on average annual revenue of $45 million, at 2 %, the amount to maintain for this reserve should be $900,000. 1. Appendix B Reserve for Replacement of Capital Equipment - G/L 7001, 7031 -7036 Actual Balance December 31, 2011 $ 852,792 Transfers into the Reserve: Revenue Fund Contribution 797,254 Return to Source 21,876 Transfers out of the Reserve: Transfers to Capital Fund (245,910) Pre -Audit Actual Balance December 31, 2012 $ 1,426,012 Purpose of this Reserve: The purpose of this reserve is to reduce the need to levy for the full cost of major equipment in the year of acquisition. This reserve acts as a stabilization factor and helps to avoid both tax rate fluctuations and the issuance of long -term debt or other means of financing. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: This reserve should be kept at a level that is equivalent to the replacement cost of the assets for which they were established. Over the last couple of years, the reserve balance has been kept at a minimum level. Contributions to this reserve are provided for annually in the Current Budget. In 2003, additional sub - categories were set up for accounting purposes to better match the collection of funds to the application of these funds to particular facilities as shown on the following page. Appendix B The balances pertaining to these sub - categories are as follows: Rec Rec Rec General Recreation Dunbarton Don Beer Comp Comp Comp Corp Use Prgrms Pool Arena Core Pool Arena Total Acct 7001 7031 7032 7033 7034 7035 7036 Dec 31/11 201,857 208,752 42,607 161,607 91,116 91,436 55,417 852,792 Transfers in 681,792 18,500 4,962 30,000 27,000 15,000 20,000 797,254 Revenue Fund 0 Return to _ source 0 4,165 17,711 21,876 Transfers out (23,316) - (26,905) (76,134) (50,600) (18,955) (50,000) (245,910) Dec 31/12 860,333 . 227,252 20,664 119,638 67,516 87,481 43,128 1,426,012 1. Appendix B Reserve for Contingencies - G/L 7011 -7014 (OPG, Other Assessment Appeals, Election, Miscellaneous) Actual Balance December 31, 2011 Transfers into the Reserve: Transfers from Revenue Fund Transfers out of the Reserve: Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve: $ 1,447,278 70,000 (2,939) $ 1,514,339 Like the Capital Equipment Replacement Reserve, this reserve acts in a tax stabilization capacity. It was established in anticipation of unknown, unusual or extraordinary expenditures, which occur from time to time. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: In 2003, the large balances in this reserve were reviewed and grouped into sub- categories in the general ledger, for accounting purposes only, to better distinguish those amounts that are committed and those amounts available for general corporate use. The sub - categories are as follows: OPG Assessment Appeal, Elections, Other Assessment Appeals and Miscellaneous. As at the year ended December 31, 2009, there are no longer any funds in the Contingency- Ontario Power Generation (OPG) Assessment Reserve as the assessment appeals related to the taxation years 2003 -2006 have been reached and this amount was transferred to the Rate Stabilization Reserve in 2007. The amounts pertaining to the other sub - categories are as follows: Election — $156,138, Other Assessment Appeals - $682,594, True Sport City Share- $121 and Miscellaneous - $675,486 Appendix B Reserve for Self Insurance - G/L 7020 Actual Balance December 31, 2011 Transfers into the Reserve Transfers out of the Reserve: Transfer to Capital Fund $ 962,707 Pre -Audit Actual Balance December 31, 2012 $ 962,707 Purpose of this Reserve: This reserve was established as a necessary form of asset protection and risk management. Specifically, it is to cover insurance claims resulting from the increase in deductible levels, costs of uninsured claims and other claim related costs. The higher deductible reduced insurance premiums. Significant savings can be realized through reduced premium costs and staff analyzes the costs /benefits of such actions on an annual basis. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: This reserve should be maintained at a level to ensure that the funding is adequate to meet future liabilities. This situation is analyzed by staff on a regular basis. lip Appendix B Reserve for Rate Stabilization - GIL 7021 Actual Balance December 31, 2011 Transfers into the Reserve: 2012 Excess Surplus Contribution Dividend from Veridian Transfers out of the Reserve: 2012 Current Budget Provision Transfer to Capital Fund $ 16,310,644 673,110 1,927,000 2,600,110 18,910,754 (2,560,338) (556,865) Pre -Audit Actual Balance December 31, 2012 $ 15,793,551 Purpose of this Reserve: The purpose of this reserve is to act as a tax rate stabilization factor for annual current budget funding. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: The fund balance should be maintained at a level of 3 to 5 per cent of tax revenues to provide tax rate stabilization for annual current budgeting purposes. The 2012 Current Budget provided for a transfer in the amount of $2,560,338, to fund current expenditures, and $556,865. to fund capital expenditures from this reserve. With the settlement of OPG assessment appeal in 2007, dividends from Veridian and surplus in 2012; there is sufficient built -up of funds to draw from this reserve for future budgeting years. The 2013 Budget uses $2.7 million from this reserve, leaving a project balance of $13.0 million for 2014. 1. 2. Appendix B Reserve for Development Charges - City Share G/L 7022 Actual Balance December 31, 2011 Transfers into the Reserve: 2012 Excess Surplus Contribution 2012 Budgeted Transfer Transfers out of the Reserve: Transfer to Capital Fund - External Subdivision Works Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve: $ 4,370,874 15.1 Wm (2,683,066) $ 3,165,288 This reserve has been established to set aside funds for projected growth in the City. From the 1999 and the 2004 Development Charges Studies it was approved that a reserve be established for the City's share (i.e. the non - development charge portion) of the costs of services included in the Development Charges Study and that contributions be included in the annual Current Budget for consideration by Council. For the City to meet its obligations for the various capital projects, an annual contribution of $2.4 million is required. The interest incomes on this account forms part of the annual Current Budget General Government Revenue. Recommended Maintenance Levels of this Reserve: Funds continue to be budgeted in the Current Budget to build -up this reserve to fund future capital growth of the City. The draws in the current year were to finance External Subdivision Works. This reserve should be maintained at a level to ensure that the funding is adequate to meet future capital growth in the City. The projected 2013 balance is $1.6 million (net of contributions). 1. Appendix B Reserve for Continuing Studies and Consulting - G/L 7024 Actual Balance December 31, 2011 Transfers into the Reserve: Continuing Consulting Work or Studies Transfers out of the Reserve: Transfers to Revenue Funds - Consulting Transfer to Financial System Reserve Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve: (274,289) (33,635) $ 582,055 446,341 (307, 924) $ 720,472 This reserve was established to capture any unspent annual Current Budget provisions related to consulting, continuing studies, professional and legal fees. Under Generally Accepted Accounting Principles, the approval to expend funds for these efforts ceases at year -end, however work may continue beyond that date. The establishment of this fund enables the transfer of unspent funds into future year and accommodates this frequent timing difference between the approval and the expenditure. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Funds transferred to this reserve will be used to fund the balance of the expenditures still to be incurred for incomplete studies or consulting contracts. 1. Appendix B Reserve for Vehicle Replacement - G/L 7040 Actual Balance December 31, 2011 Transfers into the Reserve: Transfers from Revenue Fund Return to source Transfers out of the Reserve: Transfers to Capital Fund $ 93,722 125,000 13,711 (35,218) Pre -Audit Actual Balance December 31, 2012 $ 197,215 Purpose of this Reserve: This reserve was newly established in 2004 to begin building up funds to finance the cost of replacing the City's aging fleet. The interest income on this account forms part of the annual Current Budget, General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Funds transferred to this reserve will be committed to fund the purchase of new vehicles. Appendix B Reserve - Easement Settlement - G/L 7041 Actual Balance December 31, 2011 $ 17,595 Transfers into the Reserve: Transfers out of the Reserve: Pre -Audit Actual Balance December 31, 2012 $ 17,595 1. Purpose of this Reserve: This reserve was established in 2005 with funds received from easement settlement in February 2005. The amount collected was $2.5 million. These funds were used to finance both the capital and operating expenditures of the City. The interest income on these funds forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. lip Appendix B Reserve - Provision for Eastern Branch Library - GIL 7042 Actual Balance December 31, 2011 Transfers into the Reserve: Revenue Fund Contribution Transfers out of the Reserve Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve: $ 155,000 25,000 $ 180,000 This reserve was established in 2005 to begin building up funds for a new library at the eastern part of Pickering. This provision may be used to fund the new facility, capital cost, resource materials and any other related costs. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Started in 2002, the Library Board requested $10,000 under the Capital Budget for the "Provision for Eastern Branch ". A similar request was made in both 2005 and 2006. It is the intention of the Library Board to annually request for this provision to continue building up funds for the proposed new facility. In 2007, the annual provision has been increased to $25,000. The same amount was provided annually from 2008 to 2012. 1. Appendix B Reserve - Move Ontario - G/L 7043 Actual Balance December 31, 2011 Transfers into Reserve Transfers out of the Reserve: Capital Expenditures -Roads Pre -Audit Actual Balance December 31, 2012 Purpose- of this Reserve: $ 97,483 (56,600) $ 40,883 This reserve was established in 2006 to capture the one -time funding received on March 20, 2006 from the Ontario government, the Ministry of Transportation. The Ontario government was providing a one -time investment to help municipalities primarily outside the GTA, with specific emphasis on rural and northern municipalities and to invest in municipal roads and bridges. Municipalities will determine their own roads and bridges priorities. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Appendix B Reserve - Economic Stabilization - G/L 7045 Actual Balance December 31, 2011 $ 830,000 Transfers to Reserve - Transfers out of Reserve Pre -Audit Actual Balance December 31, 2012 1. Purpose of this Reserve: $ 830,000 This reserve was established in 2009 in order to place a special dividend approved by Veridian. Report to Council CS15 -09 provides background information on the establishment of this reserve. The special dividend will be used to assist the City's budget process during the next few years. For both 2009 and 2010 budgeting years, $405,000 has been drawn per year from this reserve to minimize proposed tax increase. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Appendix B Reserve - Capital Maintenance Management System G/L 7046 Actual Balance December 31, 2011 $ 240,000 Contribution from Revenue Fund - Transfers out of the Reserve: Transfer to Financial System Reserve (240,000) Pre -Audit Actual Balance December 31, 2012 1. Purpose of this Reserve: This reserve was established in 2008 to accumulate funds for asset maintenance and management systems to assist in meeting mandatory Public Sector Accounting (PSAB) requirements and future capital asset management initiatives. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Recommendation 4 c) as per Report to Council CST 03 -12 , provides that funds balance as at December 31, 2012 be transferred to the Financial System Reserve, and the Capital Maintenance Management System Reserve be closed. 1. Appendix B Reserve - Land Purchase - G/L 7047 Actual Balance December 31, 2011 Transfers into Reserve Revenue Fund Contribution Transfers out of Reserve Transfer to Capital Fund Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve: $ 194,403 (95,000) $ 99,403 This reserve was established in 2011 in order to provide funds to meet the expenses incurred related to minor land purchases. This includes purchase of small parcels of land to be used for various City projects such as sidewalks, walking trails, and road improvements. Council approval is required before land can be purchased. Provision was made in the 2011 Current Budget to transfer $200,000 from General Government to this newly created reserve. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. 1 Appendix B Reserve - Seaton Development Review - G/L 7048 Actual Balance December 31, 2011 Transer into Reserve Revenue from Application Fees Transfers out of Reserve Transfers to Revenue Fund - Consulting & Salary $ 2,133, 752 (227,804) Pre -Audit Actual Balance December 31, 2012 $ 1,905,948 Purpose of this Reserve: This reserve was established in 2011 to allow the matching of Seaton Development application fees received prior to 2010 to the costs incurred for this development. As the development process progresses, transfers earmarked through the budget process, will be made to fund staffing and consulting costs related to this development. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. 1. 2. Appendix B Reserve - Financial Systems - G/L 7049 Actual Balance December 31, 2011 $ 175,000 Transfers into Reserve: Revenue Fund Contribution 175,000 Transfer from Reserves (Capital Maintenance & Continuing Studies Reserves 273,635 448,635 Transfers out from Reserve: Transfer to Capital Fund - Taxation Billing System (275,000) Transfer to Revenue Fund -TCA Software (33,988) (308,988) Pre -Audit Actual Balance December 31, 2012 $ 314,647 Purpose of this Reserve: This reserve was established in 2011 in order to build -up funds for the purchase of a new Financial Suite. Recommendation 11 d) as per Report to Council CST 14 -11, provides that any unspent funds budgeted in 2011 for the new Financial Suite be transferred to the Financial System Reserve at year -end of 2011. In 2012, there was a current budget provision in the amount of $175,000 for a New Financial Suite. Annual provision will be made to continue building -up sufficient funds to replace the current outdated Financial System. The interest income on this account forms part of the annual Current Budget General Government Revenue. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. The $275,000 transferred to capital funds was related to the 2012 Budget provision for the Taxation Billing System. The transfer of $33,988 was related to the purchase of the Tangible Capital Asset software budgeted under Current Budget. Appendix B Reserve - New Senior Centre - G/L 7050 (new in 2012) Actual Balance December 31, 2011 $ - Transfer into Reserve: Revenue Fund Contribution 75,000 Transfers out from Reserve: Pre -Audit Actual Balance December 31, 2012 $- 75,000 Purpose of this Reserve: This reserve was established in 2012 as per Report to Council CST03 -12 Recommendation 4 d) in order to build -up funds for the future new Senior Centre. In 2012, there was a current budget provision in the amount of $75,000 for this purpose. Annual provision will be made to continue building -up funds for the proposed new Senior Centre. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. Appendix B Reserve - Accessibility Initiatives - G/L 7051 (new in 2012) Actual Balance December 31, 2011 $ - Transfer into Reserve: Revenue Fund Contribution 13,713 Transfers out from Reserve: Pre -Audit Actual Balance December 31, 2012 $ 13,713 1. Purpose of this Reserve: This reserve was established in 2012 as per Report to Council CST 03 -12, Recommendation 15. This Recommendation provides that any unspent funds from prior year capital accessibility projects be transferred to this newly created "Reserve for Accessibility Initiatives." Funds built -up from this reserve will be directed back to fund future accessibility projects. The interest income on this account forms part of the annual Current Budget General Government Revenue. 2. Recommended Maintenance Levels of this Reserve: There is no recommended maintenance level. 1. ATTACHMENT # =T0 REPORT# FW lo-1-3 Appendix C Reserve Fund -Third Party/Developers Contributions - G/L 7501 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Contributions from Developers/Third Parties Interest Earned on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund: Capital Expenditures: Funding Capita l - Rosebank Road Funding Consulting Duffin Creek Watershed Funding Rosebank Park Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 2,233,978 $ 444,896 46,065 (1,845) 489,116 (9,651) (8,275) (35,000) (52,926) $ 2,670,168 This reserve fund was established by Council pursuant to Section 417(1) of the Municipal Act, 2001. The purpose of this reserve fund is to capture contributions from developers or third parties per development agreements and any cost sharing arrangements for future capital projects. Due to the externally restricted contributions, this reserve fund is treated as obligatory. The collections are committed for specific purposes and not available for general use. Unless specified, the City is under no obligation to pay interest to any developers or third parties. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund No reserve fund limits are appropriate for this fund as the collection and commitment of funds are dependent upon development agreements or cost sharing arrangements. is Appendix C Reserve Fund for Parkland - G/L 7502 Actual Balance December 31, 2011 $ 1,818,119 Transfers into the Reserve Fund: Developers Contributions $ 112,100 Interest Earned on External Investments 39,485 Reserve Fund Management Fee (1,869) 149,716 Transfers out of the Reserve Fund: Transfer to Capital Fund - Parks: Claremont Tennis Courts & Fencing (27,857) Dunmoore Park -South ball diamond & energy efficient lighting (15,870) Rosebank South Park (189,721) Esplanade Park Walkway & Lighting Replacement (300,880) (534,328) Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 1,433,507 This is an "obligatory" reserve fund and it was established pursuant to section 417(1)(2) of the Municipal Act, 2001 as required by subsections 42(1), (5), (6), (7), (8) and (9) of the Planning Act. This fund is governed by legislation, regulation or agreement and requires revenues received for the special purposes to be segregated from the general revenues of the municipality. Obligatory reserve funds must be created whenever a statute requires revenues for a special purpose to be segregated from the general revenues of the municipality and the revenue is to be used solely for the purpose prescribed by statute. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: Due to the obligatory nature of this fund, there are no limits on this fund. The unspent budget commitments for the year ended 2012 are $160,361. The pre -audit balance of $1,433,507 after taking into account the unspent budget commitments will provide an uncommitted balance available of $1,273,146 as at December 31, 2012. Appendix C Federal Gas Tax Reserve Fund - G/L 7505 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Federal Contribution (through AMO) 2,694,431 Interest on External Investments 114,825 Reserve Fund Management Fee (4,883) Transfers out of the Reserve Fund: Current Expenditures Audit Fees (5,597) Capital & Current Expenditures based on green outcome categories: Capacity Building (28,649) Community Energey Savings Local Roads & Bridges Local Roads & Bridges - Vehicles Public Transit (Sidewalks) Water System Pre -Audit Actual Balance December 31, 2012 1. Purpose of this Reserve Fund: $ 4,977,097 2,804,373 (713,572) (679,545) (153,042) (180,444) (3,284) (1,764,133 $ 6,017,337 This reserve fund was established in 2005 to capture the transfer of gas tax revenues from the Government of Canada through the Association of Municipalities of Ontario under the New Deal for Cities and Communities (Canada- Ontario -AMO- Toronto Agreement). The Council had approved under Report to Council CS 92 -05, the establishment of this reserve fund under By -law 6609/05 and Resolution 219/05. This program is not application based and does not require matching funding. Municipalities are allowed to invest in environmental sustainable infrastructure in programs such as public transit, storm water system, local roads and bridges. It comes with the expectation that the investments will see Ontarians enjoying cleaner air, cleaner water and reduced greenhouse gas emissions. The original 2005 Canada - Ontario -AMO- Toronto Agreement was amended on September 3, 2008 in order to extend the municipalities Gas Tax Fund allocations to 2014. Report to Council CS 06 -10 provides detailed background information on the Amending Agreement and By -Law 7030/10 authorized the execution of an Amending Municipal Funding Agreement for the Transfer of Federal Gas Tax Revenues. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(1). 2. Recommended Maintenance Levels of this Reserve Fund: No reserve fund limits are appropriate for this fund. The following table represents the schedule of payments under the 2005 Municipal Funding Agreement: Year July November 2005 $1,347,215.33 $ 849,577.58 2006 $424,788.79 424,788.79 2007 566, 321.81 566, 321.82 2008 707,854.83 707,854.84 2009 1,415,709.67 1,415,709.67 Total $7,078,927.80 The following table represents the schedule of payments over the life of the Amending Agreement: Year July November 2010 $1,347,215.33 $1,347,215.33 2011 $1,347,215.33 $1,347,215.33 2012 $1,347,215.33 $1,347,215.33 2013 $1,347,215.33 $1,347,215.33 Total $10,777,722.64 As at December 31, 2012, this reserve fund has an unspent budget commitment of $2,889,695. Taking into consideration this budget commitment, the pre -audit balance as at December 31, 2012 of $6,017,337 will be reduced to $3,127,642. Appendix C Building Permit Stabilization Reserve Fund - GL 7506 Annual Report - Building Permit Fees for the year ended December 31, 2012 Building Permit Revenue Costs Direct Costs Indirect Costs Excess /(Deficit) Revenue over Costs $ 1,636,117 (1,470,372) (254,871) (1,725,243) Building Permit Stabilization Reserve Fund - GL 7506 $ (89,126) Opening Balance, Jan. 1, 2012 $ - 2012 Contribution Closing Balance, Dec. 31, 2012 $ - 1. Purpose of this Reserve Fund: This reserve fund was officially established in 2006 based on By -Law 6651/06 and Report to Executive Committee PD 41 -05. The need for the establishment of this reserve fund arises as a result of the significant changes to the building regulatory system in Ontario with the introduction of the Building Code Statute Law Amendment Act, 2002 (known as Bill 124) and associated amendments to the Ontario Building Code. The purpose of this fund is to secure funding to provide for service delivery stabilization during an economic downturn. The source of funds will be the annual portion of building code permit fees after related direct and indirect costs are netted. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: Given the rationale for creating a fee stabilization reserve fund, the targeted reserve fund balance should reflect the reduction in permits witnessed during the last recession when compared to the long -run development average — acknowledging the City's responsibility to manage a portion of the costs associated with an economic downturn. Based on the modeled activity based direct costs conducted by CN Watson; the appropriate balance to maintain is proposed at $1.16 million, expected to be achievable within a target of seven accumulated years. As at the year ended 2012, this reserve fund remains at a zero balance. This is due to expenses exceeding building permit fee revenues; therefore, there was no transfer to the Building Permit Stabilization Reserve Fund. The Building Code Act, section 7(4) requires an annual reporting of this reserve fund, on which Report to Executive Committee FIN 12 -13 provided detailed information on the 2012 reporting year. 1. Appendix C Reserve Fund for Development Charges - G/L 7600 Actual Balance December 31, 2011 $ 34,107,294 Transfers into the Reserve Fund: Net Developer Contributions $ 3,417,020 Interest Earned on External Investments 737,551 Interest Earned on Internal Loans 35,726 Reserve Fund Management Fee (36,339) 4,153,958 Transfers out of the Reserve Fund: Transfer to Current Fund - Studies (43,372) Transfer to Capital Fund (731,868) (775,240) Pre -Audit Actual Balance December 31, 2012 $ 37,486,012 Purpose of this Reserve Fund: This is an "obligatory" reserve fund and as such is governed by Municipal Act 2001, Development Charges Act, 1997, Ontario Regulation 82198, City By -law or agreement and requires revenue received for the special purposes to be segregated from the general revenues of the municipality. Obligatory reserve funds must be created whenever a statute requires revenue received for a special purpose to be segregated from the general revenues of the municipality and the revenue is to be used solely for the purpose prescribed by statute, i.e. in this case the monies charged to developers must be held and used to fund capital services and related background studies required for new growth. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: In accordance with development charge legislation, all development charge revenues must be held within separate Reserve Funds and can only be used for the financing of growth- related projects. As such, no reserve fund limits are appropriate for the Development Charge Reserve Funds because they are tied to growth- related capital requirements. This reserve fund has an unspent budget commitment of $6,941,753. The pre - audit actual balance of $37,486,012 will be reduced by this amount to reflect an uncommitted balance of funds available for future expenditures of $30,544,259. Appendix C Reserve Fund for Community Facilities - GIL 7700 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Interest Earned on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund: Transfer to Capital Fund Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 148,547 3,067 (146) 2,921 $ 151,468 This is a "discretionary" reserve fund established by Council to attempt to avoid both tax rate fluctuations and the need for issuing long term debt for major expenditures required for community facilities. The interest income on this reserve fund forms part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: The balances in this fund have fluctuated from the high in 1998 of $773,483 to the low in 2001 of $69,102. Other than interest income earned, there has been no transfer to this reserve fund in the last ten years. 1. Appendix C Reserve Fund for Capital Works - GIL 7701 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Interest Earned on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund $ 377,057 7,618 (369) Pre -Audit Actual Balance December 31, 2012 $ 384,306 Purpose of this Reserve Fund: This Fund is a "discretionary" one and was established pursuant to section 417(1) (2) of the Municipal Act, 2001 for specified purposes by Council related to the acquisition of assets. The interest income on this reserve fund forms part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: Between the years of 1998 to 2000, the balances have been maintained at $600,000 to $800,000. The average balance from 2001 to 2003 declined to $515,000 and since then it has further declined to an average of $350,000 per year. This is largely due to no major contribution to this reserve fund in the past ten years. Further contributions will be required in future years. 1. Appendix C Reserve Fund for Public Works - G/L 7702 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Third Party Contributions Interest Earned on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund: Glenanna Road Resurfacing Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 2,095 21,773 (1,054) $ 1,074,373 22,814 (3,796) $ 1,093,391 This fund was established by Council pursuant to section 417(1) (2) of the Municipal Act, 2001. The purpose of the reserve fund is to acquire fixed assets, to fund capital works related to public property, without the need to fund on a long -term nature through the issue of debentures. The main purpose at this time is to fund the City's share of the cost of subdivision works committed to under various subdivision agreements. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: The "average" annual balance of this fund over the last four years has been approximately $1 million. This reserve fund should be kept at least at this level in the future. Staff will periodically review the need for this level with the requirements contained in the capital budget and four year program and report any different findings to Council. Appendix C Squash Funds Reserve Fund - G/L 7704 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Surcharge on Memberships Interest on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund: Recreation Centre Expansion & Squash Courts Pre -Audit Actual Balance December 31, 2012 1. Purpose of this Reserve Fund: 5,266 20 (39) 5,247 (3,159) $ 2,088 This reserve fund was established to capture funds from Pickering Squash Club memberships' surcharges, corporate sponsorships, third party contribution and any such funds as the Council may approve. This reserve fund shall be used for the purpose of paying expenses related to the provision of double squash courts. This reserve fund was newly created in 2003 further to the recommendation passed in Council Resolution #79/03, Item 5 per Report to Council CS 40 -03. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: No reserve fund limits are appropriate for this fund. There was a commitment of $200,000 from this reserve fund towards the construction of the double squash courts at the Pickering Recreation Complex. The construction of the double squash courts was completed in September 2009. The majority of the funds received from the inception of this reserve fund to 2012, plus interest income earned have been used to fund part of this project. 2012 is the final year where the outstanding amount from the original $200,000 commitment was fully paid. 1. 2. Appendix C Reserve Fund for Workers Safety Insurance Board (WSIB) - GIL 7705 Actual Balance December 31, 2011 $ 2,374,028 Transfers into the Reserve Fund: Contribution from Current Fund Interest Earned on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund: Claims and Other Related Costs Funding Insurance Costs Contribution to Health & Safety Training Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 516,869 52,229 (2,718) 566,380 $ (250,393) (130,155) (27,311) (407,859) $ 2,532,549 This reserve fund has been established to provide for the annual costs of insurance coverage, contributions towards the health and safety program, and the payment of claims and other related costs now that the City is a Schedule 2 employer. This reserve fund was created in 2001 further to the recommendation passed in Council Resolution #127/01 and in compliance with Workplace Safety & Insurance Act. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). Recommended Maintenance Levels of this Reserve Fund: Starting from 2004 and continuing to 2012, the contributions were more than double the claims.experienced for the year, resulting to a built -up in the balance of the reserve fund to assist in offsetting future claims. As Schedule 2 operates on the self- insured principle, any anticipated savings between contributions and claims experience will be transferred to this reserve fund to build -up the fund balance in the event of any catastrophic claim - related costs, which may occur. The average annual built -up of approximately $263,000 from 2003 to 2012 has resulted in the 2012 year -end balance of approximately $2.5 million. 1. 2. Appendix C Animal Shelter Reserve Fund - G/L 7706 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Revenue Fund Contribution Donations Interest on External Investments Reserve Fund Management Fee Transfers out of the Reserve Fund Pre -Audit Actual Balance December 31, 2012 Purpose of this Reserve Fund: $ 196,370 25,000 3,516 4,215 (218) 32,513 0 - $ 228,883 This reserve fund was established in 2007 based on By -law 6749/07, Report to Council CS 16 -07, Recommendation 9. This reserve fund was established to record the City's share of the proceeds resulting from the dissolution and disposition of the assets of Pickering, Ajax, Whitby Animal Services (PAW). With the establishment of this reserve fund, financial resources received and provided can be used to construct a permanent animal shelter. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). Recommended Maintenance Levels of this Reserve Fund: No reserve fund limits are appropriate for this fund. The main contribution to this reserve fund was the proceeds of $144,433 from PAW in 2007. The balance of funds is from revenue funds contribution, donations and interest income earned. 1. Appendix C Pickering Men's Slow Pitch Reserve Fund - G/L 7707 Actual Balance December 31, 2011 Transfers into the Reserve Fund: Contribution from Men's Slow Pitch League - Interest on External Investments 2,803 Reserve Fund Management Fee (136) Transfers out of the Reserve Fund $ 138,985 2,667 Pre -Audit Actual Balance December 31, 2012 $ 141,652 Purpose of this Reserve Fund: This reserve fund was established at the end of 2007 based on By -Law 6822/07, Report to Council CS 58 -07. This reserve fund was established to receive donations from the Pickering Men's Slow Pitch League, for safekeeping of donated funds and further application of funds towards a major softball facility. Report to Council OES 43 -07 provides detailed information on the memorandum of understanding between the City and the Pickering Men's Slow Pitch League. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: No reserve fund limits are appropriate for this fund. In 2008, the City received the financial contribution of $125,000 from the Pickering Men's Slow Pitch League. The built -up of funds available as at December 31, 2012 in the amount of $141,652 is largely from interest income earned from the original financial contribution. is Appendix C Operations Centre Reserve Fund - G/L 7708 Actual Balance December 31, 2011 $ 412,365 Transfers into the Reserve Fund: Interest on External Investments 7,596 Reserve Fund Management Fees (403) 7,193 Transfers out of the Reserve Fund: - Consulting & Legal Fees - Pre -Audit Actual Balance December 31, 2012 $ 419,558 Purpose of this Reserve Fund: This reserve fund was established to deposit net proceeds from the sale of land in the area known as Duffin Heights and other funds as may be approved by Council. The net proceeds will be used to finance costs associated with the establishment of the new Operations Centre. These include costs for disposal and acquisition of land, legal fees, surveys, soil testing, engineering design, construction costs, debt charges and, if available any equipment and furniture required for the facility. This reserve fund was established in 2009 under Report to Council CS 15- 09 Recommendation 9 a) and as approved by By -Law No. 6954/09. The interest incomes on these funds form part of the reserve fund as per the Municipal Act, 2001 section 417(3). 2. Recommended Maintenance Levels of this Reserve Fund: No reserve fund limits are appropriate for this fund. A parcel of land was sold in 2011. Related consulting and legal fees incurred were funded from the proceeds of this sale. The balance of the funds available as at December 31, 2012 have been committed as follows: Duffin Heights roads cost sharing agreement ($317,000), and consulting and legal fees ($95,000). There are thus no more discretionary funds available from this reserve fund.