Complete the Excel spreadsheet (above) and select which project best meets the MARR. Is it Technology A, B, or C?

0.1 = MARR IRR 17% WN Project Selection Based on Economic Analysis Technology "A" Year Cost Income Net NPV 0 $650,000 $0 -$650,000 $148,621 1 $0 $125,000 $125,000 2 $0 $175,000 $175,000 3 $275,000 $300,000 $25,000 4 $0 $400,000 $400,000 5 $200,000 $200,000 $400,000 1 2 Technology "B" 3 Year Cost Income Net NPV 4 $750,000 $0 5 1 $0 $175,000 3 2 $0 $200,000 7 3 -$370,000 $225,000 3 4 $0 $375,000 3 5 $300,000 $350,000 IRR O Net NPV IRR $808,300 $0 $0 $265,000 $0 $202,000 Income $0 $200,000 $225,000 $250,000 $400,000 $325,000 5% 1 Technology "C" 2 Year Cost 3 0 4 1 5 2 5 3 7 4 3 5 3 Increment B-A 1 Year Cost 2 0 3 1 2 5 3 3 4 7 5 3 Increment C-A Year Cost 1 0 2 1 3 2 3 5 4 3 5 7 $100,000 $0 $0 -$95,000 $0 $100,000 Income Net NPV IRR $0 $100,000 $23,453 $50,000 $50,000 $25,000 $25,000 $75,000 $ 170,000 -$25,000 $25,000 $150,000 $250,000 Net NPV IRR $ 158,300 $0 $0 $10,000 $0 $2,000 Income $0 $75,000 $50,000 -$50,000 $0 $125,000