PLEASE WRITE ALL ANSWERS IN EXCEL FORMAT. NO VALUES! THANK YOU

Pulatiny Table Styles Clipboard Font Styles A1 points An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $6,500,000 and will be sold for $1,600,000 at the end of the project. If the tax rate is 21 percent, what is the aftertax salvage value of the asset? eBook S 6,500,000 1,600,000 21% Print Acquisition costs Pretax salvage value Tax rate MACRS percentages Year 1 Year 2 Year 3 Year 4 References 0.2000 0.3200 0.1920 0.1152 Complete the following analysis. Do not hard code values in your calculations. Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation Accumulated depreciation Sheet1 ... + M U -- + 100% READY Attempt(s) Hint D18 Year 1 Year 2 Year 3 Year 4 0.2000 0.3200 0.1920 0.1152 points Complete the following analysis. Do not hard code values in your calculations. eBook Print Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation Accumulated depreciation References Book value Aftertax cash flow Pretax salvage value Taxes Aftertax salvage value ... Sheet1 ... + @ 0 -- H + 100% READY Attempt(s) 3/3 Hint