|
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 Cash/Investment Accounts
<br />Comparison of Six Fiscal Years
<br />March 31, 2024
<br />Fiscal Year 2018-2019
<br />Net Chane
<br />Month End Bal*
<br />$ (6,577,674)
<br />$ 362,277,495
<br />$ 48,128,205
<br />$ 410,405,700
<br />$ 31,350,078
<br />$ 441,755,778
<br />$ (9,877,034)
<br />$ 431,878,744
<br />$ 2,964,540
<br />$ 434,843,284
<br />$ (2,750,051)
<br />$ 432,093,233
<br />$ (3,802,746)
<br />$ 428,290,487
<br />$ (8,379,243)
<br />$ 419,911,244
<br />$ (9,758,699)
<br />$ 410,152,545
<br />$ (13,728,763)
<br />$ 396,423,782
<br />$ (11,767,333)
<br />$ 384,656,449
<br />$ 5,342,336
<br />$ 379,314,113
<br />10,458, 944
<br />28,286,769
<br />Fiscal Year 2019-2020
<br />Fiscal Year 2021-2022
<br />Month End Bal*
<br />Net Chane
<br />$ 370,053,869
<br />Month End Bal*
<br />$
<br />302,966
<br />$
<br />428,626,379
<br />$
<br />63,526,149
<br />$
<br />492,152,528
<br />$
<br />25,611,495
<br />$
<br />517,764,023
<br />$
<br />872,988
<br />$
<br />518,637,011
<br />$
<br />(7,201,984)
<br />$
<br />511,435,027
<br />$
<br />(17,106,146)
<br />$
<br />494,328,881
<br />$
<br />(11,640,607)
<br />$
<br />482,688,274
<br />$
<br />(5,845,338)
<br />$
<br />476,842,936
<br />$
<br />(9,580,769)
<br />$
<br />467,262,167
<br />$
<br />6,361,893
<br />$
<br />473,624,060
<br />$
<br />(5,770,624)
<br />$
<br />467,853,436
<br />$
<br />11,243,254
<br />$
<br />456,610,182
<br />28,286,769
<br />Fiscal Year 2019-2020
<br />Net Chane
<br />Month End Bal*
<br />$ (9,260,244)
<br />$ 370,053,869
<br />$ 39,158,339
<br />$ 409,212,208
<br />$ 47,023,081
<br />$ 456,235,289
<br />$ (6,941,131)
<br />$ 449,294,158
<br />$ (1,465,745)
<br />$ 447,828,413
<br />$ (5,997,667)
<br />$ 441,830,746
<br />$ (5,331,833)
<br />$ 436,498,913
<br />$ (10,937,819)
<br />$ 425,561,094
<br />$ (13,546,695)
<br />$ 412,014,399
<br />$ (3,248,804)
<br />$ 408,765,595
<br />$ (7,041,321)
<br />$ 401,724,274
<br />$ 10,163,806
<br />$ 391,560,468
<br />$ 12,246,355
<br />Fiscal Year 2022-2023
<br />Net Change
<br />Month End Bal*
<br />$ (11,358,975)
<br />$ 445,251,207
<br />$ 81,589,406
<br />$ 526,840,613
<br />$ 23,718,570
<br />$ 550,559,183
<br />$ (3,315,030)
<br />$ 547,244,153
<br />$ (5,588,003)
<br />$ 541,656,150
<br />$ (8,973,954)
<br />$ 532,682,196
<br />$ (5,667,237)
<br />$ 527,014,959
<br />$ (4,896,353)
<br />$ 522,118,606
<br />$ (13,714,014)
<br />$ 508,404,592
<br />$ (8,047,244)
<br />$ 500,357,348
<br />$ (8,246,160)
<br />$ 492,111,188
<br />$ (8,025,537)
<br />$ 484,085,651
<br />$ 27,475,469
<br />36,762,945
<br />Fiscal Year 2020-2021
<br />Net Chane
<br />Month End Bal*
<br />$
<br />(8,561,737)
<br />$ 382,998,731
<br />$
<br />39,238,741
<br />$ 422,237,472
<br />$
<br />57,117,548
<br />$ 479,355,020
<br />$
<br />(6,119,043)
<br />$ 473,235,977
<br />$
<br />12,395,392
<br />$ 485,631,369
<br />$
<br />(12,127,894)
<br />$ 473,503,475
<br />$
<br />(9,006,651)
<br />$ 464,496,824
<br />$
<br />295,126
<br />$ 464,791,950
<br />$
<br />(5,748,174)
<br />$ 459,043,776
<br />$
<br />(11,764,390)
<br />$ 447,279,386
<br />$
<br />(11,517,721)
<br />$ 435,761,665
<br />$
<br />7,438,252
<br />$ 428,323,413
<br />36,762,945
<br />$ 103,520,743
<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 />57
<br />Fiscal Year 2023-2024
<br />Net Change
<br />Month End Bal*
<br />$
<br />(8,145,759)
<br />$ 475,939,892
<br />$
<br />42,826,990
<br />$ 518,766,882
<br />$
<br />87,015,826
<br />$ 605,782,708
<br />$
<br />(13,694,107)
<br />$ 592,088,601
<br />$
<br />8,819,498
<br />$ 600,908,099
<br />$
<br />(13,301,705)
<br />$ 587,606,394
<br />$ 103,520,743
<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 />57
<br />
|