|
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 />September 30, 2017
<br />(8,183,746)
<br />Fiscal Year 2011-2012
<br />Net Chane
<br />Month End Bal'
<br />$
<br />(7,163,713)
<br />$ 299,325,098
<br />$
<br />15,743,556
<br />$ 315,068,654
<br />$
<br />31,679,255
<br />$ 346,747,909
<br />$
<br />540,328
<br />$ 347,288,237
<br />$
<br />(3,953,214)
<br />$ 343,335,023
<br />$
<br />(4,018,678)
<br />$ 339,316,345
<br />$
<br />(6,018,427)
<br />$ 333,297,918
<br />$
<br />(5,148,326)
<br />$ 328,149,592
<br />$
<br />(12,048,463)
<br />$ 316,101,129
<br />$
<br />(5,284,467)
<br />$ 310,816,662
<br />$
<br />(10,999,198)
<br />$ 299,817,464
<br />$
<br />1,512,399
<br />$ 298,305,065
<br />(8,183,746)
<br />7,860,609
<br />Fiscal Year 2014-2015
<br />Net Chane
<br />Month End Bal*
<br />$
<br />(10,422,694)
<br />$
<br />287,937,696
<br />$
<br />19,342,864
<br />$
<br />307,280,560
<br />$
<br />35,786,179
<br />$
<br />343,066,739
<br />$
<br />(285,799)
<br />$
<br />342,780,940
<br />$
<br />(2,801,802)
<br />$
<br />339,979,138
<br />$
<br />281,107
<br />$
<br />340,260,245
<br />$
<br />(6,111,791)
<br />$
<br />334,148,454
<br />$
<br />(4,947,796)
<br />$
<br />329,200,658
<br />$
<br />(6,122,052)
<br />$
<br />323,078,606
<br />$
<br />(8,447,944)
<br />$
<br />314,630,662
<br />$
<br />(9,274,059)
<br />$
<br />305,356,603
<br />$
<br />864,396
<br />$
<br />306,220,999
<br />7,860,609
<br />7,985
<br />Fiscal Year 2012-2013
<br />Net Chane
<br />Month End Bal'
<br />Month End Bal'
<br />$
<br />(4,325,867)
<br />$
<br />293,979,198
<br />$
<br />16,251,425
<br />$
<br />310,230,623
<br />$
<br />29,931,173
<br />$
<br />340,161,796
<br />$
<br />130,635
<br />$
<br />340,292,431
<br />$
<br />(2,486,081)
<br />$
<br />337,806,350
<br />$
<br />(2,787,582)
<br />$
<br />335,018,768
<br />$
<br />(8,244,064)
<br />$
<br />326,774,704
<br />$
<br />(4,598,588)
<br />$
<br />322;176,116
<br />$
<br />(4,334,609)
<br />$
<br />. 317,841,507
<br />$
<br />(4,470,572)
<br />$
<br />313,370,935
<br />$
<br />(10,017,849)
<br />$
<br />303,353,086
<br />$
<br />5,040,036
<br />$
<br />298,313,050
<br />7,985
<br />$ 15,098,062
<br />Fiscal Year 2015-2016
<br />Net Chane
<br />Month End Bal'
<br />$
<br />(8,105,518)
<br />$ 298,115,481
<br />$
<br />25,830,326
<br />$ 323,945,807
<br />$
<br />35,536,011
<br />$ 359,481,818
<br />$
<br />(373,573)
<br />$ 359,108,245
<br />$
<br />906,675
<br />$ 360,014,920
<br />$
<br />256,335
<br />$ 360,271,255
<br />$
<br />(5,220,820)
<br />$ 355,050,435
<br />$
<br />(2,730,213)
<br />$ 352,320,222
<br />$
<br />(8,065,869)
<br />$ 344,254,353
<br />$
<br />(7,588,170)
<br />$" 336,666,183
<br />$
<br />(8,369,612)
<br />$ 328,296,571
<br />$
<br />6,977,510
<br />$ 321,319,061
<br />$ 15,098,062
<br />47,340
<br />Fiscal Year 2013-2014
<br />Net Chane
<br />Month End Bal'
<br />$
<br />(7,076,226)
<br />$
<br />291,236,824
<br />$
<br />13,411,135
<br />$
<br />304,647,959
<br />$
<br />33,565,914
<br />$
<br />338,213,873
<br />$
<br />(1,632,096)
<br />$
<br />336,581,777
<br />$
<br />(1,988,485)
<br />$
<br />334,593,292
<br />$
<br />(474,129)
<br />$
<br />334,119,163
<br />$
<br />(6,034,807)
<br />$
<br />328,084,356
<br />$
<br />(5,237,557)
<br />$
<br />322,846,799
<br />$
<br />(11,441,367)
<br />$
<br />311,405,432
<br />$
<br />(3,166,797)
<br />$
<br />308,238,635
<br />$
<br />(8,103,393)
<br />$
<br />300,135,242
<br />$
<br />(1.774,852 )1
<br />$
<br />298,360,390
<br />47,340
<br />18,257,137
<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 />22
<br />Fiscal Year 2016-2017
<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 />18,257,137
<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 />22
<br />
|