Prepare the following problems in Excel and ensure the formulas are present in the appropriate cells:
Allen Air Lines must liquidate some equipment that iis being replaced. The equipment originally cost $12 million, of which 75% has been depreciated. The used equipment can be sold for $4 million, and tax rate is 40%. What is the equipment's after tax net salvage value?