Question: Question 1 - Facebook is evaluating a virtual reality project with the following cash flows. Your task is to calculate the NPV, IRR, and profitability

Question 1 - Facebook is evaluating a virtual reality project with the following cash flows. Your task is to calculate the NPV, IRR, and profitability index for the project. After each calculation, use the information given to make an 'Accept' or 'Reject' decision. You must use an IF' statement in your Accept/Reject formula. (20 points) Required Return 18.5% t Cash flow 0 $ (5,000,000.00) 450,000.00 1 2 650,000.00 3 $ $ $ $ $ 4 1,700,000.00 2,000,000.00 2,500,000.00 2,500,000.00 5 6 NPV Calculation Net present value: Accept or Reject? IRR Calculation Internal rate of return Accept or Reject? Pl Calculation Profitability Index Accept or Reject? What is the final decision for Facebook? Should they accept the project? Pick from the drop down menu below. Overall Final Decision
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
