Create a dividend discount model for the company American Telephone & Telegraph

$($AT&T$)$

The dividend discount model should have :

Short term: An estimate of the dividends based on analyst earnings estimates.

Explain in detail the assumptions and figures you took while calculating DDM for Short term.

An excel spreadsheet with the model.

The spreadsheet must be formatted and have links to allow changes in the assumptions.

$$A report on the model

Discussion of the inputs, assumption and output of the model.

The discussion on the inputs must include the following

Cost of Equity

How you got the market risk premium.

How you are to obtained beta and explain your methodology

Constant Growth Rate

Justify the value you calculate

Short term estimates

Where did these come from, how did you calculate the dividend payments.