use excel pls

) 145 - -)) o 2.Select the preferred alternative using ATCF Present Worth(PW) and using Incremental Analysis Method after removing the inflation (-2%) to obtain Real Dollars Tax rate 38% MARR -8% o Assume actual cash flows are in actual dollars (A$)(base=0) RS, - A$,(P/F, f.k-b) - AS, 1 1+ Depreciation method 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. (5000) AS A B C 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 10 10 10 Depreciation Taxable Macrs-GDS Income TAX 38'TI AS ATCF (1/(1+f))"k RS ATCF EOY[K] A$ BTCF 0 1-10 10 Usar ir para cmputo de PW en ATCF parte 2 1. 1+f En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCF-A ATCF-B ATCF-C AB-A) A(2-2) APWBA(MARR%)=??? ) 145 - -)) o 2.Select the preferred alternative using ATCF Present Worth(PW) and using Incremental Analysis Method after removing the inflation (-2%) to obtain Real Dollars Tax rate 38% MARR -8% o Assume actual cash flows are in actual dollars (A$)(base=0) RS, - A$,(P/F, f.k-b) - AS, 1 1+ Depreciation method 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. (5000) AS A B C 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 10 10 10 Depreciation Taxable Macrs-GDS Income TAX 38'TI AS ATCF (1/(1+f))"k RS ATCF EOY[K] A$ BTCF 0 1-10 10 Usar ir para cmputo de PW en ATCF parte 2 1. 1+f En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCF-A ATCF-B ATCF-C AB-A) A(2-2) APWBA(MARR%)=