Loading...
HomeMy WebLinkAboutFND-017-16Finance Department Report If this information is required in an alternate accessible format, please contact the Accessibility Coordinator at 905-623-3379 ext. 2131. Report To: General Government Committee Date of Meeting: November 28, 2016 Report Number: FND-017-16 Resolution: File Number: By-law Number: Report Subject: Financial Update as at September 30, 2016 Recommendations: 1.That Report FND-017-16 be received for information. Municipality of Clarington Report FND-017-16 Page 2 Report Overview The purpose of this report is to update Council on the overall budget variances as of September 30, 2016 as well as other financial indicators such as taxes receivable, investments, debt and development charges collected. 1. Background The financial update has be designed to focus on overall budget variance. 2. Third Quarter of 2016 Results 2.1 Attachment 1, Summary of Operating Expenditures and Revenues compares the Municipality’s budget to actuals as of September 30, 2016. This statement reflects the Municipality’s operating budget only and excludes year to date financial activities for the consolidated hall and arena boards. Year to date expenditures as of September 30, 2016 totalled $57,221,413 which represents 100.5% of the third quarter budget. Year to date revenues totalled $72,586,146 which represents 103.4% of the third quarter budget. 2.2 Attachment 1 is intended to provide an indication of the status of Municipality’s operating accounts compared to the approved budget as at September 30, 2016. Many departments are affected by high levels of activity during specific times of the year. Some activites are seasonal in nature, such as ice rentals and winter control, which result in a fluctuation of the timing of recognition of revenue and expenses. The budget is allocated monthly based on prior year’s actual monthly distributions. In cases where there is no prior year history, the monthly allocation is divided equaly over the 12 months. While this is the best method available to be reflective of seasonal trends, some municipal activities have significant variations from year to year such as the Legal and Planning Services activities. Due to these timing difference, this statement cannot be used in isolation. 2.3 The Administrator’s office budget has been adjusted to reflect change of moving the Communications and Tourism to the CAO’s office. In order to have a fair comparison the 2015 budget and actual figures have been moved to the Chief Administrative Officer’s budget section as well. As there was a new account structure in 2016 which separated Communication and Tourism, the budget allocation for 2016 is based on an even distribution. However, there will be some timing differences on revenue and expenses. To date, the revenue overall is higher than budgeted. This is due to higher than budgeted revenues relating to Port Granby. Respectively there are higher than budget expenses relating to Port Granby as this is a cost recovery process. Communication advertising revenues have exceeded the 2016 budget amount. Tourism advertising revenues are below budget but as noted previously this could be a timing difference for these revenues. Overall, the Administrator’s office net expenditures are at 99.4% of the third quarter budget. 2.4 The Clerk’s department net expenditures are 99.0% at the end of the third quarter. Revenues are higher than budgeted at 127.0%. There are a variety of budget variances Municipality of Clarington Report FND-017-16 Page 3 within the Clerk’s department. Most significantly, increased revenues can be attributed to higher parking revenues and wildlife damage payments from the province. Accordingly the expenditures are higher for both parking revenue transfers to the reserve fund and wildlife damage claim payments. Animal licences revenues are lower than budgeted at only 29.9% of the total 2016 budget as of September 30, 2016 2.5 Emergency Services net expenditures are 96.9% at the end of the third quarter. Emergency call revenues are unbudgeted and are offset by a corresponding expense which transfers this revenue to the reserve fund. The increase in the revenues is due to the emergency calls and other miscellaneous revenues such as charges to Ontario Power Generation as per the Memorandum of Understanding with them. Expenses overall are on track at 99.1%. The higher transfers to the reserve funds are offset by lower than budgeted expenditures in various areas such as full time suppression and internet charges. In 2016, some of the phone and internet charges were reallocated to Corporate Services. This reduction in the Emergency Services budget for phone and internet will be reflected in the 2017 budget. 2.6 Engineering net expenditures are 81.9% as of September 30, 2016 budget. This can be attributed to the higher revenues in building inspections and building permits thus reducing the net expenditures. At the end of the third quarter, building permit revenues were at $1,730,494 or 130.8% of the total 2016 budget. The higher expenditures are largely due to the corresponding transfer of inspection fees to the reserve fund. 2.7 Operations net expenditures are at 96.5% at the end of the third quarter budget. Some revenues are higher such as entrance and culvert fees as well as the recovery of winter and spring maintenance in unassumed subdivisions while other revenues such as cemetery fees are lower than budgeted. Some of the higher expenditures are road maintenance, brush removal, tree contracts and weed control. As of September 30, building maintenance costs are overall below budget but this could be due to a timing of work completed. Note that fleet costs are not completed until year end. 2.8 Boards and agencies are on budget for 2016. As noted in second quarter report, the increase is due to capital budget transfers to the library approved in prior years. This is offset by a non-departmental revenue transfer from reserve fund from a previous commitments. 2.9 Attachment 2, Continuity of Taxes Receivable for the nine months ending September 30, 2016 provides the status of the taxes billed and collected by the Municipality during this time. A total of $49,276,016 in final tax bills and $999,714 in supplementary tax bills were issued to property owners in the Municipality during the third quarter. At the end of September 2016, a total of $19,086,109 remains unpaid compared to September 2015 taxes receivable of $18,273,894. The net balance is $812,215 higher or 4.4% higher than the previous year at this time. This increase can be in part attributed to regular assessment review by municipal staff. Due to the timing of the corrections on some assessments, the taxes due would increase but have yet to be paid. The ongoing collection efforts continue to manage the balance of taxes outstanding. Municipality of Clarington Report FND-017-16 Page 4 2.10 Attachment 3, Investments Outstanding as of September 30, 2016 provides the status of the Municipality’s general, capital, and reserve fund investment holdings at the end of third quarter of 2016. The Municipality at September 30, 2016 holds $10,000,000 in general fund investments, $0 in capital fund investments, $9,313,320.27 in Development Charge reserve fund investments and $47,831,486.24 in reserve fund investments. The general fund investment is with the One Fund High Interest Savings Account (HISA). This investment offers better returns with high liquidity. Investments held in the Municipality’s portfolio are assessed on an ongoing basis to ensure they meet the requirements of section 418 of the Ontario Municipal Act, Ontario Regulation 438/97 and the Municipality’s investment policy. Clarington investments are very conservative in nature and only high quality investments are chosen as per the policy. 2.11 Attachment 4, Debenture Repayment Schedule provides the status of the Municipality’s long term debt obligations as of January 1, 2017. The Municipality will have approximately $17,977,133.62 in outstanding debt as of January 1, 2017. In 2017, the debt repayment obligations as per the current debt are $3,820,807.66. The debenture for the Courtice Library addition was finalized in October 2016 with payments starting in 2017. The annual principal and interest payments required to service these liabilities are well within the annual debt repayment limits prescribed by the Ministry of Municipal Affairs and Housing. 2.12 Attachment 5, Municipal Development Charges as of September 30, 2016 provides the Municipal Development charges collected separated into residential and non-residential. As of September 30, 2016, Residential Municipal Development Charges collected are $8,399,943.27. In the recent 2015 Development Charges Background Study, it is forecasted that the Municipality would be collecting approximately 927 residential units in total for 2016 or about 77 units per month. For 2016 budget considerations, the figure of 600 units (50 units per month) was used for the year. At the end of September 2016, there were 639 residential units. Compared to the same period the previous year there was 5.73% decrease in development charges collected and a 10.38% decrease in the number of units. In the 2015 Development Charges By-law 2015-035, there are some incentives to encourage multi-residential development in Clarington. As of September 30, 2016 at total of $413,822.26 was given to one property, a mid-rise residential development at 105 Queen Street in Bowmanville. 2.13 As of September 30, 2016, Non-Residential Municipal Development Charges collected are $53,658.51. Compared to the same period the previous year there was 84.2% decrease in development charges collected and a 38.89% decrease in the number of units. Non-residential development charges are based on the area in square meters rather than per unit cost so it can be expected to have significant variances from one year to another. In the 2015 Development Charges By-law 2015-035, there are a number of incentives to encourage development in Clarington. As of September 30, 2016 a total of $129,995.79 in non-residential incentives have been given to five properties. Municipality of Clarington Report FND-017-16 Page 5 3. Concurrence Not Applicable 4. Conclusion It is respectfully recommended that the third quarter of 2016 financial update report be received for information. 5. Strategic Plan Application The recommendations contained in this report conform to the Strategic Plan. Submitted by: Reviewed by: Nancy Taylor, BBA, CPA, CA, Curry Clifford, MPA, CMO Director of Finance/Treasurer Interim CAO Staff Contact: Catherine Carr, Manager of Internal Audit, 905-623-3379 ext. 2606 or ccarr@clarington.net There are no interested parties to be notified of Council's decision. Attachment 1 – Summary of Operating Revenues and Expenditures Attachment 2 - Continuity of Taxes Receivable Attachment 3 – Investments Outstanding Attachment 4 – Debenture Repayment Schedule Attachment 5 – Municipal Development Charges NT/CC/hjl The Municipality of Clarington Summary of Operating Expenditures for the Nine Months ending September 30, 2016 Attachment 1 for FND-017-16 2016 Budget 3rd Quarter YTD 2016 Actual 3rd QuarterYTD 2016 YTD 3rd Quarter Unexpended in $ 2016 3rd Quarter YTD Expended % 2015 Budget 3rd Quarter YTD 2015 Actual 3rd Quarter YTD 2015 YTD Unexpended 3rd Quarter in $ 2016 Total Budget 2016 % of Annual Budget Spent 05 Non-departmental Accounts Municipal Taxation (55,610,604)(56,043,221)432,617 100.8%(52,855,430)(53,429,019)573,589 (55,690,829)100.6% Other Revenue (1,453,033)(1,631,380)178,347 112.3%(1,950,541)(2,140,305)189,764 (1,646,289)99.1% Contributions (5,839,274)(5,671,883)(167,391)97.1%(3,510,404)(6,215,830)2,705,426 (5,839,274)97.1% Revenues/Recoveries (62,902,911)(63,346,484)443,573 100.7%(58,316,375)(61,785,154)3,468,779 (63,176,392)100.3% 59 BIA Taxation BIA Taxes (199,200)(199,200)0 100.0%(194,230)(194,230)0 (199,200)100.0% BIA Payments 199,200 199,200 0 100.0%194,230 194,230 0 199,200 100.0% Net Expenditures 0 0 0 0 0 0 0 10 Mayor & Council Net Expenditures 657,816 635,681 22,135 96.6%671,384 670,018 1,366 908,605 70.0% 13 Administrator's Office Revenue/Recoveries (112,687)(221,527)108,840 196.6%(137,782)(205,000)67,218 (166,200)133.3% Expenditures 1,371,597 1,473,189 (101,592)107.4%1,321,164 1,274,398 46,766 1,869,155 78.8% Net Expenditures 1,258,910 1,251,662 7,248 99.4%1,183,382 1,069,398 113,984 1,702,955 73.5% 14 Legal Administration Revenue/Recoveries (61,142)(64,229)3,087 105.0%(61,077)(97,183)36,106 (69,000)93.1% Expenditures 303,467 322,138 (18,671)106.2%299,689 317,169 (17,480)417,659 77.1% Net Expenditures 242,325 257,909 (15,584)106.4%238,612 219,986 18,626 348,659 74.0% 16 Corporate Services Revenue/Recoveries (1,506)(1,538)32 102.1%(512)(10)(502)(108,500)1.4% Expenditures 2,989,250 3,020,798 (31,548)101.1%2,854,200 2,878,156 (23,956)3,807,847 79.3% Net Expenditures 2,987,744 3,019,260 (31,516)101.1%2,853,688 2,878,146 (24,458)3,699,347 81.6% 19 Clerk's Revenue/Recoveries (520,568)(661,201)140,633 127.0%(422,291)(723,750)301,459 (708,900)93.3% Expenditures 2,239,988 2,364,144 (124,156)105.5%2,100,021 2,344,490 (244,469)3,074,911 76.9% Net Expenditures 1,719,420 1,702,943 16,477 99.0%1,677,730 1,620,740 56,990 2,366,011 72.0% 21 Finance & Unclassified Adminstration Revenue/Recoveries (1,140,697)(1,180,330)39,633 103.5%(1,156,563)(1,173,410)16,847 (1,564,000)75.5% Unclassified Admin & CBOT 2,183,319 2,293,100 (109,781)105.0%2,105,263 2,093,343 11,920 2,512,726 91.3% Operating Expenditures 1,779,917 1,779,496 421 100.0%1,720,429 1,724,259 (3,830)2,407,015 73.9% Expenditures 3,963,236 4,072,596 (109,360)102.8%3,825,692 3,817,602 8,090 4,919,741 82.8% Net Expenditures 2,822,539 2,892,266 (69,727)102.5%2,669,129 2,644,192 24,937 3,355,741 86.2% The Municipality of Clarington Summary of Operating Expenditures for the Nine Months ending September 30, 2016 Attachment 1 for FND-017-16 2016 Budget 3rd Quarter YTD 2016 Actual 3rd QuarterYTD 2016 YTD 3rd Quarter Unexpended in $ 2016 3rd Quarter YTD Expended % 2015 Budget 3rd Quarter YTD 2015 Actual 3rd Quarter YTD 2015 YTD Unexpended 3rd Quarter in $ 2016 Total Budget 2016 % of Annual Budget Spent 28 Emergency Services - Fire Revenue/Recoveries (52,555)(251,135)198,580 477.9%(40,371)(97,234)56,863 (80,000)313.9% Expenditures 8,781,807 8,706,901 74,906 99.1%8,435,413 8,798,055 (362,642)11,815,340 73.7% Net Expenditures 8,729,252 8,455,766 273,486 96.9%8,395,042 8,700,821 (305,779)11,735,340 72.1% 32 Engineering Services Revenue/Recoveries (1,021,280)(2,105,161)1,083,881 206.1%(1,061,703)(1,939,587)877,884 (1,381,500)152.4% Debentures 442,539 442,539 0 100.0%522,189 433,608 88,581 528,771 83.7% Operating Expenditures 5,429,341 5,633,435 (204,094)103.8%5,030,933 5,220,581 (189,648)6,536,575 86.2% Expenditures 5,871,880 6,075,974 (204,094)103.5%5,553,122 5,654,189 (101,067)7,065,346 86.0% Net Expenditures 4,850,600 3,970,813 879,787 81.9%4,491,419 3,714,602 776,817 5,683,846 69.9% 36 Operations Revenue/Recoveries (420,422)(581,354)160,932 138.3%(344,081)(502,966)158,885 (677,300)85.8% Operating Expenditures 11,398,286 11,601,011 (202,725)101.8%10,486,413 11,677,043 (1,190,630)15,840,827 73.2% Fleet & Debenture Payments 888,129 431,897 456,232 48.6%992,573 568,468 424,105 1,090,643 39.6% Expenditures 12,286,415 12,032,908 253,507 97.9%11,478,986 12,245,511 (766,525)16,931,470 71.1% Net Expenditures 11,865,993 11,451,554 414,439 96.5%11,134,905 11,742,545 (607,640)16,254,170 70.5% 42 Community Services Revenue/Recoveries (3,474,445)(3,642,658)168,213 104.8%(3,346,103)(3,528,403)182,300 (4,694,600)77.6% Operating Expenditures 7,925,619 8,115,697 (190,078)102.4%7,468,230 7,480,355 (12,125)10,900,097 74.5% Debenture Payments 2,933,102 2,933,102 0 100.0%3,105,368 2,899,209 206,159 3,104,458 94.5% Annual Grant & Sponsorship 115,000 113,500 1,500 98.7%100,000 83,580 16,420 115,000 98.7% Expenditures 10,973,721 11,162,299 (188,578)101.7%10,673,598 10,463,144 210,454 14,119,555 79.1% Net Expenditures 7,499,276 7,519,641 (20,365)100.3%7,327,495 6,934,741 392,754 9,424,955 79.8% 50 Planning Services Revenue/Recoveries (266,010)(331,329)65,319 124.6%(305,944)(270,138)(35,806)(436,000)76.0% Expenditures 3,287,177 3,027,100 260,077 92.1%3,111,278 2,924,423 186,855 4,141,092 73.1% Net Expenditures 3,021,167 2,695,771 325,396 89.2%2,805,334 2,654,285 151,049 3,705,092 72.8% Boards & Agencies Net Expenditures 3,988,263 4,128,485 (140,222)103.5%3,967,299 4,068,130 (100,831)3,991,671 103.4% TOTAL OPERATING: Revenue/Recoveries (70,173,423)(72,586,146)2,412,723 103.4%(65,387,032)(70,517,065)5,130,033 (73,261,592)99.1% Expenditures 56,913,817 57,221,413 (307,596)100.5%54,486,076 55,649,515 (1,163,439)73,261,592 78.1% Net Difference (13,259,606)(15,364,733)2,105,127 115.9%(10,900,956)(14,867,550)3,966,594 0 CORPORATION OF THE MUNICIPALITY OF CLARINGTON Attachment 2 to Continuity of Taxes Receivable Report FND-017-16 for the Third Quarter of the Year 2016 June 30, 2016 Beginning Balance Receivable Interest Added Taxes Billed Balance Payments and Adjustments ** September 2016 September 2015 Current Year Taxes 6,962,463 50,035,413 56,997,876 (40,907,962) 16,089,915 14,896,879 Penalty and Interest 80,256 222,456 302,711 (139,472) 163,240 159,100 First Prior Year Taxes 2,495,155 228,214 2,723,369 (777,275) 1,946,094 2,188,866 Penalty and Interest 185,642 82,942 268,584 (106,410) 162,174 181,683 Second Prior Year Taxes 714,536 12,102 726,639 (194,437) 532,202 547,809 Penalty and Interest 76,813 22,627 99,440 (44,735) 54,705 71,315 Third and Prior Years Taxes 204,453 204,453 (97,157) 107,296 157,884 Penalty and Interest 140,375 5,423 145,798 (115,315) 30,483 70,357 TOTAL 10,859,692 333,448 50,275,730 61,468,870 (42,382,761) 19,086,109 18,273,894 ** Includes refunds, write-offs, 357's, etc. NOTES: 2016 Interim Instalment months (for all classes): February and April 2016 Final Instalment months (for non-capped classes): June and September 2016 Final Instalment months (for capped classes): August and September Attachment 3 to Municipality of Clarington Report FND-017-16 Investments Outstanding As at September 30, 2016 Issuer Type Rating Purchase Date Cost Interest Rate Maturity date Maturity General Fund One Fund HISA H 07-Sep-16 10,000,000.00 1.10%n/a 10,000,000.00 (B) General Fund total:10,000,000.00 10,000,000.00 Capital Fund Capital Fund total:- - Non development charge monies (including Strategic Capital) RBC account H 30-Sep-16 3,466,196.32 n/a 3,466,196.32 ( C) Tangerine GIC H 01-Oct-12 1,819,048.00 2.35%03-Oct-16 1,996,160.91 Manulife Bank GIC HM 02-Dec-11 2,000,000.00 2.71%02-Dec-16 2,286,091.67 Manulife Bank GIC HM 19-Mar-12 1,693,000.00 2.88%19-Mar-17 1,951,224.70 BMO coupons L 15-Mar-12 159,396.18 2.86%28-Mar-17 183,615.00 RBC GIC H 01-May-13 1,000,000.00 2.10%01-May-17 1,086,683.24 BMO coupons L 15-Mar-12 196,287.25 2.92%28-Sep-17 230,141.00 BNS GIC H 30-Oct-12 1,884,365.00 2.50%30-Oct-17 2,131,986.04 HSBC GIC H 21-Dec-12 1,121,354.00 2.40%21-Dec-17 1,262,352.30 National Bank GIC M 12-Feb-13 1,927,464.00 2.45%12-Feb-18 2,175,434.89 Tangerine GIC H 25-Mar-13 1,254,427.00 2.40%26-Mar-18 1,412,449.93 HSBC GIC H 13-May-13 321,079.00 2.25%14-May-18 358,862.84 BNS GIC H 03-Jun-13 1,499,069.00 2.30%03-Jun-18 1,679,576.51 RBC GIC H 30-Jul-13 2,341,277.00 2.60%30-Jul-18 2,661,886.92 Tangerine GIC HM 10-Aug-15 672,368.00 1.60%10-Aug-18 705,160.80 BMO GIC H 30-Sep-13 1,174,214.00 2.90%01-Oct-18 1,354,748.00 Prov NB coupons H 27-Jun-13 248,068.78 2.59%03-Dec-18 285,071.00 Attachment 3 to Municipality of Clarington Report FND-017-16 Investments Outstanding As at September 30, 2016 Issuer Type Rating Purchase Date Cost Interest Rate Maturity date Maturity RBC GIC H 11-Mar-14 1,084,844.00 2.50%11-Mar-19 1,227,401.41 RBC GIC H 17-Mar-14 1,000,000.00 2.50%18-Mar-19 1,131,408.21 Tangerine GIC H 02-May-14 1,000,000.00 2.60%02-May-19 1,139,019.14 BMO GIC H 17-Aug-14 830,000.00 2.41%19-Aug-19 935,015.04 BNS GIC H 12-Sep-14 1,037,127.00 2.46%12-Sep-19 1,171,126.20 Manulife Bank GIC HM 23-Sep-14 789,343.56 2.50%22-Sep-19 893,069.79 Tangerine GIC H 02-Dec-14 1,191,382.00 2.56%02-Dec-19 1,351,889.19 Tangerine GIC H 18-Dec-14 1,045,809.00 2.56%18-Dec-19 1,186,704.08 BNS GIC H 01-Jun-15 1,500,632.00 2.10%01-Jun-20 1,664,956.59 BMO GIC H 11-Aug-15 2,000,000.00 1.95%11-Aug-20 2,202,754.75 RBC GIC H 11-Aug-15 1,741,656.00 1.95%11-Aug-20 1,918,220.51 BNS GIC H 28-Sep-15 708,582.00 2.10%29-Sep-20 786,174.27 BMO GIC H 15-Oct-15 621,864.00 2.15%15-Oct-20 691,651.42 BNS GIC H 10-Dec-15 1,500,000.00 2.32%10-Dec-20 1,682,263.09 BMO GIC H 10-Dec-15 1,500,000.00 2.20%10-Dec-20 1,672,421.48 BNS GIC H 10-Dec-15 1,976,951.00 2.32%10-Dec-20 2,220,381.86 HSBC GIC H 18-Dec-15 1,182,689.00 2.25%18-Dec-20 1,321,865.11 HSBC GIC H 29-Mar-16 195,399.00 2.18%29-Mar-21 217,646.57 HSBC GIC H 02-May-16 1,001,980.00 2.15%03-May-21 1,114,256.16 Prov BC Bond H 11-Dec-13 2,369,685.75 2.70%18-Dec-22 2,425,000.00 (A) Prov Manitoba Bond H 23-Nov-15 775,928.40 2.45%02-Jun-25 780,000.00 (A) Non-Development Charge Total:47,831,486.24 52,960,866.94 Attachment 3 to Municipality of Clarington Report FND-017-16 Investments Outstanding As at September 30, 2016 Issuer Type Rating Purchase Date Cost Interest Rate Maturity date Maturity Development charge funds One Fund Bond NR 08-Aug-00 3,904,003.27 n/a 3,904,003.27 (B) One Fund Equity NR 31-Jan-07 500,000.00 n/a 500,000.00 (B) RBC GIC H 07-Jun-16 143,426.00 0.70%05-Dec-16 143,923.87 BNS GIC H 20-Dec-13 1,062,541.00 2.03%20-Dec-16 1,128,572.22 National Bank GIC HM 20-Dec-13 1,300,000.00 2.75%20-Dec-18 1,488,855.35 Prov Ontario Bond H 19-Dec-13 2,403,350.00 2.85%02-Jun-23 2,500,000.00 (A) Development Charge Total:9,313,320.27 9,665,354.71 Total Investments 67,144,806.51$ 72,626,221.65$ Note that interest is annual compounding with the exception of the following: (A) Bond interest is paid semi-annually (B) Pooled Investment Fund ( C) Reinvested after month end Attachment 4 of Muncipality of Clarington Report FND-017-16 Debenture Repayment Schedule As of January 1, 2017 Year South Courtice Arena Indoor Soccer Lacrosse RRC CCD space Green Road Grade Separation Newcastle Library Courtice Library Newcastle Aquatic Total 2017 1,069,666.77 163,532.59 105,047.39 534,406.77 103,787.14 82,665.09 1,761,701.91 3,820,807.66 2018 164,093.85 104,942.45 538,772.66 106,787.14 78,904.97 1,759,687.50 2,753,188.57 2019 165,174.58 104,831.80 541,802.38 109,787.14 78,146.32 1,757,651.34 2,757,393.56 2020 164,755.07 104,715.46 544,416.38 112,787.14 78,341.53 1,604,355.98 2,609,371.56 2021 163,863.49 104,593.15 546,623.02 115,000.00 78,465.50 1,054,141.30 2,062,686.46 2022 163,542.75 546,559.49 117,000.00 78,488.31 1,006,711.96 1,912,302.51 2023 162,800.11 546,276.36 119,000.00 78,425.64 906,502.11 2024 160,675.42 553,240.30 78,249.84 792,165.56 2025+2,693,604.53 546,030.80 3,239,635.33 1,069,666.77 1,308,437.86 524,130.25 7,045,701.89 784,148.56 1,177,718.00 8,944,249.99 20,854,053.32 Principal at January 1, 2017 1,057,000.00 1,167,000.00 425,533.62 5,695,600.00 602,000.00 990,000.00 8,040,000.00 17,977,133.62 Principal at January 1, 2018 - 1,033,000.00 339,154.57 5,332,600.00 529,000.00 931,000.00 6,595,000.00 14,759,754.57 Interest Rates 2.00% to 2.25%1.35% to 3.35%5.12%1.35% to 3.8%4.9% to 5.2%1.15% to 2.8%4.5% to 4.75% NOTE: 2018 Newcastle library requires renewal of debenture for a further five year period unless funding is available from other sources. Partial funding at those times would reduce debenture burden for following five year period. An estimate is provided based on a further five year extension Municipality of Clarington Attachment 5 to Report FND-017-16 RESIDENTIAL Municipal Development Charges Paid Number of Units Municipal Development Charges Paid Number of Units Single/Semi- Detached -New construction 4,954,784.00$ 315 7,184,354 470 -Additions 15,985.00$ 1 172 1 Townhouse 2,273,872.00$ 184 247,786 19 Apartment 1,155,302.27$ 281 1,478,093 223 TOTAL:8,399,943.27$ 781 8,910,405.13$ 713 Change in DC paid from prior year:-5.73% Change in DC units from prior year:9.54% Noted DC Incentives under By-law 2015-035 105 Queen Street, Bowmanville Jan-16 413,822.26$ Mid-Rise Residential NON-RESIDENTIAL Municipal Development Charges Paid Number of Units Municipal Development Charges Paid Number of Units Commercial 46,214.61$ 2 -New construction 48,993.31$ 2 -Additions -$ 1 Industrial -$ - -New construction 4,665.20$ 8 -Additions -$ - Agricultural -$ - -$ - Government -$ - 289,094.57$ 15 Institutional -$ - 4,286.80$ 1 TOTAL:53,658.51$ 11 339,595.98$ 18 Change in DC paid from prior year:-84.20% Change in DC units from prior year:-38.89% Noted DC Incentives under By-law 2015-035:Date Value of Incentive 222 King Street East, Bowmanville Jul-15 110,671.30 Medical Exemption 21 King Avenue East, Newcastle Oct-15 3,636.08$ Revitalization 222 Baseline Road East, Bowmanville Feb-16 13,279.78$ Existing Industrial Development 28 King Avenue East, Newcastle Feb-16 937.96$ Small Business Expansion 70 Mearns Court, Bowmanville Apr-16 1,470.67$ Existing Industrial Development MUNICIPAL DEVELOPMENT CHARGES January to September YTD 2016 2015 2016 2015