Below is the treasury yield on two dates, January 1, 2010 and January 2, 2012. Yields are listed below are stated as APRs

Maturity	1 year	2 year	3 year	5 year
1/1/10	4%	4.5%	5%	6%
1/1/12	3%	3.5%	4%	5%

On 1/1/10, you purchase a 5-year treasury bond with a FV of $100 and 3% coupon rate that pays coupons semi-annually. If you sold the bond on 1/1/12 (just after the Jan 1 coupon payment), what was the IRR on your investment, stated as an EAR?

How would you do this by hand and in Excel?