Please answer using Excel and leaving step by step instructions for calculations, thank you!
. 3. Provide as much detail as possible about the following convertible instrument based on the Bloomberg DES screenshot provided below: How is Bloomberg calculating parity? How is the Premium being calculated? COIN O L 06 1125.178 1.0 Yld N.A At 13:13 Vol 9.5 Source 1 COIN 0 12 06/01/26 Co Actions Settings Page 1/12 Security Description: Convertible isConvertible Bond 2 Underlying Description Pages Issuer Information Identifiers Bond Info Name COINBASE GLOBAL INC FIGI BEG01138F001 Adat Info Industry Brokerage Assetmanagers Exchanges. CUSIP Reg/Tax 19260045 1 Covenants Convertible Information ISIN US19260QM58 19 Garators Mkt of Issue PRIV PLAC. Convertible Bond Ratings ford Ratings Ctry/Reg US Currency USD Identifiers Rank Sr Unsecured Series 10 Exchange Conv Ratio 2.6994 Conv Price 370.4527 19 any Parties Fees, Restrict Stock Tko COIN US Stock Price 357.3900 Schedules Parity 96.4739 Premium 29.7533 Issuance & Trading Capons Coupon 0.500000 Init Prem 55.000 Amt Issued/Outstanding Quick Links Type Fixed Freq S/A 1,437,500.00 (M) / BALLO Priang SOFTCALL 1,437,500.00 (M) 200 Q Recap Calc Type (49)CONVERTIBLE Min Piece/Increment H4 H Trade Hist Bocs Comp kction Pricing Date 05/19/2021 1,000.00/ 1,000.00 10G Prosechs 1st Coupon Date 12/01/2021 Par Amount 1,000.00 NON Convertible Until 05/29/2026 Book Runner GS,JPM AIDS Haders Maturity 06/01/2026 Reporting TRACE USD USO Seca . 3. Provide as much detail as possible about the following convertible instrument based on the Bloomberg DES screenshot provided below: How is Bloomberg calculating parity? How is the Premium being calculated? COIN O L 06 1125.178 1.0 Yld N.A At 13:13 Vol 9.5 Source 1 COIN 0 12 06/01/26 Co Actions Settings Page 1/12 Security Description: Convertible isConvertible Bond 2 Underlying Description Pages Issuer Information Identifiers Bond Info Name COINBASE GLOBAL INC FIGI BEG01138F001 Adat Info Industry Brokerage Assetmanagers Exchanges. CUSIP Reg/Tax 19260045 1 Covenants Convertible Information ISIN US19260QM58 19 Garators Mkt of Issue PRIV PLAC. Convertible Bond Ratings ford Ratings Ctry/Reg US Currency USD Identifiers Rank Sr Unsecured Series 10 Exchange Conv Ratio 2.6994 Conv Price 370.4527 19 any Parties Fees, Restrict Stock Tko COIN US Stock Price 357.3900 Schedules Parity 96.4739 Premium 29.7533 Issuance & Trading Capons Coupon 0.500000 Init Prem 55.000 Amt Issued/Outstanding Quick Links Type Fixed Freq S/A 1,437,500.00 (M) / BALLO Priang SOFTCALL 1,437,500.00 (M) 200 Q Recap Calc Type (49)CONVERTIBLE Min Piece/Increment H4 H Trade Hist Bocs Comp kction Pricing Date 05/19/2021 1,000.00/ 1,000.00 10G Prosechs 1st Coupon Date 12/01/2021 Par Amount 1,000.00 NON Convertible Until 05/29/2026 Book Runner GS,JPM AIDS Haders Maturity 06/01/2026 Reporting TRACE USD USO Seca
