"Convertible preferred stockValerian Corp. convertible preferred stock has a fixed conversion ratio of 10 common shares per 1 share of preferred stock. The preferred stock pays a dividend of $7.00 per share per year. The common stock currently sells for $50 per share and pays a dividend of $2.00 per share per year.

a.On the basis of the conversion ratio and the price of the common shares, what is the current conversion value of each preferred share?

b.If the preferred shares are selling at $495 each, should an investor convert the preferred shares to common shares?

c. What factors might cause an investor not to convert from preferred to common stock?"

Please post Excel formulas and with out formula