Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Depreciation Formula

Niharika (Asst Manager) (60 Points)

01 September 2009

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

Reply
Follow
Share

9 Replies

Arjun Roy (Chartered Accountant) (158 Points)
Replied 01 September 2009

i think its not possible to explain u this formula theoretically..

Upgrade to CAclubindia Pro. Subscribe Now!

Niharika (Asst Manager) (60 Points)
Replied 02 September 2009

Or attach a excel file which include values and formula.

Arjun Roy (Chartered Accountant) (158 Points)
Replied 03 September 2009

does this solve ur prob..?

c attachment..

Attached File : 4 book1.xls downloaded: 738 times

shreyas (Student) (260 Points)
Replied 04 September 2009

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.....

Attached File : 34 book1.xls downloaded: 457 times

Niharika (Asst Manager) (60 Points)
Replied 04 September 2009

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

Upgrade to CAclubindia Pro. Subscribe Now!

Vijay D (Finance Executive) (227 Points)
Replied 04 September 2009

Hi,

Please check this file. Please confirm once you check it.

Attached File : 15 dept calculation.xls downloaded: 515 times

Pradeep Kr Shukla (Service) (73 Points)
Replied 05 September 2009

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.

Attached File : 24 dep wdv formula.xls downloaded: 423 times

Pradeep Kr Shukla (Service) (73 Points)
Replied 05 September 2009

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 File : 52 dep wdv formula.xls downloaded: 399 times