Calculate this problem through excel and show all the formulas used to calculate every single cell that involves calculation. Do not use handwritten work or do not answer this question unless you are using excel

A one year Treasury bill has a yield of 5%. A bond will pay $40 at the end of year one and $1,040 at the end of year 2. If its market value is $946.50, the two-year spot rate is: (a) 9%. (b) 5%. (c) 7%. (d) 6%