i need to determine the market rate using goal seek for all the following market prices

PART 2 For this part begin by setting up an Excel template to determine the market rate in a single column format for the following bond: Face Value 1000 Coupon Rate 4.5% Maturity Date Purchase Date Market Price 9/10/36 3/10/20 80.000 Holding all the other inputs constant change the market price (using each price below) and recalculate the market rate using a separate column for each market price: 90.000 100.000 110.000 120.000 Describe the relationship between market prices and market rates and the coupon rate. Home Insert Draw View LU O A Page Layout Formulas Data Review Conditional Formatting 2 Format as Table Alignment Number Cell Styles % PH O Paste Font Cells Editing B21 AX fx 1 Face Value 2 Coupon Rate 3 Maturity Date 4 Market price 1,000 0.045 9/10/36 80 3/10/20 6 Purchase Date 7 Remaining Payments 8 Semi annual market rate 10 face value 11 interest payment 13 PV single factor 14 PV annuity factor 16 PV of face 17 PV of interest payments 18 Bond value 19 20 Market rate 0.10