please help with excel step-by-step (detailed) much appreciated **IMPORTANT** PLEASE MAKE SURE TO USE EXCEL WITH FORMULAS

The cash flows and Net salvage value of Project X are given the following table:

Year	Cash flows	Salvage Value
0	-5,800	4,800
1	2,100	3,000
2	3,400	2,200
3	3,600	1,800
4	1,800	0

Based on the Economic Life of this project and the cost of capital is 12%, in what year should you abandon this Project X?

• A. Year 3, since NPV in year 3 = $2,629
• B. Year 4, since NPV in year 4 = $2,892
• C. Year 1, since NPV in year 1 = $1,246
• D. Year 3, since NPV in year 3 = $8,429
• E. Year 4, since NPV in year 4 = $2,491

PLEASE HELP WITH EXCEL STEP-BY-STEP (IN FULL detail) much appreciated **IMPORTANT** I WANT TO LEARN