please use excel

1. Corporation A is deciding on an acquisition. Corporation A would buy all shares of corporation B, for a total of 500,000 shares of B. Currently, corporation B is expected to pay a constant dividend forever of $12 per share. The market price of B shares reflects these expectations, and the required rate of return is 4%. A can buy B shares at their current market price, and management expects to be able to exploit synergies between the two corporations and increase revenues. Thus, according to A's management, if the acquisition takes place the dividend per share for next year is expected to be $12, but dividends are then expected to grow forever at a rate of 3% per year. The required rate of return on stock B would stay unchanged at 4%. What is the NPV of the acquisition? ( 5 points)