To be answered in Excel:

I need number 8 solved as well. Thanks!

7. A company has just bought new manufacturing equipment: i. The acquisition price is $100,000 ii. The purchase was completed and the equipment was installed and launched on December 31st, 2020 iii. Its useful life is assumed to be 10 years iv. The equipment has no residual, or salvage value v. Depreciation calculations start one month after the acquisition (i.e., from January 2021) What is the remaining book value of the equipment at the end of September 2027 assuming the equipment is depreciated using the following methods: A. Straightline depreciation B. Double declining balance depreciation C. Sum-of-the-Years Digits depreciation 8. Recalculate the book value of the equipment at the end of September 2027 for each of the 3 depreciation methods, based on the following change (all other assumptions remain the same as above in #7). iv. The equipment has a residual value of $10,000