Mapping Intercompany Transactions: Who Sells What to Whom
This lesson is part of the course
In this lesson
You map the 2026 intercompany transactions of the fictional Aurora Optics group with SUMIFS: what each entity sells and buys inside the group, and its net position.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Mapping Intercompany Transactions: Who Sells What to Whom Locked
- The Cost Plus Method: Mark-up on the Cost Base Locked
- The Resale Price Method: Working Back from the Gross Margin Locked
- TNMM: Operating Margin, Net Cost Plus & Berry Ratio Locked
- The Comparables Set & the Interquartile Range Locked
- Testing the Result & Adjusting to the Median Locked
- Intercompany Services & Management Fees: Allocation Keys Locked
- Year-End True-Up & Its Effect on Each Entity's Profit Locked