Excel Format Only:

4.2 Connect: Exercises and Problems i Saved 8 Calculating salvage value - Excel ? X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A A % 10 Paste BIU - BB - - A * Alignment Number Conditional Format as Cell Cells Editing Formatting * Table Styles points Clipboard G Font Styles Skipped A1 X V f A B C D E F G H J Book An asset used in a four-year project falls in the five-year MACRS class for tax Print 3 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? References Acquisition costs 6,500,000 Pretax salvage value 1,600,000 Tax rate 21% MACRS percentages Year 1 0.2000 11 Year 2 0.3200 12 Year 3 0.1920 13 Year 4 0. 1152 14 15 16 Complete the following analysis. Do not hard code values in your calculations. 17 18 Year 1 depreciation 19 Year 2 depreciation 20 Vnar 2 donroriation Sheet1 ... + READY + 100% Attempt(s) Hint4.2 Connect: Exercises and Problems i Saved FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 8 Calibri - 11 - A A % Paste BIU - Alignment Number Conditional Format as Cell Cells Editing Formatting * Table Styles Clipboard G Font Styles 10 A1 X v fx points A B C D E F G H Skipped 16 Complete the following analysis. Do not hard code values in your calculations. 17 18 Year 1 depreciation 19 Year 2 depreciation eBook 20 Year 3 depreciation 21 Year 4 depreciation 22 Accumulated depreciation Print 23 24 Book value n 25 References 26 Aftertax cash flow 27 Pretax salvage value 28 Taxes 29 Aftertax salvage value 30 31 32 33 Sheet1 (+ READY + 100% Attempt(s) Hint