Using the information given in "PART A" please use excel or a table so I can clearly see how this type of problem needs to be structured. I just need Part B and Part C answered. Thank you!

YEAR RATES CASH FLOW $10,000 1 a. What date did you choose? Is the yield curve on your selected date, normal, steep, flat, or inverted? b. Use those rates to complete the table. Be sure to indicate the dates so that I can verify your data. Use those rates to calculate the present value of the listed cash flows and the total present value of the stream of cash flows. 2 $10,000 3 $10,000 Part A Date 1/24/2020 1 Mo 1.54 2 Mo 1.55 3 Mo 1.54 6 Mo 1.55 1 Yr 1.55 2 Yr 1.49 3 Yr 1.48 5 Yr 1.51 7 Yr 1.61 10 Yr 1.70 20 Yr 2.00 30 Yr 2.14