Book · Julian R. Sterling
A Practitioner's Guide to Transfer Pricing: Arm's Length Methods, Benchmarking Studies, Intercompany Agreements, Documentation and Audit Defense
March 2024. A new transfer pricing manager joins the group tax department of a privately held US maker of industrial sensors, with three affiliates abroad: two limited-risk distributors and a contract manufacturer. In the first year one distributor earns an operating margin of 0.91 percent, below the interquartile range of 2.44 percent to 4.18 percent of the group's own study; the loan to an affiliate was priced without a credit analysis; and a notice of audit arrives from abroad. This book shows the arithmetic behind each of those facts, and the file that answers them.
The Transfer Pricing Professional is a practitioner's guide to the work of the transfer pricing manager of a midsize US group, seen from the manager's own desk: the arm's length principle and section 482; the functional analysis and the characterization of each entity; the choice of method and tested party; the benchmarking study, its screens and its interquartile range, counted the way the regulation counts; the pricing policy and the year-end true-up; services, loans and licenses between affiliates; intercompany agreements; documentation and penalty protection; audits, adjustments and the mutual agreement procedure; and a decision priced over three years. One fictional group is followed over two fiscal years, and every number comes from one model; the federal rules are dated as read in November 2026.
What the record shows: why the tested party is the simplest entity, not the most profitable; why the median of a set of fourteen is the average of two results and the median of thirteen is one; why a true-up must be set by policy before the year ends; why a loan priced at the lender's own cost of funds is a finding; why a royalty is checked against the residual it should capture; and why a higher target can cost less over three years than a challenge would.
The model is supplied, not described: five companion workbooks rebuild the case by live formula, each with a Checks tab.
What you will be able to do:
Sixteen chapters in four parts and four appendices: a guide to the workbooks with seven exercises, eight working check-lists, thirty questions for interviews and committees, and a glossary of seventy-two terms.
Written for transfer pricing analysts and managers in groups and in advisory firms, tax directors who inherit the subject, controllers who invoice intercompany flows, finance directors of foreign affiliates, and students of international tax. Nothing here decides how a particular group should price, document or file. The case, its group, its people, its comparable companies and its places are fictional, and its figures are teaching assumptions, not market norms; the rules are dated as of November 2026. This book is for education only. It is not legal, tax, accounting or investment advice. Part of The Private Markets Career Guides.
How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.
Five workbooks follow Harnwick Instruments Inc., the fictional group of the case, across two fiscal years: the tested parties and the year-end true-up, the benchmark and its interquartile range, the shared services, the loan and the license, the penalty test and the year-two options. Each keeps the case’s figures in blue input cells that you overwrite with your own, guards every division against an empty divisor, and ends with a Checks tab. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in any spreadsheet program that reads .xlsx files.
Chapters 7, 8 and 9
One sheet per tested party and a summary for the parent: the result before the true-up, the target, the true-up with its direction, and what the bookings do to the parent and to group tax. Tabs: Harnwick Europe, Harnwick Asia, Harnwick Manufacturing, Summary. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 118 KBChapters 5 and 6
The accepted comparables with three years of sales and operating profit, each weighted average margin, and the quartiles found by counting, with the position used printed beside each one. Tabs: Comparables, Range. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 216 KBChapter 10
The shared services pool by category: support by headcount, engineering by hours at cost plus the markup, and what the parent keeps. Tabs: Inputs, Allocation. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 313 KBChapters 11 and 12
The case rate of an intercompany loan from a base rate and a credit spread, and the residual check of a licensed line against its royalty. Tabs: Loan, Royalty. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 413 KBChapters 14 and 16
The stress test of a filed year against the penalty thresholds, and three options for the years ahead, side by side, with sensitivity factors. All projections. Tabs: Stress Test, Options. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 516 KBAppendix B
Functional analysis interview; Benchmarking study: search, screens and rejections; Policy and true-up calendar; Intercompany agreement: clauses; Intercompany services; Intercompany loan; Documentation and local file; Preparing for an audit.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me6 KBA simplified copy of the benchmark workbook: list your accepted comparables, and it finds the interquartile range and the median by the counting rule, places your tested party and computes the true-up to the median. Get the free benchmark template.
| The median | (3.00 + 3.07) / 2 = 3.04 percent: with 14 results, 50 percent of 14 is exactly 7, so the median is the average of the 7th and 8th |
| The true-up | $3,834,430 - $3,943,155 = -$108,725: Harnwick Europe’s 2025 true-up, paid to the parent |
| The loan | $20,000,000 x (6.75 percent - 4.50 percent) = $450,000: the 2024 interest shortfall against the case rate |
The files are provided as they are, without warranty of any kind. The model is illustrative: Harnwick Instruments Inc., its affiliates, its people and the comparable companies are fictional; the sales, costs, margins, rates, probabilities and effects are the book’s assumptions, not market norms or the record of any real group. The workbooks compute; they choose no comparable, set no policy and decide no filing position, and nothing here promises any tax result. Not legal, tax, accounting or investment advice.
To read: How do you calculate the interquartile range in a transfer pricing study?
To read: Which transfer pricing method should you use?
To read: How do you set an arm's length interest rate on an intercompany loan?