Stock Repurchase - Multi-part Question. (If possible please include a version of the excel sheet with the formulas showing).

Bayani Bakery's most recent FCF was $48 million; the FCF is expected to grow at a constant rate of 6%. The firm's WACC is 12%, and it has 15 million shares of common stock outstanding. The firm has $30 million in short-term investments, which it plans to liquidate and distribute to common shareholders via a stock repurchase; the firm has no other nonoperating assets. It has $370 million in debt and $64 million in preferred stock.

1. What is the value of operations? Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.

   $ million

2. Immediately prior to the repurchase, what is the intrinsic value of equity? Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.

   $ million

3. Immediately prior to the repurchase, what is the intrinsic stock price? Round your answer to the nearest cent.

   $ per share

4. How many shares will be repurchased? Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.

   million shares

   How many shares will remain after the repurchase? Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.

   million shares

5. Immediately after the repurchase, what is the intrinsic value of equity? Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.

   $ million

   The intrinsic stock price? Round your answer to the nearest cent.

   $ per share