Raytheon wishes to use an automated environmental chamber in the manufacture of electronic components. The chamber is to be used for rigorous reliability testing and burn-in. It is installed for $1,360,000 and will have a salvage value of $180,000 after 8 years. Its use will create an opportunity to increase sales by $650,000 per year and will have operating expenses of $250,000 per year. All dollar amounts are expressed in real dollars. Depreciation follows MACRS 5-year property, taxes are 25%, the real after-tax MARR is 10%, and inflation is 3.6%.

1. Determine the actual after-tax cash flows for each year. ATCF₀ = $enter a dollar amount ATCF₁ = $enter a dollar amount ATCF₂ = $enter a dollar amount ATCF₃ = $enter a dollar amount ATCF₄ = $enter a dollar amount ATCF₅ = $enter a dollar amount ATCF₆ = $enter a dollar amount ATCF₇ = $enter a dollar amount ATCF₈ = $enter a dollar amount
2. Determine the PW of the after-tax cash flows. PW_$T = $enter a dollar amount
3. Determine the AW of the after-tax cash flows. AW_$T = $enter a dollar amount
4. Determine the FW of the after-tax cash flows. FW_$T = $enter a dollar amount
5. Determine the combined IRR of the after-tax cash flows. IRR_c = enter percentages %
6. Determine the combined ERR of the after-tax cash flows. ERR_c = enter percentages %
7. Determine the real IRR of the after-tax cash flows. IRR_r = enter percentages %
8. Determine the real ERR of the after-tax cash flows. ERR_r = enter percentages %

It would be appreciated if it was done on Excel but it's okay if it isn't.

Raytheon wishes to use an automated environmental chamber in the manufacture of electronic components. The chamber is to be used for rigorous reliability testing and burn-in. It is installed for $1.360.000 and will have a selvage value of $180,000 after 8 years. Its use will create an opportunity to increase sales by $650,000 per year and will have operating expenses of $250.000 per year. All dollar amounts are expressed in real dollars. Depreciation follows MACRS 5-year property, taxes are 25%, the real after-tax MARR is 10%, and inflation is 3.6%. a. Determine the actual after-tax cash flows for each year. ATCFo= $ ATCF1 = $ ATCF2 = $ ATCF, = $ ATCF= $ ATCF5= $ ATCF = $ ATCF7 = $ ATCF9 = $ b. Determine the PW of the after-tax cash flows. PWST = $ c Determine the AW of the after-tax cash flows. AWST = $ d. Determine the FW of the after-tax cash flows. FWST = $ e. Determine the combined IRR of the after-tax cash flows. IRR = % f. Determine the combined ERR of the after-tax cash flows. ERR = % 3. Determine the real IRR of the after-tax cash flows. IRR, h. Determine the real ERR of the after-tax cash flows. ERR = 96 Raytheon wishes to use an automated environmental chamber in the manufacture of electronic components. The chamber is to be used for rigorous reliability testing and burn-in. It is installed for $1.360.000 and will have a selvage value of $180,000 after 8 years. Its use will create an opportunity to increase sales by $650,000 per year and will have operating expenses of $250.000 per year. All dollar amounts are expressed in real dollars. Depreciation follows MACRS 5-year property, taxes are 25%, the real after-tax MARR is 10%, and inflation is 3.6%. a. Determine the actual after-tax cash flows for each year. ATCFo= $ ATCF1 = $ ATCF2 = $ ATCF, = $ ATCF= $ ATCF5= $ ATCF = $ ATCF7 = $ ATCF9 = $ b. Determine the PW of the after-tax cash flows. PWST = $ c Determine the AW of the after-tax cash flows. AWST = $ d. Determine the FW of the after-tax cash flows. FWST = $ e. Determine the combined IRR of the after-tax cash flows. IRR = % f. Determine the combined ERR of the after-tax cash flows. ERR = % 3. Determine the real IRR of the after-tax cash flows. IRR, h. Determine the real ERR of the after-tax cash flows. ERR = 96