Could someone show me how to do this using excel and detailed. Thank You!

Bond prices. Price the bonds from the following table with annual coupon payments: a. Find the price for the bond in the following table: (Round to the nearest cent.) Par Value $1,000.00 Years to Maturity 5 Coupon Rate 7% Price Yield to Maturity 10% $ X Data Table - (Click on the following icon in order to copy its contents into a spreadsheet.) Coupon Rate 7% Price Yield to Maturity 10% Years to Maturity 5 25 Par Value $1,000.00 $1,000.00 $5,000.00 $5,000.00 10% 8% ? ? ? ? 15 11% 9% 7% 5% 15 Print Done Enter your answer in the answer box and then click Check Answer. 3 parts remaining Clear All Check