Having some trouble on completing these charts on excel. There are 6 seperate bonds and the "Initial Current Yield" & "Initial Price" columns are given in the question.

Q1. Calculate One-Year Returns on Different-Maturity 10% Coupon Rate Bonds with Face Value of 1000 When Interest Rates Stay at 10% Q2. Calculate One-Year Returns on Different-Maturity 10% Coupon Rate Bonds with Face Value of 1000 When Interest Rates Rise from 10% to 20%