Loading...
HomeMy WebLinkAboutItem #2 City Investment FundsOption A Option B Current Acct Type Repo Sweep 3 Month CD Repo Sweep Rate Impact 3.00% See CD Rate Sheet (3.3% on 3 Month) 2.25% Balance 34,000,000 20,000,000 34,000,000 Yearly Interest 1,020,000 1,080,000 660,000(CD) + 420,000(Repo) 765,000 Insurance Investment I Securities I FDIC Investment Securities These investment values are not reported on the monthly "Combined Cash Investment" report Instead they are displayed as Investments on the respective Balance Sheets • Money market halance: $513,445.44 (most of this is from the $500k maturity that posted least month) Was reinvested in another Treasury Bond that matures on 11/15/2029 CITY OF CHUBBUCK CITY OF CHUBBUCK Estimated Estimated # CUSIP/Sec-LD Sec Desc 1 Weight Par Value Coupon 11 Settle Dt Mat [3t Nxt Call Dt Rating "** YTM ** YTW ** Duration Call Ty" Bos to Call Redem. Date 1 313CALF33 FHLB03/403/16/26 14.096 500,004 0.75 3/2512021 3/16/2026 NRAGY 0.83 0,83 (0,08) Quarterly 3/16/2026 2 313CAPAM7 FHLB 4.9 10/14/26 14.0% 500,000 0.90 10/15/2021 10114/2025 AA+ 0.97 0.97 0.49 Onetime 10114/2026 3 31422X194 FAMCA 4.15 10105/27 14.096 5OOr000 4.15 11/15/2023 1015/2027 NRAGY 4.50 4.50 1.42 10/5/2027 4 3130.41WN63 FHLB 4 06/30/28 14.096 500,000 4.00 11/16/2023 6130/2028 AA+ 4.44 4.44 2.08 6/30/2028 5 3130AFFXO FHLB 33/411/16/28 14.0% 500,000 3.25 11/1512023 11/1612028 AA+ 4.38 4.39 2.43 11/1612028 6 3133EP51_15 FFCB 4 1/8 03120/29 14.096 500,000 4.13 4/9/2024 3/20/2029 AA+ 4.38 4.38 2.74 3/2012029 7 91282CAE1 T 0 5/8 08115130 15.996 569,000 0.63 10/28/2425 8115/2030 AA+ 3.44 3.44 4.20 8115/2030 TOTAL and AVERAGES WW PERSI DEFERRED OUTFLOWS 3,569,000 2.51 SN LEASE ASSET 2.05 yrs 2.05 yrs 3.28 3.28 1.94 SN SU BSCRI PTIC N ASS ET `Semi -Annual interest payment ** Ym4ds calculated using cost price, at settlement date *** NR AGY = Non -Rated U.S. Government Agency • Money market halance: $513,445.44 (most of this is from the $500k maturity that posted least month) Was reinvested in another Treasury Bond that matures on 11/15/2029 7,210,706.90 CITY OF CHUBBUCK CITY OF CHUBBUCK BALANCE SHEET BALANCE SHEET APRIL 30, 2026 APRIL 30, 2026 SN SANITATION WATER UTILITY ASSETS ASSETS 33-1010000 SN CASH -COMBINED FUND 1,911,773.63 31-1014000 WW CASH -COMBINED FUND 4,173,794.91 33-1121000 SN INVESTMENTS (CERT.) 517,992.89 31-1121000 WW INVESTMENTS 2,962,390.95 31-1122000 WW INVESTMENT CHANGES IN MARK 34 990 01 33-1122000 SN INVESTMENT CHANGES IN MARKE [ 4,926.50] 33-1311000 SN ACCOUNTS RECEIVABLE 208,040.57 31-1311090 WW ACCOUNTS RECEIVABLE 439,490.95 33-1312000 SN ALLOWANCE FOR BAD DEBT [ 4,160.81] 31-1312000 WW ALLOWANCE FOR BAD DEBT [ 10,119340) 33-1691000 SN FIXED ASSETS 7,864,788.55 31-1690000 WW WATER RIGHTS 2,421,167.45 33-1691200 SNPERSIDEFERRED OUTFLOWS 92,622.78 31-1 691 00 0 WW FIXED ASSETS 32,779,932.48 31-1 691 20 0 WW PERSI DEFERRED OUTFLOWS 9262278 33-1693000 SN LEASE ASSET 5,994.05 33-1693100 SN SU BSCRI PTIC N ASS ET 2,165.81 31-1 691 50 0 WW WORK IN PROGRESS 33,790.75 33-1694000 SN ACCUMULATED AMORTIZATION -LE [ 4,709.47) 31-1693000 WW LEASE ASSET 6,201.05 33-1694100 SN ACCUM ULATED AMORTIZATION SU [ 806.17] 31-1 6931 0 0 WW 2,165-81 33-1694400 SN SUBSCRIPTION LIABILITY [ 722.52] 31-1694000 ORTI ATIOSSET ACCUM.SUBSCRIPTIONAMORTIZATION-LEASE WW ACCUMULATEDAMOR [ d, 825.32] 33-1700000 SN ACCUM ULATED DEPRECIATION [ 3,377,345.92) 31-1 6941 0 0 RATION WW ACCUMULATED AMORTIZATION SU [ 806.17] 31-1700000 WW ACCUMULATED DEPRECIATION [ 7,203,431.48} TOTAL ASSETS TOTAL ASSETS 35,719,388.97 7,210,706.90