2022 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

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

Information and Technology

Employee Benefits

Self Insurance

Total

Equipment

Buildings

Park Asset

CASH FLOWS - OPERATING ACTIVITIES Receipts from Customers and Users

$ 1,328,800

$ 1,206,450

$ 606,000

$

- -

$

612,000 (549,206)

$ 1,281,125

$ 5,034,375

Payments to Suppliers Payments to Employees

(27,629)

(62,023)

(60,887)

(807,089)

(1,506,834)

-

-

-

(66,094)

-

-

(66,094)

Net Cash Flows - Operating Activities

1,301,171

1,144,427

545,113

(66,094)

62,794

474,036

3,461,447

CASH FLOWS - NONCAPITAL FINANCING ACTIVITIES Payment Paid on Interfund Loan

- - -

(60,000) (15,125)

- - -

- - -

- - -

- -

(60,000) (15,125)

Interest Expense on Interfund Loan Repayment

Insurance Dividends

-

92,325

92,325

Net Cash Flows - Noncapital Financing Activities

-

(75,125)

-

-

-

92,325

17,200

CASH FLOWS - CAPITAL AND RELATED FINANCING ACTIVITIES Intergovernmental Capital Grant Proceeds from Disposal of Capital Assets

9,642 24,210

- -

300,000

- - -

- - -

- - -

309,642 24,960

750

Acquisition of Capital Assets

(402,073)

(421,154)

(412,273)

(1,235,500)

Net Cash Flows - Capital and Related Financing Activities

(368,221)

(421,154)

(111,523)

-

-

-

(900,898)

CASH FLOWS - INVESTING ACTIVITIES Interest Received (Loss)

(291,401)

(314,166)

(84,160)

(66,665)

(52,441)

(131,205)

(940,038)

Net Cash Flows - Investing Activities

(291,401)

(314,166)

(84,160)

(66,665)

(52,441)

(131,205)

(940,038)

641,549

333,982

349,430

(132,759)

10,353

435,156

1,637,711

Net Change in Cash and Cash Equivalents

CASH AND CASH EQUIVALENTS Beginning of Year

5,686,625

6,652,732

1,461,480

1,649,992

1,146,280

2,324,532

18,921,641

$ 6,328,174

$ 6,986,714

$ 1,810,910

$ 1,517,233

$ 1,156,633

$ 2,759,688

$ 20,559,352

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

$

260,979

$ 451,316

$ 185,738

$

-

$

17,483

$

476,738

$ 1,392,254

999,606

712,893

420,262

-

29,045

-

2,161,806

Changes in:

Accounts Receivable

-

4,250

-

- - -

-

355

4,605

Accounts and Contracts Payable

40,586

(24,032)

(60,887)

3,126

8,240

(32,967)

Prepaid Expenses

- -

- -

- -

13,140

(11,297)

1,843

Compensated Absences Payable

(66,094) (66,094)

-

-

(66,094)

Total Adjustments

1,040,192

693,111

359,375

45,311

(2,702)

2,069,193

Net Cash Flows - Operating Activities

$ 1,301,171

$ 1,144,427

$ 545,113

$ (66,094)

$

62,794

$

474,036

$ 3,461,447

NONCASH INVESTING, CAPITAL AND FINANCING ACTIVITIES Contributions of Capital Assets from the Developers

$ $

19,006

$ $

-

$ 242,256

$ $

- - -

$ $

- - -

$ $

- - -

$ $

261,262

Transfer of Capital Assets

-

7,735

$

- -

7,735

Book Value of Capital Asset Trade-Ins

215,742

-

215,742

137