Function: SYD; Formula: Multiply; Cell Referencing

Using Excel to Calculate Sum$-$of$-$the$-$Years' Digits

Depreciation

PROBLEM

Student Work Area

Required: Provide input into cells shaded in yellow in this

template. Input the required mathematical formulas or functions

Lockard Company purchased machinery on January $1,$

with cell references to the Problem area or work area as indicated.

Information concerning the machinery is presented

here.

Cost of machinery

$$80,000$

Estimated salvage value $,8,000$

Estimated useful life in years $$,8$

a$.$ Use the SYD function to compute $2025$ depreciation expense

using the sum$-$of$-$the$-$years'$-$digits method.

$2025$ Depreciation expense

b$.$ Use the SYD function to compute $2025$ depreciation expense

using the sum$-$of$-$the$-$years'$-$digits method, assuming the

machinery was purchased on April $1,2025.$

$2025$ Depreciation expense