TP Workbench - Seg. P&L

UPDATED: iCloud OTP Project file (March 8, 2026)

Main

Imported entity and fiscal year combinations from the current bridge file.

Entity Name	Fiscal Year
No bridge file imported yet.

Cash Tax Impact from Proposed TP Adjustments

Tariff-Driven Share of COGS TP Adjustment (%) Tariff rate Differential Cash Tax Rate (%) BEAT Rate (%)

Distributor	COGS TP Adjustment	Service Adjustment	Tariff-Driven COGS TP Adjustment	Tariff Cash Tax Impact	COGS TP Cash Tax Impact	BEAT Tax Impact
No bridge file imported yet.

Transfer Price Analyzer

Baseline transfer prices are sourced from IC Sales Detail (column K). Required transfer prices reflect the COGS TP adjustment % by supplier/distributor.

Distributor	Supplier	SKU	Baseline Transfer Price	COGS TP Adjustment %	Required Transfer Price
No IC Sales Detail transfer prices imported yet.

Fiscal Year

Quarter

Quarter View Basis

Entity Inputs

Entity Name Input Currency Reporting Currency FX Rate (Input to Reporting) Revenue Total COGS (from segments) Indirect OPEX Pool Total Direct OPEX (from segments) Total OPEX Total Entity Operating Profit Total Entity EBIT Margin

Bridge File

Tested Party Segmented P&L (Unadjusted)

Segment Classification	Revenue	COGS	Direct OPEX	Indirect OPEX (Allocated)	Total OPEX	Unadjusted Operating Profit

P&L Segmentation

Segment Classification	Segment Type	Revenue	Current COGS	Direct OPEX	Indirect OPEX (Allocated)	Total OPEX	PLI	Target Value	Adjustment Account

Operational TP Controls (Phase 1)

Materiality Threshold (USD)

Interquartile Ranges

Metric	Q1 (25th Percentile)	Median (50th Percentile)	Q3 (75th Percentile)
ROS
Berry Ratio
Contract R&D NCP
Contract Manufacturing NCP

Adjusted P&L

Segment Classification	Allocated Revenue	Current COGS	Direct OPEX	Indirect OPEX (Allocated)	Total OPEX	EBIT (Before)	Target Profitability	Target EBIT	TP Adjustment	COGS (After)	EBIT (After)

TP Adjustment Entries Summary

COGS Adjustments

IP Owner	LRD COGS Debit	LRD COGS Credit	IP Owner Debit	IP Owner Credit	Net TP Adjustment

Services Adjustments

Service Provider	Service Provider Debit	Service Provider Credit	IP Owner Debit	IP Owner Credit	Net TP Adjustment

Post TP Adjustments Total Entity Summary

Closed Period Records

Period	Status	Closed At	Closed By	Reason	Record ID	Action

Audit Trail

Audit Year Hide Timestamps

Timestamp	Period	Action	Details

Supply Chain Visualizer

Supplier and service-provider flows into each distributor based on imported BridgeTemplate data.

Supplier -> Distributor Network

Service Provider -> Distributor Network

Post-Adjustment Flow Values

Suppliers

Distributors

Service Providers

Supplier to Distributor Flows

Supplier	Distributor	Base Amount
No bridge file imported yet.

Service Provider to Distributor Flows

Service Provider	Distributor	Base Amount
No bridge file imported yet.

Post-Adjustment Values (Current Distributor)

Type	Entity	Distributor	Before	Adjustment	After
Run calculation to view post-adjustment values.

TP Workbench - Corporate Services Allocation

Service Entity Total Corporate Services Pool

Allocation Matrix

Recipient Entity	Allocation Key %	Allocated Services Amount

Allocation Summary

Total Allocation Key %

0.00%

Total Allocated Amount

Unallocated / Overallocated