Lets assume that an issuer issues a $5-$year bond called A$.$ These bonds pay an annual coupon of $70$ euros and have a nominal value of $1,000$ euros.

Calculate the duration of bond A for a yield to maturity of $10\%.$

If you have estimated that the discount rate will increase from $10\%$ to $11\%(100$ points

basis$)$ what effect will this change have on the price of bond A$?$ Explain the result.

Explain the relationship between the duration of a bond and the yield on maturity, $($Assume other bond characteristics remain unchanged$).$

Please show workings in excel.