Calculate the value of a $1,000 bond which has 10 years until maturity and pays semi-annual interest at an annual coupon rate of 12 percent. The required return on similar-risk bonds is 8 percent. Is your bond a premium bond or a discount bond? If the bond is sold today at $1200 will you buy this bond? Explain your answer. (The Hard copy must include the EXCEL sheet and the variables used)