How would this treasury note formula work in excel? With 6.50% new value of a 10 year treasury note 100,000 futures contract?

Uic following equation: loymentld=5905122466796156838054536989 BN=9780357114582&id=998502970&nbid=2093604&snaps Print Preview 20 $30 $1,000 IM + (1 + ra/2)t = $1,267.1875 (1 + Id/2)20 on value for the 6-month rate is 1.45122%, which is equivalent to a nominal te of 2.90244%, or 2.90%. Because the price of the bond rose by 6.5/32 that day, find the previous contract price and its implied interest rate, which would turn out by 2 basis points (from 2.92% to 2.90%), which