Please answer in excel format with formulas

3. You have been just hired as CEO of Bitter Inc., a conglomerate that operates in three businesses. The details of the businesses are provided below: Movie Entertainment Theaters $450 $400 $200 $85 36% 20% Travel Services Company $325 $1,175 $95 $380 36% 32.42% Revenues Operating Income (next year) Effective tax rate After-tax Operating Income (next year) Invested Capital Expected Growth Rate Cost of capital $128 $525 3.50% 11.00% $68 $375 3.50% 9.25% $61 $125 3.50% 8.00% $257 $1,025 3.50% 10.25% a. What is the value of the consolidated company, using the combined company's cash flows and cost of capital? b. What is the value of Bitter as the sum of its parts, using the divisional cash flows and the industry average cost of capital for each division? c. If you are getting a different value for Bitter in part b, where is the difference coming from? (A) A conglomerate discount is being applied by the market. (B) The broken-up businesses will be run more efficiently as stand-alone units. (C) The combined company has a less optimized capital structure than that the individual units could have. (D) The broken-up businesses will pay less in taxes than the combined company. (E) The broken-up businesses will have higher growth than the combined company. (F) All of the above. 3. You have been just hired as CEO of Bitter Inc., a conglomerate that operates in three businesses. The details of the businesses are provided below: Movie Entertainment Theaters $450 $400 $200 $85 36% 20% Travel Services Company $325 $1,175 $95 $380 36% 32.42% Revenues Operating Income (next year) Effective tax rate After-tax Operating Income (next year) Invested Capital Expected Growth Rate Cost of capital $128 $525 3.50% 11.00% $68 $375 3.50% 9.25% $61 $125 3.50% 8.00% $257 $1,025 3.50% 10.25% a. What is the value of the consolidated company, using the combined company's cash flows and cost of capital? b. What is the value of Bitter as the sum of its parts, using the divisional cash flows and the industry average cost of capital for each division? c. If you are getting a different value for Bitter in part b, where is the difference coming from? (A) A conglomerate discount is being applied by the market. (B) The broken-up businesses will be run more efficiently as stand-alone units. (C) The combined company has a less optimized capital structure than that the individual units could have. (D) The broken-up businesses will pay less in taxes than the combined company. (E) The broken-up businesses will have higher growth than the combined company. (F) All of the above