Hello, can I get a step by step solution for this question using excel? Thank you!

This is a practice homework assignment to understand the concept. This is not intended to be submitted. This is my understanding!

You own 2,200 shares of stock in Avondale Corporation. You will receive a dividend of $1.80 per share in one year. In two years, the company will pay a liquidating dividend of $45 per share. The required return on the company's stock is 20 percent. a. Ignoring taxes, what is the current share price of your stock? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g.. 32.16.) b. If you would rather have equal dividends in each of the next two years, how many shares would you sell in one year? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) c. What would your cash flow be for each year for the next two years if you create equal homemade dividends? Hint: Dividends will be in the form of an annuity. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) 3 _