← 返回 Tessera
加工15 行 × 4 列1 KB无缺失数据 2026-09-02

apple_revenue_flow

Apple fiscal 2025 third-quarter revenue, costs, expenses and profit arranged as a balanced Sankey edge table.

One row represents one financial flow between two reported or derived statement nodes.

Apple · 收录于 2026-09-02

下载 CSV · 1 KB
数据预览前 6 行
sourcetargetvalue_musdstage
iPhoneProducts44,582Revenue sources
MacProducts8,046Revenue sources
iPadProducts6,581Revenue sources
Wearables & accessoriesProducts7,404Revenue sources
ProductsNet sales66,613Revenue sources
ServicesNet sales27,423Revenue sources
变量4 列
字符型3整数1
类型
#变量类型缺失统计
1sourceNode from which the financial amount flows.字符型—不同值 10Gross margin · Net sales · Operating income · Pretax income · iPhone · Mac · iPad · Wearables & accessories
2targetNode receiving the financial amount.字符型—不同值 11Products · Net sales · Cost of sales · Gross margin · R&D · SG&A · Operating income · Other expense
3value_musdkeyAmount in millions of US dollars.整数—min 171.0q1 —中位 23,434均值 23,642q3 —max 66,613
4stageBroad statement stage used to organize and audit the edge table.字符型—不同值 4Revenue sources · Below operating income · Operating expenses · Cost of sales
载入已写好列类型
library(readr)

apple_revenue_flow <- read_csv(
  "https://assets.evanzhou.org/tessera/csv/apple_revenue_flow.csv",
  col_types = cols(
    source     = col_character(),
    target     = col_character(),
    value_musd = col_integer(),
    stage      = col_character()
  )
)
URLhttps://assets.evanzhou.org/tessera/csv/apple_revenue_flow.csv

Source

Apple Inc. fiscal 2025 third-quarter results for the three months ended June 28, 2025, adapted from the Form 10-Q filed with the US SEC.

The filing reports product and service net sales, product-category net sales, cost of sales, operating expenses, operating income, other expense, income before taxes, provision for income taxes and net income. Tessera reshapes those reported values into a balanced source–target edge table; it does not estimate or simulate any amount.

Use cases

  • Revenue and profit Sankey diagrams
  • Auditing whether each internal financial node balances
  • Demonstrating convergence followed by successive cost and expense splits
生成脚本R · 41 行
# Generate the adapted edge table used by the Apple revenue Sankey recipe.
script_dir <- local({
  arg <- grep("^--file=", commandArgs(trailingOnly = FALSE), value = TRUE)
  path <- if (length(arg)) sub("^--file=", "", arg[[1L]]) else sys.frame(1)$ofile
  dirname(normalizePath(path, mustWork = TRUE))
})
out_csv <- file.path(script_dir, "..", "csv", "apple_revenue_flow.csv")
dir.create(dirname(out_csv), recursive = TRUE, showWarnings = FALSE)

apple_revenue_flow <- data.frame(
  source = c(
    "iPhone", "Mac", "iPad", "Wearables & accessories", "Products", "Services",
    "Net sales", "Net sales", "Gross margin", "Gross margin", "Gross margin",
    "Operating income", "Operating income", "Pretax income", "Pretax income"
  ),
  target = c(
    "Products", "Products", "Products", "Products", "Net sales", "Net sales",
    "Cost of sales", "Gross margin", "R&D", "SG&A", "Operating income",
    "Other expense", "Pretax income", "Income taxes", "Net income"
  ),
  value_musd = c(
    44582, 8046, 6581, 7404, 66613, 27423, 50318, 43718,
    8866, 6650, 28202, 171, 28031, 4597, 23434
  ),
  stage = c(
    rep("Revenue sources", 6), rep("Cost of sales", 2),
    rep("Operating expenses", 3), rep("Below operating income", 4)
  ),
  stringsAsFactors = FALSE
)

stopifnot(
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$target == "Products"]) == 66613,
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$target == "Net sales"]) == 94036,
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$source == "Net sales"]) == 94036,
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$source == "Gross margin"]) == 43718,
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$source == "Operating income"]) == 28202,
  sum(apple_revenue_flow$value_musd[apple_revenue_flow$source == "Pretax income"]) == 28031
)

write.csv(apple_revenue_flow, out_csv, row.names = FALSE)

表中统计由 scripts/profile_dataset.py 于 2026-09-02 数出。