Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


Alphabet Inc.

Alphabet Inc. (GOOG)

Technology

Operating Data

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 66,001.0074,990.3490,273.37110,855.69136,818.10164,263.81197,215.13236,776.48284,273.85341,299.18
Revenue (%)
EBITDA 22,341.3424,814.3030,422.1234,221.1544,055.4353,779.9764,568.2377,520.6293,071.26111,741.35
EBITDA (%)
EBIT 17,364.8619,752.4524,274.5127,303.7635,025.4342,626.4651,177.3361,443.5073,769.0688,567.14
EBIT (%)
Depreciation 4,976.485,061.856,147.626,917.409,029.9911,153.5113,390.9116,077.1219,302.1923,174.21
Depreciation (%)

Balance Sheet Data

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 46,048.9056,520.2273,419.3391,156.6492,434.31123,608.52148,404.38178,174.30213,916.07256,827.63
Total Cash (%)
Account Receivables 9,385.3411,556.0114,136.8118,335.5320,837.4025,313.0530,390.8536,487.2643,806.6052,594.20
Account Receivables (%)
Inventories --270.82753.821,108.23969.161,163.571,396.981,677.222,013.67
Inventories (%)
Accounts Payable 1,716.031,927.252,040.183,137.224,378.184,418.705,305.096,369.297,646.979,180.95
Accounts Payable (%)
Capital Expenditure -15,846.84-10,153.69-11,193.90-13,468.97-26,624.80-26,791.43-32,165.79-38,618.24-46,365.06-55,665.90
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 1,169.3
Diluted Shares Outstanding 750.00
Cost of Debt
Tax Rate 11.96
After-tax Cost of Debt -0.55
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.86
Total Debt 3,950.00
Total Equity 876,975.00
Total Capital 880,925.00
Debt Weighting 0.45
Equity Weighting 99.55
Wacc

Build Up Free Cash

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 66,001.0074,990.3490,273.37110,855.69136,818.10164,263.81197,215.13236,776.48284,273.85341,299.18
EBITDA 22,341.3424,814.3030,422.1234,221.1544,055.4353,779.9764,568.2377,520.6293,071.26111,741.35
EBIT 17,364.8619,752.4524,274.5127,303.7635,025.4342,626.4651,177.3361,443.5073,769.0688,567.14
Tax Rate 16.31%16.81%19.35%53.44%11.96%23.57%23.57%23.57%23.57%23.57%
EBIAT 14,532.6016,432.4019,578.4212,713.5730,834.9832,578.1339,113.3046,959.4356,379.4967,689.21
Depreciation 4,976.485,061.856,147.626,917.409,029.9911,153.5113,390.9116,077.1219,302.1923,174.21
Accounts Receivable --2,170.67-2,580.80-4,198.72-2,501.86-4,475.66-5,077.80-6,096.40-7,319.34-8,787.60
Inventories ----483.00-354.41139.07-194.41-233.41-280.23-336.45
Accounts Payable -211.23112.931,097.041,240.9640.52886.391,064.201,277.681,533.98
Capital Expenditure --5,693.151,040.212,275.0713,155.83166.635,374.366,452.467,746.829,300.83
UFCF 19,509.0713,841.6624,298.3718,321.3551,405.5039,602.2053,492.7564,223.3977,106.6092,574.19
WACC
PV UFCF 39,602.2048,261.2352,275.7456,624.1961,334.36
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 10.84
Free cash flow (t + 1) 96,277.15
Terminal Value 1,407,560.73
Present Value of Terminal Value 841,365.22

Intrinsic Value

Enterprise Value -
Net Debt -88,484.31
Equity Value -
Shares Outstanding 750.00
Equity Value Per Share -