excel formulas only please no hard value

D B F H Consider an asset that costs $730,000 and is depreciated straight-line to zero over its eight-year tax life. The asset is to be used in a five-year project; at the end of the project, the asset can be sold for $192,000. If the relevant tax rate is 23 percent, what is the aftertax cash flow from the sale of this asset? Costs $ 730,000 192,000 $ Pretax salvage value Tax rate 23% Years for depreciation 8 Year asset is sold 5 Complete the following analysis. Do not hard code values in your calculations. Annual depreciation Accumulated depreciation Book value Aftertax cash flow B Font Sty X fx C D F Pretax salvage value $ 192,000 Tax rate 23% Years for depreciation 8 Year asset is sold 5 Complete the following analysis. Do not hard code Annual depreciation Accumulated depreciation Book value Aftertax cash flow Pretax salvage value Taxes Aftertax salvage value E D B F H Consider an asset that costs $730,000 and is depreciated straight-line to zero over its eight-year tax life. The asset is to be used in a five-year project; at the end of the project, the asset can be sold for $192,000. If the relevant tax rate is 23 percent, what is the aftertax cash flow from the sale of this asset? Costs $ 730,000 192,000 $ Pretax salvage value Tax rate 23% Years for depreciation 8 Year asset is sold 5 Complete the following analysis. Do not hard code values in your calculations. Annual depreciation Accumulated depreciation Book value Aftertax cash flow B Font Sty X fx C D F Pretax salvage value $ 192,000 Tax rate 23% Years for depreciation 8 Year asset is sold 5 Complete the following analysis. Do not hard code Annual depreciation Accumulated depreciation Book value Aftertax cash flow Pretax salvage value Taxes Aftertax salvage value E