Question $1$ Excel spreadsheet required, please attach

Here is actual data for PPL corporate bond.

Suppose you invest in this bond on December $1,2023$

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$-$annually

Use Excel spreadsheet to find this bond$$s Macauley duration. Identify the units to Macauley duration. Be sure to attach the actual Excel spreadsheet, not a snapshot.