Laserfiche WebLink
7 <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 />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 />June 30, 2023 <br />$ 29,278,971 $ 10,458,944 $ 12,246,355 <br />Fiscal Year 2017-2018 <br />Net Chane <br />Net Chane <br />Month End Bal* <br />$ <br />(7,971,324) <br />$ 331,604,874 <br />$ <br />33,131,597 <br />$ 364,736,471 <br />$ <br />41,846,074 <br />$ 406,582,545 <br />$ <br />(5,758,898) <br />$ 400,823,647 <br />$ <br />5,191,358 <br />$ 406,015,005 <br />$ <br />(4,784,411) <br />$ 401,230,594 <br />$ <br />1,577,951 <br />$ 402,808,545 <br />$ <br />(6,945,787) <br />$ 395,862,758 <br />$ <br />(9,710,169) <br />$ 386,152,589 <br />$ <br />(2,464,004) <br />$ 383,688,585 <br />$ <br />(8,022,779) <br />$ 375,665,806 <br />$ <br />6,810,637 <br />$ 368,855,169 <br />$ 29,278,971 $ 10,458,944 $ 12,246,355 <br />Fiscal Year 2018-2019 <br />Net Chane <br />Month End Bal* <br />$ <br />(6,577,674) <br />$ 362,277,495 <br />$ <br />48,128,205 <br />$ 410,405,700 <br />$ <br />31,350,078 <br />$ 441,755,778 <br />$ <br />(9,877,034) <br />$ 431,878,744 <br />$ <br />2,964,540 <br />$ 434,843,284 <br />$ <br />(2,750,051) <br />$ 432,093,233 <br />$ <br />(3,802,746) <br />$ 428,290,487 <br />$ <br />(8,379,243) <br />$ 419,911,244 <br />$ <br />(9,758,699) <br />$ 410,152,545 <br />$ <br />(13,728,763) <br />$ 396,423,782 <br />$ <br />(11,767,333) <br />$ 384,656,449 <br />$ <br />5,342,336 <br />$ 379,314,113 <br />$ 29,278,971 $ 10,458,944 $ 12,246,355 <br />Fiscal Year 2019-2020 <br />Net Change <br />Net Chane <br />Net Chane <br />Month End Bal* <br />$ <br />(9,260,244) <br />$ <br />370,053,869 <br />$ <br />39,158,339 <br />$ <br />409,212,208 <br />$ <br />47,023,081 <br />$ <br />456,235,289 <br />$ <br />(6,941,131) <br />$ <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 />$ <br />425,561,094 <br />$ <br />(13,546,695) <br />$ <br />412,014,399 <br />$ <br />(3,248,804) <br />$ <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 />$ 29,278,971 $ 10,458,944 $ 12,246,355 <br />36,762,945 $ 28,286,769 $ 51,794,410 <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 />36 <br />Fiscal Year 2020-2021 <br />Net Change <br />Net Chane <br />$ <br />Month End Bal* <br />$ <br />(8,561,737) <br />$ <br />382,998,731 <br />$ <br />39,238,741 <br />$ <br />422,237,472 <br />$ <br />57,117,548 <br />$ <br />479,355,020 <br />$ <br />(6,119,043) <br />$ <br />473,235,977 <br />$ <br />12,395,392 <br />$ <br />485,631,369 <br />$ <br />(12,127,894) <br />$ <br />473,503,475 <br />$ <br />(9,006,651) <br />$ <br />464,496,824 <br />$ <br />295,126 <br />$ <br />464,791,950 <br />$ <br />(5,748,174) <br />$ <br />459,043,776 <br />$ <br />(11,764,390) <br />$ <br />447,279,386 <br />$ <br />(11,517,721) <br />$ <br />435,761,665 <br />$ <br />7,438,252 <br />$ <br />428,323,413 <br />36,762,945 $ 28,286,769 $ 51,794,410 <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 />36 <br />Fiscal Year 2021-2022 <br />Net Change <br />Month End Bal* <br />$ <br />302,966 <br />$ 428,626,379 <br />$ <br />63,526,149 <br />$ 492,152,528 <br />$ <br />25,611,495 <br />$ 517,764,023 <br />$ <br />872,988 <br />$ 518,637,011 <br />$ <br />(7,201,984) <br />$ 511,435,027 <br />$ <br />(17,106,146) <br />$ 494,328,881 <br />$ <br />(11,640,607) <br />$ 482,688,274 <br />$ <br />(5,845,338) <br />$ 476,842,936 <br />$ <br />(9,580,769) <br />$ 467,262,167 <br />$ <br />6,361,893 <br />$ 473,624,060 <br />$ <br />(5,770,624) <br />$ 467,853,436 <br />$ <br />(11,243,254) <br />$ 456,610,182 <br />36,762,945 $ 28,286,769 $ 51,794,410 <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 />36 <br />Fiscal Year 2022-2023 <br />Net Change <br />Month End Bal* <br />$ <br />(11,358,975) <br />$ 445,251,207 <br />$ <br />81,589,406 <br />$ 526,840,613 <br />$ <br />23,718,570 <br />$ 550,559,183 <br />$ <br />(3,315,030) <br />$ 547,244,153 <br />$ <br />(5,588,003) <br />$ 541,656,150 <br />$ <br />(8,973,954) <br />$ 532,682,196 <br />$ <br />(5,667,237) <br />$ 527,014,959 <br />$ <br />(4,896,353) <br />$ 522,118,606 <br />$ <br />(13,714,014) <br />$ 508,404,592 <br />36,762,945 $ 28,286,769 $ 51,794,410 <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 />36 <br />