ABCDEFGHIJKLMOPQRSTUVWXYZ
1
Apple Inc. (AAPL) Financial Modelling HistoricalsForecasts
2
(All data is in Millions $, Except per share information)FY 2023FY 2024FY 2025FY 2026FY 2027FY 2028FY 2029FY 2030
3
Revenue:
4
Product Net sales 298,085 294,866 307,003 317,069 327,719 338,995 350,941 363,606
5
Services Net Sales 85,200 96,169 109,158 122,257 136,928 153,359 171,762 192,374
6
Total net sales 383,285 391,035 416,161 439,326 464,647 492,354 522,704 555,980
7
8
Cost of Sales:
9
Products COGS 189,282 185,233 194,116 200,480 207,215 214,344 221,898 229,906
10
Service 24,855 25,119 26,844 30,065 33,673 37,714 42,240 47,308
11
Total COGS 214,137 210,352 220,960 230,546 240,888 252,058 264,137 277,214
12
Gross margin 169,148 180,683 195,201 208,780 223,759 240,296 258,566 278,766
13
14
Operating Expense:
15
Research and development 29,915 31,370 34,550 36,473 38,575 40,876 43,395 46,158
16
Selling, general and administrative 24,932 26,097 27,601 29,137 30,817 32,654 34,667 36,874
17
Total operational expense 54,847 57,467 62,151 65,610 69,392 73,530 78,062 83,032
18
19
Operating income 114,301 123,216 133,050 143,169 154,367 166,766 180,504 195,734
20
Other income/(expense)(565) 269 (321)#REF!#REF!#REF!#REF!#REF!
21
Income before provision for income tax
 113,736 123,485 132,729 #REF!#REF!#REF!#REF!#REF!
22
Provision for income tax 16,741 29,749 20,719 #REF!#REF!#REF!#REF!#REF!
23
Tax Rate 14.72%24.09%15.61%15.00%15.00%15.00%15.00%15.00%
24
Net income 96,995 93,736 112,010 #REF!#REF!#REF!#REF!#REF!
25
26
Earnings per share:
27
Basic6.166.117.49#REF!#REF!#REF!#REF!#REF!
28
Diluted6.136.087.46#REF!#REF!#REF!#REF!#REF!
29
30
Weighted Average No. Shares used in computing earnings per share
31
Baisc15,744,23115,343,78314,948,50014,948,50014,948,50014,948,50014,948,50014,948,500
32
Diluted15,812,54715,408,09515,004,69715,004,69715,004,69715,004,69715,004,69715,004,697
33
34
EBITDA
35
Income from Operations (EBIT) 143,169 154,367 166,766 180,504 195,734
36
Add: Depreciation and Amortization 20,580 22,898 25,496 28,251 31,180
37
Add: Stock-based Ccompensation 0 0 0 0 0
38
Adjusted EBITDA 163,749 177,265 192,262 208,755 226,914
39
37.27%38.15%39.05%39.94%40.81%
40
Other Income/(Expense), Net
41
Interest and dividend income3750 4202 3391
42
Interest Expense(3933)(2931)(2070)
43
Other Income/(Expense), Net(382)(1002)(1642)
44
Total other Income/(Expense), Net(565)269 (321)
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