Please use excel to solve this question and show the formulas you used to calculate it.

10. [Present Values and Investor Ownership) Vail Venture Investors, LLC is trying to decide how much percent equity ownership in Black Hawk Products, Inc. it will need in exchange for a $5 million investment. Vail Venture Investors has a target compound rate of return of 25 percent on venture investments like Black Hawk Products. Depending on the success of products currently under development, Vail Venture's investment in Black Hawk could turn out to be a complete failure (black hole), barely surviving (living dead), or wildly successful (venture utopia). Vail Venture assigns probabilities of.20, .50, and .30, respectively, to the three possible outcomes. Following are the 3 cash flow scenarios or outcomes for the Black Hawk Products investment that Vail Venture expects to exit at the end of five years. Outcome Black Hole Living Dead Venture Utopia0 0 0S50 million 0 0 00S0 0 0 00S10 million Part A A. Calculate the present value of each scenario or outcome for Black Hawk Products. Calculate the weighted average of the present values for the three scenarios. What is the total equity value for the Black Hawk Products venture? B. C. Determine the acquired percentage of final ownership of Black Hawk Products that Vail Venture Investors would need for its S5 million proposed investment. 10. [Present Values and Investor Ownership) Vail Venture Investors, LLC is trying to decide how much percent equity ownership in Black Hawk Products, Inc. it will need in exchange for a $5 million investment. Vail Venture Investors has a target compound rate of return of 25 percent on venture investments like Black Hawk Products. Depending on the success of products currently under development, Vail Venture's investment in Black Hawk could turn out to be a complete failure (black hole), barely surviving (living dead), or wildly successful (venture utopia). Vail Venture assigns probabilities of.20, .50, and .30, respectively, to the three possible outcomes. Following are the 3 cash flow scenarios or outcomes for the Black Hawk Products investment that Vail Venture expects to exit at the end of five years. Outcome Black Hole Living Dead Venture Utopia0 0 0S50 million 0 0 00S0 0 0 00S10 million Part A A. Calculate the present value of each scenario or outcome for Black Hawk Products. Calculate the weighted average of the present values for the three scenarios. What is the total equity value for the Black Hawk Products venture? B. C. Determine the acquired percentage of final ownership of Black Hawk Products that Vail Venture Investors would need for its S5 million proposed investment