Book · Julian R. Sterling

The Transfer Pricing Professional

A Practitioner's Guide to Transfer Pricing: Arm's Length Methods, Benchmarking Studies, Intercompany Agreements, Documentation and Audit Defense

About the book

Cover of The Transfer Pricing Professional

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.

What is inside

The companion files

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 five workbooks, the toolkit and the read-me, in one archive114 KB

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.

Free template

A 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.

Three numbers to reproduce first

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.

Read first

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?

Also by Julian R. Sterling