Discounted Cash Flow (DCF) Analysis Unlevered

Chevron Corporation (CVX)

$157.91

+1.85 (+1.19%)
All numbers are in Millions, Currency in USD
Stock DCF: 484.83 | 157.91 | undervalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 158,902139,86594,471155,606235,717278,004.80327,879.07386,700.81456,075.22537,895.45
Revenue (%)
EBITDA 40,70635,63113,80640,33066,85266,713.0878,681.4692,796.97109,444.81129,079.29
EBITDA (%)
EBIT 21,2876,413-5,70222,40550,53326,567.4031,333.6136,954.8843,584.6151,403.73
EBIT (%)
Depreciation 19,41929,21819,50817,92516,31940,145.6847,347.8555,842.0965,860.2077,675.57
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 10,3455,7495,6275,67517,90115,467.2618,242.0921,514.7425,374.5029,926.70
Total Cash (%)
Account Receivables 15,05013,32511,47118,41920,45628,721.1233,873.7039,950.6747,117.8555,570.83
Account Receivables (%)
Inventories 5,7045,8485,6766,3058,24711,859.4613,987.0516,496.3419,455.7922,946.18
Inventories (%)
Accounts Payable 13,95314,10310,95016,45418,95527,283.7232,178.4537,951.2844,759.7752,789.70
Accounts Payable (%)
Capital Expenditure -13,792-14,116-8,922-8,056-11,974-21,391.54-25,229.19-29,755.33-35,093.46-41,389.25
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 157.91
Beta 1.148
Diluted Shares Outstanding 1,870.03
Cost of Debt
Tax Rate 28.60
After-tax Cost of Debt 1.58%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.930
Total Debt 23,339
Total Equity 295,295.96
Total Capital 318,634.96
Debt Weighting 7.32
Equity Weighting 92.68
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 158,902139,86594,471155,606235,717278,004.80327,879.07386,700.81456,075.22537,895.45
EBITDA 40,70635,63113,80640,33066,85266,713.0878,681.4692,796.97109,444.81129,079.29
EBIT 21,2876,413-5,70222,40550,53326,567.4031,333.6136,954.8843,584.6151,403.73
Tax Rate 27.95%47.18%25.63%27.79%28.60%31.43%31.43%31.43%31.43%31.43%
EBIAT 15,336.993,387.21-4,240.7316,178.1136,078.2918,216.8621,484.9825,339.4029,885.3035,246.75
Depreciation 19,41929,21819,50817,92516,31940,145.6847,347.8555,842.0965,860.2077,675.57
Accounts Receivable -1,7251,854-6,948-2,037-8,265.12-5,152.59-6,076.97-7,167.18-8,452.98
Inventories --144172-629-1,942-3,612.46-2,127.60-2,509.29-2,959.46-3,490.38
Accounts Payable -150-3,1535,5042,5018,328.724,894.725,772.846,808.498,029.94
Capital Expenditure -13,792-14,116-8,922-8,056-11,974-21,391.54-25,229.19-29,755.33-35,093.46-41,389.25
UFCF 20,963.9920,220.215,218.2723,974.1138,945.2933,422.1641,218.1748,612.7457,333.9067,619.64
WACC
PV UFCF 30,835.0935,084.0938,175.3041,538.8645,198.79
SUM PV UFCF 190,832.13

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.39
Free cash flow (t + 1) 68,972.03
Terminal Value 1,079,374.56
Present Value of Terminal Value 721,482.99

Intrinsic Value

Enterprise Value 912,315.12
Net Debt 5,661
Equity Value 906,654.12
Shares Outstanding 1,870.03
Equity Value Per Share 484.83