Total OC = 475Total OP = 57
Total OC = 305Total OP = 25
Total OC = 730Total OP = 66
Total OC = 550Total OP = 33
Total OC = 365Total OP = 8
Total OC = 420Total OP = 50
Total OC = 435Total OP = 46
From the above, the dataset will be constructed as follows :
For construction of the arm's length range the data place of thirty-fifth and sixty-fifth percentile shall be computed in the following manner, namely: Total no. of data points in dataset *(35/100) Total no. of data points in dataset *(65/100) Thus, the data place of the thirty-fifth percentile = 7*0.35=2.45. Since this is not a whole number, the next higher data place, i.e. the value at the third place would have at least thirty five per cent of the values below it. The thirty-fifth percentile is therefore value at the third place, i.e. 8.2%. The data place of the sixty-fifth percentile is = 7*0.65=4.55. Since this is not a whole number, the next higher data place, i.e. the value at the fifth place would have at least sixty five per cent of the values below it. The sixty-fifth percentile is therefore value at fifth place, i.e. 10.57%. The arm's length range will be beginning at 8.2% and ending at 10.57%. Therefore, if the transaction price of the international transaction or the specified domestic transaction has OP/OC percentage which is equal to or more than 8.2% and less than or equal to 10.57%, it is within the range. The transaction price in such cases will be deemed to be the arm's length price and no adjustment shall be required. However, if the transaction price is outside the arm's length range, say 6.2%, then for the purpose of determining the arm's length price the median of the dataset shall be first determined in the following manner: The data place of median is calculated by first computing the total number of data point in the dataset * (50/100). In this case it is 7*0.5=3.5. Since this is not a whole number, the next higher data place, i.e. the value at the fourth place would have at least fifty per cent of the values below it (median). The median is the value at fourth place, i.e., 9%. Therefore, the arm's length price shall be considered as 9% and adjustment shall accordingly be made. Illustration 2.-The data of the current year is available in respect of enterprises A, C, E, F and G at the time of furnishing the return of income by the assessee and the data of the financial year preceding the current year has been used to identify comparable uncontrolled transactions undertaken by entrprises B and D. Further, if the enterprises have also undertaken comparable uncontrolled transactions in earlier years as detailed in the table, the weighted average and dataset shall be computed as below:
Total OC = 475Total OP = 57
Total OC = 205Total OP = 15
Total OC = 730Total OP = 66
Total OC = 220Total OP = 22
Total OC = 100Total OP = (-)5
Total OC = 420Total OP = 50
Total OC = 435Total OP = 46
From the above, the dataset will be constructed as follows :
If during the course of assessment proceedings, the data of the current year is available and the use of such data indicates that B has failed to pass any qualitative or quantitative filter or for any other reason the transaction undertaken is not a comparable uncontrolled transaction, then, B shall not be considered for inclusion in the dataset. Further, if the data available at this stage indicates a new comparable uncontrolled transaction undertaken by enterprise H, then, it shall be included. The weighted average and dataset shall be recomputed as under :
Total OC = 475Total OP = 57
Total OC = 730Total OP = 66
Total OC = 370Total OP = 42
Total OC = 100Total OP = (-)5
Total OC = 420Total OP = 50
Total OC = 435Total OP = 46
Total OC = 230Total OP = 22
From the above, the dataset will be constructed as follows :
Illustration 3. - In a given case the dataset of 20 prices arranged in ascending order is as under :
No. Profits (in Rs. Thousand)
Applying the formula given in the Illustration 1, the data place of the thirty-fifth and sixty-fifty percentile is determined as follows: Thirty-fifth percentile place = 20* (35/100) = 7. Sixty-fifth percentile place = 20* (65/100) = 13. Since the thirty-fifth percentile place is a whole number, it shall be the average of the prices at the seventh and next higher, i.e.; eighth place. This is (47+48)/2 = Rs.47,500. Similarly, the sixty-fifth percentile will be average of thirteenth and fourteenth place prices. This is (48.5+49)/2=Rs.48,750 The median of the range (the fiftieth percentile place) = 20*(50/100)=10 Since the fiftieth percentile place is a whole number, it shall be the average of the prices at the tenth and next higher, i.e.; eleventh place. This is (48.35+48.45)/2= Rs.48,400. Thus, the arm's length range in this case shall be from Rs.47,500 to Rs.48,750. Consequently, any transaction price which is equal to or more than Rs.47,500 but less than or equal to Rs.48,750 shall be considered to be within the arm's length range.