Answer the cells in orange and please post formulas! thank you!

Pasta Sauce Price/ Capacity Utilization

$4

$5

$6

Expected NPV

70%

($3,000,000)

($1,000,000)

$0

Variance of NPV

80%

($2,000,000)

$1,000,000

$3,000,000

Standard Deviation of NPV

85%

$1,000,000

$2,000,000

$4,000,000

CV of NPV

Probability of NPV < 0

Pasta Sauce Price/ Capacity Utilization

$4

$5

$6

Scenario	Probability	NPV
$4/70%	0.02	($3,000,000)
$5/70%	0.09	($1,000,000)
$6/70%	0.19	$0
$4/80%	0.07	($2,000,000)
$5/80%	0.25	$1,000,000
$6/80%	0.07	$3,000,000
$4/85%	0.20	$1,000,000
$5/85%	0.09	$2,000,000
$6/85%	0.02	$4,000,000

70%

0.02

0.09

0.19

80%

0.07

0.25

0.07

85%

0.20

0.09

0.02