(Bond valuation) Sunn Co.s bonds, maturing in 7 years, pay 4 percent interest on a $1,000 face value. However, interest is paid semiannually. If your required rate of return is 5 percent, what is the value of the bond? How would your answer change if the interest were paid annually? I need it solved using Excel formulas. Im not sure how to do it