Solved
Excel need help figuring out a forumla
Posted on 2014-01-23
I am having problems trying to figure out a formula here and hope someone can help me out.
Yr Value Depreciation % Depreciation Amount New Value
1 100 20% 20 80
2 80 40% 32 48
3 48 60% 28.8 19.2
4 19.2 80% 15.36 3.84
5 3.84 100% 3.84 0
As you can see year 1 it depreciates a full 20% and the new value of year 1 becomes 80, but what if I am trying to get a value that is 18 month, which would include a Year 1 and half of year two. What should be the formula if I just want to plug in 18 as a value? TIA