Evaluate alternatives D1, D2 and D3 based on PW, AW, B/C ratio, IRR, incremental B/C ratio and Incremental rate of return analysis (MARR = 15%)

4. (40 points - Spreadsheet) Evaluate alternatives D1, D2 and D3 based on PW, AW, B/C ratio, IRR, incremental B/C ratio and Incremental rate of return analysis (MARR = 15%) D2 1000 800 500 500 D3 3000 1500 2000 1000 Il D1 2000 1500 1000 800 0 NPC NPB EUAC EUAB B/C Ratio IRR Solve this problem using spreadsheets