Assume a $1,000 face value bond has a coupon rate of 8.5 percent paid semi annually and has an eight-year life. If investors are willing to accept a 10 percent rate of return on bonds of similar quality, what is the present value or worth of this bond?
Please answers should be in excel format