Use the following information to answer the questions below:

Settlement Date 2/15/2017

Maturity Date 2/15/2037

First Call Date 2/15/2022

Coupon Rate 6.00%

Required Return 9.00%

Face Value 1000

Call Price 1060

Frequency 2

Basis 0

-------------------------------------------------------------------------------

1. What is the value of the bond making use of the dates listed above (settlement, maturity) using the =price() function? Assume semiannual coupons.

2. What is the current yield of the bond assuming that the current bond value is $900 (put in percentage form and remember that current yield = annual interest over current price)?

3. What is the yield using the =yield() function for this bond making use of the dates listed above (settlement, maturity) in % form? Assume semiannual coupons.

4. What is the yield to call for this bond if called early making use of the dates listed above (settlement, first call date) using the =yield() function? Assume semiannual coupons.

5. What is duration for the bond above using the =duration() function?