could you show calculations on excel

19. Douglas Controls, Inc. is considering two mutually exclusive and equally risky projects, S and L. Their cash flows are shown below. The CEO believes the IRR is the best selection criterion, while the CFO advocates the NPV. If the decision is made by choosing the project with the higher IRR rather than the one with the higher NPV, how much, if any, value will be forgone, i.e., what's the chosen NPV versus the maximum possible NPV? Note that (1) "true value is measured by NPV, and (2) under some conditions the choice of IRR vs. NPV will not affect the value gained or lost. Douglas has a cost of capital of 8.50%. I Year 0 1 2 3 CFS -$1,100 $550 $600 $100 $100 CFL -$2,700 $550 $725 $845 $1,400