Create on Excel

REMOVER INFLACION (AS R$) ATCF in R$ a 2.Select the preferred alternative using ATCF-Present-Worth (PW) Using Incremental analysis Method after removing the inflation. (f= 2 % ) to obtain Real Dollars.. Tax rate 40 % MARR ATCF 10 % Assume actual cash flows are in actual dollars (AS) (base - 0) RS, -(e-e) AS, (P/F, f,k- b) = AS, (; 1+f Depreciation method: For Alt-A Straight-Line (SL) Method (Classical Method) SL (Investment-SV) / N For Alt-B MACRS GDS 5 years recovery period. For Alt-C MACRS-ADS 5 years recovery period. d. e. f. Find the ATCF for the alternatives using R$ cash flows, them evaluate all alternatives on ATCF using incremental analysis PW ($000) AS Capital Investment Annual Expenses $19 6 C $15 $25 8 4 10 6 7 Annual Revenues Market Value (MV or SV)) Useful life 2 3 10 10 10 (1/(1+f)k RS ATCF Depreciation Taxable Income TAX= AS 40*TI ATCF EOY(K] AS- F C 1-10 10 i, 1+ f Usar i, para cmputo de PW en ATCF parte: En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis A(B-A) A-7 ATCF-C ATCF-B ATCF-A APWA(10%)=??? oN ASs REMOVER INFLACION (AS R$) ATCF in R$ a 2.Select the preferred alternative using ATCF-Present-Worth (PW) Using Incremental analysis Method after removing the inflation. (f= 2 % ) to obtain Real Dollars.. Tax rate 40 % MARR ATCF 10 % Assume actual cash flows are in actual dollars (AS) (base - 0) RS, -(e-e) AS, (P/F, f,k- b) = AS, (; 1+f Depreciation method: For Alt-A Straight-Line (SL) Method (Classical Method) SL (Investment-SV) / N For Alt-B MACRS GDS 5 years recovery period. For Alt-C MACRS-ADS 5 years recovery period. d. e. f. Find the ATCF for the alternatives using R$ cash flows, them evaluate all alternatives on ATCF using incremental analysis PW ($000) AS Capital Investment Annual Expenses $19 6 C $15 $25 8 4 10 6 7 Annual Revenues Market Value (MV or SV)) Useful life 2 3 10 10 10 (1/(1+f)k RS ATCF Depreciation Taxable Income TAX= AS 40*TI ATCF EOY(K] AS- F C 1-10 10 i, 1+ f Usar i, para cmputo de PW en ATCF parte: En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis A(B-A) A-7 ATCF-C ATCF-B ATCF-A APWA(10%)=??? oN ASs