please use excel

Modified Accelerated Cost Recovery System (MACRS)
Uses a half-year convention
Does not consider salvage value
Depreciation expense over the life of the asset is the same as with straight-line
	Recovery Year	3 year	5 year	7 year
	1	33.33%	20.00%	14.29%
	2	44.45%	32.00%	24.49%
	3	14.81%	19.20%	17.49%
	4	7.41%	11.52%	12.49%
	5		11.52%	8.93%
	6		5.76%	8.93%
	7			8.93%
	8			4.46%

FINA Corp. purchased a $9000 piece of machinery, that required an additional $1000 for shipping and installation. If the asset is depreciated under MACRS for a 7-year class asset, what are the annual depreciation expenses for this asset?
Purchase Price
+Install/Ship
Depreciable Basis
Year	MACRS Rate	Annual Dep.
1
2
3
4
5
6
7
8