Question 1 Excel spreadsheet required, please attachHere is actual data for PPL corporate bond.Suppose you invest in
Fantastic news! We've Found the answer you've been seeking!
Question:
Question Excel spreadsheet required, please attachHere is actual data for PPL corporate bond.Suppose you invest in this bond on April This bond matures on February Par value $Yieldtomaturity best estimateAnnual coupon interest payable semiannuallyUse Excel spreadsheet to find this bonds Macauley duration. Identify the units to Macauleyduration. Be sure to attach the actual Excel spreadsheet, not a snapshot.
Question Suppose a hypothetical bond is currently priced at $ Its Macauley duration is years.Yieldtomaturity is Interest is paid quarterly. If market interest rates decrease by basis points, estimate the new bond price. You may round to the nearest dollar. Show allformulas & calculations. Excel is optional. If you use Excel please include the spreadsheet.
Posted Date: