# Transfer Pricing Model Build a transfer pricing model to analyse intercompany flows, benchmark profit margins, and ensure defensible arm's length pricing across international jurisdictions. Aligned with OECD BEPS documentation standards. - Canonical: https://finamodel.com/templates/transfer-pricing-model - Excel download: https://finamodel.com/templates/transfer-pricing.xlsx - Category: Corporate Finance - Model type: Sector planning - Difficulty: Advanced - Audiences: CFOs & FP&A, Bankers & advisors, Transfer pricing specialists, Tax directors, CFOs, Big 4 advisors - Tags: transfer-pricing, arm's-length, tax-compliance, beps, documentation ## Overview Model intra-company transfer prices using comparable company analysis and arm's length benchmarking across multiple transfer pricing methods (Cost-Plus, Resale Price, Comparable Uncontrolled Price, Profit Split, TNMM). The model captures intercompany transactions (royalties, management fees, cost sharing, goods transfers) and compares profit margins before and after transfer price adjustments to ensure compliance with OECD guidelines and local tax authorities. The workbook includes a comparable company database (identifying peers in each jurisdiction), margin analysis by transaction type, and sensitivity tables showing profit allocation impact across different transfer price assumptions. Tax exposure is quantified: the gap between the selected transfer price and a tax authority's expected arm's length range is translated into potential audit adjustment, penalties, and double-tax risk. Documentation requirements vary by jurisdiction: US Form 926, EU transfer pricing documentation, and local rules in each country are referenced. This model is essential for multinationals managing ~40% of global trade flows that occur at transfer prices. Aggressive transfer pricing optimization must be balanced against audit risk, BEPS compliance (15% minimum tax), and reputational exposure. ## What's included - Intercompany transaction matrix covering goods, services, IP, and financing - TNMM and Cost Plus benchmarking modules - Global tax jurisdiction matrix with treaty rate lookups - Royalty rate and IP licensing sensitivity analysis - Country-by-country reporting data aggregation - Intercompany transaction detail (royalties, management fees, cost sharing, goods) - Comparable company selection and margin benchmarking by jurisdiction - Transfer price methods (CUP, cost-plus, resale price, profit split, TNMM) - Profit allocation before and after transfer price adjustments - Tax exposure and audit risk assessment - Documentation requirements by jurisdiction (OECD, local, Form 926) ## Inside the Transfer Pricing Model: How Intercompany Flows and Margins Are Evaluated This transfer pricing model evaluates intercompany transactions across a three-entity multinational group, using OECD-aligned methods to test whether profit allocation between entities is defensible. It combines entity-level profit and loss statements, benchmarking against external ranges, and compliance checks for interest, intangibles, and global minimum tax rules. ### Entity Structure and Forecasting Horizon The model covers a three-entity group: a US parent and manufacturing and distribution subsidiaries in Ireland and Singapore. Each entity has its own profit and loss sheet, plus a consolidated view that eliminates intercompany items. - The time frame spans a base year of actuals followed by five forecast years, with columns for each period. Named ranges allow period selection via a simple index formula, supporting consistent calculations across all years. - This setup lets you trace how intercompany pricing decisions affect each entity’s taxable income over the forecast window, while respecting the distinct functional profiles documented in the FAR analysis. ### Intercompany Pricing and Benchmarking Logic The intercompany pricing sheet implements five OECD transfer pricing methods, with benchmarking using an interquartile range engine. - For distribution activities, the model tests a gross-margin policy target against an external range, while the transactional net margin method panel uses a net cost plus target as the tested profit level indicator when the distribution entity is selected. - A manufacturing scenario is also available, and its realised net cost plus margin is compared to the same benchmark. - This structure allows you to see whether the group’s actual pricing falls inside, above, or below the arm’s length range, and the checks sheet validates the outcome without halting calculations. ### Calculating Global Tax Positions The model computes US GILTI inclusion based on the foreign subsidiaries’ tested income, tangible assets, and covered taxes. It applies a statutory net deemed tangible income return, subtracts that from tested income, and then applies the GILTI rate, which reflects the section 250 deduction. - A deemed-paid foreign tax credit at 80 percent of foreign covered taxes offsets the gross GILTI tax. Net GILTI tax flows into the US parent’s current tax and appears on the effective tax rate walk. - Under the default high-tax foreign profile, the credit fully shields the inclusion, resulting in near-zero net GILTI tax—a directional simplification documented in the model. ### Practical Applications and Outputs This model is useful for evaluating how intercompany pricing policies affect profit allocation and tax outcomes across jurisdictions. It supports scenario testing by allowing the tested party to switch between manufacturing and distribution, and it includes a country-by-country report with capital and reserves inputs. - An APA and audit sheet collects key positions. The effective tax rate walk integrates GILTI, and a net present value line discounts cumulative tax savings versus an all-US benchmark. - Eight annual checks validate reconciliations, from intercompany eliminations to cash-tax closure. These outputs help build a defensible transfer pricing position without needing to rebuild the underlying calculations from scratch. ## Built for global tax strategy Use this model when intercompany pricing, arm's length compliance, and effective tax rate optimisation are critical to the group structure. ## Supports multiple benchmarking methods A strong transfer pricing model should calculate arm's length ranges using TNMM, Cost Plus, and CUP methods with industry-specific comparables. ## Useful for documentation and audit defence This gives you the quantitative analysis needed for annual transfer pricing reports and tax authority examinations. ## Built for global tax strategy Use this model when intercompany pricing, arm's length compliance, and effective tax rate optimisation are critical to the group structure. ## Supports multiple benchmarking methods A strong transfer pricing model should calculate arm's length ranges using TNMM, Cost Plus, and CUP methods with industry-specific comparables. ## Useful for documentation and audit defence This gives you the quantitative analysis needed for annual transfer pricing reports and tax authority examinations. ## Features - **Multi-method analysis:** Compare cost-plus, resale price, and profit split methods to identify the arm's length range and strongest defensible position. - **Comparable company benchmarking:** Use operating margin, return on assets, and other metrics from peers to establish the arm's length range of transfer prices. - **Tax audit protection:** Document the economic rationale and comparable data to defend your transfer pricing in case of audit. ## Use cases - **Annual transfer pricing documentation:** Update transfer pricing study annually with current comparables and adjust intercompany prices to remain arm's length. - **Tax optimization planning:** Analyze transfer price scenarios and repatriation strategies to minimize overall tax liability while staying within arm's length range. - **Audit defense and compliance:** Build a defensible transfer pricing position with contemporary documentation and economic analysis to minimize penalties. ## Frequently asked questions ### What is a transfer pricing model? It is a model that analyses intercompany transactions, benchmarks pricing against arm's length standards, and evaluates the impact on group effective tax rates. ### Who uses transfer pricing models? Tax directors, group controllers, transfer pricing specialists, and CFOs use them for compliance, planning, and audit defence. ### What should a transfer pricing model include? It should include an intercompany transaction matrix, benchmarking analysis, global tax rate inputs, withholding tax treatment, and country-by-country reporting outputs. ### Which transfer pricing methods does it support? The model supports OECD-recognised methods including TNMM, Cost Plus, Resale Price Method, and Comparable Uncontrolled Price for interest and royalties. ### Can it handle withholding taxes on intercompany flows? Yes. The global tax matrix includes configurable withholding tax rates for royalties, interest, and service fees, projecting net cash flows after treaty benefits. ## Related templates - [Cost Allocation Model](https://finamodel.com/templates/cost-allocation-model) - [M&A Modeling & Valuation](https://finamodel.com/templates/ma-model) - [Goodwill Impairment Testing Model](https://finamodel.com/templates/goodwill-impairment-model)