Annual coupon rate$=3\mathrm{.}70\%$

Number of years $=6$

Face Value $=1000$

Price $=1100\mathrm{.}27$

a$)$What is the YTM$?$

b$)$Calculate Macaulay's duration and convexity using Excel $($see textbook for detailed steps, Exhibit $4-5$ and Exhibit $4-14)$

c$)$plot the price$-$yield relationship using excel. Hint: $($Calculate prices for different bond yields,e$.$g$.,$yields from $0\mathrm{.}5\%$ to $23\mathrm{.}5\%$;then your y$-$axis is yields and y axis is prices. The plot should show an inverse relationship.$)$

please help thank you so much!