please use excel or formula to calculate and explain as much you can. round to two decimal places

Yield to maturity. What is the yield of each of the following bonds, if interest (coupon) is paid monthly? les.) Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) es. Par Value Coupon Rate Price $5,000.00 $5,000.00 $1,000.00 $1,000.00 8% 9% 6% 11% Years to Maturity 20 10 30 Yield to Maturity ? ? ? $4,990.00 $4, 120.00 $620.00 $1,580.00 20 ? les.) Print Done