help me with the question #5

Exercise Problem #1 (slide 7) Use the Bloomberg bond description above (as of April 22, 2022) to identify the Issuer, maturity date, par amount, coupon rate, market price and yield spread (as of April 22, 2022), issued price and issued yield spread, and current credit rating of the above corporate bond issued by Apple Inc. in 2020. .397 DUS MAIL 24 04/20/2050 cox x + = Options mrers TEMES DE LO QUE MOG REWINDO YOTG > MAIL 2.1 05/20/2000 Corp DLS Related lunctions Menu Message AAPL 2.4 08/20/50$173.358 102.0 bp vs 1 1.875 11/15/2051 As of 22 Apr Source BMRK AAPEZ 08/20/50 Corp Actions Settings Pue 1/1Security Description: Bond 94 No Notes 99 Buy 962 Soll 15 Band Description 210 Issuer Description PRO Issuer Information Identifiers Name APPLE INC FIGI BBGOOWNPK2R2 OAJUL CUSIP Industry Technology (BCLASS) 097833DZO THE FAVARRA Security Information ISIN U50378330201 Mkt Iss GLOBAL Bond Ratings A Few Bar Ctry/Reg 05 Currency USD Moody's Aaa I. Rank Sr Unsecured Series S&P AA OLALI Coupon 2.400000 Fixed Composite I'w AA ROTU. Hvis Con Freg S/A ED SU Day Cnt 30/360 Iss Price 99.72400 Issuance & Trading CMS Maturity 08/20/2050 Amt Issued/Outstanding Juick Links MAKE WHOLE @15.000 until 02/20/50/ CALL 02/... USD 1,250,000.00 (M) BALLO DE Iss Sprd +100.00bp vs T 2 02/15/50 USD LU OD Ren 1,250,000.00 (M) | | | | | | Calc Type (1)STREET CONVENTION Min Plece/Increment CACE con me Pricing Date 08/13/2020 2,000.00/ 1,000.00 Pen Interest Accrual Date 08/20/2020 Par Amount 1,000.00 CN SO NOW 1st Setlle Date 08/20/2020 Book Runner JOINT LEADS oldu 1st Coupon Date 02/20/2021 Reporting TRACE Issuer: Maturity Date: Par amount (par value): Coupon rate Market Price (as of 04/22/2022): _of the Par Value Yield Spread (as of 04/22/2022) over the 30-year Treasury Benchmark Issued Price: of the Par Value Issued Yield Spread: over the Treasury Benchmark Credit Ratings: Exercise Problem #5 (slide 35) Base Curve Selected: US Treasury Actives Curve US Treasury Actives Curve Actions 98) Chart Export Settings ) E Graph Curves X- K-Axis Tenor.Y-Axis Mid TM Currency None PCS BGN Specific 04/22/20 Relative Lt 20 1W IM Mulily Lurves Rullivu Valur o values and Members Values Members Constituents #2 125 Mid YTM 125 Mid YTM 125 Mid YTM US Treasury Actives Curve US Treasury Actives Curve (Change) 04/22/22 04/22/20 04/22/22-04/22/20 Tenor Description Price Yield Description Price Vield Price Yield 21 IMBO 05/24/22 Govt 0.436 0.442 BO 05/19/20 Govt 0.070 0.071 0.366 37.1 12 2MB O 06/21/22 Govt 0.581 0.590B O 06/16/20 Govt 0.071 0.072 0.510 51.8 23 3MB O 07/21/22 Govt 0.794 0.806B O 07/23/20 Govt 0.101 0.103 0.692 70.3 14 OMBO 10/20/22 Govt 1.289 1.315 B O 10/22/20 Govt 0.134 0.136 1.155 117.9 15) 1Y DO 04/20/23 Govt 1.974 2.0315 0 04/22/21 Govt 0.161 0.164 1.312 136.B 10 ZYT 24 03/31/24 Govt 99-067 2.669TO > 03/31/22 Govt 100-09 0.215 -1-03 245.4 177 3VT 2014/15/25 Govt 99-11 2.857TO 04/15/23 Govt 99-30 0.263 -0-19 259.3 SYT 2) 03/31/27 Govt 98-00 , 2.933 TO 03/31/25 Govt 100-20". 0.368 -2-19 256.5 19 7Y1 2 03/31/29 Govt 96-13+ 2.949TO 03/31/27 Govt 100-24 0.515 -4-10 243.5 20 10YT I 1. 02/15/32 Govt 11-09 2.9021 102/15/30 Govt 108-114 0.621 -17-02 228.1 21 201 202/15/42 Govt 58-21 3.145 30VT 2102/15/52 Govt 86 07:12 2047T 2 02/15/50 GOVE 110-174 1.216 33-004 173.0 (a) Complete the following table based on the Treasury active yield curves on April 22, 2022 and April 22, 2020 (as shown above) 4/22/2022 4/22/2020 Change from 04/22/2020 (in %) (in %) to 04/22/2022 (in basis points) 3-month Treasury yield 0.806 0.103 70.3 2-year Treasury yield 10-year Treasury yield 2.902 0.621 228.1 10-year minus 2-year Term Structure Spread 10-year minus 3-month Term Structure Spread 2.096 (b) How has the yield curve shifted in the last two years from April 22, 2020 to April 2022? Exercise Problem #1 (slide 7) Use the Bloomberg bond description above (as of April 22, 2022) to identify the Issuer, maturity date, par amount, coupon rate, market price and yield spread (as of April 22, 2022), issued price and issued yield spread, and current credit rating of the above corporate bond issued by Apple Inc. in 2020. .397 DUS MAIL 24 04/20/2050 cox x + = Options mrers TEMES DE LO QUE MOG REWINDO YOTG > MAIL 2.1 05/20/2000 Corp DLS Related lunctions Menu Message AAPL 2.4 08/20/50$173.358 102.0 bp vs 1 1.875 11/15/2051 As of 22 Apr Source BMRK AAPEZ 08/20/50 Corp Actions Settings Pue 1/1Security Description: Bond 94 No Notes 99 Buy 962 Soll 15 Band Description 210 Issuer Description PRO Issuer Information Identifiers Name APPLE INC FIGI BBGOOWNPK2R2 OAJUL CUSIP Industry Technology (BCLASS) 097833DZO THE FAVARRA Security Information ISIN U50378330201 Mkt Iss GLOBAL Bond Ratings A Few Bar Ctry/Reg 05 Currency USD Moody's Aaa I. Rank Sr Unsecured Series S&P AA OLALI Coupon 2.400000 Fixed Composite I'w AA ROTU. Hvis Con Freg S/A ED SU Day Cnt 30/360 Iss Price 99.72400 Issuance & Trading CMS Maturity 08/20/2050 Amt Issued/Outstanding Juick Links MAKE WHOLE @15.000 until 02/20/50/ CALL 02/... USD 1,250,000.00 (M) BALLO DE Iss Sprd +100.00bp vs T 2 02/15/50 USD LU OD Ren 1,250,000.00 (M) | | | | | | Calc Type (1)STREET CONVENTION Min Plece/Increment CACE con me Pricing Date 08/13/2020 2,000.00/ 1,000.00 Pen Interest Accrual Date 08/20/2020 Par Amount 1,000.00 CN SO NOW 1st Setlle Date 08/20/2020 Book Runner JOINT LEADS oldu 1st Coupon Date 02/20/2021 Reporting TRACE Issuer: Maturity Date: Par amount (par value): Coupon rate Market Price (as of 04/22/2022): _of the Par Value Yield Spread (as of 04/22/2022) over the 30-year Treasury Benchmark Issued Price: of the Par Value Issued Yield Spread: over the Treasury Benchmark Credit Ratings: Exercise Problem #5 (slide 35) Base Curve Selected: US Treasury Actives Curve US Treasury Actives Curve Actions 98) Chart Export Settings ) E Graph Curves X- K-Axis Tenor.Y-Axis Mid TM Currency None PCS BGN Specific 04/22/20 Relative Lt 20 1W IM Mulily Lurves Rullivu Valur o values and Members Values Members Constituents #2 125 Mid YTM 125 Mid YTM 125 Mid YTM US Treasury Actives Curve US Treasury Actives Curve (Change) 04/22/22 04/22/20 04/22/22-04/22/20 Tenor Description Price Yield Description Price Vield Price Yield 21 IMBO 05/24/22 Govt 0.436 0.442 BO 05/19/20 Govt 0.070 0.071 0.366 37.1 12 2MB O 06/21/22 Govt 0.581 0.590B O 06/16/20 Govt 0.071 0.072 0.510 51.8 23 3MB O 07/21/22 Govt 0.794 0.806B O 07/23/20 Govt 0.101 0.103 0.692 70.3 14 OMBO 10/20/22 Govt 1.289 1.315 B O 10/22/20 Govt 0.134 0.136 1.155 117.9 15) 1Y DO 04/20/23 Govt 1.974 2.0315 0 04/22/21 Govt 0.161 0.164 1.312 136.B 10 ZYT 24 03/31/24 Govt 99-067 2.669TO > 03/31/22 Govt 100-09 0.215 -1-03 245.4 177 3VT 2014/15/25 Govt 99-11 2.857TO 04/15/23 Govt 99-30 0.263 -0-19 259.3 SYT 2) 03/31/27 Govt 98-00 , 2.933 TO 03/31/25 Govt 100-20". 0.368 -2-19 256.5 19 7Y1 2 03/31/29 Govt 96-13+ 2.949TO 03/31/27 Govt 100-24 0.515 -4-10 243.5 20 10YT I 1. 02/15/32 Govt 11-09 2.9021 102/15/30 Govt 108-114 0.621 -17-02 228.1 21 201 202/15/42 Govt 58-21 3.145 30VT 2102/15/52 Govt 86 07:12 2047T 2 02/15/50 GOVE 110-174 1.216 33-004 173.0 (a) Complete the following table based on the Treasury active yield curves on April 22, 2022 and April 22, 2020 (as shown above) 4/22/2022 4/22/2020 Change from 04/22/2020 (in %) (in %) to 04/22/2022 (in basis points) 3-month Treasury yield 0.806 0.103 70.3 2-year Treasury yield 10-year Treasury yield 2.902 0.621 228.1 10-year minus 2-year Term Structure Spread 10-year minus 3-month Term Structure Spread 2.096 (b) How has the yield curve shifted in the last two years from April 22, 2020 to April 2022