Question $1$ Excel spreadsheet required, please attachHere is actual data for PPL corporate bond.Suppose you invest in this bond on April $19,2024$This bond matures on February $21,2028$Par value $$1,000$Yield$-$to$-$maturity $5\mathrm{.}75\%($best estimate$)$Annual coupon $2\mathrm{.}875\%,$ interest payable semi$-$annuallyUse Excel spreadsheet to find this bond$$s Macauley duration. Identify the units to Macauleyduration. Be sure to attach the actual Excel spreadsheet, not a snapshot.

Question $2$ Suppose a hypothetical bond is currently priced at $$986.$ Its Macauley duration is $12\mathrm{.}34$ years.Yield$-$to$-$maturity is $6\mathrm{.}25\%.$ Interest is paid quarterly. If market interest rates decrease by $10\mathrm{.}0$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.