Formula Depreciation (Need 6 month life with different rates each MONTH)
I am trying to create a depreciation formula that will depreciate an asset over 6 months with a different rate each month.
Can anyone help? I have tried several formulas but no luck.
Example Asset life 6 months, Cost 10,000
Month 1 35.00% so depreciation = 3,500 (10,000 * .35)
Month 2 25.00% so depreciation = 2,500 (10,000 * .25)
Month 3 10.00% so depreciation = 1,000 (10,000 * .10)
Month 4 10.00% so depreciation = 1,000 (10,000 * .10)
Month 5 10.00% so depreciation = 1,000 (10,000 * .10)
Month 6 10.00% so depreciation = 1,000 (10,000 * .10)
- Terry