Laserfiche WebLink
4a UBS <br />Bond summary <br />as of September 30, 2022 <br />Bond overview <br />Total quantity <br />45,387,000 <br />Total market value <br />$40,299,424.30 <br />Total accrued interest <br />$258,043.09 <br />Total market value plus accrued interest <br />$40,557,467.39 <br />Total estimated annual bond interest <br />$963,878.70 <br />Average coupon <br />2.20% <br />Average current yield <br />2.39% <br />Average yield to maturity <br />4.68% <br />Average yield to worst <br />4.68% <br />Average modified duration <br />3.91 <br />Average effective maturity <br />4.29 <br />Credit quality of bond holdings <br />Value on <br />% of <br />Effective credit rating Issues 09/30/2022 ($) <br />port. <br />A Aaa/AAA/AAA 17 5,849,391.87 <br />14.42 <br />B Aa/AA/AA 73 29,990,432.17 <br />73.93 <br />C A/A/A 1 244,231.97 0.60 <br />D Baa/BBB/BBB 1 255,624.15 0.63 <br />E Non -investment grade <br />0 <br />0.00 <br />0.00 <br />F Certificate of deposit <br />19 <br />4,217,787.23 <br />10.42 <br />G Not rated <br />0 <br />0.00 <br />0.00 <br />Total <br />111 <br />$40,557,467.39 <br />100% <br />D <br />'A <br />C <br />6 <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 />Investment type <br />Taxable ($) <br />Tax-exempt / <br />deferred ($) <br />Total ($) <br />% of <br />bond <br />port. <br />Certificates of deposit <br />4,217,787.23 <br />0.00 <br />4,217,787.23 <br />10.40 <br />Municipals <br />35,750,004.17 <br />100,905.99 <br />35,850,910.16 <br />88.40 <br />U.S. federal agencies <br />488,770.00 <br />0.00 <br />488,770.00 <br />1.21 <br />Total <br />$40,456,561.40 <br />$100,905.99 <br />$40,557,467.39 <br />100% <br />Bond maturity schedule <br />$ Millions <br />7 <br />6 13.7 % <br />12.3 <br />5 10.9% <br />4 <br />7.9 <br />3 <br />2 3.4 <br />1 — <br />0 <br />Effective maturity schedule <br />Cash, mutual funds and some preferred securities are not included. <br />2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2033 + Other <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: October 02, 2022 Page 3 of 25 <br />