Create an Excel file that prices a stock using the dividend discount model.The user inputs to your model will be:

The expected dividends for each of years 1,2,3,4 and 5

The expected dividend in year 6

The constant growth rate of the dividend from year 6 onwards

The appropriate discount rate

The output from your model will be the stock price.

Using the Enterprise Value / EBITDA valuation method, calculate what the stock price should be for:

Alphabet (Google)

Royal Bank of Canada

Compare your estimate of price with the actual current price of the stock in the market.You should choose three appropriate comparables for each of the stocks.