|
City of Roseville, MinnesotaStatement 8
<br />STATEMENT OF CASH FLOWS (Page 1 of 1)
<br />PROPRIETARY FUNDS
<br />For the Fiscal Year Ended December 31, 2023
<br /> Business-type Activities - Enterprise FundsGovernmental
<br />Activities -
<br />
<br />StormSolid WasteInternal
<br />Sanitary SewerWaterGolf CourseDrainageRecyclingTotalService Funds
<br />CASH FLOWS FROM OPERATING ACTIVITIES
<br /> Cash received from customers and users, including deposits $ 6,333,466$ 9,868,841$ 394,610$ 2,809,319$ 9 52,725$ 20,358,961$ 343,585
<br />
<br /> Cash payments to suppliers for goods and services (3,798,363) (8,272,090) (138,154) (656,194) (865,966)(13,730,767)(506,986)
<br /> Cash payments to employees(392,938)(686,085)(364,130)(510,048)(65,476)(2,018,677)12,122
<br /> Other operating revenues 6,975149,024 104,47612,771 - 273,246 -
<br />S 1,059,6902,149,140 (3,198) 1,655,848 2 4,882,7631,283 (151,279)
<br />NET CASH PROVIDED (USED) BY OPERATING ACTIVITIE
<br />CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES
<br /> Transfers In From Other Funds- 500,000 - - - 500,000-
<br /> Advance Repayment to Other Funds - (347,521) - - - (347,521)
<br /> -
<br /> Advance Repayment From Other Funds347,521- - - - 347,521-
<br /> Subsidy from governmental grants - 11,280 - 81,908 8 8,826 182,014
<br /> -
<br />NET CASH PROVIDED (USED) BY NONCAPITAL FINANCING ACTIVITIES 163,759347,521 81,908- 88,826 682,014 -
<br />CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES
<br /> Purchase of capital assets(355,243) (45,893) - (619,480) - (1,020,616)-
<br /> Subsidy from governmental grants 349,840 - - - - 349,840
<br /> -
<br /> Lease - GASB 87(19,845)(20,061)(10,464)(19,845)(70,215)-
<br /> Interest paid on capital debt - (36,100) - - - (36,100)
<br /> -
<br /> Bond Payment- (240,000)- - - (240,000)-
<br /> Proceeds from sale of capital assets 16,986 7,090 - 2,338 - 26,414
<br /> -
<br />NET CASH PROVIDED (USED) IN CAPITAL AND RELATED
<br /> FINANCING ACTIVITIES (334,964)(8,262) (10,464) (636,987) (990,677)- -
<br />CASH FLOWS FROM INVESTING ACTIVITIES
<br />Interest received on investments 68,103 9,967 2,686 45,185 8,235 134,176 29,859
<br />
<br />Increase (Decrease) in Fair Value of Investments (81,086) (60,466) 4,506 (30,314) 5,096 (162,264)
<br /> 71,331
<br />NET CASH PROVIDED (USED) BY INVESTING ACTIVITIES (50,499)(12,983) 7,192 14,871 13,331 (28,088) 101,190
<br />NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS 2,475,416 (6,470)837,986 1,115,640 123,440 (50,089)4,546,012
<br />
<br />CASH AND CASH EQUIVALENTS, JANUARY 1 as restated1,305,067 - 94,538 1,151,333 319,449 1,448,6932,870,387
<br />CASH AND CASH EQUIVALENTS, DECEMBER 313,780,483 837,986 88,068 2,266,973 442,889 1,398,6047,416,399
<br />RECONCILIATION OF OPERATING INCOME (LOSS) TO
<br />NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES
<br />Operating Income (Loss) 1,842,338736,765(121,220) 1,063,717 95,2523,616,852 (451,823)
<br />Adjustments to Reconcile Operating Income to
<br /> Net Cash Provided (Used) by Operating Activities
<br /> Depreciation478,305 498,731 96,711 707,834 - 1,781,581 -
<br /> Pension related activity 6,622 12,992 6,849 10,601 1,018 38,082 -
<br />
<br /> Changes in elements affecting cash:
<br /> (Increase) Decrease in Accounts receivable (95,637) (123,040) (1,903) (174,683) (12,494) (407,757)
<br /> -
<br /> (Increase) Decrease in Special assessments (191,657) 762 - 4,216 - (186,679)
<br /> -
<br /> (Increase) Decrease in Due from other governmental units (2,976) - - 27,674 -
<br /> 24,698 -
<br /> (Increase) Decrease in Prepaid items (36,839) - - (1,896) - (38,735)
<br /> -
<br /> Increase (Decrease) in Accounts payable 186,879 23,818 (946) (892) (64,271) 144,588
<br /> 13,711
<br /> Increase (Decrease) in Accrued payroll (92) (518) 583 82 1,091 1,146
<br /> -
<br /> Increase (Decrease) in Compensated absences 5,089 (450) 21,190 5,238 - 31,067
<br /> -
<br /> Increase (Decrease) in Contracts payable (32,360) - - 22,783 - (9,577)
<br /> -
<br /> Increase (Decrease) in Customer deposits - (92,398) - - - (92,398)
<br /> -
<br /> Increase (Decrease) in Due to other governmental units 230 11,671 (56) (183) 687 12,349
<br /> -
<br /> Increase (Decrease) in Net other postemployment benefits obligation (10,762) (8,643) (4,406) (8,643) - (32,454)
<br /> -
<br /> Increase (Decrease) in Insurance claim payable - - - - - -
<br /> 286,833
<br /> Total Adjustments 322,925306,802 118,022 592,131 (73,969) 1,265,911 300,544
<br />NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES$ 2,149,140$ 1,059,690$ 1,655,848(3,198)$ $ 21,283$ 4,882,763$ (151,279)
<br />
<br />NONCASH INVESTING, CAPITAL AND FINANCING ACTIVITIES
<br /> Increase/(Decrease) in fair value of investments(81,086)$ (60,466)$ 4,506$ (30,314)$ $ 5,096$ (162,264)$
<br /> 71,331
<br />The notes to the financial statements are an integral part of this statement.
<br />39
<br />Qbhf!71!pg!494
<br />
<br />
|