Just solve the question in the 2nd photos, Use the information from the 1st photo, Give me the process, not the excel.

Today is 9/11/2020 (September 11, 2020) and today's 1-year spot rate is 0.040, the 2-year spot rate is 0.033, the 3-year spot rate is 0.021, and the 4-year spot rate is 0.018. Write these down on your answer sheet (you will need them later). According to the pure expectations hypothesis, what is the expected 2-year spot rate for next year (i.e., the 2-year rate that will prevail on 9/11/2021)? Your answer should be entered and rounded to the nearest 5 decimal places (e.g., 5.1236% should be entered as 0.05124). Suppose today (9/11/2020) there exists a 3-year, 8% coupon bond (annual coupons), and instead of the expectations hypothesis suppose that instead you believe that one year from today (i.e., on 9/11/2021) the yield curve will look at the same as it does today. If you buy the bond today (9/11/2020), what do you expect your one-year holding period return to be i.e., your return from 9/11/2020 to 9/11/2021)? NOTE: This is NOT the bond asked about in #16 -- it is a completely different bond. Make sure to fully support your answer on the supporting worksheet, and express your final answer rounded accurately to the nearest 4 decimal places (e.g., if you calculated 0.02345 then your final answer should be 0.0235). Today is 9/11/2020 (September 11, 2020) and today's 1-year spot rate is 0.040, the 2-year spot rate is 0.033, the 3-year spot rate is 0.021, and the 4-year spot rate is 0.018. Write these down on your answer sheet (you will need them later). According to the pure expectations hypothesis, what is the expected 2-year spot rate for next year (i.e., the 2-year rate that will prevail on 9/11/2021)? Your answer should be entered and rounded to the nearest 5 decimal places (e.g., 5.1236% should be entered as 0.05124). Suppose today (9/11/2020) there exists a 3-year, 8% coupon bond (annual coupons), and instead of the expectations hypothesis suppose that instead you believe that one year from today (i.e., on 9/11/2021) the yield curve will look at the same as it does today. If you buy the bond today (9/11/2020), what do you expect your one-year holding period return to be i.e., your return from 9/11/2020 to 9/11/2021)? NOTE: This is NOT the bond asked about in #16 -- it is a completely different bond. Make sure to fully support your answer on the supporting worksheet, and express your final answer rounded accurately to the nearest 4 decimal places (e.g., if you calculated 0.02345 then your final answer should be 0.0235)