1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation: 7 Sucation.com/ext/map/index.html?_con=con\&external_browser=08launchUrl=https\%253A\% 252F%252Flm.mheducation.com\% ers 912 Saved SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ End of year amounts } \\ \hline Year & Depreciation Expense & Accumulated Depreciation & Book Value \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline Total & & & \\ \hline s-of-Production depreciationschedule by entering formulas. \end{tabular} Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. \begin{tabular}{|l|l|} \hline 28 \\ \hline 29 & \\ 30 \\ 31 & \\ 32 \\ 33 \\ 34 \\ 35 \\ 36 \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ SULLIVAN RANCH CORPORATION } \\ \hline \multicolumn{4}{|c|}{ Depreciation Schedule-Units-of-Production Method } \\ \hline Year & Depreciation Expense & Accumulated Depreciation & Book Value \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline Total & & & \\ \hline \end{tabular} Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation: 7 Sucation.com/ext/map/index.html?_con=con\&external_browser=08launchUrl=https\%253A\% 252F%252Flm.mheducation.com\% ers 912 Saved SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ End of year amounts } \\ \hline Year & Depreciation Expense & Accumulated Depreciation & Book Value \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline Total & & & \\ \hline s-of-Production depreciationschedule by entering formulas. \end{tabular} Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. \begin{tabular}{|l|l|} \hline 28 \\ \hline 29 & \\ 30 \\ 31 & \\ 32 \\ 33 \\ 34 \\ 35 \\ 36 \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ SULLIVAN RANCH CORPORATION } \\ \hline \multicolumn{4}{|c|}{ Depreciation Schedule-Units-of-Production Method } \\ \hline Year & Depreciation Expense & Accumulated Depreciation & Book Value \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline Total & & & \\ \hline \end{tabular} Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells