Consider a convertible bond with the following characteristics:

Required:

Note: Use cells A$2$ to B$12$ from the given information to complete this question.

Using the above information and the dates below, calculate the Yield to Maturity, the

Current Yield, and the Yield to Call.