2022-2026 Capital Improvement Plan (Final)

City of Shakopee Equipment Internal Service Fund (7800) Cash Flow Projections Updated 8/13/2021

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2026 Projected

2020 Actual 2017 Actual 2019 Actual

Sources

Rental Charges

$

787,800 51,473

$

988,600 158,839

1,089,800 $

1,152,400 $

1,328,800 $

1,355,376 $

1,382,484 $

1,410,134 $

1,438,337 $

Investment Income

169,334

57,131

59,182

60,476

69,780

75,015

77,909

Miscellaneous

- -

- - -

Interfund Loan Miscellaneous

941,394

- -

- -

- -

- -

- -

- -

8,163

(3,849)

Gain (loss) on asset disposal

97,619 945,174

211,751

203,938

15,000

15,000

15,000

15,000

15,000

15,000

Total Revenue

1,359,190

2,400,617

1,224,531

1,402,982

1,430,852

1,467,264

1,500,149

1,531,246

Uses

Administration

-

- -

-

36,000 208,000 161,500

42,000 214,000 208,000 10,000 31,000 608,100 63,200 72,000 25,250

-

-

-

-

Police

181,401 539,710

447,297 204,954

309,000 111,740

319,000 61,532 10,600 32,000 280,300 215,750 24,600

303,000 178,378 57,000 102,000 61,400 509,000

266,000

Fire

49,617

3,420,280

Facilities

5,475

- -

8,716

- -

- -

46,200

Engineering

-

-

-

Street Maintenance Park Maintenance

440,599 355,490 132,631

231,789 105,419 31,500

443,827 205,273

604,000 10,000

37,200 42,500

5,500

143,300 102,200

Recreation

- -

- -

- -

- -

Transfers to Storm Sewer

-

-

-

-

Total Expenditures

1,655,306

418,325

1,310,067

1,019,500

1,273,550

500,440

943,782

1,210,778

3,983,480

Excess (deficiency) of Sources over Uses

(710,132)

940,865

1,090,550

205,031

129,432

930,412

523,482

289,371

(2,452,234)

Cash Balance- January 1

4,510,751 $

3,681,710 $

4,622,575 $

5,713,125 $

5,918,156 $

6,047,588 $

6,978,000 $

7,501,482 $

7,790,853 $

Cash Balance December 31

3,800,619 $

4,622,575 $

5,713,125 $

5,918,156 $

6,047,588 $

6,978,000 $

7,501,482 $

7,790,853 $

5,338,618 $

84