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 Topics :
- REGARDING HSN CODE FOR WASHING JOB CHARGES
- Advance Tax Due Date 2026
- Query – Interest on Capital Received by Part
- Query - Section 164(2)(a) – Interpretation o
- Submission for Expert Opinion on Rectification of
- NRI since March 2023 – resident savings acco
- My All-Time Top 15 Indian Web Series
- Wrong date of invoice
- Paper 6 - IBS
- Chhath Puja 2026 Dates Timing Tithi
Related Topics :
CAclubindia
