In cell E14, by using cell references, calculate the company's average hurdle rate. Use the relevant cells from the given data section.
a) Calculate the net present value
b) Determine the internal rate of return
c) Evaluate the payback period
d) Compute the weighted average cost of capital
