See attached file. Use only excel functions. Provide response on sheet 2.
a) Value using the price function.
b) Current yield.
c) Yield to maturity using the yield function.
d) Yield to first call using the yield function.
e) Value using the PV function.
f) Yield to maturity using the rate function.
g) Yield to first call using the rate function.
The solution shows how to calculate the bond value current yield, and yield to maturity using different methods.