Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make portfolio that must have at least 3 fixed income or bond instruments with a range of $250,000 - $1,000,000 per bond. it can be
Make portfolio that must have at least 3 fixed income or bond instruments with a range of $250,000 - $1,000,000 per bond. it can be a US Treasury or Corporate Bond, and it has to be made in an excel format here is a sample below:
Name: Class: Re: 2023 Fixed Income (and or Equity) Portfolio As of Date: Instrument Govt. Bond Corporate Corporate Summary: Issuer Amount Value Date Maturity Date OID U.S. Treasury $ Apple 11/30/2027 11/15/2022 8/8/2029 8/1/2022 $ 200,000.00 11/30/2022 200,000.00 11/30/2022 $ 200,000.00 11/30/2022 12/10/2025 12/10/2021 600,000.00 JPM $ Coupon 3.875% 3.250% 3.688% 3.604% Current Price 102.037 96.860 97.870 98.922 Day Count Formula 0 0 0 YTM Annual Interest Mark to Market 3.393% $ 7,750.00 S 3.798% $ 6,500.00 $ 4.328% $ 7,376.00 $ 3.840% $ 21,626.00 $ Unrealized Gain or Loss 204,074.00 $ 193,720.00 $ 195,740.00 $ 593,534.00 $ Current Yield Rating WAM (years) Cusip AAA A1 A2 4,074.00 3.798% (6,280.00) 3.355% (4,260.00) 3.768% (6,466.00) 3.640% 5.1 6.8 3.1 5.0 037883ENG 466447PCS3 Callable Yes Yes
Step by Step Solution
★★★★★
3.42 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
SureI can help you create a portfolio that meets your requirementsHere is an example of a portfolio ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started