MUST BE DONE MANUALLY NOT WITH EXCEL

7.For the following table assume a MARR of 6% per year, and a useful life for each alternative of six years. Which equals the study period. The rank order of alternatives from least capital to greatest capital investment is A, C, B. Complete the PW-Incremental Analysis by selecting the preferred alternative. (5ptos) $15,000 4,000 1,000 6,000 $3,982 A Capital Investment A Annual Revenues Annual Cost A Market Value APW A(C-A) A(B-C) $2,000 $3,000 900 460 150 100 -2,200 3,350 $137 a 7.For the following table assume a MARR of 6% per year, and a useful life for each alternative of six years. Which equals the study period. The rank order of alternatives from least capital to greatest capital investment is A, C, B. Complete the PW-Incremental Analysis by selecting the preferred alternative. (5ptos) $15,000 4,000 1,000 6,000 $3,982 A Capital Investment A Annual Revenues Annual Cost A Market Value APW A(C-A) A(B-C) $2,000 $3,000 900 460 150 100 -2,200 3,350 $137 a