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
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
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
T R SOOD & CO
New Delhi
CA Inter
View Details
SSGS and Associates
Chennai
CA Inter
View Details
R P S K & Associates
Nashik
CA Inter
View Details
CAclubindia
