Based on the following information please use the Excel œYield function

QUESTION

Based on the following information please use the Excel œYield function to calculate the yield to maturity of the bond. You can use the Excel help function to clarify terms of the function. Please carry your answer to two decimal places.Terms of Bond:a)Settlement date: 12/10/2015 Maturity: 12/10/2020Rate: 5%Price: $90Redemption: $100Frequency: 2Basis: 0The yield to maturity is 6.43% True Falseb)Settlement date: 12/10/2015 Maturity: 12/10/2035Rate: 5%Price: $90Redemption: $100Frequency: 2Basis: 0The yield to maturity is 5.86% True Falsec)Settlement date: 12/10/2015 Maturity: 12/10/2035Rate: 5%Price: $101Redemption: $100Frequency: 2Basis: 0The yield to maturity is 4.92% True Falsed)Settlement date: 12/10/2015 Maturity: 12/10/2035Rate: 5%Price: $106Redemption: $100Frequency: 2Basis: 0The yield to maturity is 5.01% True False

ANSWER

CLICK HERE TO GET AN EXPERT SOLUTION TO THE QUESTION