can you please help with this question? with full clear answers

EGEE 451 Fall 2016 Assignment #3: Decision Analysis EGEE 451 Southern PV (Adapted from Clemen, 1996). This assignment is designed to familiarize you with using tools of decision analysis to build decision trees, analyze alternatives under uncertainty, explore the value of information, and the value of flexibility. Problem Description: Steve Sheffler is president, CEO, and majority stockholder of Southern PV, a startup technology firm with a revolutionary new material for solar photovoltaic cells. Steve faces a major decision: Two firms, Edison Energy and Westinghouse Renewables, are bidding to purchase Southern PV. Steve founded Southern 15 years ago, and the company has been extremely successful in developing advanced materials for solar cells. Steve is ready to sell the company (as long as the price is right!) so that he can pursue other interests. Last month, Edison Energy offered Steve $6 million and 100,000 shares of Edison Energy stock (currently trading at $75 per share and not expected to change substantially in the future). Until yesterday, Edison Energy's offer sounded good to Steve, and he had planned on accepting it this week. But a lawyer from Westinghouse Renewables called last week and indicated that Westinghouse was interested in acquiring Southern PV. In discussions this past week, Steve has learned that Westinghouse is developing a new solar-energy storage system, codenamed EnergyWall (EW) that, if successful, will revolutionize the industry. Southern PV could play an important role in the development of the energy system design. In their discussions, several important points have surfaced. First, Westinghouse has said that it believes the probability that the EW will succeed is 0.6, and that if it does, the value of Westinghouse's stock will increase from the current value of $30 per share. Although the future price is uncertain, Westinghouse judges that, conditional on the EW's success, the anticipated price of the stock is $60 per share. If the EW is not successful, the price will probably decrease slightly. Westinghouse judges that if the EW fails, Westinghouse's share price will fall to $20 per share. HW3 Decision Analysis 1 EGEE 451 Fall 2016 Yesterday Steve discussed this information with his financial analyst, who is an expert regarding the energy technology industry and whose counsel Steve trusts completely. The analyst pointed out that Westinghouse has an incentive to be very optimistic about the EW project. "Being realistic, though," said the analyst, "the probability that the EW succeeds is only 0.45, and if it does succeed, the expected price of the stock would be only $50 per share. On the other hand, I agree with Westinghouse's assessment for the share price if the EW fails." Negotiations today have proceeded to the point where Westinghouse has made a final offer to Steve of $5 million and 200,000 shares of Westinghouse stock. The company's representative has stated quite clearly that Westinghouse cannot pay any more than this in a straight transaction. Furthermore, the representative claims, it is not clear why Steve will not accept the offer because it appears to them to be more valuable than the Edison Energy offer. Questions: 1. In terms of expected value, what is the least that Steve should accept from Westinghouse (This amount is called his reservation price)? 2. Create and solve the decision tree for Steve's problem (use the probabilities and stock price estimates from Steve's analyst, not Westinghouse's estimates). Which offer should Steve accept and why (assume Steve is risk-neutral)? [Build and solve your decision tree in Excel to make the remaining questions easier]. 3. (Sensitivity Analysis). a. Conduct a sensitivity analysis on the probability that EW succeeds (the probability of failure is 1 minus this value). Using an Excel version of the decision tree, test these values for the probability of success: {0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9} Above what probability of success is Westinghouse's offer better than Edison Energy's. b. Perform a two-way sensitivity on Westinghouse's stock price conditional on EW success and probability of success (the price if EW is a failure is still $20). Test all combinations of the following values: probability of success = {0.1, 0.3, 0.5, 0.7, 0.9} and stock price if success = {$40, $50, $60, $70}. For each combination, which is the best decision (Westinghouse or Edison)? For what ranges of values HW3 Decision Analysis 2 EGEE 451 Fall 2016 should Steve accept Westinghouse's offer. Does this explain why Westinghouse thinks their offer is fair? You can show these results with a table. 4. (Risk Profiles/Target Curves). Return to the original decision tree you built for Q2. Draw/plot the cumulative distributions for the alternatives (also known as the 'Risk Profiles' or the 'Target Curves'). Are any alternatives stochastically dominant? Is one higher risk/variance than the other? 5. (Expected Value of Perfect Information). Return to the original decision tree you built for Q2, and calculate the Expected Value of Perfect Information. What is this number and what does it mean? Give an intuitive interpretation. 6. (Expected Value of Imperfect Information). For the original decision in Q2, Steve's analyst now tells him he knows an expert in the specific technology type that EW is in. This expert has a good track record of predictions: 80% of the time that a technology succeeds, this expert has predicted \"Good\