Calculating aftertax salvage value - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 36 Arial -12 -A A 9 Paste BIU- 49 Cells Ed Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D19 X A B D E F G H 4 5 6 A Costs Pretax salvage value Tax rate Years for depreciation Year asset is sold 730,000 192,000 23% 8 5 7 8 9 10 11 12 13 14 15 16 17 18 Complete the following analysis. Do not hard code values in your calcula Annual depreciation $ 91,250 Accumulated depreciations 456,250 19 Book value 20 21 22 23 24 25 26 Aftertax cash flow Pretax salvage value Taxes Aftertax salvage value Sheet1 READY