2018-2022 Financial Plan

FUND BALANCE PROJECTIONS

Accumulated Surplus and Funds Balance as at December 31, 2017 (All Figures $ in thousands)

Reserve Funds

General

Sewer

Water

Total

Operating Surplus

10,012

8,936

12,840

31,788

Reserve Accounts

48,123

3,228

4,665

56,016

Reserve Funds

41,639

41,639

Funds Balance

58,135

12,163 17,505

41,639

129,443

Equity in Capital Assets

721,401

129,423

117,672

968,496

Accumulated Surplus

779,536 141,587 35,177

41,639

1,097,940

Tangible Capital Assets are reported in the annual report as per PSAB Accounting Handbook Sec. 3150.

Funds committed to previously approved work but not yet part of the 2018-2022 Financial Plan Reserve Accounts 28,293 3,752 5,337

37,383

Reserve Funds

18,160

18,160

Adjustment

28,293

3,752 5,337

18,160

55,543

The above was approved in 2017 but not yet complete and will be included in the 2018 budget amendment in May.

Reserve Funds

Adjusted Funds Balance

General

Sewer

Water

Total

Operating Surplus

10,012

8,936

12,840

31,788

Reserve Accounts

19,830

(524)

(672)

18,634

Reserve Funds

23,479

23,479

29,842

8,412

12,168

23,479

73,901

Planned Fund Changes

2018

2019

2020

2021

2022

General

(1,972)

(123)

1,970

1,054

2,183

Sewer

(786)

(2,760)

427

1,054

1,326

Water

(71)

1,478

2,421

1,955

3,557

Reserve Funds

760

4,548

7,094

4,391

7,060

(2,069)

3,143

11,912

8,454

14,126

Planned Fund Balances

2018

2019

2020

2021

2022

General

27,870

27,747

29,717

30,771

32,954

Sewer

7,626

4,866

5,293

6,347

7,673

Water

12,097

13,575

15,996

17,951

21,508

Reserve Funds

24,239

28,787

35,881

40,272

47,332

71,832

74,975

86,887

95,341

109,467

Equity in Capital Assets Beginning Balance

968,496

1,031,623

1,083,858

1,110,232

1,135,631

Capital Planned

62,907

52,015

26,154

25,179

19,706

Developer Contributed

20,000

20,000

20,000

20,000

20,000

Amortization

(19,780)

(19,780)

(19,780)

(19,780)

(19,780)

1,031,623

1,083,858

1,110,232

1,135,631

1,155,557

Accumulated Surplus

1,103,455

1,158,833

1,197,119

1,230,972

1,265,024

Page 78 of 234