On January 1 of the current year, the S Company purchased equipment for $152,000. The equipment...

Transcribed Image Text:

On January 1 of the current year, the S Company purchased equipment for $152,000. The equipment has an estimated useful life of 5 years and an estimated salvage value of $12,000. Complete the depreciation schedule below. Each formula in column D must include the DDB function. Cost Salvage Life (in years) $152,000 $12,000 Depreciation Accumulated Expense January 1 December 31 Year book value Depreciation book value 1 $152,000 4 If we modify the formula in cell 828 to =826*SB$27 before we copy the formula, Excel will not change the row or the column of the second variable, When the formula is copied to columns C through E, the formulas become: Cell C28 -C26*58527 Cell D28 -D26*SBS27 Cell E28 =E26*SeS27 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a dollar sign before the column, but not the row (i.e.S827) If you want the row to stay fixed, but allow the calumn to remain relative when it's copied, add a dollar sign before the row, but not the column (i.e. B$27), Tapping the F4 button while entering the formula for in the formula bar) toggles among the 3 absolute options (Absolute Column and Absolute Row $8$28, Absolute Column and Relative Row $828, Relative Column and Absolute Row BS28) On January 1 of the current year, the S Company purchased equipment for $152,000. The equipment has an estimated useful life of 5 years and an estimated salvage value of $12,000. Complete the depreciation schedule below. Each formula in column D must include the DDB function. Cost Salvage Life (in years) $152,000 $12,000 Depreciation Accumulated Expense January 1 December 31 Year book value Depreciation book value 1 $152,000 4 If we modify the formula in cell 828 to =826*SB$27 before we copy the formula, Excel will not change the row or the column of the second variable, When the formula is copied to columns C through E, the formulas become: Cell C28 -C26*58527 Cell D28 -D26*SBS27 Cell E28 =E26*SeS27 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a dollar sign before the column, but not the row (i.e.S827) If you want the row to stay fixed, but allow the calumn to remain relative when it's copied, add a dollar sign before the row, but not the column (i.e. B$27), Tapping the F4 button while entering the formula for in the formula bar) toggles among the 3 absolute options (Absolute Column and Absolute Row $8$28, Absolute Column and Relative Row $828, Relative Column and Absolute Row BS28)

Answer rating: 100% (QA)

cost 152000 salvage 12000 life in years 5 year January 1 ... View the full answer