ALT-SL-DEPRECIATION-SCHEDULE

please post the answer in excel

Granite Company purchased a machine with cost of $32,000 and salvage value of $4,000.

The life of the machine was estimated to be 5 years.

Complete the depreciation schedule shown below.

DEPRECIABLE

SL

DEPRECIATION

ACCUM.

BOOK

GRADES

YEAR

COST

RATE

EXPENSE

DEPRECIATION

VALUE

YR

DPC

SLR

EXP

ACC

BKV

1

1

0

0

0

0

0

2

2

0

0

0

0

0

3

3

0

0

0

0

0

4

4

0

0

0

0

0

5

5

0

0

0

0

0