Discounted Cash Flow (DCF) Analysis Unlevered

Alphabet Inc

Alphabet Inc (GOOGL)

$1458.66
19.6 (+1.36%)

Operating Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 55,519.0066,001.0074,989.0090,272.00110,855.00136,819.00161,857.00193,527.31231,394.51276,671.12330,806.94395,535.43
Revenue (%)
EBITDA 19,716.0023,339.0024,818.0030,418.0024,393.0044,062.0051,506.0061,844.7373,945.8088,414.66105,714.62126,399.64
EBITDA (%)
EBIT 15,777.0018,360.0019,755.0024,274.0017,478.0035,027.0039,725.0048,486.7657,974.0969,317.8082,881.1099,098.32
EBIT (%)
Depreciation 3,939.004,979.005,063.006,144.006,915.009,035.0011,781.0013,357.9715,971.7119,096.8622,833.5227,301.32
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Total Cash 58,717.0064,395.0073,066.0086,333.00101,871.00109,140.00119,675.00177,493.05212,222.85253,748.17303,398.69362,764.25
Total Cash (%)
Account Receivables 9,390.0010,849.0013,909.0014,232.0018,705.0021,193.0027,492.0032,350.3238,680.2646,248.7655,298.1966,118.30
Account Receivables (%)
Inventories ------------
Inventories (%)
Accounts Payable 2,453.001,715.001,931.002,041.003,137.004,378.005,561.005,893.787,047.018,425.8910,074.5712,045.84
Accounts Payable (%)
Capital Expenditure -7,358.00-11,014.00-9,950.00-10,212.00-13,184.00-25,139.00-23,548.00-27,463.57-32,837.33-39,262.56-46,945.00-56,130.66
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 1,458.66
Beta 1.108
Diluted Shares Outstanding 698.56
Cost of Debt
Tax Rate 13.33
After-tax Cost of Debt 4.33%
Risk-Free Rate
Market Risk Premium
Cost of Equity 11.278
Total Debt 4,554.00
Total Equity 1,018,955.69
Total Capital 1,023,509.69
Debt Weighting 0.44
Equity Weighting 99.56
Wacc

Build Up Free Cash

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 55,519.0066,001.0074,989.0090,272.00110,855.00136,819.00161,857.00193,527.31231,394.51276,671.12330,806.94395,535.43
EBITDA 19,716.0023,339.0024,818.0030,418.0024,393.0044,062.0051,506.0061,844.7373,945.8088,414.66105,714.62126,399.64
EBIT 15,777.0018,360.0019,755.0024,274.0017,478.0035,027.0039,725.0048,486.7657,974.0969,317.8082,881.1099,098.32
Tax Rate 19.91%18.09%16.81%19.35%53.44%11.96%13.33%21.84%21.84%21.84%21.84%21.84%
EBIAT 12,635.2915,037.7716,434.5219,578.018,138.3630,836.3634,429.6737,896.3745,311.5054,177.5364,778.3777,453.45
Depreciation 3,939.004,979.005,063.006,144.006,915.009,035.0011,781.0013,357.9715,971.7119,096.8622,833.5227,301.32
Accounts Receivable --1,459.00-3,060.00-323.00-4,473.00-2,488.00-6,299.00-4,858.32-6,329.94-7,568.51-9,049.43-10,820.11
Inventories ------------
Accounts Payable --738.00216.00110.001,096.001,241.001,183.00332.781,153.231,378.881,648.681,971.28
Capital Expenditure -7,358.00-11,014.00-9,950.00-10,212.00-13,184.00-25,139.00-23,548.00-27,463.57-32,837.33-39,262.56-46,945.00-56,130.66
UFCF 9,216.296,805.778,703.5215,297.01-1,507.6413,485.3617,546.6719,265.2323,269.1627,822.2133,266.1439,775.27
WACC
PV UFCF 17,317.0618,800.9920,206.5221,717.1223,340.65
SUM PV UFCF 101,382.35

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 11.25
Free cash flow (t + 1) 41,366.28
Terminal Value 570,569.39
Present Value of Terminal Value 334,817.67

Intrinsic Value

Enterprise Value 436,200.02
Net Debt -13,944.00
Equity Value 450,144.02
Shares Outstanding 698.56
Equity Value Per Share 644.39