Home Company Products Support Partners Clients Bulletin Resources Downloads Contact Us


 

 
Our Products
 
TdsPac  
FAMS
eTds Wizard
ITR Wizard
           
FAMS – Prospective Change in Rate: Depreciation

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

FAMS – Proportionate Depreciation : Depreciation Rate 100%

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

  1. Proportionate Dep Calc for 100% rate
  2. 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

  1. Based on Date put to use of parent asset
  2. Based on Date put to use of dependent child
  3. 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
best website stats