Straightline Depreciation

profileahmed_8800
StraightlineDepreciationExample_1_.xlsx
Home>Business & Finance homework help>Accounting homework help>Straightline Depreciation

Sheet1

Purchase Price $ 110,000
Recovery Period 7 years
Salvage Value $ 10,000
m Rm Dm ($) BVm ($)
0 $ 110,000
1 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 95,714
2 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 81,429
3 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 67,143
4 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 52,857
5 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 38,571
6 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 24,286
7 1/7 0.14 ($110,000 -$10,000)/7 $ 14,286 $ 10,000
$14,285.71

Sheet2

Sheet3