Laserfiche WebLink
6.C. - Page 66 of 196 <br />Operating income (loss) <br />Adjustments to reconcile operating income to net cash <br />provided by operating activities: <br />Depreciation <br />Change in assets and liabilities: <br />Decrease (increase) in accounts receivable <br />Decrease (increase) in due from other governmental agencies <br />Decrease (increase) in inventory/prepaid expenses/deposits <br />Decrease (increase) in pension deferred outflows <br />Decrease (increase) in OPEB deferred outflow <br />Increase (decrease) in vacation & sick leave payable <br />Increase (decrease)in accounts payable <br />Increase (decrease) in customer deposits <br />Increase (decrease) in unearned revenue <br />Increase (decrease) in net pension liability <br />Increase (decrease) in pension deferred inflows <br />Increase (decrease) in net OPEB liability <br />Increase (decrease) in OPEB deferred inflows <br />Increase (decrease) in insurance claims payable <br />Total adjustments <br />Net cash provided by (used in) operating activities <br />Noncash investing, capital and financing activities: <br />Proceeds on sale of equipment <br />Increase (decrease) in investment in sewer authority <br />Impairment loss on property held for development <br />Reconciliation of Net Cash Flow from Operating Activities <br />9,164,177 8,820,561 (2,142,918) 2,831,274 (674,013) 17,999,081 1,358,135 <br />3,279,479 <br />CITY OF REDWOOD CITY, CALIFORNIA <br />755,235 <br />1,730,886 <br />19,062 <br />6,820,126 <br />1,503,132 <br />PROPRIETARY FUNDS <br />150,361 <br />396,444 <br />1,564,791 <br />(22,205) <br />1,858,872 <br />STATEMENT <br />OF CASH FLOWS <br />(550,489) <br />910 <br />(535,240) <br />FOR THE FISCAL YEAR ENDED <br />JUNE 30, 2020 <br />2,068 <br />4,550 <br />(4,726) <br />21,163 <br />92,068 <br />327,189 <br />165,213 <br />95,144 <br />86,583 <br />15,019 <br />Governmental <br />538,047 <br />Water <br />Sewer <br />(36,874) <br />(47,344) <br />Non -Major <br />(129,213) <br />Activities - <br />102,909 <br />utility <br />Utility <br />Parking <br />Port of <br />Docktown <br />142,241 <br />Internal Service <br />(336,536) <br />Fund <br />Fund <br />Fund <br />Redwood City <br />Marina <br />Totals <br />Funds <br />Cash flows from operating activities: <br />$ <br />$ <br />$ <br />$ <br />$ <br />$ <br />$ <br />Cash received from customers <br />47,008,836 <br />41,951,483 <br />2,069,597 <br />10,330,191 <br />(3,854) <br />101,356,253 <br />19,954 <br />Cash received from interfund services provided <br />158,376 <br />124,001 <br />(388,867) <br />(192,231) <br />(80,470) <br />(62,417) <br />37,677,896 <br />Cash payments to suppliers for goods and services <br />(26,428,370) <br />(29,756,876) <br />(1,858,472) <br />(2,119,277) <br />(527,963) <br />(60,690,958) <br />(15,179,071) <br />Cash payments to employees for services <br />(5,250,190) <br />(2,683,353) <br />(1,096,447) <br />(1,953,017) <br />(183,022) <br />(11,166,029) <br />(17,655,278) <br />Net cash provided by (used in) operating activities <br />15,330,276 <br />9,511,254 <br />(885,322) <br />6,257,897 <br />(714,839) <br />29,499,266 <br />4,843,547 <br />Cash flows from noncapital financing activities: <br />(885,322) <br />6,257,897 <br />(714,839) <br />29,499,266 <br />4,843,547 <br />Nonoperating grant revenue <br />1,606 <br />37,342 <br />38,948 <br />Insurance recovery (loss) <br />(278) <br />(2,950) <br />(3,228) <br />Property taxes <br />447,594 <br />447,594 <br />Transfers in <br />777,404 <br />916,343 <br />4,366,141 <br />6,059,888 <br />1,401,727 <br />Transfers out <br />(50,188) <br />(588,822) <br />(639,010) <br />(13,357) <br />Advances from (to) other funds <br />(300,000) <br />850,000 <br />(3,850,000) <br />(3,300,000) <br />3,300,000 <br />Other <br />(6,411) <br />(408,830) <br />(415,241) <br />Net cash provided by (used in) noncapital financing activities <br />420,527 <br />(591,772) <br />2,215,543 <br />(371,488) <br />516,141 <br />2,188,951 <br />4,688,370 <br />Cash flows from capital and related financing activities: <br />Acquisition and construction of capital assets <br />(5,445,980) <br />(6,535,813) <br />(1,153) <br />(227,467) <br />(12,210,413) <br />(1,468,563) <br />Sale of property held for development <br />130,027 <br />130,027 <br />Contributions <br />586,422 <br />101,724 <br />50,000 <br />738,146 <br />Principal retirements <br />(2,316,054) <br />(852,429) <br />(3,168,483) <br />Interest paid <br />(1,699,246) <br />(492,087) <br />(56,595) <br />(2,247,928) <br />Net cash used in capital and related financing activities <br />(8,874,858) <br />(6,434,089) <br />48,847 <br />(1,571,983) <br />73,432 <br />(16,758,651) <br />(1,468,563) <br />Cash flows from investing activities: <br />Interest on investments <br />1,536,478 <br />953,296 <br />485,567 <br />292,088 <br />(15,355) <br />3,252,074 <br />1,506,974 <br />Net cash provided by investing activities <br />1,536,478 <br />953,296 <br />485,567 <br />292,088 <br />(15,355) <br />3,252,074 <br />1,506,974 <br />Net increase (decrease) in cash and cash equivalents <br />8,412,423 <br />3,438,689 <br />1,864,635 <br />4,606,514 <br />(140,621) <br />18,181,640 <br />9,570,328 <br />Cash and cash equivalents at beginning of fiscal year <br />38,874,974 <br />35,924,277 <br />16,832,877 <br />14,856,723 <br />410,051 <br />106,898,902 <br />45,304,225 <br />Cash and cash equivalents at end of fiscal year <br />47,287,397 <br />39,362,966 <br />18,697,512 <br />19,463,237 <br />269,430 <br />125,080,542 <br />54,874,553 <br />Financial statement presentation: <br />Cash and investments available for operations <br />47,269,748 <br />39,362,966 <br />9,327,087 <br />18,360,194 <br />269,430 <br />114,589,425 <br />54,874,553 <br />Cash and investments, restricted <br />17,649 <br />9,370,425 <br />1,103,043 <br />10,491,117 <br />Cash and cash equivalents at end of year <br />47,287,397 <br />39,362,966 <br />18,697,512 <br />19,463,237 <br />269,430 <br />125,080,542 <br />54,874,553 <br />Operating income (loss) <br />Adjustments to reconcile operating income to net cash <br />provided by operating activities: <br />Depreciation <br />Change in assets and liabilities: <br />Decrease (increase) in accounts receivable <br />Decrease (increase) in due from other governmental agencies <br />Decrease (increase) in inventory/prepaid expenses/deposits <br />Decrease (increase) in pension deferred outflows <br />Decrease (increase) in OPEB deferred outflow <br />Increase (decrease) in vacation & sick leave payable <br />Increase (decrease)in accounts payable <br />Increase (decrease) in customer deposits <br />Increase (decrease) in unearned revenue <br />Increase (decrease) in net pension liability <br />Increase (decrease) in pension deferred inflows <br />Increase (decrease) in net OPEB liability <br />Increase (decrease) in OPEB deferred inflows <br />Increase (decrease) in insurance claims payable <br />Total adjustments <br />Net cash provided by (used in) operating activities <br />Noncash investing, capital and financing activities: <br />Proceeds on sale of equipment <br />Increase (decrease) in investment in sewer authority <br />Impairment loss on property held for development <br />Reconciliation of Net Cash Flow from Operating Activities <br />9,164,177 8,820,561 (2,142,918) 2,831,274 (674,013) 17,999,081 1,358,135 <br />3,279,479 <br />1,035,464 <br />755,235 <br />1,730,886 <br />19,062 <br />6,820,126 <br />1,503,132 <br />(230,519) <br />150,361 <br />396,444 <br />1,564,791 <br />(22,205) <br />1,858,872 <br />(108,056) <br />14,339 <br />(550,489) <br />910 <br />(535,240) <br />232,056 <br />19,271 <br />2,068 <br />4,550 <br />(4,726) <br />21,163 <br />92,068 <br />327,189 <br />165,213 <br />95,144 <br />86,583 <br />15,019 <br />689,148 <br />538,047 <br />(34,830) <br />(10,165) <br />(36,874) <br />(47,344) <br />(129,213) <br />(57,935) <br />102,909 <br />32,864 <br />67,946 <br />(6,670) <br />2,400 <br />199,449 <br />142,241 <br />2,278,330 <br />(336,536) <br />(138,555) <br />(71,291) <br />(78,729) <br />1,653,219 <br />(54,042) <br />3,594 <br />(260) <br />3,472 <br />(422) <br />6,384 <br />448,476 <br />226,458 <br />96,905 <br />118,679 <br />20,587 <br />911,105 <br />737,501 <br />75,406 <br />38,076 <br />21,478 <br />19,954 <br />3,462 <br />158,376 <br />124,001 <br />(388,867) <br />(192,231) <br />(80,470) <br />(62,417) <br />(723,985) <br />(646,914) <br />271,322 <br />129,610 <br />75,143 <br />94,706 <br />570,781 <br />451,364 <br />531,949 <br />6,166,099 <br />690,693 <br />1,257,596 <br />3,426,623 <br />(40,826) <br />11,500,185 <br />3,485,412 <br />15,330,276 <br />9,511,254 <br />(885,322) <br />6,257,897 <br />(714,839) <br />29,499,266 <br />4,843,547 <br />2,498,610 2,498,610 <br />(1,054,510) (1,054,510) <br />See accompanying notes to financial statements <br />34 <br />153 <br />