Using Excel, determine how much money a company would receive today if they issued these two bonds. That is, determine the price of each of these bonds. Bond #1: Face value $1M, 9% annual coupon rate, interest payable semiannually, 12% market rate, maturity 10 years Bond #2: Face value $1M, 12% annual coupon rate, payable semiannually, 12% market rate, maturity 10 years

Please provide each and every excel formula you used and how you got each and every value as I am very confused. Please make sure you are using excel formulas not the factor and annuity tables because I need to know how to do this using excel. Thank you!