please i want answer in excel file and use the excel to calculate the problem... please i want a good job on this paper

1. Your bank is offering you an account that will pay 21% interest in total for a two-year deposit. Determine the equivalent discount rate for a period length of: a. Six months. b. One year. c. One month. Round to two decimal places. 2. Which do you prefer: a bank account that pays 9 % per year (EAR) for three years or: a. An account that pays 4.5 % every six months for three years? b. An account that pays 13.5 % every 18 months for three years? Round to five decimal places 3. Suppose a 10-year, $ 1, 000 bond with a 8% coupon rate and semiannual coupons is trading for a price of $ 1,080.72. a. What is the bond's yield to maturity (expressed as an APR with semiannual compounding)? b. If the bond's yield to maturity changes to 9 % APR, what will the bond's price be? Round to two decimal places. 4. Suppose a seven-year, $1,000 bond with a 7.77% coupon rate and semiannual coupons is trading with a yield to maturity of 6.04%. a. If the yield to maturity of the bond rises to 7.03 %(APR with semiannual compounding), at what price will the bond trade? Round to two decimal places