Bank of America has bonds that have a 6.5% coupon, payable annually, and mature in 5 years. If an investor has a required rate of return of 4.3% per annum, compounded annually, what is the price of the bond? What happens to the return if the investor pays more or less than the amount calculated? Show steps of how to solve using excel including the formulas and manually.