You're deciding whether or not to build a new plant in order to ramp up production. Calculate the standard deviation for the project when you have the following estimates:

Outcome	Probability	Return
Better than expected	0.15	0.55
Average	0.5	0.25
Worse than expected	0.25	0.08
Poor	0.1	-0.15

Next, you are analyzing an investment. The beta is 1.25, the risk premium is .055, and the risk-free rate of return is .035. What is the required return on the investment?

Show using Excel formulas as well, if possible.