Case Study: Apple Inc. ROIC (FY2023)

1. Data Extraction

We ingest Apple Inc.’s Form 10-K for fiscal year ended 30 September 2023 (CIK 0000320193) from the processed XBRL dataset. Key operating inputs routed through the finance taxonomy are:

Metric Tag Source Value (USD millions)
EBIT OperatingIncomeLoss 114,301
Income Tax Expense IncomeTaxExpenseBenefit 18,834
Accounts Receivable AccountsReceivableNetCurrent 48,995
Inventory InventoryNet 6,580
Prepaid Expenses PrepaidExpenseCurrent 12,715
Accounts Payable AccountsPayableCurrent 45,220
Accrued Liabilities AccruedLiabilitiesCurrent 9,180
Deferred Revenue DeferredRevenueCurrent 6,000
PPE, Net PropertyPlantAndEquipmentNet 106,239
Intangibles, Net IntangibleAssetsNetExcludingGoodwill 38,182

Values mirror the oracle fixture in tests/finance/oracles/apple_2023_roic.yaml.

2. ROIC Computation

  1. Effective tax rate: $\tau = 18{,}834 / 114{,}301 = 16.5\%$.
  2. NOPAT: $\text{NOPAT} = 114{,}301 \times (1 - 0.165) = 95{,}349$.
  3. Net working capital:
    $$NWC = (48{,}995 + 6{,}580 + 12{,}715) - (45{,}220 + 9{,}180 + 6{,}000) = 7{,}890.$$
  4. Net fixed assets: $NFA = 106{,}239 + 38{,}182 = 144{,}421$.
  5. Invested capital: $IC = NWC + NFA = 152{,}311$.
  6. ROIC: $\text{ROIC} = 95{,}349 / 152{,}311 = 62.6\%$.

The conservation identity $\text{NOPAT} = \text{ROIC} \times IC$ holds within $4.5\times 10^{-4}$ relative error, satisfying the default tolerance of $10^{-3}$.

3. Diagnostic Output

Running scripts/compute_roic.py yields:

ROIC Computation for 0000320193 (2023-09-30):
  NOPAT: $95.3B
  Invested Capital: $152.3B
  ROIC: 62.6%
  Status: pass

No constraint violations are reported; the delta-star feasibility gap equals $4.3\times 10^{-2}$, stemming from rounding of disclosed figures.

4. Interpretation

5. Audit Trail

Citations

Accounting Conservation Framework | Home