Description: There are few assets in a category. Out of these assets, category and rate of one asset is to be changed with prospective effect.
Is it possible in FAMS? If not, then any workaround.
Solution
If rate is to be changed for ALL the assets in the category, it is provided in FAMS. However there is no direct method of changing the category and rate of partial assets.
Workaround
Prospective change of category and rate is possible via the following work-around
First change the Category for the asset thru Transactions -> Change of Asset Category. This will not change the rate, and continue to calculate depreciation by old rate tagged to previous category
Next, manually change the “over Ride” rate for the asset in Transactions-> Acquisition of asset
Precautions
Asset ID will remain same. An asset belonging to Computer category – now shifted to Furniture. Asset ID will remain what was given originally for Computer category.
Depreciation needs to be calculated upto that date to give effect of new rate. Example : New rate applicable from 15/07/2009. Depreciation needs to be calculated till 14/07/2009
Description: There are some assets having 100% depreciation rate. Depreciation is calculated every month.
We would like depreciation to be calculated proportionately in such a way that it gets depreciated over 365 days from date put-to-use.
Is it possible in FAMS and how ?
Solution
It is possible to depreciate an asset with 100% rate over 365 days from date put to use. There is an option provided in Master->Parameters
Proportionate Dep Calc for 100% rate
Full write-off for 100% rate in Financial Year
Both options are being explained with the help of following example
Example:
An asset is purchased as per details in Table below
Financial Year
2002-2003
Category-I
Computer
Category-II
Desktop
Rate
100%
Method
SLM
Date Put to Use
01/08/2002
Cost
100000
Based on above facts depreciation calculation as per option A and B is being explained
A Proportionate Dep Calc for 100% rate
In this option the asset will get depreciated over 365 days i.e. from August 2002 to July 2003. Depreciation calculation for the two financial years given blow.
Depreciation is calculated as
Depreciation Amt = Cost x Rate / 100 x No of days / 365
Financial Year : 2002-2003
Month
No of Days
Dep AMT
WDV
April
0
May
0
June
0
July
0
August
31
8493
91507
September
30
8219
83288
October
31
8493
74795
November
30
8219
66576
December
31
8493
58083
January
31
8493
49590
February
28
7671
41919
March
31
8493
33426
Financial Year : 2003-2004
Month
No of Days
Dep AMT
WDV
April
30
8219
25207
May
31
8493
16714
June
30
8219
8495
July
31
8493
2
August
31
2
0
B Full write-off for 100% rate in Financial Year
In this option the asset will get depreciated till the financial year end i.e. from August 2002 to March 2003. Depreciation is calculated as
Total No of Days = Last Date of Depreciation - Date put to use + 1
DepAmt = Cost x Rate / 100 x No of days / Total No of Days
Financial Year : 2002-2003
Month
No of Days
Dep AMT
WDV
April
0
May
0
June
0
July
0
August
31
12757
87243
September
30
12346
74897
October
31
12757
62140
November
30
12346
49794
December
31
12757
37037
January
31
12757
24280
February
28
11523
12757
March
31
12757
0
FAMS – Dependent-Child : Depreciation calculation
Description:
As per Accounting Standard 6, “Any addition or extension to an existing asset which is of a capital nature and which becomes an integral part of the existing asset is depreciated over the remaining useful life of that asset.”As a practical measure, however, depreciation is sometimes provided on such addition or extension at the rate which is applied to an existing asset.
How is this to be implemented in FAMS ?
Solution
FAMS has provided an option to update addition to an existing asset as ‘Dependent-Child’. Depreciation on such dependent child can also be parameterized to take care of accounting standards.
Updating dependent child
In Transaction->Acquisition screen, field Acquired As has drop-down value "Dependent-child". For this the parent asset needs to be selected
Once the asset is added as Depe AssetID, if assets is acquired as ‘Dependent-Child’, cost of this asset is added to the cost of parent asset . Dependent child does not get any separate asset ID and no separate identity is maintained thereafter.
Depreciation Calculation
Depreciation calculation for the dependent child can be handled in the one of the three ways provided in Parameters
Based on Date put to use of parent asset
Based on Date put to use of dependent child
Cost of dependent child to be writen-off alongwith parent asset
The three options are being explained with the help of following example
Mode of Acquisition
Parent Asset
Dep-Child
Accyear
2002-2003
2003-2004
2004-2005
Method
SLM
SLM
SLM
Rate
50
50
50
Assetid
COM0001
COM0001-01
COM0001
DateUsed
01/04/2002
01/10/2003
01/04/2004
Depreciation Upto
31/03/2003
31/03/2004
31/03/2005
Days
365
183
365
Cost
100000
25000
125000
A Based on Date put to use of parent asset
In this case date put to use of dependent child is ignored and that of parent child is considered
As can be seen from table below, although dependent child is used only for 183 days, depreciation on the same has been calculated for 365 days
DepAmt for Dep-Child = 25000 x 50/100 x 365/365 = 12500
Mode of Acquisition
Parent Asset
Dep-Child
Accyear
2002-2003
2003-2004
2004-2005
Depreciation Upto
31/03/2003
31/03/2004
31/03/2005
Days
365
183
365
Cost
100000
25000
125000
Acc Dep
0
50000
100000
Dep -Parent Asset
50000
50000
12500
Dep -Dep-Child
0
12500
0
Total Dep Amt
50000
62500
12500
WDV
50000
12500
0
B Based on Date put to use of dependent child
In this case date put to use of the dependent child is considered.
As can be seen from the table below, depreciation on the dependent child is calculated only for 183 days
Dep Amt for Dep-Child = 25000 x 50/100 x 183/365 = 6267
Mode of Acquisition
Parent Asset
Dep-Child
Accyear
2002-2003
2003-2004
2004-2005
Depreciation Upto
31/03/2003
31/03/2004
31/03/2005
Days
365
183
365
Cost
100000
25000
125000
Acc Dep
0
50000
100000
Dep - Parent Asset
50000
50000
12500
Dep - Dep-Child
0
6267
0
Total Dep Amt
50000
56267
18733
WDV
50000
18733
0
C Cost of dependent child to be written-off alongwith parent asset
In this case, a new rate of depreciation is worked out in such a way that the cost of parent asset and dependent child gets depreciated over remaining life of parent asset
This new rate is automatically updated as 'Over Ride' rate in acquisition of asset and depreciation is calculated based on this over-riding rate
In the table below, this point is explained.
Year
Mode
Cost
Rate
Dep
AccDep
WDV
2002-2003
100000
25
4110
0
95890
2003-2004
100000
25
25000
4110
70890
2004-2005
Dep-Child
150000
28.38
42570
29110
78320
2005-2006
150000
28.38
42570
71680
35750
2006-2007
Dep-Child
200000
51.04
102080
114250
-16330
Copyright (C) 2007, Fast Facts Computer Systems Limited, Mumbai. All Rights Reserved.
622, Laxmi Plaza, New Link Road, Andheri West Mumbai -400053 . Sales and Support :022- 40557000 ( 30 Lines )