Solve using excel

Tartan Industries currently has total capital equal to $7 million, has zero debt, is in the 25% federal-plus-state tax bracket, has a net income of $2 million, and distributes 40% of its earnings as dividends. Net income is expected to grow at a constant rate of 5% per year, 440,000 shares of stock are outstanding, and the current WACC is 13.20%. The company is considering a recapitalization where it will issue $5 million in debt and use the proceeds to repurchase stock. Investment bankers have estimated that if the company goes through with the recapitalization, its before-tax cost of debt will be 10% and its cost of equity will rise to 14.5%. a. What is the stock's current price per share (before the recapitalization)? Do not round intermediate calculations. Round your answer to the nearest cent. $ b. Assuming that the company maintains the same payout ratio, what will be its stock price following the recapitalization? Assume that shares are repurchased at the price calculated in part a. Do not round intermediate calculations. Round your answer to the nearest cent. $