Please use Excel Andrew Industries is contemplating issuing a 30-year bond with
ID: 2785120 • Letter: P
Question
Please use Excel
Andrew Industries is contemplating issuing a 30-year bond with a coupon rate of 7.08% (annual coupon payments) and a face value of $1,000. Andrew believes it can get a rating of A from Standard & Poor's. However, due to recent financial difficulties at the company, Standard & Poor's is warning that it may downgrade Andrew Industries' bonds to BBB. Yields on A-rated, long-term bonds are currently 6.51%, and yields on BBB-rated bonds are 6.75% a. What is the price of the bond if Andrew Industries maintains the A rating for the bond issue? b. What will be the price of the bond if it is downgraded? a. What is the price of the bond if Andrew Industries maintains the A rating for the bond issue? If Andrew maintains the A rating for the bond issue, the price of the bond is S (Round to the nearest cent.)Explanation / Answer
Bond Prices can be calculated using PV function in excel
a) Bond Price = PV(rate = 6.51%, nper = 30, pmt = 7.08% x 1000, fv = 1000, 0) = $1,074.36
b) Bond Price = PV(rate = 6.75%, nper = 30, pmt = 7.08% x 1000, fv = 1000, 0) = $1,042.00