1. Little Oil has outstanding 1 million shares with a total market value of $20 million. The firm is expected to pay $1 million of dividends next year, and thereafter the amount paid out is expected to grow by 5 percent a year in perpetuity. However, the company has heard that the value of a share depends on the flow of dividends, and therefore it announces that next years dividend will be increased to $2 million and that the extra cash will be raised immediately afterward by an issue of shares. After that, the total amount paid out each year will be as previously forecasted, that is, $05 million in year 2 and increasing by 5 percent in each subsequent year.

1. At what price will the new shares be issued in year 1?
2. How many shares will the firm need to issue?
3. What will be the expected dividend payments on these new shares, and what therefore will be paid out to the old shareholders after year 1?
4. Show that the present value of the cash flows to current shareholders remains $20 million.
5. Assume that new shares are issued in year 1 at $10 a share. Show who gains and who loses. Is dividend policy still irrelevant? Why or why not?

PLEASE DO IT IN EXCEL AND PROVIDE STEPS AND FORMULAS

Thank you