please provide excel formulas/steps referring to the cell numbers (B4,B5,B6...) for each answer according to the instructions given.

For example, please include absolute cell references when appropriate

1 Sullivan Ranch Corporation has purchased a new tractor. The following information is giver: 3 Cost: 4 Estimated Residual: 5 Estimated Lif : 6 Estimated Life in hours: 7 Actual Hours: 8 Year 1 9 Year 2 10 Year 3 11Year 4 12 $ 150,000 $ 10,000 e in years 4 1200 360 270 350 220