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.....
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 Threads
- Excess Payment on RCM
- AOC4 auto population of previous year data
- Exports against INR PO payable by Domestic Company
- Which websites are best for government exam prepar
- TDS on maturity payment of LIC of india
- ITR2 Gold ETF short and long term
- Query under faceless assessment
- Purchase of business
- Refund of ITC for advance paid to overseas supplie
- Clubbing query (when gifts given to multiple fami
Related Threads
CAclubindia
