Solve Using Excel please show all formulas in cells

Problem 2: A machine that was purchased for $47,000 has an estimated useful life of seven years and a scrap value of $5,000. Use the straight line method to find the depreciation charge per year, then build a table to show the net book value each year over the life of the machine. Make the table similar to that of problem 1 (insert rows below to fit)