Hey 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?
Please find attached file and revert
The file i think is locked or the formula isnt working correctly. When I enter my data the computation shows #VALUE!
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
S.B.G. & CO. CHARTERED ACCOUNTANTS
New Delhi
CA Inter
View Details
RMA And Associates LLP
New Delhi
CA Inter
View Details
AJAY SINGH AND CO LLP
Thane
CA Final
View Details
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
Abic and Mani Chartered Accountants
Kottayam
B.Com
View Details
ADY & CO.
New Delhi
Graduate (Any)
View Details
CCI
Pro
CAclubindia
