in excel

2. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method after removing the inflution v-2%) to obtain Real Dollars.. Tax rate 38% MARR = 8% a Assume actual cash flows are in actual dollars (AS) (base=0) RS, = AS (P/F.S.k-b) = A$, 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. 0 Find the ATCF for the alternatives using RS cash flows, them evaluate all alternatives on ATCF using incremental analysis PW. (5000) AS A B Capital Investment $20,000 $25,000 S40,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 AS Usar i para cmputo de PW en ATCF parte 2 I is 1+1 EOY[k] AS- Depreciation Taxable TAX- (1/(1+Yk RS 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) AC-2) APWA(MARR%)-??? E w 16 REMOVER INFLACION (AS a RS) ATCF in RS o o 2. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method after removing the inflation V-) to obtain Real Dollars.. Tax rate 38% MARR -8% Assume actual cash flows.ace.in actual dollars.(A))(base-0) R$, = AS (P/F,/,k - b) = A$, 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. o For Alt-C MACRS-ADS 7 years recovery period. a Find the ATCF for the alternatives using RS cash flows them evaluate all alternatives on ATCF using incremental analysis PW. (5000) AS B 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 Useful life 10 10 10 5,000 Usar para computo de PW en ATCF parte 2 I I+ EOYTK] AS- Depreciation Taxable TAX- AS (1/(1+0) * RS BTCE Macrs-GDS Income -38TI ATCF ATCP 0 1-10 10 En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCF-A ATCE-B ATCF-C AB-A) AC-?) APWA(MARR%)