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