Company purchases a new punch press at a cost of $265,000. Delivery and installation cost $46,000. The machine has a useful life of 12-years, but will depreciate using MACRS over a seven year property class,

1. What is the cost basis of the machine

2. What will be the depreciation allowance each year over the seven years

3. If we sell the machine at the end of five years for $70,000, what will be the gain/loss tax assuming a 40% tax rate

4. What are the net-proceeds from the sale

Calculate and show all in Excel.