Q$2.$

Two bonds, each with a maturity of $5$ years, are available. One has an annual coupon rate of $8\%,$ while the other has a coupon rate of $0\%.$ Both bonds have a yield to maturity of $10\%$ and a face value of $$1,000.$

a$.$ What are the prices of each bond?

b$.$ What is the Macaulay duration for each bond?

Complete the table below $($cells in green$),$ and provide answers to questions a and $b.$ You can use an Excel spreadsheet and then copy and paste the sheet. Additionally, please provide detailed explanations beneath the table on how to determine the values in each cell, using either equations or descriptive methods.