1) A new excavator was purchased by a construction company for $350,000 with an estimated cash flow before taxes (BTC) as illustrated below. The asset is depreciated using a SOYD depreciation method to a salvage value estimated to be $125,000 after the 5-year recovery period. At the end of year 5, however, the excavator was actually sold for $200,000. The construction company is subject to a corporate tax rate of 35% and a 20% capital gain tax. Calculate the after tax cash flow (ATCF) for this investment and fill out all missing values in the table below. Show your work for all steps. 1 BTCF Depreciation D Taxable Income Taxes ATCF 0 - $350k 1 +$95k 2 +S80K 3 +$65k 4 +$50K 5 +$35k 5