Asset # $222$

Asset name: Equipment

Date acquired: $1/1/14$

Cost: $$45,000$

Depreciation method: Double$-$Declining$-$Balance

Salvage $($residual$)$ value: $$5,000$

Estimated useful life $($years$)$: $5$

Output:

$(1)$ Set up an Excel worksheet and include the data above in the Excel worksheet.

$(2)$ Set up a Depreciation Schedule as shown below:

Depreciation Schedule$-$ Double Declining Balance

Current Period End of Period

Year Beginning Book Value DDB Rate Annual Depreciation Accumulated

Depreciation Ending Book Value

$2014$

$2015$

$2016$

$2017$

$2018$