This question is to develop a depreciation table based on two methods of depreciation for a piece of equipment. You can either prepare this in Excel or manually and can either show one or two tables. The required column headings, in this order, are 1)Year (for both if you split into two tables), 2)SL Annual Depreciation Base, 3)SL Depreciation Annual Rate, 4)SL Annual Depreciation Expense, 5)SL Annual Cumulative Depreciation Expense, 6)SL Annual Book Value Year End, 7)DB(1.5) Depreciation Annual Rate, 8)DB(1.5) Annual Depreciation Base, 9)DB(1.5) Annual Depreciation Expense, 10)DB(1.5) Annual Cumulative Depreciation Expense, 11)DB(1.5) Annual Book Value Year End. The two depreciation methods are Straight Line (SL) and Declining Balance with a 1.5 factor on the SL rate. The piece of equipment has a Purchase Cost of $500,000, a Salvage Value of $50,000 and a Service Life of 6 years. If you split into two tables, then each table should have 6 columns. If you combine the two methods into one table, then you should have 11 columns. The Annual Depreciation Rate columns should show % values to 2 decimal places. All other data should be shown to 0 decimal places. Also, note the difference in Salvage Value at the end of Year 6 between the two methods.