Cities Index.
U.S. Bank Piper Sandler Investment Statements April

Menifee City Council
September 4, 2024

Document
U.S. Bank Piper Sandler Investment Statements April
Meeting
September 4, 2024
Body
Menifee City Council
Original file
642 KB
Text extracted from the city's file for reading and search. Open the original on cityofmenifee.primegov.com. That file is the official record.

This statement is for the period from
April 1, 2024
to
April 30, 2024
000003240 02 SP 000638706711850 S

CITY OF MENIFEE
ATTN: ROCHELLE CLAYTON
29844 HAUN ROAD
MENIFEE, CA 92586
If you have any questions regarding your account or this statement, please contact your Administrator.

IBRAHIMA KANE
CN-OH-W5IT
CN-OH-W5IT
425 WALNUT STREET
CINCINNATI OH 45202
TS CIN RC #6 - MANUAL
CN-OH-W6TC
Phone 513-632-4038
E-mail [email protected]
Portfolio Manager:
6891
00- -M -UC-UU -122-04
0509316-00-01888-04

FFFTDDFDFDTADDFDFAAATTFDAFDDFADATTTDFFTDTFADTATFTADAAFDADATFDADAD ACCOUNT NUMBER:
001051010931

CITY OF MENIFEE
QUESTIONS?

10101010101010101010
10111001011000101011
10101111001110010000
10010101000100000111
11101010010001011110
11000100101100100001
10010001000010000000
10010010100010001001
11010100001101001100
11001010010110000101
11000000110101011000
10101000001101011011
10000010001001101000
10100111111011000011
10001110110100110000
10001011010100100111
10100110111001110000
11010011010011101101
10011000101010110010
11111111111111111111

THIS PAGE WAS INTENTIONALLY LEFT BLANK

TABLE OF CONTENTS
........................................................................................ .................................................................................................... .................................................................................................. ..................................................................................................... ........................................................................................................... ................................................................................................. .....................................................................................................

Market Value Summary
Asset Summary
Income Summary
Cash Summary
Asset Detail
Transaction Detail
Bond Summary
1 2
3 4
5 8
9 6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Schedule
Page

10101010101010101010
10111001011000000011
10101111001110010000
10010101000000010111
11101010010001011110
11000100101100000001
10010001000010011000
10010001100000101101
11010100001101010000
11001010000000001101
11000000111001000000
10101001100100000011
10000010000011100100
10100001111100000011
10001010100010000100
10000011100011001101
10110010110110101010
11010111110010110101
10011010001010101010
11111111111111111111

THIS PAGE WAS INTENTIONALLY LEFT BLANK

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
1 of
10 MARKET VALUE SUMMARY
Taxable Interest
71,208.42
245,935.52
Fees and Expenses
-537.75
-2,146.05
Change in Investment Value
-72,030.00
88,220.00
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Current Period
04/01/24
to
04/30/24
Year-to-Date
01/01/24
to
04/30/24
Beginning Market Value
$64,529,719.26
$64,196,350.46
Ending Market Value
$64,528,359.93
$64,528,359.93
Current Period
04/01/24
to
04/30/24

10101010101010101010
10111001011000000011
10101111001010010000
10010101011100000111
11101010010001001110
11000100101100000001
10010001000010001000
10010000100100111101
11010100001100010100
11001010010100001101
11000000110010000000
10101001011101010011
10000011110000111000
10100110110101011011
10001001010001101000
10000110011011000111
10111100110101111010
11011100010001100101
10011000001010101010
11111111111111111111

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
2 of
10 ASSET SUMMARY
Cash & Equivalents
2,176,109.93

3.40 107,271.51
Taxable Bonds
62,352,250.00

96.60 595,250.00
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Assets
Current Period
Market Value
% of
Total
Estimated
Annual Income
Total Market Value
$64,528,359.93
100.00
$702,521.51

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
3 of
10 INCOME SUMMARY
Taxable Interest
71,208.42
245,935.52
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Income Received
Current Period
Income Received
YTD
Total Current Period Income
$71,208.42
$245,935.52

10101010101010101010
10111001011000000011
10101111001010010000
10010101011000011111
11101010010001010110
11000100101101011001
10010000000010111100
10010111100101100011
11010100001011001110
11001010000101101101
11000000110010110000
10101000010111100011
10000011110000011000
10100001000111000011
10001001101001000000
10000001000001110011
10100001111001111010
11010111110100010101
10011001101010110010
11111111111111111111

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
4 of
10 CASH SUMMARY
Taxable Interest
71,208.42
71,208.42
Fees and Expenses
-537.75
-537.75
Net Money Market Activity
-70,670.67
-70,670.67
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Principal
Cash
Income
Cash
Total
Cash
Beginning Cash 04/01/2024
-$1,602,928.96
$1,602,928.96
$0.00
Ending Cash 04/30/2024
-$1,674,137.38
$1,674,137.38
$0.00

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
5 of
10 Cash/Money Market
Total Cash/Money Market
US Government Issues

ASSET DETAIL
First American Government
-
31846V203
Oblig Fd Cl Y
#3763
2,176,109.930

1.0000
2,176,109.93
2,176,109.93

0.00 3.4
107,271.51

4.93 Principal Cash
-1,674,137.38
-1,674,137.38
-2.6
Income Cash
1,674,137.38
1,674,137.38

2.6 Federal Farm Credit Bks
-
3133EMF98

0.650 06/09/2025
4,000,000.000

95.1550
3,806,200.00
4,000,000.00
-193,800.00

5.9 26,000.00

0.68 Federal Farm Credit Bks
-
3133EML67

0.800 06/22/2026
5,000,000.000

91.2130
4,560,650.00
4,977,500.00
-416,850.00

7.1 40,000.00

0.88 Federal Home Loan Bks
-
3130AMXJ6

0.500 09/30/2024
5,000,000.000

97.9740
4,898,700.00
5,000,000.00
-101,300.00

7.6 25,000.00

0.51 Total Cash
$2,176,109.93
$2,176,109.93
$0.00

3.4 $107,271.51
$0.00
$0.00
$0.00

0.0 $0.00
$2,176,109.93
$2,176,109.93
$0.00

3.4 $107,271.51
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Cash
Security Description
Shares/Face Amt
Price
Market Value
Tax Cost
Unrealized
Gain/Loss
Percent
of Total
Portfolio
Estimated
Annual Income
Estimated
Current Yield
Cash & Equivalents
Total Cash & Equivalents
Taxable Bonds

10101010101010101010
10111001011000000011
10101111001010010000
10010101010100000111
11101010010001011010
11000100101101000001
10010000000011110100
10010110100000101101
11010100001000111000
11001010011010011101
11000000100010001000
10101001110011100011
10000011111110000100
10100011110100101011
10001010010101011000
10001110001000100101
10101111100000001010
11011100110011010101
10011000001010000010
11111111111111111111

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
6 of
10 ASSET DETAIL
(continued)
Federal Home Loan Bks
-
3130AMNZ1

0.500 12/16/2024
3,000,000.000

97.0650
2,911,950.00
3,000,000.00
-88,050.00

4.5 15,000.00

0.51 Federal Home Loan Bks
-
3130AMST0

0.625 03/24/2025
5,000,000.000

95.9390
4,796,950.00
5,000,000.00
-203,050.00

7.4 31,250.00

0.65 Federal Home Loan Bks
-
3130AMQ54

0.700 09/16/2025
4,000,000.000

93.9660
3,758,640.00
4,000,000.00
-241,360.00

5.8 28,000.00

0.74 Federal Home Loan Bks
-
3130AMX31

0.750 06/30/2025
5,000,000.000

95.1630
4,758,150.00
5,000,000.00
-241,850.00

7.4 37,500.00

0.79 Federal Home Loan Bks
-
3130AMM33

0.875 07/16/2026
5,000,000.000

91.2800
4,564,000.00
5,000,000.00
-436,000.00

7.1 43,750.00

0.96 Federal Home Loan Bks
-
3130AMT28

1.000 06/30/2026
5,000,000.000

91.6430
4,582,150.00
5,000,000.00
-417,850.00

7.1 50,000.00

1.09 Federal Home Loan Bks
-
3130AMWZ1

1.050 06/30/2026
5,000,000.000

91.6440
4,582,200.00
5,000,000.00
-417,800.00

7.1 52,500.00

1.15 U S Treasury Note
-
912828ZF0

0.500 03/31/2025
5,000,000.000

95.7920
4,789,600.00
4,984,375.00
-194,775.00

7.4 25,000.00

0.52 U S Treasury Note
-
91282CBT7

0.750 03/31/2026
4,000,000.000

92.2310
3,689,240.00
3,998,750.00
-309,510.00

5.7 30,000.00

0.81 U S Treasury Note
-
912828Z52

1.375 01/31/2025
3,000,000.000

97.1240
2,913,720.00
3,091,875.00
-178,155.00

4.5 41,250.00

1.42 6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Security Description
Shares/Face Amt
Price
Market Value
Tax Cost
Unrealized
Gain/Loss
Percent
of Total
Portfolio
Estimated
Annual Income
Estimated
Current Yield

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
7 of
10 Total US Government Issues

ASSET DETAIL
(continued)

ASSET DETAIL MESSAGES
Time of trade execution and trading party (if not disclosed) will be provided upon request.

Publicly traded assets are valued in accordance with market quotations or valuation methodologies from financial industry services believed by us to be reliable. Assets that are not publicly traded may be reflected at value
s from other external sources. Assets for which a current value is not available may be reflected at a previous value or as not valued, at par value, or at a nominal value. Values shown do not necessarily reflect prices at w
hich assets could be bought or sold. Values are updated based on internal policy and may be updated less frequently than statement generation.

U S Treasury Note
-
912828YM6

1.500 10/31/2024
3,000,000.000

98.1080
2,943,240.00
3,111,562.50
-168,322.50

4.6 45,000.00

1.53 U S Treasury Note
-
912828K74

2.000 08/15/2025
3,000,000.000

96.0700
2,882,100.00
3,175,312.50
-293,212.50

4.5 60,000.00

2.08 U S Treasury Note
-
912828M56

2.250 11/15/2025
2,000,000.000

95.7380
1,914,760.00
2,140,625.00
-225,865.00

3.0 45,000.00

2.35 $62,352,250.00
$66,480,000.00
-$4,127,750.00

96.6 $595,250.00
$62,352,250.00
$66,480,000.00
-$4,127,750.00

96.6 $595,250.00
$64,528,359.93
$68,656,109.93
-$4,127,750.00
100.0
$702,521.51

1.08 6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Security Description
Shares/Face Amt
Price
Market Value
Tax Cost
Unrealized
Gain/Loss
Percent
of Total
Portfolio
Estimated
Annual Income
Estimated
Current Yield
Total Taxable Bonds
Total Assets
Estimated Current Yield

10101010101010101010
10111001011000000011
10101111001010010000
10010101010000001111
11101010010001001010
11000100101101110101
10010000000010010000
10010101100011010111
11010100001100010000
11001010011100011101
11000000110011011000
10101000011111100011
10000010110011011100
10100110010100000011
10001001000111111100
10001001101000110111
10110100101011000110
11001011010110000101
10011010101010101010
11111111111111111111

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
8 of
10 TRANSACTION DETAIL
04/01/24
Asset Income
Interest Earned On
F H L B Deb 0.500% 9/30/24
12,500.00

0.0025 USD/$1 Pv On 5,000,000 Par Value Due 3/30/24
04/01/24
Asset Income
Interest Earned On
U S Treasury Nt 0.500% 3/31/25
12,500.00

0.0025 USD/$1 Pv On 5,000,000 Par Value Due 3/31/24
04/01/24
Asset Income
Interest Earned On
U S Treasury Nt 0.750% 3/31/26
15,000.00

0.00375 USD/$1 Pv On 4,000,000 Par Value Due 3/31/24
04/01/24
Asset Income
Interest Earned On
First Am Govt Ob Fd Cl Y
8,708.42
Interest From 3/1/24 To 3/31/24
04/25/24
Fee
Trust Fees Collected
Charged For Period 03/01/2024 Thru 03/31/2024
-537.75
04/30/24
Asset Income
Interest Earned On
U S Treasury Nt 1.500% 10/31/24
22,500.00

0.0075 USD/$1 Pv On 3,000,000 Par Value Due 4/30/24
Purchase
Combined Purchases For The Period 4/ 1/24 - 4/30/24 Of First Am Govt Ob Fd Cl Y
-71,208.42
71,208.42
Sale
Combined Sales For The Period 4/ 1/24 - 4/30/24 Of
First Am Govt Ob Fd Cl Y
537.75
-537.75
$1,602,928.96
-$1,602,928.96
$68,585,439.26
$1,674,137.38
-$1,674,137.38
$68,656,109.93
6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Date
Posted
Activity
Description
Income
Cash
Principal
Cash
Tax Cost
Beginning Balance 04/01/2024
Ending Balance 04/30/2024

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
9 of
10 BOND SUMMARY
2024
11,000,000.00
10,753,890.00

17.25 2025
31,000,000.00
29,620,120.00

47.51 2026
24,000,000.00
21,978,240.00

35.24 Aaa
66,000,000.00
62,352,250.00
100.00
AA+
46,000,000.00
43,219,590.00

69.32 6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Par Value
Market Value
Percentage of
Category

MATURITY
Total of Category
$66,000,000.00
$62,352,250.00
100.00

MOODY'S RATING
Total of Category
$66,000,000.00
$62,352,250.00
100.00

S&P RATING

10101010101010101010
10111001011000000011
10101111001010010000
10010101001100010111
11101010010001010010
11000100101101100101
10010000000011100000
10010100100000101011
11010100001010001110
11001010000001011101
11000000110110010000
10101000101111001011
10000010100110011100
10100111001001111011
10001101110110111000
10011000110001010011
10110110111011100000
11001100010101110101
10011001101010001010
11111111111111111111

CITY OF MENIFEE
ACCOUNT NUMBER:
001051010931
April 1, 2024
to
April 30, 2024
Page
10 of
10 Data contained within this section excluded Mutual Funds, Exchange Traded Funds, and Closed-Ended Funds.

BOND SUMMARY
(continued)

BOND SUMMARY MESSAGES
N/A
20,000,000.00
19,132,660.00

30.68 6891
00- -M -UC-UU -122-04
0509316-00-01888-04
Par Value
Market Value
Percentage of
Category
Total of Category
$66,000,000.00
$62,352,250.00
100.00

Glossary
The accumulation of the value of a discounted bond until maturity.

The difference between the proceeds and the Prior
Market Value of the transaction.

The difference between the Market Value and the
Adjusted Prior Market Value.

A figure calculated using the beginning Market Value for the fiscal year, adjusted for all asset related transactions during the period, employing an average cost methodology.

The decrease in value of a premium bond until maturity. - Anything owned that has commercial exchange value. Assets may consist of specific property or of claims against others, in contrast to obligations due to others (liabilities).

A measurement of a bond's quality based upon the issuer's financial condition. Ratings are assigned by independent rating services, such as Moody's, or S&P, and reflect their opinion of the issuer's ability to meet the scheduled interest and principal repayments for the bond.

Cash activity that includes both income and principal cash categories. - Also reported as Gain/Loss in Period in the Asset Detail section.

This figure shows the market appreciation (depreciation) for the current period. - The original price of an asset, normally the purchase price or appraised value at the time of acquisition. Book Value method maintains an average cost for each asset. - The original price of an asset, normally the purchase price or appraised value at the time of acquisition. Tax Basis uses client determined methods such as Last-In-First-Out (LIFO), First-In-First-Out (FIFO), Average, Minimum Gain, and Maximum Gain. (Also reported as Accrued Income)
Income earned but not yet received, or expenses
incurred but not yet paid, as of the end of the reporting period.

The amount of income a particular asset is anticipated to earn over the next year. The shares multiplied by annual income rate. - The annual rate of return on an investment expressed as a percentage. For stocks, yield is calculated by taking the annual dividend payments divided by the stock's current share price. For bonds, yield is calculated by the coupon rate divided by the bond's market price. - (Also reported as Ex-Date) For stock trades, the person who owns the security on the ex-dividend date will earn the dividend, regardless of who currently owns the stock.

A category of cash comprised of ordinary earnings derived from investments, usually dividends and interest.

The price per unit multiplied by the number of units.
- The date on which an obligation or note matures.
- The date on which a dividend, mutual fund distribution, or interest on a bond will be made.

A category of cash comprised of cash, deposits, cash withdrawals and the cash flows generated from purchases or sales of investments.
- The Proceeds less the Cost Basis of a transaction.
- The date on which a trade settles and cash or securities are credited or debited to the account.

The date a trade is legally entered into.
- The difference between the Market Value and Cost Basis at the end of the current period.
- The annual rate of return on an investment expressed as a percentage. For stocks, yield is calculated by the annual dividend payments divided by the stock's current share price.

For bonds, yield is calculated by the coupon rate divided by the bond's market price.

The terms defined in this glossary are only for use when reviewing your account statement. Please contact your Relationship Manager with any questions.

Accretion -
Adjusted Prior Market Realized Gain/Loss -
Adjusted Prior Market Unrealized Gain/Loss -
Adjusted Prior Market Value -
Amortization -
Asset
Bond Rating -
Cash -
Change in Unrealized Gain/Loss
Cost Basis (Book Value)
Cost Basis (Tax Basis)
Ending Accrual -
Estimated Annual Income -
Estimated Current Yield
Ex-Dividend Date
Income Cash -
Market Value -
Maturity Date
Payable Date
Principal Cash -
Realized Gain/Loss Calculation
Settlement Date
Trade Date -
Unrealized Gain/Loss
Yield on/at Market

10101010101010101010
10111001011000000011
10101111001010010000
10010101001000010111
11101010010001011010
11000100101100010101
10010000000011110100
10010011100010000011
11010100001000111000
11001010010010000101
11000000100100100000
10101000110011000011
10000011100010010000
10100101100001000011
10001100110101101000
10011100111000100011
10101111110101011000
11001110010000011101
10011011101010101010
11111111111111111111
006891
-UC-122
000003240 02 SP 000638706711850 S

CITY OF MENIFEE
ATTN: ROCHELLE CLAYTON
29844 HAUN ROAD
MENIFEE, CA 92586

FFFTDDFDFDTADDFDFAAATTFDAFDDFADATTTDFFTDTFADTATFTADAAFDADATFDADAD U.S. Bank
1555 N. Rivercenter Dr.

Suite 300
Milwaukee, WI 53212

← All documents from this meeting