Question

GOOD FELLAS’ CATERING Truck Depreciation Schedule • Straight-Line Method
Cost of Asset:		$56,500
Salvage Value:		$5,500
	Length of Service (yrs):	5
Depreciable Base:
Annual Depreciation:
Straight-Line	Years
(SLN)	1	2	3	4	5
Annual Depreciation
Cumulative Depreciation
End-of-Year Book Value

1. Enter a formula in Cell C7 to calculate the Depreciable Base.

2. Enter a straight line depreciation formula in Cell C8 to calculate the Annual Depreciation.

3. Copy the formula in C8 to B11.

4. Copy the formula in Cell B11 horizontally to Cell F11.

5. In Cell B12, enter the formula to display the depreciation for the first year.

6. In Cell C12, enter the formula to add this yearly depreciation to the previous year's depreciation.

7. Copy the formula in cell C12 across to F12 to calculate cumulative depreciation through the first five years.

8. In Cell B13, enter the formula to calculate the depreciated asset's value after the first year.

9. Copy the formula in B13 across to F13. The asset's value will be reduced to the Salvage value.

10. Save the file as ch13ex02a.xlsx.

Answer 1

GOOD FELLAS’ CATERING
Truck
Depreciation Schedule • Straight-Line Method
Cost of Asset:		$56,500
Salvage Value:		$5,500
	Length of Service (yrs):	5
Depreciable Base:
Annual Depreciation:
Straight-Line	Years
(SLN)	1	2	3	4	5
Annual Depreciation	$10,200	$10,200	$10,200	$10,200	$10,200
Cumulative Depreciation	10200	20400	30600	40800	51000
End-of-Year Book Value	46300	36100	25900	15700	5500