The rates shown below are from bloomberg.com on 1/27/2020. Use the YIELD function in Excel to calculate the yield of 1.43% for the 5 year U.S. Treasury obligation. -nm rinoco a Treasury Yields NAME COUPON PRICE YIELD 10 GB3:GOV 3 Month 0.00 1.52% 11 12 ODA 0.00 GB6:GOV 6 Month 1.55% 001471.51% GB12:GOV 12 Month GT2:GOV 2 Year 100.37 1.42% GT5:GOV 5 Year 101.52 1.43%