Laserfiche WebLink
UBS <br />Bond summary <br />as of March 31, 2023 <br />Bond overview <br />Total quantity <br />47,984,000 <br />Total market value <br />$43,199,876.78 <br />Total accrued interest <br />$278,478.72 <br />Total market value plus accrued interest <br />$43,478,355.50 <br />Total estimated annual bond interest <br />$1,025,542.70 <br />Average coupon <br />2.22% <br />Average current yield <br />2.37% <br />Average yield to maturity <br />4.66% <br />Average yield to worst <br />4.65% <br />Average modified duration <br />3.95 <br />Average effective maturity <br />4.31 <br />Credit quality of bond holdings <br />Value on <br />% of <br />Effective credit rating Issues 03/31/2023 ($) <br />port. <br />A Aaa/AAA/AAA 22 7,081,750.05 <br />16.29 <br />B Aa/AA/AA 83 31,899,304.77 <br />73.36 <br />C A/A/A 1 249,195.00 0.57 <br />D Baa/BBB/BBB 1 269,470.83 0.62 <br />E Non -investment grade <br />0 <br />0.00 <br />0.00 <br />F Certificate of deposit <br />18 <br />3,978,634.85 <br />9.16 <br />G Not rated <br />0 <br />0.00 <br />0.00 <br />Total <br />125 <br />$43,478,355.50 <br />100% <br />RX XX694 • City of Elk River • Business Service Account <br />Prepared for City of Elk River <br />Risk profile: Conservative <br />Return Objective: Current Income <br />Investment type allocation <br />% of <br />Tax-exempt / bond <br />Investment type Taxable ($) deferred ($) Total ($) port. <br />Certificates of deposit 3,978,634.85 0.00 3,978,634.85 9.15 <br />Municipals 38,904,405.82 100,919.83 39,005,325.65 89.71 <br />U.S. federal agencies 494,395.00 0.00 494,395.00 1.14 <br />Total $43,377,435.67 $100,919.83 $43.478,355.50 100% <br />Bond maturity schedule <br />$ Millions <br />F� A 7 <br />D 6 <br />5 <br />C <br />4 <br />s 3 <br />2 <br />1 <br />0 <br />13.4 % <br />2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2034 + Other <br />Effective maturity schedule <br />Cash, mutual funds and some preferred securities are not included. <br />Includes all fixed income securities in the selected perfolio. Average yields and durations exclude Structured Product, Pass -Through, Perpetual Preferred, and Foreign securities. <br />Report created on: April 02, 2023 Page 3 of 26 <br />