2021 Annual Comprehensive Financial Report

CITY OF SHAKOPEE

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

Information and Technology

Employee Benefits

Self Insurance

Total

Equipment

Buildings

Park Asset

CASH FLOWS - OPERATING ACTIVITIES Receipts from Customers and Users

1,156,193 $

1,082,250 $

593,000 $

$

-

$

616,276

1,109,335 $

4,557,054 $

Receipts from Interfund Services

-

-

-

130,720

-

-

130,720

Payments to Suppliers

(86,561)

(42,439)

(35)

-

(386,871)

(757,957)

(1,273,863)

Net Cash Flows - Operating Activities

1,069,632

1,039,811

592,965

130,720

229,405

351,378

3,413,911

CASH FLOWS - NONCAPITAL FINANCING ACTIVITIES Payment Paid on Interfund Loan

- - -

(60,000) (16,500)

- - -

- - -

- - -

- -

(60,000) (16,500)

Interest Expense on Interfund Loan Repayment

Insurance Dividends

-

142,519

142,519

Net Cash Flows - Noncapital Financing Activities

-

(76,500)

-

-

-

142,519

66,019

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

-

- -

100,000

- - -

- - -

- - -

100,000 79,777

79,777

-

Acquisition of Capital Assets

(1,125,652)

(423,042)

(865,275)

(2,413,969)

Net Cash Flows - Capital and Related Financing Activities

(1,045,875)

(423,042)

(765,275)

-

-

-

(2,234,192)

CASH FLOWS - INVESTING ACTIVITIES Interest Received (Loss)

(50,257)

(51,889)

(15,047)

(13,714)

(7,697)

(17,680)

(156,284)

Net Cash Flows - Investing Activities

(50,257)

(51,889)

(15,047)

(13,714)

(7,697)

(17,680)

(156,284)

(26,500)

488,380

(187,357)

117,006

221,708

476,217

1,089,454

Net Change in Cash and Cash Equivalents

CASH AND CASH EQUIVALENTS Beginning of Year

5,713,125

6,164,352

1,648,837

1,532,986

924,572

1,848,315

17,832,187

5,686,625 $

6,652,732 $

1,461,480 $

1,649,992 $

1,146,280 $

2,324,532 $

18,921,641 $

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

$

189,000

307,059 $

160,139 $

$

-

$

222,632

$

347,978

1,226,808 $

914,132

693,948

432,861

-

29,045

-

2,069,986

Changes in:

Accounts Receivable

-

(4,250) 43,054

-

- - -

1,067

(1,213) 1,224

(4,396) (1,168) (8,039)

Accounts and Contracts Payable

(33,500)

(35)

(11,911) (11,428)

Prepaid Expenses

- -

- -

- -

3,389

Compensated Absences Payable

130,720 130,720

-

-

130,720

Total Adjustments

880,632

732,752

432,826

6,773

3,400

2,187,103

Net Cash Flows - Operating Activities

1,069,632 $

1,039,811 $

592,965 $

130,720 $

$

229,405

$

351,378

3,413,911 $

NONCASH INVESTING, CAPITAL AND FINANCING ACTIVITIES Transfer of Capital Assets Book Value of Capital Asset Trade-Ins

$

-

$

- -

184,988 $

$

- -

$

- -

$

- -

$

184,988 109,203

109,203

-

136