Calculating key stock performance metrics. The Alliance Company recently reported net profits after taxes of $15.8 million. It has 2.5 million shares of common stock outstanding and pays preferred dividends of $1 million a year. The companys stock currently trades at $60 per share.

a) Compute the stocks EPS.

b) What is the stocks P/E ratio?

c) Determine what the stocks dividend yield would be if it paid $1.75 per share to common stockholders.

Please use excel and show functions so I can attempt to learn myself. Thank you!