please solve

4. Use formula, calculator, and Excel and to answer the following questions: a. Bank of America offers loans at an APR (Nominal Rate) of 9% (interest compounded quarterly). If you borrow $500,000 for 1 year, how much interest will you have paid and what is the bank's APY (Effective Rate)? b. Two years ago, Camp Nou Corp issued a AA-rated 30 year, 5% coupon bond to be paid semi-annually. Currently, the yield to maturity on these bonds is 3% Calculate the price of the bond today. (plug in values in formula show keys in calculator, and write formula and arguments as you would enter them.in. Excel) Bond Price = Par Value +Coupon r