Expected return required by convertible bondholders = 9% Hint: Use Goal seek to set the difference between the convertible bondholders' current return and the target return to zero by changing the input cell for the conversion ratio. Current difference between bondholders' current expected return and target return (multiplied by 1000) = Conversion ratio (given original convertible coupon rate) that produces the required yield (Note: after using Goal Seek, cut and paste the conversion ratio into the yellow cell):