how to do in excel

1. What is your value per share of Comet using a forward P/E of 12 and its sustainable growth rate? TTM Annual Sales EBIT Net Income $200,000 $120,000 $100,000 40% $400,000 CGS EBITDA Outstanding Shares Value of Equity Price per share Dividend Payout Book Value of Equity Is the market over or under valuing Comet shares? $ 80,000 $140,000 5,000 $1,350,000 $270

What is your value per share of Comet using a forward P/E of 12 and its sustainable growth rate? Is the market over or under valuing Comet shares