2019 City of Shakopee Comprehensive Annual Financial Report

CITY OF SHAKOPEE

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

Information and Technology

Employee Benefits

Self Insurance

Total

Equipment

Buildings

Park Asset

CASH FLOWS - OPERATING ACTIVITIES Receipts from Customers and Users

$

988,600 (71,288)

1,037,000 $

451,124 $

$

- -

$

420,900 (397,376)

$

880,330 (813,553)

3,777,954 $

Payments to Suppliers Payments to Employees

(163,516)

(1,305)

(1,447,038) (121,579)

-

-

-

(121,579)

-

-

Net Cash Flows - Operating Activities

917,312

873,484

449,819

(121,579)

23,524

66,777

2,209,337

CASH FLOWS - NONCAPITAL FINANCING ACTIVITIES Payment Paid on Interfund Loan

- - - - - -

(60,000) (19,250)

- - - - -

- - - - - -

- - - - - -

- - -

(60,000) (19,250)

Interest Expense on Interfund Loan Repayment

Receipts from Interfund Services

55,000

55,000 24,282

Insurance Dividends

-

24,282

Transfer from Other Funds Transfer to Other Funds

2,084,504 (350,000)

- -

2,084,504 (2,434,504)

(2,084,504)

Net Cash Flows - Noncapital Financing Activities

-

1,710,254

(2,084,504)

-

-

24,282

(349,968)

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

-

-

5,000

- - -

- -

-

5,000

211,751 (347,037)

60,000

-

14,116

285,867 (666,816)

Acquisition of Capital Assets

(207,278)

(98,978)

(13,523)

-

Net Cash Flows - Capital and Related Financing Activities

(135,286)

(147,278)

(93,978)

-

(13,523)

14,116

(375,949)

CASH FLOWS - INVESTING ACTIVITIES Interest Received

158,839

191,413

46,781

43,010

25,816

50,745

516,604

Net Cash Flows - Investing Activities

158,839

191,413

46,781

43,010

25,816

50,745

516,604

940,865

2,627,873

(1,681,882)

(78,569)

35,817

155,920

2,000,024

Net Change in Cash and Cash Equivalents

CASH AND CASH EQUIVALENTS Beginning of Year

3,681,710

2,852,193

2,902,259

1,136,035

678,258

1,380,828

12,631,283

4,622,575 $

5,480,066 $

1,220,377 $

1,057,466 $

$

714,075

1,536,748 $

14,631,307 $

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

$

22,057

223,718 $

$

31,036

(216,518) $

$

66,916

$

52,911

$

180,120

895,255

681,847

418,783

-

24,557

-

2,020,442

Changes in:

Accounts Receivable

- - - -

-

- - - -

- - -

-

6,704 (5,748)

6,704

Accounts and Contracts Payable

(32,081)

(29,526) (38,423)

(67,355) (25,513)

Prepaid Expenses

- -

12,910

Compensated Absences Payable

94,939 94,939

-

-

94,939

Total Adjustments

895,255

649,766

418,783

(43,392)

13,866

2,029,217

Net Cash Flows - Operating Activities

$

917,312

873,484 $

449,819 $

(121,579) $

$

23,524

$

66,777

2,209,337 $

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

$

-

$

-

162,455 $

$

-

$

-

$

-

$

162,455

132