I need to fill in the yellow cells, with formulas whenever possible. Thanks xxx

On January 1, 2017, Silicon Valley Bank purchased 3% bonds having a face value of $25,000,000,000 to yield a 2% market rate. The bonds are dated January 1, 2017 and mature January 1, 2027 (10 year term), with interest payable semiannually (July 1 and January 1) each year. (Hint: You will first need to populate the following information, in bold, before calculating MARKET RATE)