|
Schedule 7
<br /> Indian River County
<br /> Pooled Interest Earnings Analysis
<br /> Comparison of Two Prior Fiscal Years With Current Fiscal Year
<br /> September 30,2013 Portfolio
<br /> Banks-(2)-Qualified Public Depositories Money Market Funds (7)
<br /> Treasuries 8 Agencies RBC-Bank Wells Faro-Bank SunTrust Bank Regions-Bank Regions-Lockbox FLGIT-Landfill 3 Day-to-Day 4 Utilities Reserve Benchmark
<br /> (1) 12 (6) One Year
<br /> Interest Interest Interest Interest Interest Interest Interest Month Interest Interest Average Constant
<br /> Mo/Yr Earned Return Earned Return Earned Return Earned Return Earned Return Earned Return Earned Return Earned Return Earned Return Total Return
<br /> Return Maturity
<br /> Oct-10 $ 151,431 0.81% S 11 0.19% $ 2,729 0.35% $ 2,007 0.22% S 7,155 0.75% $ 2,031 0.60% $ 31,772 2.81% $ 1,562 0.17% $ 1,960 044% $ 200,658 0.84%
<br /> 023%
<br /> Nov-10 $ 146,474 0.76% $ 70 0.19% $ 3,159 0.35% $ 1,813 0.22% $ 8,568 0.75% $ 2,463 0.60% $ (25,346) 2.01% $ 1,755 0.16% $ 1,960 0.44% $ 140,916 0.55%
<br /> 0.25%
<br /> Dec-10 $ 153,531 0.70% S 44 0.16% $ 2,982 0.24% $ 2,087 0.18% $ 9,045 0.75% $ 3,063 0,60% $ (30,823) 2.12% $ 1,529 0.15% $ 1,634 0.37% $ 143,092 0.51%
<br /> 0.29%
<br /> Jan-11 $ 158,546 0.70% $ 23 0.17% $ 2,316 0.25% $ 2,268 0.18% $ 9,570 0.75% $ 1,212 0.60% $ 26,671 1.84% $ 1,687 0.14% S 1,634 0 37% $ 203,927 0.72%
<br /> 017%
<br /> Feb-11 $ 151,347 0.67% $ 6 0.16% $ 2,600 0.25% $ 2,061 0.18% $ 8,662 0.75% $ 1.110 0.60% $ 2,034 1.68% $ 2,216 0.14% $ 1,634 0 37% $ 171.672 0.60%
<br /> 0.29%
<br /> Mar-11 $ 144,299 065% N/A N/A $ 2,611 0.25% $ 2,284 0.18% $ 9,597 0.75% $ 1,738 0.60% $ (1,744) 1.72% $ 1,536 0.15% $ 1,634 0.37% $ 161,955 0.57%
<br /> 0.26%
<br /> Apr-11 $ 142,140 0.66% N/A NIA $ 2,849 0.25% $ 2,210 0.18% $ 8,983 0.75% $ 2,203 0.60% $ 36,523 1.78% $ 1,340 0.14% $ 1.634 0.37% $ 197,882 0.71%
<br /> 0.25%
<br /> May-11 $ 126.070 0.60% NIA NIA $ 2,666 0.24% $ 2,111 0.17% $ 9,919 0.75% $ 2,800 0.60% $ 27,263 2.02% $ 948 0.12% $ 1,634 0.37% $ 173,411 0.63%
<br /> 0.191/6
<br /> Jun-11 $ 118,118 0.57% NIA NIA $ 2,887 0.25% $ 1,837 0.15% $ 9,294 0.75% S 1,128 0.60% $ (1,609) 1.68% $ 1,119 0.09% $ 1,739 0.39% $ 134,513 0.51%
<br /> 0.18%
<br /> Jul-11 $ 112,161 0.57% N/A NIA $ 2.448 0.25% $ 1,817 0.15% $ 8,682 0.75% S 1,705 0.60% $ 18,631 1.43% $ 630 0.08% $ 1,739 0.39% $ 147,813 0.57%
<br /> 0.19°/
<br /> Aug-11 $ 114,327 0.56% N/A N/A $ 2,541 0.25% $ 1,466 0.12% $ 9,909 0.75% $ 2,418 0.60% $ 7,275 1.20% $ 863 0.07% $ 1,739 0.39% $ 140,538 0.54%
<br /> 0.11%
<br /> Sep-11 $ 113,284 0.56% NIA N/A $ 2,468 0.25% $ 505 0.12% $ 6,998 0.75% $ 2,762 060x/ $ (16,397) 0.79% $ 1,515 008% $ 1,739 0.39% $ 114,874 0.45%
<br /> 0.10%
<br /> Oct-11 $ 112,720 0.56% N/A NIA $ 1,972 0.25% $ 687 0.12% $ 8,822 0.75% $ 1,830 0.60% $ 20,928 0.66% $ 1,057 0,09% $ 1,739 0.39% $ 149,755 0.60%
<br /> 0.11%
<br /> Nov-11 $ 113,695 0.57°/ N/A NIA $ 2,449 0.25% $ 781 0.10% $ 8,562 0.75% $ 2,245 0.60% $ (7,681) 0.85% $ 1,506 0.11% $ 1,739 039% $ 123,296 0.47%
<br /> 0.11%
<br /> Dec-11 $ 119,525 0.51% NIA N/A $ 2,480 0.25% $ 1,204 010% S 8,568 0.751/6 $ 2,431 0.60% $ 10,390 1.29% $ 1,943 0.14% $ 1,055 0.23% $ 147,596 0.51%
<br /> 0.12%
<br /> Jan-12 $ 116,759 0.50% N/A NIA S 2,267 0.25% $ 648 0.10% $ 4,706 0.39% $ 2,795 0.60% $ 49,426 1.50% $ 1,898 0.16% $ 1,302 0.29% $ 179,803 0.62%
<br /> 0.12%
<br /> Feb-12 $ 106,646 0.48% NIA N/A $ 2,438 0.25% $ 1,089 0.10% $ 3,853 0.35% $ 1,773 0.60% $ 9,916 1.58% $ 2,593 0.17% $ 1,302 0.29% $ 129,610 0.45%
<br /> 0.16%
<br /> Mar-12 $ 100,006 0.46% NIA NIA $ 2,557 0.25% $ 1,271 0.10% $ 3,987 0.35% $ 2,489 0.60% $ 6,112 1.66% $ 2,138 0.18% $ 1,302 0.29% $ 119,862 0.42%
<br /> 0.19%
<br /> Apr-12 $ 98,225 045% NIA NIA $ 2,286 0.25% $ 1,258 0.10% $ 4,121 0.35% $ 2,637 0.60% $ 23,647 1.51% $ 2,467 0.20% $ 1,302 0.29% $ 135,943 0.49%
<br /> 0.18%
<br /> May-12 $ 94.155 0.44% NIA N/A $ 2,205 0.25% $ 1,301 0.10% $ 4,122 0.35% $ 2,729 0.60% $ 8,910 1.31% $ 2,102 0.19% $ 1,302 0.29% $ 116,826 0.43%
<br /> 0.19%
<br /> Jun-12 $ 91,836 0.45% NIA N/A $ 2,176 0.25% $ 1,122 0.10% $ 3,857 0.35% $ 3,007 0.60% $ 17,204 1.50% $ 2,304 019% $ 802 016% $ 122,308 046%
<br /> 0.19%
<br /> Jul-12 $ 87,758 0.44% NIA NIA S 2,558 0.25% $ 1,112 010% $ 4,258 0.35% $ 3,026 0.60% $ 40,245 1,70% $ 2,037 0.19% $ 1,106 0.24% $ 142,100 0.55%
<br /> 0.19%
<br /> Aug-12 $ 84,170 0.44% N/A N/A S 2.318 0.25% $ 1,132 0.10% $ 4,126 0.35% $ 2.877 0.60% $ 16,715 1.79% S 1,870 0.18% $ 1,106 0.24% $ 114,314 0.46%
<br /> 0.18%
<br /> Sep-12 $ 81,572 0.44% N/A N/A $ 2,260 0.25% $ 1,055 0.10% $ 3,705 0.35% $ 3,072 0.601A $ 10,872 2,07% $ 2,146 0,18% $ 1,106 0.24% $ 105,788 043%
<br /> 0.18%
<br /> Oct-12 $ 78,538 0.43% NIA N/A $ 2,490 025% $ 1,119 0.10% $ 4,129 0.35% $ 2.938 0.60% $ 4,325 1.90% $ 1.934 0.18% $ 1,106 0.24% $ 96,579 0.39%
<br /> 0.18%
<br /> Nov-12 $ 80,929 0.41% N/A NIA $ 3,050 0.25% $ 988 0.10% $ 3,617 0.35% $ 3,048 0.60% $ 8,195 2.06% $ 1,880 0.19% $ 1,262 0.28% $ 102,969 0.40%
<br /> 0.18%
<br /> Dec-12 $ 81,102 0.37% NIA NIA $ 2,408 0.25% $ 1,164 0.10% $ 4,178 0.35% $ 2,765 0.60% $ 339 1.96% $ 1,693 018% $ 1,262 0.28% $ 94,911 0.33%
<br /> 0.16%
<br /> Jan-13 $ 69,467 0.33% NIA NIA $ 2,560 0.25% $ 1,243 0.10% $ 4,440 035% $ 3,090 0.60% $ 2,432 1.48% $ 1,396 0.16% S 1,262 0.28% $ 85.890 0.30%
<br /> 0.15%
<br /> Feb-13 S 67,326 0.31% NIA NIA $ 2,376 0.25% $ 1,134 0.10% $ 4,024 0.35% $ 2,699 0.60% $ 16.678 1.54% $ 1,793 0.14% $ 1,262 0.28°/ $ 97,292 0.35%
<br /> 0.16%
<br /> Mar-13 $ 66,593 0.31% NIA NIA $ 2,647 0.25% $ 1,151 0.10% $ 4,170 0.35% $ 2,481 0.60% $ 3,585 1.51% $ 1.356 0.13% $ 1,262 0.28% $ 83,245 0.30%
<br /> 0.15%
<br /> Apr-13 $ 64,262 0.30% NIA NIA $ 2,474 0.25% $ 722 0.08% $ 3,120 0.24% $ 2,891 0.60% $ 18.536 145% $ 1,490 012% $ 1,262 0.28% $ 94,757 0.35%
<br /> 012%
<br /> May-13 $ 62,908 0.30% NIA N/A $ 2,573 0.25% $ 696 0.08% $ 2,701 0.23% $ 2,966 0.60% $ (24,756) 1.13% $ 1,000 0.12% $ 1,262 0.28% $ 49,352 0.18%
<br /> 0.12%
<br /> Jun-13 $ 62,191 0.30% NIA NIA $ 2,445 0.25% $ 672 0.07% $ 2,271 0.23% $ 3,083 0.60% $ (35,180) 0.61% $ 881 0.10% $ 1,262 0.28% $ 37,625 0.14%
<br /> 0.14%
<br /> Jul-13 $ 56,919 0.28% N/A N/A $ 2,741 0.25% $ 696 0.07% $ 2,702 0.23% $ 3,011 0.60% $ 22,336 0.43% $ 699 0.09% $ 1,263 0.28% $ 90,367 0.35%
<br /> 0.12%
<br /> Aug-13 $ 56,203 0.28% NIA N/A $ 2,637 0.25% $ 696 0.07% $ 2,456 0.23% $ 3,204 OM% $ (8,589) 0.18% $ 646 0.08% $ 1,263 0.28% $ 58,516 0.23%
<br /> 0.13%
<br /> Sep-131 $ 54,148 0.29% NIA NIA $ 2,524 0.25% $ 673 0.07% $ 2,539 0.23% $ 2,895 0.60% S 29,674 0.36% $ 714 0.08% $ 1,263 0.28°/ $ 94,430 0.38%
<br /> 0.12%
<br /> Notes
<br /> 1)"Investments"are accrued interest on coupon instruments.
<br /> 2)"Bank"is cash received on the overnight investment of the County's cash in the bank. RBC bank account closed on February 11,2011.
<br /> 3)"FLGIT"is the change in market value of the Florida Local Government Investment Trust account A monthly return is not available;consequently,the 12 month return is provided.
<br /> 4) "Day-to-Day"is a money market fund managed by the FACC under the FLGIT umbrella,
<br /> 5) Federated Money Market Fund was 100%US Treasury investments. Return reflected is 30-day yield.Account dosed September 2010.
<br /> 6) Average return is computed by dividing total interest income for the month by the monthly cash balances listed on schedule 6. Does not include mark to market except for FLGIT
<br />landfill.
<br /> 7) Source of one-year treasury rates is the Federal Reserve website.
<br /> This report does not Include OPEB funds.
<br /> A
<br /> f11
<br />
|