12 On the Depreciation worksheet, in cell B7, use the straight-line depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references. Copy the function down through B13. 13 In cells C7:C13, calculate the accumulated depreciation value for each year. In cell C7, reference the current year's Depreciation Expense. In cell C8, add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through C13. 14 In cells D7:D13, calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied. Copy the formula down through D13 15 In cell G7, use the declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute references where appropriate. Copy the function down through G13. Step Instructions Possible 16 In cell G18, use the double declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references where appropriate. Copy the function down through G24. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Double Declining Balance Depreciation schedule } \\ \hline & YearlyDepreciationExpense & AccumulatedDepreciation & \\ \hline 1 & & $0.00 & $00k Value \\ \hline 2 & & $0.00 & $100,000 \\ \hline 3 & $0.00 & $100,000 \\ \hline 4 & $0.00 & $100,000 \\ \hline 5 & $0.00 & $100,000 \\ \hline 6 & & $0.00 & $100,000 \\ \hline 7 & & $100,000 \\ \hline \end{tabular} 12 On the Depreciation worksheet, in cell B7, use the straight-line depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references. Copy the function down through B13. 13 In cells C7:C13, calculate the accumulated depreciation value for each year. In cell C7, reference the current year's Depreciation Expense. In cell C8, add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through C13. 14 In cells D7:D13, calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied. Copy the formula down through D13 15 In cell G7, use the declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute references where appropriate. Copy the function down through G13. Step Instructions Possible 16 In cell G18, use the double declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references where appropriate. Copy the function down through G24. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Double Declining Balance Depreciation schedule } \\ \hline & YearlyDepreciationExpense & AccumulatedDepreciation & \\ \hline 1 & & $0.00 & $00k Value \\ \hline 2 & & $0.00 & $100,000 \\ \hline 3 & $0.00 & $100,000 \\ \hline 4 & $0.00 & $100,000 \\ \hline 5 & $0.00 & $100,000 \\ \hline 6 & & $0.00 & $100,000 \\ \hline 7 & & $100,000 \\ \hline \end{tabular}