How did they get this on Excel?

It is 5PM on May 23rd, 2016, and you are looking at a bond table. You see a 3% treasury bond maturing in 2045 (Nov 15th) offered at 107.6875, with an asked yield of 2.624. IT WORKS! 3% Maturity Close Settle 5/23/16 5/25/16 11/15/45 Days: 10766 Years: 29.4958904 YTM 0.02624 CPN PV 613.37122 PRIN PV 463.50464 TOTAL $ 1,076.88 SA 0.01312