|
CITY OF REDWOOD CITY, CALIFORNIA
<br />PROPRIETARY FUNDS
<br />COMBINING STATEMENT OF CASH FLOWS
<br />INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS
<br />FOR THE FISCAL YEAR ENDED JUNE 30, 2017
<br />Governmental
<br />Water Sewer Non‐Major Activities ‐
<br />Utility Utility Parking Port of Docktown Internal Service
<br />Fund Fund Fund Redwood City Marina Totals Funds
<br />Cash flows from operating activities:$$$$$ $$
<br /> Cash received from customers 35,742,186 36,148,617 1,918,784 7,062,837 633,134 81,505,558
<br /> Cash received from interfund services provided 32,992,107
<br /> Cash payments to suppliers for goods and services (23,877,870) (20,635,363) (576,123) (1,382,475) (1,075,134) (47,546,965) (15,428,400)
<br /> Cash payments to employees for services (5,251,690) (2,899,551) (1,246,467) (1,330,764) (199,791) (10,928,263) (13,785,639)
<br /> Right of way compensation (2,262,500) (1,865,119) (42,000)(4,169,619)
<br /> Net cash provided by (used in) operating activities 4,350,126 10,748,584 54,194 4,349,598 (641,791) 18,860,711 3,778,068
<br />Cash flows from noncapital financing activities:
<br /> Nonoperating grant revenue 61,904 1,568 4,134 67,606
<br /> Insurance recovery 658 658 53,088
<br /> Property taxes 213,553 213,553
<br /> Transfers in 691,113 101,815 2,406,537 3,199,465 1,000,000
<br /> Transfers out (517,835)(517,835) (8,565)
<br /> Advances to other funds (300,000)(300,000) 300,000
<br /> Other (212,875)(427,583)(640,458)
<br /> Net cash provided by (used in) noncapital financing activities 240,800 (517,835) 316,936 (423,449) 2,406,537 2,022,989 1,344,523
<br />Cash flows from capital and related financing activities:
<br /> Acquisition and construction of capital assets (2,781,050) (4,516,806) (1,267,836) (768,287)(9,333,979) (879,560)
<br /> Contributions 1,689,862 226,185 4,925,000 6,841,047 172,178
<br /> Principal retirements (7,153,940)(770,416)(7,924,356)
<br /> Interest paid (2,203,986)(610,928)(2,814,914)
<br /> Proceeds from sale of capital assets
<br /> Net cash used in capital and related financing activities (10,449,114) (4,290,621) 3,657,164 (2,149,631) (13,232,202) (707,382)
<br />Cash flows from investing activities:
<br /> Interest on investments 31,978 225,236 83,774 107,911 27,915 476,814 252,931
<br /> Net cash provided by investing activities 31,978 225,236 83,774 107,911 27,915 476,814 252,931
<br /> Net increase (decrease) in cash and cash equivalents (5,826,210) 6,165,364 4,112,068 1,884,429 1,792,661 8,128,312 4,668,140
<br /> Cash and cash equivalents at beginning of year 36,697,382 25,342,608 10,460,482 16,020,945 2,947,246 91,468,663 36,354,579
<br /> Cash and cash equivalents at end of year 30,871,172 31,507,972 14,572,550 17,905,374 4,739,907 99,596,975 41,022,719
<br />Financial statement presentation:
<br />Cash and investments available for operations 30,824,060 31,507,972 9,171,661 16,844,610 4,739,907 93,088,210 41,022,719
<br />Cash and investments, restricted 47,112 ‐ 5,400,889 1,060,764 ‐ 6,508,765 ‐
<br /> Cash and cash equivalents at end of year 30,871,172 31,507,972 14,572,550 17,905,374 4,739,907 99,596,975 41,022,719
<br />Reconciliation of Net Cash Flow from Operating Activities
<br />Operating income (loss)2,301,122 10,393,249 (1,040,327) 2,458,285 (714,782) 13,397,547 1,471,524
<br />Adjustments to reconcile operating income to net cash
<br /> provided by operating activities:
<br /> Depreciation 3,027,920 670,287 564,852 1,562,952 32,258 5,858,269 1,310,890
<br /> Change in assets and liabilities:
<br /> Decrease (increase) in accounts receivable (461,620) (157,482) (47,645) (66,922) (60,926) (794,595) 163,388
<br /> Decrease (increase) in due from other governmental agencies (547,638) (762,681)(1,310,319) (72,051)
<br /> Decrease (increase) in inventory/prepaid expenses/deposits (8,115) 956,763 25,161 973,809 (23,288)
<br /> Increase (decrease) in vacation & sick leave payable 3,641 23,010 2,930 81,726 111,307 55,018
<br /> Increase (decrease) in accounts payable (110,954) (445,101) 515,874 188,979 95,183 243,981 (14,159)
<br /> Increase (decrease) in customer deposits 7,287 1,800 1,893 705 11,685
<br /> Increase (decrease) in unearned revenue 52 52
<br /> Increase (decrease) in deferred employer contributions 851,905 397,983 181,195 (32,759) 55,629 1,453,953 1,456,296
<br /> Increase (decrease) in other pension deferred outflows (1,327,590) (699,047) (323,447) (341,751) (71,066) (2,762,901) (2,282,989)
<br /> Increase (decrease) in other pension deferred inflows (1,308,666) (624,070) (317,293) (91,696) (49,866) (2,391,591) (2,166,568)
<br /> Increase (decrease) in net pension liability 1,922,834 995,673 516,255 500,752 71,074 4,006,588 3,226,356
<br /> Increase (decrease) in net OPEB obligation 31,463 31,463
<br /> Increase (decrease) in insurance claims payable 653,651
<br /> Total adjustments 2,049,004 355,335 1,094,521 1,891,313 72,991 5,463,164 2,306,544
<br /> Net cash provided by (used in) operating activities 4,350,126 10,748,584 54,194 4,349,598 (641,791) 18,860,711 3,778,068
<br />Noncash investing, capital and financing activities:
<br />Noncash capital contributions 207,190 23,046 230,236
<br />Gain (loss) on disposal of equipment (18,287)
<br />Increase (decrease) in investment in sewer authority 153,112 153,112
<br />See accompanying notes to financial statements
<br />32
<br />6.1.E. - Page 55
|