Francesco Laconi EQUITY RESEARCH
FINANCIAL MODEL

Apple Inc.

AAPL · all figures in $M unless noted
burgundy figures open the exact filing page they were verified against · green figures are computed — click for the formula
FY2015FY2016FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025
Income Statement
Revenue233,715215,639229,234265,595260,174274,515365,817394,328383,285391,035416,161
Cost of Goods Sold131,376141,048163,756161,782169,559212,981223,546214,137210,352220,960
Gross Profit
SG&A14,19415,26116,70518,24519,91621,97325,09424,93226,09727,601
R&D10,04511,58114,23616,21718,75221,91426,25129,91531,37034,550
EBITDA
D&A10,50510,15710,90312,54711,05611,28411,10411,51911,44511,698
EBIT (Operating Income)60,02461,34470,89863,93066,288108,949119,437114,301123,216133,050
Interest Expense1,4562,3233,2403,5762,8732,6452,9313,933
Pre-Tax Income61,37264,08972,90365,73767,091109,207119,103113,736123,485132,729
Tax Expense15,68515,73813,37210,4819,68014,52719,30016,74129,74920,719
Net Income53,39445,68748,35159,53155,25657,41194,68099,80396,99593,736112,010
Diluted EPS9.228.319.2111.9111.893.285.616.116.136.087.46
Diluted Shares (M)5,793.15,500.35,251.75,000.14,648.917,528.216,864.916,325.815,812.515,408.115,004.7
Balance Sheet
Total Cash & Equivalents20,28925,91348,84438,01634,94023,64629,96529,94335,934
Short-term Debt18,47320,74816,24013,76915,61321,11015,80720,87920,329
Long-term Debt53,32975,42797,20793,73591,80798,667109,10698,95995,28185,75078,328
Total Debt
Net Debt
Total Current Assets128,645131,339162,819143,713134,836135,405143,566152,987147,957
Total Current Liabilities100,814116,866105,718105,392125,481153,982145,308176,392165,631
Total Assets290,345321,686375,319365,725338,516323,888351,002352,755352,583364,980359,241
Total Liabilities193,437241,272258,578248,028258,549287,912302,083290,437308,030285,508
Shareholders' Equity128,249134,047107,14790,48865,33963,09050,67262,14656,95073,733
Minority Interest00
Intangibles & Goodwill
PP&E33,78341,30437,37836,76639,44042,11743,71545,68049,834
Receivables17,87423,18622,92616,12026,27828,18429,50833,41039,777
Payables44,24255,88846,23642,29654,76364,11562,61168,96069,860
Inventory4,8553,9564,1064,0616,5804,9466,3317,2865,718
Retained Earnings96,36498,33070,40045,89814,9665,562-3,068-214-19,154-14,264
Cash Flow
Cash from Operations66,23164,22577,43469,39180,674104,038122,151110,543118,254111,482
Capital Expenditures12,73412,45113,31310,4957,30911,08510,70810,9599,44712,715
Free Cash Flow
Stock-Based Compensation4,2104,8405,3406,0686,8297,9069,03810,83311,68812,863
Dividends Paid12,15012,76913,71214,11914,08114,46714,84115,02515,23415,421
Share Repurchases29,72232,90072,73866,89772,35885,97189,40277,55094,94990,711