Coupon	Type	Frequency	Years to Maturity	Current Price (per $100 par)
4.25%	Fixed	Semi-Annually	20	$78.28

Based on the information above calculate in excel:

1. Yield to Maturity at current price

2. Current Yield at current price

3. Current Value assuming the appropriate discount rate = 7%

4. Expected Value in 5 Years if the appropriate discount rate remains 7%

5.Expected Value in 5 Years if the appropriate discount rate increases to 10%

6. Expected Value in 5 Years if the appropriate discount rate falls to 5%