Abhishek (CA - Student) (50 Points)
20 December 2008Hey guys.
I require some help in computation of depreciation under straight line method for a certain entity. WDV is extremely easy to recompute.
Now I have an entity for which audit is being done a period between Apr to Nov. There are several FAs added mid month's.
Now the underlying question her is, is there an easy formula that I can apply across all the assets for computing depn. for the period?
Juzer Sadikot
(CA - innovative solutions for Imports and Exports)
(1309 Points)
Replied 20 December 2008
Please find attached file and revert
Abhishek
(CA - Student)
(50 Points)
Replied 23 December 2008
The file i think is locked or the formula isnt working correctly. When I enter my data the computation shows #VALUE!
Juzer Sadikot
(CA - innovative solutions for Imports and Exports)
(1309 Points)
Replied 26 December 2008
Dear Abhishek,
Just do following and then try to resolve your computation
Go to Start Menu => Control Panel => Regional Setting => Customize => Date => select format dd/mmm/yy and the sheet will work
Regards
CAclubindia
