Calculate for each of the following bonds the current yield and yield to maturity per $$1,000$ of par value assuming both situations of annual AND semiannual coupon payments.

Explain the relationship between coupon rate, current yield and yield to maturity for each of the bonds.

Bond $1$

Coupon rate: $6\%$

Years to maturity: $8$

Price: $980$$

Bond $2$

Coupon rate: $8\%$

Years to maturity: $15$

Price: $1100$$

Bond $3$

Coupon rate: $7\%$

Years to maturity: $10$

Price: $900$$

Bond $4$

Coupon rate: $8\%$

Years to maturity: $3$

Price: $1010$$

Please show the calculations in excel.