How is this treasury yield calculated?

[golden_eagle]

I got this spreadsheet from a friend and was asked how to calculate the yield numbers. All are callable. 

I can calculate it as (100/40.85)^(1/(2050-2023)) -1 + 0.0 = 0.0337, which is more or less accurate. I believe the first item, one buys at 40.85 and get 100 at 05/15/2049 or until it's called, gets nothing in between.

Number 4 I calculate it as (100/80.7)^(1/(2050-2023)) -1 + 0.0225 = 0.03047, which is 10% off. What is the formula? As for the trade, one pays $80.7, gets $2.25 each year, then get back $100 at 08/15/2049. Is the trade correct? 

 

PRODUCT    CLOSING PRICE    CLOSING YIELD    CURRENT BID YIELD    CURRENT BID PRICE/SIZE     CURRENT ASK YIELD    CURRENT ASK PRICE/SIZE     MATURITY    CALLABLE    CUSIP    MOODY'S    S&P    
1) United States Treasury 0.0    40.85    —    3.414%     40.2510 x $5,000K    3.376%     40.6520 x $5,000K    05/15/2049        —    —    —    
2) United States Treasury 3.0    93.84    —    3.371%     93.5150 x $3,000K    3.360%     93.7000 x $5,000K    02/15/2049        —    AAA    —    
3) United States Treasury 2.875    91.80    —    3.359%     91.4680 x $3,000K    3.348%     91.6540 x $5,000K    05/15/2049        —    AAA    —    
4) United States Treasury 2.25    80.69    —    3.357%     80.3906 x $3,483K    3.343%     80.6060 x $5,000K    08/15/2049        —    AAA    —    
5) United States Treasury 1.25    62.41    —    3.351%     62.1270 x $10,000K    3.336%     62.3260 x $10,000K    05/15/2050        —    AAA    —    
6) United States Treasury 2.0    76.11    —    3.343%     75.8900 x $3,000K    3.333%     76.0430 x $5,000K    02/15/2050        —    —    —    
7) United States Treasury 0.0   39.83    —    3.374%     39.3400 x $5,000K    3.332%     39.7960 x $5,000K    05/15/2050        —    —    —    

Edited June 25, 2022 by golden_eagle