Please give the excel formulas for each answer

2 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight-Line Method End of year amounts Depreciation Accumulated \begin{tabular}{|c|cccc|} \hline 23 & Year & Expense & Depreciation & Book Value \\ \hline 24 & 1 & & $0 & \\ 25 & 2 & r & & \\ 26 & 3 & & & \\ 27 & 4 & & \\ 28 & Total & & \\ \hline 29 & & & \end{tabular} SULLIVAN RANCH CORPORATION Depreciation Schedule-Activity Based Method End of year amounts Depreciation Accumulated \begin{tabular}{cccc|} Year & Expense & Depreciation & Book Value \\ \hline 1 & & & \end{tabular} SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Depreciation Accumulated 52 53 54 55 57 \begin{tabular}{c} Year \\ \hline 1 \\ \hline 2 \\ 3 \\ \hline 4 \end{tabular} Total