Francesco Laconi EQUITY RESEARCH
FINANCIAL MODEL

Alphabet Inc.

GOOG · 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
Revenue74,98990,272110,855136,819161,857182,527257,637282,836307,394350,018402,836
Cost of Goods Sold28,16435,13845,58359,54971,89684,732110,939126,203133,332146,306162,535
Gross Profit
SG&A15,18317,47019,76524,45928,01528,99836,42242,29144,34241,99650,175
R&D12,28213,94816,62521,41926,01827,57331,56239,50045,42749,32661,087
EBITDA
D&A5,0636,1446,9159,03511,78113,69712,44115,92811,94615,31121,136
EBIT (Operating Income)19,36023,71626,14626,32134,23141,22478,71474,84284,293112,390129,039
Interest Expense104124109114100135346357308268736
Pre-Tax Income19,65124,15027,19334,91339,62548,08290,73471,32885,717119,815158,826
Tax Expense3,3034,67214,5314,1775,2827,81314,70111,35611,92219,69726,656
Net Income16,34819,47812,66230,73634,34340,26976,03359,97273,795100,118132,170
Diluted EPS22.8427.8518.0043.7049.1658.61112.204.565.808.0410.81
Diluted Shares (M)692.9698.7703.6703.3698.6687.0677.713,159.012,722.012,447.012,230.0
Balance Sheet
Total Cash & Equivalents16,54912,91810,71516,70118,49826,46520,94521,87924,04823,46630,708
Short-term Debt00001151,1001132981,3633,2991,996
Long-term Debt03,9353,9694,0124,55413,93214,81714,70113,25310,88346,547
Total Debt
Net Debt
Total Current Assets105,408124,308135,676152,578174,296188,143164,795171,530163,711206,038
Total Current Liabilities16,75624,18334,62045,22156,83464,25469,30081,81489,122102,745
Total Assets167,497197,295232,792275,909319,616359,268365,264402,392450,256595,281
Total Liabilities28,46144,79355,16474,46797,072107,633109,120119,013125,172180,016
Shareholders' Equity120,331139,036152,502177,628201,442222,544251,635256,144283,379325,084415,265
Minority Interest
Intangibles & Goodwill16,46816,74717,88820,62421,17522,95628,96029,19831,88533,380
PP&E34,23442,38359,71973,64684,74997,599112,668134,345171,036246,597
Receivables14,13718,33620,83825,32630,93039,30440,25847,96452,34062,886
Payables2,0413,1374,3785,5615,5896,0375,1287,4937,98712,200
Inventory2687491,1079997281,1702,670
Retained Earnings89,223105,131113,247134,885152,122163,401191,484195,563211,247245,084324,055
Cash Flow
Cash from Operations26,57236,03637,09147,97154,52065,12491,65291,495101,746125,299164,713
Capital Expenditures9,95010,21213,18425,13923,54822,28124,64031,48532,25152,53591,447
Free Cash Flow
Stock-Based Compensation5,2036,7037,6799,35310,79412,99115,37619,36222,46022,78524,953
Dividends Paid007,36310,049
Share Repurchases1,7803,6934,8469,07518,39631,14950,27459,29661,50462,22245,709