Please I ADVISE YOU NOT TO USE EXCEL UNLESS YOU ARE VERY SURE HOW TO USE IT

Thanks

1. Find the NPV, IRR, Payback Period, Profitability Index, and MIRR for each of these five pro 2. Based on NPV (and only NPV) answer these following questions: a) Which project(s) should you invest in if you have unlimited resource? b) Which project(s) should you invest in if you have (exactly and in total) $1,000 ? c) Which project(s) should you invest in if you have (exactly and in total) $2,000 ? d) Which project(s) should you invest in if you have (exactly and in total) $3,000 ? e) Which project(s) should you invest in if you have (exactly and in total) $4,000 ? 1. Find the NPV, IRR, Payback Period, Profitability Index, and MIRR for each of these five pro 2. Based on NPV (and only NPV) answer these following questions: a) Which project(s) should you invest in if you have unlimited resource? b) Which project(s) should you invest in if you have (exactly and in total) $1,000 ? c) Which project(s) should you invest in if you have (exactly and in total) $2,000 ? d) Which project(s) should you invest in if you have (exactly and in total) $3,000 ? e) Which project(s) should you invest in if you have (exactly and in total) $4,000