PLEASE DO IT IN EXCEL. An investor receives 3 projects and must decide in which of them he should invest, he has the following information: Project A: Considers a R&D cost of $200,000 and in the thind month a capital contribution of $200,000 and a monthly return of $135,000 is expected. Project B: Consider an initial investment of $200,000 and a monthly return of $90,000 is expected and a monthly maintenance savings of $20,000 and an operational cost of $20,000 per month Project C: Considers a R \& cost of $200,000 and a capital contribution of $220,000 in the second month and then in the fourth month it must return to contribute $220,000 and a monthly return of $175,000 is expected. Background: Discountrate15% and a project duration of 6 months Questions. 1) Which project generates the most profit? procedure and explain thoroughly the answer) 2) If the investor can only choose one project, which one do you recommend investing in according to NPV, IRR, Payback \& Cash hole? Explain. PLEASE DO IT IN EXCEL. An investor receives 3 projects and must decide in which of them he should invest, he has the following information: Project A: Considers a R&D cost of $200,000 and in the thind month a capital contribution of $200,000 and a monthly return of $135,000 is expected. Project B: Consider an initial investment of $200,000 and a monthly return of $90,000 is expected and a monthly maintenance savings of $20,000 and an operational cost of $20,000 per month Project C: Considers a R \& cost of $200,000 and a capital contribution of $220,000 in the second month and then in the fourth month it must return to contribute $220,000 and a monthly return of $175,000 is expected. Background: Discountrate15% and a project duration of 6 months Questions. 1) Which project generates the most profit? procedure and explain thoroughly the answer) 2) If the investor can only choose one project, which one do you recommend investing in according to NPV, IRR, Payback \& Cash hole? Explain