must be in formula format

A B D E F G H J 3 3 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? 4 5 6 7 $ $ 6,500,000 1,600,000 21% 8 9 10 11 Acquisition costs Pretax salvage value Tax rate MACRS percentages Year 1 Year 2 Year 3 Year 4 12 13 0.2000 0.3200 0.1920 0.1152 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 18 19 20 21 Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation Accumulated depreciation Sheet1 22 READY Clipboard Font 1 Styles A1 > fx A B D E F G H 1 J 8 21% 9 10 Tax rate MACRS percentages Year 1 Year 2 Year 3 Year 4 11 12 0.2000 0.3200 0.1920 0.1152 13 14 15 16 Complete the following analysis. Do not hard code values in your calculations. 17 18 19 20 Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation Accumulated depreciation 21 22 23 24 25 26 Book value 27 28 Aftertax cash flow Pretax salvage value Taxes Aftertax salvage value 29 30 4 Sheet1 READY COM