17-29, please see attached. I need the formulas and associated answers. Thank you.

Problem 17-29 AMC Corporation currently has an enterprise value of $400 million and $100 million in exc million shares outstanding and no debt. Suppose AMC uses its excess cash to repurchase sha repurchase, news will come out that will change AMC's enterprise value to either $600 mill a. What is AMC's share price prior to the share repurchase? b. What is AMC's share price after the repurchase if its enterprise value goes up? What i the repurchase if its enterprise value declines? c. Suppose AMC waits until after the news comes out to do the share repurchase. What i the repurchase if its enterprise value goes up? What is AMC's share price after the rep value declines? d. Suppose AMC management expects good news to come out. Based on your answers t management desires to maximize AMC's ultimate share price, will they undertake the the news comes out? When would management undertake the repurchase if they expe e. Given your answers to part (d), what would you expect an announcement of a share re news to have on the stock price? Why? Enterprise value before announcement (million) Excess cash (million) Shares outstanding (million) High enterprise value (million) Low enterprise value (million) $400 $100 10 $600 $200 a. What is AMC's share price prior to the share repurchase? Share price before repurchase b. What is AMC's share price after the repurchase if its enterprise value goes up? What i the repurchase if its enterprise value declines? Shares to repurchase (million) High share price post repurchase Low share price post repurchase c. Suppose AMC waits until after the news comes out to do the share repurchase. What i the repurchase if its enterprise value goes up? What is AMC's share price after the rep value declines? High share price post repurchase Low share price post repurchase d. Suppose AMC management expects good news to come out. Based on your answers t management desires to maximize AMC's ultimate share price, will they undertake the the news comes out? When would management undertake the repurchase if they expe If management expects the news to be good, it will benefit shareholders if they repurc If management expects the news to be bad it will benefit shareholders if they repurcha e. Given your answers to part (d), what would you expect an announcement of a share re news to have on the stock price? Why? Requirements 1. In cell D21, by using cell references, calculate the company's share price prior to the 2. In cell D25, by using cell references, calculate the number of shares that can be repurc cash (1 pt.). 3. In cell D26, by using cell references, calculate the company's share price after the sha enterprise value goes up (1 pt.). 4. In cell D27, by using cell references, calculate the company's share price after the sha enterprise value goes down (1 pt.). 5. In cell D31, by using cell references, calculate the company's share price after the ann the share repurchase) if its enterprise value goes up (1 pt.). 6. In cell D32, by using cell references, calculate the company's share price after the ann the share repurchase) if its enterprise value goes down (1 pt.). 7. In cell C37, type before the news is released. (lowercase) (1 pt.). 8. In cell C40, type after the news is released (lowercase). (1 pt.). 9. In cell C44, type You would expect the share price to increase, because the annou good news is about to be released. (sentences case) (1 pt.). d $100 million in excess cash. The firm has 10 ash to repurchase shares. After the share e to either $600 million or $200 million. alue goes up? What is AMC's share price after e repurchase. What is AMC's share price after are price after the repurchase if its enterprise ed on your answers to parts (b) and (c), if ll they undertake the repurchase before or after urchase if they expect bad news to come out? ncement of a share repurchase prior to the alue goes up? What is AMC's share price after e repurchase. What is AMC's share price after are price after the repurchase if its enterprise ed on your answers to parts (b) and (c), if ll they undertake the repurchase before or after urchase if they expect bad news to come out? olders if they repurchase ders if they repurchase ncement of a share repurchase prior to the re price prior to the share repurchase (1 pt.). res that can be repurchased with the excess re price after the share repurchase if its re price after the share repurchase if its re price after the announcement (but before re price after the announcement (but before . because the announcement will mean that