PLEASE ANSWER QUESTION IN EXCEL WITH FORMULAS SHOWN THANKS!

Bond AAPL: Coupon rate Face value Coupons per year Years to maturity $ 4.75% 1,000.00 2 8 Bond GOOG: Coupon rate Face value Coupons per year Years to maturity $ 5.10% 1,000.00 2 15 Question 1 - Interest rates have increased by 1.3% since their original issue dates, calculate the new YTM, Prices, and the Percent Change in Price for both Bond AAPL and Bond GOOG. (15 points) Increase in interest rates 1.30% 6.05% New YTM AAPL New YTM GOOG 6.40% New Price of AAPL New Price of GOOG $918.51 $875.83 % change in AAPL % change in GOOG -8.15% - 13.52% Question 2 - Interest rates have decreased by 0.75% since their original issue dates, calculate the new YTM, Prices, and the Percent Change in Price for both Bond AAPL and Bond GOOG. (15 points) Fall in interest rates -0.75% New YTM AAPL New YTM GOOG New Price of AAPL New Price of GOOG TIMUM % change in AAPL % change in GOOG