WooYing
asked on
Excel need help figuring out a forumla
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
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
HI
Form your question what i got is you need to show year as 1.6,3,4.6,6...so on.if it is correct you can use below formula.
Try this :
Cell A1 => 1.6
Cell A2 => 3
Cell A3 => =A1+3
Cell A4 => =A2+3
For the Following cell just drag the selection in the column 'A'
Form your question what i got is you need to show year as 1.6,3,4.6,6...so on.if it is correct you can use below formula.
Try this :
Cell A1 => 1.6
Cell A2 => 3
Cell A3 => =A1+3
Cell A4 => =A2+3
For the Following cell just drag the selection in the column 'A'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See attached file.
Thanks
Depreciation.xlsx