Double$-$Declining$-$Balance Depreciation

A small delivery truck was purchased on January $1$ at a cost of $$5,000.$ It has an estimated useful life of four years and an estimated salvage value of $$1,000.$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

Small Delivery Truck

Depreciation ScheduleDouble$-$Declining$-$Balance Depreciation

A small delivery truck was purchased on January $1.$ The following data is provided:

DATA

Using depreciation formulas and cell references, perform the required analysis, and input your answers into the

green cells in the $B,C,D,E,$ and $F$ columns. Transfer the numeric results for the green entry cells $($B$16$:F$17,$

$B18$:$B19,D18$:$F19$ into the appropriate fields in CNOWv$2$ for grading.