J&J Manufacturing just issued a bond with a $1,000 face value and a coupon rate of 10%. If the bond has a life of 20 years, pays annual coupons, and the yield to maturity is 7.5%, what will the bond sell for? Suppose you purchase the bond today at year 0 and sell it at the end of year 2 when the yield to maturity declines to 6%, what is the IRR for holding this bond? (YTM is quoted as APR with annual compounding)

Do it in excel please