$\backslash$table$[[$DATA$,5,,2,],[,],[$Cost$,,,400,000,,,],[$Residual Value,,$20,000,,,],[$Useful Life $($Years$),,4,,,],[$Useful Life $($Hours$),,8,000,,,],[$Gain End of Year $1,,6,000,,\sqrt[\phantom{2}]{858},],[,,,,,,],[,8,,=,,,],[$Straight Line,,$\sqrt[\phantom{2}]{4x},58,,],[$Year$,\backslash$table$[[$Depreciable$],[$Cost$]],,$Rate,$\backslash$table$[[$Depreciatio$],[$n Expense$]],\backslash$table$[[$Accumulated$],[$Depreciation$]],$Book Value$],[,,,,,,],[2],[3],[4,\sqrt[\phantom{2}]{x+1},,,,,]]$

Selling price at the end of Year $1$ that results in a gain of $$6,000$

Double Declining Balance

$\backslash$table$[[$Year$,\backslash$table$[[$Book Value$],[$Beginning$],[$of Year$]],$Rate,$\backslash$table$[[$Depreciatio$],[$n Expense$]],\backslash$table$[[$Accumulated$],[$Depreciation$]],\backslash$table$[[$Book Value$],[$End of Year$]]],[1,,,,,],[2,,,,,],[3,,,,,],[4,,,,,]]$

Double Declining Balance using DDB function

Selling price at the end of Year I that results in a gain of $$6,000$

Units of Production

$\backslash$table$[[$Year$,\backslash$table$[[$Depreciatio$],[$n Per Unit$]],\backslash$table$[[$Machine$],[$Hours$]],\backslash$table$[[$Depreciatio$],[$n Expense$]],\backslash$table$[[$Accumulated$],[$Depreciation$]],$Book Value$],[1,,2,400,,,],[2,,1,800,,,],[3,,2,480,,,],[4,,1,320,,,]]$

Selling price at the end of Year $1$ that results in a gain of $$6,000$