Laserfiche WebLink
4a UBS <br />Bond summary <br />as of June 30, 2022 <br />Bond overview <br />Total quantity <br />43,922,000 <br />Total market value <br />$40,632,679.24 <br />Total accrued interest <br />$253,964.48 <br />Total market value plus accrued interest <br />$40,886,643.72 <br />Total estimated annual bond interest <br />$934,661.40 <br />Average coupon <br />2.21 % <br />Average current yield <br />2.30% <br />Average yield to maturity <br />3.59% <br />Average yield to worst <br />3.58% <br />Average modified duration <br />4.11 <br />Average effective maturity <br />4.49 <br />Credit quality of bond holdings <br />Value on <br />% of <br />Effective credit rating Issues 06/30/2022 ($) <br />port. <br />A Aaa/AAA/AAA 18 6,439,347.19 <br />15.75 <br />B Aa/AA/AA 65 29,641,753.76 <br />72.47 <br />C A/A/A 1 262,996.93 0.64 <br />D Baa/BBB/BBB 1 272,194.90 0.67 <br />E Non -investment grade <br />0 <br />0.00 <br />0.00 <br />F Certificate of deposit <br />19 <br />4,270,350.93 <br />10.47 <br />G Not rated <br />0 <br />0.00 <br />0.00 <br />Total <br />104 <br />$40,886,643.72 <br />100% <br />F��A <br />D <br />c <br />B <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 4,270,350.93 0.00 4,270,350.93 10.44 <br />Municipals 36,014,236.55 102,151.24 36,116,387.78 88.33 <br />U.S. federal agencies 499,905.00 0.00 499,905.00 1.22 <br />Total $40,784,492.48 $102,151.24 $40,886,643.71 100% <br />Bond maturity schedule <br />$ Millions <br />7 <br />6 13.7 % <br />12.4% <br />5 <br />4 <br />3 <br />2 <br />1 <br />0 <br />2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2033 + 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 porfolio. Average yields and durations exclude Structured Product, Pass -Through, Perpetual Preferred, and Foreign securities. <br />Report created on: July 01, 2022 Page 3 of 23 <br />