Net present value: Independent projects Using a 10% cost of capital, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. Table:

Cash Flows in thousands

YEAR 0 A = -250000 B = -375000 C = -550000 D = -750000 E = -1150000

YEAR 1 A = 50000 B = 45000 C = 350000 D = 200000 E = 80000

YEAR 2 A = 90000 B = 55000 C = 210000 D = 235000 E = 135000

YEAR 3 A = 140000 B = 65000 C = 165000 D = 250000 E = 190000

YEAR 4 A = 80000 B = 55000 C = 55000 D = 265000 E = 255000

YEAR 5 A = 0 B = 45000 C = 45000 D = 100000 E = 315000

YEAR 6 A = 0 B = 35000 C = 10000 D = 50000 E = 380000

YEAR 7 A = 0 B = 25000 C = 0 D = 0 E = 275000

YEAR 8 A = 0 B = 15000 C = 0 D = 0 E = 100000

YEAR 9 A = 0 B = 5000 C = 0 D = 0 E = 45000

YEAR 10 A = 0 B = 0 C = 0 D = 0 E = 25000

Could you please work the problem in excel format? If not, that is okay. I appreciate the help!