please use formula or excel with explanation as much you can

Bond prices. Price the bonds from the following table with monthly coupon payments: B. Hint: make sure to round all intermediate calculations to at least seven decimal places. i Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Years to Maturity 25 Par Value $5,000.00 $1,000.00 $1,000.00 $1,000.00 Coupon Rate 11% 6% 5% 10% Yield to Maturity 10% 7% 11% 12% Price ? ? 15 30 ? ? 10