Using the spreadsheet functions construct the depreciation schedules for Problem 12.5 using the…

Using the spreadsheet functions construct the depreciation schedules for Problem 12.5 using the following methods: (a) Straight-line. (b) Double-declining balance. (c) SOYD. (d) MACRS (ADR = 8 years).