The question is required to be done in Excel. So if it cannot be done in Excel initially, then if it can be done manually the same way as on Excel that would work too.

2. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method after removing the inflation. r-2%) to obtain Real Dollars.. Tax rate 40% MARR = 8% o Assume actual cash flows are in actual dollars (AS) (base-0) R$. = A$:(P/F,f,k - b) = A$, '1+f Depreciation method o For Alt-A Straight-Line (SL) Method (Classical Method) SL=(Investment-SV)/N For Alt-B MACRS GDS 7 years recovery period. For Alt-C MACRS-ADS 7 years recovery period. Find the ATCF for the alternatives using R$ cash flows, them evaluate all alternatives on ATCF using incremental analysis PW. AS Capital Investment $20,000 $25,000 $40,000 Annual Expenses 10,000 5,000 2,000 Annual Revenues 12.000 8,000 6,000 Market Value (MV or SV)) 2,000 2,000 5,000 Useful life A B 10 10 10 Usar i, para computo de PW en ATCF parte 2 1-f recodar i marr 1+1 EOY[k] AS- Depreciation Taxable TAX AS (1/(1+1) R$ BTCF Macrs-GDS Income - 38TI ATCF ATCF 0 1-10 10 En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCF-A ATCF-B ATCF-C A(B-A) A-?) APWB-A(MARR%)?!? 2. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method after removing the inflation. r-2%) to obtain Real Dollars.. Tax rate 40% MARR = 8% o Assume actual cash flows are in actual dollars (AS) (base-0) R$. = A$:(P/F,f,k - b) = A$, '1+f Depreciation method o For Alt-A Straight-Line (SL) Method (Classical Method) SL=(Investment-SV)/N For Alt-B MACRS GDS 7 years recovery period. For Alt-C MACRS-ADS 7 years recovery period. Find the ATCF for the alternatives using R$ cash flows, them evaluate all alternatives on ATCF using incremental analysis PW. AS Capital Investment $20,000 $25,000 $40,000 Annual Expenses 10,000 5,000 2,000 Annual Revenues 12.000 8,000 6,000 Market Value (MV or SV)) 2,000 2,000 5,000 Useful life A B 10 10 10 Usar i, para computo de PW en ATCF parte 2 1-f recodar i marr 1+1 EOY[k] AS- Depreciation Taxable TAX AS (1/(1+1) R$ BTCF Macrs-GDS Income - 38TI ATCF ATCF 0 1-10 10 En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCF-A ATCF-B ATCF-C A(B-A) A-?) APWB-A(MARR%)