I must create (through Excel) the following analysis; determine and forecast A) The payout rate, b) the expected growth rate in dividend, and c) the likely dividend in the following year for a company. This requires the stream of dividends and earnings, and it is beneficial to include growth in sales, assets, and book value of the company. [So please include these]. I must do this over a span of several years for the firm - I want to learn how to do this myself. Please conduct said analysis over say 2 years with a random company's data, and EXPLAIN how it has been done. A general site can be used for the dividend data, such as yahoo finance.

Again, I want to LEARN how to do this with a different company, so please provide basic equations with the solved data.