Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

BASED ON THE ABOVE BOND INFORMATION CAN YOU HELP ANSWER AND EXPLAIN THE FOLLOWING QUESTIONS? PLEASE INDICATE THE EXCEL FORMULAS. THANK YOU

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Fundamentals For Nonprofits

Authors: Woods Bowman

1st Edition

1118004515, 9781118004517

More Books

Students also viewed these Finance questions

Question

Q5 What is the users role in the requirements phase?

Answered: 1 week ago