Suppose I purchased Computer for Rs 29000 on 01.05.2005 and sold the same on 30.06.2009 for 18000 and I want Excel formula of WDV on sale date and total depreciation( as per Companies Act)-Niharika
Menu
Depreciation Formula
Replies (9)
i think its not possible to explain u this formula theoretically..
Or attach a excel file which include values and formula.
does this solve ur prob..?
c attachment..
| Originally posted by :Niharika | ||
| " | Suppose I purchased Computer for Rs 29000 on 01.05.2005 and sold the same on 30.06.2009 for 18000 and I want Excel formula of WDV on sale date and total depreciation( as per Companies Act)-Niharika | " |
Hopes the attached file might solve ur question.....
shreyas
In your excel file total depn as on date of sale is 14218, but i want single formula on the same date with total depn and WDV
Hi,
Please check this file. Please confirm once you check it.
| Originally posted by :Niharika | ||
| " | Suppose I purchased Computer for Rs 29000 on 01.05.2005 and sold the same on 30.06.2009 for 18000 and I want Excel formula of WDV on sale date and total depreciation( as per Companies Act)-Niharika | " |
Hi Niharika
Find the attached excel formula i hope it will be useful for you.
| Originally posted by :Niharika | ||
| " | Suppose I purchased Computer for Rs 29000 on 01.05.2005 and sold the same on 30.06.2009 for 18000 and I want Excel formula of WDV on sale date and total depreciation( as per Companies Act)-Niharika | " |
Hi Niharika
Find the attached Excel formula hope be useful for you.
attached here single formula for dept calculation
Recent Topic
- Form 10E and Salary arrear
- LTCG U/S 54F. Sale of property plus sale of share
- Issue with ITR2 online utility for HUF
- TDS deducted by EPFO under wrong section
- Schedule SI in ITR-2
- What is the easy way to do CA- through foundation
- Schedule FA query for this AY 2026-27
- Business income source for husband and wife
- Set off of LTCL against STCG under section 536(2n)
- Audit Workflow tool
Related Topics
CAclubindia
