To finance a new Fab in Arizona, TSM issued an 8-year, 5.75% coupon bond with semi-annual coupon payments. The current YTM is 6.5%. What is the duration of this bond and how much will the price change if YTM goes up by 1% using the duration approximation method you've learned in this class?

Please solve ASAP and show how to easily solve in Excel, will give a thumbs up if actually done easily and quickly