URGENT!!!

Please show which formula is being used for the question. Thank you

Question 3 (20 marks) Group Genesis is considering upgrading its computer servers. Two mutually exclusive plans are proposed by the IT consulting firm and their respective estimated net cash flows are listed below. Assume that the relevant discount rate is 8% per annum. Year Plan I Plan II 0 -$150,000 -$150,000 1 $50,000 $64,000 2 $50,000 $56,000 3 $50,000 $40,000 4 $50,000 $40,000

(a) Compute the payback period for Plan I and Plan II.

(b) If Group Genesis uses a payback criterion of 2.8 years or less, which plan would it choose (4 marks) based on the results in part (a)? (2 marks)

(c) Just by studying the cash flows pattern of Plans I and II (i.e., WITHOUT calculation), explain which plan should have higher NPV value. (3 marks)

(d) Compute the NPV of Plan I and Plan II. Which plan should the company accept (if any)? (8 marks)

(e) Based on the results in parts (a) and (d), which plan should Group Genesis choose? Explain. (3 marks)