Loading...
HomeMy WebLinkAboutFIN 12-23 Report to Council Report Number: FIN 12-23 Date: June 26, 2023 From: Stan Karwowski Director, Finance & Treasurer Subject: Annual Treasurer’s Statement Report – Summary of Activity for the Year Ended December 31, 2022 - File: F-4920-001 Recommendation: 1. That Report FIN 12-23 of the Director, Finance & Treasurer entitled “Annual Treasurer’s Statement Report: Summary of Activity for the Year Ended December 31, 2022” as required by the Development Charges Act and Planning Act be received for information; 2. That the City of Pickering’s “Annual Treasurer’s Statement Report” be made available to the public on the City of Pickering’s website; and 3. That the appropriate City of Pickering officials be authorized to take the necessary actions as indicated in this report. Executive Summary: Development Charges (DC) are collected by the City for the sole purpose of funding necessary infrastructure for new residents and businesses. All DC funds collected can be used only for the purpose in accordance with the Development Charges Act, 1997 (DCA). These funds are collected so that existing property owners are not unduly burdened by the cost of growth related infrastructure. The attached DC Statements are being provided for information in accordance with requirements of the DCA. The purpose of this report and associated statements is to ensure that all transactions related to development charges have been correctly accounted for and reported, as stipulated under the DCA. Section 43 of the DCA requires that the Treasurer provides Council with a financial statement relating to the Development Charges By-law and reserve fund established for each service as established under Section 33 of the DCA. Attachment 1 provides pre-audit details of the activity of the Development Charges Reserve Fund (DCRF) for the year ended December 31, 2022 in the manner prescribed by Section 43(2)(a) of the DCA. Attachment 2 provides pre-audit details on information related to assets funded by the development charges by-law as stipulated by Section 43(2)(b) of the amended DCA. Section 42 under the Planning Act, requires the Treasurer of the municipality to provide Council with a statement relating to the status of the cash -in-lieu of parkland reserve fund. This requirement is a result of the passage of Bill 73, Smart Growth for our Communities Act. FIN 12-23 June 26, 2023 Subject: Annual Treasurer’s Statement Report – Summary of Activity Page 2 for the Year Ended December 31, 2022 Section 37 under the Planning Act, requires the Treasurer of the municipality to provide Council with a statement relating to the increases in height and density of development. Under City’s By-law No. 7590/17 and 7954/22, these reserve funds were established as the Public Benefits Reserve Fund and Community Benefit Charges Reserve Fund, respectively. Legislation requires Council to ensure that these statements are made available to the public. These statements will be posted on the City’s website to facilitate compliance with the amendment. Financial Implications: During the three-year period from 2020 to 2022, the approximate DC collected were $12.49 million in 2020, $9.12 million in 2021 and $14.07 million in 2022. The City saw an increase of DC collections of approximately 54% from 2021 to 2022. The increase is due to the high growth phase that the City is currently in, with the prioritization of intensification and growth in Seaton. Before the passage of Bill 23, the City was expecting consistent DC collection increases due to the current growth phase. However, with Bill 23’s DC fee reductions and exemptions, the City may not reach the expected revenue targets. Attachment 1 provides a breakdown of the various DC service cat egories. Two of the service categories are in a negative position (before commitments) due to DC funding for the new Operations Centre and the new financial system. The negative balances will be addressed through DC fees collected from current growth related activity, as these negative balances were included in the 2022 DC Background Study. However, it will take longer for these categories to reach a positive balance due to the DC fee reduction legislated by Bill 23. The overall positions of the Development Charges Reserve Fund for the period of 2017 to 2022 is presented below. Development Charges Reserve Fund Summary – 2016 to 2022 2017 ($) 2018 ($) 2019 ($) 2020 ($) 2021 ($) 2022 ($) Opening Balance 43,318,105 48,100,585 58,789,415 62,598,255 69,376,247 77,078,827 Collections 5,311,744 13,033,850 7,386,544 12,492,201 9,118,065 14,067,449 Net Transactions incl. Use of Funds (529,264) (2,345,021) (3,577,704) (5,714,209) (1,415,485) (6,915,371) Ending Balance 48,100,585 58,789,415 62,598,255 69,376,247 77,078,827 84,230,905 Budget Commitments (18,392,441) (19,089,535) (27,144,954) (36,469,498) (60,687,888) (64,143,674) End Bal After Budget Commitments 29,708,144 39,699,880 35,453,301 32,906,749 16,390,939 20,087,231* * If you include the City Centre project (approved in 2020) the ending balance commitment is in a deficit position ($44,217,445) FIN 12-23 June 26, 2023 Subject: Annual Treasurer’s Statement Report – Summary of Activity Page 3 for the Year Ended December 31, 2022 The City Centre project was introduced in 2020 with a DC funding commitment of approximately $90.1 million. If we exclude the City Centre project from the budget commitments, both the 2020 to 2022 DC fund balances would be in a net positive positon. The Treasurer’s Statement for the Parkland, Public Benefits and Community Benefit Charges Reserve Funds as required under the Planning Act is as follows: Parkland ($) Public Benefits ($) Community Benefit Charges ($) Open Balance January 1, 2022 8,563,353 265,147 0 Revenues Developer/Third Party Contributions 178,210 0 0 Interest Income 136,814 4,104 0 Total Revenue 315,024 4,104 0 Expenses Transfers to Capital Fund (3,028,150) 0 (5,671) Net Change for the Current Year (2,713,126) 4,104 (5,671) GL Bal. before commitments December 31, 2022 5,850,227 269,251 (5,671) Budget Commitments 2022 & Prior (2,695,722) (269,251) (4,131) Funds Balance after Budget Commitments 3,154,505 0 (9,803) Amendments were made to the Planning Act in 2020 with the passage into law of Bill 197 – COVID-19 Economic Recovery Act. This bill allows municipalities to impose a Community Benefit Charge (CBC), which will allow single-tier and lower-tier municipalities to collect fees from developer’s (on top of Development Charges and Parkland Dedication) to pay for capital costs of community facilities and administrative studies. The CBC can only be imposed if a development/redevelopment requires a passing of zoning by-law (or an amendment) under Section 34 of the Planning Act, the approval of a minor variance under Section 45 or an approval of a plan or subdivision under Section 51. However, a CBC would not be imposed if the development is less than 5 -storeys or less than 10 residential units. The City has concluded its CBC Strategy and the CBC by-law was passed on July 11th, 2022 (Resolution #7954/22). The CBC replaces the current Public Benefits Reserve Fund under Section 37 (increased density allocations). The residual funds remaining in the Public Benefits Reserve Fund have been committed to ongoing capital projects and the Reserve Fund will be closed upon completion of these projects. FIN 12-23 June 26, 2023 Subject: Annual Treasurer’s Statement Report – Summary of Activity Page 4 for the Year Ended December 31, 2022 Discussion: Funds are not transferred out of the DC Reserve Fund for projects until the funds are actually needed, as required by applicable accounting rules. This ensures that the reserve fund continues to earn interest income on the unspent monies until such time as actual expenses are incurred. The total pre-audit reserve fund balance of $84.2 million represented in Attachment 1 represents the unspent monies as at December 31, 2022. Please note that there are approximately $128.5 million of committed capital projects, ongoing studies, and financial obligation that have been approved in prior years, but have not proceeded or are still ongoing as at December 31, 2022. Of the $128.5 million in commitments, approximately 61 percent or $78.2 million are related to the City Centre projects ($64.3 million) and the Pickering Heritage Community Centre ($13.9 million). However, when you consider the 401 Bridge and Road Crossing project and its current estimated projected cost, sometime in the near future, there is a possibility that all of the DC components will be in a deficit position. Having various DC components in a deficit position is not unusual when you consider that the City is now transitioning from a moderate to a higher growth scenario due to Seaton and downtown area intensification. As presented in Attachment 1, there is approximately $18.7 million in outstanding debenture commitments across three service categories. These debenture commitments are for three capital projects: New Operations Centre ($10.1 million), construction of Fire Station #1 ($7.7 million) and purchase of land in north Seaton for a new Fire Station ($0.9 million). The terms of these debentures range from 10-years to 20-years, with the most recent debenture being for the construction of Fire Station #1 being undertaken in 2021. The total projected net deficit position after all budget expenditures, was approximately $44.2 million for the year-ended December 31, 2022. In order to meet the new requirements under Section 43(2.1) of the amended DCA and Section 37 and 42 of the Planning Act, it is recommended that these statements be placed on the City’s website upon approval by Council. Attachments: 1. 2022 Statement of the Treasurer – Development Charges Reserve Fund (Pre-Audit) 2. Amount Transferred to Assets – Capital & Current Funds Transactions (Pre-Audit) FIN 12-23 June 26, 2023 Subject: Annual Treasurer’s Statement Report – Summary of Activity Page 5 for the Year Ended December 31, 2022 Prepared By: Approved/Endorsed By: Original Signed By: Original Signed By: Jason Bekramchand, CPA Stan Karwowski, CPA, CMA, MBA Senior Financial Analyst – Capital & Director, Finance & Treasurer Debt Management Recommended for the consideration of Pickering City Council Original Signed By: Marisa Carpino, M.A. Chief Administrative Officer Attachment #1 to Report FIN 12-23 City of Pickering 2022 Statement of the Treasurer - Development Charges Reserve Fund - (Pre Audit)DC Act S 43 (2)(a) For the year ended December 31, 2022 (with City Centre) Services to which the Development Charges Relates Account 8601 8602 8603 8604 8605 8606 8607 8608 Description Fire Protective Services Transportation Other Services Related to a Highway (Deficit) Storm Water Mgmt Studies (Deficit)Parks & Recreation Library: Facilities & Materials By-Law Services Enforcement Total $ $$$$$$$$ Opening Balance, January 1, 2022 2,934,491 34,925,315 (951,687)4,008,668 (1,536,044)31,877,563 5,820,521 0 77,078,827 Plus: Development Charges Collections 1,048,739 2,141,153 541,420 349,443 324,345 8,244,056 1,401,501 16,792 14,067,449 Interest Income-Internal Investment 240 2,852 - 327 - 2,603 475 - 6,497 Interest Income-Negative Balance 3,487 41,498 (41,379) 4,763 (53,162) 37,877 6,916 - 0 Interest Income -External Investment 60,142 613,754 - 71,287 - 626,278 113,166 163 1,484,791 Less Admin Fee (3,383) (35,204) - (4,091) - (35,208) (6,378) (8) (84,272) Sub-Total 1,109,225 2,764,053 500,041 421,729 271,183 8,875,607 1,515,681 16,946 15,474,465 Less: 2022 Transfer to Capital Funds 1 (253,086) (5,201,277) (464,872) (71,783) (62,894) (750,918) (88,354) (13,326) (6,906,510) 2022 Transfer to Current Funds 1 (519,852) 3 - (478,387) 3 (3,613) (151,027) (262,998) 3 - - (1,415,877) Sub-Total 2022 (772,938) (5,201,277) (943,259) (75,396) (213,921) (1,013,916) (88,354) (13,326) (8,322,387) Closing Balance, December 31, 2022 before Budget Commitments 3,270,777 32,488,091 (1,394,904)4,355,002 (1,478,782)39,739,253 7,247,848 3,620 84,230,905 Less Budget Commitments 2 (2,515,251) (12,769,081) (1,548,523) (4,062,857) (634,506) (62,931,250)(22,381,753)(2,919,988) (109,763,208) Less Debt Chrgs Commitments 4 (8,589,862) - (6,182,416) - - (3,912,864) - - (18,685,142) Sub-Total Budget Commitments (11,105,113) (12,769,081) (7,730,938) (4,062,857) (634,506) (66,844,114) (22,381,753) (2,919,988) (128,448,350) Closing Balance, December 31, 2022 after Budget Commitments-(Deficit)(7,834,335) 19,719,010 (9,125,843) 292,144 (2,113,288) (27,104,861) (15,133,904) (2,916,368) (44,217,445) Notes 1. See Attachment 2 for detailed breakdown. 2. Budget commitments include capital projects previously approved, but have not proceeded or still ongoing. 2022 & Prior Commitments. 3. Annual principal & interest payment related DC debenture financing 4. Includes outstanding principal & interest payments related to DC debenture financing The Municipality is compliant with s.s.59.1(1) of the Development Charges Act,whereby charges are not directly or indirectly imposed on development nor has a requirement to construct a service related to development been imposed, except as permitted by the Development Charges Act or another Act. 1 of 4 Attachment #2 to FIN 12-23 City of Pickering Amount Transferred to Assets - Capital & Current Fund Transactions (Pre-Audit)DC Act S 43 (2)(b) For the year ended December 31, 2022 DC Recoverable Cost Share Non - DC Recoverable Cost Share Description Project Code Gross Capital Costs DC RF 5: Funded in prior years DC RF 5: Funded in 2022 DC RF 5: Future Funding 1 Other Reserves/Re serve Funds Type of Funds (R=Reserve, RF=Reserve Fund) Property Taxes Other Sources Type Total Funding Development Related Studies New Financial System C10600.1801 5,000,000 1,421,257 62,894 472,349 1,743,500 R-Rate Stabilization 1,300,000 R-Financial System 5,000,000 Comprehensive Zoning By-law Review-Phse 1 to 3 10105-502230 371,389 165,830 48,112 36,746 120,701 371,389 Northeast Pickering OPA - Background studies 10105-502230 566,053 38,745 125,410 401,898 Third Party Contribution 566,053 DC Bylaw and new Community Benefit Charge (CBC) Bylaw 10600-502230 77,205 13,034 64,171 0 77,205 Sub-total Studies 6,014,647 1,600,121 213,921 634,506 1,743,500 - 120,701 1,701,898 6,014,647 Fire Protection Services Seaton- New Fire Hall-Site Preparation, Other Construction Related CostC10700.1601 1,066,290 316,874 14,002 533,777 201,637 R-DC City's Share 1,066,290 FS #1 New Fire Station & HQ (Seaton) Bunker Gear & Breathing Apparatus Equipment C10700.1901/2008/ 2102/2201 442,453 117,970 136,600 187,883 442,453 Aerial Ladder Truck (Seaton Fire Station #1) - New - Aerial Ladder Truck for Seaton Fire Station A (98/02) (5340 Fire Services)C10700.1903 1,510,641 58,151 895 1,414,082 37,513 RF - Seaton Land Grp FIA 1,510,641 Seaton FS#1- New Fire Station & H.Q.Re-design - Design and other consulting fees for new fire station serving Seaton. C10700.2007 445,000 291,753 78,133 63,990 11,125 R-DC City's Share 445,000 FS #1 New Fire Station & HQ (Seaton) - Construction DC Debt (debt charges)11100 8,136,830 73,479 403,613 7,659,738 2 8,136,830 Small Vehicle (Seaton Fire Station A) - New C10700.2105 55,000 - 53,625 1,375 Third Party Contribution 55,000 FS #1 New Fire Station & HQ (Seaton) - FF&E C10700.2107 356,160 - 19,984 226,366 109,810 RF - Seaton Land Grp FIA 356,160 Fire Hall Technology - Seaton C10405.2101 40,000 - 3,473 35,527 1,000 RF - Seaton Land Grp FIA 40,000 Seaton North FS - Land (Debt charges)11100 1,166,324 119,961 116,239 930,124 2 1,166,324 Sub-total Fire Services 13,218,698 978,187 772,938 11,105,113 361,085 0 1,375 13,218,698 By-Law Enforcement Services Animal Shelter - Design & Construction C10430.2101 9,739,000 6,914 13,326 2,919,988 6,798,772 RF - Animal Shelter, R-City's Share, RF-CBC 9,739,000 Sub-total By-Law Enforcement Services 9,739,000 6,914 13,326 2,919,988 6,798,772 0 0 9,739,000 Transportation BR-1 Third Concession Road - Brock Road to 425m East (T/L) . Reconstruction/Urbanization including sidewalk and multi-use trailC10575.1101 1,576,525 350,987 0 43,788 374,750 R-City's Share & RF-FGT 1,000 806,000 Debt 15-Yr 1,576,525 B-29 Sandy Beach Road - EA, Design, Construction C10575.1609 5,895,000 163,318 0 2,784,182 2,647,500 R-AIP & R-DC City's Share 300,000 Loan 10-Yr 5,895,000 Walnut Lane Extension Study & EA and Detail Design (related to TC-26, TC-27, TC-28) C10575.1801 7,011,526 214,093 102,488 4,942,063 1,752,882 R-DC City's Share 7,011,526 DH-4 Valley Farm Road - Road Oversizing - DH-4 Valley Farm Road - Oversizing local to collector- Tillings Road to Brock Road (90:10).C10575.1804 288,000 48,768 43,081 167,351 28,800 R-DC City's Share 288,000 B-29 Sandy Beach Rd. - Road Reconstruction Phase 1 - Sandy Beach Road reconstruction and storm sewer installation - Bayly Street to Montgomery Park Road (50/50). Multi-year project. Phase 1 to include replacement of Krosno Creek cross road culvert and associated works, and utility relocation.C10575.1904 2,000,000 - 0 1,000,000 1,000,000 R-DC City's Share 2,000,000 Purchase of Part Lot 21, Concession I, Pickering, being part of PIN 26330-0186 (LT) from Metrolinx, including land transfer tax and related disbursements (75:25). C10600.2001 806,622 604,966 0 0 0 201,655 Third Party Contribution 806,622 2 of 4 Attachment #2 to FIN 12-23 City of Pickering Amount Transferred to Assets - Capital & Current Fund Transactions (Pre-Audit)DC Act S 43 (2)(b) For the year ended December 31, 2022 DC Recoverable Cost Share Non - DC Recoverable Cost Share Description Project Code Gross Capital Costs DC RF 5: Funded in prior years DC RF 5: Funded in 2022 DC RF 5: Future Funding 1 Other Reserves/Re serve Funds Type of Funds (R=Reserve, RF=Reserve Fund) Property Taxes Other Sources Type Total Funding B-26B A-11 (Plummer Street)C10575.2001 364,045 - 0 273,033 91,012 R-DC City's Share 364,045 Highway 401 Road Crossing Design C10575.2002 3,478,460 14,043 4,470 1,581,580 1,391,384 Third Party Contribution 486,984 Loan 2-Yr 3,478,460 Hwy 401 Road Crossing - Land Acquisition - Phase 1 C10575.2004 5,000,000 1,116,222 0 133,778 1,250,000 RF- Roads & Bridges 2,500,000 Third Party Contribution 5,000,000 Hwy 401 Road Crossing - Land Acquisition - Phase 2 C10575.2004 10,934,876 - 4,966,534 9,698 4,373,950 Debt-20 Yr 1,584,694 Loan 2-Yr 10,934,876 City Dev Projects-DCRF committed 1,236,300 - 618,150 4 618,150 R-DC City's Share 0 1,236,300 Sidewalks W0-2,WO-10 Kingston Rd & Altona C10515.1603/1801/1802 698,374 - 58,626 248,418 391,330 R-DC City's Share 0 698,374 1 Ton Dump Truck with Aluminum Body, Plow and Salter - New (Seaton) (2)C10315.2113 225,149 - 0 225,149 225,149 Scarborough/Pickering Townline Road Reconstruction - Finch Ave. to CPR Crossing - RP-14C10570.2207 1,005,300 - 10,939 491,711 305,150 R-DC City's Share 197,500 Third Party Contribution 1,005,300 DH-3 Tillings Road - Road Oversizing C10575.1803 294,800 15,140 250,180 29,480 R-DC City's Share 294,800 Sub-total Transportation 40,814,977 2,512,396 5,201,277 12,769,081 14,254,388 1,000 6,076,833 40,814,976 Stormwater Management B-20 D Krosno Creek SWM Facility Design & Construction C10575.1904 2,280,400 - 1,094,592 1,185,808 R-DC City's Share 2,280,400 Breezy Drive/Sunrise Ave. Storm Sewer Outfall Reconstruction C10575.1903 1,446,300 21,740 3,122 336,713 1,084,725 R-DC City's Share 1,446,300 Installation of Oil Grit Separators - Installation of Oil Grit Separators Frenchman's Bay (28/72)C10575.1903 300,900 - 0 85,310 215,590 R-DC City's Share 300,900 Krosno Creek Culvert Replacements & Erosion Control Construction (B-32a,b,c & B-15) - B-32a,b,c Krosno Creek Culvert Replacements & B-15 Krosno Creek Erosion Control (52/48)C10575.1910 4,800,000 - 68,661 2,235,339 2,496,000 R-DC City's Share 4,800,000 Installation of Oil Grit Separators - Frenchman's Bay C10575.2203 349,000 99,000 250,000 R-DC City's Share 349,000 City Centre Storm Water Mgmt Strategy 10510-502230 249,156 18,442 2,033 203,765 24,916 R-DC City's Share 249,156 Pine Creek Erosion Assessment Municipal Class EA Study 10510-502230 76,524 - 1,580 8,139 66,805 76,524 Sub-total Stormwater Management 9,502,280 40,183 75,396 4,062,857 5,257,039 9,502,280 Other Services Related to a Highway Sidewalk Plow with Attachments - New C10305.2004 172,477 0 172,477 0 0 172,477 5 Ton Dump Truck with Plow and Wing - New (Seaton) (5319 Roads Equipment)C10315.2006 292,395 0 292,395 0 0 292,395 Front Plow and Wing Attachments for Seaton - New C10315.2106 40,000 0 0 40,000 0 40,000 4 Ton Dump Truck with Snow Plow & Wing C10315.2205 330,000 0 0 330,000 0 330,000 5 Ton Dump Truck with Snow Plow & Wing C10315.2222 350,000 0 0 350,000 0 350,000 4 Ton Dump Truck with Snow Plow, Wing & Brine Tank (2)C10315.2223 660,000 0 0 660,000 0 660,000 City Centre Transportation Master Plan 10500-502230 261,727 0 67,031 168,523 0 26,173 261,727 Operations Centre-Debt Charges 61% of total debt charges 11100 8,279,058 1,685,287 411,356 6,182,416 2 0 8,279,058 Sub-total 10,385,657 1,685,287 943,259 7,730,938 0 10,385,657 3 of 4 Attachment #2 to FIN 12-23 City of Pickering Amount Transferred to Assets - Capital & Current Fund Transactions (Pre-Audit)DC Act S 43 (2)(b) For the year ended December 31, 2022 DC Recoverable Cost Share Non - DC Recoverable Cost Share Description Project Code Gross Capital Costs DC RF 5: Funded in prior years DC RF 5: Funded in 2022 DC RF 5: Future Funding 1 Other Reserves/Re serve Funds Type of Funds (R=Reserve, RF=Reserve Fund) Property Taxes Other Sources Type Total Funding Parks & Recreation Services Indoor Soccer Facility and Land - Design & Construction of Indoor Soccer FacilityC10220.1401 7,296,605 3,369,586 0 114,543 78,375 R-DC City's Share 101 3,734,000 Debt 15-Yr 7,296,605 Duffin Heights Village Green (East)-New C10320.1708 190,000 5,670 0 161,055 23,275 190,000 Duffin Heights Neighbourhood Park Construction C10320.1808 600,000 18,350 1,316 506,834 73,500 R-DC City's Share 600,000 Seaton (P103) Village Green Construction C10320.1816 210,000 - 0 184,275 25,725 RF-FIA 210,000 Seaton (P-102) Neighbourhood Park Construction C10320.1819 924,532 804,723 8,865 0 110,944 RF-FIA 924,532 Village Green Seaton P-114 (88/12)C10320.1909 222,000 - 0 194,805 27,195 RF-Parkland 222,000 Seaton Parks P-123, P-112, P-113, P-126, P-127, P-121 C10320.2023-2025, 2118, 2119, 2205 4,158,932 - 3,749,386 409,546.00 RF-Seaton FIA 4,158,932 Pickering Heritage & Community Ctr (Design)-Community Ctr component C10220.2011 1,503,779 125,924 26,828 46,032 753,943 4 R-Rate Stabilization: $693K RF-DC City's Share: $61K 551,052 RF-DC Library Facilities 1,503,779 PHCC Project Management C10220.2011 450,000 - 42,630 76,500 4 R-DC City's Share 330,870 Grant-Fed: $300k RF-DC Library Facilities: $30,870 450,000 PHCC - Construction C10220.2011 29,080,000 - 16,843 7,976,857 5,694,400 4 RF-DC Library Facilities 15,391,900 Grant-Fed: $4.0M Debt 20-Yr: $11.39M 29,080,000 Rotary Frenchman's Bay West Park Waterfront Master Plan C10320.1912 2,730,488 44,801 218,886 1,101,557 1,365,244 R-DC City's Share 2,730,488 Rotary Frenchmans Bay West-Accessibility C10320.1913 1,426,819 34,264 379,572 299,574 713,409 R-DC City's Share 1,426,819 Seaton Community Centre - Preliminary Planning, Investigations & Design C10260.2101 150,000 - 0 138,450 11,550 RF-Seaton FIA 150,000 Skate Board Park - West Shore C10320.2124 200,000 - 98,608 1,392 100,000 R-DC City's Share 200,000 Skate Board Park - Community Size - Design & Construction C10320.2134 920,000 2,798 0 457,202 460,000 R-DC City's Share 920,000 Operations Centre - DC Debt Charges, 39% of total debt charges 11100 5,253,341 1,077,478 262,998 3,912,864 2 - 5,253,341 Performing Arts Centre C11100.2001/ C10225.2201 64,640,000 284,524 0 12,404,476 51,951,000 Debt-25 Year 64,640,000 Senior & Youth Centre C11100.2003/ C10265.2201 41,290,000 679,818 0 35,552,182 5,058,000 Debt-25 Year 41,290,000 Sub-total 161,246,496 6,447,936 1,013,916 66,844,114 9,923,606 101 77,016,822 161,246,495 Library Facilites & Materials Pickering Heritage & Community Ctr (Design)-Archive Facility component C10220.2011 0 358,398 76,357 116,297 3 (551,052)4 RF-DC Library Facilities 0 PHCC Project Management C10220.2011 0 - 0 30,870 3 (30,870)4 RF-DC Library Facilities 0 PHCC Archives & Library Space - Construction C10220.2011 0 - 11,997 5,682,403 3 (5,694,400)4 RF-DC Library Facilities 0 Outreach Vehicle C10900.2109 220,000 - 0 198,000 22,000 R-Vehicle Replacement 220,000 Seaton Regional Library - Schematic Design C10905.2101 25,000 - 0 6,465 18,535 RF-Seaton FIA 25,000 New Central Library-Consulting, Construction & Landscaping costs C11100.2002/C109 00.2201 39,884,000 434,283 16,347,718 23,102,000 Debt-25 Year 39,884,000 Sub-total 40,129,000 792,681 88,354 22,381,753 (6,235,787)23,102,000 40,129,000 4 of 4 Attachment #2 to FIN 12-23 City of Pickering Amount Transferred to Assets - Capital & Current Fund Transactions (Pre-Audit)DC Act S 43 (2)(b) For the year ended December 31, 2022 DC Recoverable Cost Share Non - DC Recoverable Cost Share Description Project Code Gross Capital Costs DC RF 5: Funded in prior years DC RF 5: Funded in 2022 DC RF 5: Future Funding 1 Other Reserves/Re serve Funds Type of Funds (R=Reserve, RF=Reserve Fund) Property Taxes Other Sources Type Total Funding Grand Total 291,050,754 14,063,705 8,322,387 128,448,350 32,102,603 168,291 107,898,928 291,004,264 Notes 1 Projects ongoing. Future funding for incomplete component. DC RF will be drawn when expenses are incurred. 2 DC Costs relates to Debt charges undertaken for the projects 3 Presented as in/out to show funding from "Library Facilities". Total costs and sources of funds presented in "Parks & Recreation". 4 Amount presented relates to DC RF budget commitments only, combined 7 projects. No expenses in 2022. 5 Development Charges Reserve Fund (DC RF)