We have two projects; project A and project B. A 10% cost of copital and 10 -year projects. Assume that the financial manager created three scenarios for each project: pessimistic, most likely, and optimistic. The table below summarizes the cash inflows Calculate the NPV for each of the three scenarios for each project. (5points) Calculate the range of cash inflows: (2points) Calculate the NPV ranges. (3points) For full credit, please upload an Excel spreadsheet of your solution to your response. (10 points)