A set of office equipment costs $200,000 and has a useful life of 8 years. Its estimated market value at the end of the 8^th year is $10,000. Determine the depreciation amount on the 3^rd year and the book value at the end of the 4^th year using:

a. Straight Line Method

b. Double Declining Balance Method

c. Sum-of-Years Digits Method

d. Declining Balance Method with Switchover to SL

e. MACRS GDS (assume that the assets will be disposed of on the 4^th year)

excel solution is okay!! pls answer all of them thank you!