Information #2 07-17-2023 - Laserfiche WebLink

Home Browse Search

UBS RX •City of Elk River •Business Service Account Preparedpared for City of Elk River Risk profile: Conservative Return Objective: Current Income Bond Summary as of June 30, 2023 Bond Overview Investment Type Allocation Total quantity 48,312,000 % of Total market value $42,987,597.35 Tax-exempt / bond Investment type Taxable ($) deferred ($) Total ($) port. Total accrued interest $277,856.74 Total market value plus accrued interest $43,265,454.09 Certificates of deposit 3,951,285.98 0.00 3,951,285.98 9.13 Total estimated annual bond interest $1,048,894.70 Municipals 38,727,439.87 102,013.24 38,829,453.11 89.75 Average coupon 2.25% U.S. federal agencies 484,715.00 0.00 484,715.00 1.12 Average current yield 2.44% Total $43,163,440.85 $102,013.24 $43,265,454.09 100% Average yield to maturity 5.10% Average yield to worst 5.10% Average modified duration 3.89 Average effective maturity 4.25 Credit Quality of Bond Holdings Bond Maturity Schedule Value on % of $ Millions Effective credit rating Issues 06/30/2023 ($) port. 7 A Aaa/AAA/AAA 20 5,949,449.21 13.76 6 12 9% 0 13.6% 13.4% 11.6% 12.0% 11.7% B Aa/AA/AA 85 32,857,985.02 75.93 F� A 5 10.6% 10.0% C A/A/A 1 247,600.97 0.57 n 4 D Baa/BBB/BBB 1 259,132.90 0.60 C 3 E Non -investment grade 0 0.00 0.00 2 3.8% F Certificate of deposit 18 3,951,285.98 9.15 1 g 0 0.00/00.00/00.00/00.00/00.0% G Not rated 0 0.00 0.00 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2034 + Other Total 125 $43,265,454.09 100% Effective maturity schedule Cash, mutual funds and some preferred securities are not included. Includes 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 02, 2023 Page 3 of 37