XYZ Company
Depreciation Schedule
Cost
Salvage Value
Estimated Useful Life
Declining Balance Rate
Period	Depreciation Expense	Accumulated Depreciation	Book Value
0			-
1
2
3
4
5
6
7
8
9
10
XYZ is considering purchasing some new equipment at the beginning of 2014.
Cost		$350,000
Salvage Value		75,000.00
Estimated Useful Life		15 years
Declining Balance Rate		200%
1- Prepare a depreciation schedule that will calculate depreciation for a 20 Year period.
2- create an input section for the cost, salvage value. Life and declining balance rate.
3- Use the depreciation methods. Hint Use function
Use function to calculate the depreciation methods .
Straight line, sum-of years digits and double decline balance.
4- create a chart to compare between the three different methods of depreciation
5- comment about which depreciation method is better for company and why?