a)

b)

please elaborate how you got this and please please please show what formula and steps you used to fill out the formula to get the answer. excel is still fairly new to me so im really trying to learn it. please help a sis out. thank you in advance!

Crayola Corp has an outstanding bond with a coupon rate of 6.3% per year which matures in 2040. If you require a rate of 5.3% per year on this bond, what is the value of the Crayola bond? (Of course the bond is par value $1000 and pays semi- annual coupon payments.) A long term FedEx bond that pays a coupon of 5.74% per year with a maturity of 2038. If the current price of the bonds is $1,010.6, what is the yield to maturity of the bonds? Express your answer as a decimal (5.83% is .0583). NOTE: the answer is approximate so your answer may be slightly off but still correct