please show all step. you can do with excel if needed. will thump up !!!!!

Question 1 6 pt 1 (30 points) Tiffany bought a piece of equivalent for $40,000. The equipment has a useful life of 5 years and a salvage value of $500 at the end of its useful life. Assume that the interest rate per year is 10% (a) (6 points) Calculate the depreciation for year 4, using DDB $3456 $3640 $3820 54070 D Question 2 8 pts (b) (8 pts) Calculate the present worth (PW) of the depreciation, using the DDB depreciation $29455 $30920 532115 0534100 Question 3 8 pts (d 18 pts) Calculate the present worth of the depreciation, using the straight line depreciation $27450 528.570 529.950 $31.00 Question 4 8 pts d) 8 pts) Calculate the present worth of the depreciation using the SOYD depreciation