yield curve

year Yield$(\%)$

$0\mathrm{.}53\mathrm{.}45\%$

$13\mathrm{.}6500\%$

$1\mathrm{.}53\mathrm{.}8500\%$

$24\mathrm{.}0500\%$

$2\mathrm{.}54\mathrm{.}2500\%$

$34\mathrm{.}4500\%$

$3\mathrm{.}54\mathrm{.}6500\%$

$44\mathrm{.}8500\%$

$4\mathrm{.}55\mathrm{.}0500\%$

$55\mathrm{.}2500\%$

$65\mathrm{.}4500\%$

Part a

Calculate the price of $3\mathrm{.}4\%$ semi$-$annual coupon paying bond with maturity of $4$ years. Assume par value is $100.$

Part b

Calculate the price of $0\%$ semi$-$annual coupon paying bond with maturity of $4$ years. Assume par value is $100.$

Part c

If the entire yield curve increases by $1\%,$ what is the percentage price change of $3\mathrm{.}4\%$ coupon paying bond?

Part d

If the entire yield curve increases by $1\%,$ what is the percentage price change of $0\%$ coupon paying bond.

Part e

Which bond reacts more to the change in yield, and why?

Zero coupon bond reacts more because the cash flows arrive at the end and teher is no gain from the coupon reinvestment.

Use FINRA for todays data and numbers. Please upload excel functions, I have attached the problem