Data table Probability Cash flow for each scenario Click on the icon Scenario I: Recession 30% Scenario II: Normal 50% $147,000 $(49,000) in order to copy its contents into a spreadsheet.) 1 Scenario Il Expansion 20% $252,000 (Forecasting cash flows using the expected value) Rao Roofing of Stillwater, Oklahoma, is considering the acquisition of Simpkins Storage Company. Rao's management team has analyzed the annual cash flows for Simpkins and come up with these estimates for the three states of the economy shown here: A rival firm, Michell Storage Company is also considering a bid for Simpkins and their estimated cash flow for Simpkins in each potential state of theb economy are the same as those of Rao. However, Mitchell's management is much more optimistic about the economy. They estimate the probability of a recession next year at only 25 percent, the probability of a normal state of the economy at 45 percent, and the probability of expansion at 30 percent. a. Based on Rao's estimated probabilities for each state of the economy, what should be their estimate of expected cash flows for Simpkins? economy shown here: A rival firm, Michell Storage Company is also considering a bid for Simpkins and their estimated cash flow for Simpkins in each potential state of theb economy are the same as those of Rao. However, Mitchell's management is much more optimistic about the economy. They estimate the probability of a recession next year at only 25 percent, the probability of a normal state of the economy at 45 percent, and the probability of expansion at 30 percent. a. Based on Rao's estimated probabilities for each state of the economy, what should be their estimate of expected cash flows for Simpkins? b. What should be Mitchell's estimate of the expected cash flow for Simpkins' year one cash flow? c. Which company do you think will ultimately be willing to pay the highest price for Simpkins, all else being equal other than their outlook for the economy? a. Based on Rao's estimated probabilities for each state of the economy, their estimate of the expected cash flow for Simpkin should be $. (Round to the nearest dollar.) b. Mitchell's estimate of the expected cash flow for Simpkins' year one cash flow should be $. (Round to the nearest dollar.) c. Which company do you think will ultimately be willing to pay the highest price for Simpkins, all else being equal other than their outlook for the economy? (Select the best choice below.) OA. Mitchell's optimistic view of the future state of the economy creates a higher forecasted cash flow and might lead to a willingness to pay more for the acquisition. 26_L_I_