contro Excel Online Activity: Project risk analysis X Question 1 G10 Hvideo Bub Excel Online Structured Activity Project risk analysis The Butler Perkins Company (PC) must decide between two mutually exclusive projects. Each costs $7.000 and has an expected life of years. Annual project cash flow begin year after the initial investment and are subject to the following probability distributions: Project A Projects Probability Cash Flows Probability Cash Flows 02 $6,250 0.2 50 0.6 $7.000 0.6 $7,000 0.2 57.750 02 $18,000 FC has decided to evaluate the niskoer project at 17 and the bas-rluky project at . The data has been collected in the Microsoft Excel na fie below. Open the readed and perform the required analysis to answer the question below. Open spreadsheet What is each project's expected annual cash flow Round your answers to two decimal places Project Als Projects Project By standard deviation () is $5,77.01 and its conficient of variation (CV) lis 0.74, what are the values of (on) and (CAP Round your answers to two decimal places CA- CVA . Based on the risk-adjusted NPS, which project should BPC choose? Question 1 0/10 0.2 $7,750 0.2 $18,000 Submit BPC has decided to evaluate the risker project at 12% and the lessky project at 9%. The data has been collected in the Microsoft Excel Online Nebelow Open the spreadsheet and perform the required analysis to answer the questions below Open spreadsheet What each project's expected annual cash flow? Round your answers to two decimal places Project A: 5 Project : Projecte standard deviation (on) { $5,775.61 and its coefficient of variation (CV) 0.74 What are the values of (o) and (CV)? Hound your answers to two decimal places OAS CVA- 6. Based on the risk adjusted NPW, which project should choose? c. If you knew that Project B's cash flows were negatively correlated with the firm's other cash now, but project A's cash nows were positively correlates, now might this affect the decision 1 Project B's can nows were negatively correlated wah gross domestic product (GO) while we can now were posnively correlated, would that influence your risk assessment Check My Work Reset