You are considering investing in a security that matures in $10$ years with a par value of $$1,000.$ During the first five years, the security has an $8$ percent coupon with quarterly payments. During the remaining five years the security has a $10$ percent coupon with quarterly payments. After $10$ years you receive the par value.

Another $10-$year bond has an $8$ percent semiannual coupon. This bond is selling at its par value, $$1,000.$ This bond has the same risk as the security you are thinking of purchasing. Given this information, what should be the price of the security you are considering purchasing? Please awnser with excel