Question: Please answer the following questions on excel step by step I will not pay another penny to someone else other than chegg. and will report


1. You want to start a new project that will require an initial investment of USD 3000 and then will continue for 10 years with following cash flows. Your required return is 25% and you want to recover your investment within 4 years. Calculate Payback Period, NPV, IRR, and Profitability Index and recommend whether you should invest or not. Give your justifications. 2. You have two investment options A and B with the following cash flows. Your required return is 10%, Evaluate these two projects using IRR, NPV, and PI and give your investment recommendations. Justify your answer. 3. You have 5000 to invest and you want to recover your money within 4 years. Your cost of capital is 12%. You have following investment opportunties that have same risk. Which one you will choose and why? Give your reasoning for each opportunity that you eliminate. 1. You want to start a new project that will require an initial investment of USD 3000 and then will continue for 10 years with following cash flows. Your required return is 25% and you want to recover your investment within 4 years. Calculate Payback Period, NPV, IRR, and Profitability Index and recommend whether you should invest or not. Give your justifications. 2. You have two investment options A and B with the following cash flows. Your required return is 10%, Evaluate these two projects using IRR, NPV, and PI and give your investment recommendations. Justify your answer. 3. You have 5000 to invest and you want to recover your money within 4 years. Your cost of capital is 12%. You have following investment opportunties that have same risk. Which one you will choose and why? Give your reasoning for each opportunity that you eliminate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
