on excel please

Old Growth Corp (OGC) most recent free cash flow (FCF) was $500 million; the FCF is expected to grow at a constant rate of 2.5%. The rms WACC is 15%, and it has 12 million shares of common stock outstanding. The rm has $300 million in short-term investments, which it plans to liquidate and distribute to common shareholders via a stock repurchase; the rm has no other non-operating assets. It has $985 million in debt and $450 million in preferred stock.

a. What is the value of operations? b. Immediately prior to the repurchase, what is the intrinsic value of equity? c.Immediately prior to the repurchase, what is the intrinsic stock price?

d.How many shares will be repurchased? How many shares will remain after the repurchase?

e.Immediately after the repurchase, what is the intrinsic value of equity? The intrinsic stock price?