Answer :
Answer:
Part a to f are answered in the tables attached. Part g and h are answered below:
Explanation:
Value of a bond is given by the excel function, PV = PV(R,N,PMT,FV)
R - YTM
N - years to maturity
PMT - Coupon
FV - Par value
Coupon = Coupon rate * par value
g - From the column change, Long-term bonds are more affected than short-term bonds by rise in interest rates
h - From the column change, Long-term bonds are more affected than short-term bonds by decline in interest rates

