please do in excel and show calculations, thank you.

New Value Corp (NVC) most recent free cash flow (FCF was $525 million; the FCF is expected to grow at a constant rate of 2.5%. The firm's WACC is 15%, and it has 9 million shares of common stock outstanding. The firm has $200 million in short-term investments, which it plans to liquidate and distribute to common shareholders via a stock repurchase; the firm has no other non-operating assets. It has $968 million in debt and $260 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