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
- UNCLAIMED TDS REFUND QUERY
- Rcm payable which head
- Query of GST
- Long Term Capitalgains on sale of residential prop
- How Salaried Individuals Can Reduce Capital Gains
- NSTPI registration
- GST PAID IN DELHI
- How to Trade Forex in India?
- TDS - requirement of TDS by individual under presu
- Normal Register in GST in delhi in gujarat no rece
Related Threads
CAclubindia
