USING MICROSOFT EXCEL PROGRAM STEP BY STEP (SHOW HOW PUT IN THE PROGRAM)

AADIR INFLACION (R$ a A$) ATCF in A$ 1. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method. After recognition of Inflation ( 13%). Tax rate 40% MARR 10% Assume actual cash flows are in real dollars (R$) )(base=0) AS, - R$, (FIPS.4-b) - RS, (I+D Depreciation method a For Alt-A Straight-Line (SL) Method (Classical Method) SL-Investment-SV)/N b. For Alt-B MACRS GDS 5 years recovery period. For AR-C MACRS-ADS 5 years recovery period. Find the ATCF for the alternatives using A$ cash flows them evaluate all alteratives on ATCF using Incremental analysis PW. C. (5000) R$ Capital Investment Annual Expenses Annual Revenues Market Value (MV or SV)) Useful life A B $10,000 $15,000 $20,000 9,000 5,000 3,000 10,000 6,000 4,000 1,000 1,000 2,000 8 8 8 (1+r)^k Inflation A$. BTCF Depreciation Taxable Macrs-GDS Income TAX - 40'TI A$ ATCF EOY[K] R$ BTCF 0 1-8 8 Search REMOVER INFLACION (A$ a R$) ATCF in R$ 2.Select the preferred alterative using ATCF Present Worthw) and using incremental Analysis Method after removing the Inflation (2%) to obtain Real Dollars. Tx38% MARR-3% Assume actual cash flows in actual delas (AS)(base) RS, AS (P/FJ.:-)) = 45, 1 1+/ Depreciation method For AIBA Straight Line (SL) Method (Classical Method) Scievestment BV) IN For A B MACRS GOS 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 alamatives on ATC using Incremental analysis PW. (5000) AS A B C Capital Investment $20,000 $25,000 $40,000 Annual Expenses 10,000 5.000 Annual Revenues 12.000 6.000 Market Value MV or SV) 2.000 2,000 5,000 Useful life 10 10 10 2.000 8,000 TAX EOYIKAS Depreciation Taxable AS (1/40 RS BTCF Maars-GDS Income - 38'TI ATCF ATCH 0 1-10 10 Usar para computo de PW en ATCF part 2 panda 1+1 En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCFA ATCF-B ATCF-C ABA A2-2) 12-1 APWA(MARR%)=??? 1 AADIR INFLACION (R$ a A$) ATCF in A$ 1. Select the preferred alternative using ATCF-Present-Worth(PW) and using Incremental Analysis Method. After recognition of Inflation ( 13%). Tax rate 40% MARR 10% Assume actual cash flows are in real dollars (R$) )(base=0) AS, - R$, (FIPS.4-b) - RS, (I+D Depreciation method a For Alt-A Straight-Line (SL) Method (Classical Method) SL-Investment-SV)/N b. For Alt-B MACRS GDS 5 years recovery period. For AR-C MACRS-ADS 5 years recovery period. Find the ATCF for the alternatives using A$ cash flows them evaluate all alteratives on ATCF using Incremental analysis PW. C. (5000) R$ Capital Investment Annual Expenses Annual Revenues Market Value (MV or SV)) Useful life A B $10,000 $15,000 $20,000 9,000 5,000 3,000 10,000 6,000 4,000 1,000 1,000 2,000 8 8 8 (1+r)^k Inflation A$. BTCF Depreciation Taxable Macrs-GDS Income TAX - 40'TI A$ ATCF EOY[K] R$ BTCF 0 1-8 8 Search REMOVER INFLACION (A$ a R$) ATCF in R$ 2.Select the preferred alterative using ATCF Present Worthw) and using incremental Analysis Method after removing the Inflation (2%) to obtain Real Dollars. Tx38% MARR-3% Assume actual cash flows in actual delas (AS)(base) RS, AS (P/FJ.:-)) = 45, 1 1+/ Depreciation method For AIBA Straight Line (SL) Method (Classical Method) Scievestment BV) IN For A B MACRS GOS 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 alamatives on ATC using Incremental analysis PW. (5000) AS A B C Capital Investment $20,000 $25,000 $40,000 Annual Expenses 10,000 5.000 Annual Revenues 12.000 6.000 Market Value MV or SV) 2.000 2,000 5,000 Useful life 10 10 10 2.000 8,000 TAX EOYIKAS Depreciation Taxable AS (1/40 RS BTCF Maars-GDS Income - 38'TI ATCF ATCH 0 1-10 10 Usar para computo de PW en ATCF part 2 panda 1+1 En ambos casos se requiere INCREMENTAL ANALYSIS ATCF Incremental Analysis ATCFA ATCF-B ATCF-C ABA A2-2) 12-1 APWA(MARR%)=??? 1