Using the numbers from (1st picture) Please help with A, B, C and D (2nd picture)

Show work and use excel format

thank you

COTY INC + ADD TO WATCHLIST Maturity Date Coupon Rate 6.500% Callable 14,15,2025 Symbol CUSIP COTY4617036 222070ABO Next Call Date 04/15/2021 Yes Last Trade Price Last Trade Yield Last Trade Date US Treasury $81.50 11.094% 10/20/2020 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type 04/05/2018 10/20/2020 Zoom: 5D 1M 3M YTD 1Y 3Y 5Y 10Y Max Yield Debt Type Industry Group Industry Sub Group Sub-Product Asset Sub-Product Asset Type State Use of Proceeds Security Code Yield % US Corporate Debentures Senior Unsecured Note Industrial Manufacturing CORP Corporate Bond 12.00 9.00 Special Characteristics Matt Medium Term Note N 6.00 Issue Elements 11/2018 06/2019 01/2020 03/28/2018 04/05/2018 10/15/2018 $550,000.00 $550,000.00 Credit and Rating Elements Offering Date 3.00 Dated Date 08/2020 First Coupon Date Original Offering Amount Outstanding* Series Caa3 (04/09/2020) Issue Description B- (07/07/2020) Project Name High Yield Payment Frequency Day Count Form Depository/Registration Semi-Annual Moody's Rating Standard & Poor's Rating TRACE Grade Default Bankruptcy Insurance Mortgage Insurer Pre-Refunded/Escrowed Additional Description N 30/360 Book Entry Depository Trust Company Senior Senior Unsecured Note Security Level Collateral Pledge Capital Purpose *dollar amount in thousands Put & Redemption Provisions Call Frequency Bond Elements Call Date 04/15/2021 Call Price $104.88 Continuously 550,000.00 550,000.00 Put Date Put Price Put Frequency Original Maturity Size* Amount Outstanding Size* Yield at Offering Price at Offering Coupon Type Escrow. Type 6.50% $100.00 Fixed CHLIST YOU CAN SHOW YOUR WORK AT THE BOTTOM OF THE SHEET. Use the boxes below to put your final answers (use a cell reference A) What is the amount in dollars) of each coupon payment? Assume the typical face value. ury B) How often Will the payment be made? C) Assume yo were standing at 10/15/20 (time 0), use the PV formula to determine the current price of the bond. (note: not the same as the last trade price listed in the pic) D) If the price pn 10/15/20 was $81.50, then what would the yield to maturity be (use the "rate" formula)? Corporate bentures ured Note Industrial facturing CORP ate Bond E) What is the YTC if the bond will be called on 10/15/22 (note the call price at the bottom of the pic)? F) Looking at the graph to the left, was the price of the bond lower or higher than it is now around January of this year? N G) Use the "yield" function to calculate the yield on a trade date of 9/14/20 if the price was $84.95 on that date. H) T/F -- This bond is highly rated by the investment rating agencies. /28/2018 05/2018 15/2018 0,000.00 0,000.00 I) Given the current "Last Trade Price", how many of these $1000 face value bonds could you buy with $1,000,000? H) When these bonds were issued, they were issued at PAR, or a PREMIUM, or a DISCOUNT? mi-Annual 30/360 Dok Entry Cory Trust Company Senior I) Make a table (below) of the cash flows you can expect if you buy the bond on 10/15/20 and hold them to maturity Calculate the IRR of include the price you would pay for the bond (see D above). include the dates for each flow. COTY INC + ADD TO WATCHLIST Maturity Date Coupon Rate 6.500% Callable 14,15,2025 Symbol CUSIP COTY4617036 222070ABO Next Call Date 04/15/2021 Yes Last Trade Price Last Trade Yield Last Trade Date US Treasury $81.50 11.094% 10/20/2020 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type 04/05/2018 10/20/2020 Zoom: 5D 1M 3M YTD 1Y 3Y 5Y 10Y Max Yield Debt Type Industry Group Industry Sub Group Sub-Product Asset Sub-Product Asset Type State Use of Proceeds Security Code Yield % US Corporate Debentures Senior Unsecured Note Industrial Manufacturing CORP Corporate Bond 12.00 9.00 Special Characteristics Matt Medium Term Note N 6.00 Issue Elements 11/2018 06/2019 01/2020 03/28/2018 04/05/2018 10/15/2018 $550,000.00 $550,000.00 Credit and Rating Elements Offering Date 3.00 Dated Date 08/2020 First Coupon Date Original Offering Amount Outstanding* Series Caa3 (04/09/2020) Issue Description B- (07/07/2020) Project Name High Yield Payment Frequency Day Count Form Depository/Registration Semi-Annual Moody's Rating Standard & Poor's Rating TRACE Grade Default Bankruptcy Insurance Mortgage Insurer Pre-Refunded/Escrowed Additional Description N 30/360 Book Entry Depository Trust Company Senior Senior Unsecured Note Security Level Collateral Pledge Capital Purpose *dollar amount in thousands Put & Redemption Provisions Call Frequency Bond Elements Call Date 04/15/2021 Call Price $104.88 Continuously 550,000.00 550,000.00 Put Date Put Price Put Frequency Original Maturity Size* Amount Outstanding Size* Yield at Offering Price at Offering Coupon Type Escrow. Type 6.50% $100.00 Fixed CHLIST YOU CAN SHOW YOUR WORK AT THE BOTTOM OF THE SHEET. Use the boxes below to put your final answers (use a cell reference A) What is the amount in dollars) of each coupon payment? Assume the typical face value. ury B) How often Will the payment be made? C) Assume yo were standing at 10/15/20 (time 0), use the PV formula to determine the current price of the bond. (note: not the same as the last trade price listed in the pic) D) If the price pn 10/15/20 was $81.50, then what would the yield to maturity be (use the "rate" formula)? Corporate bentures ured Note Industrial facturing CORP ate Bond E) What is the YTC if the bond will be called on 10/15/22 (note the call price at the bottom of the pic)? F) Looking at the graph to the left, was the price of the bond lower or higher than it is now around January of this year? N G) Use the "yield" function to calculate the yield on a trade date of 9/14/20 if the price was $84.95 on that date. H) T/F -- This bond is highly rated by the investment rating agencies. /28/2018 05/2018 15/2018 0,000.00 0,000.00 I) Given the current "Last Trade Price", how many of these $1000 face value bonds could you buy with $1,000,000? H) When these bonds were issued, they were issued at PAR, or a PREMIUM, or a DISCOUNT? mi-Annual 30/360 Dok Entry Cory Trust Company Senior I) Make a table (below) of the cash flows you can expect if you buy the bond on 10/15/20 and hold them to maturity Calculate the IRR of include the price you would pay for the bond (see D above). include the dates for each flow