I just need to know how to solve spot rate for 1 question and forward for 1 question, don't have to answer all of them

Q ~ Search Sheet Q v AutoSave O OFF homework 8 (2) Home Insert Draw Page Layout Formulas Data Review View Share Comments J22 4 X V fx Z AA A B D E F G H I J K L M N P Q R S T U v w X Y Below are cash flows from bonds of 1, 2, 3, and 4 semi-annual periods of maturity and $1,000 par 2.5% coupon Bond 1 Bond 2 Bond 3 Bond AWN- O -995.02 -980.30 -992.72 1000.00 0.00 12.50 12.50 1000.00 12.50 12.50 1012.50 12.50 11 1012.50 12 1.00% 2.00% 4.00% 14 yield-to-maturity 15 What is the yield-to-maturity on bond 3 16 17 18 19 20 21 Calcualte the price for bond 4 that results in a 4% yield-to-maturity 22 23 24 25 26 27 28 What is the spot rate for period 1? 29 30 31 33 What is the spot rate for period 2? 35 36 38 What is the spot rate for period 3? 39 What is the forward for period 1? 45 46 47 48 49 50 What is the forward rate for period 1 to period 2? 51 52 Sheet1 + + 100% Ready