can you show steps use Npv formula in excel

1 x for 2 2 3 1,000 Q2. What is the net present value of a project that has an initial cash flow of $37,400 and e the following cash inflows? The required rate is 9.2 percent? Would you accept the projec 3. Why? 5 Year 1 61 72 Cash inflows $13,400 $20,100 83 19 4 $10,120 22 Q3. You are considering the following two mutually exclusive projects. The required rate of 23 return is 12.2 percent for project A and 11.5 percent for projcet B. Which project should be 24 accepted and why? 25 (Hint: Use NPV formula in excel) 26 27 Year Project A Project B ($54,000) ($54,000) 29 1 25,120 43,000 30 2 37,000 22,000 31 3 24,000 12,700 28 0 23 Unit 5 Problems Type here to search