HomeMy WebLinkAboutCash & Investment Balances with Graphs - Apr 2023CITY OF REXBURG CASH & INVESTMENT
FY 2023 BALANCE REPORT
% of Total
Portfolio
BALANCE
AS OF
CASH & INVESTMENTS Rate/Yield < 1 YEAR 1-2 Years 2-3 Years 3-4 Years 4-5 Years > 5 YEARS 4/30/2023
Bank of Commerce Bank CD 2.84%276,835 0.63%276,835
Westmark CD 2.05%258,127 0.59%258,127
Beehive Credit Union CD 2.48%250,153 0.57%250,153
East Idaho CU CD 2.02%507,051 1.16%507,051
Idaho Central Credit Union CD 2.97%250,025 0.57%250,025
Mountain America Credit Union 3.40%252,539 0.58%252,539
Total CDs 1,794,731 4.09%1,794,731
Moreton Asset Management 3.33%6,132,368 2,249,229 325,313 450,515 20.89%9,157,425
Zions Bank Capital Advisors 2.26%3,728,205 589,166 681,244 227,201 11.92%5,225,815
TVI - Bond Investment 2.50%1,941,572 3,883,144 684,709 2,054,127 825,403 21.40%9,379,576
State Diversified Bond Fund 3.02%918,797 2,240,303 853,952 9.15%4,013,052
State LGIP--City 4.54%10,055,810 90,839 23.15%10,146,649
State LGIP--Fire District 4.54%628,031 5,673 1.45%633,704
Total Managed Accounts 23,404,783 9,058,354 1,691,266 2,731,844 825,403 853,952 87.96%38,556,221
Key Bank Checking (RLF)0.01%350,905 0.80%350,905
Wells Fargo Drug Fund Checking 0.01%12,587 0.03%12,587
Wells Fargo Fire District Banking 0.03%521,880 1.19%521,880
Bank of Commerce Legacy FM 0.10%55,283 0.13%55,283
Zions Bank Collateralized Acct 0.20%1,500,080 3.42%1,500,080
Zions Bank General Checking NA 314,125 0.72%314,125
Zions Bank Payroll Checking NA 19,939 0.05%19,939
Total Bank Accounts 2,774,799 6.33%2,774,799
Cash On Hand NA 2,970 0.01%2,970
Real Estate Investments (Streets)NA 610,083 1.39%610,083
City Golf Cart CD 3.00%22,980 74,495 0.22%97,475
Total Other 636,033 74,495 1.62%710,528
GRAND TOTAL 28,610,346 9,058,354 1,691,266 2,731,844 899,898 853,952 100%43,836,279
% OF TOTAL PORTFOLIO 65.3%20.7%3.9%6.2%2.1%1.9%100%
2021 2022 2023 2024 Total
Interest 277,824.00 547,062.00 902,000.00 814,700.00 2,541,586.00
Unrealized (Gain) Loss (215,468.78) (1,343,307.80) 605,000.00 616,000.00 (337,776.58)
Accounts Included
Moreton Asset Management
Zions Capital Advisors
Time Value Investments
Managed Account Analysis
$(1,000,000)
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
US Gov Municipal CD Corp Agency
Bond
MMFund Cash
Types of Investments
Moreton Zions Capital Advisors TVI
AAA, 14,205,106 ,
59%
A+, 2,606,689 , 11%
AA-, 1,480,609 , 6%
NR, 1,415,750 , 6%
A, 1,234,630 , 5%
NA, 1,224,292 , 5%
AA+, 975,229 , 4%
A-1+, 500,646 , 2%
AA, 185,000 , 1%A-, 179,523 , 1%
Investment Ratings
-
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
AAA A+AA-NR A NA AA+A-1+AA A-
Rating of All Investments
Moreton Zions TVI