G
Guest
Guest
Im making a modified depreciation schedule that depreciates assets at non-linear rates.
(i.e. a 20-year asset will depreciate over 20 years, but not necessarily at 5% each year). In addition, I will be making capital additions to the asset each year that will need to be depreciated at the corresponding rate.
Ultimately, Im looking for total depreciation in each year. So Im looking for a scenario in which the first column (headed '2002', for example) will have the capital addition from that year, times the 1st year depreciation rate. The second column (headed '2003') will have capital addition from the second year times the 1st year depreciation rate, PLUS the capital addition in the first year times the 2nd year rate (since it will then be two years old). And so on. Can anyone help me? Thanks in advance.
(i.e. a 20-year asset will depreciate over 20 years, but not necessarily at 5% each year). In addition, I will be making capital additions to the asset each year that will need to be depreciated at the corresponding rate.
Ultimately, Im looking for total depreciation in each year. So Im looking for a scenario in which the first column (headed '2002', for example) will have the capital addition from that year, times the 1st year depreciation rate. The second column (headed '2003') will have capital addition from the second year times the 1st year depreciation rate, PLUS the capital addition in the first year times the 2nd year rate (since it will then be two years old). And so on. Can anyone help me? Thanks in advance.