Excel Online Structured Activity: Project risk analysis

and are subject to the following probability distributions:

to answer the questions below.

Open spreadsheet

a$.$ What is each project's expected annual cash flow? Round your answers to two decimal places.

Project A: $

Project B: $

Project B$\text{'}$s standard deviation $({}_B)$ is $$6,185\mathrm{.}47$ and its coefficient of variation $(C{V}_B)$ is $0\mathrm{.}80.$ What are the values of $({}_A)$ and $(C{V}_A)?$ Round your answers to two decimal places.

${}_A=$$

$C{V}_A=$

b$.$ Based on the risk$-$adjusted NPVs$,$ which project should BPC choose?

$[$

If Project B$\text{'}$s cash flows were negatively correlated with gross domestic product $($GDP$),$ while A$\text{'}$s cash flows were positively correlated, would that influence your risk assessment?