|
RX XX694 • City of Elk River • Business Service AccountPrepared forCity of Elk RiverRisk profile:ConservativeReturn Objective:Current IncomeBond Summaryas of June 30, 2024Bond SummaryBond Overview48,873,000Total quantityTotal market value$45,133,154.45Total accrued interest$281,694.59Total market value plus accrued interest$45,414,849.03Total estimated annual bond interest$1,347,801.21Average yield to maturityAverage coupon2.88%5.04%2.99%5.04%Average current yieldAverage yield to worstAverage modified duration3.27Average effective maturity4.01Investment Type AllocationTaxable ($)Investment typeTotal ($)Tax-exempt /deferred ($)% ofbondport.Asset/Mortgage11,229,731.120.0011,229,731.1224.73Certificates of deposit4,145,650.390.004,145,650.399.13Municipals29,539,452.520.0029,539,452.5265.04U.S. federal agencies500,015.000.00500,015.001.10Total$45,414,849.03$0.00$45,414,849.03100%Credit Quality of Bond Holdings128.76Aaa/AAA/AAAA3,993,619.126256.15Aa/AA/AAB25,509,617.2410.57A/A/AC260,305.9710.60Baa/BBB/BBBD271,032.9000.00Non-investment gradeE0.00189.12Certificate of depositF4,145,650.391324.81Not ratedG11,234,623.42Total100%$45,414,849.03107Effective credit rating% ofport.Value on06/30/2024 ($)IssuesBond Maturity ScheduleEffective maturity schedule2024202520262027202820292030203120322033203420352035 +Other0.02.55.07.54.3%13.0%12.6%8.6%16.1%15.2%16.6%9.7%3.4%0.0%0.0%0.0%0.0%0.0%Cash, mutual funds and some preferred securities are not included.$ MillionsIncludes all fixed income securities in the selected portfolio. Average yields and durations exclude Structured Product, Pass-Through, Perpetual Preferred, and Foreign securities.Accrued interest, if any, has been included in the total market value.Report created on: July 01, 2024Page 3of 33Page 389 of 389
|