2021-25 Capital Improvement Plan

City of Shakopee Equipment Internal Service Fund (7800) Cash Flow Projections Updated 7/31/2020

2020 Projected

2021 Projected

2022 Projected

2023 Projected

2024 Projected

2025 Projected

2018 Actual 2019 Actual

Sources

Rental Charges Reimbursement

$

889,300

$

988,600

1,089,800 $

1,198,400 $

1,222,368 $

1,246,815 $

1,271,751 $

1,297,186 $

947

-

-

-

-

-

-

-

Investment Income

56,065

158,839

46,226

49,374

49,466

51,899

53,407

61,592

Miscellaneous

- -

- -

Miscellaneous

-

-

-

-

-

-

Gain (loss) on asset disposal

10,655 956,967

211,751

15,000

15,000

15,000

15,000

15,000

15,000

Total Revenue

1,359,190

1,151,026

1,262,774

1,286,834

1,313,714

1,340,158

1,373,778

Uses

Equipment

- -

- - -

- -

-

- -

- -

- -

- -

Administration

36,000 208,000 161,500

Police

92,759 785,714

282,000 158,000

214,000 203,000

309,000 106,500

319,000 56,000

234,000 57,500

Fire

49,617

Facilities

2,886

- -

8,000

- -

8,000

- -

8,000

Engineering

-

-

62,000 530,100 10,200 83,500 25,250

-

-

Street Maintenance Park Maintenance

49,126 145,391

231,789 105,419 31,500

188,000 191,000

604,000 10,000

47,700 32,000

307,050 173,000

16,400 30,000

Recreation

- -

- -

- -

- -

- -

- -

Transfers to Storm Sewer

-

Total Expenditures

1,075,876

418,325

827,000

1,019,500

1,136,050

495,200

863,050

337,900

Excess (deficiency) of Sources over Uses

(118,909)

940,865

324,026

243,274

150,784

818,514

477,108

1,035,878

Cash Balance- January 1

3,800,619 $

3,681,710 $

4,622,575 $

4,946,601 $

5,189,875 $

5,340,659 $

6,159,172 $

6,636,280 $

Cash Balance December 31

3,681,710 $

4,622,575 $

4,946,601 $

5,189,875 $

5,340,659 $

6,159,172 $

6,636,280 $

7,672,158 $

82