Please answer this question in detail with formulas as to denote what is calculated when and where. If possible also calculate manually, i.e. without Excel - if not possible please give me manual calculations of point (c) i.e. calculating the DPBP.

14. Consider the following projects: (a) Calculate the payback period for each project. (b) If the standard payback period is 2 years, which project will you select? Will your answer be different if the standard payback is 3 years? A KB (c) If the cost of capital is 10%, compute the discounted payback for each project? Which projects will you recommend if the standard payback is (i) 2 years; (ii) 3 years? (d) Compute the NPV of each project? Which projects will you recommend