a)

b)

c)

please elaborate how you got the answer. especially if you use excel. excel is still a little foreign to me so please please please show what you did for excel what formula and how you pluged in the formula so i can truly learn. thank you in adavance!!

Pumpkin Inc has a bond outstanding that makes interest payments of $25 every six months. The bond is a US Corporate coupon bond so has a Par of $1000 that will be paid at maturity. If the bond has 26 years to maturity (so twice as many six month periods) and a required rate of 6% per year (so half of this per six months), what is the value of the bond today? 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