2021-25 Capital Improvement Plan

CITY OF SHAKOPEE SEWER FUND PROJECTIONS INCOME / EXPENSE PROJECTIONS 08/31/20

8,149,310 2020 Projected

7,489,352 2021 Projected

1,942,798 2022 Projected

2023 Projected

2024 Projected

1,521,610 2025 Projected

2019 Actual

Cash and Cash Equivalents January 1 Cash Flows From Operating Activities: Operating Income (Loss)

8,139,159

482,294

767,592

5,764

(390,692)

(446,059)

(471,908)

(438,906)

(447,386)

(457,386)

Adjustments to reconcile operating Income (Loss) to net cash flows from operating activities: Depreciation

874,611

889,900

905,500

921,300

937,400

953,800

970,500

Pension Expense

-

-

-

-

-

-

-

Changes in assets and liabilities

Decrease (Increase) in assets/liabilities

182,831

-

-

-

-

-

-

Net cash flows from operating activities

1,063,206

499,208

459,441

449,392

498,494

506,414

513,114

Cash flows from non-capital financing activities: Operating transfers-in

-

290,000 (125,000) 106,704 271,704

1,051,000 (125,000) 106,704 1,032,704

-

-

-

-

Operating transfers-out

(125,000) 117,953

(125,000) 106,704 (18,296)

(125,000) 106,704 (18,296)

(125,000) 106,704 (18,296)

(125,000)

Interfund Loan Issued/(Payment Received) Net cash flows from non-capital financing activities Cash flows from capital and related financing activities: Acquisition and construction of fixed assets

-

(7,047)

(125,000)

(1,638,555) (1,593,870) (7,651,000) (2,393,000)

(667,000)

(212,000) (1,268,000)

Trunk Charges

201,810 53,622

- -

-

-

-

-

-

Capital Related Special Assessments Intergovernmental Capital Grant

462,500

462,500

462,500

462,500

462,500

- -

- -

- -

- -

- -

Proceeds (Loss) from Disposal of Capital Assets

18,000

-

Net cash flows from capital and related financing activities

(1,365,123) (1,593,870) (7,188,500) (1,930,500)

(204,500)

250,500

(805,500)

Net cash flows from investing activities

319,115

163,000

149,800

38,900

9,600

15,400

30,400

Net Increase (Decrease) in cash

10,151

(659,958) (5,546,555) (1,460,504)

285,298

754,018

(386,986)

Cash and Cash Equivalents December 31

8,149,310

7,489,352

1,942,798

482,294

767,592

1,521,610

1,134,624

182