XLS www.stern.nyu.edu

I. Pricing a Zero couponFace Value at Maturity =1000Time to Maturity =10( In years)Interest Rate on Bond =0.0455 (Current market interest rate for default-free bonds with given maturity)Price of the Bond ==C3/(1+C5)^C4II. Computing Yield to Maturity on a Zero CouponPrice of Bond =593.82YTM on the Bond ==(C3/C10)^(1/C4)-1 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download