Transfer Pricing
Tool

Transfer pricing refers to the pricing of transactions between related parties: companies within the same multinational group. It matters because it determines how profits are allocated between jurisdictions, which directly affects taxable income. Tax authorities require that intercompany transactions be priced at arm's length, the same price that independent parties would agree to in comparable circumstances. Non-compliance can result in significant tax adjustments, penalties, and double taxation.

The arm's length principle, codified in Article 9 of the OECD Model Tax Convention, requires that related-party transactions be priced as if they were between independent, unrelated parties. This is the cornerstone of international transfer pricing. The OECD Transfer Pricing Guidelines (2022) provide detailed guidance on how to apply this principle, including method selection, comparability analysis, and documentation requirements.

The interquartile range is a statistical measure spanning the 25th to 75th percentile of a comparable dataset. In transfer pricing, the IQR is used to define the arm's length range per OECD ¶3.55–3.62. If the tested party's result falls within the IQR, no adjustment is required (¶3.60). If it falls outside the IQR, tax authorities may adjust the result to the median (¶3.62). This tool calculates the IQR using the PERCENTILE.INC method (Excel-compatible interpolation).

The OECD prescribes five methods, three of which are implemented in this tool: CUP (best when reliable uncontrolled prices exist: commodities, loans, royalties), Cost Plus (best for contract manufacturing, routine services, management fees), and TNMM (most widely used method globally, compares net profit margin of the tested party to comparable independent companies). The method choice depends on the transaction type, available data, and comparability. Select the 'most appropriate method' per OECD ¶2.1–2.12.

The Transactional Net Margin Method (TNMM) is the most widely used transfer pricing method globally. It compares the net profit margin of the tested party (the least complex entity in the transaction) to the margins of comparable independent companies. TNMM is appropriate when: reliable comparable transaction data is not available for CUP, the tested party performs routine functions without unique intangibles, and sufficient comparable company data exists in databases like Amadeus or Orbis. The Profit Level Indicator (PLI: operating margin, net cost plus, Berry Ratio, or return on assets) must be selected based on the tested party's characteristics.

No. This tool performs the statistical analysis (IQR calculation, arm's length testing, and documentation) on comparable data that you provide. You need to source your comparable set from commercial databases such as Amadeus, Orbis (Bureau van Dijk), RoyaltyRange, or publicly available financial statements. The tool then calculates Q1, median, Q3, and determines whether your tested party falls within the arm's length range.

ISA 550 (Related Parties) requires auditors to identify related party transactions, assess whether they are conducted at arm's length (when the reporting framework requires such disclosure), and evaluate whether they have been appropriately accounted for and disclosed. Transfer pricing analysis directly supports ISA 550 compliance. When the auditor evaluates whether a related party transaction was at arm's length, a transfer pricing benchmarking study with IQR analysis provides the quantitative evidence needed.

The OECD does not prescribe a minimum number, but statistical validity improves with more data points. Practical guidance: minimum 3 comparables (the mathematical minimum for IQR calculation), 6+ comparables recommended for statistical reliability, and 10–15 comparables is ideal. India's Rule 10CA specifically requires 6 or more comparables for the range concept to apply. Fewer than 6 comparables should be flagged as a limitation in your documentation.

Per OECD ¶3.62, if the tested party's result falls outside the interquartile range, tax authorities may adjust the result to the most appropriate point within the range, typically the median. This tool calculates the suggested adjustment amount. Being outside the IQR does not automatically mean non-compliance, but it creates a presumption that an adjustment may be warranted. Document the reasons if you believe the result is arm's length despite falling outside the IQR.

The full range spans from the minimum to the maximum of your comparable dataset. The interquartile range (IQR) spans from Q1 (25th percentile) to Q3 (75th percentile) and excludes the extreme values. Most OECD jurisdictions use the IQR as the arm's length range because it reduces the impact of outliers and reflects the most reliable portion of the data. However, Canada prefers the full range, and India uses a narrower 35th–65th percentile range. This tool supports all three approaches via the jurisdiction selector.

Yes. Select the CUP method and enter the controlled interest rate as the controlled transaction price. Enter comparable market interest rates (from independent loan transactions, EURIBOR/SOFR plus credit spread data, or loan market databases) as the CUP prices. The tool will calculate whether the controlled rate falls within the arm's length range. OECD Chapter X (Financial Transactions, 2020) provides specific guidance on intercompany loan pricing.

Yes. It runs entirely in your browser with no data sent to any server and no registration required. All calculations are performed client-side. You can export your analysis as documentation (.txt) or comparable data as CSV.

Ciferi offers 20+ free audit and accounting tools, all browser-based with no login required. These include the ISA 530 Sampling Calculator, ISA 570 Going Concern Checklist, Analytical Review Tool (ISA 520), Financial Ratio Calculator, Depreciation Calculator (IAS 16), IFRS 16 Lease Calculator, IFRS 9 ECL Calculator, IAS 37 Provision Calculator, IAS 12 Deferred Tax Calculator, IAS 36 Impairment Calculator, Materiality Calculator (ISA 320), and Intercompany Elimination Tool (IFRS 10). Visit our free tools hub at ciferi.com/free to see the full collection.