|
CITY OF REDWOOD CITY, CALIFORNIA
<br />INTERNAL SERVICE 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 />Equipment Self Internal Employee
<br />Services Insurance Services Benefits
<br />Fund Fund Fund Fund Total
<br />$$$$$
<br />Cash flows from operating activities:
<br /> Cash received from interfund services provided 4,709,860 9,278,842 10,244,955 8,758,450 32,992,107
<br /> Cash payments to suppliers for goods and services (1,678,730) (7,504,531) (2,349,529) (3,895,610) (15,428,400)
<br /> Cash payments to employees for services (987,197) (456,724) (8,248,378) (4,093,340) (13,785,639)
<br /> Net cash provided by (used in) operating activities 2,043,933 1,317,587 (352,952) 769,500 3,778,068
<br />Cash flows from noncapital financing activities
<br /> Insurance recovery 53,088 53,088
<br /> Transfers in 1,000,000 1,000,000
<br /> Transfers out (8,565)(8,565)
<br /> Advances to other funds 300,000 300,000
<br /> Contributions
<br /> Net cash provided by (used in) non‐capital financing activities 353,088 1,000,000 (8,565)1,344,523
<br />Cash flows from capital and related financing activities:
<br /> Acquisition and construction of capital assets (708,807)(170,753)(879,560)
<br /> Contributions 172,178 172,178
<br /> Proceeds from sale of capital assets
<br /> Net cash used in capital and related financing activities (708,807)1,425 (707,382)
<br />Cash flows from investing activities:
<br /> Interest on investments 135,623 76,141 2,367 38,800 252,931
<br /> Net cash provided by investing activities 135,623 76,141 2,367 38,800 252,931
<br /> Net increase (decrease) in cash and cash equivalents 1,823,837 2,393,728 (357,725) 808,300 4,668,140
<br /> Cash and cash equivalents at beginning of year 12,039,220 22,657,313 860,855 797,191 36,354,579
<br /> Cash and cash equivalents at end of year 13,863,057 25,051,041 503,130 1,605,491 41,022,719
<br />Reconciliation of Net Cash Flow from Operating Activities
<br />Operating income (loss)867,649 623,487 (788,595) 768,983 1,471,524
<br />Adjustments to reconcile operating income(loss) to
<br /> net cash provided by operating activities:
<br /> Depreciation 1,167,892 142,998 1,310,890
<br /> Change in assets and liabilities:
<br /> Decrease (increase) in accounts receivable 1,620 161,768 163,388
<br /> Decrease (increase) in due from other governmental agencies (21,900)(50,151)(72,051)
<br /> Decrease (increase) in inventory/prepaid expense/deposits (14,766) (5,000) (3,522)(23,288)
<br /> Increase (decrease) in vacation & sick leave payable 12,285 42,733 55,018
<br /> Increase (decrease) in accounts payable 3,912 (127,767) 109,179 517 (14,159)
<br /> Increase (decrease) in deferred outflows ‐ pension (245,600) (103,245) (1,934,144)(2,282,989)
<br /> Increase (decrease) in deferred employer contributions 118,141 58,781 1,279,374 1,456,296
<br /> Increase (decrease) in deferred inflows ‐ pension (245,750) (108,105) (1,812,713)(2,166,568)
<br /> Increase (decrease) in net pension liability 400,450 164,017 2,661,889 3,226,356
<br /> Increase (decrease) in insurance claims payable 653,651 653,651
<br /> Total adjustments 1,176,284 694,100 435,643 517 2,306,544
<br />Net cash provided by (used in) operating activities 2,043,933 1,317,587 (352,952) 769,500 3,778,068
<br />Noncash investing, capital and financing activities:
<br />Gain (loss) on disposal of equipment (12,553)(5,734)(18,287)
<br />122
<br />6.1.E. - Page 145
|