The companies are Duke Energy (DUK) and The Southern Company (SO). Both belong in the Utilities sector and the models chosen are: How can I analyze the company through the Dividend Discount Model? What are the steps? Can we look at the last 5 years in order to make the DDM valuation analysis? How? What is the equity analysis for these 2 step-by-step? Which company is undervalued/overvalued? Why? I will need the analysis on the EXCEL, so if you could please upload the pictures that would be great. What are the calculations behind the model so we can find the value of the companies and decide on which company of the 2 to invest? What is their intrinsic value?

(v) Summarise the key findings of the equity analysis in a format and structure suitable for presentation to the shareholders. (vi) Compare your valuations with the current market stock price and analyse any over-pricing and under-pricing of the stock price