I need to answer to these questions by using Excel FUNCTIONS

Randy Company bought a machine for $7,000. Its estimated life is 5 years. The residual value of the machine is $500. Calculate the (a) annual depreciation and (b) book value at the end of year 3. Assume a straight-line depreciation.

Using problem 1, calculate the first two years depreciation assuming the units-of-production method is used. This machine is expected to produce 50,000 units. In year 1 it produced 18,000 units, and in year 2, 14,000 units were produced.

Using problem 1, calculate the first two years depreciation expense, assuming Randy uses the declining-balance method at twice the straight-line rate.

For tax purposes in problem 1, Randy has requested his accountant to calculate what his depreciation expense will be for his class 5 piece of machinery over the first 3 years using MACRS