it is not option D. must be done in Excel, please show your work.

Question 4 0720 pts Due to regulatory standards, your company must select an environmentally friendly project. Otherwise, your company will incur a $50,000 fine (in Year O). Your company is considering two independent projects. Which project should be selected? Project A Initial Investment Annual Cost none $90,000 $30,000 5% $55,000 5% MARR Life 10 years 10 Project B Initial Investment Annual Cost MARR Life Savings (Great- 10%) Savings. (Most Likely 65%) Savings (Pessimistic 25%) $60,000 Savings per year (Great - 25%) Savings per year (Most Likely 50%) Savings per year (Pessimistic 25%) $60,000 $40,000 $50,000 $10,000 $30,000 Project A Project B Both Project A and B Neither Project A or B