|
Surface Nonmajor Internal
<br />Water Service
<br />Water Sewer Management Recycling Totals Funds
<br />Cash flows from operating activities
<br />Receipts from customers and users 2,157,750$ 1,979,821$ 827,381$ 150,885$ 5,115,837$ 805,452$
<br />Payments to suppliers (1,552,264) (1,258,347) (234,444) (125,264) (3,170,319) (813,008)
<br />Payments to employees (286,291) (345,204) (202,166) (17,628) (851,289) (30,776)
<br />Payments for interfund services used (55,802) (57,399) (38,852) (4,172) (156,225) –
<br />Net cash flows from operating activities 263,393 318,871 351,919 3,821 938,004 (38,332)
<br />Cash flows from noncapital financing activities
<br />Grants received 73 84 57 24,441 24,655 –
<br />Cash paid to other funds – (133,652) – – (133,652) (27,404)
<br />Transfers out (135,396) (138,870) (197,324) – (471,590) –
<br />Net cash flows from noncapital
<br /> financing activities (135,323) (272,438) (197,267) 24,441 (580,587) (27,404)
<br />Cash flows from capital and related
<br /> financing activities
<br />Acquisition and construction of capital assets (123,886) (46,706) (63,082) – (233,674) –
<br />Cash flows from investing activities
<br />Earnings on investments 20,792 273 8,091 1,111 30,267 6,056
<br />Net change in cash and cash equivalents 24,976 – 99,661 29,373 154,010 (59,680)
<br />Cash and cash equivalents – beginning 798,259 – 312,817 115,299 1,226,375 481,140
<br />Cash and cash equivalents – ending 823,235$ –$ 412,478$ 144,672$ 1,380,385$ 421,460$
<br />Reconciliation of operating income (loss) to net
<br /> cash flows from operating activities
<br />Operating income (loss)(32,422)$ 15,884$ 353,947$ 3,353$ 340,762$ (100,156)$
<br />Adjustments to reconcile operating income (loss)
<br /> to net cash flows from operating activities
<br />Depreciation 238,736 164,833 85,311 – 488,880 –
<br />Decrease (increase) in customer receivables 30,298 183,677 (7,592) (387) 205,996 –
<br />Decrease (increase) in prepaid items (290) 61,412 (290) – 60,832 26,869
<br />Decrease (increase) in inventory 743 – – – 743 –
<br />Decrease (increase) in deferred outflows 62,287 71,594 48,304 – 182,185 –
<br />Increase (decrease) in accounts payable (57,039) (37,904) (76,641) (830) (172,414) 18,542
<br />Increase (decrease) in salaries payable (1,238) (1,600) (994) 111 (3,721) (142)
<br />Increase (decrease) in due to other governments 87,024 (64,008) – 1,520 24,536 17,645
<br />Increase (decrease) in net pension liability (95,986) (110,327) (74,438) – (280,751) –
<br />Increase (decrease) in compensated absences
<br /> payable (2,554) (3,579) (1,926) 54 (8,005) (1,090)
<br />Increase (decrease) in deferred inflows 33,834 38,889 26,238 – 98,961 –
<br />Total adjustments 295,815 302,987 (2,028) 468 597,242 61,824
<br />Net cash flows from operating activities 263,393$ 318,871$ 351,919$ 3,821$ 938,004$ (38,332)$
<br />Noncash investing, capital,
<br /> and financing activities
<br />Capital contributions 67,000$ 42,000$ 131,825$ –$ 240,825$ –$
<br />Business-Type Activities – Enterprise Funds
<br />CITY OF ARDEN HILLS
<br />Statement of Cash Flows
<br />Proprietary Funds
<br />Year Ended December 31, 2017
<br />See notes to basic financial statements -24-
|