A company has two outstanding bond issues, each with a 5.5% coupon, payable annually. Both bonds have a par value of $1,000; the first bond has a maturity of 1 year and the second has a maturity of 12 years (a) What is the price of each bond if the required rate of return (compounded annually) is (1) 4% per annum; (2) 7% per annum; and (3) 10% per annum? Show both how to solve it using excel including the formulas and manually