ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LINKWELL | Amazon Last-Mile Delivery Case Study — Phase 2: Raw Data
2
Blue = hardcoded inputs (sourced from 10-K / public filings) | Black = formulas | All figures in $B unless stated
3
4
A — INCOME STATEMENT ($B) | Source: Amazon SEC 10-K FY2019–FY2024
5
FY2019FY2020FY2021FY2022FY2023FY2024Source
6
Total Revenue ($B)280.5386.1469.8513.9574.8638.0Amazon 10-K
7
Cost of Sales ($B)165.5233.3272.3288.8304.7325.9Amazon 10-K
8
Gross Profit ($B)115.0152.8197.5225.1270.1312.1Calculated
9
Gross Margin %41.0%39.6%42.0%43.8%47.0%48.9%Calculated
10
Shipping Costs ($B)37.961.176.783.589.595.9Amazon 10-K (CoS note)
11
Fulfillment Costs ($B)40.258.575.184.390.697.0Amazon 10-K
12
Total Ship + Fulfil ($B)78.1119.6151.8167.8180.1192.9Calculated
13
Operating Income ($B)14.522.924.9-2.436.968.6Amazon 10-K
14
Net Income ($B)11.621.333.4-2.730.459.2Amazon 10-K
15
16
17
B — SHIPPING COST ANALYSIS | Source: Amazon 10-K + Calculated
18
FY2019FY2020FY2021FY2022FY2023FY2024Formula / Source
19
Shipping Costs ($B)37.961.176.783.589.595.9Income Statement C11
20
Shipping as % Revenue13.5%15.8%16.3%16.2%15.6%15.0%Shipping/Revenue
21
Fulfillment Costs ($B)40.258.575.184.390.697.0Income Statement C12
22
Ship + Fulfil ($B)78.1119.6151.8167.8180.1192.9178.1
23
Ship + Fulfil as % Rev27.8%31.0%32.3%32.7%31.3%30.2%Ship+Fulfil/Revenue
24
YoY Shipping Growth--61.2%25.5%8.9%7.2%7.2%Calculated
25
Cost/Package (est. $)$22,294.12$24,440.00$21,914.29$17,395.83$15,169.49$14,313.43Shipping*1000/Volume
26
27
SOURCES: Amazon 10-K filings FY2019-FY2024 via SEC EDGAR (https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0001018724&type=10-K) | ShipMatrix US Parcel Index | Pitney Bowes Parcel Shipping Index
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100