Question:

Bond Dave has a 3 percent coupon rate, makes semiannual payments, a 8 percent YTM, and 26 years to maturity. If interest rates suddenly rise by 5 percent, what is the percentage change in the price of Bond Dave? Enter the answer with 4 decimals (e.g. 0.0123).

Ackerman Co. has 11 percent coupon bonds on the market with 9 years left to maturity. The bonds make semiannual payments. If the bond currently sells for $1035.15, what is its YTM? Answer with 4 decimals (e.g. 0.0123)

Please proper explain with formula in MS excel and do not copy from Chegg. otherwise, I have to report the answer. (NEED BOTH ANSWER)