Laserfiche WebLink
Prepared for City of Elk River <br /> RP 38694•City of Elk River•Business Service Account <br /> Risk profile: Conservative <br /> Return Objective: Current Income <br /> Bondsummary Includes all fixed-rate securities in the selected porfolio.Average yields and durations exclude Structured Product,Pass Through,Perpetual Preferred,and Foreign securities. <br /> as of June 30, 2014 <br /> Bond overview Investment type allocation <br /> Total quantity 30,400,000 <br /> Total market value $30,005,538.15 %of <br /> Total accrued interest $107,092.22 Tax-exempt/ bond <br /> Total market value plus accrued interest $30,112,630.37 Investment type Taxable($) deferred($) Total($) port. <br /> Total estimated annual bond interest $447,887.20 Certificates of deposit 6,033,399.67 0.00 6,033,399.67 20.04 <br /> Average coupon 1.51% Municipals 6,287,670.79 530,918.24 6,818,589.03 22.64 <br /> Average current yield 1.49% U.S.federal agencies 17,260,641.67 0.00 17,260,641.67 57.32 <br /> Average yield to maturity 1.69% <br /> Average yield to worst 1.47% Total $29,581,712.13 $530,918.24 $30,112,630.37 100% <br /> Average effective maturity 6.21 <br /> Credit quality of bond holdings Bond maturity schedule <br /> Value on %of $Millions <br /> Effective credit rating Issues 06/30/2014($) port. <br /> A Aaa/AAA/AAA 37 20,019,965.04 66.47 F 6 <br /> 16.8% <br /> B Aa/AA/AA 10 4,059,265.66 13.46 5 <br /> C A/A/A 0 0.00 0.00 6 4 12.7% 12}% <br /> D Baa/BBBBBB 0 0.00 0.00 n 20.5% <br /> E Non-investment grade 0 0.00 0.00 3 9s% d9.1% 1&4W.F Certificate of deposit 27 6,033,399.67 2007 2 _ <br /> G Not rated 0 0.00 0.00 3.6% as% A4.5% <br /> Total 74 $30,112,630.37 100% 1 .9% <br /> 0 <br /> 0.0% 0.0% <br /> 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2025+Other <br /> E Effective maturity schedule <br /> Cash,mutual funds and some preferred securities are not included. <br /> Report created on:July 21,2014 <br />