use excel and show formulas please

Xabbdu Co. sell shares on the market for $82.40. It has 52 million shares outstanding with a book value per share of $12.99 and a net income of $1.2 billion. The firm will raise $357,066,650 in capital to add to assets through an equity issue. The asset addition will raise net income by $100 million. Assuming the PE ratio stays constant, how will this equity issue affect the price per share and EPS (If at ali)? $0.67 loss in price/\$0.49 loss in EPS 50.48 gain in price/\$0.66 gain in EPS no change $0.83 loss in price/\$1.01 gain in EPS 50.08 gain in price/\$0.15 loss in EPS