Question: Hello! Can you please validate and provide rationale for the following: A B C D E 1 PROJECT CASH FLOWS 2 NPV METHOD Project A

Hello! Can you please validate and provide rationale for the following:

A B C D E 1 PROJECT CASH FLOWS 2 NPV METHOD Project A Project B 4 Discount rate 10% 10% 5 Initial Investment -10000 -55000 6 1st year return 5000 20000 7 2nd year return 5000 20000 8 3rd year return 5000 20000 9 NPV Function 2.212.96 (4.784.51) 10 71 Decision: Adopt Project A because it has a higher NPV 13 14 PAYBACK PERIOD METHOD 15 Project A: Initial investment = 10101010 16 Cumulative cash flows for project A 17 1st year 5000 18 2nd year 10000 19 Payback period for project A is 2 years 20 21 Project B: Initial investment = 55000 22 Cumulative cash flows for project B 23 1st year 20000 24 2nd year 40000 25 3rd year 60000 26 27 Payback period for project B: 28 29 2 years 1 month 30 31 Decision: Adopt project A because it has the shortest payback period
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
