Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BASED ON THE ABOVE BOND INFORMATION CAN YOU HELP ANSWER AND EXPLAIN THE FOLLOWING QUESTIONS? PLEASE INDICATE THE EXCEL FORMULAS. THANK YOU Bond Detail Lookup
BASED ON THE ABOVE BOND INFORMATION CAN YOU HELP ANSWER AND EXPLAIN THE FOLLOWING QUESTIONS? PLEASE INDICATE THE EXCEL FORMULAS. THANK YOU
Bond Detail Lookup Symbol: DISCLAIMER: These transactions are effected pursuant to SEC Rule 144A. AMC ENTMT HLDGS INC + ADD TO WATCHLIST Coupon Rate Maturity Date Callable 10.500% 04/15/2025 Symbol AMC4978205 CUSIP 00165CANA Next Call Date 04/15/2022 Yes Last Trade Price Last Trade Yield Last Trade Date US Treasury $59.50 26.483% 10/23/2020 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type US Corporate Debentures 04/17/2020 - 10/23/2020 Zoom: 5D 1M 3M YTD 1Y 3Y 5Y 10Y Max Note -Price Price $ Debt Type Industry Group Industry Sub Group Sub-Product Asset Sub-Product Asset Type - State Use of Proceeds Security Code Financial Banking CORP Corporate Bond Date : 09/04/2020 Price: $91.06 90.00 80.00 70.00 Special Characteristics Medium Term Note N 60.00 50.00 06/2020 08/2020 10/2020 04/17/2020 04/24/2020 10/15/2020 Credit and Rating Elements Issue Elements Offering Date Dated Date First Coupon Date Original Offering Amount Outstanding Series Issue Description Project Name Payment Frequency Day Count Form $500,000.00 $500,000.00 Moody's Rating Standard & Poor's Rating TRACE Grade Default Caa2 (08/03/2020) CCC (10/01/2020) High Yield Semi-Annual N Depository/Registration Bankruptcy Insurance Mortgage Insurer Pre-Refunded/Escrowed Additional Description 30/360 Book Entry Depository Trust Company Senior Secured First Lien Note Security Level Collateral Pledge Capital Purpose *dollar amount in thousands Put & Redemption Provisions Call Date Call Price Call Frequency 04/15/2022 $105.25 Bond Elements Continuously Original Maturity Size Amount Outstanding Size 500,000.00 500,000.00 Put Date Put Price Put Frequency 11.03% Yield at Offering Price at Offering Coupon Type Escrow Type $98.00 Fixed *dollar amount in thousands YOU CAN SHOW YOUR WORK AT THE BOTTOM OF THE SHEET. Use the boxes below to put your final answers (use a cell reference to the answer in your work if necessary). A) What is the amount (in dollars) of each coupon payment for each bond? Assume the typical face value ($1000). B) How often will the payment be made? C) Assume you were standing at 4/17/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 on 4/17/20 was $61.50 (term for 61.5% of $1000), then what would the yield to maturity be (use the "rate" formula)Step by Step Solution
There are 3 Steps involved in it
Step: 1
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