S23Depreciation Home Insert Draw Page Layout Formulas Data Review View Q Tell me S23Depreciation Methods Home Insert Draw Page Layout Formulas Data Review View & Tell me Do not depreciate below estimated salvage value! Be sure to use formulas or cell references through out your table! Units of Production - Check Figures \begin{tabular}{lll|} \hline Inputs: & & \\ \hline Machine Cost & $6,000 \\ Estimated Salvage Value & $ & 12,000 \\ Estimated Useful Life & & 75,000 \end{tabular} units Annual S23Depreciation Methods Home Insert Draw Page Layout Formulas Data Review View Q Tell me A1 fx Double Declining Balance \begin{tabular}{|c|c|} \hline Double Dec lining Balance \\ \hline \end{tabular} \begin{tabular}{l} 2 \\ 3 \\ 4 \\ 5 \\ 6 \\ 7 \\ 8 \\ 9 \\ 10 \\ 11 \\ 12 \\ 13 \\ 14 \\ 15 \\ 16 \\ 17 \\ 18 \\ 19 \\ 20 \\ 21 \\ 22 \\ 23 \\ 24 \\ 25 \\ 26 \\ 27 \\ 28 \\ 29 \\ 30 \\ 31 \\ 32 \\ 33 \\ 34 \\ 35 \\ 36 \\ 37 \\ 38 \\ 39 \\ 40 \\ 41 \\ 42 \\ 43 \\ 44 \\ 45 \\ 46 \\ 47 \\ 48 \\ \hline \end{tabular} \begin{tabular}{|lrr|} \hline Inputs: & & \\ Machine Cost & 5 & 80,000 \\ Estimated Salvage Value & & 10,000 \\ Estimated Useful Llfe & & 5 \\ \hline \end{tabular} Use algebraic formulas in the main table Annual (columns B:E), and Excel's DDB function in \begin{tabular}{l|l|l|l} Depreciation & Accumulated & Clarying & Excel \\ \hline \end{tabular} column F. Expense Depreciation $80,000Value Function Do not depreciate below estimated salvage value! Be sure to use formulas or cell references through out your tablel Double Declining Check Figures Inputs: Machine Cost Estimated Salvage value Estimated Useful Life Annus Depreciation Accumulated Carrying Year 1 2 Do not depreciate below estimated salvege valuel Do not depreciate below estimated salvage value