2018 City of Shakopee Comprehensive Annual Financial Report

CITY OF SHAKOPEE

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

Information and Technology

Employee Benefits

Self Insurance

Total

Equipment

Buildings

Park Asset

CASH FLOWS - OPERATING ACTIVITIES Receipts from Customers and Users

$

897,463

579,400 $

806,280 $

$

-

$

400,900

$

858,677

3,542,720 $

Receipts from Interfund Services

-

-

-

46,293

-

-

46,293

Payments to Suppliers

(67,344)

14,420

(64,726)

-

(384,034)

(735,058)

(1,236,742)

Net Cash Flows - Operating Activities

830,119

593,820

741,554

46,293

16,866

123,619

2,352,271

CASH FLOWS - NONCAPITAL FINANCING ACTIVITIES Payment Paid on Interfund Loan

- - - - -

(60,000) (20,625)

- - - - -

- - - - -

- - - - -

- - -

(60,000) (20,625) 918,435 26,150 (470,000)

Interest Expense on Interfund Loan Repayment

Receipts from Interfund Services

918,435

Insurance Dividends Transfer to Other Funds

-

26,150

(470,000)

-

Net Cash Flows - Noncapital Financing Activities

-

367,810

-

-

-

26,150

393,960

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

-

- -

5,000

- - -

- -

-

5,000

188,699

-

6,704

195,403

Acquisition of Capital Assets

(1,193,792)

(154,361)

(85,439)

(52,738)

-

(1,486,330)

Net Cash Flows - Capital and Related Financing Activities

(1,005,093)

(154,361)

(80,439)

-

(52,738)

6,704

(1,285,927)

CASH FLOWS - INVESTING ACTIVITIES Interest Received

56,065

46,313

32,256

15,672

9,377

7,225

166,908

Net Cash Flows - Investing Activities

56,065

46,313

32,256

15,672

9,377

7,225

166,908

Net Change in Cash and Cash Equivalents

(118,909)

853,582

693,371

61,965

(26,495)

163,698

1,627,212

CASH AND CASH EQUIVALENTS Beginning of Year

3,800,619

1,998,611

2,208,888

1,074,070

704,753

1,217,130

11,004,071

End of Year

3,681,710 $

2,852,193 $

2,902,259 $

1,136,035 $

$

678,258

1,380,828 $

12,631,283 $

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

$

(26,851)

(127,197) $

333,887 $

$

(86,088)

$

103,161

$

139,485

$

336,397

860,407

684,115

431,742

-

17,686

-

1,993,950

Changes in:

Accounts Receivable

8,163

-

-

- - -

-

(6,704)

1,459

Accounts and Contracts Payable

(11,600)

36,902

(24,075)

(73,940) (30,041)

5,972

(66,741) (45,175)

- -

(15,134)

Prepaid Expenses

- -

- -

Compensated Absences Payable

132,381 132,381

-

-

132,381

Total Adjustments

856,970

721,017

407,667

(86,295)

(15,866)

2,015,874

Net Cash Flows - Operating Activities

$

830,119

593,820 $

741,554 $

$

46,293

$

16,866

$

123,619

2,352,271 $

132