This homework is designed to provide a brief understanding about using MS Excel and calculating depreciation Complete the homework and upload it on webcourse. Jan 1, 2016. AAA Purchased an equipment (Cost: $20,000, salvage value: $2,000, useful life 5 years) What is the amount of depreciable cost? Suppose that you are using straight line method to calculate depreciation expense. What is the depreciation rate? 1. Complete the table based on stright-line method to calculate depreciation. 2. Complete the table based on double declining balance method. 3. Complete the table based on sum of year's digit method \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Year } & \multicolumn{2}{|l|}{ Computation } & \multirow[b]{2}{*}{=} & \multicolumn{3}{|c|}{ End of Year } \\ \hline & x & Rate & & \begin{tabular}{r} Annual \\ Depreciation \\ Expense \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & Book Value \\ \hline 1 & x & & = & & 23 & \\ \hline 2 & x & & = & & & \\ \hline 3 & x & & = & & & \\ \hline 4 & x & & = & & & \\ \hline 5 & x & & = & & & \\ \hline \end{tabular}