|
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 />December 31, 2020
<br />15,098,062 $ 18,257,137 $ 29,278,971
<br />Fiscal Year 2015-2016
<br />Net Chane
<br />Net Chane
<br />Month End Bal`
<br />Month End Bal'
<br />$
<br />(8,105,518)
<br />$
<br />298,115,481
<br />$
<br />25,830,326
<br />$
<br />323,945,807
<br />$
<br />35,536,011
<br />$
<br />359,481,818
<br />$
<br />(373,573)
<br />$
<br />359,108,245
<br />$
<br />906,675
<br />$
<br />360;014,920
<br />$
<br />256,335
<br />$
<br />360,271,255
<br />$
<br />(5,220,820)
<br />$
<br />355,050,435
<br />$
<br />(2,730,213)
<br />$
<br />352,320,222
<br />$
<br />(8,065,869)
<br />$
<br />344,254,353
<br />$
<br />(7,588,170)
<br />$
<br />336,666,183
<br />$
<br />(8,369,612)
<br />$
<br />328,296,571
<br />$
<br />6,977,510
<br />$
<br />321,319,061
<br />15,098,062 $ 18,257,137 $ 29,278,971
<br />Fiscal Year 2016-2017
<br />Net Chane
<br />Net Chane
<br />Month End Bal`
<br />$
<br />(6,856,660)
<br />$
<br />314,462,401
<br />$
<br />29,862,090
<br />$
<br />344,324,491
<br />$
<br />37,277,098
<br />$
<br />381,601,589
<br />$
<br />(931,868)
<br />$
<br />380,669,721
<br />$
<br />(2,015,776)
<br />$
<br />378,653,945
<br />$
<br />442,916
<br />$
<br />379,096,861
<br />$
<br />(2,740,420)
<br />$
<br />376,356,441
<br />$
<br />(4,378,477)
<br />$
<br />371,977,964
<br />$
<br />(6,628,797)
<br />$
<br />365,349,167
<br />$
<br />(10,868,408)
<br />$
<br />354,480,759
<br />$
<br />(9,027,471)
<br />$
<br />345,453,288
<br />$
<br />5,877,090
<br />$
<br />339,576,198
<br />15,098,062 $ 18,257,137 $ 29,278,971
<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 />15,098,062 $ 18,257,137 $ 29,278,971
<br />Fiscal Year 2020-2021
<br />Fiscal Year 2018-2019
<br />Net Chane
<br />Net Chane
<br />Month End Bal'
<br />$
<br />(6,577,674)
<br />$
<br />362,277,495
<br />$
<br />48,128,205
<br />$
<br />410,405,700
<br />$
<br />31,350,078
<br />$
<br />441,755,778
<br />$
<br />(9,877,034)
<br />$
<br />431,878,744
<br />$
<br />2,964,540
<br />$
<br />434,843,284
<br />$
<br />(2,750,051)
<br />$
<br />432,093,233
<br />$
<br />(3,802,746)
<br />$
<br />428,290,487
<br />$
<br />(8,379,243)
<br />$
<br />419,911,244
<br />$
<br />(9,758,699)
<br />$
<br />410,152,545
<br />$
<br />(13,728,763)
<br />$
<br />396,423,782
<br />$
<br />(11,767,333)
<br />$
<br />384,656,449
<br />$
<br />5,342,336
<br />$
<br />379,314,113
<br />Fiscal Year 2020-2021
<br />Fiscal Year 2019-2020
<br />Net Chane
<br />Month End Bal'
<br />$
<br />(9,260,244)
<br />$ 370,053,869
<br />$
<br />39,158,339
<br />$ 409,212,208
<br />$
<br />47,023,081
<br />$ 456,235,289
<br />$
<br />(6,941,131)
<br />$ 449,294,158
<br />$
<br />(1,465,745)
<br />$ 447,828,413
<br />$
<br />(5,997,667)
<br />$ 441,830,746
<br />$
<br />(5,331,833)
<br />$ 436,498,913
<br />$
<br />(10,937,819)
<br />$ 425,561,094
<br />$
<br />(13,546,695)
<br />$ 412,014,399
<br />$
<br />(3,248,804)
<br />$ 408,765,595
<br />$
<br />(7,041,321)
<br />$ 401,724,274
<br />$
<br />10,163,806
<br />$ 391,560,468
<br />Fiscal Year 2020-2021
<br />Net Chane Month End Bal
<br />$ (8,561,737)
<br />$ 382,998,731
<br />$ 39,238,741
<br />$ 422,237,472
<br />$ 57,117,548
<br />$ 479,355,020
<br />10,458,944 $ 12,246,355 $ 87,794,552
<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 />31
<br />
|