Pick a stock from the S&P 500 and find the following information on the stock: Current dividend, current selling price. If you need a list of S&P stocks, go to...

please see the attached file


Pick a stock from the S&P 500 and find the following information on the stock: Current dividend,  current selling price. If you need a list of S&P stocks, go to  https://en.wikipedia.org/wiki/List_of_S%26P_500_companies.  Find information on how the dividend has changed over time. If you cannot find at least 5 years’  worth of dividend data, choose a new stock. See  https://www.streetinsider.com/dividend_history.php?q=msft or  https://www.nasdaq.com/market-activity/stocks/msft/dividend-history for an example of a  dividend history. (Note, we will not allow an analysis of MSFT, AAPL, INTC, ORCL, or IBM for this  mini-project.)  Your tasks:  1. Estimate the dividend growth rate.  2. Using your information on current price, current dividend, and estimated growth rate, estimate  the effective annual interest rate, using the growing perpetuity formula. (Many firms pay out  dividends multiple times per year. Make sure to take this into account of your calculation. You  should also account for when the next dividend will be paid.) Make your calculations as clear as  possible; there should be no ambiguity as to which numbers are being used.  3. Repeat estimating the effective annual interest rate using the value of the stock on August 1,  2020.  4. State the sources you accessed the information you found. Also state the date(s) that you  accessed the information.  5. State which discount rate you believe to be more accurate, and why. (Hint: Reading about  financial news from the last few months may help you to formulate your argument.)  The answers to parts 2-4 should be very brief in your answers. Most of the analysis should  address #1 and #5. A typical submission should have about 200 words, but up to 300 words is  acceptable.    I picked AT&T   AT&T current dividend: $0.52 current selling price: $27.82