2020 Comprehensive Annual Financial Report

CITY OF SHAKOPEE

COMBINING STATEMENT OF CASH FLOWS - INTERNAL SERVICE FUNDS For the Year Ended December 31, 2020

Information and Technology

Employee Benefits

Self Insurance

Total

Equipment

Buildings

Park Asset

CASH FLOWS - OPERATING ACTIVITIES Receipts from Customers and Users

1,089,800 $

1,084,200 $

569,800 $

$

-

$

610,233

1,048,387 $

4,402,420 $

Receipts from Interfund Services

-

-

-

434,293

-

-

434,293

Payments to Suppliers

(1,623)

(141,135)

(78,489)

-

(490,810)

(872,926)

(1,584,983)

Net Cash Flows - Operating Activities

1,088,177

943,065

491,311

434,293

119,423

175,461

3,251,730

CASH FLOWS - NONCAPITAL FINANCING ACTIVITIES Payment Paid on Interfund Loan

941,394

(60,000) (17,875)

- - - -

- - - -

- - - -

- -

881,394 (17,875)

Interest Expense on Interfund Loan Repayment

- - -

Insurance Dividends Transfer to Other Funds

-

54,741

54,741

(300,000)

-

(300,000)

Net Cash Flows - Noncapital Financing Activities

941,394

(377,875)

-

-

-

54,741

618,260

CASH FLOWS - CAPITAL AND RELATED FINANCING ACTIVITIES Intergovernmental Capital Grant

- -

4,355

-

- - - -

106,492

- -

110,847 50,000 235,129

Donations

- -

50,000

- -

203,938

-

31,191

Proceeds from Disposal of Capital Assets

Acquisition of Capital Assets

(1,312,293)

(76,663)

(162,443)

(42,875)

-

(1,594,274)

Net Cash Flows - Capital and Related Financing Activities

(1,108,355)

(72,308)

(112,443)

-

63,617

31,191

(1,198,298)

CASH FLOWS - INVESTING ACTIVITIES Interest Received

169,334

191,404

49,592

41,227

27,457

50,174

529,188

Net Cash Flows - Investing Activities

169,334

191,404

49,592

41,227

27,457

50,174

529,188

1,090,550

684,286

428,460

475,520

210,497

311,567

3,200,880

Net Change in Cash and Cash Equivalents

CASH AND CASH EQUIVALENTS Beginning of Year

4,622,575

5,480,066

1,220,377

1,057,466

714,075

1,536,748

14,631,307

5,713,125 $

6,164,352 $

1,648,837 $

1,532,986 $

$

924,572

1,848,315 $

17,832,187 $

End of Year

RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH FLOWS - OPERATING ACTIVITIES Operating Income (Loss) Adjustments to Reconcile Operating Income (Loss) to Net Cash Flows - Operating Activities: Depreciation Expense

$

177,172

258,228 $

142,753 $

$

-

$

86,758

$

185,125

$

850,036

856,713

692,368

427,047

-

25,441

-

2,001,569

Changes in:

Accounts Receivable

-

-

-

- - -

(1,067) 3,305

-

(1,067) (30,923) (2,178)

Accounts and Contracts Payable

54,292

(7,531)

(78,489)

(2,500) (7,164)

Prepaid Expenses

- -

- -

- -

4,986

Compensated Absences Payable

434,293 434,293

-

-

434,293

Total Adjustments

911,005

684,837

348,558

32,665

(9,664)

2,401,694

Net Cash Flows - Operating Activities

1,088,177 $

943,065 $

491,311 $

434,293 $

$

119,423

$

175,461

3,251,730 $

136