|
4*UBS
<br />Bond Summary
<br />as of March 31, 2024
<br />Bond Overview
<br />Total quantity
<br />48,428,000
<br />Total market value
<br />$44,870,179.85
<br />Total accrued interest
<br />$262,516.13
<br />Total market value plus accrued interest
<br />$45,132,695.98
<br />Total estimated annual bond interest
<br />$1,300,109.35
<br />Average coupon
<br />2.80
<br />Average current yield
<br />2.90
<br />Average yield to maturity
<br />4.89
<br />Average yield to worst
<br />4.89
<br />Average modified duration
<br />3.30
<br />Average effective maturity
<br />3.97
<br />Credit Quality of Bond Holdings
<br />Value on % of
<br />Effective credit rating Issues 03/31/2024 ($) porn
<br />A
<br />Aaa1AAA1AAA
<br />13
<br />4,481,400.16
<br />9.93
<br />B
<br />Aa1AA1AA
<br />64
<br />26,722,530.99
<br />59.18
<br />C
<br />AIAIA
<br />1
<br />257,826.00
<br />0.57
<br />D
<br />Baa1BBB1BBB
<br />1
<br />267,020.83
<br />0.59
<br />E
<br />Non -investment grade
<br />0
<br />0.00
<br />0.00
<br />F
<br />Certificate of deposit
<br />20
<br />4,634,678.76
<br />10.25
<br />G
<br />Not rated
<br />9
<br />8,769,2 39 23
<br />1947.
<br />Total
<br />108
<br />$45,132,695.98
<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 />Investment type
<br />Taxable ($)
<br />Tax exempt /
<br />deferred ($)
<br />Total ($)
<br />of
<br />bond
<br />port.
<br />Asset/Mortgage
<br />8,764,378.51
<br />0.00
<br />8,764,378.51
<br />1942.
<br />Certificates of deposit
<br />4,634,678.76
<br />0.00
<br />4,634,678.76
<br />10.27
<br />Municipals
<br />31,2 39,588 70
<br />0.00
<br />31,239,588.70
<br />69.22
<br />U.S. federal agencies
<br />494,050.00
<br />0.00
<br />494,050.00
<br />1.09
<br />Total
<br />$45,132,695.97
<br />$0.00
<br />$45,132,695.97
<br />100%
<br />Bond Maturity Schedule
<br />$ Millions
<br />7.5
<br />16.2% 16.8%
<br />G q 13.1%12.6%
<br />11.7%
<br />5.0 9.2% 8.6% 8.6%
<br />F
<br />0 2 5 2.8%
<br />C OB 0.0 ' 0.0% 0.0% 0.0% 0.0% 0.0%
<br />2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2035, 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 portfolio. Average yields and durations exclude Structured Product, Pass Through, Perpetual Preferred, and Foreign securities.
<br />Accrued interest, if any, has been included in the total market value.
<br />Report created on. April 01 , 2024 Page 3 of 33
<br />Page 192 of 201
<br />
|