The company I chose was microsoft

any guidance how to demonstrate this within excel would be greatlly appreciated.

Please recall the company that you selected for the Module 1 SLP. Please review the companys dividends over the past three years. Then, answer the following questions in Word (except for the Excel portion specifically noted):

What has occurred with companys dividend payout, dividend yield, and dividend per share over the past three years? Do you have any explanations for what has occurred?

How does your selected companys dividend payout, dividend yield, and dividend per share compare to other companies in its industry? Has the companys dividend strategy been similar to other companies in its industry?

You are now to use Excel and plot your selected companys earnings and dividends over the past three years. Do you notice any patterns?

What is your estimate for your companys dividend per share next year? Please justify why you made that decision.

Now locate a company that has reduced or eliminated its common stock cash dividend over the past year. Why did the company reduce or eliminate its dividend? What has happened to the companys stock price over the year?