|
October
<br />November
<br />December
<br />January
<br />February
<br />March
<br />April
<br />May
<br />June
<br />July
<br />August
<br />September
<br />Net cash flow
<br />October
<br />November
<br />December
<br />January
<br />February
<br />March
<br />April
<br />May
<br />June
<br />July
<br />August
<br />September
<br />Net cash flow
<br />Schedule 6
<br />Indian River County
<br />Change in Monthly Cash Flows For All Pooled Cashllnvestment Accounts
<br />Comparison of Six Fiscal Years
<br />September 30, 2022
<br />18,257,137
<br />Fiscal Year 2016-2017
<br />Month End Bal*
<br />Net Chane
<br />Month End Bal*
<br />S
<br />(6,856,660)
<br />$ 314,462,401
<br />S
<br />29,862,090
<br />S 344,324,491
<br />$
<br />37,277,098
<br />$ 381,601,589
<br />$
<br />(931,868)
<br />S 380,669,721
<br />$
<br />(2,015,776)
<br />$ 378,653,945
<br />$
<br />442,916
<br />S 379,096,861
<br />$
<br />(2,740,420)
<br />$ 376,356,441
<br />$
<br />(4,378,477)
<br />S 371,977,964
<br />$
<br />(6,628,797)
<br />S 365,349,167
<br />S
<br />(10,868,408)
<br />$ 354,480,759
<br />S
<br />(9,027,471)
<br />S 345,453,288
<br />$
<br />5,877,090
<br />S 339,576,198
<br />18,257,137
<br />12,246,355
<br />Fiscal Year 2017-2018
<br />Fiscal Year 2019-2020
<br />Month End Bal*
<br />Net Chane
<br />S 331,604,874
<br />Month End Bal*
<br />$
<br />(9,260,244)
<br />$
<br />370,053,869
<br />S
<br />39,158,339
<br />$
<br />409,212,208
<br />$
<br />47,023,081
<br />S
<br />456,235,289
<br />$
<br />(6,941,131)
<br />S
<br />449,294,158
<br />$
<br />(1,465,745)
<br />$
<br />447,828,413
<br />$
<br />(5,997,667)
<br />$
<br />441,830,746
<br />$
<br />(5,331,833)
<br />$
<br />436,498,913
<br />$
<br />(10,937,819)
<br />S
<br />425,561,094
<br />$
<br />(13,546,695)
<br />$
<br />412,014,399
<br />$
<br />(3,248,804)
<br />S
<br />408,765,595
<br />$
<br />(7,041,321)
<br />$
<br />401,724,274
<br />$
<br />(10,163,806)
<br />$
<br />391,560,468
<br />12,246,355
<br />Fiscal Year 2017-2018
<br />Net Chane
<br />Month End Bal*
<br />S (7,971,324)
<br />S 331,604,874
<br />S 33,131,597
<br />$ 364,736,471
<br />$ 41,846,074
<br />S 406,582,545
<br />S (5,758,898)
<br />$ 400,823,647
<br />$ 5,191,358
<br />S 406,015,005
<br />S (4,784,411)
<br />$ 401,230,594
<br />1,577,951
<br />S 402,808,545
<br />S (6,945,787)
<br />$ 395,862,758
<br />$ (9,710,169)
<br />S 386,152,589
<br />S (2,464,004)
<br />S 383,688,585
<br />S (8,022,779)
<br />$ 375,665,806
<br />S 6,810,637
<br />S 368,855,169
<br />S 29,278,971
<br />Fiscal Year 2020-2021
<br />Net Change
<br />Month End Bal*
<br />$ (8,561,737)
<br />S 382,998,731
<br />S 39,238,741
<br />$ 422,237,472
<br />S 57,117,548
<br />$ 479,355,020
<br />S (6,119,043)
<br />$ 473,235,977
<br />$ 12,395,392
<br />$ 485,631,369
<br />$ (12,127,894)
<br />$ 473,503,475
<br />$ (9,006,651)
<br />$ 464,496,824
<br />S 295,126
<br />$ 464,791,950
<br />(5,748,174)
<br />S 459,043,776
<br />S (11,764,390)
<br />S 447,279,386
<br />S (11,517,721)
<br />$ 435,761,665
<br />S (7,438,252)
<br />S 428,323,413
<br />S 36,762,945
<br />Fiscal Year 2018-2019
<br />Net Chane
<br />Month End Bal*
<br />S (6,577,674)
<br />S 362,277,495
<br />S 48,128,205
<br />S 410,405,700
<br />S 31,350,078
<br />$ 441,755,778
<br />S (9,877,034)
<br />$ 431,878,744
<br />S 2,964,540
<br />$ 434,843,284
<br />$ (2,750,051)
<br />$ 432,093,233
<br />$ (3,802,746)
<br />S 428,290,487
<br />S (8,379,243)
<br />$ 419,911,244
<br />S (9,758,699)
<br />$ 410,152,545
<br />S (13,728,763)
<br />$ 396,423,782
<br />S (11,767,333)
<br />$ 384,656,449
<br />S 5,342,336
<br />$ 379,314,113
<br />10,458,944
<br />Fiscal Year 2021-2022
<br />Net Change
<br />Month End Bal*
<br />S 302,966
<br />$ 428,626,379
<br />$ 63,526,149
<br />$ 492,152,528
<br />$ 25,611,495
<br />$ 517,764,023
<br />S 872,988
<br />$ 518,637,011
<br />S (7,201,984)
<br />$ 511,435,027
<br />S (17,106,146)
<br />$ 494,328,881
<br />$ (11,640,607)
<br />$ 482,688,274
<br />S (5,845,338)
<br />$ 476,842,936
<br />S (9,580,769)
<br />$ 467,262,167
<br />$ 6,361,893
<br />$ 473,624,060
<br />S (5,770,624)
<br />$ 467,853,436
<br />S (11,243,253)
<br />S 456,610,183
<br />28,286,770
<br />*Schedule represents total assets in 801 fund -including portfolio accounts, FMV adjustments, cash in bank and utilities debt reserve.
<br />Excludes health insurance bank accounts utilized by Florida Blue and the Section 8 HUD bank account.
<br />Source: Balance Sheet for fund 801 (run by month)
<br />Schedule does not include OPEB investments - see separate report.
<br />47
<br />
|