|
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, 2019
<br />Fiscal Year 2013-2014
<br />Net Change Month End Bal*
<br />$ (7,076,226)
<br />$ 291,236,824
<br />$ 13,411,135
<br />$ 304,647,959
<br />$ 33,565,914
<br />$ 338,213,873
<br />$ (1,632,096)
<br />$ 336,581,777
<br />$ (1,988,485)
<br />$ 334,593,292
<br />$ (474,129)
<br />$ 334,119,163
<br />$ (6,034,807)
<br />$ 328,084,356
<br />$ (5,237,557)
<br />$ 322,846,799
<br />$ (11,441,367)
<br />$ 311,405,432
<br />$ (3,166,797)
<br />$ 308,238,635
<br />$ (8,103,393)
<br />$ 300,135,242
<br />$ (1,774,852)
<br />$ 298,360,390
<br />$ 47,340
<br />Fiscal Year 2016-2017
<br />Net Change Month End Bal*
<br />$ (6,856,660)
<br />$ 314,462,401
<br />$ 29,862,090
<br />$ 344,324,491
<br />$ 37,277,098
<br />$ 381,601,589
<br />$ (931,868)
<br />$ 380,669,721
<br />$ (2,015,776)
<br />$ 378,653,945
<br />$ 442,916
<br />$ 379,096,861
<br />$ (2,740,420)
<br />$ 376,356,441
<br />$ (4,378,477)
<br />$ 371,977,964
<br />$ (6,628,797)
<br />$ 365,349,167
<br />$ (10,868,408)
<br />$ 354,480,759
<br />$ (9,027,471)
<br />$ 345,453,288
<br />$ (5,877,090)
<br />$ 339,576,198
<br />$ 18,257,137
<br />Fiscal Year 2014-2015
<br />Net Change Month End Bal*
<br />$ (10,422,694)
<br />$ 287,937,696
<br />$ 19,342,864
<br />$ 307,280,560
<br />$ 35,786,179
<br />$ 343,066,739
<br />$ (285,799)
<br />$ 342,780,940
<br />$ (2,801,802)
<br />$ 339,979,138
<br />$ 281,107
<br />$ 340,260,245
<br />$ (6,111,791)
<br />$ 334,148,454
<br />$ (4,947,796)
<br />$ 329,200,658
<br />$ (6,122,052)
<br />$ 323,078,606
<br />$ (8,447,944)
<br />$ 314,630,662
<br />$ (9,274,059)
<br />$ 305,356,603
<br />$ 864,396
<br />$ 306,220,999
<br />$ 7,860,609
<br />Fiscal Year 2017-2018
<br />Net Change Month End Bal*
<br />$ (7,971,324)
<br />$ 331,604,874
<br />$ 33,131,597
<br />$ 364,736,471
<br />$ 41,846,074
<br />$ 406,582,545
<br />$ (5,758,898)
<br />$ 400,823,647
<br />$ 5,191,358
<br />$ 406,015,005
<br />$ (4,784,411)
<br />$ 401,230,594
<br />$ 1,577,951
<br />$ 402,808,545
<br />$ (6,945,787)
<br />$ 395,862,758
<br />$ (9,710,169)
<br />$ 386,152,589
<br />$ (2,464,004)
<br />$ 383,688,585
<br />$ (8,022,779)
<br />$ 375,665,806
<br />$ (6,810,637)
<br />$ 368,855,169
<br />$ 29,278,971
<br />Fiscal Year 2015-2016
<br />Net Change Month End Bal*
<br />$ (8,105,518)
<br />$ 298,115,481
<br />$ 25,830,326
<br />$ 323,945,807
<br />$ 35,536,011
<br />$ 359,481,818
<br />$ (373,573)
<br />$ 359,108,245
<br />$ 906,675
<br />$ 360,014,920
<br />$ 256,335
<br />$ 360,271,255
<br />$ (5,220,820)
<br />$ 355,050,435
<br />$ (2,730,213)
<br />$ 352,320,222
<br />$ (8,065,869)
<br />$ 344,254,353
<br />$ (7,588,170)
<br />$ 336,666,183
<br />$ (8,369,612)
<br />$ 328,296,571
<br />$ (6,977,510)
<br />$ 321,319,061
<br />$ 15,098,062
<br />Fiscal Year 2018-2019
<br />Net Change 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 />$ 63,238,064
<br />*Schedule represents total assets in 801 fund -including portfolio accounts, FMV adjustments, cash in bank and utilities debt reserve.
<br />Excludes two health insurance bank accounts utilized by BCBS 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 />40
<br />
|