Answer this question through excel and show all formulas used!

8. Machines A and B are mutually exclusive and are expected to produce the following real cash flows: Machine Co -100 C Cash Flows ($ thousands) 61 C2 +110 +121 +110 +121 A B -120 +133 The real opportunity cost of capital is 10%. a. Calculate the NPV of each machine. b. Calculate the equivalent annual cash flow from each machine. c. Which machine should you buy