2021-25 Capital Improvement Plan

First page Table of contents Previous page 246-247 Next page Last page

CITY OF SHAKOPEE STORM WATER FUND PROJECTIONS REVENUE/ EXPENSE PROJECTIONS AND CASHFLOW 8/31/2020

2020 Projected

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2019 Actual

Cash and Cash Equivalents January 1

13,029,404

14,305,220

10,807,249

7,973,449

5,576,749

5,777,749

5,847,649

Cash Flows From Operating Activities: Operating Income (Loss)

(502,169)

(470,100)

(518,700)

(554,600)

(591,300)

(629,000)

(667,700)

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

885,285 16,778 49,669

911,800

939,200

967,400

996,400

1,026,300

1,057,100

Pension Expense

Changes in assets and liabilities

Other non-operating revenue

546,000 987,700

375,000 772,300

375,000 764,400

Net cash flows from operating activities

449,563

420,500

412,800

405,100

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

Operating transfers-out

(125,000) 110,000 (15,000)

(125,000) (2,272,400) (2,397,400)

(125,000) 291,800 166,800

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

(777,928) 168,203 799,313

(2,877,371)

(3,629,200)

(3,056,000)

(426,700)

(927,000)

Capital Grant Trunk Charges

100,000 546,000

100,000

- - -

Capital Related Special Assessments

- -

Proceeds (Loss) from Disposal of Capital Assets Net cash flows from capital and related financing act.

137,560 327,148

(2,231,371)

(3,529,200)

(3,056,000)

(426,700)

(927,000)

Net cash flows from investing activities

514,105

143,100

108,100

79,700

55,800

57,800

58,500

Net Increase (Decrease) in cash

1,275,816

(3,497,971)

(2,833,800)

(2,396,700)

201,000

69,900

62,700

Cash and Cash Equivalents December 31